有没有办法在sqlite中获取列名列表?
我想从数据库的表中获取列名列表.使用 pragma 我得到一个包含大量不需要信息的元组列表.有没有办法只获取列名?所以我可能会得到这样的结果:
I want to get a list of column names from a table in a database. Using pragma I get a list of tuples with a lot of unneeded information. Is there a way to get only the column names? So I might end up with something like this:
[第 1 列、第 2 列、第 3 列、第 4 列]
[Column1, Column2, Column3, Column4]
我绝对需要这个列表的原因是因为我想在列表中搜索一个列名并获取索引，因为我的很多代码中都使用了索引.
The reason why I absolutely need this list is because I want to search for a column name in the list and get the index because the index is used in a lot of my code.
有没有办法得到这样的列表?
Is there a way of getting a list like this?
谢谢
推荐答案
你可以使用 sqlite3 和 pep-249
You can use sqlite3 and pep-249
import sqlite3
connection = sqlite3.connect('~/foo.sqlite')
cursor = connection.execute('select * from bar')
cursor.description 是列的描述
names = list(map(lambda x: x[0], cursor.description))
或者，您可以使用列表推导式:
Alternatively you could use a list comprehension:
names = [description[0] for description in cursor.description]
相关文章