def testEnsureMySQLTyping(self): mysqlDb = MySQLDB(None, None, None, None, None) self.assertEqual('10,"My Poem"', mysqlDb.ensureSQLTyping((10, 'My Poem'))) self.assertEqual('10,11.23,"My Poem"', mysqlDb.ensureSQLTyping((10, 11.23, 'My Poem'))) self.assertEqual('10', mysqlDb.ensureSQLTyping((10, ))) self.assertEqual('"foo"', mysqlDb.ensureSQLTyping(('foo', )))
def __init__(self, testing=False): if testing: return self.mysqlDb = MySQLDB(user='******') scriptDir = os.path.dirname(os.path.abspath(__file__)) print scriptDir #**** truthFilesDir = os.path.join(scriptDir, '../json_to_relation/test/data') print truthFilesDir #**** for filename in os.listdir(truthFilesDir): if filename.endswith('Truth.sql'): print('Testing truth file %s' % filename) for sqlStatement in self.getSQLStatement(os.path.join(truthFilesDir, filename)): try: for res in self.mysqlDb.query(sqlStatement): print res except (pymysql.err.InternalError, pymysql.err.IntegrityError, pymysql.err.Error) as e: print >>sys.stderr, 'Failed in filename %s: %s' % (filename, `e`) print 'Done.'