diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/upload_umb_bonds.py | 4 |
1 files changed, 1 insertions, 3 deletions
diff --git a/python/upload_umb_bonds.py b/python/upload_umb_bonds.py index d6355559..1c000ebb 100644 --- a/python/upload_umb_bonds.py +++ b/python/upload_umb_bonds.py @@ -7,15 +7,13 @@ from serenitas.ops.funds import UMB def upload_to_umb(trade_date, upload): sql_query = ( "SELECT bonds.*, bond_allocation.notional, fund, custodian, " - "cash_account, bond_submission.id as sid, allocation_id, action, " + "cash_account, " "counterparties.name, dtc_number " "FROM bonds " "INNER JOIN bond_allocation ON bond_allocation.tradeid=bonds.id " "INNER JOIN accounts USING (code) " - "INNER JOIN bond_submission ON allocation_id=bond_allocation.id " "INNER JOIN counterparties ON counterparties.code = bonds.cp_code " "WHERE fund= %s and trade_date = %s " - "ORDER BY fund, allocation_id, bonds" ) with BondDeal._conn.cursor() as c: c.execute( |