def testNoTimezoneChange(self):
self.assertEqual(utl.reformatDate('12-Mar-10','12:00:00','UTC'),'2010-03-12 12:00')
def testTimezoneChange(self):
self.assertEqual(utl.reformatDate('12-Mar-10','12:00:00','America/Guyana'),'2010-03-12 16:00')
sys.exit("Exiting ... File %s not found" % filename)
# connect to database
conn = utl.connectMysql(args.dbase)
csr = conn.cursor()
# read csv file of prices and convert to list
# INSERT prices into value table using a loop
with open(filename, 'rU') as f:
try:
reader = csv.DictReader(f,fieldnames=('Ticker','Session','Date','Price'))
numInserted= 0
for row in reader:
if (reader.line_num > 1):
if ((row['Price'].find('N/A') == -1) and (len(row['Price'])>0)):
hhmmss = str( asst[(exID,row['Ticker'])][1] )
tzon = asst[(exID,row['Ticker'])][2]
sqlStmt= "insert into value (assetID, datetime, valueTypeID, value) values (%d, '%s', 1, %s)" % (asst[(exID,row['Ticker'])][0], utl.reformatDate(row['Date'],hhmmss,tzon), row['Price'])
print sqlStmt
csr.execute(sqlStmt)
numInserted += 1
# print "Number of rows: %d" % (reader.line_num-1)
except Exception, e:
sys.exit('Exiting from data insertion...File %s, line %d, %s' % (filename, reader.line_num, e))
finally:
csr.close()
conn.commit()
print "Number of rows added: %d" % (numInserted)
f.close()
