diff options
Diffstat (limited to 'python/otc_fx.py')
| -rw-r--r-- | python/otc_fx.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/python/otc_fx.py b/python/otc_fx.py index 870cf1be..1608b6a8 100644 --- a/python/otc_fx.py +++ b/python/otc_fx.py @@ -51,7 +51,7 @@ class FXMonitor( def email_setts(settle_date, conn, fund): - QUERY = "SELECT dealid, trade_date, settle_date, ft.cp_code, ft.name, buy_currency, buy_amount, sell_currency, sell_amount FROM forward_trades ft LEFT JOIN accounts2 USING (cash_account) WHERE accounts2.fund=%s AND ft.settle_date=%s;" + QUERY = "SELECT dealid, trade_date, settle_date, ft.cp_code, ft.name, buy_currency, buy_amount, sell_currency, sell_amount FROM forward_trades ft LEFT JOIN accounts2 USING (cash_account) WHERE accounts2.fund=%s AND ft.settle_date=%s AND accounts2.account_type='Cash';" with conn.cursor() as c: c.execute( QUERY, |