可以从SQLite CLI使用这些回调…
仔细阅读SQLite源代码，看起来该功能似乎未在CLI源代码中的任何地方使用，因此我怀疑您可以通过CLI来完成此工作。
…或者来自Bash …
不知道那是什么意思。
…或来自Python？
它不是通过标准
sqlite3模块公开的，但是可以与
ctypes模块一起使用。
如果是这样，怎么办？
这是一个通过
ctypes…使用它的快速示例。
from ctypes import *# Define some symbolsSQLITE_DELETE = 9SQLITE_INSERT = 18SQLITE_UPDATE = 23# Define our callback function## 'user_data' will be the third param passed to sqlite3_update_hook# 'operation' will be one of: SQLITE_DELETE, SQLITE_INSERT, or SQLITE_UPDATE# 'db name' will be the name of the affected database# 'table_name' will be the name of the affected table# 'row_id' will be the ID of the affected rowdef callback(user_data, operation, db_name, table_name, row_id): if operation == SQLITE_DELETE: optext = 'Deleted row' elif operation == SQLITE_INSERT: optext = 'Inserted row' elif operation == SQLITE_UPDATE: optext = 'Updated row' else: optext = 'Unknown operation on row' s = '%s %ld of table "%s" in database "%s"' % (optext, row_id, table_name, db_name) print(s)# Translate into a ctypes callbackc_callback = CFUNCTYPE(c_void_p, c_void_p, c_int, c_char_p, c_char_p, c_int64)(callback)# Load sqlite3dll = CDLL('libsqlite3.so')# Holds a pointer to the database connectiondb = c_void_p()# Open a connection to 'test.db'dll.sqlite3_open('test.db', byref(db))# Register callbackdll.sqlite3_update_hook(db, c_callback, None)# Create a variable to hold error messageserr = c_char_p()# Now execute some SQLdll.sqlite3_exec(db, b'create table foo (id int, name varchar(255))', None, None, byref(err))if err: print(err.value)dll.sqlite3_exec(db, b'insert into foo values (1, "Bob")', None, None, byref(err))if err: print(err.value)…打印出来…
Inserted row 1 of table "foo" in database "main"
在第一次运行中
table foo already existsInserted row 2 of table "foo" in database "main"
在第二轮
