diff options
| -rw-r--r-- | python/load_intex_collateral.py | 1 | ||||
| -rw-r--r-- | sql/et_tables.sql | 4 |
2 files changed, 3 insertions, 2 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index df01f650..00b6f027 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -52,6 +52,7 @@ def upload_data(workdate, conn, cursor): if line['LoanX ID'] and len(line['LoanX ID']) > 8: print "dubious id found: {0}".format(line['LoanX ID']) line['LoanX ID'] = line['LoanX ID'][:8] + line['LoanX ID'] = line['LoanX ID'].upper() try: # make sure the string is utf8 safe line['Issuer'] = line['Issuer'].decode('windows-1252') diff --git a/sql/et_tables.sql b/sql/et_tables.sql index 02d75c31..bb306904 100644 --- a/sql/et_tables.sql +++ b/sql/et_tables.sql @@ -342,7 +342,7 @@ CREATE OR REPLACE FUNCTION et_aggdealinfo (p_dealname varchar(10)) bool_or(c.covlite))) AS covlite, (bool_or(a.secondlien) OR bool_or(c.secondlien)) AS secondlien, bool_or(a.iscdo) AS iscdo, bool_or(a.defaultedflag) AS defaultedflag FROM et_latestdealinfo(p_dealname) a - LEFT JOIN latest_markit_prices2 b ON upper(a.loanxid) = b.loanxid + LEFT JOIN latest_markit_prices2 b ON a.loanxid = b.loanxid LEFT JOIN bloomberg_corp c ON a.cusip=c.cusip WHERE a.dealname = p_dealname GROUP BY a.issuername, a.maturity, a.loanxid, a.fixedorfloat, a.frequency, a.cusip ORDER BY issuername; @@ -409,7 +409,7 @@ CREATE OR REPLACE FUNCTION et_aggdealinfo_historical (p_dealname varchar(10), p_ bool_or(c.secondlien)) AS secondlien, bool_or(a.iscdo) AS iscdo, bool_or(a.defaultedflag) AS defaultedflag, a.et_loanxid, a.et_cusip FROM et_historicaldealinfo(p_dealname, p_date) a - LEFT JOIN historical_markit_prices2(p_date) b ON upper(a.loanxid)=b.loanxid + LEFT JOIN historical_markit_prices2(p_date) b ON a.loanxid=b.loanxid LEFT JOIN historical_bloomberg_corp(p_date) c ON a.cusip=c.cusip WHERE a.dealname = p_dealname GROUP BY a.issuername, a.maturity, a.loanxid, a.fixedorfloat, |