[{"_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","4ff166458996ccfe3bfa8627489090938620785a","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,"_149":150,"_171":172,"_173":-5},"handle","newbienate","name","ft","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_148":20},"id","69399298-3f7e-11f0-820d-76b3cceeab13","createdAt",["D",1748847261223],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","f521b780-3f70-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","screenshotVersion","likeCount","d29ff17c-9cbb-49b2-b254-710626e49047","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdGZlpJUjl1bndWV2NuaWJYN1FuVG1tUGsifQ","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":116,"_146":96,"_147":94},"version",1,"693b71c6-3f7e-11f0-820d-76b3cceeab13","projectId","forkedBranchId","40ee4994-3f71-11f0-a5e4-76b3cceeab13","forkedBranchVersion",22,"forkedProjectPrivacy","forkedProjectId","40ee09ac-3f71-11f0-a5e4-76b3cceeab13","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":151,"_95":152,"_153":154,"_155":156,"_157":136,"_158":135,"_159":160,"_103":161,"_134":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_97":168},"693e26fa-3f7e-11f0-820d-76b3cceeab13","queries.ts","fileId","67e285b5-111f-4efc-87a1-9e3fecebdb0b","parentId","ca01ff90-e473-4924-b15b-0f4f5b5cb884","branchId","branchVersion","latest",true,["D",1748847261223],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Member, BootcampClass, Booking, Workout, ClassWithBookings, MemberWithBookings } from \"../../shared/types.ts\";\n\n// Member queries\nexport async function getAllMembers(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM members_v1 WHERE active = 1 ORDER BY name\");\n return result as Member[];\n}\n\nexport async function getMemberById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM members_v1 WHERE id = ? AND active = 1\", [id]);\n return result[0] as Member || null;\n}\n\nexport async function createMember(member: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO members_v1 (name, email, phone, membership_type, join_date, active) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [member.name, member.email, member.phone || null, member.membership_type, member.join_date, member.active]\n );\n return result.lastInsertRowid as number;\n}\n\n// Class queries\nexport async function getAllClasses(): Promise {\n const result = await sqlite.execute(`\n SELECT c.*, \n COUNT(b.id) as current_bookings\n FROM classes_v1 c\n LEFT JOIN bookings_v1 b ON c.id = b.class_id AND b.status = 'confirmed'\n WHERE c.date >= date('now')\n GROUP BY c.id\n ORDER BY c.date, c.start_time\n `);\n \n return result.map(row => ({\n ...row,\n current_bookings: row.current_bookings || 0\n })) as BootcampClass[];\n}\n\nexport async function getClassById(id: number): Promise {\n const classResult = await sqlite.execute(`\n SELECT c.*, \n COUNT(b.id) as current_bookings\n FROM classes_v1 c\n LEFT JOIN bookings_v1 b ON c.id = b.class_id AND b.status = 'confirmed'\n WHERE c.id = ?\n GROUP BY c.id\n `, [id]);\n \n if (!classResult[0]) return null;\n \n const bookingsResult = await sqlite.execute(`\n SELECT b.*, m.name as member_name, m.email as member_email\n FROM bookings_v1 b\n JOIN members_v1 m ON b.member_id = m.id\n WHERE b.class_id = ? AND b.status = 'confirmed'\n ORDER BY b.created_at\n `, [id]);\n \n const classData = classResult[0] as BootcampClass;\n classData.current_bookings = classData.current_bookings || 0;\n \n return {\n ...classData,\n bookings: bookingsResult as Booking[]\n };\n}\n\nexport async function createClass(classData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO classes_v1 (name, description, instructor, date, start_time, end_time, max_capacity, difficulty_level, workout_type) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n [classData.name, classData.description, classData.instructor, classData.date, classData.start_time, classData.end_time, classData.max_capacity, classData.difficulty_level, classData.workout_type]\n );\n return result.lastInsertRowid as number;\n}\n\n// Booking queries\nexport async function createBooking(memberId: number, classId: number): Promise<{ success: boolean; message: string; bookingId?: number }> {\n // Check if class exists and has capacity\n const classInfo = await sqlite.execute(`\n SELECT c.*, COUNT(b.id) as current_bookings\n FROM classes_v1 c\n LEFT JOIN bookings_v1 b ON c.id = b.class_id AND b.status = 'confirmed'\n WHERE c.id = ?\n GROUP BY c.id\n `, [classId]);\n \n if (!classInfo[0]) {\n return { success: false, message: \"Class not found\" };\n }\n \n const cls = classInfo[0];\n const currentBookings = cls.current_bookings || 0;\n \n // Check if member already booked this class\n const existingBooking = await sqlite.execute(\n \"SELECT * FROM bookings_v1 WHERE member_id = ? AND class_id = ? AND status != 'cancelled'\",\n [memberId, classId]\n );\n \n if (existingBooking.length > 0) {\n return { success: false, message: \"Already booked for this class\" };\n }\n \n // Determine booking status\n const status = currentBookings >= cls.max_capacity ? 'waitlist' : 'confirmed';\n \n const result = await sqlite.execute(\n `INSERT INTO bookings_v1 (member_id, class_id, booking_date, status) \n VALUES (?, ?, ?, ?)`,\n [memberId, classId, new Date().toISOString().split('T')[0], status]\n );\n \n return {\n success: true,\n message: status === 'confirmed' ? 'Booking confirmed!' : 'Added to waitlist',\n bookingId: result.lastInsertRowid as number\n };\n}\n\nexport async function cancelBooking(memberId: number, classId: number): Promise<{ success: boolean; message: string }> {\n const result = await sqlite.execute(\n \"UPDATE bookings_v1 SET status = 'cancelled' WHERE member_id = ? AND class_id = ? AND status != 'cancelled'\",\n [memberId, classId]\n );\n \n if (result.changes === 0) {\n return { success: false, message: \"Booking not found or already cancelled\" };\n }\n \n // Check if we can promote someone from waitlist\n const waitlistBookings = await sqlite.execute(`\n SELECT * FROM bookings_v1 \n WHERE class_id = ? AND status = 'waitlist' \n ORDER BY created_at ASC \n LIMIT 1\n `, [classId]);\n \n if (waitlistBookings.length > 0) {\n await sqlite.execute(\n \"UPDATE bookings_v1 SET status = 'confirmed' WHERE id = ?\",\n [waitlistBookings[0].id]\n );\n }\n \n return { success: true, message: \"Booking cancelled successfully\" };\n}\n\nexport async function getMemberBookings(memberId: number): Promise<(Booking & { class: BootcampClass })[]> {\n const result = await sqlite.execute(`\n SELECT b.*, \n c.name as class_name, c.description as class_description, c.instructor, \n c.date, c.start_time, c.end_time, c.difficulty_level, c.workout_type\n FROM bookings_v1 b\n JOIN classes_v1 c ON b.class_id = c.id\n WHERE b.member_id = ? AND b.status != 'cancelled'\n ORDER BY c.date, c.start_time\n `, [memberId]);\n \n return result.map(row => ({\n id: row.id,\n member_id: row.member_id,\n class_id: row.class_id,\n booking_date: row.booking_date,\n status: row.status,\n class: {\n id: row.class_id,\n name: row.class_name,\n description: row.class_description,\n instructor: row.instructor,\n date: row.date,\n start_time: row.start_time,\n end_time: row.end_time,\n difficulty_level: row.difficulty_level,\n workout_type: row.workout_type,\n max_capacity: 0, // Not needed for this view\n current_bookings: 0 // Not needed for this view\n }\n }));\n}\n\n// Workout queries\nexport async function getAllWorkouts(): Promise {\n const result = await sqlite.execute(\"SELECT * FROM workouts_v1 ORDER BY name\");\n return result.map(row => ({\n ...row,\n equipment_needed: JSON.parse(row.equipment_needed || '[]'),\n exercises: JSON.parse(row.exercises || '[]')\n })) as Workout[];\n}\n\nexport async function getWorkoutById(id: number): Promise {\n const result = await sqlite.execute(\"SELECT * FROM workouts_v1 WHERE id = ?\", [id]);\n if (!result[0]) return null;\n \n const workout = result[0];\n return {\n ...workout,\n equipment_needed: JSON.parse(workout.equipment_needed || '[]'),\n exercises: JSON.parse(workout.exercises || '[]')\n } as Workout;\n}\n\nexport async function createWorkout(workout: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO workouts_v1 (name, description, duration_minutes, difficulty_level, equipment_needed, exercises) \n VALUES (?, ?, ?, ?, ?, ?)`,\n [\n workout.name, \n workout.description, \n workout.duration_minutes, \n workout.difficulty_level, \n JSON.stringify(workout.equipment_needed),\n JSON.stringify(workout.exercises)\n ]\n );\n return result.lastInsertRowid as number;\n}","deleted","label",[169,170,152],"backend","database","permalink","https://www.val.town/x/newbienate/ft/code/backend/database/queries.ts","extension","actionData","errors"]