home-sveltekit/src/lib/server/services/references.ts, branch mainUnnamed repository; edit this file 'description' to name the repository.
https://git.kagamino.dev/home-sveltekit/atom?h=main2026-10-05T22:46:53Zfix: make grocery and reference ordering deterministic2026-10-05T22:46:53ZMartin Kagamino Lehouxmartin@lehoux.net2026-10-05T22:46:53Zurn:sha1:c915f91fbe8d97201d813c792f4e1fe8c4401e15
Every list query lacked a tiebreak, so rows sharing a sort key (same-ms
createdAt inserts, tied or NULL quality scores) came back in unspecified
order and bestRef flipped between loads. Add explicit tiebreaks: items
createdAt desc, id desc (newest first); references qualityScore desc,
id asc (first inserted wins ties). Categories were already total
(order, name unique).
Pin the rules with service tests.
refactor: services layer, valibot validation, shared CSS utilities, aria labels, and drizzle migrate2026-07-28T13:07:57ZMartin Kagamino Lehouxmartin@lehoux.net2026-07-28T13:07:57Zurn:sha1:04fabf115ccea31ac504b06cc51d78423b697f60
- 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