diff options
| -rw-r--r-- | python/load_intex_collateral.py | 4 | ||||
| -rw-r--r-- | sql/et_tables.sql | 1 |
2 files changed, 3 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: diff --git a/sql/et_tables.sql b/sql/et_tables.sql index de43439f..5fd4ff78 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -29,6 +29,7 @@ CREATE TABLE et_collateral ( isCDO boolean, Liborfloor float, ReinvFlag boolean, + Currency varchar(3), PRIMARY KEY (updatedate, Name, dealname) ); |