diff options
Diffstat (limited to 'python/load_intex_collateral.py')
| -rw-r--r-- | python/load_intex_collateral.py | 15 |
1 files changed, 6 insertions, 9 deletions
diff --git a/python/load_intex_collateral.py b/python/load_intex_collateral.py index 0ccaa1da..a16430bc 100644 --- a/python/load_intex_collateral.py +++ b/python/load_intex_collateral.py @@ -22,7 +22,7 @@ conn = psycopg2.connect(database="ET", user="et_user", password="Serenitas1", ho cursor = conn.cursor() prog = re.compile("\((.*)\)") -workdate = "2012-11-20" +workdate = "2012-11-30" with open(os.path.join(root, "data", "clo_universe_intex_" + workdate + ".txt")) as fh: dr = csv.DictReader(fh, dialect='excel-tab') deal_table = {line['Deal,Tr/CUSIP/ISIN']: datetime.strptime(line['Latest Update'], '%b %d, %Y').date() \ @@ -98,16 +98,13 @@ for dealname in os.listdir(os.path.join(root, "Collaterals_" + workdate)): print detail pdb.set_trace() except psycopg2.IntegrityError as detail: + print detail # crazy hack intex unique id is not really unique - if dealname in ["caval1", "octag11", "octagon8", "windriv2"]: - conn.rollback() - # make sure the loan name is unique by tagging it - row[0] = row[0] + str(tag) - tag = tag+1 + conn.rollback() + # make sure the loan name is unique by tagging it + row[0] = row[0] + "_tag_" + str(tag) + tag = tag+1 cursor.execute(sqlstr, (dealname, updatedate) + tuple(row)) - else: - print detail - pdb.set_trace() conn.commit() |