如何用Python解析XML并存入SQLite数据库

<library>
  <book id="1">
    <title>Python编程</title>
    <author>张三</author>
    <price>59.9</price>
  </book>
  <book id="2">
    <title>数据结构</title>
    <author>李四</author>
    <price>45.5</price>
  </book>
</library>

import xml.etree.ElementTree as ET

tree = ET.parse("books.xml")
root = tree.getroot()

books = []
for book in root.findall("book"):
    books.append({
        "id": book.get("id"),
        "title": book.find("title").text if book.find("title") is not None else None,
        "author": book.find("author").text if book.find("author") is not None else None,
        "price": float(book.find("price").text) if book.find("price") is not None else None,
    })

import sqlite3

conn = sqlite3.connect("library.db")
cursor = conn.cursor()

cursor.execute("""
    CREATE TABLE IF NOT EXISTS books (
        id TEXT PRIMARY KEY,
        title TEXT,
        author TEXT,
        price REAL
    )
""")

cursor.executemany(
    "INSERT OR REPLACE INTO books (id, title, author, price) VALUES (?, ?, ?, ?)",
    [(b["id"], b["title"], b["author"], b["price"]) for b in books]
)

conn.commit()
conn.close()