[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_301":302,"_303":304},"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",12,"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/JobBoard.tsx","latestPath","fileId","5eadff4c-3fb7-11f0-b1ac-76b3cceeab13","name","JobBoard.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport JobCard from \"./JobCard.tsx\";\nimport type { JobPosting, JobFilters } from \"../../shared/types.ts\";\n\nexport default function JobBoard() {\n const [jobs, setJobs] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [selectedJob, setSelectedJob] = useState(null);\n const [filters, setFilters] = useState({});\n\n // Fetch jobs\n const fetchJobs = async () => {\n try {\n setLoading(true);\n const params = new URLSearchParams();\n if (filters.type) params.append('type', filters.type);\n if (filters.location) params.append('location', filters.location);\n if (filters.search) params.append('search', filters.search);\n\n const response = await fetch(`/api/jobs?${params}`);\n if (!response.ok) throw new Error('Failed to fetch jobs');\n \n const data = await response.json();\n setJobs(data);\n setError(null);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to load jobs');\n } finally {\n setLoading(false);\n }\n };\n\n useEffect(() => {\n fetchJobs();\n }, [filters]);\n\n const handleFilterChange = (key: keyof JobFilters, value: string) => {\n setFilters(prev => ({\n ...prev,\n [key]: value || undefined\n }));\n };\n\n const clearFilters = () => {\n setFilters({});\n };\n\n if (selectedJob) {\n return (\n

\n {/* Back Button */}\n setSelectedJob(null)}\n className=\"mb-6 flex items-center space-x-2 text-blue-600 hover:text-blue-800 transition-colors\"\n >\n ←\n Back to Job Board\n \n\n {/* Job Details */}\n

{selectedJob.title}

\n {selectedJob.company}\n

\n 📍\n {selectedJob.location}\n

\n 💼\n {selectedJob.type.replace('-', ' ')}\n

\n {selectedJob.salary_range && (\n

\n 💰\n {selectedJob.salary_range}\n

\n )}\n

\n\n

Job Description

\n {selectedJob.description}\n

\n\n

Requirements

\n {selectedJob.requirements}\n

\n\n

\n Posted on {new Date(selectedJob.posted_at).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n })}\n {selectedJob.expires_at && (\n \n Expires {new Date(selectedJob.expires_at).toLocaleDateString()}\n \n )}\n

\n \n 📧 Apply Now\n \n

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

\n {/* Header */}\n

IT Job Opportunities

Discover your next career opportunity in technology

\n\n {/* Filters */}\n

\n Search\n handleFilterChange('search', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n Job Type\n handleFilterChange('type', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n >\n \n \n \n \n \n \n

\n Location\n handleFilterChange('location', e.target.value)}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500\"\n />\n

\n \n Clear Filters\n \n

\n\n {/* Loading State */}\n {loading && (\n

Loading jobs...

\n )}\n\n {/* Error State */}\n {error && (\n

\n ⚠️\n {error}\n \n Try Again\n \n

\n )}\n\n {/* Jobs List */}\n {!loading && !error && (\n <>\n

\n {jobs.length} job{jobs.length !== 1 ? 's' : ''} found\n

\n \n 🔄 Refresh\n \n

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

🔍

No jobs found

Try adjusting your filters or check back later for new opportunities.

\n ) : (\n

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

\n )}\n \n )}\n

