From 329ab5a990df5e460afa31094e5e827c9743565b Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
Date: Mon, 27 Jul 2026 21:17:55 +0200
Subject: feat: production Docker image with health check and data persistence

- Non-root user (node), data volume at /app/data
- Startup migration script applies drizzle SQL before server starts
- HEALTHCHECK on port 3000 every 30s
---
 scripts/migrate.js | 22 ++++++++++++++++++++++
 1 file changed, 22 insertions(+)
 create mode 100644 scripts/migrate.js

(limited to 'scripts')

diff --git a/scripts/migrate.js b/scripts/migrate.js
new file mode 100644
index 0000000..dee9411
--- /dev/null
+++ b/scripts/migrate.js
@@ -0,0 +1,22 @@
+import { createClient } from '@libsql/client';
+import { readdirSync, readFileSync } from 'node:fs';
+import { join } from 'node:path';
+
+const dbUrl = process.env.DATABASE_URL ?? 'file:./data/data.db';
+const client = createClient({ url: dbUrl });
+
+const dir = '/app/drizzle';
+const files = readdirSync(dir)
+	.filter((f) => f.endsWith('.sql'))
+	.sort();
+
+for (const file of files) {
+	const sql = readFileSync(join(dir, file), 'utf8');
+	const stmts = sql.split('--> statement-breakpoint').filter(Boolean);
+	for (const stmt of stmts) {
+		await client.execute(stmt);
+	}
+}
+
+console.log(`${files.length} migration(s) applied.`);
+client.close();
-- 
cgit v1.3