def check_execute_sql(self, db_id, sql_content, action_type, triggerstmp=''): db_instance = Dbconf.objects.get(id=db_id) db_conf = self.get_db_conf(db_instance.user, db_instance.password, db_instance.host, db_instance.port, action_type) sql_review = Inception(sql_content, db_instance.name).inception_handle( db_conf, triggerstmp) result, status = sql_review.get('result'), sql_review.get('status') if status == -1 or len(result) == 1: raise ParseError({self.connect_error: result}) success_sql_list = [] exception_sql_list = [] for sql_result in result: error_message = sql_result[4] if error_message == 'None': success_sql_list.append(sql_result) else: exception_sql_list.append(error_message) if exception_sql_list and action_type == self.action_type_check: raise NotValid(exception_sql_list) return success_sql_list, exception_sql_list, json.dumps(result)
def check_execute_sql(self, db_id, sql_content): dbobj = Dbconf.objects.get(id=db_id) db_addr = self.get_db_addr(dbobj.user, dbobj.password, dbobj.host, dbobj.port, self.action_type) sql_review = Inception(sql_content, dbobj.name).inception_handle(db_addr) result, status = sql_review.get('result'), sql_review.get('status') if status == -1 or len(result) == 1: raise ParseError({self.connect_error: result}) success_sqls = [] exception_sqls = [] for sql_result in result: error_message = sql_result[4] if error_message == 'None' or re.findall('Warning', error_message): success_sqls.append(sql_result) else: exception_sqls.append(error_message) if exception_sqls and self.action_type == '--enable-check': raise ParseError({self.exception_sqls: exception_sqls}) return (success_sqls, exception_sqls, json.dumps(result))