home-sveltekit/src/lib/server/services/groceries.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.
Migrate date handling from Date to Temporal API2026-09-08T15:06:51ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-08T15:06:51Zurn:sha1:bd2f982c489b15ce1165c051fdedf35af979f784
Routine scheduling, health series, service stamps, session expiry, and
date formatting move to native Temporal (Instant / ZonedDateTime in
UTC), with ISO strings kept at DB and chart boundaries. Ambient types
in src/temporal-ambient.d.ts cover the native runtime; no polyfill.
Observable behavior and stored formats are unchanged.
feat: drag-to-reorder categories with persistent order2026-07-29T13:01:38ZMartin Kagamino Lehouxmartin@lehoux.net2026-07-29T13:01:38Zurn:sha1:63e003a718782e2ca3ffcb2d11b0be97560a7259feat: multi-select and bulk-update category from catalog2026-07-29T08:31:36ZMartin Kagamino Lehouxmartin@lehoux.net2026-07-29T08:31:36Zurn:sha1:684d3c954e3577a6488101bf5ee85e36439fd53cfeat: editable name and category in grocery detail page2026-07-28T13:29:32ZMartin Kagamino Lehouxmartin@lehoux.net2026-07-28T13:29:32Zurn:sha1:db2f142aaf98ba36d1e9b17ce8a4299268d1b69brefactor: 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