How to send myself an email notification when a suds job is done?

Question

I'm learning to use suds in a python script to send SQL queries to a database. I'd like to able to send myself an email when the query job is finished (it has a job ID so I'm able to check its status). How do I do that?

Answer 1

This is how you send an email via python just fill in the blanks and input it to your code:

import smtplib

content = ("Content to send")

mail = smtplib.SMTP('smtp.gmail.com',587)

mail.ehlo()

mail.starttls()

mail.login('[email protected]','123your_password')

mail.sendmail('[email protected]','[email protected]',content) 

mail.close()

print("Sent")

(you dont have to use gmail as most addresses will still work through the gmail smtp)

Answer 2

I just wrote a Python decorator for this purpose. You can realize it in one line.

https://github.com/Wenzhi-Ding/py_reminder

from py_reminder import monitor

@monitor('SQL Query of xxx')
def query(sql):
    ...send your query...

query()

Once this function finishes / or is caught an error, you will get an email notification with some brief information.

Answer 3

If email is not required, you can also send chat messages to yourself.

Two projects achieving this :

• Nimrod, for Facebook Messenger : https://www.nimrod-messenger.io/
• Telegram Middleman, for Telegram : https://github.com/n1try/telegram-middleman-bot