[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_313":314,"_315":316},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":57,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",18,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/ProfileForm.tsx","latestPath","fileId","65caf45c-3fb6-11f0-a44c-76b3cceeab13","name","ProfileForm.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { UserProfile, CreateProfileRequest } from \"../../shared/types.ts\";\n\ninterface ProfileFormProps {\n onProfileCreated: (profile: UserProfile) => void;\n existingProfile?: UserProfile | null;\n}\n\nexport default function ProfileForm({ onProfileCreated, existingProfile }: ProfileFormProps) {\n const [formData, setFormData] = useState({\n userName: existingProfile?.userName || \"\",\n email: existingProfile?.email || \"\",\n bio: existingProfile?.bio || \"\",\n location: existingProfile?.location || \"\",\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setIsSubmitting(true);\n setError(\"\");\n\n try {\n const response = await fetch(\"/api/profiles\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const profile = await response.json();\n onProfileCreated(profile);\n \n // Only reset form if creating new profile\n if (!existingProfile) {\n setFormData({\n userName: \"\",\n email: \"\",\n bio: \"\",\n location: \"\",\n });\n }\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to save profile\");\n }\n } catch (err) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value,\n }));\n };\n\n return (\n

\n {existingProfile ? \"Update Profile\" : \"Create Profile\"}\n

\n \n {error && (\n

\n {error}\n

\n )}\n\n

\n );\n}","createdAt",["D",1748871307281],"branchVersion","branchId","077e3da2-3fb4-11f0-899e-76b3cceeab13","id","077ddf9c-3fb4-11f0-899e-76b3cceeab13","Estateskillsearch",["D",1748870290080],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","d154d2c0-3fab-11f0-b6e9-ab0b2f88b858","pinnedFileId","301eeefa-3fb4-11f0-8c9f-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","0a60fb5a-edbe-490c-873b-b7d824b4072f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",23,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jibolad","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eDU0TFN2MENxZ2lDNnJXaHE3Sk1Ia0JLbSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":309,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":310,"_79":311,"_81":312,"_83":24},"tree",[168,176,184,186],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185,186],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":157},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":150,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":151},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":143,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":145},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"1e6d86c6-3fb4-11f0-a2f9-76b3cceeab13","README.md","1e6d8798-3fb4-11f0-a2f9-76b3cceeab13","parentId",1,"latest",["D",1748870328559],"# Skill Exchange Platform\n\nA simple platform for users to input their skills and specify whether they're offering or requesting help.\n\n## Features\n\n- User registration with username and skill\n- Toggle between \"offer\" and \"request\" modes\n- Store submissions in SQLite database\n- View all submissions\n\n## Project Structure\n\n- `backend/` - Hono API server\n- `frontend/` - React frontend with form\n- `shared/` - Shared types and utilities\n\n## API Endpoints\n\n- `GET /` - Serve frontend\n- `POST /api/submissions` - Create new submission\n- `GET /api/submissions` - Get all submissions\n\n## Usage\n\n1. Enter your username\n2. Specify your skill\n3. Choose whether you're offering or requesting help\n4. Submit the form","label",[130],"20d59f52-3fb4-11f0-9103-76b3cceeab13","shared","fea8f9e5-33f1-4448-b5bc-d8ede9a97d99",2,["D",1748870332585],"directory",[140],"336f2084-3fb4-11f0-9502-76b3cceeab13","frontend","424a05be-e1a3-4a96-807c-b93ffa758fbc",7,["D",1748870363795],[147],"24250224-3fb4-11f0-8c9f-76b3cceeab13","backend","9ff999fb-9a43-4cca-ae31-aa092077a53c",3,["D",1748870338148],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":306,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":307,"_26":308},{"_42":302,"_31":293,"_29":287,"_132":154,"_40":41,"_39":155,"_134":57,"_37":303,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":304,"_26":305},{"_42":294,"_31":295,"_29":296,"_132":287,"_40":41,"_39":297,"_134":57,"_37":298,"_13":133,"_33":34,"_35":299,"_23":24,"_137":-5,"_188":300,"_26":301},{"_42":284,"_31":285,"_29":286,"_132":287,"_40":41,"_39":288,"_134":57,"_37":289,"_13":133,"_33":34,"_35":290,"_23":24,"_137":-5,"_188":291,"_26":292},{"_42":280,"_31":271,"_29":265,"_132":154,"_40":41,"_39":266,"_134":57,"_37":281,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":282,"_26":283},{"_42":272,"_31":273,"_29":274,"_132":265,"_40":41,"_39":275,"_134":57,"_37":276,"_13":61,"_33":34,"_35":277,"_23":24,"_137":-5,"_188":278,"_26":279},{"_42":262,"_31":263,"_29":264,"_132":265,"_40":41,"_39":266,"_134":57,"_37":267,"_13":61,"_33":34,"_35":268,"_23":24,"_137":-5,"_188":269,"_26":270},{"_42":254,"_31":255,"_29":55,"_132":154,"_40":41,"_39":256,"_134":57,"_37":257,"_13":142,"_33":258,"_35":259,"_23":24,"_137":-5,"_188":260,"_26":261},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":251,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":252,"_26":253},{"_42":247,"_31":226,"_29":220,"_132":148,"_40":41,"_39":242,"_134":57,"_37":248,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":249,"_26":250},{"_42":239,"_31":240,"_29":241,"_132":220,"_40":41,"_39":242,"_134":24,"_37":243,"_13":61,"_33":34,"_35":244,"_23":24,"_137":-5,"_188":245,"_26":246},{"_42":235,"_31":32,"_29":30,"_132":220,"_40":41,"_39":14,"_134":57,"_37":236,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_188":237,"_26":238},{"_42":227,"_31":228,"_29":229,"_132":220,"_40":41,"_39":230,"_134":57,"_37":231,"_13":61,"_33":34,"_35":232,"_23":24,"_137":-5,"_188":233,"_26":234},{"_42":217,"_31":218,"_29":219,"_132":220,"_40":41,"_39":221,"_134":57,"_37":222,"_13":61,"_33":34,"_35":223,"_23":24,"_137":-5,"_188":224,"_26":225},{"_42":210,"_31":211,"_29":212,"_132":148,"_40":41,"_39":149,"_134":57,"_37":213,"_13":61,"_33":20,"_35":214,"_23":24,"_137":-5,"_188":215,"_26":216},{"_42":202,"_31":203,"_29":204,"_132":148,"_40":41,"_39":205,"_134":57,"_37":206,"_13":61,"_33":34,"_35":207,"_23":24,"_137":-5,"_188":208,"_26":209},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":199,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_188":200,"_26":201},{"_42":191,"_31":192,"_29":193,"_132":141,"_40":41,"_39":194,"_134":57,"_37":195,"_13":133,"_33":34,"_35":196,"_23":24,"_137":-5,"_188":197,"_26":198},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":187,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_188":189,"_26":190},["D",1748870328559],"children",[],[130],"325a2782-3fb6-11f0-b1e2-76b3cceeab13","types.ts","20d59516-3fb4-11f0-9103-76b3cceeab13",13,["D",1748871220970],"export interface UserProfile {\n id?: number;\n userName: string;\n email?: string;\n bio?: string;\n location?: string;\n createdAt?: string;\n updatedAt?: string;\n}\n\nexport interface Skill {\n id?: number;\n userId: number;\n skillName: string;\n description?: string;\n category?: string;\n type: 'offer' | 'request';\n isActive: boolean;\n createdAt?: string;\n}\n\nexport interface CreateProfileRequest {\n userName: string;\n email?: string;\n bio?: string;\n location?: string;\n}\n\nexport interface CreateSkillRequest {\n userName: string;\n skillName: string;\n description?: string;\n category?: string;\n type: 'offer' | 'request';\n}\n\n// Legacy types for backward compatibility\nexport interface Submission {\n id?: number;\n userName: string;\n skill: string;\n type: 'offer' | 'request';\n createdAt?: string;\n}\n\nexport interface CreateSubmissionRequest {\n userName: string;\n skill: string;\n type: 'offer' | 'request';\n}",[],[140,192],["D",1748870332585],[185],[140],"363ae73a-3fb4-11f0-b9bb-76b3cceeab13","index.tsx","363ae820-3fb4-11f0-b9bb-76b3cceeab13",8,["D",1748870368489],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client?deps=react@18.2.0,react-dom@18.2.0\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[147,203],"336f1b98-3fb4-11f0-9502-76b3cceeab13","index.html","336f1c42-3fb4-11f0-9502-76b3cceeab13",["D",1748870363795],"\n\n\n \n \n Skill Exchange Platform\n \n \n\n\n

