import csv
import os.path
import pdb

if os.name=='nt':
    root = "//WDSENTINEL/share/CorpCDOs/"
elif os.name=='posix':
    root = "/home/share/CorpCDOs/"

root = os.path.join(root, "data")
fh1 = open(os.path.join(root, "clo_universe_intex_2012-11-20.txt"))
fh2 = open(os.path.join(root, "clo_universe_intex_2012-11-21.txt"))

dr1 = csv.DictReader(fh1, dialect = 'excel-tab')
dr2 = csv.DictReader(fh2, dialect = 'excel-tab')

for line1 in dr1:
    line2 = dr2.next()
    if line1['Deal,Tr/CUSIP/ISIN'] != line2['Deal,Tr/CUSIP/ISIN']:
        pdb.set_trace()
    if line1['Latest Update'] != line2['Latest Update']:
        print '{0}: {1}   {2}: {3}'.format(line1['Deal,Tr/CUSIP/ISIN'], line1['Latest Update'],
                                           line2['Deal,Tr/CUSIP/ISIN'], line2['Latest Update'])