\n );\n}","createdAt",["D",1748871724845],"branchVersion","branchId","f01b3f86-3fb6-11f0-a0c3-76b3cceeab13","id","f01ad88e-3fb6-11f0-a0c3-76b3cceeab13","ITJobListings",["D",1748871539335],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","ab434b70-3fb5-11f0-b6e9-ab0b2f88b858","pinnedFileId","2c8c9258-3fb7-11f0-9480-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","fd36482f-5e2f-4625-98a8-542f43351351","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",16,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","JonhSmith","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHhEaVFqc1NscUVUZ3I4V0JUWnNFTDZFU24ifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":297,"_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":298,"_79":299,"_81":300,"_83":24},"tree",[168,176,183,185],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183,184,185],"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},"03a84274-3fb7-11f0-90b7-76b3cceeab13","README.md","03a84350-3fb7-11f0-90b7-76b3cceeab13","parentId",1,"latest",["D",1748871572133],"# IT Jobs Board & Chat\n\nA full-stack application for posting IT job opportunities with a public chat room for discussing opportunities.\n\n## Features\n\n- 📋 **Job Postings**: Create, view, and manage IT job postings\n- 💬 **Public Chat**: Real-time chat room for discussing opportunities\n- 🔍 **Job Search**: Filter and search through job postings\n- 📱 **Responsive Design**: Works on desktop and mobile\n\n## Tech Stack\n\n- **Backend**: Hono.js API framework\n- **Frontend**: React with TypeScript\n- **Database**: SQLite for job postings and chat messages\n- **Styling**: TailwindCSS\n- **Real-time**: Server-sent events for chat updates\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 API server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main application component\n│ │ ├── JobBoard.tsx # Job listings component\n│ │ ├── JobForm.tsx # Job posting form\n│ │ ├── ChatRoom.tsx # Chat interface\n│ │ └── JobCard.tsx # Individual job display\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## API Endpoints\n\n### Jobs\n- `GET /api/jobs` - Get all job postings\n- `POST /api/jobs` - Create new job posting\n- `GET /api/jobs/:id` - Get specific job posting\n\n### Chat\n- `GET /api/chat/messages` - Get chat messages\n- `POST /api/chat/messages` - Send new message\n- `GET /api/chat/stream` - Server-sent events for real-time updates\n\n## Getting Started\n\nThis is a Val Town project. The main entry point is `backend/index.ts` which serves both the API and frontend files.","label",[130],"07fb816a-3fb7-11f0-a452-76b3cceeab13","shared","d00dacc8-4bbf-4c70-99b3-7b9efab2f4e5",2,["D",1748871579344],"directory",[140],"32a6fe44-3fb7-11f0-af77-76b3cceeab13","frontend","65a7d69d-bd22-4b08-a606-7a45f417aabe",8,["D",1748871650978],[147],"0c09bfc4-3fb7-11f0-9d66-76b3cceeab13","backend","b73a6c7f-82c5-4f39-a0d5-fccc581fa9ce",3,["D",1748871586191],[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":294,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":295,"_26":296},{"_42":290,"_31":282,"_29":276,"_132":154,"_40":41,"_39":155,"_134":57,"_37":291,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":292,"_26":293},{"_42":283,"_31":284,"_29":285,"_132":276,"_40":41,"_39":155,"_134":57,"_37":286,"_13":61,"_33":34,"_35":287,"_23":24,"_137":-5,"_187":288,"_26":289},{"_42":273,"_31":274,"_29":275,"_132":276,"_40":41,"_39":277,"_134":57,"_37":278,"_13":61,"_33":34,"_35":279,"_23":24,"_137":-5,"_187":280,"_26":281},{"_42":269,"_31":260,"_29":254,"_132":154,"_40":41,"_39":255,"_134":57,"_37":270,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":271,"_26":272},{"_42":261,"_31":262,"_29":263,"_132":254,"_40":41,"_39":264,"_134":57,"_37":265,"_13":61,"_33":34,"_35":266,"_23":24,"_137":-5,"_187":267,"_26":268},{"_42":251,"_31":252,"_29":253,"_132":254,"_40":41,"_39":255,"_134":57,"_37":256,"_13":61,"_33":34,"_35":257,"_23":24,"_137":-5,"_187":258,"_26":259},{"_42":244,"_31":245,"_29":55,"_132":154,"_40":41,"_39":246,"_134":24,"_37":247,"_13":61,"_33":34,"_35":248,"_23":24,"_137":-5,"_187":249,"_26":250},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":241,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":242,"_26":243},{"_42":237,"_31":224,"_29":218,"_132":148,"_40":41,"_39":232,"_134":57,"_37":238,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":239,"_26":240},{"_42":229,"_31":230,"_29":231,"_132":218,"_40":41,"_39":232,"_134":57,"_37":233,"_13":61,"_33":34,"_35":234,"_23":24,"_137":-5,"_187":235,"_26":236},{"_42":225,"_31":32,"_29":30,"_132":218,"_40":41,"_39":14,"_134":57,"_37":226,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_187":227,"_26":228},{"_42":215,"_31":216,"_29":217,"_132":218,"_40":41,"_39":219,"_134":57,"_37":220,"_13":61,"_33":34,"_35":221,"_23":24,"_137":-5,"_187":222,"_26":223},{"_42":208,"_31":209,"_29":210,"_132":148,"_40":41,"_39":149,"_134":57,"_37":211,"_13":61,"_33":20,"_35":212,"_23":24,"_137":-5,"_187":213,"_26":214},{"_42":200,"_31":201,"_29":202,"_132":148,"_40":41,"_39":203,"_134":57,"_37":204,"_13":61,"_33":34,"_35":205,"_23":24,"_137":-5,"_187":206,"_26":207},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":197,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_187":198,"_26":199},{"_42":190,"_31":191,"_29":192,"_132":141,"_40":41,"_39":142,"_134":57,"_37":193,"_13":61,"_33":34,"_35":194,"_23":24,"_137":-5,"_187":195,"_26":196},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":186,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_187":188,"_26":189},["D",1748871572133],"children",[],[130],"07fb797c-3fb7-11f0-a452-76b3cceeab13","types.ts","07fb7a3a-3fb7-11f0-a452-76b3cceeab13",["D",1748871579344],"// Shared types for the IT Jobs Board application\n\nexport interface JobPosting {\n id: number;\n title: string;\n company: string;\n location: string;\n type: 'full-time' | 'part-time' | 'contract' | 'remote';\n salary_range?: string;\n description: string;\n requirements: string;\n contact_email: string;\n posted_at: string;\n expires_at?: string;\n}\n\nexport interface ChatMessage {\n 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 type: 'full-time' | 'part-time' | 'contract' | 'remote';\n salary_range?: string;\n description: string;\n requirements: string;\n contact_email: string;\n expires_at?: string;\n}\n\nexport interface CreateMessageRequest {\n username: string;\n message: string;\n}\n\nexport interface JobFilters {\n type?: string;\n location?: string;\n search?: string;\n}",[],[140,191],["D",1748871579344],[184],[140],"35439f18-3fb7-11f0-b953-76b3cceeab13","index.tsx","35439fb8-3fb7-11f0-b953-76b3cceeab13",9,["D",1748871655362],"/** @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\nconst root = createRoot(document.getElementById(\"root\")!);\nroot.render();",[],[147,201],"32a6ebe8-3fb7-11f0-af77-76b3cceeab13","index.html","32a6ecce-3fb7-11f0-af77-76b3cceeab13",["D",1748871650978],"\n\n\n \n \n IT Jobs Board & Chat\n \n \n \n\n\n

