[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_365":366,"_367":368},"routes/_app.x.$handle.$name",{"_97":96,"_32":46,"_105":87,"_27":106,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":59,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":80,"_81":82,"_83":84,"_85":25},"version",21,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":38,"_36":37,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","shared/types.ts","latestPath","fileId","263c1368-3fa5-11f0-b424-76b3cceeab13","name","types.ts","fileType","script","content","// Shared types for SkillSwap AI\n\nexport interface 123 {\n \n\n id: 2\n name: ®\n email: ©©©\n bio: cecilmukui@gmail.com\n avatar_url?:n/a\n timezone:EAT\n created_at: 8.30 am.\n rating: 2\n total_sessions: 5\n}\n\nexport interface Skill {\n id: 33\n user_id: 2000\n name: ss\n category: education \n type: teach\n prol ercentage: :100\n description: Male\n created_at: 8.30\n}\n\nexport interface SkillMatch {\n id: 332\n learner_id: 200\n teacher_id: 2200\n skill_name: nursing \n compatibility_score: any\n ai_reasoning: any level \n status: 'completed';\n created_at: 9.30\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}","http","createdAt",["D",1748871187098],"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",{"_97":96,"_104":100},"org",{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},"branch",{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"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",{"_44":45,"_32":46,"_39":361,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":59,"_61":-5,"_62":63,"_64":65,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":71,"_72":71,"_73":74,"_75":74,"_76":74,"_77":71,"_78":71,"_79":362,"_81":363,"_83":364,"_85":25},"tree",[170,182,192,194],"files",[170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188,189,190,191,192,193,194],"counts",{"_160":137,"_161":63,"_162":137,"_163":164,"_165":166},"contents",[127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_135":59,"_39":158,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":159},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_135":59,"_39":152,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":153},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_135":59,"_39":145,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_27":147},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":63,"_135":59,"_39":136,"_13":137,"_34":20,"_36":138,"_24":25,"_139":-5,"_27":140},"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",[132],"263c1ebc-3fa5-11f0-b424-76b3cceeab13","shared","40719501-6aa0-4845-938d-a4f0777f0cad",2,["D",1748863899196],"directory",[142],"c8f48482-3fa5-11f0-b9d5-76b3cceeab13","frontend","b2704061-7250-49c0-a02a-351d33192ccd",12,["D",1748864172198],[149],"32eeced4-3fa5-11f0-8de5-76b3cceeab13","backend","58ca6478-e48f-4149-9238-705f9b02a9af",3,["D",1748863920489],[155],"pulls","branches","forks","envVars",{"_167":137,"_169":137},"connections",{"_167":137,"_168":137},"count","unfilledCount","emptyCount",{"_44":154,"_32":155,"_30":156,"_134":-5,"_42":43,"_41":157,"_135":59,"_39":358,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":359,"_27":360},{"_44":354,"_32":346,"_30":340,"_134":156,"_42":43,"_41":157,"_135":59,"_39":355,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":356,"_27":357},{"_44":347,"_32":348,"_30":349,"_134":340,"_42":43,"_41":157,"_135":59,"_39":350,"_13":137,"_34":35,"_36":351,"_24":25,"_139":-5,"_196":352,"_27":353},{"_44":338,"_32":339,"_30":57,"_134":340,"_42":43,"_41":341,"_135":25,"_39":342,"_13":137,"_34":35,"_36":343,"_24":25,"_139":-5,"_196":344,"_27":345},{"_44":334,"_32":293,"_30":287,"_134":156,"_42":43,"_41":288,"_135":59,"_39":335,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":336,"_27":337},{"_44":326,"_32":327,"_30":328,"_134":287,"_42":43,"_41":329,"_135":59,"_39":330,"_13":137,"_34":35,"_36":331,"_24":25,"_139":-5,"_196":332,"_27":333},{"_44":318,"_32":319,"_30":320,"_134":287,"_42":43,"_41":321,"_135":59,"_39":322,"_13":137,"_34":35,"_36":323,"_24":25,"_139":-5,"_196":324,"_27":325},{"_44":310,"_32":311,"_30":312,"_134":287,"_42":43,"_41":313,"_135":59,"_39":314,"_13":137,"_34":35,"_36":315,"_24":25,"_139":-5,"_196":316,"_27":317},{"_44":302,"_32":303,"_30":304,"_134":287,"_42":43,"_41":305,"_135":59,"_39":306,"_13":137,"_34":35,"_36":307,"_24":25,"_139":-5,"_196":308,"_27":309},{"_44":294,"_32":295,"_30":296,"_134":287,"_42":43,"_41":297,"_135":59,"_39":298,"_13":137,"_34":35,"_36":299,"_24":25,"_139":-5,"_196":300,"_27":301},{"_44":284,"_32":285,"_30":286,"_134":287,"_42":43,"_41":288,"_135":59,"_39":289,"_13":137,"_34":35,"_36":290,"_24":25,"_139":-5,"_196":291,"_27":292},{"_44":276,"_32":277,"_30":278,"_134":156,"_42":43,"_41":279,"_135":59,"_39":280,"_13":137,"_34":35,"_36":281,"_24":25,"_139":-5,"_196":282,"_27":283},{"_44":148,"_32":149,"_30":150,"_134":-5,"_42":43,"_41":151,"_135":59,"_39":273,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":274,"_27":275},{"_44":269,"_32":244,"_30":238,"_134":150,"_42":43,"_41":264,"_135":59,"_39":270,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":271,"_27":272},{"_44":261,"_32":262,"_30":263,"_134":238,"_42":43,"_41":264,"_135":59,"_39":265,"_13":137,"_34":35,"_36":266,"_24":25,"_139":-5,"_196":267,"_27":268},{"_44":253,"_32":254,"_30":255,"_134":238,"_42":43,"_41":256,"_135":59,"_39":257,"_13":137,"_34":35,"_36":258,"_24":25,"_139":-5,"_196":259,"_27":260},{"_44":245,"_32":246,"_30":247,"_134":238,"_42":43,"_41":248,"_135":59,"_39":249,"_13":137,"_34":35,"_36":250,"_24":25,"_139":-5,"_196":251,"_27":252},{"_44":235,"_32":236,"_30":237,"_134":238,"_42":43,"_41":239,"_135":59,"_39":240,"_13":137,"_34":35,"_36":241,"_24":25,"_139":-5,"_196":242,"_27":243},{"_44":228,"_32":229,"_30":230,"_134":150,"_42":43,"_41":151,"_135":59,"_39":231,"_13":137,"_34":20,"_36":232,"_24":25,"_139":-5,"_196":233,"_27":234},{"_44":220,"_32":221,"_30":222,"_134":150,"_42":43,"_41":223,"_135":59,"_39":224,"_13":137,"_34":35,"_36":225,"_24":25,"_139":-5,"_196":226,"_27":227},{"_44":213,"_32":214,"_30":215,"_134":150,"_42":43,"_41":216,"_135":59,"_39":217,"_13":137,"_34":35,"_36":106,"_24":25,"_139":-5,"_196":218,"_27":219},{"_44":206,"_32":207,"_30":208,"_134":150,"_42":43,"_41":209,"_135":59,"_39":210,"_13":137,"_34":35,"_36":106,"_24":25,"_139":-5,"_196":211,"_27":212},{"_44":141,"_32":142,"_30":143,"_134":-5,"_42":43,"_41":144,"_135":59,"_39":203,"_13":137,"_34":146,"_36":-5,"_24":25,"_139":-5,"_196":204,"_27":205},{"_44":199,"_32":33,"_30":31,"_134":143,"_42":43,"_41":14,"_135":59,"_39":200,"_13":144,"_34":38,"_36":37,"_24":25,"_139":-5,"_196":201,"_27":202},{"_44":131,"_32":132,"_30":133,"_134":-5,"_42":43,"_41":63,"_135":59,"_39":195,"_13":137,"_34":20,"_36":138,"_24":25,"_139":-5,"_196":197,"_27":198},["D",1748863885941],"children",[],[132],"1e28fb8a-3fb6-11f0-96ed-76b3cceeab13",["D",1748871187098],[],[142,33],["D",1748863899196],[193],[142],"8fa5b3a6-3fa8-11f0-ac09-76b3cceeab13","new-file-9603.tsx","8fa5b46e-3fa8-11f0-ac09-76b3cceeab13",19,["D",1748865364548],[],[149,207],"8f208370-3fa8-11f0-bd44-76b3cceeab13","new-file-9506.tsx","8f208438-3fa8-11f0-bd44-76b3cceeab13",18,["D",1748865363675],[],[149,214],"cdd5a828-3fa5-11f0-a1e5-76b3cceeab13","index.tsx","cdd5a922-3fa5-11f0-a1e5-76b3cceeab13",13,["D",1748864180388],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport App from \"./components/App.tsx\";\n\n// Get initial data injected by the server\nconst initialData = (window as any).__INITIAL_DATA__ || {};\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[149,221],"c8f47528-3fa5-11f0-b9d5-76b3cceeab13","index.html","c8f475fa-3fa5-11f0-b9d5-76b3cceeab13",["D",1748864172198],"\n\n\n \n \n SkillSwap AI - Connect, Learn, Grow\n \n \n 🎯\">\n \n\n\n

\n \n

Loading SkillSwap AI...

Connecting you with amazing learning opportunities

\n\n \n\n",[],[149,229],"0bbcc0fe-3fa6-11f0-913f-76b3cceeab13","UserProfile.tsx","0bbcc1da-3fa6-11f0-913f-76b3cceeab13","da18fc47-db72-425b-8ff0-d542110777bf",15,["D",1748864284247],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Skill } from \"../../shared/types.ts\";\n\ninterface UserProfileProps {\n user: User;\n onUserUpdate: (user: User) => void;\n}\n\nexport default function UserProfile({ user, onUserUpdate }: UserProfileProps) {\n const [isEditing, setIsEditing] = useState(false);\n const [formData, setFormData] = useState({\n name: user.name,\n bio: user.bio,\n timezone: user.timezone\n });\n const [skills, setSkills] = useState<{ teach: Skill[]; learn: Skill[] }>({\n teach: [],\n learn: []\n });\n const [newSkill, setNewSkill] = useState({\n name: '',\n category: '',\n type: 'teach' as 'teach' | 'learn',\n proficiency_level: 'intermediate' as 'beginner' | 'intermediate' | 'advanced' | 'expert',\n description: ''\n });\n const [isLoading, setIsLoading] = useState(true);\n const [showAddSkill, setShowAddSkill] = useState(false);\n\n useEffect(() => {\n loadUserSkills();\n }, [user.id]);\n\n const loadUserSkills = async () => {\n try {\n setIsLoading(true);\n const [teachResponse, learnResponse] = await Promise.all([\n fetch(`/api/skills/user/${user.id}?type=teach`),\n fetch(`/api/skills/user/${user.id}?type=learn`)\n ]);\n\n const teachData = await teachResponse.json();\n const learnData = await learnResponse.json();\n\n setSkills({\n teach: teachData.success ? teachData.data : [],\n learn: learnData.success ? learnData.data : []\n });\n } catch (error) {\n console.error(\"Error loading skills:\", error);\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleUpdateProfile = async (e: React.FormEvent) => {\n e.preventDefault();\n try {\n const response = await fetch(`/api/users/${user.id}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(formData)\n });\n\n const data = await response.json();\n if (data.success) {\n onUserUpdate(data.data);\n setIsEditing(false);\n } else {\n alert('Failed to update profile: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error updating profile:\", error);\n alert('Failed to update profile');\n }\n };\n\n const handleAddSkill = async (e: React.FormEvent) => {\n e.preventDefault();\n try {\n const response = await fetch('/api/skills', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n ...newSkill,\n user_id: user.id\n })\n });\n\n const data = await response.json();\n if (data.success) {\n await loadUserSkills();\n setNewSkill({\n name: '',\n category: '',\n type: 'teach',\n proficiency_level: 'intermediate',\n description: ''\n });\n setShowAddSkill(false);\n } else {\n alert('Failed to add skill: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error adding skill:\", error);\n alert('Failed to add skill');\n }\n };\n\n const handleDeleteSkill = async (skillId: number) => {\n if (!confirm('Are you sure you want to delete this skill?')) return;\n\n try {\n const response = await fetch(`/api/skills/${skillId}?userId=${user.id}`, {\n method: 'DELETE'\n });\n\n const data = await response.json();\n if (data.success) {\n await loadUserSkills();\n } else {\n alert('Failed to delete skill: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error deleting skill:\", error);\n alert('Failed to delete skill');\n }\n };\n\n const skillCategories = [\n 'Programming', 'Languages', 'Music', 'Arts', 'Sports', 'Cooking',\n 'Business', 'Design', 'Writing', 'Science', 'Fitness', 'Life Skills'\n ];\n\n if (isLoading) {\n return (\n

\n );\n }\n\n return (\n

\n {/* Profile Header */}\n

\n {user.name.charAt(0).toUpperCase()}\n

{user.name}

{user.email}

\n \n ⭐ {user.rating}/5 rating\n \n \n 📅 {user.total_sessions} sessions completed\n \n \n 🌍 {user.timezone}\n \n

\n setIsEditing(!isEditing)}\n className=\"px-4 py-2 bg-purple-600 text-white rounded-lg hover:bg-purple-700 transition-colors\"\n >\n {isEditing ? 'Cancel' : 'Edit Profile'}\n \n

