diff options
Diffstat (limited to 'python/upload_bbh_trades.py')
| -rw-r--r-- | python/upload_bbh_trades.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/upload_bbh_trades.py b/python/upload_bbh_trades.py index ccce36a2..b0da6dd8 100644 --- a/python/upload_bbh_trades.py +++ b/python/upload_bbh_trades.py @@ -7,12 +7,12 @@ from sqlalchemy.exc import IntegrityError from io import StringIO from serenitas.utils.env import DAILY_DIR from serenitas.utils.remote import SftpClient -from csv_headers.bond_upload import bbh_bonds +from csv_headers.bond_upload import BBH_BONDS if __name__ == "__main__": conn = dbconn("dawndb") with conn.cursor() as c: - headers = bbh_bonds + headers = BBH_BONDS sql_query = "SELECT bond_trades.*, counterparties.dtc_number FROM bond_trades LEFT JOIN counterparties ON cp_code=code WHERE cash_counterparty AND trade_date >= '2022-04-05' AND fund='BRINKER' and faceamount is not null and faceamount >0;" c.execute( sql_query, (datetime.date(2022, 4, 5),) |