コード例 #1
0
 def testValidConnection(self):
     self.assertGreater(len(utl.getExchanges('TestValDb')), 0)
     self.assertIn('GASCI', utl.getExchanges('TestValDb').keys())
コード例 #2
0
 def testValidConnection(self):
     self.assertGreater(len(utl.getAssets('TestValDb')), 0)
     self.assertIn((1,'DDL'), utl.getAssets('TestValDb').keys())
コード例 #3
0
 def testValidConnection(self):
     self.assertEqual(utl.connectMysql('TestValDb').errno(),0)
     self.assertRaises(MySQLdb.MySQLError, utl.connectMysql, 'XYZ')
コード例 #4
0
 def testTimezoneChange(self):
     self.assertEqual(utl.reformatDate('12-Mar-10','12:00:00','America/Guyana'),'2010-03-12 16:00')
コード例 #5
0
 def testNoTimezoneChange(self):
     self.assertEqual(utl.reformatDate('12-Mar-10','12:00:00','UTC'),'2010-03-12 12:00')
コード例 #6
0
    import sys
    import os
    import argparse as ap
    
#    Parse arguments
    pars= ap.ArgumentParser(description="Load GASCI-formatted data from csv file to ValDb")
    pars.add_argument('file',help='name of csv file in "dir" with GASCI/TTSE price history')
    pars.add_argument('dir',nargs='?',
                      default='/Users/dpollard2/Documents/Work/Pollards&Filles/Research/GASCI_Analysis/GASCI_Data/Jan2012/',
                      help='directory holding GASCI csv files with price histories')
    pars.add_argument('-ex --exchange',dest='exch',required=True,help='name of exchange e.g. GASCI')
    pars.add_argument('-db --dbase',dest='dbase',default='TestValDb',choices=['TestValDb','PeFValDb'],help='name of database')
    args= pars.parse_args()

    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()