\n\n {isEditing ? (\n

\n Name\n setFormData({ ...formData, name: e.target.value })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n required\n />\n

\n Bio\n setFormData({ ...formData, bio: e.target.value })}\n rows={3}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n placeholder=\"Tell others about yourself, your interests, and what you're passionate about...\"\n />\n

\n Timezone\n setFormData({ ...formData, timezone: e.target.value })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n >\n \n \n \n \n \n \n \n \n \n \n

\n \n Save Changes\n \n setIsEditing(false)}\n className=\"px-4 py-2 bg-gray-300 text-gray-700 rounded-lg hover:bg-gray-400 transition-colors\"\n >\n Cancel\n \n

\n ) : (\n

{user.bio || \"No bio provided yet.\"}

\n )}\n

\n\n {/* Skills Section */}\n

\n {/* Skills I Can Teach */}\n

\n 🎓 Skills I Can Teach\n

\n {\n setNewSkill({ ...newSkill, type: 'teach' });\n setShowAddSkill(true);\n }}\n className=\"px-3 py-1 bg-green-600 text-white rounded-lg text-sm hover:bg-green-700 transition-colors\"\n >\n + Add Skill\n \n

\n {skills.teach.length === 0 ? (\n

No teaching skills added yet.

\n ) : (\n skills.teach.map((skill) => (\n

{skill.name}

\n {skill.category}\n {skill.proficiency_level && (\n \n {skill.proficiency_level}\n \n )}\n

\n {skill.description && (\n

{skill.description}

\n )}\n

\n handleDeleteSkill(skill.id)}\n className=\"text-red-500 hover:text-red-700 text-sm\"\n >\n ✕\n \n

\n ))\n )}\n

