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