如何从数据库的XML列中删除节点

import xml.etree.ElementTree as ET
import psycopg2

# 连接到数据库
conn = psycopg2.connect(database="your_database", user="your_username", password="your_password", host="your_host", port="your_port")
cur = conn.cursor()

# 从数据库中获取XML数据
cur.execute("SELECT xml_column FROM your_table WHERE id = your_id")
xml_data = cur.fetchone()[0]

# 解析XML数据
root = ET.fromstring(xml_data)

# 定位要删除的节点
node_to_delete = root.find("path/to/node")

# 删除节点
if node_to_delete is not None:
    root.remove(node_to_delete)

# 更新数据库
updated_xml_data = ET.tostring(root, encoding="unicode")
cur.execute("UPDATE your_table SET xml_column = %s WHERE id = your_id", (updated_xml_data,))

# 提交事务并关闭连接
conn.commit()
cur.close()
conn.close()