def compareresultpatternlistmysql(jobname, selectsql, patternformat, indexs, cutlens, filepath='default'):
if filepath == 'default':
filepath = os.path.abspath(os.path.dirname(__file__) + '/outputdata/%sDB.txt' % jobname)
mysqldb = MysqlDbObj()
if mysqldb.selectdatatofile( selectsql, filepath):
return compareresultpatternlist(jobname, patternformat, indexs, cutlens)
else:
return False
def compareresultmysql(jobname, selectsql, filepath='default'):
if filepath == 'default':
filepath = os.path.abspath(os.path.dirname(__file__) + '/outputdata/%sDB.txt' % jobname)
mysqldb = MysqlDbObj()
if mysqldb.selectdatatofile(selectsql, filepath):
return compareresult(jobname)
else:
return False
def operatemysqldata(slqstr):
dbobj = MysqlDbObj()
return dbobj.executesql(slqstr)