[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_257":258,"_259":260},"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",9,"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/community.ts","latestPath","fileId","aad011b0-3fa5-11f0-b9d5-76b3cceeab13","name","community.ts","fileType","script","content","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createCommunityPost, \n getCommunityPosts, \n createCommunityComment, \n getPostComments,\n likePost \n} from \"../database/queries.ts\";\nimport type { CommunityPost, CommunityComment, ApiResponse } from \"../../shared/types.ts\";\n\nconst community = new Hono();\n\n// Create a new community post\ncommunity.post(\"/posts\", async (c) => {\n try {\n const postData = await c.req.json();\n \n // Validate required fields\n if (!postData.user_id || !postData.user_name || !postData.title || !postData.content) {\n return c.json({ \n success: false, \n error: \"user_id, user_name, title, and content are required\" \n }, 400);\n }\n\n // Validate post type\n const validTypes = ['question', 'success_story', 'tip', 'general'];\n if (postData.type && !validTypes.includes(postData.type)) {\n return c.json({ \n success: false, \n error: `Type must be one of: ${validTypes.join(', ')}` \n }, 400);\n }\n\n const post = await createCommunityPost({\n user_id: postData.user_id,\n user_name: postData.user_name,\n title: postData.title.trim(),\n content: postData.content.trim(),\n type: postData.type || 'general',\n skill_tags: postData.skill_tags || []\n });\n\n return c.json>({ \n success: true, \n data: post \n });\n } catch (error) {\n console.error(\"Error creating community post:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create post\" \n }, 500);\n }\n});\n\n// Get community posts with pagination and filtering\ncommunity.get(\"/posts\", async (c) => {\n try {\n const type = c.req.query(\"type\");\n const limit = parseInt(c.req.query(\"limit\") || \"20\");\n const offset = parseInt(c.req.query(\"offset\") || \"0\");\n\n // Validate limit and offset\n if (limit < 1 || limit > 100) {\n return c.json({ \n success: false, \n error: \"Limit must be between 1 and 100\" \n }, 400);\n }\n\n if (offset < 0) {\n return c.json({ \n success: false, \n error: \"Offset must be non-negative\" \n }, 400);\n }\n\n // Validate type if provided\n const validTypes = ['question', 'success_story', 'tip', 'general'];\n if (type && !validTypes.includes(type)) {\n return c.json({ \n success: false, \n error: `Type must be one of: ${validTypes.join(', ')}` \n }, 400);\n }\n\n const posts = await getCommunityPosts(type, limit, offset);\n\n return c.json>({ \n success: true, \n data: posts \n });\n } catch (error) {\n console.error(\"Error fetching community posts:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch posts\" \n }, 500);\n }\n});\n\n// Get comments for a specific post\ncommunity.get(\"/posts/:postId/comments\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const comments = await getPostComments(postId);\n\n return c.json>({ \n success: true, \n data: comments \n });\n } catch (error) {\n console.error(\"Error fetching comments:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch comments\" \n }, 500);\n }\n});\n\n// Create a comment on a post\ncommunity.post(\"/posts/:postId/comments\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const commentData = await c.req.json();\n \n // Validate required fields\n if (!commentData.user_id || !commentData.user_name || !commentData.content) {\n return c.json({ \n success: false, \n error: \"user_id, user_name, and content are required\" \n }, 400);\n }\n\n const comment = await createCommunityComment({\n post_id: postId,\n user_id: commentData.user_id,\n user_name: commentData.user_name,\n content: commentData.content.trim()\n });\n\n return c.json>({ \n success: true, \n data: comment \n });\n } catch (error) {\n console.error(\"Error creating comment:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create comment\" \n }, 500);\n }\n});\n\n// Like a post\ncommunity.post(\"/posts/:postId/like\", async (c) => {\n try {\n const postId = parseInt(c.req.param(\"postId\"));\n if (isNaN(postId)) {\n return c.json({ \n success: false, \n error: \"Invalid post ID\" \n }, 400);\n }\n\n const success = await likePost(postId);\n if (!success) {\n return c.json({ \n success: false, \n error: \"Post not found\" \n }, 404);\n }\n\n return c.json({ \n success: true \n });\n } catch (error) {\n console.error(\"Error liking post:\", error);\n return c.json({ \n success: false, \n error: \"Failed to like post\" \n }, 500);\n }\n});\n\n// Get trending topics/skills\ncommunity.get(\"/trending\", async (c) => {\n try {\n // In a real app, this would analyze post content and skill tags\n // For now, we'll return mock trending data\n const trendingTopics = [\n { name: \"JavaScript\", posts: 45, growth: \"+12%\" },\n { name: \"Remote Work Tips\", posts: 38, growth: \"+8%\" },\n { name: \"Language Learning\", posts: 32, growth: \"+15%\" },\n { name: \"Photography\", posts: 28, growth: \"+5%\" },\n { name: \"Cooking\", posts: 25, growth: \"+20%\" },\n { name: \"Data Science\", posts: 22, growth: \"+10%\" },\n { name: \"Guitar\", posts: 20, growth: \"+7%\" },\n { name: \"Public Speaking\", posts: 18, growth: \"+25%\" }\n ];\n\n return c.json({ \n success: true, \n data: trendingTopics \n });\n } catch (error) {\n console.error(\"Error fetching trending topics:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch trending topics\" \n }, 500);\n }\n});\n\n// Get community statistics\ncommunity.get(\"/stats\", async (c) => {\n try {\n // In a real app, these would be calculated from the database\n const stats = {\n totalPosts: 1247,\n totalComments: 3891,\n activeUsers: 342,\n questionsAnswered: 89,\n successStories: 156,\n tipsShared: 203,\n topContributors: [\n { name: \"Sarah Chen\", posts: 23, helpful_votes: 145 },\n { name: \"Mike Rodriguez\", posts: 19, helpful_votes: 132 },\n { name: \"Emma Thompson\", posts: 17, helpful_votes: 98 },\n { name: \"David Kim\", posts: 15, helpful_votes: 87 },\n { name: \"Lisa Johnson\", posts: 14, helpful_votes: 76 }\n ]\n };\n\n return c.json({ \n success: true, \n data: stats \n });\n } catch (error) {\n console.error(\"Error fetching community stats:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch community statistics\" \n }, 500);\n }\n});\n\n// Search posts by content or skill tags\ncommunity.get(\"/search\", async (c) => {\n try {\n const query = c.req.query(\"q\");\n const type = c.req.query(\"type\");\n \n if (!query || query.trim().length < 2) {\n return c.json({ \n success: false, \n error: \"Search query must be at least 2 characters\" \n }, 400);\n }\n\n // In a real app, this would use full-text search\n // For now, we'll return a simple response\n const searchResults = [\n {\n id: 1,\n title: \"How to get started with JavaScript?\",\n content: \"I'm new to programming and want to learn JavaScript...\",\n type: \"question\",\n user_name: \"John Doe\",\n skill_tags: [\"JavaScript\", \"Programming\"],\n likes: 12,\n created_at: new Date().toISOString()\n }\n ];\n\n return c.json({ \n success: true, \n data: searchResults \n });\n } catch (error) {\n console.error(\"Error searching posts:\", error);\n return c.json({ \n success: false, \n error: \"Failed to search posts\" \n }, 500);\n }\n});\n\nexport default community;","createdAt",["D",1748864121630],"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":253,"_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":254,"_79":255,"_81":256,"_83":24},"tree",[161,171,173],"files",[161,162,163,164,165,166,167,168,169,170,171,172,173],"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":250,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_175":251,"_26":252},{"_42":246,"_31":238,"_29":232,"_131":147,"_40":41,"_39":148,"_132":57,"_37":247,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_175":248,"_26":249},{"_42":239,"_31":240,"_29":241,"_131":232,"_40":41,"_39":148,"_132":57,"_37":242,"_13":134,"_33":34,"_35":243,"_23":24,"_136":-5,"_175":244,"_26":245},{"_42":230,"_31":231,"_29":55,"_131":232,"_40":41,"_39":233,"_132":24,"_37":234,"_13":134,"_33":34,"_35":235,"_23":24,"_136":-5,"_175":236,"_26":237},{"_42":226,"_31":197,"_29":191,"_131":147,"_40":41,"_39":192,"_132":57,"_37":227,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_175":228,"_26":229},{"_42":222,"_31":32,"_29":30,"_131":191,"_40":41,"_39":14,"_132":57,"_37":223,"_13":134,"_33":34,"_35":36,"_23":24,"_136":-5,"_175":224,"_26":225},{"_42":214,"_31":215,"_29":216,"_131":191,"_40":41,"_39":217,"_132":57,"_37":218,"_13":134,"_33":34,"_35":219,"_23":24,"_136":-5,"_175":220,"_26":221},{"_42":206,"_31":207,"_29":208,"_131":191,"_40":41,"_39":209,"_132":57,"_37":210,"_13":134,"_33":34,"_35":211,"_23":24,"_136":-5,"_175":212,"_26":213},{"_42":198,"_31":199,"_29":200,"_131":191,"_40":41,"_39":201,"_132":57,"_37":202,"_13":134,"_33":34,"_35":203,"_23":24,"_136":-5,"_175":204,"_26":205},{"_42":188,"_31":189,"_29":190,"_131":191,"_40":41,"_39":192,"_132":57,"_37":193,"_13":134,"_33":34,"_35":194,"_23":24,"_136":-5,"_175":195,"_26":196},{"_42":138,"_31":139,"_29":140,"_131":-5,"_40":41,"_39":141,"_132":57,"_37":185,"_13":134,"_33":143,"_35":-5,"_23":24,"_136":-5,"_175":186,"_26":187},{"_42":178,"_31":179,"_29":180,"_131":140,"_40":41,"_39":141,"_132":24,"_37":181,"_13":134,"_33":34,"_35":182,"_23":24,"_136":-5,"_175":183,"_26":184},{"_42":128,"_31":129,"_29":130,"_131":-5,"_40":41,"_39":61,"_132":57,"_37":174,"_13":134,"_33":20,"_35":135,"_23":24,"_136":-5,"_175":176,"_26":177},["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,179],["D",1748863899196],[172],[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,197,189],"routes","64fbf9f6-3fa5-11f0-afca-76b3cceeab13","skills.ts","64fbfafa-3fa5-11f0-afca-76b3cceeab13",6,["D",1748864004470],"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;",[],[146,197,199],"9571d24a-3fa5-11f0-b5a0-76b3cceeab13","sessions.ts","9571d2f4-3fa5-11f0-b5a0-76b3cceeab13",8,["D",1748864085783],"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;",[],[146,197,207],"7ef7583c-3fa5-11f0-bd8f-76b3cceeab13","matching.ts","7ef75904-3fa5-11f0-bd8f-76b3cceeab13",7,["D",1748864048071],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { \n getUserSkills, \n getSkillsByName, \n createSkillMatch, \n getMatchesForUser, \n updateMatchStatus,\n getUserById \n} from \"../database/queries.ts\";\nimport type { MatchingRequest, MatchingResponse, SkillMatch, ApiResponse } from \"../../shared/types.ts\";\n\nconst matching = new Hono();\nconst openai = new OpenAI();\n\n// AI-powered skill matching\nmatching.post(\"/find-matches\", async (c) => {\n try {\n const request: MatchingRequest = await c.req.json();\n \n if (!request.userId || !request.skillsToLearn || request.skillsToLearn.length === 0) {\n return c.json({ \n success: false, \n error: \"User ID and skills to learn are required\" \n }, 400);\n }\n\n const user = await getUserById(request.userId);\n if (!user) {\n return c.json({ \n success: false, \n error: \"User not found\" \n }, 404);\n }\n\n const matches = [];\n\n // Find potential teachers for each skill\n for (const skillName of request.skillsToLearn) {\n const teachers = await getSkillsByName(skillName, 'teach');\n \n // Filter out the user themselves\n const availableTeachers = teachers.filter(skill => skill.user_id !== request.userId);\n\n if (availableTeachers.length === 0) continue;\n\n // Get user's teaching skills for context\n const userTeachingSkills = await getUserSkills(request.userId, 'teach');\n const userSkillNames = userTeachingSkills.map(s => s.name);\n\n // Use AI to analyze compatibility and provide reasoning\n for (const teacherSkill of availableTeachers.slice(0, 3)) { // Limit to top 3 per skill\n try {\n const teacher = await getUserById(teacherSkill.user_id);\n if (!teacher) continue;\n\n const teacherSkills = await getUserSkills(teacher.id, 'teach');\n const teacherSkillNames = teacherSkills.map(s => s.name);\n\n const prompt = `\nAnalyze the compatibility between a learner and teacher for skill sharing:\n\nLEARNER PROFILE:\n- Name: ${user.name}\n- Bio: ${user.bio}\n- Skills they can teach: ${userSkillNames.join(', ') || 'None listed'}\n- Wants to learn: ${skillName}\n- Preferred teaching style: ${request.preferredTeachingStyle || 'Not specified'}\n\nTEACHER PROFILE:\n- Name: ${teacher.name}\n- Bio: ${teacher.bio}\n- Rating: ${teacher.rating}/5 (${teacher.total_sessions} sessions)\n- Can teach: ${teacherSkillNames.join(', ')}\n- Skill description: ${teacherSkill.description}\n- Proficiency level: ${teacherSkill.proficiency_level || 'Not specified'}\n\nProvide a compatibility score (0-100) and brief reasoning (max 100 words) focusing on:\n1. Teaching style match\n2. Skill level appropriateness\n3. Potential for mutual learning\n4. Communication compatibility\n\nFormat: {\"score\": number, \"reasoning\": \"string\"}`;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\",\n max_tokens: 150,\n temperature: 0.7\n });\n\n const aiResponse = completion.choices[0]?.message?.content;\n if (!aiResponse) continue;\n\n let analysis;\n try {\n analysis = JSON.parse(aiResponse);\n } catch {\n // Fallback if AI doesn't return valid JSON\n analysis = {\n score: Math.floor(Math.random() * 30) + 70, // 70-100 range\n reasoning: \"Good potential match based on skill compatibility and user profiles.\"\n };\n }\n\n matches.push({\n teacher,\n skill: teacherSkill,\n compatibilityScore: analysis.score,\n reasoning: analysis.reasoning\n });\n\n } catch (error) {\n console.error(\"Error in AI analysis:\", error);\n // Continue with other matches even if one fails\n }\n }\n }\n\n // Sort by compatibility score and limit results\n matches.sort((a, b) => b.compatibilityScore - a.compatibilityScore);\n const topMatches = matches.slice(0, 10);\n\n return c.json>({ \n success: true, \n data: { matches: topMatches }\n });\n\n } catch (error) {\n console.error(\"Error finding matches:\", error);\n return c.json({ \n success: false, \n error: \"Failed to find matches\" \n }, 500);\n }\n});\n\n// Create a skill match request\nmatching.post(\"/create-match\", async (c) => {\n try {\n const matchData = await c.req.json();\n \n if (!matchData.learner_id || !matchData.teacher_id || !matchData.skill_name) {\n return c.json({ \n success: false, \n error: \"Learner ID, teacher ID, and skill name are required\" \n }, 400);\n }\n\n // Prevent self-matching\n if (matchData.learner_id === matchData.teacher_id) {\n return c.json({ \n success: false, \n error: \"Cannot create match with yourself\" \n }, 400);\n }\n\n const skillMatch = await createSkillMatch({\n learner_id: matchData.learner_id,\n teacher_id: matchData.teacher_id,\n skill_name: matchData.skill_name,\n compatibility_score: matchData.compatibility_score || 0,\n ai_reasoning: matchData.ai_reasoning || '',\n status: 'pending'\n });\n\n return c.json>({ \n success: true, \n data: skillMatch \n });\n } catch (error) {\n console.error(\"Error creating match:\", error);\n return c.json({ \n success: false, \n error: \"Failed to create match\" \n }, 500);\n }\n});\n\n// Get matches for a user\nmatching.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 matches = await getMatchesForUser(userId, status);\n\n return c.json>({ \n success: true, \n data: matches \n });\n } catch (error) {\n console.error(\"Error fetching matches:\", error);\n return c.json({ \n success: false, \n error: \"Failed to fetch matches\" \n }, 500);\n }\n});\n\n// Update match status (accept/decline)\nmatching.put(\"/:matchId/status\", async (c) => {\n try {\n const matchId = parseInt(c.req.param(\"matchId\"));\n if (isNaN(matchId)) {\n return c.json({ \n success: false, \n error: \"Invalid match ID\" \n }, 400);\n }\n\n const { status } = await c.req.json();\n \n if (!['accepted', 'declined', 'completed'].includes(status)) {\n return c.json({ \n success: false, \n error: \"Invalid status. Must be 'accepted', 'declined', or 'completed'\" \n }, 400);\n }\n\n const updatedMatch = await updateMatchStatus(matchId, status);\n if (!updatedMatch) {\n return c.json({ \n success: false, \n error: \"Match not found\" \n }, 404);\n }\n\n return c.json>({ \n success: true, \n data: updatedMatch \n });\n } catch (error) {\n console.error(\"Error updating match status:\", error);\n return c.json({ \n success: false, \n error: \"Failed to update match status\" \n }, 500);\n }\n});\n\n// Get AI-powered learning recommendations\nmatching.get(\"/recommendations/: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 user = await getUserById(userId);\n if (!user) {\n return c.json({ \n success: false, \n error: \"User not found\" \n }, 404);\n }\n\n const userSkills = await getUserSkills(userId);\n const teachingSkills = userSkills.filter(s => s.type === 'teach').map(s => s.name);\n const learningSkills = userSkills.filter(s => s.type === 'learn').map(s => s.name);\n\n const prompt = `\nBased on this user's profile, suggest 5 new skills they might want to learn:\n\nUSER PROFILE:\n- Name: ${user.name}\n- Bio: ${user.bio}\n- Skills they can teach: ${teachingSkills.join(', ') || 'None listed'}\n- Skills they're learning: ${learningSkills.join(', ') || 'None listed'}\n\nSuggest skills that:\n1. Complement their existing skills\n2. Are popular and in-demand\n3. Match their apparent interests\n4. Offer good learning opportunities\n\nReturn as JSON array: [\"skill1\", \"skill2\", \"skill3\", \"skill4\", \"skill5\"]`;\n\n const completion = await openai.chat.completions.create({\n messages: [{ role: \"user\", content: prompt }],\n model: \"gpt-4o-mini\",\n max_tokens: 100,\n temperature: 0.8\n });\n\n const aiResponse = completion.choices[0]?.message?.content;\n let recommendations;\n \n try {\n recommendations = JSON.parse(aiResponse || '[]');\n } catch {\n // Fallback recommendations\n recommendations = [\n \"Communication Skills\",\n \"Time Management\", \n \"Critical Thinking\",\n \"Digital Marketing\",\n \"Data Analysis\"\n ];\n }\n\n return c.json>({ \n success: true, \n data: recommendations \n });\n\n } catch (error) {\n console.error(\"Error getting recommendations:\", error);\n return c.json({ \n success: false, \n error: \"Failed to get recommendations\" \n }, 500);\n }\n});\n\nexport default matching;",[],[146,197,215],"aad010e8-3fa5-11f0-b9d5-76b3cceeab13",["D",1748864121630],[],[146,197,32],"54fa9c1a-3fa5-11f0-b48c-76b3cceeab13",["D",1748863977620],[166,167,168,169,170],[146,197],"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,238,231],"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,238,240],"32eed5a0-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],[163,164],[146,238],["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":290,"_291":292,"_293":294,"_295":24,"_296":24,"_297":24,"_298":57,"_299":-5,"_300":-7,"_301":-7,"_302":134,"_303":24,"_304":24,"_305":-5,"_306":24,"_307":24,"_308":24,"_309":-5},"ENV",{"_261":262,"_263":264,"_265":85,"_266":267,"_268":269,"_270":271,"_272":273,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289},"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 · v9