如何在使用sqlite3的插入过程中使用外键的当前值

import sqlite3

# 连接到数据库
conn = sqlite3.connect('your_database.db')
cursor = conn.cursor()

# 获取外键的当前值
cursor.execute("SELECT MAX(id) FROM other_table")
result = cursor.fetchone()
current_foreign_key = result[0]

# 插入数据，使用外键的当前值
insert_query = "INSERT INTO your_table (foreign_key_column, other_column) VALUES (?, ?)"
data = (current_foreign_key, "some_value")
cursor.execute(insert_query, data)

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