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