[{"_1":2,"_172":-5,"_173":-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","ff0419d68e57d8cc3e37e5d3da688157c5dd37c6","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,"_147":148,"_169":170,"_171":-5},"handle","Cess","name","skillswapapappforcommunityskillexchange","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":116,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_146":20},"id","f5940a7c-3fa4-11f0-aa05-76b3cceeab13","createdAt",["D",1748863817576],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","a37c0b00-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","screenshotVersion","likeCount",1,"aa51fa98-a743-4468-8b23-b215c685353a","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd5MjRkTHcyazFycGoycnREVHZIWXlnZGkifQ","org",{"_93":94,"_132":129},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",24,"f5948dd0-3fa4-11f0-aa05-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":150,"_151":152,"_153":154,"_155":137,"_156":136,"_157":158,"_103":159,"_135":116,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"8c41b462-3fc6-11f0-97e8-76b3cceeab13","queries.ts","fileId","4b181376-3fa5-11f0-ad43-76b3cceeab13","parentId","9569732a-62bc-445b-9421-9ed3e3701759","branchId","branchVersion","latest",true,["D",1748878243757],"fileType","http","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Skill, SkillMatch, Session, Progress, CommunityPost, CommunityComment } from \"../../shared/types.ts\";\n\n// User operations\nexport async function createUser(userData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users_v1 (name, email, bio, avatar_url, timezone) \n VALUES (?, ?, ?, ?, ?) RETURNING *`,\n [userData.name, userData.email, userData.bio, userData.avatar_url || null, userData.timezone]\n );\n return result[0] as User;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE id = ?`, [id]);\n return result[0] as User || null;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(`SELECT * FROM users_v1 WHERE email = ?`, [email]);\n return result[0] as User || null;\n}\n\nexport async function updateUser(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at');\n const values = fields.map(field => updates[field as keyof User]);\n const setClause = fields.map(field => `${field} = ?`).join(', ');\n \n const result = await sqlite.execute(\n `UPDATE users_v1 SET ${setClause} WHERE id = ? RETURNING *`,\n [...values, id]\n );\n return result[0] as User || null;\n}\n\n// Skill operations\nexport async function createSkill(skillData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO skills_v1 (user_id, name, category, type, proficiency_level, description) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [skillData.user_id, skillData.name, skillData.category, skillData.type, \n skillData.proficiency_level || null, skillData.description]\n );\n return result[0] as Skill;\n}\n\nexport async function getUserSkills(userId: number, type?: 'teach' | 'learn'): Promise {\n const query = type \n ? `SELECT * FROM skills_v1 WHERE user_id = ? AND type = ? ORDER BY created_at DESC`\n : `SELECT * FROM skills_v1 WHERE user_id = ? ORDER BY created_at DESC`;\n const params = type ? [userId, type] : [userId];\n \n const result = await sqlite.execute(query, params);\n return result as Skill[];\n}\n\nexport async function getSkillsByName(skillName: string, type: 'teach' | 'learn'): Promise {\n const result = await sqlite.execute(\n `SELECT s.*, u.name as user_name, u.rating as user_rating \n FROM skills_v1 s \n JOIN users_v1 u ON s.user_id = u.id \n WHERE s.name LIKE ? AND s.type = ? \n ORDER BY u.rating DESC`,\n [`%${skillName}%`, type]\n );\n return result as Skill[];\n}\n\nexport async function deleteSkill(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM skills_v1 WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n return result.changes > 0;\n}\n\n// Skill match operations\nexport async function createSkillMatch(matchData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO skill_matches_v1 (learner_id, teacher_id, skill_name, compatibility_score, ai_reasoning, status) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [matchData.learner_id, matchData.teacher_id, matchData.skill_name, \n matchData.compatibility_score, matchData.ai_reasoning, matchData.status]\n );\n return result[0] as SkillMatch;\n}\n\nexport async function getMatchesForUser(userId: number, status?: string): Promise {\n const query = status\n ? `SELECT m.*, \n l.name as learner_name, l.email as learner_email,\n t.name as teacher_name, t.email as teacher_email\n FROM skill_matches_v1 m\n JOIN users_v1 l ON m.learner_id = l.id\n JOIN users_v1 t ON m.teacher_id = t.id\n WHERE (m.learner_id = ? OR m.teacher_id = ?) AND m.status = ?\n ORDER BY m.created_at DESC`\n : `SELECT m.*, \n l.name as learner_name, l.email as learner_email,\n t.name as teacher_name, t.email as teacher_email\n FROM skill_matches_v1 m\n JOIN users_v1 l ON m.learner_id = l.id\n JOIN users_v1 t ON m.teacher_id = t.id\n WHERE m.learner_id = ? OR m.teacher_id = ?\n ORDER BY m.created_at DESC`;\n \n const params = status ? [userId, userId, status] : [userId, userId];\n const result = await sqlite.execute(query, params);\n return result as SkillMatch[];\n}\n\nexport async function updateMatchStatus(id: number, status: string): Promise {\n const result = await sqlite.execute(\n `UPDATE skill_matches_v1 SET status = ? WHERE id = ? RETURNING *`,\n [status, id]\n );\n return result[0] as SkillMatch || null;\n}\n\n// Session operations\nexport async function createSession(sessionData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO sessions_v1 (match_id, learner_id, teacher_id, skill_name, scheduled_at, duration_minutes, meeting_link, notes) \n VALUES (?, ?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [sessionData.match_id, sessionData.learner_id, sessionData.teacher_id, sessionData.skill_name,\n sessionData.scheduled_at, sessionData.duration_minutes, sessionData.meeting_link || null, sessionData.notes || null]\n );\n return result[0] as Session;\n}\n\nexport async function getUserSessions(userId: number, status?: string): Promise {\n const query = status\n ? `SELECT s.*, \n l.name as learner_name, t.name as teacher_name\n FROM sessions_v1 s\n JOIN users_v1 l ON s.learner_id = l.id\n JOIN users_v1 t ON s.teacher_id = t.id\n WHERE (s.learner_id = ? OR s.teacher_id = ?) AND s.status = ?\n ORDER BY s.scheduled_at ASC`\n : `SELECT s.*, \n l.name as learner_name, t.name as teacher_name\n FROM sessions_v1 s\n JOIN users_v1 l ON s.learner_id = l.id\n JOIN users_v1 t ON s.teacher_id = t.id\n WHERE s.learner_id = ? OR s.teacher_id = ?\n ORDER BY s.scheduled_at ASC`;\n \n const params = status ? [userId, userId, status] : [userId, userId];\n const result = await sqlite.execute(query, params);\n return result as Session[];\n}\n\nexport async function updateSession(id: number, updates: Partial): Promise {\n const fields = Object.keys(updates).filter(key => key !== 'id' && key !== 'created_at');\n const values = fields.map(field => updates[field as keyof Session]);\n const setClause = fields.map(field => `${field} = ?`).join(', ');\n \n const result = await sqlite.execute(\n `UPDATE sessions_v1 SET ${setClause} WHERE id = ? RETURNING *`,\n [...values, id]\n );\n return result[0] as Session || null;\n}\n\n// Progress operations\nexport async function upsertProgress(progressData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO progress_v1 (user_id, skill_name, current_level, sessions_completed, milestones_achieved, notes)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(user_id, skill_name) DO UPDATE SET\n current_level = excluded.current_level,\n sessions_completed = excluded.sessions_completed,\n milestones_achieved = excluded.milestones_achieved,\n notes = excluded.notes,\n updated_at = CURRENT_TIMESTAMP\n RETURNING *`,\n [progressData.user_id, progressData.skill_name, progressData.current_level,\n progressData.sessions_completed, JSON.stringify(progressData.milestones_achieved), progressData.notes]\n );\n return result[0] as Progress;\n}\n\nexport async function getUserProgress(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM progress_v1 WHERE user_id = ? ORDER BY updated_at DESC`,\n [userId]\n );\n return result.map(row => ({\n ...row,\n milestones_achieved: JSON.parse(row.milestones_achieved)\n })) as Progress[];\n}\n\n// Community operations\nexport async function createCommunityPost(postData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO community_posts_v1 (user_id, user_name, title, content, type, skill_tags) \n VALUES (?, ?, ?, ?, ?, ?) RETURNING *`,\n [postData.user_id, postData.user_name, postData.title, postData.content, \n postData.type, JSON.stringify(postData.skill_tags)]\n );\n return {\n ...result[0],\n skill_tags: JSON.parse(result[0].skill_tags)\n } as CommunityPost;\n}\n\nexport async function getCommunityPosts(type?: string, limit: number = 20, offset: number = 0): Promise {\n const query = type\n ? `SELECT * FROM community_posts_v1 WHERE type = ? ORDER BY created_at DESC LIMIT ? OFFSET ?`\n : `SELECT * FROM community_posts_v1 ORDER BY created_at DESC LIMIT ? OFFSET ?`;\n \n const params = type ? [type, limit, offset] : [limit, offset];\n const result = await sqlite.execute(query, params);\n \n return result.map(row => ({\n ...row,\n skill_tags: JSON.parse(row.skill_tags)\n })) as CommunityPost[];\n}\n\nexport async function createCommunityComment(commentData: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO community_comments_v1 (post_id, user_id, user_name, content) \n VALUES (?, ?, ?, ?) RETURNING *`,\n [commentData.post_id, commentData.user_id, commentData.user_name, commentData.content]\n );\n return result[0] as CommunityComment;\n}\n\nexport async function getPostComments(postId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM community_comments_v1 WHERE post_id = ? ORDER BY created_at ASC`,\n [postId]\n );\n return result as CommunityComment[];\n}\n\nexport async function likePost(postId: number): Promise {\n const result = await sqlite.execute(\n `UPDATE community_posts_v1 SET likes = likes + 1 WHERE id = ?`,\n [postId]\n );\n return result.changes > 0;\n}","deleted","label",[167,168,150],"backend","database","permalink","https://www.val.town/x/Cess/skillswapapappforcommunityskillexchange/code/backend/database/queries.ts","extension","actionData","errors"]