[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_292":293,"_294":295},"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",11,"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/JobDetail.tsx","latestPath","fileId","d543c4c4-3fbd-11f0-9a75-76b3cceeab13","name","JobDetail.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Job } from \"../../shared/types.ts\";\nimport Chat from \"./Chat.tsx\";\n\ninterface JobDetailProps {\n job: Job;\n onBack: () => void;\n}\n\nexport default function JobDetail({ job, onBack }: JobDetailProps) {\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n const getJobTypeBadgeClass = (type: string) => {\n return `job-type-badge job-type-${type}`;\n };\n\n return (\n

\n {/* Job Header */}\n

{job.title}

{job.company}

\n \n {job.type}\n \n

\n \n

\n \n 📍\n {job.location}\n \n {job.salary && (\n \n 💰\n {job.salary}\n \n )}\n \n 📅\n Posted {formatDate(job.posted_at)}\n \n

\n\n {/* Job Content */}\n

\n {/* Job Description */}\n

Job Description

\n {job.description.split('\\n').map((paragraph, index) => (\n

{paragraph}

\n ))}\n

\n\n

Requirements

\n •\n {requirement}\n

\n\n {/* Chat Section */}\n

\n 💬 Discussion\n

\n Join the conversation about this job posting. Ask questions, share insights, or connect with other candidates.\n

\n \n