\n \n\n",[],[147,211],"4db53d0c-3fb4-11f0-bc33-76b3cceeab13","SubmissionsList.tsx","4db53dac-3fb4-11f0-bc33-76b3cceeab13","9d891580-8e12-402f-a15f-698a84486ef5",11,["D",1748870407877],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission } from \"../../shared/types.ts\";\n\ninterface SubmissionsListProps {\n submissions: Submission[];\n loading: boolean;\n}\n\nexport default function SubmissionsList({ submissions, loading }: SubmissionsListProps) {\n if (loading) {\n return (\n

\n Recent Submissions\n

Loading submissions...

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

\n Recent Submissions\n

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

No submissions yet. Be the first to share your skill!

\n ) : (\n

\n {submissions.map((submission) => (\n \n

\n \n {submission.userName}\n \n \n {submission.type === 'offer' ? '💡 Offering' : '🙋 Requesting'}\n \n

\n {submission.skill}\n

\n {submission.createdAt && (\n

\n {new Date(submission.createdAt).toLocaleDateString()}\n

\n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[147,226,218],"components","45c095ba-3fb4-11f0-8e1d-76b3cceeab13","SubmissionForm.tsx","45c09682-3fb4-11f0-8e1d-76b3cceeab13",10,["D",1748870394533],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Submission, CreateSubmissionRequest } from \"../../shared/types.ts\";\n\ninterface SubmissionFormProps {\n onSubmissionCreated: (submission: Submission) => void;\n}\n\nexport default function SubmissionForm({ onSubmissionCreated }: SubmissionFormProps) {\n const [formData, setFormData] = useState({\n userName: \"\",\n skill: \"\",\n type: \"offer\"\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [error, setError] = useState(\"\");\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setError(\"\");\n setIsSubmitting(true);\n\n try {\n const response = await fetch(\"/api/submissions\", {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n },\n body: JSON.stringify(formData),\n });\n\n if (response.ok) {\n const newSubmission = await response.json();\n onSubmissionCreated(newSubmission);\n setFormData({ userName: \"\", skill: \"\", type: \"offer\" });\n } else {\n const errorData = await response.json();\n setError(errorData.error || \"Failed to submit\");\n }\n } catch (error) {\n setError(\"Network error occurred\");\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n };\n\n return (\n

\n Add Your Skill\n

\n \n

\n );\n}",[],[147,226,228],"65caf394-3fb6-11f0-a44c-76b3cceeab13",["D",1748871307281],[],[147,226,32],"3bafce4c-3fb4-11f0-b34a-76b3cceeab13","App.tsx","3bafcf1e-3fb4-11f0-b34a-76b3cceeab13",9,["D",1748870377639],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport SubmissionForm from \"./SubmissionForm.tsx\";\nimport SubmissionsList from \"./SubmissionsList.tsx\";\nimport type { Submission } from \"../../shared/types.ts\";\n\nexport default function App() {\n const [submissions, setSubmissions] = useState([]);\n const [loading, setLoading] = useState(true);\n\n const fetchSubmissions = async () => {\n try {\n const response = await fetch(\"/api/submissions\");\n if (response.ok) {\n const data = await response.json();\n setSubmissions(data);\n }\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchSubmissions();\n }, []);\n\n const handleSubmissionCreated = (newSubmission: Submission) => {\n setSubmissions(prev => [newSubmission, ...prev]);\n };\n\n return (\n

\n 🤝 Skill Exchange Platform\n

\n Share your skills or find help from the community\n

\n\n

\n \n

\n );\n}",[],[147,226,240],"3bafd5e0-3fb4-11f0-b34a-76b3cceeab13",["D",1748870377639],[178,179,180,181],[147,226],["D",1748870363795],[177,182,183],[147],"5938a162-3fb6-11f0-9427-76b3cceeab13","index.ts",17,["D",1748871286183],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { createTables } from \"./database/migrations.ts\";\nimport submissionsRouter from \"./routes/submissions.ts\";\nimport profilesRouter from \"./routes/profiles.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\nawait createTables();\n\n// API routes\napp.route(\"/api/submissions\", submissionsRouter);\napp.route(\"/api\", profilesRouter);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Serve main page\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;",[],[153,255],"2c178e3e-3fb4-11f0-89cd-76b3cceeab13","submissions.ts","2c179000-3fb4-11f0-89cd-76b3cceeab13","36fbd25c-53cf-47ae-b59a-61818f9edbef",5,["D",1748870351480],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createSubmission, getAllSubmissions } from \"../database/queries.ts\";\nimport type { CreateSubmissionRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\n\n// Get all submissions\napp.get(\"/\", async (c) => {\n try {\n const submissions = await getAllSubmissions();\n return c.json(submissions);\n } catch (error) {\n console.error(\"Error fetching submissions:\", error);\n return c.json({ error: \"Failed to fetch submissions\" }, 500);\n }\n});\n\n// Create new submission\napp.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateSubmissionRequest;\n \n // Validate required fields\n if (!body.userName || !body.skill || !body.type) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (body.type !== 'offer' && body.type !== 'request') {\n return c.json({ error: \"Type must be 'offer' or 'request'\" }, 400);\n }\n \n const submission = await createSubmission(body);\n return c.json(submission, 201);\n } catch (error) {\n console.error(\"Error creating submission:\", error);\n return c.json({ error: \"Failed to create submission\" }, 500);\n }\n});\n\nexport default app;",[],[153,271,263],"routes","50a0eadc-3fb6-11f0-96a3-76b3cceeab13","profiles.ts","50a0eb90-3fb6-11f0-96a3-76b3cceeab13",16,["D",1748871271774],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createOrUpdateProfile, \n getUserProfile, \n getAllProfiles,\n addSkillToProfile,\n getUserSkills,\n getAllSkills,\n getSkillsByType,\n toggleSkillStatus\n} from \"../database/queries.ts\";\nimport type { CreateProfileRequest, CreateSkillRequest } from \"../../shared/types.ts\";\n\nconst app = new Hono();\n\n// Profile routes\napp.post(\"/profiles\", async (c) => {\n try {\n const data: CreateProfileRequest = await c.req.json();\n \n if (!data.userName?.trim()) {\n return c.json({ error: \"Username is required\" }, 400);\n }\n\n const profile = await createOrUpdateProfile(data);\n return c.json(profile);\n } catch (error) {\n console.error(\"Error creating/updating profile:\", error);\n return c.json({ error: \"Failed to create/update profile\" }, 500);\n }\n});\n\napp.get(\"/profiles/:userName\", async (c) => {\n try {\n const userName = c.req.param(\"userName\");\n const profile = await getUserProfile(userName);\n \n if (!profile) {\n return c.json({ error: \"Profile not found\" }, 404);\n }\n \n return c.json(profile);\n } catch (error) {\n console.error(\"Error fetching profile:\", error);\n return c.json({ error: \"Failed to fetch profile\" }, 500);\n }\n});\n\napp.get(\"/profiles\", async (c) => {\n try {\n const profiles = await getAllProfiles();\n return c.json(profiles);\n } catch (error) {\n console.error(\"Error fetching profiles:\", error);\n return c.json({ error: \"Failed to fetch profiles\" }, 500);\n }\n});\n\n// Skill routes\napp.post(\"/skills\", async (c) => {\n try {\n const data: CreateSkillRequest = await c.req.json();\n \n if (!data.userName?.trim() || !data.skillName?.trim()) {\n return c.json({ error: \"Username and skill name are required\" }, 400);\n }\n\n const skill = await addSkillToProfile(data);\n return c.json(skill);\n } catch (error) {\n console.error(\"Error adding skill:\", error);\n return c.json({ error: \"Failed to add skill\" }, 500);\n }\n});\n\napp.get(\"/skills\", async (c) => {\n try {\n const type = c.req.query(\"type\") as 'offer' | 'request' | undefined;\n \n if (type && !['offer', 'request'].includes(type)) {\n return c.json({ error: \"Invalid type parameter\" }, 400);\n }\n\n const skills = type ? await getSkillsByType(type) : await getAllSkills();\n return c.json(skills);\n } catch (error) {\n console.error(\"Error fetching skills:\", error);\n return c.json({ error: \"Failed to fetch skills\" }, 500);\n }\n});\n\napp.get(\"/profiles/:userName/skills\", async (c) => {\n try {\n const userName = c.req.param(\"userName\");\n const skills = await getUserSkills(userName);\n return c.json(skills);\n } catch (error) {\n console.error(\"Error fetching user skills:\", error);\n return c.json({ error: \"Failed to fetch user skills\" }, 500);\n }\n});\n\napp.patch(\"/skills/:skillId/toggle\", async (c) => {\n try {\n const skillId = parseInt(c.req.param(\"skillId\"));\n const { isActive } = await c.req.json();\n \n if (isNaN(skillId)) {\n return c.json({ error: \"Invalid skill ID\" }, 400);\n }\n\n await toggleSkillStatus(skillId, isActive);\n return c.json({ success: true });\n } catch (error) {\n console.error(\"Error toggling skill status:\", error);\n return c.json({ error: \"Failed to toggle skill status\" }, 500);\n }\n});\n\nexport default app;",[],[153,271,273],"2c1799f6-3fb4-11f0-89cd-76b3cceeab13",["D",1748870351480],[173,174],[153,271],"470079c0-3fb6-11f0-8f9c-76b3cceeab13","queries.ts","27536d14-3fb4-11f0-899e-76b3cceeab13","eb87c3dd-108a-4423-8f53-b6674d5c7dc4",15,["D",1748871255620],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE } from \"./migrations.ts\";\nimport type { \n UserProfile, \n Skill, \n CreateProfileRequest, \n CreateSkillRequest,\n Submission, \n CreateSubmissionRequest \n} from \"../../shared/types.ts\";\n\n// User Profile Functions\nexport async function createOrUpdateProfile(data: CreateProfileRequest): Promise {\n // Try to update existing profile first\n const existingUser = await getUserProfile(data.userName);\n \n if (existingUser) {\n const result = await sqlite.execute(\n `UPDATE ${USERS_TABLE} \n SET email = ?, bio = ?, location = ?, updatedAt = CURRENT_TIMESTAMP \n WHERE userName = ? \n RETURNING *`,\n [data.email || null, data.bio || null, data.location || null, data.userName]\n );\n return result.rows[0] as UserProfile;\n } else {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (userName, email, bio, location) \n VALUES (?, ?, ?, ?) \n RETURNING *`,\n [data.userName, data.email || null, data.bio || null, data.location || null]\n );\n return result.rows[0] as UserProfile;\n }\n}\n\nexport async function getUserProfile(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE userName = ?`,\n [userName]\n );\n \n return result.rows.length > 0 ? result.rows[0] as UserProfile : null;\n}\n\nexport async function getAllProfiles(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as UserProfile[];\n}\n\n// Skill Functions\nexport async function addSkillToProfile(data: CreateSkillRequest): Promise {\n // Get or create user profile\n let user = await getUserProfile(data.userName);\n if (!user) {\n user = await createOrUpdateProfile({ userName: data.userName });\n }\n\n const result = await sqlite.execute(\n `INSERT INTO ${SKILLS_TABLE} (userId, skillName, description, category, type) \n VALUES (?, ?, ?, ?, ?) \n RETURNING *`,\n [user.id, data.skillName, data.description || null, data.category || null, data.type]\n );\n \n return result.rows[0] as Skill;\n}\n\nexport async function getUserSkills(userName: string): Promise {\n const result = await sqlite.execute(\n `SELECT s.* FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE u.userName = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [userName]\n );\n \n return result.rows as Skill[];\n}\n\nexport async function getAllSkills(): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.isActive = 1 \n ORDER BY s.createdAt DESC`\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function getSkillsByType(type: 'offer' | 'request'): Promise<(Skill & { userName: string })[]> {\n const result = await sqlite.execute(\n `SELECT s.*, u.userName FROM ${SKILLS_TABLE} s \n JOIN ${USERS_TABLE} u ON s.userId = u.id \n WHERE s.type = ? AND s.isActive = 1 \n ORDER BY s.createdAt DESC`,\n [type]\n );\n \n return result.rows as (Skill & { userName: string })[];\n}\n\nexport async function toggleSkillStatus(skillId: number, isActive: boolean): Promise {\n await sqlite.execute(\n `UPDATE ${SKILLS_TABLE} SET isActive = ? WHERE id = ?`,\n [isActive ? 1 : 0, skillId]\n );\n}\n\n// Legacy Functions (for backward compatibility)\nexport async function createSubmission(data: CreateSubmissionRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${LEGACY_TABLE} (userName, skill, type) VALUES (?, ?, ?) RETURNING *`,\n [data.userName, data.skill, data.type]\n );\n \n return result.rows[0] as Submission;\n}\n\nexport async function getAllSubmissions(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${LEGACY_TABLE} ORDER BY createdAt DESC`\n );\n \n return result.rows as Submission[];\n}",[],[153,293,285],"database","398595fa-3fb6-11f0-8a23-76b3cceeab13","migrations.ts","2424fbda-3fb4-11f0-8c9f-76b3cceeab13",14,["D",1748871233001],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst USERS_TABLE = 'user_profiles';\nconst SKILLS_TABLE = 'user_skills';\nconst LEGACY_TABLE = 'skill_submissions';\n\nexport async function createTables() {\n // Create user profiles table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${USERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT UNIQUE NOT NULL,\n email TEXT,\n bio TEXT,\n location TEXT,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n updatedAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create user skills table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${SKILLS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userId INTEGER NOT NULL,\n skillName TEXT NOT NULL,\n description TEXT,\n category TEXT,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n isActive BOOLEAN DEFAULT 1,\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (userId) REFERENCES ${USERS_TABLE}(id) ON DELETE CASCADE\n )`);\n\n // Keep legacy table for backward compatibility\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${LEGACY_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n userName TEXT NOT NULL,\n skill TEXT NOT NULL,\n type TEXT NOT NULL CHECK (type IN ('offer', 'request')),\n createdAt DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create indexes for better performance\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_user ON ${SKILLS_TABLE}(userId)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_type ON ${SKILLS_TABLE}(type)`);\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_skills_active ON ${SKILLS_TABLE}(isActive)`);\n}\n\nexport { USERS_TABLE, SKILLS_TABLE, LEGACY_TABLE };",[],[153,293,295],"242504ae-3fb4-11f0-8c9f-76b3cceeab13",["D",1748870338148],[170,171],[153,293],["D",1748870338148],[169,172,175],[153],["D",1748870290080],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":346,"_347":348,"_349":350,"_351":24,"_352":24,"_353":24,"_354":57,"_355":-5,"_356":-7,"_357":-7,"_358":61,"_359":24,"_360":24,"_361":-5,"_362":24,"_363":24,"_364":24,"_365":-5},"ENV",{"_317":318,"_319":320,"_321":85,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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 · v18