feat: multi-select and bulk-update category from catalog

1 files changed, 20 insertions, 1 deletions

diff --git a/src/lib/server/services/groceries.ts b/src/lib/server/services/groceries.ts
index db9e736..3c6de70 100644
--- a/src/lib/server/services/groceries.ts
+++ b/src/lib/server/services/groceries.ts
@@ -1,6 +1,6 @@
 import { db as defaultDb } from '$lib/server/db';
 import { groceries, categories, references } from '$lib/server/db/schema';
-import { eq, desc } from 'drizzle-orm';
+import { eq, desc, inArray } from 'drizzle-orm';
 import type { LibSQLDatabase } from 'drizzle-orm/libsql';
 import type * as schema from '$lib/server/db/schema';
 import type { Category, Grocery, Reference } from './types';
@@ -109,6 +109,25 @@ export async function updateGrocery(
 		.where(eq(groceries.id, id));
 }
 
+export async function updateGroceryCategory(
+	id: number,
+	categoryId: number | null,
+	db = defaultDb,
+): Promise<void> {
+	await db.update(groceries).set({ categoryId }).where(eq(groceries.id, id));
+}
+
+export async function bulkUpdateGroceryCategory(
+	ids: number[],
+	categoryId: number | null,
+	db = defaultDb,
+): Promise<void> {
+	await db
+		.update(groceries)
+		.set({ categoryId })
+		.where(inArray(groceries.id, ids));
+}
+
 export async function deleteGrocery(id: number, db = defaultDb): Promise<void> {
 	await db.delete(groceries).where(eq(groceries.id, id));
 }