\n \n\n",[],[147,209],"48ec0564-3fb7-11f0-a9f3-76b3cceeab13","JobCard.tsx","48ec0604-3fb7-11f0-a9f3-76b3cceeab13","e8b36a7c-6f2d-4dc0-851e-2ea0c84674a2",11,["D",1748871688340],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { JobPosting } from \"../../shared/types.ts\";\n\ninterface JobCardProps {\n job: JobPosting;\n onClick?: () => void;\n}\n\nexport default function JobCard({ job, onClick }: JobCardProps) {\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 getTypeColor = (type: string) => {\n switch (type) {\n case 'full-time': return 'bg-green-100 text-green-800';\n case 'part-time': return 'bg-blue-100 text-blue-800';\n case 'contract': return 'bg-purple-100 text-purple-800';\n case 'remote': return 'bg-orange-100 text-orange-800';\n default: return 'bg-gray-100 text-gray-800';\n }\n };\n\n const getTypeIcon = (type: string) => {\n switch (type) {\n case 'full-time': return '🏢';\n case 'part-time': return '⏰';\n case 'contract': return '📋';\n case 'remote': return '🌍';\n default: return '💼';\n }\n };\n\n return (\n

\n {/* Header */}\n

{job.title}

\n {job.company}\n •\n {job.location}\n

