import sqlite3
'''查询sqlite结果转化为字典的函数,
database:查询数据库名
name:查询表名
col_name:查询字段名
col:查询字段值
# 查询结果返回字典'''
def query(database, name, col_name, col):
conn = sqlite3.connect(database)
c = conn.cursor()
sql = 'select * from {name} WHERE {col_name} = "{col}"'.format(name=name, col_name=col_name, col=col)
values = c.execute(sql)
keys = []
for i in values.description:
keys.append(i[0])
keys = tuple(keys)
list_dict = []
try:
for i in values:
dictionary = dict(zip(keys, i))
list_dict.append(dictionary)
except:
dictionary = dict(zip(keys, values))
list_dict.append(dictionary)
return list_dict
10-12
923
![](https://csdnimg.cn/release/blogv2/dist/pc/img/readCountWhite.png)
“相关推荐”对你有帮助么?
-
非常没帮助
-
没帮助
-
一般
-
有帮助
-
非常有帮助
提交