\n\n {/* Skills I Want to Learn */}\n

\n 📚 Skills I Want to Learn\n

\n {\n setNewSkill({ ...newSkill, type: 'learn' });\n setShowAddSkill(true);\n }}\n className=\"px-3 py-1 bg-blue-600 text-white rounded-lg text-sm hover:bg-blue-700 transition-colors\"\n >\n + Add Skill\n \n

\n {skills.learn.length === 0 ? (\n

No learning goals added yet.

\n ) : (\n skills.learn.map((skill) => (\n

{skill.name}

\n {skill.category}\n

\n {skill.description && (\n

{skill.description}

\n )}\n

\n handleDeleteSkill(skill.id)}\n className=\"text-red-500 hover:text-red-700 text-sm\"\n >\n ✕\n \n

\n ))\n )}\n

\n\n {/* Add Skill Modal */}\n {showAddSkill && (\n

\n Add New {newSkill.type === 'teach' ? 'Teaching' : 'Learning'} Skill\n

\n Skill Name\n setNewSkill({ ...newSkill, name: e.target.value })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n placeholder=\"e.g., JavaScript, Guitar, Spanish\"\n required\n />\n

\n Category\n setNewSkill({ ...newSkill, category: e.target.value })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n required\n >\n \n {skillCategories.map((category) => (\n \n ))}\n \n

\n {newSkill.type === 'teach' && (\n

\n Proficiency Level\n setNewSkill({ ...newSkill, proficiency_level: e.target.value as any })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n >\n \n \n \n \n \n

\n )}\n

\n Description\n setNewSkill({ ...newSkill, description: e.target.value })}\n rows={3}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n placeholder=\"Describe your experience or learning goals...\"\n />\n

\n \n Add Skill\n \n setShowAddSkill(false)}\n className=\"flex-1 px-4 py-2 bg-gray-300 text-gray-700 rounded-lg hover:bg-gray-400 transition-colors\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[149,244,236],"components","2e43692a-3fa6-11f0-a283-76b3cceeab13","SkillMatcher.tsx","2e436a10-3fa6-11f0-a283-76b3cceeab13",16,["D",1748864342158],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Skill, MatchingResponse } from \"../../shared/types.ts\";\n\ninterface SkillMatcherProps {\n user: User;\n}\n\nexport default function SkillMatcher({ user }: SkillMatcherProps) {\n const [learningSkills, setLearningSkills] = useState([]);\n const [selectedSkills, setSelectedSkills] = useState([]);\n const [matches, setMatches] = useState([]);\n const [recommendations, setRecommendations] = useState([]);\n const [isLoading, setIsLoading] = useState(false);\n const [isLoadingRecommendations, setIsLoadingRecommendations] = useState(false);\n const [searchQuery, setSearchQuery] = useState('');\n\n useEffect(() => {\n loadLearningSkills();\n loadRecommendations();\n }, [user.id]);\n\n const loadLearningSkills = async () => {\n try {\n const response = await fetch(`/api/skills/user/${user.id}?type=learn`);\n const data = await response.json();\n if (data.success) {\n setLearningSkills(data.data);\n setSelectedSkills(data.data.map((skill: Skill) => skill.name));\n }\n } catch (error) {\n console.error(\"Error loading learning skills:\", error);\n }\n };\n\n const loadRecommendations = async () => {\n try {\n setIsLoadingRecommendations(true);\n const response = await fetch(`/api/matching/recommendations/${user.id}`);\n const data = await response.json();\n if (data.success) {\n setRecommendations(data.data);\n }\n } catch (error) {\n console.error(\"Error loading recommendations:\", error);\n } finally {\n setIsLoadingRecommendations(false);\n }\n };\n\n const findMatches = async () => {\n if (selectedSkills.length === 0) {\n alert('Please select at least one skill to learn');\n return;\n }\n\n try {\n setIsLoading(true);\n const response = await fetch('/api/matching/find-matches', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n userId: user.id,\n skillsToLearn: selectedSkills,\n preferredTeachingStyle: 'interactive',\n availability: ['weekends', 'evenings']\n })\n });\n\n const data = await response.json();\n if (data.success) {\n setMatches(data.data.matches);\n } else {\n alert('Failed to find matches: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error finding matches:\", error);\n alert('Failed to find matches');\n } finally {\n setIsLoading(false);\n }\n };\n\n const createMatch = async (teacherId: number, skillName: string, compatibilityScore: number, reasoning: string) => {\n try {\n const response = await fetch('/api/matching/create-match', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n learner_id: user.id,\n teacher_id: teacherId,\n skill_name: skillName,\n compatibility_score: compatibilityScore,\n ai_reasoning: reasoning\n })\n });\n\n const data = await response.json();\n if (data.success) {\n alert('Match request sent successfully!');\n } else {\n alert('Failed to create match: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error creating match:\", error);\n alert('Failed to create match');\n }\n };\n\n const addSkillToLearn = (skillName: string) => {\n if (!selectedSkills.includes(skillName)) {\n setSelectedSkills([...selectedSkills, skillName]);\n }\n };\n\n const removeSkillToLearn = (skillName: string) => {\n setSelectedSkills(selectedSkills.filter(skill => skill !== skillName));\n };\n\n const filteredRecommendations = recommendations.filter(skill =>\n skill.toLowerCase().includes(searchQuery.toLowerCase()) &&\n !selectedSkills.includes(skill)\n );\n\n return (\n

