From e075698891d653330b5d5d0f80c2c3495aee6262 Mon Sep 17 00:00:00 2001 From: Martin Kagamino Lehoux Date: Mon, 27 Jul 2026 19:53:11 +0200 Subject: feat: product references + grocery detail page MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit - references table (brand, price, unit, quality_score) with FK to groceries - /grocery/[id] page for managing references per item - Unit dropdown (€/kg, €/L, €/u) defaulting to €/kg - → link on all items navigates to detail page - Delete item moved from catalog to detail page --- drizzle/0001_dry_meteorite.sql | 9 ++ drizzle/meta/0001_snapshot.json | 172 ++++++++++++++++++++++ drizzle/meta/_journal.json | 7 + eslint.config.js | 1 + src/lib/server/db/schema.ts | 13 +- src/routes/+page.server.ts | 9 -- src/routes/+page.svelte | 32 ++-- src/routes/grocery/[id]/+page.server.ts | 71 +++++++++ src/routes/grocery/[id]/+page.svelte | 253 ++++++++++++++++++++++++++++++++ 9 files changed, 539 insertions(+), 28 deletions(-) create mode 100644 drizzle/0001_dry_meteorite.sql create mode 100644 drizzle/meta/0001_snapshot.json create mode 100644 src/routes/grocery/[id]/+page.server.ts create mode 100644 src/routes/grocery/[id]/+page.svelte diff --git a/drizzle/0001_dry_meteorite.sql b/drizzle/0001_dry_meteorite.sql new file mode 100644 index 0000000..ae22f4b --- /dev/null +++ b/drizzle/0001_dry_meteorite.sql @@ -0,0 +1,9 @@ +CREATE TABLE `references` ( + `id` integer PRIMARY KEY AUTOINCREMENT NOT NULL, + `grocery_id` integer NOT NULL, + `brand` text NOT NULL, + `price` real, + `unit` text, + `quality_score` integer, + FOREIGN KEY (`grocery_id`) REFERENCES `groceries`(`id`) ON UPDATE no action ON DELETE cascade +); diff --git a/drizzle/meta/0001_snapshot.json b/drizzle/meta/0001_snapshot.json new file mode 100644 index 0000000..21f509e --- /dev/null +++ b/drizzle/meta/0001_snapshot.json @@ -0,0 +1,172 @@ +{ + "version": "6", + "dialect": "sqlite", + "id": "52dffa39-fdb4-4a7c-8688-136e0ad485fc", + "prevId": "54c7ae45-9838-4ffb-ad46-29995def7272", + "tables": { + "categories": { + "name": "categories", + "columns": { + "id": { + "name": "id", + "type": "integer", + "primaryKey": true, + "notNull": true, + "autoincrement": true + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + } + }, + "indexes": { + "categories_name_unique": { + "name": "categories_name_unique", + "columns": ["name"], + "isUnique": true + } + }, + "foreignKeys": {}, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "checkConstraints": {} + }, + "groceries": { + "name": "groceries", + "columns": { + "id": { + "name": "id", + "type": "integer", + "primaryKey": true, + "notNull": true, + "autoincrement": true + }, + "name": { + "name": "name", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "checked": { + "name": "checked", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false, + "default": false + }, + "created_at": { + "name": "created_at", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "category_id": { + "name": "category_id", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": { + "groceries_name_unique": { + "name": "groceries_name_unique", + "columns": ["name"], + "isUnique": true + } + }, + "foreignKeys": { + "groceries_category_id_categories_id_fk": { + "name": "groceries_category_id_categories_id_fk", + "tableFrom": "groceries", + "tableTo": "categories", + "columnsFrom": ["category_id"], + "columnsTo": ["id"], + "onDelete": "no action", + "onUpdate": "no action" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "checkConstraints": {} + }, + "references": { + "name": "references", + "columns": { + "id": { + "name": "id", + "type": "integer", + "primaryKey": true, + "notNull": true, + "autoincrement": true + }, + "grocery_id": { + "name": "grocery_id", + "type": "integer", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "brand": { + "name": "brand", + "type": "text", + "primaryKey": false, + "notNull": true, + "autoincrement": false + }, + "price": { + "name": "price", + "type": "real", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "unit": { + "name": "unit", + "type": "text", + "primaryKey": false, + "notNull": false, + "autoincrement": false + }, + "quality_score": { + "name": "quality_score", + "type": "integer", + "primaryKey": false, + "notNull": false, + "autoincrement": false + } + }, + "indexes": {}, + "foreignKeys": { + "references_grocery_id_groceries_id_fk": { + "name": "references_grocery_id_groceries_id_fk", + "tableFrom": "references", + "tableTo": "groceries", + "columnsFrom": ["grocery_id"], + "columnsTo": ["id"], + "onDelete": "cascade", + "onUpdate": "no action" + } + }, + "compositePrimaryKeys": {}, + "uniqueConstraints": {}, + "checkConstraints": {} + } + }, + "views": {}, + "enums": {}, + "_meta": { + "schemas": {}, + "tables": {}, + "columns": {} + }, + "internal": { + "indexes": {} + } +} diff --git a/drizzle/meta/_journal.json b/drizzle/meta/_journal.json index 2923632..9872346 100644 --- a/drizzle/meta/_journal.json +++ b/drizzle/meta/_journal.json @@ -8,6 +8,13 @@ "when": 1785169427572, "tag": "0000_youthful_mercury", "breakpoints": true + }, + { + "idx": 1, + "version": "6", + "when": 1785170535526, + "tag": "0001_dry_meteorite", + "breakpoints": true } ] } diff --git a/eslint.config.js b/eslint.config.js index e49e39f..060a8a7 100644 --- a/eslint.config.js +++ b/eslint.config.js @@ -7,6 +7,7 @@ export default [ { rules: { 'svelte/no-at-html-tags': 'off', + 'svelte/no-navigation-without-resolve': 'off', }, }, { diff --git a/src/lib/server/db/schema.ts b/src/lib/server/db/schema.ts index 1d5fd9e..9cd6af8 100644 --- a/src/lib/server/db/schema.ts +++ b/src/lib/server/db/schema.ts @@ -1,4 +1,4 @@ -import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core'; +import { sqliteTable, text, integer, real } from 'drizzle-orm/sqlite-core'; export const categories = sqliteTable('categories', { id: integer('id').primaryKey({ autoIncrement: true }), @@ -12,3 +12,14 @@ export const groceries = sqliteTable('groceries', { createdAt: text('created_at').notNull(), categoryId: integer('category_id').references(() => categories.id), }); + +export const references = sqliteTable('references', { + id: integer('id').primaryKey({ autoIncrement: true }), + groceryId: integer('grocery_id') + .notNull() + .references(() => groceries.id, { onDelete: 'cascade' }), + brand: text('brand').notNull(), + price: real('price'), + unit: text('unit'), + qualityScore: integer('quality_score'), +}); diff --git a/src/routes/+page.server.ts b/src/routes/+page.server.ts index e77b27f..6d547e6 100644 --- a/src/routes/+page.server.ts +++ b/src/routes/+page.server.ts @@ -75,13 +75,4 @@ export const actions: Actions = { return { success: true }; }, - - delete: async ({ request }) => { - const data = await request.formData(); - const id = Number(data.get('id')); - - await db.delete(groceries).where(eq(groceries.id, id)); - - return { success: true }; - }, }; diff --git a/src/routes/+page.svelte b/src/routes/+page.svelte index 9490a51..64c8410 100644 --- a/src/routes/+page.svelte +++ b/src/routes/+page.svelte @@ -57,10 +57,11 @@

{cat}

@@ -84,15 +85,7 @@ - + → {/each} @@ -191,20 +184,23 @@ align-items: center; } - .catalog-item .delete-btn { - border: 1px solid #e0e0e0; - border-radius: 0.5rem; - background: #fff; - color: #d00; - transition: background 0.15s; + .ref-link { width: 2rem; + aspect-ratio: 1; display: flex; align-items: center; justify-content: center; + border: 1px solid #e0e0e0; + border-radius: 0.5rem; + background: #fff; + color: #333; + text-decoration: none; + font-size: 1rem; + transition: background 0.15s; } - .catalog-item .delete-btn:hover { - background: #fee; + .ref-link:hover { + background: #f5f5f5; } .empty { diff --git a/src/routes/grocery/[id]/+page.server.ts b/src/routes/grocery/[id]/+page.server.ts new file mode 100644 index 0000000..88aa137 --- /dev/null +++ b/src/routes/grocery/[id]/+page.server.ts @@ -0,0 +1,71 @@ +import { error, fail, redirect } from '@sveltejs/kit'; +import { db } from '$lib/server/db'; +import { groceries, categories, references } from '$lib/server/db/schema'; +import { eq } from 'drizzle-orm'; +import type { Actions, PageServerLoad } from './$types'; + +export const load: PageServerLoad = async ({ params }) => { + const id = Number(params.id); + + const [item] = await db.select().from(groceries).where(eq(groceries.id, id)); + if (!item) throw error(404, 'Item not found'); + + const [cat] = item.categoryId + ? await db + .select() + .from(categories) + .where(eq(categories.id, item.categoryId)) + : [null]; + + const refs = await db + .select() + .from(references) + .where(eq(references.groceryId, id)); + + return { + item: { + ...item, + categoryName: cat?.name ?? null, + }, + references: refs, + }; +}; + +export const actions: Actions = { + add: async ({ request, params }) => { + const data = await request.formData(); + const brand = data.get('brand')?.toString().trim(); + const price = data.get('price')?.toString().trim(); + const unit = data.get('unit')?.toString().trim(); + const qualityScore = data.get('quality_score')?.toString().trim(); + + if (!brand) { + return fail(400, { error: 'Brand is required' }); + } + + await db.insert(references).values({ + groceryId: Number(params.id), + brand, + price: price ? Number(price) : null, + unit: unit || null, + qualityScore: qualityScore ? Number(qualityScore) : null, + }); + + return { success: true }; + }, + + delete: async ({ request }) => { + const data = await request.formData(); + const id = Number(data.get('id')); + + await db.delete(references).where(eq(references.id, id)); + + return { success: true }; + }, + + deleteItem: async ({ params }) => { + await db.delete(groceries).where(eq(groceries.id, Number(params.id))); + + throw redirect(303, '/'); + }, +}; diff --git a/src/routes/grocery/[id]/+page.svelte b/src/routes/grocery/[id]/+page.svelte new file mode 100644 index 0000000..15c4e8b --- /dev/null +++ b/src/routes/grocery/[id]/+page.svelte @@ -0,0 +1,253 @@ + + +

{data.item.name}

+ +{#if data.item.categoryName} +

{data.item.categoryName}

+{/if} + +
+ +

References

+ +
+ +
+ + + +
+ +
+ +{#if form?.error} +

{form.error}

+{/if} + +
+ +
+ +{#if (data?.references?.length ?? 0) === 0} +

No references yet

+{/if} + +
+ +
+ +← Back to list + + -- cgit v1.3