\n );\n}","createdAt",["D",1748874500774],"branchVersion","branchId","4eefeace-3fbd-11f0-9f87-76b3cceeab13","id","4eef7a58-3fbd-11f0-9f87-76b3cceeab13","Jobposting",["D",1748874275414],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","5d335530-3fae-11f0-ad5b-814c56c8abb0","pinnedFileId","a1fa76e4-3fbd-11f0-96f1-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","87bce618-de29-462f-9a71-e210990e2b5c","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",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","faithyz","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHg3S3JPSUx5UlNjNFFqQ2kzNm5pemQ2VkYifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":288,"_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":289,"_79":290,"_81":291,"_83":24},"tree",[168,176,182,184],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184],"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":57,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"7af5cb2a-3fbd-11f0-8972-76b3cceeab13","README.md","7af5cbca-3fbd-11f0-8972-76b3cceeab13","parentId",1,"latest",["D",1748874349269],"# Job Posting Chat Platform\n\nA platform where users can view job postings and chat about them in real-time.\n\n## Features\n\n- View job postings\n- Real-time chat for each job posting\n- Simple, clean interface\n- No authentication required (anonymous chat)\n\n## Project Structure\n\n```\n├── backend/\n│ ├── database/\n│ │ ├── migrations.ts # Database schema setup\n│ │ └── queries.ts # Database query functions\n│ ├── routes/\n│ │ ├── jobs.ts # Job posting endpoints\n│ │ └── chat.ts # Chat endpoints\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── JobList.tsx # Job listings\n│ │ ├── JobDetail.tsx # Individual job view\n│ │ └── Chat.tsx # Chat component\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Usage\n\n1. Visit the homepage to see all job postings\n2. Click on a job to view details and join the chat\n3. Chat messages are stored and displayed in real-time\n4. No registration required - just start chatting!","label",[130],"7f1753c2-3fbd-11f0-a966-76b3cceeab13","shared","767d0179-067a-499d-9782-c0a9d917bffc",2,["D",1748874356199],"directory",[140],"aadb1b1a-3fbd-11f0-9f87-76b3cceeab13","frontend","19d8f571-ab9e-4344-ab64-a3118300a2da",8,["D",1748874429624],[147],"83c20b06-3fbd-11f0-966b-76b3cceeab13","backend","302a2e11-4b8a-4fb1-bfb8-126e7acfdf89",3,["D",1748874364027],[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":285,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":286,"_26":287},{"_42":281,"_31":273,"_29":267,"_132":154,"_40":41,"_39":155,"_134":57,"_37":282,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":283,"_26":284},{"_42":274,"_31":275,"_29":276,"_132":267,"_40":41,"_39":155,"_134":57,"_37":277,"_13":61,"_33":34,"_35":278,"_23":24,"_137":-5,"_186":279,"_26":280},{"_42":264,"_31":265,"_29":266,"_132":267,"_40":41,"_39":268,"_134":57,"_37":269,"_13":61,"_33":34,"_35":270,"_23":24,"_137":-5,"_186":271,"_26":272},{"_42":260,"_31":251,"_29":245,"_132":154,"_40":41,"_39":246,"_134":57,"_37":261,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":262,"_26":263},{"_42":252,"_31":253,"_29":254,"_132":245,"_40":41,"_39":255,"_134":57,"_37":256,"_13":61,"_33":34,"_35":257,"_23":24,"_137":-5,"_186":258,"_26":259},{"_42":242,"_31":243,"_29":244,"_132":245,"_40":41,"_39":246,"_134":57,"_37":247,"_13":61,"_33":34,"_35":248,"_23":24,"_137":-5,"_186":249,"_26":250},{"_42":235,"_31":236,"_29":55,"_132":154,"_40":41,"_39":237,"_134":24,"_37":238,"_13":61,"_33":34,"_35":239,"_23":24,"_137":-5,"_186":240,"_26":241},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":232,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":233,"_26":234},{"_42":228,"_31":215,"_29":209,"_132":148,"_40":41,"_39":223,"_134":57,"_37":229,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":230,"_26":231},{"_42":220,"_31":221,"_29":222,"_132":209,"_40":41,"_39":223,"_134":57,"_37":224,"_13":61,"_33":34,"_35":225,"_23":24,"_137":-5,"_186":226,"_26":227},{"_42":216,"_31":32,"_29":30,"_132":209,"_40":41,"_39":14,"_134":57,"_37":217,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_186":218,"_26":219},{"_42":206,"_31":207,"_29":208,"_132":209,"_40":41,"_39":210,"_134":57,"_37":211,"_13":61,"_33":34,"_35":212,"_23":24,"_137":-5,"_186":213,"_26":214},{"_42":199,"_31":200,"_29":201,"_132":148,"_40":41,"_39":149,"_134":57,"_37":202,"_13":61,"_33":20,"_35":203,"_23":24,"_137":-5,"_186":204,"_26":205},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":196,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_186":197,"_26":198},{"_42":189,"_31":190,"_29":191,"_132":141,"_40":41,"_39":142,"_134":57,"_37":192,"_13":61,"_33":34,"_35":193,"_23":24,"_137":-5,"_186":194,"_26":195},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":185,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_186":187,"_26":188},["D",1748874349269],"children",[],[130],"7f1738ec-3fbd-11f0-a966-76b3cceeab13","types.ts","7f1739be-3fbd-11f0-a966-76b3cceeab13",["D",1748874356199],"// Shared types for the job posting chat platform\n\nexport interface Job {\n id: number;\n title: string;\n company: string;\n location: string;\n description: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n posted_at: string;\n requirements: string[];\n}\n\nexport interface ChatMessage {\n id: number;\n job_id: number;\n username: string;\n message: string;\n timestamp: string;\n}\n\nexport interface CreateJobRequest {\n title: string;\n company: string;\n location: string;\n description: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n requirements: string[];\n}\n\nexport interface CreateMessageRequest {\n job_id: number;\n username: string;\n message: string;\n}",[],[140,190],["D",1748874356199],[183],[140],"aadb0fd0-3fbd-11f0-9f87-76b3cceeab13","index.html","aadb10ac-3fbd-11f0-9f87-76b3cceeab13",["D",1748874429624],"\n\n\n \n \n Job Posting Chat Platform\n \n \n \n\n\n

