如何遍历字典列表并插入到sqlite 3中

import sqlite3

conn = sqlite3.connect('database.db')

cursor = conn.cursor()

cursor.execute('''
    CREATE TABLE IF NOT EXISTS my_table (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        key1 TEXT,
        key2 INTEGER,
        key3 REAL
    )
''')

data = [
    {'key1': 'value1', 'key2': 123, 'key3': 3.14},
    {'key1': 'value2', 'key2': 456, 'key3': 2.71},
    # 可以继续添加更多的字典数据
]

for item in data:
    key1 = item['key1']
    key2 = item['key2']
    key3 = item['key3']
    
    cursor.execute('INSERT INTO my_table (key1, key2, key3) VALUES (?, ?, ?)', (key1, key2, key3))

conn.commit()
conn.close()