def get_except_data_for_sql(self, row, sql_base):
oper_mysql = OperationMysql(sql_base)
except_data = self.get_except(row)
result = oper_mysql.search_all(except_data)
# if sql_value == '':
# result = oper_mysql.search_all(except_data)
# else:
# result = oper_mysql.search_all(except_data % sql_value)
return result
def get_expcet_data(self, row):
col = int(data_config.get_expect())
expect = self.opera_excel.get_cell_value(row, col)
if expect == '':
expect = None
elif not self.common_util.is_json(expect):
op_mysql = OperationMysql()
expect = op_mysql.search_all(expect)
col = int(data_config.get_data_func())
func = self.opera_excel.get_cell_value(row, col)
expect = getattr(self.expectFunc, func)(expect)
return expect
def get_all_sql_data(self, row, get_data):
sql = get_data(row)
# print sql
# 这里做判断，预期结果内有sql命令，才去运行sql
if sql != None:
op_mysql = OperationMysql()
res = op_mysql.search_all(sql)
# return res.decode('unicode-escape')
# print(res.encode('utf-8').decode('gb18030'))
# print(type((res.encode('utf-8').decode('gb18030'))))
return res.encode('utf-8').decode('unicode_escape')
else:
return None
def get_expcet_data_for_mysql(self, row):
op_mysql = OperationMysql()
sql = self.get_expcet_data(row)
res = op_mysql.search_all(sql)
return res.decode('unicode-escape')
