diff options
Diffstat (limited to 'python/ack_checker.py')
| -rw-r--r-- | python/ack_checker.py | 7 |
1 files changed, 4 insertions, 3 deletions
diff --git a/python/ack_checker.py b/python/ack_checker.py index fbfdd9ff..8f7a4cd9 100644 --- a/python/ack_checker.py +++ b/python/ack_checker.py @@ -26,16 +26,17 @@ def ack_check(date: datetime.date, conn): if dealtype == "CreditDefaultSwapDeal": with conn.cursor() as c: c.execute( - "SELECT orig_attach FROM cds WHERE id=%s", (serenitas_id,) + "SELECT trade_date, orig_attach FROM cds WHERE id=%s", + (serenitas_id,), ) - (attach,) = c.fetchone() + (trade_date, attach) = c.fetchone() if attach is None: continue with conn.cursor() as c: c.execute( "INSERT INTO id_mapping VALUES(%s, %s, %s, %s)", - (date, "CDS", serenitas_id, globeop_id), + (trade_date, "CDS", serenitas_id, globeop_id), ) if dealtype == "SwaptionDeal": with conn.cursor() as c: |