Esempio n. 1
0
class TruthFileTester(object):
    
    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.'

    def getSQLStatement(self, fileName):
        fullLine = ''
        for line in open(fileName, 'r'):
            line = line.strip()
            fullLine += line
            if fullLine.endswith(';'):
                yield fullLine
                fullLine = ''
class TruthFileTester(object):
    
    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.'

    def getSQLStatement(self, fileName):
        fullLine = ''
        for line in open(fileName, 'r'):
            line = line.strip()
            fullLine += line
            if fullLine.endswith(';'):
                yield fullLine
                fullLine = ''