def __init__(self, curs, table_name): """Initializes class by loading info about table_name from database.""" BaseStruct.__init__(self, curs, table_name) self.table_name = table_name # fill args schema, name = fq_name_parts(table_name) args = { 'schema': schema, 'table': name, 'fqname': self.fqname, 'fq2name': quote_literal(self.fqname), 'oid': get_table_oid(curs, table_name), 'pg_class_oid': get_table_oid(curs, 'pg_catalog.pg_class'), } # load table struct self.col_list = self._load_elem(curs, self.name, args, TColumn) self.object_list = [ TTable(table_name, self.col_list) ] self.seq_list = [] # load seqs for col in self.col_list: if col.seqname: owner = self.fqname + '.' + quote_ident(col.name) seq_args = { 'fqname': col.seqname, 'owner': quote_literal(owner) } self.seq_list += self._load_elem(curs, col.seqname, seq_args, TSeq) self.object_list += self.seq_list # load additional objects to_load = [TConstraint, TIndex, TTrigger, TRule, TGrant, TOwner, TParent] for eclass in to_load: self.object_list += self._load_elem(curs, self.name, args, eclass)
def __init__(self, curs, table_name): """Initializes class by loading info about table_name from database.""" self.table_name = table_name # fill args schema, name = fq_name_parts(table_name) args = { 'schema': schema, 'table': name, 'oid': get_table_oid(curs, table_name), 'pg_class_oid': get_table_oid(curs, 'pg_catalog.pg_class'), } # load table struct self.col_list = self._load_elem(curs, args, TColumn) self.object_list = [ TTable(table_name, self.col_list) ] # load additional objects to_load = [TConstraint, TIndex, TTrigger, TRule, TGrant, TOwner] for eclass in to_load: self.object_list += self._load_elem(curs, args, eclass)
def __init__(self, curs, table_name): """Initializes class by loading info about table_name from database.""" self.table_name = table_name # fill args schema, name = fq_name_parts(table_name) args = { 'schema': schema, 'table': name, 'oid': get_table_oid(curs, table_name), 'pg_class_oid': get_table_oid(curs, 'pg_catalog.pg_class'), } # load table struct self.col_list = self._load_elem(curs, args, TColumn) self.object_list = [TTable(table_name, self.col_list)] # load additional objects to_load = [TConstraint, TIndex, TTrigger, TRule, TGrant, TOwner] for eclass in to_load: self.object_list += self._load_elem(curs, args, eclass)