diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/bbg_cds_quotes.py | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/python/bbg_cds_quotes.py b/python/bbg_cds_quotes.py index b921b838..3fa451e1 100644 --- a/python/bbg_cds_quotes.py +++ b/python/bbg_cds_quotes.py @@ -31,7 +31,7 @@ def bbg_call(session, securities, fields, r): r = {} bbg_call(securities, fields, r) - +breakpoint() sql_str = f"INSERT INTO cds_quotes VALUES({','.join(['%s'] * 8)})" @@ -48,10 +48,10 @@ def build_tuple(k, v, workdate, source): ) -for pcs in ["CBGN", "CMAN"]: +for pcs, data in r.items(): logger.info(f"Inserting quotes for {pcs}") with serenitasdb.cursor() as c: c.executemany( - sql_str, [build_tuple(k, v, workdate, pcs) for k, v in r[pcs].items()] + sql_str, [build_tuple(k, v, workdate, pcs) for k, v in data.items()] ) serenitasdb.commit() |