From 6722589b515ccee267212cf783fc0ebbaa20cd90 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 27 Jul 2026 17:18:40 +0200 Subject: feat: catalog section + deduplicate items by name - Show all items split into List (unchecked) and Catalog (checked) sections - Tapping a catalog item unchecks it (returns to list) - Add action now upserts: unchecks existing item instead of creating duplicate - UNIQUE constraint on groceries.name as defense-in-depth - Tests for dedup behavior (insert, re-add from catalog, no-op on list) --- drizzle/0001_dear_bastion.sql | 1 + 1 file changed, 1 insertion(+) create mode 100644 drizzle/0001_dear_bastion.sql (limited to 'drizzle/0001_dear_bastion.sql') diff --git a/drizzle/0001_dear_bastion.sql b/drizzle/0001_dear_bastion.sql new file mode 100644 index 0000000..ecc896d --- /dev/null +++ b/drizzle/0001_dear_bastion.sql @@ -0,0 +1 @@ +CREATE UNIQUE INDEX `groceries_name_unique` ON `groceries` (`name`); \ No newline at end of file -- cgit v1.3