diff options
| author | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-07-27 16:54:28 +0200 |
|---|---|---|
| committer | Martin Kagamino Lehoux <martin@lehoux.net> | 2026-07-27 16:54:28 +0200 |
| commit | 71ca66bcba70f7a463df6ee9bdcb0e14b8e60595 (patch) | |
| tree | 6e962f0d8c3346fd871cb337f9c5a14e4c0f0a08 /src/routes/+page.server.ts | |
| parent | ed39c60ebc10efe2b644172e7c82f943c4fba3cc (diff) | |
feat: minimal grocery list — add items, check them off
- Groceries DB schema (id, name, checked, created_at) with Drizzle + libsql
- /+page.server.ts: load (unchecked items, newest first), add & toggle actions
- /+page.svelte: text input + Add button, item list with toggle buttons
- Mobile-first styling with scoped CSS classes
- AGENTS.md: project-specific rules including UI validation
Diffstat (limited to 'src/routes/+page.server.ts')
| -rw-r--r-- | src/routes/+page.server.ts | 53 |
1 files changed, 53 insertions, 0 deletions
diff --git a/src/routes/+page.server.ts b/src/routes/+page.server.ts new file mode 100644 index 0000000..e6f3b0f --- /dev/null +++ b/src/routes/+page.server.ts @@ -0,0 +1,53 @@ +import { fail } from '@sveltejs/kit'; +import { db } from '$lib/server/db'; +import { groceries } from '$lib/server/db/schema'; +import { eq, desc } from 'drizzle-orm'; +import type { Actions, PageServerLoad } from './$types'; + +export const load: PageServerLoad = async () => { + const items = await db + .select() + .from(groceries) + .where(eq(groceries.checked, false)) + .orderBy(desc(groceries.createdAt)); + + return { items }; +}; + +export const actions: Actions = { + add: async ({ request }) => { + const data = await request.formData(); + const name = data.get('name')?.toString().trim(); + + if (!name) { + return fail(400, { error: 'Name is required' }); + } + + await db.insert(groceries).values({ + name, + createdAt: new Date().toISOString(), + }); + + return { success: true }; + }, + + toggle: async ({ request }) => { + const data = await request.formData(); + const id = Number(data.get('id')); + + const [item] = await db + .select() + .from(groceries) + .where(eq(groceries.id, id)); + if (!item) { + return fail(404, { error: 'Item not found' }); + } + + await db + .update(groceries) + .set({ checked: !item.checked }) + .where(eq(groceries.id, id)); + + return { success: true }; + }, +}; |