\n \n\n",[],[147,200],"cb8ac96e-3fbd-11f0-87d5-76b3cceeab13","JobList.tsx","cb8aca4a-3fbd-11f0-87d5-76b3cceeab13","76b8926b-da6b-4fc1-8cff-4c0b9bf6cb55",10,["D",1748874484464],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Job, CreateJobRequest } from \"../../shared/types.ts\";\n\ninterface JobListProps {\n jobs: Job[];\n onJobSelect: (job: Job) => void;\n onRefresh: () => void;\n}\n\nexport default function JobList({ jobs, onJobSelect, onRefresh }: JobListProps) {\n const [showCreateForm, setShowCreateForm] = useState(false);\n const [creating, setCreating] = useState(false);\n\n const handleCreateJob = async (event: React.FormEvent) => {\n event.preventDefault();\n setCreating(true);\n\n const formData = new FormData(event.currentTarget);\n const requirements = (formData.get('requirements') as string)\n .split('\\n')\n .map(req => req.trim())\n .filter(req => req.length > 0);\n\n const jobData: CreateJobRequest = {\n title: formData.get('title') as string,\n company: formData.get('company') as string,\n location: formData.get('location') as string,\n description: formData.get('description') as string,\n salary: formData.get('salary') as string || undefined,\n type: formData.get('type') as CreateJobRequest['type'],\n requirements\n };\n\n try {\n const response = await fetch('/api/jobs', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(jobData),\n });\n\n if (response.ok) {\n setShowCreateForm(false);\n onRefresh();\n (event.target as HTMLFormElement).reset();\n } else {\n const error = await response.json();\n alert(`Error creating job: ${error.error}`);\n }\n } catch (error) {\n console.error('Error creating job:', error);\n alert('Failed to create job');\n } finally {\n setCreating(false);\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n const getJobTypeBadgeClass = (type: string) => {\n return `job-type-badge job-type-${type}`;\n };\n\n return (\n

Available Jobs

Click on any job to view details and join the discussion

\n setShowCreateForm(!showCreateForm)}\n className=\"inline-flex items-center px-4 py-2 border border-transparent rounded-md shadow-sm text-sm font-medium text-white bg-blue-600 hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500\"\n >\n {showCreateForm ? 'Cancel' : '+ Post Job'}\n \n

