传入一个字典，python sqlite根据字典key和value插入的代码

import sqlite3def insert_dict_to_sqlite(dict_data, table_name):conn = sqlite3.connect('example.db')c = conn.cursor()columns = ', '.join(dict_data.keys())placeholders = ':'+', :'...

御坂10057

209人浏览 · 2023-01-19 23:48:38

御坂10057 · 2023-01-19 23:48:38 发布

import sqlite3

def insert_dict_to_sqlite(dict_data, table_name):
    conn = sqlite3.connect('example.db')
    c = conn.cursor()

    columns = ', '.join(dict_data.keys())
    placeholders = ':'+', :'.join(dict_data.keys())
    query = f'INSERT INTO {table_name} ({columns}) VALUES ({placeh