message = {
    "text": "Stock levels are below threshold !",
    "channel": "logistics",
    "username": "Peliqan bot"
}

conn = pq.connect('Slack')
result = conn.add('message', message)
st.json(result) # for debugging only, see result of sending message to Slack

email = {
    "from": "no-reply@acme.com",
    "to": "john@acme.com",
    "subject": "Here is your weekly report",
    "text": "We are happy to provide you with this report !",
    "html": "We are <b>happy</b> to provide you with this report !"
}

conn = pq.connect('Postmark')
result = conn.add('email', email)
st.json(result) # for debugging only, see result of sending email to Postmark

import json

dbconn = pq.dbconnect(pq.DW_NAME)
query = "SELECT id, name FROM my_schema.my_table"
df = dbconn.fetch(pq.DW_NAME, query = query, df = True)

# more info: https://pandas.pydata.org/docs/reference/api/pandas.DataFrame.to_html.html
html = df.to_html(col_space = 50, border = 0, justify = "left")

email = {
    "from": "no-reply@acme.com",
    "to": "john@acme.com",
    "subject": "Your data",
    "html": "Here is your data: <br><br>" + json.dumps(html).strip('"')
}

conn = pq.connect('Postmark')
result = conn.add('email', email)
st.json(result) # for debugging only, see result of sending email to Postmark

import base64

text_file_content = "This will be in the attached text file."

email = {
    "from": "no-reply@acme.com",
    "to": "john@acme.com",
    "subject": "Test email with attachment",
    "text": "See Text file attached.",
    "html": "See Text file attached.",
    "attachment_name": "my_file.txt",
    "attachment_content_base64": base64.b64encode(text_file_content.encode("ascii")).decode("ascii"),
    "attachment_contenttype": "text/plain"
}

conn = pq.connect('Postmark')
result = conn.add('email_with_attachment', email)
st.json(result) # for debugging only, see result of sending email to Postmark

import base64

dbconn = pq.dbconnect(PQ.DW_NAME)
query = "SELECT id, name FROM pipedrive.organizations"
df = dbconn.fetch(PQ.DW_NAME, query = query, df = True)

csv = "index" + df.to_csv()
st.text(csv) # optional, show CSV on screen

email_server = pq.connect('Postmark')
email = {
    "from": "no-reply@acme.com",
    "to": "john@acme.com",
    "subject": "Test email with attachment",
    "text": "See CSV file attached.",
    "html": "See CSV file attached.",
    "attachment_name": "data.csv",
    "attachment_content_base64": base64.b64encode(csv.encode("ascii")).decode("ascii"),
    "attachment_contenttype": "text/csv"
}
result = email_server.add('email_with_attachment', email)
st.json(result) # optional, show result of sending the email