init_db

import sqlite3

# Connect to DB with autocommit mode
conn = sqlite3.connect("meal_ingredients.db", isolation_level=None)

# Ensure tables exist
conn.execute("PRAGMA foreign_keys = ON")
conn.execute("CREATE TABLE IF NOT EXISTS meals (name TEXT) STRICT")
conn.execute(
    """
CREATE TABLE IF NOT EXISTS ingredients (
    name TEXT,
    meal_id INTEGER,
    FOREIGN KEY(meal_id) REFERENCES meals(rowid)
) STRICT
"""
)

res = conn.execute("SELECT * FROM sqlite_schema WHERE name = 'meals'").fetchone()
print(res)