[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",10,"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/SubmissionForm.tsx","latestPath","fileId","45c09682-3fb4-11f0-8e1d-76b3cceeab13","name","SubmissionForm.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 { 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}","createdAt",["D",1748870394533],"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":279,"_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":280,"_79":281,"_81":282,"_83":24},"tree",[168,175,181,183],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183],"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":276,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":277,"_26":278},{"_42":272,"_31":264,"_29":258,"_132":154,"_40":41,"_39":155,"_134":57,"_37":273,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":274,"_26":275},{"_42":265,"_31":266,"_29":267,"_132":258,"_40":41,"_39":155,"_134":24,"_37":268,"_13":61,"_33":34,"_35":269,"_23":24,"_137":-5,"_185":270,"_26":271},{"_42":255,"_31":256,"_29":257,"_132":258,"_40":41,"_39":259,"_134":24,"_37":260,"_13":61,"_33":34,"_35":261,"_23":24,"_137":-5,"_185":262,"_26":263},{"_42":251,"_31":250,"_29":244,"_132":154,"_40":41,"_39":245,"_134":57,"_37":252,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":253,"_26":254},{"_42":241,"_31":242,"_29":243,"_132":244,"_40":41,"_39":245,"_134":57,"_37":246,"_13":61,"_33":34,"_35":247,"_23":24,"_137":-5,"_185":248,"_26":249},{"_42":234,"_31":235,"_29":55,"_132":154,"_40":41,"_39":236,"_134":24,"_37":237,"_13":61,"_33":34,"_35":238,"_23":24,"_137":-5,"_185":239,"_26":240},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":231,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":232,"_26":233},{"_42":227,"_31":218,"_29":214,"_132":148,"_40":41,"_39":222,"_134":57,"_37":228,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":229,"_26":230},{"_42":219,"_31":220,"_29":221,"_132":214,"_40":41,"_39":222,"_134":24,"_37":223,"_13":61,"_33":34,"_35":224,"_23":24,"_137":-5,"_185":225,"_26":226},{"_42":213,"_31":32,"_29":30,"_132":214,"_40":41,"_39":14,"_134":57,"_37":215,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_185":216,"_26":217},{"_42":206,"_31":207,"_29":208,"_132":148,"_40":41,"_39":149,"_134":57,"_37":209,"_13":61,"_33":20,"_35":210,"_23":24,"_137":-5,"_185":211,"_26":212},{"_42":198,"_31":199,"_29":200,"_132":148,"_40":41,"_39":201,"_134":57,"_37":202,"_13":61,"_33":34,"_35":203,"_23":24,"_137":-5,"_185":204,"_26":205},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":195,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":196,"_26":197},{"_42":188,"_31":189,"_29":190,"_132":141,"_40":41,"_39":142,"_134":24,"_37":191,"_13":61,"_33":34,"_35":192,"_23":24,"_137":-5,"_185":193,"_26":194},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":24,"_37":184,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_185":186,"_26":187},["D",1748870328559],"children",[],[130],"20d59458-3fb4-11f0-9103-76b3cceeab13","types.ts","20d59516-3fb4-11f0-9103-76b3cceeab13",["D",1748870332585],"export 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,189],["D",1748870332585],[182],[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,199],"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,207],"45c095ba-3fb4-11f0-8e1d-76b3cceeab13","9d891580-8e12-402f-a15f-698a84486ef5",["D",1748870394533],[],[147,218,32],"components","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,218,220],"3bafd5e0-3fb4-11f0-b34a-76b3cceeab13",["D",1748870377639],[177,178],[147,218],["D",1748870363795],[176,179,180],[147],"301eee50-3fb4-11f0-8c9f-76b3cceeab13","index.ts",6,["D",1748870358219],"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\";\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);\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,235],"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,250,242],"routes","2c1799f6-3fb4-11f0-89cd-76b3cceeab13",["D",1748870351480],[173],[153,250],"27536c6a-3fb4-11f0-899e-76b3cceeab13","queries.ts","27536d14-3fb4-11f0-899e-76b3cceeab13","eb87c3dd-108a-4423-8f53-b6674d5c7dc4",4,["D",1748870343487],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLE_NAME } from \"./migrations.ts\";\nimport type { Submission, CreateSubmissionRequest } from \"../../shared/types.ts\";\n\nexport async function createSubmission(data: CreateSubmissionRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (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 ${TABLE_NAME} ORDER BY createdAt DESC`\n );\n \n return result.rows as Submission[];\n}",[],[153,264,256],"database","2424fb44-3fb4-11f0-8c9f-76b3cceeab13","migrations.ts","2424fbda-3fb4-11f0-8c9f-76b3cceeab13",["D",1748870338148],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = 'skill_submissions';\n\nexport async function createTables() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\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\nexport { TABLE_NAME };",[],[153,264,266],"242504ae-3fb4-11f0-8c9f-76b3cceeab13",["D",1748870338148],[170,171],[153,264],["D",1748870338148],[169,172,174],[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":316,"_317":318,"_319":320,"_321":24,"_322":24,"_323":24,"_324":57,"_325":-5,"_326":-7,"_327":-7,"_328":61,"_329":24,"_330":24,"_331":-5,"_332":24,"_333":24,"_334":24,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":85,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"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 · v10