python3 sqlite 中文_在Python中插入sqlite 3时发生操作错误

我用JSON解析的数据填充数据库。当我执行INSERT语句时，我得到一个错误：sqlite3.OperationalError: no such column: None。一些JSON数据返回null，这会导致Python将None插入表中，但我相信这应该没问题吧？有人知道问题出在哪里吗？在

回溯：

Traceback (most recent call last):

File "productInfoScraper.py", line 71, in

")")

Python中我的INSERT语句：cursor.execute("INSERT INTO ProductInfo VALUES(" +

str(data["data"]["product_id"]) + ", " +

"'" + str(data["data"]["product_name"]) + "'" + ", " +

"'" + str(data["data"]["ingredients"]) + "'" + ", " +

"'" + str(data["data"]["serving_size"]) + "'" + ", " +

str(data["data"]["calories"]) + ", " +

str(data["data"]["total_fat_g"]) + ", " +

str(data["data"]["total_fat_percent"]) + ", " +

str(data["data"]["fat_saturated_g"]) + ", " +

str(data["data"]["fat_saturated_percent"]) + ", " +

str(data["data"]["fat_trans_g"]) + ", " +

str(data["data"]["fat_trans_percent"]) + ", " +

str(data["data"]["cholesterol_mg"]) + ", " +

str(data["data"]["sodium_mg"]) + ", " +

str(data["data"]["sodium_percent"]) + ", " +

str(data["data"]["carbo_g"]) + ", " +

str(data["data"]["carbo_percent"]) + ", " +

str(data["data"]["carbo_fibre_g"]) + ", " +

str(data["data"]["carbo_fibre_percent"]) + ", " +

str(data["data"]["carbo_sugars_g"]) + ", " +

str(data["data"]["protein_g"]) + ", " +

str(data["data"]["vitamin_a_percent"]) + ", " +

str(data["data"]["vitamin_c_percent"]) + ", " +

str(data["data"]["calcium_percent"]) + ", " +

str(data["data"]["iron_percent"]) + ", " +

"'" + str(data["data"]["micro_nutrients"]) + "'" + ", " +

"'" + str(data["data"]["tips"]) + "'" + ", " +

str(data["data"]["diet_id"]) + ", " +

"'" + str(data["data"]["diet_type"]) + "'" +

")")

我的CREATE TABLE声明：

^{pr2}$