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 --- src/lib/server/db/test-helper.ts | 13 +++++++++++++ 1 file changed, 13 insertions(+) create mode 100644 src/lib/server/db/test-helper.ts (limited to 'src/lib/server/db/test-helper.ts') diff --git a/src/lib/server/db/test-helper.ts b/src/lib/server/db/test-helper.ts new file mode 100644 index 0000000..5bae681 --- /dev/null +++ b/src/lib/server/db/test-helper.ts @@ -0,0 +1,13 @@ +import { createClient } from '@libsql/client'; +import { drizzle } from 'drizzle-orm/libsql'; +import { migrate } from 'drizzle-orm/libsql/migrator'; +import * as schema from './schema'; + +export async function createTestDb() { + const client = createClient({ url: ':memory:' }); + const db = drizzle(client, { schema }); + + await migrate(db, { migrationsFolder: './drizzle' }); + + return { db, client }; +} -- cgit v1.3