\n {getTypeIcon(job.type)}\n {job.type.replace('-', ' ')}\n

\n\n {/* Salary */}\n {job.salary_range && (\n

\n 💰 {job.salary_range}\n

\n )}\n\n {/* Description Preview */}\n

\n {job.description.length > 150 \n ? `${job.description.substring(0, 150)}...` \n : job.description\n }\n

\n\n {/* Requirements Preview */}\n

Key Requirements:

\n {job.requirements.length > 100 \n ? `${job.requirements.substring(0, 100)}...` \n : job.requirements\n }\n

\n\n {/* Footer */}\n

\n Posted {formatDate(job.posted_at)}\n

\n View Details\n →\n

\n\n {/* Expiry Warning */}\n {job.expires_at && (\n

\n ⏰ Expires {formatDate(job.expires_at)}\n

\n )}\n

\n );\n}",[],[147,224,216],"components","5eadfe7a-3fb7-11f0-b1ac-76b3cceeab13",["D",1748871724845],[],[147,224,32],"3e83f460-3fb7-11f0-a0d7-76b3cceeab13","App.tsx","3e83f51e-3fb7-11f0-a0d7-76b3cceeab13",10,["D",1748871670881],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport ChatRoom from \"./ChatRoom.tsx\";\nimport JobForm from \"./JobForm.tsx\";\n\ntype Tab = 'jobs' | 'chat' | 'post-job';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState('jobs');\n\n const tabs = [\n { id: 'jobs' as Tab, label: '💼 Job Board', icon: '📋' },\n { id: 'chat' as Tab, label: '💬 Chat Room', icon: '🗨️' },\n { id: 'post-job' as Tab, label: '➕ Post Job', icon: '📝' }\n ];\n\n return (\n

\n {/* Header */}\n

💻

IT Jobs Board

\n Find opportunities • Connect with others\n

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

