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 3386b50f..c96bb11f 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -111,7 +111,8 @@ def upload_data(dealnames, workdate, conn, cursor): if reinsert or not old_update_dates or updatedate not in old_update_dates: tag = 0 for row in data: - # print dealname, row + if row[4] and 'Reinvest' in row[4]: + row[4] = row[4].replace("Reinvest ", "") sql_fields = ["dealname", "updatedate", "name", "IssuerName", "CurrentBalance", "Maturity", "AssetSubtype", "AssetType", "GrossCoupon", "Spread", "Frequency", "NextPaydate", "SecondLien", "LoanXID", @@ -132,7 +133,7 @@ def upload_data(dealnames, workdate, conn, cursor): conn.rollback() # make sure the loan name is unique by tagging it row[0] = row[0] + "_tag_" + str(tag) - tag = tag+1 + tag = tag + 1 cursor.execute(sqlstr, (dealname, updatedate) + tuple(row)) except TypeError: pdb.set_trace() |