\n\n {showCreateForm && (\n

Post a New Job

\n Job Title\n \n

\n Company\n \n

\n Location\n \n

\n Salary (Optional)\n \n

\n Job Type\n \n \n \n \n \n \n

\n Description\n \n

\n Requirements (one per line)\n \n

\n setShowCreateForm(false)}\n className=\"px-4 py-2 border border-gray-300 rounded-md shadow-sm text-sm font-medium text-gray-700 bg-white hover:bg-gray-50 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500\"\n >\n Cancel\n \n \n {creating ? 'Creating...' : 'Post Job'}\n \n

\n )}\n\n {jobs.length === 0 ? (\n

📋

No jobs posted yet

Be the first to post a job and start the conversation!

\n ) : (\n

\n {jobs.map((job) => (\n onJobSelect(job)}\n >\n

{job.title}

{job.company}

\n \n {job.type}\n \n

\n \n

\n 📍 {job.location}\n {job.salary && 💰 {job.salary}}\n 📅 {formatDate(job.posted_at)}\n

\n \n

{job.description}

\n \n

\n {job.requirements.slice(0, 3).map((req, index) => (\n \n {req}\n \n ))}\n {job.requirements.length > 3 && (\n \n +{job.requirements.length - 3} more\n \n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[147,215,207],"components","d543c410-3fbd-11f0-9a75-76b3cceeab13",["D",1748874500774],[],[147,215,32],"b42f9e48-3fbd-11f0-aa5d-76b3cceeab13","App.tsx","b42f9efc-3fbd-11f0-aa5d-76b3cceeab13",9,["D",1748874445274],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Job } from \"../../shared/types.ts\";\nimport JobList from \"./JobList.tsx\";\nimport JobDetail from \"./JobDetail.tsx\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: {\n jobs: Job[];\n };\n }\n}\n\nexport default function App() {\n const [jobs, setJobs] = useState([]);\n const [selectedJob, setSelectedJob] = useState(null);\n const [loading, setLoading] = useState(true);\n const [view, setView] = useState<'list' | 'detail'>('list');\n\n useEffect(() => {\n // Use initial data if available, otherwise fetch\n if (window.__INITIAL_DATA__?.jobs) {\n setJobs(window.__INITIAL_DATA__.jobs);\n setLoading(false);\n } else {\n fetchJobs();\n }\n }, []);\n\n const fetchJobs = async () => {\n try {\n const response = await fetch('/api/jobs');\n if (response.ok) {\n const jobsData = await response.json();\n setJobs(jobsData);\n } else {\n console.error('Failed to fetch jobs');\n }\n } catch (error) {\n console.error('Error fetching jobs:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleJobSelect = (job: Job) => {\n setSelectedJob(job);\n setView('detail');\n };\n\n const handleBackToList = () => {\n setSelectedJob(null);\n setView('list');\n };\n\n const refreshJobs = () => {\n setLoading(true);\n fetchJobs();\n };\n\n if (loading) {\n return (\n

Loading jobs...

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

💼 Job Chat Platform

\n {view === 'detail' && (\n \n ← Back to Jobs\n \n )}\n

\n\n

\n {view === 'list' ? (\n \n ) : (\n selectedJob && (\n \n )\n )}\n

\n );\n}",[],[147,215,221],"b42faa6e-3fbd-11f0-aa5d-76b3cceeab13",["D",1748874445274],[178,179,180],[147,215],["D",1748874429624],[177,181],[147],"a1fa7612-3fbd-11f0-96f1-76b3cceeab13","index.ts",7,["D",1748874414734],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { getAllJobs } from \"./database/queries.ts\";\nimport jobsRouter from \"./routes/jobs.ts\";\nimport chatRouter from \"./routes/chat.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 runMigrations();\n\n// API routes\napp.route(\"/api/jobs\", jobsRouter);\napp.route(\"/api/chat\", chatRouter);\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 with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial job data to avoid extra round-trips\n try {\n const initialJobs = await getAllJobs();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n \n return c.html(html);\n});\n\n// Catch-all for SPA routing\napp.get(\"*\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n try {\n const initialJobs = await getAllJobs();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n \n return c.html(html);\n});\n\nexport default app.fetch;",[],[153,236],"934f37a6-3fbd-11f0-bfdd-76b3cceeab13","jobs.ts","934f383c-3fbd-11f0-bfdd-76b3cceeab13","d5d37d87-3d17-4073-83f3-57aed15e533d",5,["D",1748874390122],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, getJobById, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const allJobs = await getAllJobs();\n return c.json(allJobs);\n } catch (error) {\n console.error(\"Error fetching jobs:\", error);\n return c.json({ error: \"Failed to fetch jobs\" }, 500);\n }\n});\n\n// Get specific job by ID\njobs.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid job ID\" }, 400);\n }\n \n const job = await getJobById(id);\n if (!job) {\n return c.json({ error: \"Job not found\" }, 404);\n }\n \n return c.json(job);\n } catch (error) {\n console.error(\"Error fetching job:\", error);\n return c.json({ error: \"Failed to fetch job\" }, 500);\n }\n});\n\n// Create new job\njobs.post(\"/\", async (c) => {\n try {\n const jobData: CreateJobRequest = await c.req.json();\n \n // Basic validation\n if (!jobData.title || !jobData.company || !jobData.location || !jobData.description) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (!['full-time', 'part-time', 'contract', 'internship'].includes(jobData.type)) {\n return c.json({ error: \"Invalid job type\" }, 400);\n }\n \n if (!Array.isArray(jobData.requirements)) {\n return c.json({ error: \"Requirements must be an array\" }, 400);\n }\n \n const newJob = await createJob(jobData);\n return c.json(newJob, 201);\n } catch (error) {\n console.error(\"Error creating job:\", error);\n return c.json({ error: \"Failed to create job\" }, 500);\n }\n});\n\nexport default jobs;",[],[153,251,243],"routes","9947139a-3fbd-11f0-8b35-76b3cceeab13","chat.ts","9947148a-3fbd-11f0-8b35-76b3cceeab13",6,["D",1748874399972],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getMessagesByJobId, createMessage } from \"../database/queries.ts\";\nimport type { CreateMessageRequest } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get messages for a specific job\nchat.get(\"/:jobId\", async (c) => {\n try {\n const jobId = parseInt(c.req.param(\"jobId\"));\n if (isNaN(jobId)) {\n return c.json({ error: \"Invalid job ID\" }, 400);\n }\n \n const messages = await getMessagesByJobId(jobId);\n return c.json(messages);\n } catch (error) {\n console.error(\"Error fetching messages:\", error);\n return c.json({ error: \"Failed to fetch messages\" }, 500);\n }\n});\n\n// Post a new message\nchat.post(\"/\", async (c) => {\n try {\n const messageData: CreateMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.job_id || !messageData.username || !messageData.message) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (typeof messageData.job_id !== 'number') {\n return c.json({ error: \"job_id must be a number\" }, 400);\n }\n \n if (messageData.username.trim().length === 0) {\n return c.json({ error: \"Username cannot be empty\" }, 400);\n }\n \n if (messageData.message.trim().length === 0) {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n \n // Sanitize input\n const sanitizedMessage = {\n ...messageData,\n username: messageData.username.trim().slice(0, 50), // Limit username length\n message: messageData.message.trim().slice(0, 1000) // Limit message length\n };\n \n const newMessage = await createMessage(sanitizedMessage);\n return c.json(newMessage, 201);\n } catch (error) {\n console.error(\"Error creating message:\", error);\n return c.json({ error: \"Failed to create message\" }, 500);\n }\n});\n\nexport default chat;",[],[153,251,253],"934f3dc8-3fbd-11f0-bfdd-76b3cceeab13",["D",1748874390122],[173,174],[153,251],"8cabb672-3fbd-11f0-ae23-76b3cceeab13","queries.ts","8cabb712-3fbd-11f0-ae23-76b3cceeab13","26f02f60-e3b7-4e29-a7b2-4d4eadc83ba1",4,["D",1748874378984],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, MESSAGES_TABLE } from \"./migrations.ts\";\nimport type { Job, ChatMessage, CreateJobRequest, CreateMessageRequest } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} ORDER BY posted_at DESC`);\n return result.rows.map(row => ({\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n }));\n}\n\nexport async function getJobById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} WHERE id = ?`, [id]);\n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n };\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${JOBS_TABLE} (title, company, location, description, salary, type, requirements) \n VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [\n jobData.title,\n jobData.company,\n jobData.location,\n jobData.description,\n jobData.salary || null,\n jobData.type,\n JSON.stringify(jobData.requirements)\n ]\n );\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n };\n}\n\n// Chat message queries\nexport async function getMessagesByJobId(jobId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${MESSAGES_TABLE} WHERE job_id = ? ORDER BY timestamp ASC`,\n [jobId]\n );\n \n return result.rows.map(row => ({\n id: row.id as number,\n job_id: row.job_id as number,\n username: row.username as string,\n message: row.message as string,\n timestamp: row.timestamp as string\n }));\n}\n\nexport async function createMessage(messageData: CreateMessageRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${MESSAGES_TABLE} (job_id, username, message) \n VALUES (?, ?, ?) RETURNING *`,\n [messageData.job_id, messageData.username, messageData.message]\n );\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n job_id: row.job_id as number,\n username: row.username as string,\n message: row.message as string,\n timestamp: row.timestamp as string\n };\n}",[],[153,273,265],"database","83c201ec-3fbd-11f0-966b-76b3cceeab13","migrations.ts","83c20296-3fbd-11f0-966b-76b3cceeab13",["D",1748874364027],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'job_postings_v1';\nconst MESSAGES_TABLE = 'chat_messages_v1';\n\nexport async function runMigrations() {\n // Create jobs table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n location TEXT NOT NULL,\n description TEXT NOT NULL,\n salary TEXT,\n type TEXT NOT NULL CHECK (type IN ('full-time', 'part-time', 'contract', 'internship')),\n requirements TEXT NOT NULL, -- JSON array of strings\n posted_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create chat messages table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n job_id INTEGER NOT NULL,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (job_id) REFERENCES ${JOBS_TABLE} (id)\n )`);\n\n console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, MESSAGES_TABLE };",[],[153,273,275],"83c20c96-3fbd-11f0-966b-76b3cceeab13",["D",1748874364027],[170,171],[153,273],["D",1748874364027],[169,172,175],[153],["D",1748874275414],{"_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":325,"_326":327,"_328":329,"_330":24,"_331":24,"_332":24,"_333":57,"_334":-5,"_335":-7,"_336":-7,"_337":61,"_338":24,"_339":24,"_340":-5,"_341":24,"_342":24,"_343":24,"_344":-5},"ENV",{"_296":297,"_298":299,"_300":85,"_301":302,"_303":304,"_305":306,"_307":308,"_309":310,"_311":312,"_313":314,"_315":316,"_317":318,"_319":320,"_321":322,"_323":324},"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 · v11