\n {/* Header */}\n

🎯 AI-Powered Skill Matching

\n Find the perfect teachers for your learning journey. Our AI analyzes compatibility, \n teaching styles, and mutual learning opportunities.\n

\n\n {/* Skill Selection */}\n

Select Skills to Learn

\n \n {/* Current Learning Skills */}\n

Your Learning Goals

\n {learningSkills.map((skill) => (\n \n selectedSkills.includes(skill.name)\n ? removeSkillToLearn(skill.name)\n : addSkillToLearn(skill.name)\n }\n >\n {skill.name}\n {selectedSkills.includes(skill.name) && ' ✓'}\n

\n ))}\n

\n\n {/* AI Recommendations */}\n

AI Recommendations for You

\n {isLoadingRecommendations ? (\n

\n Getting personalized recommendations...\n

\n ) : (\n

\n {recommendations.slice(0, 8).map((skill) => (\n addSkillToLearn(skill)}\n className=\"px-3 py-1 bg-blue-100 text-blue-700 rounded-full text-sm font-medium hover:bg-blue-200 transition-colors\"\n disabled={selectedSkills.includes(skill)}\n >\n {skill} +\n \n ))}\n

\n )}\n

\n\n {/* Search for Skills */}\n

Search for Skills

\n setSearchQuery(e.target.value)}\n placeholder=\"Search for skills to learn...\"\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n />\n {\n if (searchQuery.trim() && !selectedSkills.includes(searchQuery.trim())) {\n addSkillToLearn(searchQuery.trim());\n setSearchQuery('');\n }\n }}\n className=\"px-4 py-2 bg-purple-600 text-white rounded-lg hover:bg-purple-700 transition-colors\"\n >\n Add\n \n

\n {filteredRecommendations.length > 0 && searchQuery && (\n

\n {filteredRecommendations.slice(0, 5).map((skill) => (\n {\n addSkillToLearn(skill);\n setSearchQuery('');\n }}\n className=\"px-2 py-1 bg-gray-100 text-gray-700 rounded text-sm hover:bg-gray-200 transition-colors\"\n >\n {skill}\n \n ))}\n

\n )}\n

\n\n {/* Selected Skills */}\n {selectedSkills.length > 0 && (\n

Selected Skills ({selectedSkills.length})

\n {selectedSkills.map((skill) => (\n \n {skill}\n removeSkillToLearn(skill)}\n className=\"text-purple-200 hover:text-white\"\n >\n ✕\n \n

\n ))}\n

\n )}\n\n {/* Find Matches Button */}\n \n {isLoading ? (\n

\n Finding Perfect Matches...\n

\n ) : (\n `🎯 Find Matches for ${selectedSkills.length} Skill${selectedSkills.length !== 1 ? 's' : ''}`\n )}\n \n \n\n {/* Matches Results */}\n {matches.length > 0 && (\n

\n 🎉 Found {matches.length} Perfect Match{matches.length !== 1 ? 'es' : ''}\n

\n {matches.map((match, index) => (\n

\n {match.teacher.name.charAt(0).toUpperCase()}\n

{match.teacher.name}

\n ⭐ {match.teacher.rating}/5\n •\n {match.teacher.total_sessions} sessions\n

\n {match.compatibilityScore}%\n

compatibility

\n\n

{match.skill.name}

\n {match.skill.proficiency_level && (\n

\n Level: {match.skill.proficiency_level}\n

\n )}\n

\n\n

AI Analysis:

{match.reasoning}

\n\n {match.skill.description && (\n

Teaching Approach:

{match.skill.description}

\n )}\n\n createMatch(\n match.teacher.id,\n match.skill.name,\n match.compatibilityScore,\n match.reasoning\n )}\n className=\"w-full px-4 py-2 bg-green-600 text-white rounded-lg hover:bg-green-700 transition-colors\"\n >\n Send Match Request\n \n

\n ))}\n

\n )}\n\n {/* No Matches State */}\n {matches.length === 0 && !isLoading && selectedSkills.length > 0 && (\n

🔍

No matches found yet

\n Try adjusting your skill selection or check back later as new teachers join the platform.\n

\n \n Search Again\n \n

\n )}\n \n );\n}",[],[149,244,246],"5a51bd64-3fa6-11f0-a780-76b3cceeab13","Scheduler.tsx","5a51be2c-3fa6-11f0-a780-76b3cceeab13",17,["D",1748864416084],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { User, Session, SkillMatch } from \"../../shared/types.ts\";\n\ninterface SchedulerProps {\n user: User;\n}\n\nexport default function Scheduler({ user }: SchedulerProps) {\n const [sessions, setSessions] = useState([]);\n const [matches, setMatches] = useState([]);\n const [upcomingSessions, setUpcomingSessions] = useState([]);\n const [isLoading, setIsLoading] = useState(true);\n const [showScheduleModal, setShowScheduleModal] = useState(false);\n const [selectedMatch, setSelectedMatch] = useState(null);\n const [scheduleForm, setScheduleForm] = useState({\n scheduled_at: '',\n duration_minutes: 60,\n notes: ''\n });\n const [activeTab, setActiveTab] = useState<'upcoming' | 'all' | 'matches'>('upcoming');\n\n useEffect(() => {\n loadData();\n }, [user.id]);\n\n const loadData = async () => {\n try {\n setIsLoading(true);\n const [sessionsResponse, matchesResponse, upcomingResponse] = await Promise.all([\n fetch(`/api/sessions/user/${user.id}`),\n fetch(`/api/matching/user/${user.id}?status=accepted`),\n fetch(`/api/sessions/upcoming/${user.id}`)\n ]);\n\n const [sessionsData, matchesData, upcomingData] = await Promise.all([\n sessionsResponse.json(),\n matchesResponse.json(),\n upcomingResponse.json()\n ]);\n\n if (sessionsData.success) setSessions(sessionsData.data);\n if (matchesData.success) setMatches(matchesData.data);\n if (upcomingData.success) setUpcomingSessions(upcomingData.data);\n } catch (error) {\n console.error(\"Error loading data:\", error);\n } finally {\n setIsLoading(false);\n }\n };\n\n const handleScheduleSession = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!selectedMatch) return;\n\n try {\n const response = await fetch('/api/sessions', {\n method: 'POST',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify({\n match_id: selectedMatch.id,\n learner_id: selectedMatch.learner_id,\n teacher_id: selectedMatch.teacher_id,\n skill_name: selectedMatch.skill_name,\n scheduled_at: scheduleForm.scheduled_at,\n duration_minutes: scheduleForm.duration_minutes,\n notes: scheduleForm.notes\n })\n });\n\n const data = await response.json();\n if (data.success) {\n setShowScheduleModal(false);\n setSelectedMatch(null);\n setScheduleForm({ scheduled_at: '', duration_minutes: 60, notes: '' });\n await loadData();\n alert('Session scheduled successfully!');\n } else {\n alert('Failed to schedule session: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error scheduling session:\", error);\n alert('Failed to schedule session');\n }\n };\n\n const updateSessionStatus = async (sessionId: number, status: string, rating?: number) => {\n try {\n const updates: any = { status };\n if (rating) {\n // Determine if user is learner or teacher to set appropriate rating\n const session = sessions.find(s => s.id === sessionId);\n if (session) {\n if (session.learner_id === user.id) {\n updates.teacher_rating = rating;\n } else {\n updates.learner_rating = rating;\n }\n }\n }\n\n const response = await fetch(`/api/sessions/${sessionId}`, {\n method: 'PUT',\n headers: { 'Content-Type': 'application/json' },\n body: JSON.stringify(updates)\n });\n\n const data = await response.json();\n if (data.success) {\n await loadData();\n alert('Session updated successfully!');\n } else {\n alert('Failed to update session: ' + data.error);\n }\n } catch (error) {\n console.error(\"Error updating session:\", error);\n alert('Failed to update session');\n }\n };\n\n const formatDateTime = (dateString: string) => {\n const date = new Date(dateString);\n return date.toLocaleString('en-US', {\n weekday: 'short',\n month: 'short',\n day: 'numeric',\n hour: 'numeric',\n minute: '2-digit',\n hour12: true\n });\n };\n\n const getMinDateTime = () => {\n const now = new Date();\n now.setHours(now.getHours() + 1); // Minimum 1 hour from now\n return now.toISOString().slice(0, 16);\n };\n\n if (isLoading) {\n return (\n