\n {tabs.map((tab) => (\n setActiveTab(tab.id)}\n className={`py-4 px-1 border-b-2 font-medium text-sm transition-colors ${\n activeTab === tab.id\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n \n {tab.icon}\n {tab.label}\n \n \n ))}\n

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

\n {activeTab === 'jobs' && }\n {activeTab === 'chat' && }\n {activeTab === 'post-job' && setActiveTab('jobs')} />}\n

\n\n {/* Footer */}\n \n

\n );\n}",[],[147,224,230],"3e83fbea-3fb7-11f0-a0d7-76b3cceeab13",["D",1748871670881],[178,179,180],[147,224],["D",1748871650978],[177,181,182],[147],"2c8c917c-3fb7-11f0-9480-76b3cceeab13","index.ts",7,["D",1748871640740],"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 { runMigrations } from \"./database/migrations.ts\";\nimport jobs from \"./routes/jobs.ts\";\nimport chat 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\", jobs);\napp.route(\"/api/chat\", chat);\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 application\napp.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 initialDataScript = ``;\n\n html = html.replace(\"\", `${initialDataScript}`);\n return c.html(html);\n } catch (error) {\n console.error(\"Error serving index:\", error);\n return c.text(\"Error loading application\", 500);\n }\n});\n\n// Health check endpoint\napp.get(\"/health\", c => c.json({ status: \"ok\", timestamp: new Date().toISOString() }));\n\nexport default app;",[],[153,245],"1dc6222a-3fb7-11f0-929c-76b3cceeab13","jobs.ts","1dc62310-3fb7-11f0-929c-76b3cceeab13","123c9573-b30c-47b2-8dc6-0d24cbd38c7f",5,["D",1748871615948],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, getJobById, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest, JobFilters } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs with optional filters\njobs.get(\"/\", async (c) => {\n try {\n const filters: JobFilters = {\n type: c.req.query(\"type\"),\n location: c.req.query(\"location\"),\n search: c.req.query(\"search\")\n };\n\n // Remove undefined values\n Object.keys(filters).forEach(key => {\n if (filters[key as keyof JobFilters] === undefined) {\n delete filters[key as keyof JobFilters];\n }\n });\n\n const jobsList = await getAllJobs(Object.keys(filters).length > 0 ? filters : undefined);\n return c.json(jobsList);\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 posting\njobs.post(\"/\", async (c) => {\n try {\n const body = await c.req.json() as CreateJobRequest;\n\n // Validate required fields\n const requiredFields = ['title', 'company', 'location', 'type', 'description', 'requirements', 'contact_email'];\n for (const field of requiredFields) {\n if (!body[field as keyof CreateJobRequest]) {\n return c.json({ error: `Missing required field: ${field}` }, 400);\n }\n }\n\n // Validate job type\n const validTypes = ['full-time', 'part-time', 'contract', 'remote'];\n if (!validTypes.includes(body.type)) {\n return c.json({ error: \"Invalid job type\" }, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(body.contact_email)) {\n return c.json({ error: \"Invalid email format\" }, 400);\n }\n\n const newJob = await createJob(body);\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,260,252],"routes","264c0aea-3fb7-11f0-9279-76b3cceeab13","chat.ts","264c0ba8-3fb7-11f0-9279-76b3cceeab13",6,["D",1748871630247],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getChatMessages, createChatMessage, getRecentChatMessages } from \"../database/queries.ts\";\nimport type { CreateMessageRequest } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get chat messages\nchat.get(\"/messages\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"50\");\n const messages = await getChatMessages(limit);\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// Send new chat message\nchat.post(\"/messages\", async (c) => {\n try {\n const body = await c.req.json() as CreateMessageRequest;\n\n // Validate required fields\n if (!body.username || !body.message) {\n return c.json({ error: \"Username and message are required\" }, 400);\n }\n\n // Validate message length\n if (body.message.length > 500) {\n return c.json({ error: \"Message too long (max 500 characters)\" }, 400);\n }\n\n // Validate username length\n if (body.username.length > 50) {\n return c.json({ error: \"Username too long (max 50 characters)\" }, 400);\n }\n\n // Basic content filtering\n const message = body.message.trim();\n if (message.length === 0) {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n\n const newMessage = await createChatMessage({\n username: body.username.trim(),\n message: message\n });\n\n return c.json(newMessage, 201);\n } catch (error) {\n console.error(\"Error creating message:\", error);\n return c.json({ error: \"Failed to send message\" }, 500);\n }\n});\n\n// Server-sent events for real-time chat updates\nchat.get(\"/stream\", async (c) => {\n const lastMessageTime = c.req.query(\"since\") || new Date(0).toISOString();\n \n // Set up SSE headers\n c.header(\"Content-Type\", \"text/event-stream\");\n c.header(\"Cache-Control\", \"no-cache\");\n c.header(\"Connection\", \"keep-alive\");\n\n const stream = new ReadableStream({\n start(controller) {\n // Send initial connection message\n controller.enqueue(`data: ${JSON.stringify({ type: \"connected\" })}\\n\\n`);\n\n // Poll for new messages every 2 seconds\n const interval = setInterval(async () => {\n try {\n const recentMessages = await getRecentChatMessages(lastMessageTime);\n if (recentMessages.length > 0) {\n for (const message of recentMessages) {\n controller.enqueue(`data: ${JSON.stringify({ type: \"message\", data: message })}\\n\\n`);\n }\n }\n } catch (error) {\n console.error(\"Error in SSE stream:\", error);\n controller.enqueue(`data: ${JSON.stringify({ type: \"error\", message: \"Stream error\" })}\\n\\n`);\n }\n }, 2000);\n\n // Clean up on close\n setTimeout(() => {\n clearInterval(interval);\n controller.close();\n }, 300000); // Close after 5 minutes\n }\n });\n\n return new Response(stream);\n});\n\nexport default chat;",[],[153,260,262],"1dc62e3c-3fb7-11f0-929c-76b3cceeab13",["D",1748871615948],[173,174],[153,260],"15bd4b58-3fb7-11f0-861e-76b3cceeab13","queries.ts","15bd4c16-3fb7-11f0-861e-76b3cceeab13","203de2c1-d941-457c-81d0-2d47e5a30a07",4,["D",1748871602471],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_TABLE } from \"./migrations.ts\";\nimport type { JobPosting, ChatMessage, CreateJobRequest, CreateMessageRequest, JobFilters } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(filters?: JobFilters): Promise {\n let query = `SELECT * FROM ${JOBS_TABLE} WHERE 1=1`;\n const params: any[] = [];\n\n if (filters?.type) {\n query += ` AND type = ?`;\n params.push(filters.type);\n }\n\n if (filters?.location) {\n query += ` AND location LIKE ?`;\n params.push(`%${filters.location}%`);\n }\n\n if (filters?.search) {\n query += ` AND (title LIKE ? OR company LIKE ? OR description LIKE ?)`;\n const searchTerm = `%${filters.search}%`;\n params.push(searchTerm, searchTerm, searchTerm);\n }\n\n // Only show non-expired jobs\n query += ` AND (expires_at IS NULL OR expires_at > datetime('now'))`;\n query += ` ORDER BY posted_at DESC`;\n\n const result = await sqlite.execute(query, params);\n return result.rows as JobPosting[];\n}\n\nexport async function getJobById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${JOBS_TABLE} WHERE id = ?`,\n [id]\n );\n return result.rows[0] as JobPosting || null;\n}\n\nexport async function createJob(job: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} \n (title, company, location, type, salary_range, description, requirements, contact_email, expires_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n job.title,\n job.company,\n job.location,\n job.type,\n job.salary_range || null,\n job.description,\n job.requirements,\n job.contact_email,\n job.expires_at || null\n ]);\n\n const newJob = await getJobById(result.lastInsertRowId!);\n if (!newJob) {\n throw new Error('Failed to create job');\n }\n return newJob;\n}\n\n// Chat queries\nexport async function getChatMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} \n ORDER BY timestamp DESC \n LIMIT ?\n `, [limit]);\n \n // Reverse to show oldest first\n return (result.rows as ChatMessage[]).reverse();\n}\n\nexport async function createChatMessage(message: CreateMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_TABLE} (username, message)\n VALUES (?, ?)\n `, [message.username, message.message]);\n\n const newMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} WHERE id = ?\n `, [result.lastInsertRowId!]);\n\n return newMessage.rows[0] as ChatMessage;\n}\n\nexport async function getRecentChatMessages(since: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} \n WHERE timestamp > ?\n ORDER BY timestamp ASC\n `, [since]);\n \n return result.rows as ChatMessage[];\n}",[],[153,282,274],"database","0c09b90c-3fb7-11f0-9d66-76b3cceeab13","migrations.ts","0c09b9d4-3fb7-11f0-9d66-76b3cceeab13",["D",1748871586191],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'it_jobs_board_jobs_v1';\nconst CHAT_TABLE = 'it_jobs_board_chat_v1';\n\nexport async function runMigrations() {\n // Create jobs table\n await sqlite.execute(`\n 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 type TEXT NOT NULL CHECK (type IN ('full-time', 'part-time', 'contract', 'remote')),\n salary_range TEXT,\n description TEXT NOT NULL,\n requirements TEXT NOT NULL,\n contact_email TEXT NOT NULL,\n posted_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n expires_at DATETIME\n )\n `);\n\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, CHAT_TABLE };",[],[153,282,284],"0c09c1d6-3fb7-11f0-9d66-76b3cceeab13",["D",1748871586191],[170,171],[153,282],["D",1748871586191],[169,172,175],[153],["D",1748871539335],{"_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":334,"_335":336,"_337":338,"_339":24,"_340":24,"_341":24,"_342":57,"_343":-5,"_344":-7,"_345":-7,"_346":61,"_347":24,"_348":24,"_349":-5,"_350":24,"_351":24,"_352":24,"_353":-5},"ENV",{"_305":306,"_307":308,"_309":85,"_310":311,"_312":313,"_314":315,"_316":317,"_318":319,"_320":321,"_322":323,"_324":325,"_326":327,"_328":329,"_330":331,"_332":333},"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 · v12