python字典添加主键,INSERT字典sqlite3（python）

最新推荐文章于 2024-09-21 10:56:00 发布

虹王

最新推荐文章于 2024-09-21 10:56:00 发布

阅读量331

点赞数

文章标签： python字典添加主键

这篇博客讨论了如何处理在SQLite数据库中插入字典数据时遇到的语法问题。作者建议使用命名参数的方式，特别是当字典的键可能不存在于数据库列中时，可以使用`defaultdict`来确保缺失的键默认为`None`。通过这种方式，可以避免 OperationalError，并有效地将字典数据插入到对应的列中。

摘要由CSDN通过智能技术生成

New to sqlite and having trouble with the syntax.

I need to iterate through each key of a dictionary and insert dict[key] into the column with the same name as the dictionary key. If it makes any difference, dict['Url'] contains the primary key, and all the rows are already created.

So far I think I've witnessed every possible OperationalError.

for key in merged_dict:

cur.execute("INSERT INTO Games VALUES (?,?)", (key, merged_dict[key]))

解决方案

You can use named parameters for all your insert:

cur.execute("INSERT INTO GAMES (key1, key2, key3, key4) VALUES (:key1, :key2, :key3, :key4)",

merged_dict)

This will take parameters by name from a dictionary, but those keys do have to exist. To support keys that may not exist (defaulting them to NULL instead, use a defaultdict object that will use None for missing keys:

from collections import defaultdict

params = defaultdict(lambda: None, merged_dict)

cur.execute("INSERT INTO GAMES (key1, key2, key3, key4) VALUES (:key1, :key2, :key3, :key4)",

params)