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']