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.'
