def getdatabaserelation(self):
reloid = 1262
if not self.pg_database_attr:
self.pg_database_attr = [
PgAttribute95( 1262, "datname", 19, -1, Catalog95.NAMEDATALEN, 1, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datdba", 26, -1, 4, 2, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "encoding", 23, -1, 4, 3, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datcollate", 19, -1, Catalog95.NAMEDATALEN, 4, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datctype", 19, -1, Catalog95.NAMEDATALEN, 5, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datistemplate", 16, -1, 1, 6, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datallowconn", 16, -1, 1, 7, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datconnlimit", 23, -1, 4, 8, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datlastsysoid", 26, -1, 4, 9, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datfrozenxid", 28, -1, 4, 10, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datminmxid", 28, -1, 4, 11, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "dattablespace", 26, -1, 4, 12, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datacl", 1034, -1, -1, 13, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 0 )
]
relfilenode = RelFileNode()
relfilenode.space_node = Catalog95.GLOBALTABLESPACE_OID
relfilenode.db_node = 0
relfilenode.rel_node = self.getsharerelmap()[reloid]
databaserelation = Relation(reloid, 'pg_database',
self.pg_database_attr, relfilenode)
return databaserelation
def getdatabaserelation(self):
reloid = 1262
if not self.pg_database_attr:
self.pg_database_attr = [
PgAttribute95( 1262, "datname", 19, -1, Catalog95.NAMEDATALEN, 1, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datdba", 26, -1, 4, 2, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "encoding", 23, -1, 4, 3, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datcollate", 19, -1, Catalog95.NAMEDATALEN, 4, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datctype", 19, -1, Catalog95.NAMEDATALEN, 5, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datistemplate", 16, -1, 1, 6, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datallowconn", 16, -1, 1, 7, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datconnlimit", 23, -1, 4, 8, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datlastsysoid", 26, -1, 4, 9, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datfrozenxid", 28, -1, 4, 10, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datminmxid", 28, -1, 4, 11, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "dattablespace", 26, -1, 4, 12, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( 1262, "datacl", 1034, -1, -1, 13, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 0 )
]
relfilenode = RelFileNode()
relfilenode.space_node = Catalog95.GLOBALTABLESPACE_OID
relfilenode.db_node = 0
relfilenode.rel_node = self.getsharerelmap()[reloid]
databaserelation = Relation(reloid, 'pg_database', self.pg_database_attr, relfilenode)
return databaserelation
def getpgclassrelation(self, tablesapce, dboid):
reloid = 1259
if not self.pg_class_attr:
self.pg_class_attr = [
PgAttribute95( reloid, "relname", 19, -1, Catalog95.NAMEDATALEN, 1, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relnamespace", 26, -1, 4, 2, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltype", 26, -1, 4, 3, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reloftype", 26, -1, 4, 4, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relowner", 26, -1, 4, 5, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relam", 26, -1, 4, 6, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relfilenode", 26, -1, 4, 7, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltablespace", 26, -1, 4, 8, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relpages", 23, -1, 4, 9, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltuples", 700, -1, 4, 10, 0, -1, -1, self.float4ByVal, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relallvisible", 23, -1, 4, 11, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltoastrelid", 26, -1, 4, 12, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasindex", 16, -1, 1, 13, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relisshared", 16, -1, 1, 14, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relpersistence", 18, -1, 1, 15, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relkind", 18, -1, 1, 16, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relnatts", 21, -1, 2, 17, 0, -1, -1, True, 'p', 's', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relchecks", 21, -1, 2, 18, 0, -1, -1, True, 'p', 's', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasoids", 16, -1, 1, 19, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhaspkey", 16, -1, 1, 20, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasrules", 16, -1, 1, 21, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhastriggers", 16, -1, 1, 22, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhassubclass", 16, -1, 1, 23, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relrowsecurity", 16, -1, 1, 24, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relispopulated", 16, -1, 1, 25, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relreplident", 18, -1, 1, 26, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relfrozenxid", 28, -1, 4, 27, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relminmxid", 28, -1, 4, 28, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relacl", 1034, -1, -1, 29, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reloptions", 1009, -1, -1, 30, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 100)
]
relfilenode = RelFileNode()
relfilenode.space_node = tablesapce
relfilenode.db_node = dboid
relfilenode.rel_node = self.getdatabaserelmap(tablesapce,
dboid)[reloid]
relation = Relation(reloid, 'pg_class', self.pg_class_attr,
relfilenode, tablesapce)
return relation
def getpgclassrelation(self, tablesapce, dboid):
reloid = 1259
if not self.pg_class_attr:
self.pg_class_attr = [
PgAttribute95( reloid, "relname", 19, -1, Catalog95.NAMEDATALEN, 1, 0, -1, -1, False, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relnamespace", 26, -1, 4, 2, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltype", 26, -1, 4, 3, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reloftype", 26, -1, 4, 4, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relowner", 26, -1, 4, 5, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relam", 26, -1, 4, 6, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relfilenode", 26, -1, 4, 7, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltablespace", 26, -1, 4, 8, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relpages", 23, -1, 4, 9, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltuples", 700, -1, 4, 10, 0, -1, -1, self.float4ByVal, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relallvisible", 23, -1, 4, 11, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reltoastrelid", 26, -1, 4, 12, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasindex", 16, -1, 1, 13, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relisshared", 16, -1, 1, 14, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relpersistence", 18, -1, 1, 15, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relkind", 18, -1, 1, 16, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relnatts", 21, -1, 2, 17, 0, -1, -1, True, 'p', 's', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relchecks", 21, -1, 2, 18, 0, -1, -1, True, 'p', 's', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasoids", 16, -1, 1, 19, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhaspkey", 16, -1, 1, 20, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhasrules", 16, -1, 1, 21, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhastriggers", 16, -1, 1, 22, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relhassubclass", 16, -1, 1, 23, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relrowsecurity", 16, -1, 1, 24, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relispopulated", 16, -1, 1, 25, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relreplident", 18, -1, 1, 26, 0, -1, -1, True, 'p', 'c', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relfrozenxid", 28, -1, 4, 27, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relminmxid", 28, -1, 4, 28, 0, -1, -1, True, 'p', 'i', True, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "relacl", 1034, -1, -1, 29, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 0 ), \
PgAttribute95( reloid, "reloptions", 1009, -1, -1, 30, 1, -1, -1, False, 'x', 'i', False, False, False, True, 0, 100)
]
relfilenode = RelFileNode()
relfilenode.space_node = tablesapce
relfilenode.db_node = dboid
relfilenode.rel_node = self.getdatabaserelmap(tablesapce, dboid)[reloid]
relation = Relation(reloid, 'pg_class', self.pg_class_attr, relfilenode, tablesapce)
return relation
