[{"_1":2,"_175":-5,"_176":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_37":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","79f79f5ed57d7b797958358e03e52c65090a3729","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_172":173,"_174":-5},"handle","fezokuhlekhumalo14","name","ATM","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","85875b64-3fac-11f0-b8d4-76b3cceeab13","createdAt",["D",1748867065562],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","ca7d2610-2448-11f0-8391-8dd03738580d","pinnedFileId","f5295850-3fac-11f0-93a4-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","ce736e01-69ba-497b-b8c2-6d6d59b1ccc3","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ3TWRtMDhUcmFrS21DVnNjcVVoWWFVUjgxWCJ9","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",14,"8587d0f8-3fac-11f0-b8d4-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_98":169},"e8e3a136-3fac-11f0-bf79-76b3cceeab13","queries.ts","fileId","e8e3a1fe-3fac-11f0-bf79-76b3cceeab13","parentId","4a3de075-973f-457f-ab01-9757ac6be7fa","branchId","branchVersion",4,"latest",["D",1748867232257],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n User, Activity, RestPeriod, StressReading, Meal, FoodItem, \n WearableDevice, DailyGoals, DailySummary, WellnessInsight \n} from \"../../shared/types.ts\";\n\n// User queries\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM users_v1 WHERE id = ?\n `, [id]);\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row[0] as number,\n email: row[1] as string,\n name: row[2] as string,\n age: row[3] as number,\n height: row[4] as number,\n weight: row[5] as number,\n activityLevel: row[6] as any,\n dailyCalorieGoal: row[7] as number,\n dailyStepGoal: row[8] as number,\n createdAt: row[9] as string,\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM users_v1 WHERE email = ?\n `, [email]);\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row[0] as number,\n email: row[1] as string,\n name: row[2] as string,\n age: row[3] as number,\n height: row[4] as number,\n weight: row[5] as number,\n activityLevel: row[6] as any,\n dailyCalorieGoal: row[7] as number,\n dailyStepGoal: row[8] as number,\n createdAt: row[9] as string,\n };\n}\n\n// Activity queries\nexport async function addActivity(activity: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO activities_v1 (\n user_id, type, value, unit, timestamp, source, \n exercise_type, duration, intensity, heart_rate\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n activity.userId,\n activity.type,\n activity.value,\n activity.unit,\n activity.timestamp,\n activity.source,\n activity.metadata?.exerciseType || null,\n activity.metadata?.duration || null,\n activity.metadata?.intensity || null,\n activity.metadata?.heartRate || null,\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getActivitiesByDateRange(\n userId: number, \n startDate: string, \n endDate: string\n): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM activities_v1 \n WHERE user_id = ? AND timestamp BETWEEN ? AND ?\n ORDER BY timestamp DESC\n `, [userId, startDate, endDate]);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n userId: row[1] as number,\n type: row[2] as any,\n value: row[3] as number,\n unit: row[4] as string,\n timestamp: row[5] as string,\n source: row[6] as any,\n metadata: {\n exerciseType: row[7] as string,\n duration: row[8] as number,\n intensity: row[9] as any,\n heartRate: row[10] as number,\n }\n }));\n}\n\n// Rest period queries\nexport async function addRestPeriod(restPeriod: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO rest_periods_v1 (\n user_id, type, start_time, end_time, duration, quality, source,\n deep_sleep, light_sleep, rem_sleep, awakenings\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n restPeriod.userId,\n restPeriod.type,\n restPeriod.startTime,\n restPeriod.endTime,\n restPeriod.duration,\n restPeriod.quality || null,\n restPeriod.source,\n restPeriod.metadata?.deepSleep || null,\n restPeriod.metadata?.lightSleep || null,\n restPeriod.metadata?.remSleep || null,\n restPeriod.metadata?.awakenings || null,\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getRestPeriodsByDateRange(\n userId: number, \n startDate: string, \n endDate: string\n): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM rest_periods_v1 \n WHERE user_id = ? AND start_time BETWEEN ? AND ?\n ORDER BY start_time DESC\n `, [userId, startDate, endDate]);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n userId: row[1] as number,\n type: row[2] as any,\n startTime: row[3] as string,\n endTime: row[4] as string,\n duration: row[5] as number,\n quality: row[6] as any,\n source: row[7] as any,\n metadata: {\n deepSleep: row[8] as number,\n lightSleep: row[9] as number,\n remSleep: row[10] as number,\n awakenings: row[11] as number,\n }\n }));\n}\n\n// Stress reading queries\nexport async function addStressReading(stress: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO stress_readings_v1 (\n user_id, level, heart_rate, heart_rate_variability, timestamp, source, context\n ) VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n stress.userId,\n stress.level,\n stress.heartRate || null,\n stress.heartRateVariability || null,\n stress.timestamp,\n stress.source,\n stress.context || null,\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getStressReadingsByDateRange(\n userId: number, \n startDate: string, \n endDate: string\n): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM stress_readings_v1 \n WHERE user_id = ? AND timestamp BETWEEN ? AND ?\n ORDER BY timestamp DESC\n `, [userId, startDate, endDate]);\n \n return result.rows.map(row => ({\n id: row[0] as number,\n userId: row[1] as number,\n level: row[2] as number,\n heartRate: row[3] as number,\n heartRateVariability: row[4] as number,\n timestamp: row[5] as string,\n source: row[6] as any,\n context: row[7] as string,\n }));\n}\n\n// Meal queries\nexport async function addMeal(meal: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO meals_v1 (user_id, type, timestamp, total_calories, notes)\n VALUES (?, ?, ?, ?, ?)\n `, [\n meal.userId,\n meal.type,\n meal.timestamp,\n meal.totalCalories,\n meal.notes || null,\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function addFoodItem(foodItem: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO food_items_v1 (\n meal_id, name, brand, quantity, unit, calories, \n protein, carbs, fat, fiber, sugar, sodium\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n foodItem.mealId,\n foodItem.name,\n foodItem.brand || null,\n foodItem.quantity,\n foodItem.unit,\n foodItem.calories,\n foodItem.protein || null,\n foodItem.carbs || null,\n foodItem.fat || null,\n foodItem.fiber || null,\n foodItem.sugar || null,\n foodItem.sodium || null,\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getMealsByDateRange(\n userId: number, \n startDate: string, \n endDate: string\n): Promise {\n const mealsResult = await sqlite.execute(`\n SELECT * FROM meals_v1 \n WHERE user_id = ? AND timestamp BETWEEN ? AND ?\n ORDER BY timestamp DESC\n `, [userId, startDate, endDate]);\n \n const meals: Meal[] = [];\n \n for (const row of mealsResult.rows) {\n const mealId = row[0] as number;\n \n // Get food items for this meal\n const foodsResult = await sqlite.execute(`\n SELECT * FROM food_items_v1 WHERE meal_id = ?\n `, [mealId]);\n \n const foods: FoodItem[] = foodsResult.rows.map(foodRow => ({\n id: foodRow[0] as number,\n mealId: foodRow[1] as number,\n name: foodRow[2] as string,\n brand: foodRow[3] as string,\n quantity: foodRow[4] as number,\n unit: foodRow[5] as string,\n calories: foodRow[6] as number,\n protein: foodRow[7] as number,\n carbs: foodRow[8] as number,\n fat: foodRow[9] as number,\n fiber: foodRow[10] as number,\n sugar: foodRow[11] as number,\n sodium: foodRow[12] as number,\n }));\n \n meals.push({\n id: mealId,\n userId: row[1] as number,\n type: row[2] as any,\n timestamp: row[3] as string,\n totalCalories: row[4] as number,\n notes: row[5] as string,\n foods,\n });\n }\n \n return meals;\n}\n\n// Daily summary queries\nexport async function getDailySummary(userId: number, date: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM daily_summaries_v1 WHERE user_id = ? AND date = ?\n `, [userId, date]);\n \n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n userId: row[0] as number,\n date: row[1] as string,\n totalSteps: row[2] as number,\n totalCaloriesBurned: row[3] as number,\n totalCaloriesConsumed: row[4] as number,\n totalSleep: row[5] as number,\n averageStress: row[6] as number,\n totalWater: row[7] as number,\n totalExercise: row[8] as number,\n goalsAchieved: JSON.parse(row[9] as string || '[]'),\n };\n}\n\nexport async function updateDailySummary(summary: DailySummary): Promise {\n await sqlite.execute(`\n INSERT OR REPLACE INTO daily_summaries_v1 (\n user_id, date, total_steps, total_calories_burned, total_calories_consumed,\n total_sleep, average_stress, total_water, total_exercise, goals_achieved, updated_at\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, CURRENT_TIMESTAMP)\n `, [\n summary.userId,\n summary.date,\n summary.totalSteps,\n summary.totalCaloriesBurned,\n summary.totalCaloriesConsumed,\n summary.totalSleep,\n summary.averageStress,\n summary.totalWater,\n summary.totalExercise,\n JSON.stringify(summary.goalsAchieved),\n ]);\n}\n\n// Water intake queries\nexport async function addWaterIntake(userId: number, amount: number, timestamp: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO water_intake_v1 (user_id, amount, timestamp)\n VALUES (?, ?, ?)\n `, [userId, amount, timestamp]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getWaterIntakeByDate(userId: number, date: string): Promise {\n const result = await sqlite.execute(`\n SELECT SUM(amount) as total FROM water_intake_v1 \n WHERE user_id = ? AND DATE(timestamp) = ?\n `, [userId, date]);\n \n return (result.rows[0]?.[0] as number) || 0;\n}\n\n// Analytics queries\nexport async function getWeeklySteps(userId: number, startDate: string): Promise<{ date: string; steps: number }[]> {\n const result = await sqlite.execute(`\n SELECT DATE(timestamp) as date, SUM(value) as steps\n FROM activities_v1 \n WHERE user_id = ? AND type = 'steps' AND timestamp >= ?\n GROUP BY DATE(timestamp)\n ORDER BY date\n `, [userId, startDate]);\n \n return result.rows.map(row => ({\n date: row[0] as string,\n steps: row[1] as number,\n }));\n}\n\nexport async function getWeeklyCalories(userId: number, startDate: string): Promise<{ date: string; burned: number; consumed: number }[]> {\n const burnedResult = await sqlite.execute(`\n SELECT DATE(timestamp) as date, SUM(value) as calories\n FROM activities_v1 \n WHERE user_id = ? AND type = 'calories_burned' AND timestamp >= ?\n GROUP BY DATE(timestamp)\n ORDER BY date\n `, [userId, startDate]);\n \n const consumedResult = await sqlite.execute(`\n SELECT DATE(timestamp) as date, SUM(total_calories) as calories\n FROM meals_v1 \n WHERE user_id = ? AND timestamp >= ?\n GROUP BY DATE(timestamp)\n ORDER BY date\n `, [userId, startDate]);\n \n const burnedMap = new Map(burnedResult.rows.map(row => [row[0] as string, row[1] as number]));\n const consumedMap = new Map(consumedResult.rows.map(row => [row[0] as string, row[1] as number]));\n \n // Get all dates in range\n const dates = new Set([...burnedMap.keys(), ...consumedMap.keys()]);\n \n return Array.from(dates).map(date => ({\n date,\n burned: burnedMap.get(date) || 0,\n consumed: consumedMap.get(date) || 0,\n })).sort((a, b) => a.date.localeCompare(b.date));\n}","deleted","label",[170,171,153],"backend","database","permalink","https://www.val.town/x/fezokuhlekhumalo14/ATM/code/backend/database/queries.ts","extension","actionData","errors"]