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