diff options
Diffstat (limited to 'python/scotia_monitor.py')
| -rw-r--r-- | python/scotia_monitor.py | 26 |
1 files changed, 0 insertions, 26 deletions
diff --git a/python/scotia_monitor.py b/python/scotia_monitor.py deleted file mode 100644 index 93e39b9e..00000000 --- a/python/scotia_monitor.py +++ /dev/null @@ -1,26 +0,0 @@ -import datetime -import logging -from serenitas.analytics.dates import prev_business_day -from serenitas.utils.db import dbconn -from serenitas.utils.exchange import ExchangeMessage -from report_ops.utils import EmailOps - -if __name__ == "__main__": - import argparse - - parser = argparse.ArgumentParser() - parser.add_argument( - "cob", - nargs="?", - type=datetime.date.fromisoformat, - default=prev_business_day(datetime.date.today()), - help="working date", - ) - args = parser.parse_args() - logger = logging.getLogger(__name__) - conn = dbconn("dawndb") - sql_str = "SELECT * FROM cash_balances cb WHERE fund='ISOSEL' AND account_number = '476960681512' AND date=%s;" - with conn.cursor() as c: - c.execute(sql_str, (args.cob,)) - if not (cash_balance := c.fetchone()): - EmailOps.email_boston(args.cob) |
