import { Database } from "bun:sqlite";
import { join } from "node:path";
import { drizzle } from "drizzle-orm/bun-sqlite";
import { migrate } from "drizzle-orm/bun-sqlite/migrator";

import { DB_FILE } from "@/utils/constants";

const sqlite = new Database(DB_FILE);
export const db = drizzle({ client: sqlite });

export async function migrateDb() {
	console.log("checking database migrations...");
	migrate(db, { migrationsFolder: join(process.cwd(), "drizzle") });
}

export * from "./schema";