Python webpy db 获取 column name

cwalet · April 24, 2014 · Last by r4r4r5t5tvvvv replied at May 15, 2014 · 7617 hits

data = db.query(sql).list()
for d in dir(data):
    print d
for d in data.__dict__:
    print d

请问如何获取 list 中的 column name 呢？

xds2000 #1 April 25, 2014

rows = db.query(sql).list()
if(rows):
    columns = rows[0].keys()  <- here

cwalet #2 April 25, 2014

#1 楼 @xds2000 灰常感谢！奇怪为什么下面这样写不行：

for d in rows:
    print d.keys()

这样输出来的还是列数据对象。

r4r4r5t5tvvvv #3 May 15, 2014

为什么这个网站没有发帖的按钮

You need to Sign in before reply, if you don't have an account, please Sign up first.