[{"_1":2,"_181":-5,"_182":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","7c5bc882bceb0a55efc9fc584fee6b89303eee47","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_156":157,"_178":179,"_180":-5},"handle","arfan","name","family-hub","path","backend/database.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":74,"_112":-5,"_12":113,"_114":-5,"_115":20,"_116":-5,"_117":-5,"_118":33,"_14":119,"_120":121,"_122":123,"_124":-5,"_125":126,"_127":126,"_128":129,"_130":129,"_131":129,"_132":126,"_133":126,"_23":134,"_137":138,"_142":143,"_155":20},"id","80288642-2053-11f1-97de-42dde27851f2","createdAt",["D",1773567842966],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","1601447d-3c17-4580-a190-f6b82a1eb8e2","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","8789b31e-4477-4b2d-ae0d-cc5f2132061a","tursoName","80288642205311f197de42dde27851f2","tursoHostname","80288642205311f197de42dde27851f2-val-town.aws-us-east-2.turso.io","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_135":136},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ3WWZ5Sm91SWx1eXRNRTZDazIwbnFiUVV4WiJ9","org",{"_95":96,"_139":136,"_12":113,"_140":141},"avatar","tier","pro","branch",{"_144":145,"_97":45,"_103":146,"_147":104,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":98,"_154":96},"version",27,"8028e3bc-2053-11f1-97de-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":158,"_97":159,"_160":161,"_162":163,"_164":146,"_165":166,"_167":168,"_105":169,"_144":33,"_170":171,"_172":173,"_174":20,"_175":-5,"_99":176},"75c014d0-2054-11f1-9cb0-42dde27851f2","database.ts","fileId","75c01692-2054-11f1-9cb0-42dde27851f2","parentId","752ccd9c-2054-11f1-9d71-42dde27851f2","branchId","branchVersion",20,"latest",true,["D",1773568254961],"fileType","script","content","// Database layer - all 7 tables with user_email scoping\n\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport { TABLES } from \"../shared/constants.ts\";\nimport type {\n CalendarEvent,\n Todo,\n Meal,\n GroceryItem,\n Reminder,\n Activity,\n} from \"../shared/types.ts\";\n\n// --- Helpers ---\n\nfunction mapRowToObject(row: any[], columns: string[]): any {\n if (!row) return null;\n const obj: any = {};\n columns.forEach((col, i) => {\n obj[col] = row[i];\n });\n return obj;\n}\n\nfunction mapRows(result: { rows: any[][]; columns: string[] }): any[] {\n return result.rows.map((row) => mapRowToObject(row, result.columns));\n}\n\n// --- Init ---\n\nexport async function initDatabase() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.events} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL,\n date TEXT NOT NULL,\n start_time TEXT DEFAULT '',\n end_time TEXT DEFAULT '',\n category TEXT DEFAULT 'family',\n notes TEXT DEFAULT ''\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_events_user ON ${TABLES.events}(user_email)`,\n );\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.todos} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL,\n priority TEXT DEFAULT 'medium',\n completed BOOLEAN DEFAULT 0,\n due_date TEXT DEFAULT ''\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_todos_user ON ${TABLES.todos}(user_email)`,\n );\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.meals} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n week_start TEXT DEFAULT '',\n day_of_week INTEGER NOT NULL,\n meal_type TEXT NOT NULL,\n name TEXT NOT NULL,\n category TEXT DEFAULT ''\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_meals_user ON ${TABLES.meals}(user_email)`,\n );\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.groceries} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n name TEXT NOT NULL,\n category TEXT DEFAULT 'Produce',\n quantity TEXT DEFAULT '1',\n purchased BOOLEAN DEFAULT 0\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_groceries_user ON ${TABLES.groceries}(user_email)`,\n );\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.reminders} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n title TEXT NOT NULL,\n date TEXT NOT NULL,\n time TEXT DEFAULT '',\n completed BOOLEAN DEFAULT 0\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_reminders_user ON ${TABLES.reminders}(user_email)`,\n );\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLES.activities} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_email TEXT NOT NULL,\n child_name TEXT NOT NULL,\n activity_name TEXT NOT NULL,\n duration_minutes INTEGER DEFAULT 0,\n date TEXT DEFAULT '',\n category TEXT DEFAULT ''\n )\n `);\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_activities_user ON ${TABLES.activities}(user_email)`,\n );\n}\n\n// --- Generic CRUD helpers ---\n\nasync function listItems(table: string, userEmail: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT * FROM ${table} WHERE user_email = ? ORDER BY id DESC`,\n args: [userEmail],\n });\n return mapRows(result) as T[];\n}\n\nasync function createItem(\n table: string,\n userEmail: string,\n columns: string[],\n values: any[],\n): Promise {\n const placeholders = columns.map(() => \"?\").join(\", \");\n const result = await sqlite.execute({\n sql: `INSERT INTO ${table} (user_email, ${columns.join(\", \")}) VALUES (?, ${placeholders})`,\n args: [userEmail, ...values],\n });\n\n const created = await sqlite.execute({\n sql: `SELECT * FROM ${table} WHERE id = ?`,\n args: [Number(result.lastInsertRowid)],\n });\n return mapRows(created)[0];\n}\n\nasync function updateItem(\n table: string,\n userEmail: string,\n id: number,\n updates: Record,\n): Promise {\n const entries = Object.entries(updates).filter(\n ([k]) => k !== \"id\" && k !== \"user_email\",\n );\n if (entries.length === 0) return null;\n\n const setParts = entries.map(([k]) => `${k} = ?`);\n const args = [...entries.map(([, v]) => v), id, userEmail];\n\n await sqlite.execute({\n sql: `UPDATE ${table} SET ${setParts.join(\", \")} WHERE id = ? AND user_email = ?`,\n args,\n });\n\n const updated = await sqlite.execute({\n sql: `SELECT * FROM ${table} WHERE id = ? AND user_email = ?`,\n args: [id, userEmail],\n });\n return updated.rows[0] ? mapRows(updated)[0] : null;\n}\n\nasync function deleteItem(\n table: string,\n userEmail: string,\n id: number,\n): Promise {\n const result = await sqlite.execute({\n sql: `DELETE FROM ${table} WHERE id = ? AND user_email = ?`,\n args: [id, userEmail],\n });\n return (result.rowsAffected ?? 0) > 0;\n}\n\n// --- Events ---\n\nexport function listEvents(email: string) {\n return listItems(TABLES.events, email);\n}\n\nexport function createEvent(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.events,\n email,\n [\"title\", \"date\", \"start_time\", \"end_time\", \"category\", \"notes\"],\n [data.title, data.date, data.start_time || \"\", data.end_time || \"\", data.category || \"family\", data.notes || \"\"],\n );\n}\n\nexport function updateEvent(email: string, id: number, updates: Partial) {\n return updateItem(TABLES.events, email, id, updates);\n}\n\nexport function deleteEvent(email: string, id: number) {\n return deleteItem(TABLES.events, email, id);\n}\n\n// --- Todos ---\n\nexport function listTodos(email: string) {\n return listItems(TABLES.todos, email);\n}\n\nexport function createTodo(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.todos,\n email,\n [\"title\", \"priority\", \"completed\", \"due_date\"],\n [data.title, data.priority || \"medium\", data.completed ? 1 : 0, data.due_date || \"\"],\n );\n}\n\nexport function updateTodo(email: string, id: number, updates: Partial) {\n const mapped: Record = {};\n if (updates.title !== undefined) mapped.title = updates.title;\n if (updates.priority !== undefined) mapped.priority = updates.priority;\n if (updates.completed !== undefined) mapped.completed = updates.completed ? 1 : 0;\n if (updates.due_date !== undefined) mapped.due_date = updates.due_date;\n return updateItem(TABLES.todos, email, id, mapped);\n}\n\nexport function deleteTodo(email: string, id: number) {\n return deleteItem(TABLES.todos, email, id);\n}\n\n// --- Meals ---\n\nexport function listMeals(email: string) {\n return listItems(TABLES.meals, email);\n}\n\nexport function createMeal(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.meals,\n email,\n [\"week_start\", \"day_of_week\", \"meal_type\", \"name\", \"category\"],\n [data.week_start || \"\", data.day_of_week, data.meal_type, data.name, data.category || \"\"],\n );\n}\n\nexport function updateMeal(email: string, id: number, updates: Partial) {\n return updateItem(TABLES.meals, email, id, updates);\n}\n\nexport function deleteMeal(email: string, id: number) {\n return deleteItem(TABLES.meals, email, id);\n}\n\n// --- Groceries ---\n\nexport function listGroceries(email: string) {\n return listItems(TABLES.groceries, email);\n}\n\nexport function createGrocery(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.groceries,\n email,\n [\"name\", \"category\", \"quantity\", \"purchased\"],\n [data.name, data.category || \"Produce\", data.quantity || \"1\", data.purchased ? 1 : 0],\n );\n}\n\nexport function updateGrocery(email: string, id: number, updates: Partial) {\n const mapped: Record = {};\n if (updates.name !== undefined) mapped.name = updates.name;\n if (updates.category !== undefined) mapped.category = updates.category;\n if (updates.quantity !== undefined) mapped.quantity = updates.quantity;\n if (updates.purchased !== undefined) mapped.purchased = updates.purchased ? 1 : 0;\n return updateItem(TABLES.groceries, email, id, mapped);\n}\n\nexport function deleteGrocery(email: string, id: number) {\n return deleteItem(TABLES.groceries, email, id);\n}\n\n// --- Reminders ---\n\nexport function listReminders(email: string) {\n return listItems(TABLES.reminders, email);\n}\n\nexport function createReminder(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.reminders,\n email,\n [\"title\", \"date\", \"time\", \"completed\"],\n [data.title, data.date, data.time || \"\", data.completed ? 1 : 0],\n );\n}\n\nexport function updateReminder(email: string, id: number, updates: Partial) {\n const mapped: Record = {};\n if (updates.title !== undefined) mapped.title = updates.title;\n if (updates.date !== undefined) mapped.date = updates.date;\n if (updates.time !== undefined) mapped.time = updates.time;\n if (updates.completed !== undefined) mapped.completed = updates.completed ? 1 : 0;\n return updateItem(TABLES.reminders, email, id, mapped);\n}\n\nexport function deleteReminder(email: string, id: number) {\n return deleteItem(TABLES.reminders, email, id);\n}\n\n// --- Activities ---\n\nexport function listActivities(email: string) {\n return listItems(TABLES.activities, email);\n}\n\nexport function createActivity(\n email: string,\n data: Omit,\n) {\n return createItem(\n TABLES.activities,\n email,\n [\"child_name\", \"activity_name\", \"duration_minutes\", \"date\", \"category\"],\n [data.child_name, data.activity_name, data.duration_minutes || 0, data.date || \"\", data.category || \"\"],\n );\n}\n\nexport function updateActivity(email: string, id: number, updates: Partial) {\n return updateItem(TABLES.activities, email, id, updates);\n}\n\nexport function deleteActivity(email: string, id: number) {\n return deleteItem(TABLES.activities, email, id);\n}\n","deleted","label",[177,159],"backend","permalink","https://www.val.town/x/arfan/family-hub/code/backend/database.ts","extension","actionData","errors"]