diff options
Diffstat (limited to 'python/intex')
| -rw-r--r-- | python/intex/load_indicative.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/python/intex/load_indicative.py b/python/intex/load_indicative.py index c8134a42..908cb1c3 100644 --- a/python/intex/load_indicative.py +++ b/python/intex/load_indicative.py @@ -51,6 +51,7 @@ def insert_new_tranche(conn, line): "INSERT INTO tranche_ref(Cusip, ISIN, figi, bloomberg_ticker, dealname, " "tranche, paripassu_tranches, Orig_Balance, Orig_Moody, Orig_Attach, " "Orig_Detach, Floater_Index, Spread, type) VALUES({0}) " + "ON CONFLICT (cusip, dealname) DO UPDATE SET figi=EXCLUDED.figi " "RETURNING id".format(",".join(["%s"] * 14)) ) with conn.cursor() as c: |