diff options
Diffstat (limited to 'python')
| -rw-r--r-- | python/load_intex_collateral.py | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index f7437d15..4325c9aa 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -12,7 +12,7 @@ fields = ['Asset Name', 'Issuer', 'Contributed Balance', 'Maturity Date', \ 'Next Paydate', 'Second Lien', 'LoanX ID', 'CUSIP', 'Market Price', \ 'Market Price Source', 'Price Date', 'Fixed or Float', \ 'Defaulted Flag', 'Security Sub-Category', \ - 'Structured Finance Security', 'Life Floor', 'Reinvest Collat'] + 'Structured Finance Security', 'Life Floor', 'Reinvest Collat', 'Native Currency'] def convertToNone(s): return None if s=='' else s @@ -128,7 +128,7 @@ def upload_data(dealnames, workdate, conn, cursor): "Spread", "Frequency", "NextPaydate", "SecondLien", "LoanXID", "Cusip", "IntexPrice", "IntexPriceSource", "IntexPriceDate", "FixedOrFloat", "DefaultedFlag", "CovLite", "isCDO", - "Liborfloor", "ReinvFlag"] + "Liborfloor", "ReinvFlag", "Currency"] sqlstr = "INSERT INTO ET_COLLATERAL({0}) VALUES({1})".format(",".join(sql_fields), ",".join(["%s"] * len(sql_fields))) try: |