import { Database } from "bun:sqlite";

// all of these do the same thing
const db = new Database("mydb.sqlite");
createTable();

function createTable() {
  db.run(`
    CREATE TABLE IF NOT EXISTS images (
      id INTEGER PRIMARY KEY AUTOINCREMENT,
      image BLOB,
      type TEXT
    );
  `);
}

export const query_getImages = db.query(`SELECT id, type FROM images`);

export const query_getImage = db.query(
  `SELECT image, type FROM images WHERE id = $id`,
);

export const query_saveImage = db.query(
  `INSERT INTO images (image, type) VALUES ($image, $type) RETURNING id`,
);