def _fetch_properties(self, tid, trid):
SQL = render_template("/".join(
[self.template_path, self._PROPERTIES_SQL]),
tid=tid,
trid=trid,
datlastsysoid=self.datlastsysoid)
status, res = self.conn.execute_dict(SQL)
if not status:
return status, res
if len(res['rows']) == 0:
return True, res
# Making copy of output for future use
data = dict(res['rows'][0])
if len(data['tgattr']) >= 1:
columns = ', '.join(data['tgattr'].split(' '))
data['columns'] = compound_trigger_utils.get_column_details(
self.conn, tid, columns)
data = trigger_definition(data)
return True, data
def _fetch_properties(self, tid, trid):
SQL = render_template("/".join([self.template_path,
'properties.sql']),
tid=tid, trid=trid,
datlastsysoid=self.datlastsysoid)
status, res = self.conn.execute_dict(SQL)
if not status:
return internal_server_error(errormsg=res)
if len(res['rows']) == 0:
return gone(gettext(
"""Could not find the compound trigger in the table."""))
# Making copy of output for future use
data = dict(res['rows'][0])
if len(data['tgattr']) >= 1:
columns = ', '.join(data['tgattr'].split(' '))
data['columns'] = compound_trigger_utils.get_column_details(
self.conn, tid, columns)
data = trigger_definition(data)
return True, data
def properties(self, gid, sid, did, scid, tid, trid):
"""
This function will show the properties of the selected
compound trigger node.
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
scid: Schema ID
tid: Table ID
trid: Trigger ID
Returns:
JSON of selected compound trigger node
"""
SQL = render_template("/".join([self.template_path,
'properties.sql']),
tid=tid, trid=trid,
datlastsysoid=self.datlastsysoid)
status, res = self.conn.execute_dict(SQL)
if not status:
return internal_server_error(errormsg=res)
if len(res['rows']) == 0:
return gone(gettext(
"""Could not find the compound trigger in the table."""))
# Making copy of output for future use
data = dict(res['rows'][0])
if len(data['tgattr']) >= 1:
columns = ', '.join(data['tgattr'].split(' '))
data['columns'] = compound_trigger_utils.get_column_details(
self.conn, tid, columns)
data = trigger_definition(data)
return ajax_response(
response=data,
status=200
)