如何使用sqllite在pytest中启用外键检查

import sqlite3
import pytest

@pytest.fixture
def db_connection():
    conn = sqlite3.connect(":memory:")
    conn.execute("PRAGMA foreign_keys = ON")
    yield conn
    conn.close()

def test_foreign_key(db_connection):
    cursor = db_connection.cursor()
    cursor.execute("CREATE TABLE users (id INTEGER PRIMARY KEY, name TEXT)")
    cursor.execute("CREATE TABLE orders (id INTEGER PRIMARY KEY, user_id INTEGER, FOREIGN KEY(user_id) REFERENCES users(id))")
    cursor.execute("INSERT INTO users (id, name) VALUES (1, 'John')")
    cursor.execute("INSERT INTO orders (id, user_id) VALUES (1, 1)")
    db_connection.commit()
    cursor.execute("SELECT * FROM orders")
    result = cursor.fetchone()
    assert result[1] == 1

pytest test_sqlite.py