def get_node_list(self, gid, sid, did, scid, tid, exid=None):
"""
This function returns all exclusion constraints
nodes within that collection as a list.
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
exid: Exclusion constraint ID
Returns:
"""
self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(sid)
self.conn = self.manager.connection(did=did)
self.template_path = 'exclusion_constraint/sql/#{0}#'.format(
self.manager.version)
# We need parent's name eg table name and schema name
schema, table = exclusion_utils.get_parent(self.conn, tid)
self.schema = schema
self.table = table
SQL = render_template("/".join([self.template_path, 'properties.sql']),
did=did,
tid=tid)
status, res = self.conn.execute_dict(SQL)
return res['rows']
def wrap(*args, **kwargs):
# Here args[0] will hold self & kwargs will hold gid,sid,did
self = args[0]
self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(
kwargs['sid'])
self.conn = self.manager.connection(did=kwargs['did'])
self.datlastsysoid = \
self.manager.db_info[kwargs['did']]['datlastsysoid'] \
if self.manager.db_info is not None and \
kwargs['did'] in self.manager.db_info else 0
self.datistemplate = False
if (self.manager.db_info is not None
and kwargs['did'] in self.manager.db_info and
'datistemplate' in self.manager.db_info[kwargs['did']]):
self.datistemplate = self.manager.db_info[
kwargs['did']]['datistemplate']
self.template_path = self.EXCLUSION_CONSTRAINT_PATH.format(
self.manager.version)
# We need parent's name eg table name and schema name
schema, table = exclusion_utils.get_parent(self.conn,
kwargs['tid'])
self.schema = schema
self.table = table
return f(*args, **kwargs)
def wrap(*args, **kwargs):
# Here args[0] will hold self & kwargs will hold gid,sid,did
self = args[0]
self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(
kwargs['sid'])
self.conn = self.manager.connection(did=kwargs['did'])
self.template_path = 'exclusion_constraint/sql/#{0}#'.format(
self.manager.version)
# We need parent's name eg table name and schema name
schema, table = exclusion_utils.get_parent(self.conn,
kwargs['tid'])
self.schema = schema
self.table = table
return f(*args, **kwargs)
def get_nodes(self, gid, sid, did, scid, tid, exid=None):
"""
This function returns all Exclusion constraint nodes as a list.
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
exid: Exclusion constraint ID
Returns:
"""
self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(sid)
self.conn = self.manager.connection(did=did)
self.template_path = self.EXCLUSION_CONSTRAINT_PATH.format(
self.manager.version)
# We need parent's name eg table name and schema name
schema, table = exclusion_utils.get_parent(self.conn, tid)
self.schema = schema
self.table = table
res = []
SQL = render_template("/".join([self.template_path,
self._NODES_SQL]),
tid=tid)
status, rset = self.conn.execute_2darray(SQL)
for row in rset['rows']:
res.append(
self.blueprint.generate_browser_node(
row['oid'],
tid,
row['name'],
icon="icon-exclusion_constraint"
))
return res
def get_node_list(self, gid, sid, did, scid, tid, exid=None):
"""
This function returns all exclusion constraints
nodes within that collection as a list.
Args:
gid: Server Group ID
sid: Server ID
did: Database ID
scid: Schema ID
tid: Table ID
exid: Exclusion constraint ID
Returns:
"""
self.manager = get_driver(PG_DEFAULT_DRIVER).connection_manager(sid)
self.conn = self.manager.connection(did=did)
self.template_path = self.EXCLUSION_CONSTRAINT_PATH.format(
self.manager.version)
# We need parent's name eg table name and schema name
schema, table = exclusion_utils.get_parent(self.conn, tid)
self.schema = schema
self.table = table
SQL = render_template("/".join(
[self.template_path, self._PROPERTIES_SQL]),
did=did,
tid=tid)
status, res = self.conn.execute_dict(SQL)
for row in res['rows']:
row['_type'] = self.node_type
return res['rows']
