[{"_1":2,"_175":-5,"_176":-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,"_150":151,"_172":173,"_174":-5},"handle","Cess","name","skillswapapappforcommunityskillexchange","path","backend/routes/sessions.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":113,"_114":115,"_116":115,"_117":-5,"_118":119,"_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","f5940a7c-3fa4-11f0-aa05-76b3cceeab13","createdAt",["D",1748863817576],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","a37c0b00-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","4b181376-3fa5-11f0-ad43-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"aa51fa98-a743-4468-8b23-b215c685353a","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd5MjRkTHcyazFycGoycnREVHZIWXlnZGkifQ","org",{"_93":94,"_135":132,"_12":111},"avatar","branch",{"_138":139,"_95":43,"_101":140,"_141":102,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":96,"_148":94},"version",24,"f5948dd0-3fa4-11f0-aa05-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":115,"_103":162,"_138":32,"_163":164,"_165":166,"_167":20,"_168":-5,"_97":169},"9571d24a-3fa5-11f0-b5a0-76b3cceeab13","sessions.ts","fileId","9571d2f4-3fa5-11f0-b5a0-76b3cceeab13","parentId","ed53dd82-7867-47c9-aeda-ec124e3d2fff","branchId","branchVersion",8,"latest",["D",1748864085783],"fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createSession, \n getUserSessions, \n updateSession,\n updateUser,\n getUserById \n} from \"../database/queries.ts\";\nimport type { Session, SchedulingRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst sessions = new Hono();\n\n// Create a new session\nsessions.post(\"/\", async (c) => {\n try {\n const sessionData = await c.req.json();\n \n // Validate required fields\n if (!sessionData.match_id || !sessionData.learner_id || !sessionData.teacher_id || \n !sessionData.skill_name || !sessionData.scheduled_at) {\n return c.json({ \n success: false, \n error: \"match_id, learner_id, teacher_id, skill_name, and scheduled_at are required\" \n }, 400);\n }\n\n // Validate scheduled time is in the future\n const scheduledTime = new Date(sessionData.scheduled_at);\n if (scheduledTime <= new Date()) {\n return c.json({ \n success: false, \n error: \"Scheduled time must be in the future\" \n }, 400);\n }\n\n // Generate meeting link (in a real app, this would integrate with Zoom, Google Meet, etc.)\n const meetingLink = `https://meet.skillswap.ai/session-${Date.now()}`;\n\n const session = await createSession({\n match_id: sessionData.match_id,\n learner_id: sessionData.learner_id,\n teacher_id: sessionData.teacher_id,\n skill_name: sessionData.skill_name,\n scheduled_at: sessionData.scheduled_at,\n duration_minutes: sessionData.duration_minutes || 60,\n status: 'scheduled',\n meeting_link: meetingLink,\n notes: sessionData.notes\n });\n\n return c.json>({ \n success: true, \n data: session \n });\n } catch (error) {\n console.error(\"Error creating session:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create session\" \n }, 500);\n }\n});\n\n// Get sessions for a user\nsessions.get(\"/user/:userId\", async (c) => {\n try {\n const userId = parseInt(c.req.param(\"userId\"));\n if (isNaN(userId)) {\n return c.json({ \n success: false, \n error: \"Invalid user ID\" \n }, 400);\n }\n\n const status = c.req.query(\"status\");\n const userSessions = await getUserSessions(userId, status);\n\n return c.json>({ \n success: true, \n data: userSessions \n });\n } catch (error) {\n console.error(\"Error fetching sessions:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch sessions\" \n }, 500);\n }\n});\n\n// Update session (reschedule, complete, cancel, etc.)\nsessions.put(\"/:sessionId\", async (c) => {\n try {\n const sessionId = parseInt(c.req.param(\"sessionId\"));\n if (isNaN(sessionId)) {\n return c.json({ \n success: false, \n error: \"Invalid session ID\" \n }, 400);\n }\n\n const updates = await c.req.json();\n \n // Remove fields that shouldn't be updated directly\n delete updates.id;\n delete updates.created_at;\n delete updates.match_id;\n\n // Validate status if being updated\n if (updates.status && !['scheduled', 'completed', 'cancelled', 'no_show'].includes(updates.status)) {\n return c.json({ \n success: false, \n error: \"Invalid status\" \n }, 400);\n }\n\n // Validate scheduled time if being updated\n if (updates.scheduled_at) {\n const scheduledTime = new Date(updates.scheduled_at);\n if (scheduledTime <= new Date()) {\n return c.json({ \n success: false, \n error: \"Scheduled time must be in the future\" \n }, 400);\n }\n }\n\n const updatedSession = await updateSession(sessionId, updates);\n if (!updatedSession) {\n return c.json({ \n success: false, \n error: \"Session not found\" \n }, 404);\n }\n\n // If session is completed and ratings are provided, update user ratings\n if (updates.status === 'completed') {\n if (updates.teacher_rating && updatedSession.teacher_id) {\n await updateUserRating(updatedSession.teacher_id, updates.teacher_rating);\n }\n if (updates.learner_rating && updatedSession.learner_id) {\n await updateUserRating(updatedSession.learner_id, updates.learner_rating);\n }\n }\n\n return c.json>({ \n success: true, \n data: updatedSession \n });\n } catch (error) {\n console.error(\"Error updating session:\", error);\n return c.json({ \n success: false, \n error: \"Failed to update session\" \n }, 500);\n }\n});\n\n// Get upcoming sessions (next 7 days)\nsessions.get(\"/upcoming/:userId\", async (c) => {\n try {\n const userId = parseInt(c.req.param(\"userId\"));\n if (isNaN(userId)) {\n return c.json({ \n success: false, \n error: \"Invalid user ID\" \n }, 400);\n }\n\n const allSessions = await getUserSessions(userId, 'scheduled');\n const now = new Date();\n const nextWeek = new Date(now.getTime() + 7 * 24 * 60 * 60 * 1000);\n\n const upcomingSessions = allSessions.filter(session => {\n const sessionTime = new Date(session.scheduled_at);\n return sessionTime >= now && sessionTime <= nextWeek;\n });\n\n // Sort by scheduled time\n upcomingSessions.sort((a, b) => \n new Date(a.scheduled_at).getTime() - new Date(b.scheduled_at).getTime()\n );\n\n return c.json>({ \n success: true, \n data: upcomingSessions \n });\n } catch (error) {\n console.error(\"Error fetching upcoming sessions:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch upcoming sessions\" \n }, 500);\n }\n});\n\n// Get session statistics for a user\nsessions.get(\"/stats/:userId\", async (c) => {\n try {\n const userId = parseInt(c.req.param(\"userId\"));\n if (isNaN(userId)) {\n return c.json({ \n success: false, \n error: \"Invalid user ID\" \n }, 400);\n }\n\n const allSessions = await getUserSessions(userId);\n \n const stats = {\n total: allSessions.length,\n completed: allSessions.filter(s => s.status === 'completed').length,\n scheduled: allSessions.filter(s => s.status === 'scheduled').length,\n cancelled: allSessions.filter(s => s.status === 'cancelled').length,\n asLearner: allSessions.filter(s => s.learner_id === userId).length,\n asTeacher: allSessions.filter(s => s.teacher_id === userId).length,\n totalHours: allSessions\n .filter(s => s.status === 'completed')\n .reduce((total, s) => total + (s.duration_minutes || 60), 0) / 60,\n averageRating: calculateAverageRating(allSessions, userId)\n };\n\n return c.json({ \n success: true, \n data: stats \n });\n } catch (error) {\n console.error(\"Error fetching session stats:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch session statistics\" \n }, 500);\n }\n});\n\n// Helper function to update user rating\nasync function updateUserRating(userId: number, newRating: number) {\n try {\n const user = await getUserById(userId);\n if (!user) return;\n\n const allSessions = await getUserSessions(userId);\n const completedSessions = allSessions.filter(s => s.status === 'completed');\n \n // Calculate new average rating\n const ratings = completedSessions\n .map(s => s.teacher_id === userId ? s.teacher_rating : s.learner_rating)\n .filter(r => r !== null && r !== undefined);\n \n if (ratings.length > 0) {\n const averageRating = ratings.reduce((sum, r) => sum + r, 0) / ratings.length;\n await updateUser(userId, { \n rating: Math.round(averageRating * 10) / 10, // Round to 1 decimal\n total_sessions: completedSessions.length \n });\n }\n } catch (error) {\n console.error(\"Error updating user rating:\", error);\n }\n}\n\n// Helper function to calculate average rating for stats\nfunction calculateAverageRating(sessions: Session[], userId: number): number {\n const completedSessions = sessions.filter(s => s.status === 'completed');\n const ratings = completedSessions\n .map(s => s.teacher_id === userId ? s.teacher_rating : s.learner_rating)\n .filter(r => r !== null && r !== undefined);\n \n if (ratings.length === 0) return 0;\n return Math.round((ratings.reduce((sum, r) => sum + r, 0) / ratings.length) * 10) / 10;\n}\n\nexport default sessions;","deleted","label",[170,171,153],"backend","routes","permalink","https://www.val.town/x/Cess/skillswapapappforcommunityskillexchange/code/backend/routes/sessions.ts","extension","actionData","errors"]