def get_columns(self, relation):
sql = """SELECT c.name, t.name, c.colid FROM sysobjects AS o JOIN syscolumns AS c ON o.id = c.id JOIN systypes AS t ON c.usertype = t.usertype WHERE o.name = '%s'""" % relation.name
result = self.query(sql)
results = []
for r in result:
co = ColumnObject(r[0].strip(), self, relation)
co.type = r[1].strip()
co.num = r[2]
results.append(co)
return results
def get_columns(self, relation):
sql = """SELECT c.name, t.name, c.colid FROM sysobjects AS o JOIN syscolumns AS c ON o.id = c.id JOIN systypes AS t ON c.usertype = t.usertype WHERE o.name = '%s'""" % relation.name
result = self.query(sql)
results = []
for r in result:
co = ColumnObject(r[0].strip(), self, relation)
co.type = r[1].strip()
co.num = r[2]
results.append(co)
return results
def get_columns(self, relation):
sql = """SELECT column_name, udt_name, ordinal_position FROM information_schema.columns WHERE table_catalog = %(dbname)s AND table_schema = %(sname)s AND table_name = %(rname)s"""
dbname = relation.parent.parent.name
sname = relation.parent.name
rname = relation.name
result = self.query(sql, locals())
results = []
for r in result:
co = ColumnObject(r[0], self, relation)
co.type = r[1]
co.num = r[2]
results.append(co)
return results
def get_columns(self, relation):
sql = """SELECT column_name, udt_name, ordinal_position FROM information_schema.columns WHERE table_catalog = %(dbname)s AND table_schema = %(sname)s AND table_name = %(rname)s"""
dbname = relation.parent.parent.name
sname = relation.parent.name
rname = relation.name
result = self.query(sql, locals())
results = []
for r in result:
co = ColumnObject(r[0], self, relation)
co.type = r[1]
co.num = r[2]
results.append(co)
return results
