From 04fabf115ccea31ac504b06cc51d78423b697f60 Mon Sep 17 00:00:00 2001
From: Martin Kagamino Lehoux <martin@lehoux.net>
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/services/references.ts | 38 +++++++++++++++++++++++++++++++++++
 1 file changed, 38 insertions(+)
 create mode 100644 src/lib/server/services/references.ts

(limited to 'src/lib/server/services/references.ts')

diff --git a/src/lib/server/services/references.ts b/src/lib/server/services/references.ts
new file mode 100644
index 0000000..99ba487
--- /dev/null
+++ b/src/lib/server/services/references.ts
@@ -0,0 +1,38 @@
+import { db as defaultDb } from '$lib/server/db';
+import { references } from '$lib/server/db/schema';
+import { eq, desc } from 'drizzle-orm';
+import type { AppDatabase } from './groceries';
+import type { Reference } from './types';
+
+export async function loadForGrocery(
+	groceryId: number,
+	db = defaultDb,
+): Promise<Reference[]> {
+	return db
+		.select()
+		.from(references)
+		.where(eq(references.groceryId, groceryId))
+		.orderBy(desc(references.qualityScore));
+}
+
+export async function add(
+	groceryId: number,
+	reference: string,
+	price: number | null,
+	unit: string | null,
+	qualityScore: number | null,
+	db = defaultDb,
+): Promise<Reference> {
+	const [inserted] = await db
+		.insert(references)
+		.values({ groceryId, reference, price, unit, qualityScore })
+		.returning();
+	return inserted;
+}
+
+export async function deleteReference(
+	id: number,
+	db = defaultDb,
+): Promise<void> {
+	await db.delete(references).where(eq(references.id, id));
+}
-- 
cgit v1.3