def testValidConnection(self):
self.assertEqual(utl.connectMysql('TestValDb').errno(),0)
self.assertRaises(MySQLdb.MySQLError, utl.connectMysql, 'XYZ')
try:
asst= utl.getAssets( args.dbase)
exchange = utl.getExchanges( args.dbase)
exID = exchange[(args.exch).upper()]
except Exception, e:
sys.exit('Exiting %s...Problem with Assets or Exchanges; %s' % (sys.argv[0], e))
# check file available
filename = args.dir + args.file
print filename
if not(os.access(filename, os.F_OK)):
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
