diff options
Diffstat (limited to 'python/load_intex_collateral.py')
| -rw-r--r-- | python/load_intex_collateral.py | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index b530d246..ab86f93d 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -50,6 +50,7 @@ def upload_data(conn, dealnames, workdate): line['LoanX ID'] = line['LoanX ID'].upper() line['CUSIP'] = line['CUSIP'].upper() line['Asset Subtype'] = line['Asset Subtype'].replace("Reinvest ", "") + line['Asset Subtype'] = line['Asset Subtype'].replace("Reinv ", "") except AttributeError: pass else: @@ -61,7 +62,7 @@ def upload_data(conn, dealnames, workdate): print("dubious CUSIP found: {0}".format(line['CUSIP'])) line['CUSIP'] = line['CUSIP'][:9] if len(line['Asset Subtype'])>10: - line['Assert Subtype'] = line['Assert Subtype'][:9] + line['Asset Subtype'] = line['Asset Subtype'][:9] if 'Reinvest Collat' not in missingfields and \ line['Reinvest Collat'].upper() == 'Y' or line['Issuer'] == '': @@ -97,6 +98,7 @@ def upload_data(conn, dealnames, workdate): old_update_dates = [date[0] for date in query_db(sqlstr, params=(dealname,), one=False)] sqlstr = "select max(\"Latest Update\") from clo_universe where dealname= %s" + updatedate = query_db(sqlstr, params = (dealname,))[0] # sanity check if we already have the data reinsert = False if updatedate in old_update_dates: |