def get_sql_from_diff(self, gid, sid, did, scid, tid, oid,
data=None, diff_schema=None, drop_sql=False):
if data:
SQL, name = trigger_utils.get_sql(
self.conn, data, tid, oid,
self.datlastsysoid,
self.blueprint.show_system_objects, True)
if not isinstance(SQL, str):
return SQL
SQL = SQL.strip('\n').strip(' ')
else:
if drop_sql:
SQL = self.delete(gid=gid, sid=sid, did=did,
scid=scid, tid=tid, trid=oid,
only_sql=True)
else:
schema = self.schema
if diff_schema:
schema = diff_schema
SQL = trigger_utils.get_reverse_engineered_sql(
self.conn, schema,
self.table, tid, oid,
self.datlastsysoid,
self.blueprint.show_system_objects,
template_path=None, with_header=False)
return SQL
def get_sql_from_diff(self, **kwargs):
"""
This function is used to get the DDL/DML statements.
:param kwargs
:return:
"""
gid = kwargs.get('gid')
sid = kwargs.get('sid')
did = kwargs.get('did')
scid = kwargs.get('scid')
tid = kwargs.get('tid')
oid = kwargs.get('oid')
data = kwargs.get('data', None)
drop_sql = kwargs.get('drop_sql', False)
target_schema = kwargs.get('target_schema', None)
if data:
SQL, name = trigger_utils.get_sql(
self.conn,
data=data,
tid=tid,
trid=oid,
datlastsysoid=self.datlastsysoid,
show_system_objects=self.blueprint.show_system_objects,
is_schema_diff=True)
if not isinstance(SQL, str):
return SQL
SQL = SQL.strip('\n').strip(' ')
else:
if drop_sql:
SQL = self.delete(gid=gid,
sid=sid,
did=did,
scid=scid,
tid=tid,
trid=oid,
only_sql=True)
else:
schema = self.schema
if target_schema:
schema = target_schema
SQL = trigger_utils.get_reverse_engineered_sql(
self.conn,
schema=schema,
table=self.table,
tid=tid,
trid=oid,
datlastsysoid=self.datlastsysoid,
show_system_objects=self.blueprint.show_system_objects,
template_path=None,
with_header=False)
return SQL
def sql(self, gid, sid, did, scid, tid, trid):
"""
This function will generates reverse engineered sql for trigger object
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
trid: Trigger ID
"""
SQL = trigger_utils.get_reverse_engineered_sql(
self.conn, self.schema, self.table, tid, trid, self.datlastsysoid,
self.blueprint.show_system_objects)
return ajax_response(response=SQL)
