[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_230":231,"_232":233},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",6,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","backend/routes/skills.ts","latestPath","fileId","64fbfafa-3fa5-11f0-afca-76b3cceeab13","name","skills.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createSkill, getUserSkills, getSkillsByName, deleteSkill } from \"../database/queries.ts\";\nimport type { Skill, ApiResponse } from \"../../shared/types.ts\";\n\nconst skills = new Hono();\n\n// Create a new skill\nskills.post(\"/\", async (c) => {\n try {\n const skillData = await c.req.json();\n \n // Validate required fields\n if (!skillData.user_id || !skillData.name || !skillData.category || !skillData.type) {\n return c.json({ \n success: false, \n error: \"user_id, name, category, and type are required\" \n }, 400);\n }\n\n // Validate type\n if (!['teach', 'learn'].includes(skillData.type)) {\n return c.json({ \n success: false, \n error: \"Type must be 'teach' or 'learn'\" \n }, 400);\n }\n\n const skill = await createSkill({\n user_id: skillData.user_id,\n name: skillData.name.trim(),\n category: skillData.category.trim(),\n type: skillData.type,\n proficiency_level: skillData.proficiency_level,\n description: skillData.description || ''\n });\n\n return c.json>({ \n success: true, \n data: skill \n });\n } catch (error) {\n console.error(\"Error creating skill:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create skill\" \n }, 500);\n }\n});\n\n// Get skills for a user\nskills.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 type = c.req.query(\"type\") as 'teach' | 'learn' | undefined;\n if (type && !['teach', 'learn'].includes(type)) {\n return c.json({ \n success: false, \n error: \"Type must be 'teach' or 'learn'\" \n }, 400);\n }\n\n const userSkills = await getUserSkills(userId, type);\n\n return c.json>({ \n success: true, \n data: userSkills \n });\n } catch (error) {\n console.error(\"Error fetching user skills:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch skills\" \n }, 500);\n }\n});\n\n// Search skills by name\nskills.get(\"/search\", async (c) => {\n try {\n const skillName = c.req.query(\"name\");\n const type = c.req.query(\"type\") as 'teach' | 'learn';\n\n if (!skillName) {\n return c.json({ \n success: false, \n error: \"Skill name is required\" \n }, 400);\n }\n\n if (!type || !['teach', 'learn'].includes(type)) {\n return c.json({ \n success: false, \n error: \"Valid type ('teach' or 'learn') is required\" \n }, 400);\n }\n\n const matchingSkills = await getSkillsByName(skillName, type);\n\n return c.json>({ \n success: true, \n data: matchingSkills \n });\n } catch (error) {\n console.error(\"Error searching skills:\", error);\n return c.json({ \n success: false, \n error: \"Failed to search skills\" \n }, 500);\n }\n});\n\n// Delete a skill\nskills.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const userId = parseInt(c.req.query(\"userId\") || \"0\");\n\n if (isNaN(id) || isNaN(userId) || userId === 0) {\n return c.json({ \n success: false, \n error: \"Valid skill ID and user ID are required\" \n }, 400);\n }\n\n const deleted = await deleteSkill(id, userId);\n if (!deleted) {\n return c.json({ \n success: false, \n error: \"Skill not found or unauthorized\" \n }, 404);\n }\n\n return c.json({ \n success: true \n });\n } catch (error) {\n console.error(\"Error deleting skill:\", error);\n return c.json({ \n success: false, \n error: \"Failed to delete skill\" \n }, 500);\n }\n});\n\n// Get popular skills by category\nskills.get(\"/popular\", async (c) => {\n try {\n const category = c.req.query(\"category\");\n const type = c.req.query(\"type\") as 'teach' | 'learn';\n\n // This would be a more complex query in a real app\n // For now, we'll return a simple response\n const popularSkills = [\n { name: \"JavaScript\", category: \"Programming\", count: 45 },\n { name: \"Python\", category: \"Programming\", count: 38 },\n { name: \"Guitar\", category: \"Music\", count: 32 },\n { name: \"Spanish\", category: \"Languages\", count: 28 },\n { name: \"Photography\", category: \"Arts\", count: 25 },\n { name: \"Cooking\", category: \"Life Skills\", count: 22 },\n { name: \"Yoga\", category: \"Fitness\", count: 20 },\n { name: \"Data Science\", category: \"Programming\", count: 18 }\n ];\n\n const filtered = category \n ? popularSkills.filter(skill => skill.category.toLowerCase() === category.toLowerCase())\n : popularSkills;\n\n return c.json({ \n success: true, \n data: filtered \n });\n } catch (error) {\n console.error(\"Error fetching popular skills:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch popular skills\" \n }, 500);\n }\n});\n\nexport default skills;","createdAt",["D",1748864004470],"branchVersion","branchId","f5948dd0-3fa4-11f0-aa05-76b3cceeab13","id","f5940a7c-3fa4-11f0-aa05-76b3cceeab13","skillswapapappforcommunityskillexchange",["D",1748863817576],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","a37c0b00-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","4b181376-3fa5-11f0-ad43-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",1,"orgId","aa51fa98-a743-4468-8b23-b215c685353a","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",24,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Cess","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd5MjRkTHcyazFycGoycnREVHZIWXlnZGkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":226,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":227,"_79":228,"_81":229,"_83":24},"tree",[161,168,170],"files",[161,162,163,164,165,166,167,168,169,170],"counts",{"_151":134,"_152":61,"_153":134,"_154":155,"_156":157},"contents",[125,126,127],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_132":57,"_37":149,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":150},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_132":57,"_37":142,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_26":144},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":61,"_132":57,"_37":133,"_13":134,"_33":20,"_35":135,"_23":24,"_136":-5,"_26":137},"1e54aa5c-3fa5-11f0-b6a3-76b3cceeab13","README.md","1e54aaf2-3fa5-11f0-b6a3-76b3cceeab13","parentId","latest",["D",1748863885941],0,"# SkillSwap AI\n\nA community-driven skill-sharing platform that uses AI to match learners with teachers, featuring intelligent matching, scheduling, progress tracking, and community engagement.\n\n## Features\n\n- **AI-Powered Matching**: Uses TonyAI to intelligently match learners with compatible teachers based on skills, availability, and learning preferences\n- **Skill Management**: Users can list skills they want to learn and skills they can teach\n- **Smart Scheduling**: Integrated calendar system for booking and managing learning sessions\n- **Progress Tracking**: Track learning milestones and achievements\n- **Community Board**: Share experiences, ask questions, and celebrate successes\n- **User Profiles**: Comprehensive profiles with skills, ratings, and availability\n\n## Tech Stack\n\n- **Backend**: Hono.js API with SQLite database\n- **Frontend**: React with TypeScript and TailwindCSS\n- **AI**: TonyAI for intelligent matching\n- **Storage**: Val Town SQLite for data persistence\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema\n│ │ └── queries.ts # Database operations\n│ ├── routes/\n│ │ ├── users.ts # User management\n│ │ ├── skills.ts # Skill operations\n│ │ ├── matching.ts # AI matching logic\n│ │ ├── sessions.ts # Session scheduling\n│ │ ├── community.ts # Community board\n│ │ └── static.ts # Static file serving\n│ └── index.ts # Main API entry point\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application\n│ │ ├── UserProfile.tsx # User profile management\n│ │ ├── SkillMatcher.tsx # AI matching interface\n│ │ ├── Scheduler.tsx # Session scheduling\n│ │ ├── ProgressTracker.tsx # Progress tracking\n│ │ └── CommunityBoard.tsx # Community features\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Getting Started\n\n1. The app runs on Val Town with HTTP trigger\n2. Visit the main URL to access the platform\n3. Create a profile and add your skills\n4. Use AI matching to find learning partners\n5. Schedule sessions and track your progress\n6. Engage with the community board\n\n## Environment Variables\n\n- `OPENAI_API_KEY`: Required for AI matching functionality","label",[129],"263c1ebc-3fa5-11f0-b424-76b3cceeab13","shared","40719501-6aa0-4845-938d-a4f0777f0cad",2,["D",1748863899196],"directory",[139],"32eeced4-3fa5-11f0-8de5-76b3cceeab13","backend","58ca6478-e48f-4149-9238-705f9b02a9af",3,["D",1748863920489],[146],"pulls","branches","forks","envVars",{"_158":134,"_160":134},"connections",{"_158":134,"_159":134},"count","unfilledCount","emptyCount",{"_42":145,"_31":146,"_29":147,"_131":-5,"_40":41,"_39":148,"_132":57,"_37":223,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_172":224,"_26":225},{"_42":219,"_31":211,"_29":205,"_131":147,"_40":41,"_39":148,"_132":57,"_37":220,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_172":221,"_26":222},{"_42":212,"_31":213,"_29":214,"_131":205,"_40":41,"_39":148,"_132":57,"_37":215,"_13":134,"_33":34,"_35":216,"_23":24,"_136":-5,"_172":217,"_26":218},{"_42":203,"_31":204,"_29":55,"_131":205,"_40":41,"_39":206,"_132":24,"_37":207,"_13":134,"_33":34,"_35":208,"_23":24,"_136":-5,"_172":209,"_26":210},{"_42":199,"_31":194,"_29":188,"_131":147,"_40":41,"_39":189,"_132":57,"_37":200,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_172":201,"_26":202},{"_42":195,"_31":32,"_29":30,"_131":188,"_40":41,"_39":14,"_132":57,"_37":196,"_13":134,"_33":34,"_35":36,"_23":24,"_136":-5,"_172":197,"_26":198},{"_42":185,"_31":186,"_29":187,"_131":188,"_40":41,"_39":189,"_132":57,"_37":190,"_13":134,"_33":34,"_35":191,"_23":24,"_136":-5,"_172":192,"_26":193},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_132":57,"_37":182,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_172":183,"_26":184},{"_42":175,"_31":176,"_29":177,"_131":140,"_40":41,"_39":141,"_132":24,"_37":178,"_13":134,"_33":34,"_35":179,"_23":24,"_136":-5,"_172":180,"_26":181},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":61,"_132":57,"_37":171,"_13":134,"_33":20,"_35":135,"_23":24,"_136":-5,"_172":173,"_26":174},["D",1748863885941],"children",[],[129],"263c1282-3fa5-11f0-b424-76b3cceeab13","types.ts","263c1368-3fa5-11f0-b424-76b3cceeab13",["D",1748863899196],"// Shared types for SkillSwap AI\n\nexport interface User {\n id: number;\n name: string;\n email: string;\n bio: string;\n avatar_url?: string;\n timezone: string;\n created_at: string;\n rating: number;\n total_sessions: number;\n}\n\nexport interface Skill {\n id: number;\n user_id: number;\n name: string;\n category: string;\n type: 'teach' | 'learn';\n proficiency_level?: 'beginner' | 'intermediate' | 'advanced' | 'expert';\n description: string;\n created_at: string;\n}\n\nexport interface SkillMatch {\n id: number;\n learner_id: number;\n teacher_id: number;\n skill_name: string;\n compatibility_score: number;\n ai_reasoning: string;\n status: 'pending' | 'accepted' | 'declined' | 'completed';\n created_at: string;\n}\n\nexport interface Session {\n id: number;\n match_id: number;\n learner_id: number;\n teacher_id: number;\n skill_name: string;\n scheduled_at: string;\n duration_minutes: number;\n status: 'scheduled' | 'completed' | 'cancelled' | 'no_show';\n meeting_link?: string;\n notes?: string;\n learner_rating?: number;\n teacher_rating?: number;\n created_at: string;\n}\n\nexport interface Progress {\n id: number;\n user_id: number;\n skill_name: string;\n current_level: 'beginner' | 'intermediate' | 'advanced' | 'expert';\n sessions_completed: number;\n milestones_achieved: string[];\n notes: string;\n updated_at: string;\n}\n\nexport interface CommunityPost {\n id: number;\n user_id: number;\n user_name: string;\n title: string;\n content: string;\n type: 'question' | 'success_story' | 'tip' | 'general';\n skill_tags: string[];\n likes: number;\n created_at: string;\n}\n\nexport interface CommunityComment {\n id: number;\n post_id: number;\n user_id: number;\n user_name: string;\n content: string;\n created_at: string;\n}\n\nexport interface MatchingRequest {\n userId: number;\n skillsToLearn: string[];\n preferredTeachingStyle?: string;\n availability?: string[];\n maxDistance?: number;\n}\n\nexport interface MatchingResponse {\n matches: Array<{\n teacher: User;\n skill: Skill;\n compatibilityScore: number;\n reasoning: string;\n }>;\n}\n\nexport interface SchedulingRequest {\n matchId: number;\n preferredTimes: string[];\n duration: number;\n notes?: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[139,176],["D",1748863899196],[169],[139],"54fa8fd6-3fa5-11f0-b48c-76b3cceeab13","users.ts","54fa9080-3fa5-11f0-b48c-76b3cceeab13","ed53dd82-7867-47c9-aeda-ec124e3d2fff",5,["D",1748863977620],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createUser, getUserById, getUserByEmail, updateUser } from \"../database/queries.ts\";\nimport type { User, ApiResponse } from \"../../shared/types.ts\";\n\nconst users = new Hono();\n\n// Create a new user\nusers.post(\"/\", async (c) => {\n try {\n const userData = await c.req.json();\n \n // Validate required fields\n if (!userData.name || !userData.email) {\n return c.json({ \n success: false, \n error: \"Name and email are required\" \n }, 400);\n }\n\n // Check if user already exists\n const existingUser = await getUserByEmail(userData.email);\n if (existingUser) {\n return c.json({ \n success: false, \n error: \"User with this email already exists\" \n }, 409);\n }\n\n const user = await createUser({\n name: userData.name,\n email: userData.email,\n bio: userData.bio || '',\n avatar_url: userData.avatar_url,\n timezone: userData.timezone || 'UTC'\n });\n\n return c.json>({ \n success: true, \n data: user \n });\n } catch (error) {\n console.error(\"Error creating user:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create user\" \n }, 500);\n }\n});\n\n// Get user by ID\nusers.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ \n success: false, \n error: \"Invalid user ID\" \n }, 400);\n }\n\n const user = await getUserById(id);\n if (!user) {\n return c.json({ \n success: false, \n error: \"User not found\" \n }, 404);\n }\n\n return c.json>({ \n success: true, \n data: user \n });\n } catch (error) {\n console.error(\"Error fetching user:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch user\" \n }, 500);\n }\n});\n\n// Get user by email\nusers.get(\"/email/:email\", async (c) => {\n try {\n const email = c.req.param(\"email\");\n const user = await getUserByEmail(email);\n \n if (!user) {\n return c.json({ \n success: false, \n error: \"User not found\" \n }, 404);\n }\n\n return c.json>({ \n success: true, \n data: user \n });\n } catch (error) {\n console.error(\"Error fetching user by email:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch user\" \n }, 500);\n }\n});\n\n// Update user\nusers.put(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ \n success: false, \n error: \"Invalid user 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.rating;\n delete updates.total_sessions;\n\n const user = await updateUser(id, updates);\n if (!user) {\n return c.json({ \n success: false, \n error: \"User not found\" \n }, 404);\n }\n\n return c.json>({ \n success: true, \n data: user \n });\n } catch (error) {\n console.error(\"Error updating user:\", error);\n return c.json({ \n success: false, \n error: \"Failed to update user\" \n }, 500);\n }\n});\n\nexport default users;",[],[146,194,186],"routes","64fbf9f6-3fa5-11f0-afca-76b3cceeab13",["D",1748864004470],[],[146,194,32],"54fa9c1a-3fa5-11f0-b48c-76b3cceeab13",["D",1748863977620],[166,167],[146,194],"4b1812a4-3fa5-11f0-ad43-76b3cceeab13","queries.ts","9569732a-62bc-445b-9421-9ed3e3701759",4,["D",1748863961043],"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}",[],[146,211,204],"database","32eebf98-3fa5-11f0-8de5-76b3cceeab13","migrations.ts","32eec06a-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Database schema for SkillSwap AI\n// Change table names when modifying schemas (add _2, _3, etc.)\n\nexport async function runMigrations() {\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n email TEXT UNIQUE NOT NULL,\n bio TEXT DEFAULT '',\n avatar_url TEXT,\n timezone TEXT DEFAULT 'UTC',\n rating REAL DEFAULT 0.0,\n total_sessions INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Skills table - tracks both skills users can teach and want to learn\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skills_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n category TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('teach', 'learn')),\n proficiency_level TEXT CHECK (proficiency_level IN ('beginner', 'intermediate', 'advanced', 'expert')),\n description TEXT DEFAULT '',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Skill matches - AI-generated matches between learners and teachers\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skill_matches_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n learner_id INTEGER NOT NULL,\n teacher_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n compatibility_score REAL NOT NULL,\n ai_reasoning TEXT NOT NULL,\n status TEXT DEFAULT 'pending' CHECK (status IN ('pending', 'accepted', 'declined', 'completed')),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (learner_id) REFERENCES users_v1 (id),\n FOREIGN KEY (teacher_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Sessions - scheduled learning sessions\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n match_id INTEGER NOT NULL,\n learner_id INTEGER NOT NULL,\n teacher_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n scheduled_at DATETIME NOT NULL,\n duration_minutes INTEGER DEFAULT 60,\n status TEXT DEFAULT 'scheduled' CHECK (status IN ('scheduled', 'completed', 'cancelled', 'no_show')),\n meeting_link TEXT,\n notes TEXT,\n learner_rating INTEGER CHECK (learner_rating BETWEEN 1 AND 5),\n teacher_rating INTEGER CHECK (teacher_rating BETWEEN 1 AND 5),\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (match_id) REFERENCES skill_matches_v1 (id),\n FOREIGN KEY (learner_id) REFERENCES users_v1 (id),\n FOREIGN KEY (teacher_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Progress tracking\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS progress_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n skill_name TEXT NOT NULL,\n current_level TEXT DEFAULT 'beginner' CHECK (current_level IN ('beginner', 'intermediate', 'advanced', 'expert')),\n sessions_completed INTEGER DEFAULT 0,\n milestones_achieved TEXT DEFAULT '[]', -- JSON array of milestone strings\n notes TEXT DEFAULT '',\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id),\n UNIQUE(user_id, skill_name)\n )\n `);\n\n // Community posts\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS community_posts_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n user_name TEXT NOT NULL,\n title TEXT NOT NULL,\n content TEXT NOT NULL,\n type TEXT DEFAULT 'general' CHECK (type IN ('question', 'success_story', 'tip', 'general')),\n skill_tags TEXT DEFAULT '[]', -- JSON array of skill tags\n likes INTEGER DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Community comments\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS community_comments_v1 (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n post_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n user_name TEXT NOT NULL,\n content TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (post_id) REFERENCES community_posts_v1 (id),\n FOREIGN KEY (user_id) REFERENCES users_v1 (id)\n )\n `);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_user_type ON skills_v1 (user_id, type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_name_type ON skills_v1 (name, type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_matches_status ON skill_matches_v1 (status)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_sessions_scheduled ON sessions_v1 (scheduled_at)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_posts_type ON community_posts_v1 (type, created_at DESC)`);\n\n console.log(\"Database migrations completed successfully\");\n}",[],[146,211,213],"32eed5a0-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],[163,164],[146,211],["D",1748863920489],[162,165],[146],["D",1748863817576],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":263,"_264":265,"_266":267,"_268":24,"_269":24,"_270":24,"_271":57,"_272":-5,"_273":-7,"_274":-7,"_275":134,"_276":24,"_277":24,"_278":-5,"_279":24,"_280":24,"_281":24,"_282":-5},"ENV",{"_234":235,"_236":237,"_238":85,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v6