python解析包含多个元素的XML并插入到sqlite中

import xml.etree.ElementTree as ET
import sqlite3

conn = sqlite3.connect('database.db')
cursor = conn.cursor()
cursor.execute('''CREATE TABLE IF NOT EXISTS xml_data (id INTEGER PRIMARY KEY AUTOINCREMENT, element TEXT)''')

tree = ET.parse('xml_file.xml')
root = tree.getroot()

for element in root.iter():
    cursor.execute("INSERT INTO xml_data (element) VALUES (?)", (element.text,))

conn.commit()
conn.close()