home-sveltekit/src/lib/server/services/groceries.test.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.
Consolidate duplicated page CSS into app.css, share TestDb type2026-09-08T07:12:25ZMartin Kagamino Lehouxmartin@lehoux.net2026-09-08T07:12:25Zurn:sha1:7d85a18867ca0fe2310218c63cfc696c0f916171
- Move .page-header/.back-link/.input-invalid/.save-status/.btn-done
(plus hover/variant rules) into app.css as shared route scaffolding;
delete per-page scoped copies
- Unify drifted values: page-header padding 1rem -> 1.25rem (routine
page), empty-state spacing 0.75/1.5rem -> 1/2rem (grocery detail),
save-status margin -0.25rem applied on both pages, back-link margin
1.5rem -> 1rem (grocery detail); routine page's large Fait button is
kept via a .btn-done-lg modifier
- Export TestDb from test-helper and use it in the five db/service
test files to shrink duplicated fixture scaffolding
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