import { DatabaseSync } from "node:sqlite";

const db = new DatabaseSync("recipes.db");

db.exec(`
    CREATE TABLE IF NOT EXISTS recipes (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        url TEXT,
        name TEXT NOT NULL,
        ingredients TEXT NOT NULL,
        imageUrl TEXT,
        createdAt DATETIME DEFAULT CURRENT_TIMESTAMP
    )
    `);

db.exec(`
    CREATE TABLE IF NOT EXISTS groceryLists (
        id INTEGER PRIMARY KEY AUTOINCREMENT,
        createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,
        recipeIds TEXT NOT NULL
    )`);

export default db;