如何利用sqlite进行撤消/重做功能？

import sqlite3

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

# 开始一个新的事务
conn.execute('BEGIN')

# 执行一些 SQL 操作
conn.execute('INSERT INTO my_table VALUES (?, ?)', (1, 'A'))
conn.execute('INSERT INTO my_table VALUES (?, ?)', (2, 'B'))

# 回滚事务，撤销所有操作
conn.execute('ROLLBACK')

# 提交事务，使更改生效
conn.execute('COMMIT')

conn.close()

import sqlite3
import shutil

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

# 备份数据库
shutil.copyfile('example.db', 'example_backup.db')

# 执行一些 SQL 操作
conn.execute('INSERT INTO my_table VALUES (?, ?)', (1, 'A'))
conn.execute('INSERT INTO my_table VALUES (?, ?)', (2, 'B'))

# 需要撤销时，还原备份
shutil.copyfile('example_backup.db', 'example.db')

conn.close()

import sqlite3

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

# 创建一个撤销日志表
conn.execute('CREATE TABLE IF NOT EXISTS undo_log (id INTEGER PRIMARY KEY, operation TEXT)')

# 执行一些 SQL 操作，并记录到撤销日志中
conn.execute('INSERT INTO my_table VALUES (?, ?)', (1, 'A'))
conn.execute('INSERT INTO undo_log VALUES (NULL, ?)', ('INSERT INTO my_table VALUES (1, "A")'))
conn.execute('INSERT INTO my_table VALUES (?, ?)', (2, 'B'))
conn.execute('INSERT INTO undo_log VALUES (NULL, ?)', ('INSERT INTO my_table VALUES (2, "B")'))

# 需要撤销时，按照相反的顺序执行撤销操作
for row in conn.execute('SELECT operation FROM undo_log ORDER BY id DESC'):
    conn.execute(f'{row[0]}')

# 清空撤销日志
conn.execute('DELETE FROM undo_log')

conn.close()