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