\n );\n }\n\n return (\n

\n {/* Header */}\n

📅 Session Scheduler

\n Manage your learning sessions, schedule new meetings, and track your progress.\n

\n\n {/* Quick Stats */}\n

📅

{upcomingSessions.length}

Upcoming

✅

\n {sessions.filter(s => s.status === 'completed').length}\n

Completed

🎯

{matches.length}

Ready to Schedule

⏱️

\n {Math.round(sessions.filter(s => s.status === 'completed')\n .reduce((total, s) => total + (s.duration_minutes || 60), 0) / 60)}h\n

Total Hours

\n\n {/* Tabs */}\n

\n {[\n { id: 'upcoming', name: 'Upcoming Sessions', count: upcomingSessions.length },\n { id: 'all', name: 'All Sessions', count: sessions.length },\n { id: 'matches', name: 'Ready to Schedule', count: matches.length }\n ].map((tab) => (\n setActiveTab(tab.id as any)}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === tab.id\n ? 'border-purple-500 text-purple-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n {tab.name} ({tab.count})\n \n ))}\n

\n\n

\n {/* Upcoming Sessions */}\n {activeTab === 'upcoming' && (\n

\n {upcomingSessions.length === 0 ? (\n

📅

No upcoming sessions

Schedule your first session to get started!

\n setActiveTab('matches')}\n className=\"px-4 py-2 bg-purple-600 text-white rounded-lg hover:bg-purple-700 transition-colors\"\n >\n View Available Matches\n \n

\n ) : (\n upcomingSessions.map((session) => (\n

{session.skill_name}

\n \n {session.learner_id === user.id ? 'Learning' : 'Teaching'}\n \n

📅 {formatDateTime(session.scheduled_at)}

⏱️ {session.duration_minutes} minutes

👤 With: {session.learner_id === user.id ? session.teacher_name : session.learner_name}

\n {session.meeting_link && (\n

🔗 Join Meeting

\n )}\n {session.notes &&

📝 {session.notes}

}\n

\n updateSessionStatus(session.id, 'completed')}\n className=\"px-3 py-1 bg-green-600 text-white rounded text-sm hover:bg-green-700 transition-colors\"\n >\n Mark Complete\n \n updateSessionStatus(session.id, 'cancelled')}\n className=\"px-3 py-1 bg-red-600 text-white rounded text-sm hover:bg-red-700 transition-colors\"\n >\n Cancel\n \n

\n ))\n )}\n

\n )}\n\n {/* All Sessions */}\n {activeTab === 'all' && (\n

\n {sessions.length === 0 ? (\n

📚

No sessions yet

Your learning journey starts here!

\n ) : (\n sessions.map((session) => (\n

{session.skill_name}

\n \n {session.learner_id === user.id ? 'Learning' : 'Teaching'}\n \n \n {session.status}\n \n

📅 {formatDateTime(session.scheduled_at)}

⏱️ {session.duration_minutes} minutes

👤 With: {session.learner_id === user.id ? session.teacher_name : session.learner_name}

\n {session.notes &&

📝 {session.notes}

}\n

\n {session.status === 'completed' && (\n

\n {session.learner_id === user.id && session.teacher_rating && (\n

Teacher: ⭐ {session.teacher_rating}/5

\n )}\n {session.teacher_id === user.id && session.learner_rating && (\n

Learner: ⭐ {session.learner_rating}/5

\n )}\n

\n ))\n )}\n

\n )}\n\n {/* Available Matches */}\n {activeTab === 'matches' && (\n

\n {matches.length === 0 ? (\n

🎯

No accepted matches

Find new matches to schedule sessions!

\n window.location.hash = '#matcher'}\n className=\"px-4 py-2 bg-purple-600 text-white rounded-lg hover:bg-purple-700 transition-colors\"\n >\n Find Matches\n \n

\n ) : (\n matches.map((match) => (\n

{match.skill_name}

\n \n {match.compatibility_score}% match\n \n

👤 {match.learner_id === user.id ? 'Teacher' : 'Learner'}: {match.learner_id === user.id ? match.teacher_name : match.learner_name}

🤖 AI Analysis: {match.ai_reasoning}

\n {\n setSelectedMatch(match);\n setShowScheduleModal(true);\n }}\n className=\"px-4 py-2 bg-blue-600 text-white rounded-lg hover:bg-blue-700 transition-colors\"\n >\n Schedule Session\n \n

\n ))\n )}\n

\n )}\n

\n\n {/* Schedule Session Modal */}\n {showScheduleModal && selectedMatch && (\n

Schedule Session

{selectedMatch.skill_name}

\n With: {selectedMatch.learner_id === user.id ? selectedMatch.teacher_name : selectedMatch.learner_name}\n

\n Date & Time\n setScheduleForm({ ...scheduleForm, scheduled_at: e.target.value })}\n min={getMinDateTime()}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n required\n />\n

\n Duration\n setScheduleForm({ ...scheduleForm, duration_minutes: parseInt(e.target.value) })}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n >\n \n \n \n \n \n

\n Notes (Optional)\n setScheduleForm({ ...scheduleForm, notes: e.target.value })}\n rows={3}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n placeholder=\"Any specific topics or goals for this session...\"\n />\n

