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