From 04fabf115ccea31ac504b06cc51d78423b697f60 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Tue, 28 Jul 2026 15:07:57 +0200 Subject: refactor: services layer, valibot validation, shared CSS utilities, aria labels, and drizzle migrate - Extract groceries/categories/references services with db injection - Add valibot for form validation and safe numeric id parsing - Fix category delete FK behavior with onDelete: set null + migration - Replace custom migrate.js with drizzle-orm/libsql/migrator - Add shared CSS utility classes in app.css (forms, lists, buttons) - Add aria-pressed and aria-label on interactive elements - Remove redundant app.css imports and unused /stores import - Add integration tests for all services using drizzle migrate helper - Remove smoke test; add db:migrate and db:studio scripts --- scripts/migrate.js | 21 +++++---------------- 1 file changed, 5 insertions(+), 16 deletions(-) (limited to 'scripts') diff --git a/scripts/migrate.js b/scripts/migrate.js index dee9411..656c752 100644 --- a/scripts/migrate.js +++ b/scripts/migrate.js @@ -1,22 +1,11 @@ import { createClient } from '@libsql/client'; -import { readdirSync, readFileSync } from 'node:fs'; -import { join } from 'node:path'; +import { drizzle } from 'drizzle-orm/libsql'; +import { migrate } from 'drizzle-orm/libsql/migrator'; const dbUrl = process.env.DATABASE_URL ?? 'file:./data/data.db'; const client = createClient({ url: dbUrl }); +const db = drizzle(client); -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.`); +await migrate(db, { migrationsFolder: './drizzle' }); +console.log('Migrations applied successfully'); client.close(); -- cgit v1.3