diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/bondallocation_email.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/bondallocation_email.py b/python/bondallocation_email.py index 2eca012c..8061e7bb 100644 --- a/python/bondallocation_email.py +++ b/python/bondallocation_email.py @@ -1,4 +1,4 @@ -from serenitas.utils.db import dbconn +from serenitas.utils.db import dawn_engine, dbconn from serenitas.utils.exchange import ExchangeMessage, FileAttachment from exchangelib import HTMLBody import pandas as pd @@ -27,7 +27,7 @@ if __name__ == "__main__": df = pd.read_sql_query( "SELECT bonds.id as tradeid, trade_date, settle_date, CASE WHEN buysell THEN 'Buy' ELSE 'Sell' end as buysell, identifier, description , faceamount AS notional, price, accrued, principal_payment + accrued_payment as net_amount, name as counterparty, allocation_contacts FROM bonds LEFT JOIN counterparties on cp_code=code WHERE trade_date >= %s and not EMAILED and allocated;", - con=dawndb, + con=dawn_engine, params=(args.trade_date,), ) with dawndb.cursor() as d: |