[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","ENV",{"_36":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},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","a31a1550ad486cf340b818a53bc6ddc8c7db0295","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",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_148":149,"_171":172,"_173":-5},"handle","lily_2025","name","Gymtracking","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":110,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","0890ee04-3f8e-11f0-87a9-76b3cceeab13","createdAt",["D",1748853971003],"deletedAt","legacyEnvVars","privacy","unlisted","description","username","imageUrl","0afdf700-3f8d-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","3a8c5ac8-f16c-4d8a-96bc-345123d2239f","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4d2VJRW5meW9WejFHVGcyZUo5WUkwNXVzZSJ9","org",{"_93":94,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_95":43,"_101":138,"_139":102,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":96,"_146":94},"version",20,"089186de-3f8e-11f0-87a9-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":150,"_95":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_103":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"5b1e8f32-3f8e-11f0-a673-76b3cceeab13","queries.ts","fileId","5b1e8fe6-3f8e-11f0-a673-76b3cceeab13","parentId","3101a8a9-28f2-4840-a66c-17f2f7d78b59","branchId","branchVersion",4,"latest",true,["D",1748854109505],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Exercise, Workout, WorkoutExercise, ChatMessage, PersonalRecord, ProgressData } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(username: string, email: string, passwordHash: string, goals?: string, experienceLevel?: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users (username, email, password_hash, goals, experience_level) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [username, email, passwordHash, goals || null, experienceLevel || null]\n );\n return result[0].id;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n \"SELECT id, username, email, goals, experience_level, created_at FROM users WHERE email = ?\",\n [email]\n );\n return result[0] || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n \"SELECT id, username, email, goals, experience_level, created_at FROM users WHERE id = ?\",\n [id]\n );\n return result[0] || null;\n}\n\nexport async function getUserPasswordHash(email: string): Promise {\n const result = await sqlite.execute(\n \"SELECT password_hash FROM users WHERE email = ?\",\n [email]\n );\n return result[0]?.password_hash || null;\n}\n\n// Exercise queries\nexport async function getAllExercises(): Promise {\n return await sqlite.execute(\"SELECT * FROM exercises ORDER BY category, name\");\n}\n\nexport async function getExerciseById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM exercises WHERE id = ?\", [id]);\n return result[0] || null;\n}\n\nexport async function getExercisesByCategory(category: string): Promise {\n return await sqlite.execute(\"SELECT * FROM exercises WHERE category = ? ORDER BY name\", [category]);\n}\n\n// Workout queries\nexport async function createWorkout(userId: number, name: string, date: string, durationMinutes?: number, notes?: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO workouts (user_id, name, date, duration_minutes, notes) \n VALUES (?, ?, ?, ?, ?) RETURNING id`,\n [userId, name, date, durationMinutes || null, notes || null]\n );\n return result[0].id;\n}\n\nexport async function addWorkoutExercise(workoutId: number, exerciseId: number): Promise {\n const result = await sqlite.execute(\n `INSERT INTO workout_exercises (workout_id, exercise_id) \n VALUES (?, ?) RETURNING id`,\n [workoutId, exerciseId]\n );\n return result[0].id;\n}\n\nexport async function addWorkoutSet(workoutExerciseId: number, setNumber: number, reps: number, weight: number, restSeconds?: number, notes?: string): Promise {\n await sqlite.execute(\n `INSERT INTO workout_sets (workout_exercise_id, set_number, reps, weight, rest_seconds, notes) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [workoutExerciseId, setNumber, reps, weight, restSeconds || null, notes || null]\n );\n}\n\nexport async function getUserWorkouts(userId: number, limit: number = 20): Promise {\n return await sqlite.execute(\n `SELECT * FROM workouts WHERE user_id = ? \n ORDER BY date DESC, created_at DESC LIMIT ?`,\n [userId, limit]\n );\n}\n\nexport async function getWorkoutDetails(workoutId: number): Promise {\n const result = await sqlite.execute(`\n SELECT \n we.id,\n we.workout_id,\n we.exercise_id,\n e.name as exercise_name,\n ws.id as set_id,\n ws.set_number,\n ws.reps,\n ws.weight,\n ws.rest_seconds,\n ws.notes as set_notes\n FROM workout_exercises we\n JOIN exercises e ON we.exercise_id = e.id\n LEFT JOIN workout_sets ws ON we.id = ws.workout_exercise_id\n WHERE we.workout_id = ?\n ORDER BY we.id, ws.set_number\n `, [workoutId]);\n\n // Group by exercise\n const exerciseMap = new Map();\n \n for (const row of result) {\n if (!exerciseMap.has(row.id)) {\n exerciseMap.set(row.id, {\n id: row.id,\n workout_id: row.workout_id,\n exercise_id: row.exercise_id,\n exercise_name: row.exercise_name,\n sets: []\n });\n }\n \n if (row.set_id) {\n exerciseMap.get(row.id)!.sets.push({\n id: row.set_id,\n workout_exercise_id: row.id,\n set_number: row.set_number,\n reps: row.reps,\n weight: row.weight,\n rest_seconds: row.rest_seconds,\n notes: row.set_notes\n });\n }\n }\n \n return Array.from(exerciseMap.values());\n}\n\n// Progress queries\nexport async function getUserProgress(userId: number, exerciseId?: number): Promise {\n let query = `\n SELECT \n e.name as exercise_name,\n w.date,\n ws.weight,\n ws.reps,\n COUNT(ws.id) as sets_count\n FROM workouts w\n JOIN workout_exercises we ON w.id = we.workout_id\n JOIN exercises e ON we.exercise_id = e.id\n JOIN workout_sets ws ON we.id = ws.workout_exercise_id\n WHERE w.user_id = ?\n `;\n \n const params = [userId];\n \n if (exerciseId) {\n query += \" AND e.id = ?\";\n params.push(exerciseId);\n }\n \n query += `\n GROUP BY e.id, w.date, ws.weight, ws.reps\n ORDER BY e.name, w.date\n `;\n \n const result = await sqlite.execute(query, params);\n \n // Group by exercise and aggregate data\n const exerciseMap = new Map();\n \n for (const row of result) {\n if (!exerciseMap.has(row.exercise_name)) {\n exerciseMap.set(row.exercise_name, { dates: [], weights: [], volumes: [] });\n }\n \n const data = exerciseMap.get(row.exercise_name)!;\n const volume = row.weight * row.reps * row.sets_count;\n \n data.dates.push(row.date);\n data.weights.push(row.weight);\n data.volumes.push(volume);\n }\n \n return Array.from(exerciseMap.entries()).map(([exercise_name, data]) => ({\n exercise_name,\n ...data\n }));\n}\n\n// Personal Records queries\nexport async function updatePersonalRecord(userId: number, exerciseId: number, weight: number, reps: number, date: string): Promise {\n await sqlite.execute(\n `INSERT OR REPLACE INTO personal_records (user_id, exercise_id, weight, reps, date) \n VALUES (?, ?, ?, ?, ?)`,\n [userId, exerciseId, weight, reps, date]\n );\n}\n\nexport async function getUserPersonalRecords(userId: number): Promise {\n return await sqlite.execute(`\n SELECT \n pr.*,\n e.name as exercise_name\n FROM personal_records pr\n JOIN exercises e ON pr.exercise_id = e.id\n WHERE pr.user_id = ?\n ORDER BY e.name\n `, [userId]);\n}\n\n// Chat queries\nexport async function addChatMessage(userId: number, message: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO chat_messages (user_id, message) \n VALUES (?, ?) RETURNING id`,\n [userId, message]\n );\n return result[0].id;\n}\n\nexport async function getChatMessages(limit: number = 50): Promise {\n return await sqlite.execute(`\n SELECT \n cm.id,\n cm.user_id,\n u.username,\n cm.message,\n cm.timestamp\n FROM chat_messages cm\n JOIN users u ON cm.user_id = u.id\n ORDER BY cm.timestamp DESC\n LIMIT ?\n `, [limit]);\n}\n\nexport async function getRecentChatMessages(since: string, limit: number = 50): Promise {\n return await sqlite.execute(`\n SELECT \n cm.id,\n cm.user_id,\n u.username,\n cm.message,\n cm.timestamp\n FROM chat_messages cm\n JOIN users u ON cm.user_id = u.id\n WHERE cm.timestamp > ?\n ORDER BY cm.timestamp ASC\n LIMIT ?\n `, [since, limit]);\n}","deleted","label",[169,170,151],"backend","database","permalink","https://www.val.town/x/lily_2025/Gymtracking/code/backend/database/queries.ts","extension","actionData","errors"]