\n \n Schedule Session\n \n {\n setShowScheduleModal(false);\n setSelectedMatch(null);\n }}\n className=\"flex-1 px-4 py-2 bg-gray-300 text-gray-700 rounded-lg hover:bg-gray-400 transition-colors\"\n >\n Cancel\n \n

\n )}\n

\n );\n}",[],[149,244,254],"e83226e2-3fa5-11f0-bbb0-76b3cceeab13","App.tsx","e83227aa-3fa5-11f0-bbb0-76b3cceeab13",14,["D",1748864224614],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport UserProfile from \"./UserProfile.tsx\";\nimport SkillMatcher from \"./SkillMatcher.tsx\";\nimport Scheduler from \"./Scheduler.tsx\";\nimport ProgressTracker from \"./ProgressTracker.tsx\";\nimport CommunityBoard from \"./CommunityBoard.tsx\";\nimport type { User } from \"../../shared/types.ts\";\n\ninterface AppProps {\n initialData: any;\n}\n\ntype TabType = 'dashboard' | 'profile' | 'matcher' | 'sessions' | 'progress' | 'community';\n\nexport default function App({ initialData }: AppProps) {\n const [currentTab, setCurrentTab] = useState('dashboard');\n const [currentUser, setCurrentUser] = useState(null);\n const [isLoading, setIsLoading] = useState(true);\n\n useEffect(() => {\n // Simulate loading and check for existing user\n const loadUser = async () => {\n try {\n // In a real app, this would check authentication\n // For demo purposes, we'll create a demo user\n const demoUser: User = {\n id: 1,\n name: \"Demo User\",\n email: \"demo@skillswap.ai\",\n bio: \"Passionate learner and teacher, excited to share knowledge and grow together!\",\n timezone: \"UTC\",\n rating: 4.8,\n total_sessions: 12,\n created_at: new Date().toISOString()\n };\n setCurrentUser(demoUser);\n } catch (error) {\n console.error(\"Error loading user:\", error);\n } finally {\n setIsLoading(false);\n }\n };\n\n setTimeout(loadUser, 1000); // Simulate loading time\n }, []);\n\n if (isLoading) {\n return (\n

