def get_relations(self, schema):
sql = """SELECT name, type FROM sysobjects"""
result = self.query(sql)
results = []
for r in result:
if r[1].strip() in ['U', 'V']:
ro = RelationObject(r[0].strip(), self, schema)
if r[1].strip() == 'V':
ro.type = 'view'
else:
ro.type = 'table'
results.append(ro)
return results
def get_relations(self, schema):
sql = """SELECT name, type FROM sysobjects"""
result = self.query(sql)
results = []
for r in result:
if r[1].strip() in ['U', 'V']:
ro = RelationObject(r[0].strip(), self, schema)
if r[1].strip() == 'V':
ro.type = 'view'
else:
ro.type = 'table'
results.append(ro)
return results
def get_relations(self, schema):
sql = """SELECT table_name, table_type FROM information_schema.tables WHERE table_catalog = %(dbname)s AND table_schema = %(sname)s"""
dbname = schema.parent.name
sname = schema.name
result = self.query(sql, locals())
results = []
for r in result:
ro = RelationObject(r[0], self, schema)
if r[1] == "VIEW":
ro.type = "view"
else:
ro.type = "table"
results.append(ro)
return results
def get_relations(self, schema):
sql = """SELECT table_name, table_type FROM information_schema.tables WHERE table_catalog = %(dbname)s AND table_schema = %(sname)s"""
dbname = schema.parent.name
sname = schema.name
result = self.query(sql, locals())
results = []
for r in result:
ro = RelationObject(r[0], self, schema)
if r[1] == 'VIEW':
ro.type = 'view'
else:
ro.type = 'table'
results.append(ro)
return results
