Files
gerbeur/api/db/init.ts
khannurien 3d03c9e69c
All checks were successful
Build and Publish Docker Image / build-and-push (push) Successful in 39s
v3: fixed docker image, updated locales
2026-06-21 14:38:17 +00:00

15 lines
428 B
TypeScript

import { DatabaseSync } from "node:sqlite";
import { DB_PATH } from "../config.ts";
try {
await Deno.stat(DB_PATH);
console.log("Database already exists, skipping initialization.");
} catch {
console.log("Initializing database from schema...");
const schema = Deno.readTextFileSync("api/db/schema.sql");
const db = new DatabaseSync(DB_PATH);
db.exec(schema);
db.close();
console.log("Database initialized.");
}