Loading SkillSwap AI...

Connecting you with amazing learning opportunities

\n );\n }\n\n const tabs = [\n { id: 'dashboard', name: 'Dashboard', icon: '🏠' },\n { id: 'profile', name: 'Profile', icon: '👤' },\n { id: 'matcher', name: 'Find Matches', icon: '🎯' },\n { id: 'sessions', name: 'Sessions', icon: '📅' },\n { id: 'progress', name: 'Progress', icon: '📈' },\n { id: 'community', name: 'Community', icon: '💬' }\n ];\n\n const renderTabContent = () => {\n if (!currentUser) return null;\n\n switch (currentTab) {\n case 'dashboard':\n return ;\n case 'profile':\n return ;\n case 'matcher':\n return ;\n case 'sessions':\n return ;\n case 'progress':\n return ;\n case 'community':\n return ;\n default:\n return ;\n }\n };\n\n return (\n

\n {/* Header */}\n

🎯 SkillSwap AI

\n \n Beta\n \n

\n {currentUser && (\n

{currentUser.name}

⭐ {currentUser.rating} • {currentUser.total_sessions} sessions

\n 👤\n

\n )}\n

\n\n {/* Navigation */}\n

\n {tabs.map((tab) => (\n setCurrentTab(tab.id as TabType)}\n className={`flex items-center space-x-2 py-4 px-2 border-b-2 font-medium text-sm whitespace-nowrap ${\n currentTab === tab.id\n ? 'border-purple-500 text-purple-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n {tab.icon}\n {tab.name}\n \n ))}\n

\n\n {/* Main Content */}\n

\n {renderTabContent()}\n

\n );\n}\n\n// Dashboard Component\nfunction Dashboard({ user, onNavigate }: { user: User; onNavigate: (tab: TabType) => void }) {\n const stats = [\n { label: 'Sessions Completed', value: user.total_sessions, icon: '✅' },\n { label: 'Average Rating', value: `${user.rating}/5`, icon: '⭐' },\n { label: 'Skills Teaching', value: '5', icon: '🎓' },\n { label: 'Skills Learning', value: '3', icon: '📚' }\n ];\n\n const quickActions = [\n { label: 'Find New Matches', action: () => onNavigate('matcher'), icon: '🎯', color: 'bg-blue-500' },\n { label: 'Schedule Session', action: () => onNavigate('sessions'), icon: '📅', color: 'bg-green-500' },\n { label: 'Update Profile', action: () => onNavigate('profile'), icon: '👤', color: 'bg-purple-500' },\n { label: 'Join Community', action: () => onNavigate('community'), icon: '💬', color: 'bg-orange-500' }\n ];\n\n return (\n

\n {/* Welcome Section */}\n

\n Welcome back, {user.name}! 👋\n

\n Ready to learn something new or share your expertise? Let's make today productive!\n

\n\n {/* Stats Grid */}\n

\n {stats.map((stat, index) => (\n

{stat.icon}

{stat.value}

{stat.label}

\n ))}\n

\n\n {/* Quick Actions */}\n

Quick Actions

\n {quickActions.map((action, index) => (\n \n

{action.icon}

{action.label}

\n \n ))}\n

\n\n {/* Recent Activity */}\n

Recent Activity

🎯

New match found for JavaScript!

Sarah Chen wants to learn from you

2h ago

📅

Session completed: Python Basics

Great session with Mike Rodriguez

1d ago

💬

New comment on your post

\"Tips for Learning Guitar\" received 3 new comments

2d ago

\n );\n}",[],[149,244,262],"e8324154-3fa5-11f0-bbb0-76b3cceeab13",["D",1748864224614],[184,185,186,187],[149,244],["D",1748864172198],[183,188,189,190,191],[149],"c086e880-3fa5-11f0-985b-76b3cceeab13","index.ts","c086e952-3fa5-11f0-985b-76b3cceeab13",11,["D",1748864158063],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { runMigrations } from \"./database/migrations.ts\";\n\n// Import route modules\nimport users from \"./routes/users.ts\";\nimport skills from \"./routes/skills.ts\";\nimport matching from \"./routes/matching.ts\";\nimport sessions from \"./routes/sessions.ts\";\nimport community from \"./routes/community.ts\";\nimport staticRoutes from \"./routes/static.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\ntry {\n await runMigrations();\n console.log(\"SkillSwap AI backend initialized successfully\");\n} catch (error) {\n console.error(\"Failed to initialize database:\", error);\n}\n\n// API routes\napp.route(\"/api/users\", users);\napp.route(\"/api/skills\", skills);\napp.route(\"/api/matching\", matching);\napp.route(\"/api/sessions\", sessions);\napp.route(\"/api/community\", community);\n\n// Health check endpoint\napp.get(\"/api/health\", (c) => {\n return c.json({\n status: \"healthy\",\n timestamp: new Date().toISOString(),\n service: \"SkillSwap AI API\",\n version: \"1.0.0\"\n });\n});\n\n// API documentation endpoint\napp.get(\"/api/docs\", (c) => {\n const apiDocs = {\n title: \"SkillSwap AI API\",\n version: \"1.0.0\",\n description: \"AI-powered skill sharing platform API\",\n endpoints: {\n users: {\n \"POST /api/users\": \"Create a new user\",\n \"GET /api/users/:id\": \"Get user by ID\",\n \"GET /api/users/email/:email\": \"Get user by email\",\n \"PUT /api/users/:id\": \"Update user profile\"\n },\n skills: {\n \"POST /api/skills\": \"Create a new skill\",\n \"GET /api/skills/user/:userId\": \"Get user's skills\",\n \"GET /api/skills/search\": \"Search skills by name\",\n \"DELETE /api/skills/:id\": \"Delete a skill\",\n \"GET /api/skills/popular\": \"Get popular skills\"\n },\n matching: {\n \"POST /api/matching/find-matches\": \"Find AI-powered skill matches\",\n \"POST /api/matching/create-match\": \"Create a skill match request\",\n \"GET /api/matching/user/:userId\": \"Get user's matches\",\n \"PUT /api/matching/:matchId/status\": \"Update match status\",\n \"GET /api/matching/recommendations/:userId\": \"Get AI learning recommendations\"\n },\n sessions: {\n \"POST /api/sessions\": \"Create a new session\",\n \"GET /api/sessions/user/:userId\": \"Get user's sessions\",\n \"PUT /api/sessions/:sessionId\": \"Update session\",\n \"GET /api/sessions/upcoming/:userId\": \"Get upcoming sessions\",\n \"GET /api/sessions/stats/:userId\": \"Get session statistics\"\n },\n community: {\n \"POST /api/community/posts\": \"Create a community post\",\n \"GET /api/community/posts\": \"Get community posts\",\n \"GET /api/community/posts/:postId/comments\": \"Get post comments\",\n \"POST /api/community/posts/:postId/comments\": \"Create a comment\",\n \"POST /api/community/posts/:postId/like\": \"Like a post\",\n \"GET /api/community/trending\": \"Get trending topics\",\n \"GET /api/community/stats\": \"Get community statistics\",\n \"GET /api/community/search\": \"Search posts\"\n }\n },\n authentication: \"Currently no authentication required (demo mode)\",\n rateLimit: \"No rate limiting implemented\",\n cors: \"CORS enabled for all origins\"\n };\n\n return c.json(apiDocs);\n});\n\n// Static file serving and main app\napp.route(\"/\", staticRoutes);\n\n// 404 handler for API routes\napp.notFound((c) => {\n if (c.req.path.startsWith('/api/')) {\n return c.json({\n success: false,\n error: \"API endpoint not found\",\n path: c.req.path,\n method: c.req.method\n }, 404);\n }\n \n // For non-API routes, redirect to main app\n return new Response(null, {\n status: 302,\n headers: { Location: \"/\" }\n });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[155,277],"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;",[],[155,293,285],"routes","b45c6148-3fa5-11f0-939b-76b3cceeab13","static.ts","b45c6210-3fa5-11f0-939b-76b3cceeab13",10,["D",1748864137651],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve shared files\nstaticRoutes.get(\"/shared/*\", (c) => {\n return serveFile(c.req.path, import.meta.url);\n});\n\n// Serve the main application with initial data injection\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n // Inject initial data to avoid extra round-trips\n const initialData = {\n appName: \"SkillSwap AI\",\n version: \"1.0.0\",\n features: [\n \"AI-Powered Matching\",\n \"Smart Scheduling\", \n \"Progress Tracking\",\n \"Community Board\"\n ],\n popularSkills: [\n \"JavaScript\", \"Python\", \"Guitar\", \"Spanish\", \n \"Photography\", \"Cooking\", \"Yoga\", \"Data Science\"\n ]\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving main page:\", error);\n return c.html(`\n \n \n \n SkillSwap AI - Error\n \n \n \n

Error Loading Application

Please try refreshing the page.

\n \n \n `, 500);\n }\n});\n\nexport default staticRoutes;",[],[155,293,295],"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;",[],[155,293,303],"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;",[],[155,293,311],"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;",[],[155,293,319],"aad010e8-3fa5-11f0-b9d5-76b3cceeab13","community.ts","aad011b0-3fa5-11f0-b9d5-76b3cceeab13",9,["D",1748864121630],"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;",[],[155,293,327],"54fa9c1a-3fa5-11f0-b48c-76b3cceeab13",["D",1748863977620],[175,176,177,178,179,180],[155,293],"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}",[],[155,346,339],"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}",[],[155,346,348],"32eed5a0-3fa5-11f0-8de5-76b3cceeab13",["D",1748863920489],[172,173],[155,346],["D",1748863920489],[171,174,181],[155],["D",1748863817576],{"_97":96,"_104":100},{"_97":96,"_98":-5,"_99":100,"_18":55,"_101":102,"_103":25},{"_13":86,"_32":87,"_44":43,"_88":45,"_89":-5,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":46,"_95":96},"ctx",{"_79":-5,"_124":398,"_399":400,"_401":402,"_403":25,"_404":25,"_405":25,"_406":59,"_407":-5,"_408":-7,"_409":-7,"_410":137,"_411":25,"_412":25,"_413":-5,"_414":25,"_415":25,"_416":25,"_417":-5},"ENV",{"_369":370,"_371":372,"_373":87,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5a709144666c9e69e88140f015c586412f0fd8d3","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 · v21