Error loading application

Please try again later.

\n \n \n `, 500);\n }\n});\n\n// Health check\napp.get(\"/health\", c => c.json({ status: \"ok\", timestamp: new Date().toISOString() }));\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[18,94],"b8ba84c4-3fbc-11f0-bcb4-76b3cceeab13",["D",1748874023404],[18,84],"ab91c528-3fbc-11f0-bf6d-76b3cceeab13",["D",1748874001324],[18,68],"pulls","branches",1,"forks","envVars",{"_210":26,"_212":26},"connections",{"_210":26,"_211":26},"count","unfilledCount","emptyCount",{"_37":181,"_13":18,"_66":112,"_47":-5,"_39":40,"_182":44,"_183":24,"_41":352,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":353,"_17":354},{"_37":199,"_13":68,"_66":67,"_47":112,"_39":40,"_182":44,"_183":24,"_41":349,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":350,"_17":351},{"_37":342,"_13":343,"_66":344,"_47":67,"_39":40,"_182":44,"_183":24,"_41":345,"_43":26,"_69":95,"_185":346,"_71":30,"_186":-5,"_237":347,"_17":348},{"_37":334,"_13":335,"_66":336,"_47":67,"_39":40,"_182":337,"_183":24,"_41":338,"_43":26,"_69":95,"_185":339,"_71":30,"_186":-5,"_237":340,"_17":341},{"_37":196,"_13":84,"_66":83,"_47":112,"_39":40,"_182":77,"_183":24,"_41":331,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":332,"_17":333},{"_37":323,"_13":324,"_66":325,"_47":83,"_39":40,"_182":326,"_183":24,"_41":327,"_43":26,"_69":95,"_185":328,"_71":30,"_186":-5,"_237":329,"_17":330},{"_37":316,"_13":317,"_66":318,"_47":83,"_39":40,"_182":77,"_183":24,"_41":319,"_43":26,"_69":95,"_185":320,"_71":30,"_186":-5,"_237":321,"_17":322},{"_37":191,"_13":94,"_66":93,"_47":112,"_39":40,"_182":107,"_183":24,"_41":313,"_43":193,"_69":104,"_185":194,"_71":30,"_186":-5,"_237":314,"_17":315},{"_37":309,"_13":262,"_66":256,"_47":-5,"_39":40,"_182":266,"_183":24,"_41":310,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":311,"_17":312},{"_37":305,"_13":280,"_66":274,"_47":256,"_39":40,"_182":300,"_183":24,"_41":306,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":307,"_17":308},{"_37":297,"_13":298,"_66":299,"_47":274,"_39":40,"_182":300,"_183":24,"_41":301,"_43":26,"_69":95,"_185":302,"_71":30,"_186":-5,"_237":303,"_17":304},{"_37":289,"_13":290,"_66":291,"_47":274,"_39":40,"_182":292,"_183":24,"_41":293,"_43":26,"_69":95,"_185":294,"_71":30,"_186":-5,"_237":295,"_17":296},{"_37":281,"_13":282,"_66":283,"_47":274,"_39":40,"_182":284,"_183":24,"_41":285,"_43":26,"_69":95,"_185":286,"_71":30,"_186":-5,"_237":287,"_17":288},{"_37":271,"_13":272,"_66":273,"_47":274,"_39":40,"_182":275,"_183":24,"_41":276,"_43":26,"_69":95,"_185":277,"_71":30,"_186":-5,"_237":278,"_17":279},{"_37":263,"_13":264,"_66":265,"_47":256,"_39":40,"_182":266,"_183":24,"_41":267,"_43":26,"_69":21,"_185":268,"_71":30,"_186":-5,"_237":269,"_17":270},{"_37":253,"_13":254,"_66":255,"_47":256,"_39":40,"_182":257,"_183":24,"_41":258,"_43":26,"_69":95,"_185":259,"_71":30,"_186":-5,"_237":260,"_17":261},{"_37":249,"_13":248,"_66":243,"_47":-5,"_39":40,"_182":193,"_183":24,"_41":250,"_43":26,"_69":70,"_185":-5,"_71":30,"_186":-5,"_237":251,"_17":252},{"_37":240,"_13":241,"_66":242,"_47":243,"_39":40,"_182":193,"_183":24,"_41":244,"_43":26,"_69":95,"_185":245,"_71":30,"_186":-5,"_237":246,"_17":247},{"_37":232,"_13":233,"_66":234,"_47":-5,"_39":40,"_182":204,"_183":24,"_41":235,"_43":26,"_69":21,"_185":236,"_71":30,"_186":-5,"_237":238,"_17":239},"92ee8efc-3fbc-11f0-9f9e-76b3cceeab13","README.md","92ee8fc4-3fbc-11f0-9f9e-76b3cceeab13",["D",1748873959989],"# Job Board & Chat App\n\nA full-stack application for posting job opportunities and discussing them in a public chat room.\n\n## Features\n\n- **Job Postings**: Create, view, and manage job postings\n- **Public Chat**: Real-time chat room for discussing opportunities\n- **Responsive Design**: Works on desktop and mobile devices\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 API routes\n│ │ └── chat.ts # Chat API routes\n│ └── index.ts # Main Hono 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│ ├── 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 a new job posting\n- `DELETE /api/jobs/:id` - Delete a job posting\n\n### Chat\n- `GET /api/chat/messages` - Get recent chat messages\n- `POST /api/chat/messages` - Send a new chat message\n\n## Database Schema\n\n### Jobs Table\n- id (INTEGER PRIMARY KEY)\n- title (TEXT)\n- company (TEXT)\n- description (TEXT)\n- location (TEXT)\n- salary (TEXT)\n- contact_email (TEXT)\n- created_at (DATETIME)\n\n### Chat Messages Table\n- id (INTEGER PRIMARY KEY)\n- username (TEXT)\n- message (TEXT)\n- created_at (DATETIME)\n\n## Getting Started\n\nThis app runs on Val Town. The backend serves both the API and the frontend files.\n\nVisit the HTTP endpoint to access the application.","children",[],[233],"a739da4c-3fbc-11f0-aa5b-76b3cceeab13","types.ts","a739db14-3fbc-11f0-aa5b-76b3cceeab13","0b87d2d5-4b88-4b12-a5bb-2e374f4aa6cf",["D",1748873994037],"// Shared TypeScript types for the Job Board & Chat App\n\nexport interface Job {\n id: number;\n title: string;\n company: string;\n description: string;\n location: string;\n salary: string;\n contact_email: string;\n created_at: string;\n}\n\nexport interface CreateJobRequest {\n title: string;\n company: string;\n description: string;\n location: string;\n salary: string;\n contact_email: string;\n}\n\nexport interface ChatMessage {\n id: number;\n username: string;\n message: string;\n created_at: string;\n}\n\nexport interface CreateMessageRequest {\n username: string;\n message: string;\n}\n\nexport interface ApiResponse {\n success: boolean;\n data?: T;\n error?: string;\n}",[],[248,241],"shared","a739e014-3fbc-11f0-aa5b-76b3cceeab13",["D",1748873994037],[230],[248],"1a523ee8-3fbd-11f0-8663-76b3cceeab13","index.tsx","1a523f88-3fbd-11f0-8663-76b3cceeab13","d519e47a-98ed-407f-81e3-a69134cad10c",13,["D",1748874187138],"/** @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\";\nimport App from \"./components/App.tsx\";\n\nconst root = createRoot(document.getElementById('root')!);\nroot.render();",[],[262,254],"frontend","cc53e548-3fbc-11f0-b5c6-76b3cceeab13","index.html","cc53e624-3fbc-11f0-b5c6-76b3cceeab13",8,["D",1748874056215],"\n\n\n \n \n Job Board & Chat\n \n \n \n\n\n

\n \n \n\n",[],[262,264],"fdea63d4-3fbc-11f0-8220-76b3cceeab13","JobForm.tsx","fdea64ba-3fbc-11f0-8220-76b3cceeab13","0d9c1ac1-34fc-4444-ae79-c306bb6ed17f",11,["D",1748874139481],"/** @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 JobFormProps {\n onJobCreated: (job: Job) => void;\n onCancel: () => void;\n}\n\nexport default function JobForm({ onJobCreated, onCancel }: JobFormProps) {\n const [formData, setFormData] = useState({\n title: '',\n company: '',\n description: '',\n location: '',\n salary: '',\n contact_email: ''\n });\n const [loading, setLoading] = useState(false);\n const [errors, setErrors] = useState>({});\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n \n // Clear error when user starts typing\n if (errors[name]) {\n setErrors(prev => ({ ...prev, [name]: '' }));\n }\n };\n\n const validateForm = (): boolean => {\n const newErrors: Record = {};\n\n if (!formData.title.trim()) newErrors.title = 'Job title is required';\n if (!formData.company.trim()) newErrors.company = 'Company name is required';\n if (!formData.description.trim()) newErrors.description = 'Job description is required';\n if (!formData.location.trim()) newErrors.location = 'Location is required';\n if (!formData.salary.trim()) newErrors.salary = 'Salary information is required';\n if (!formData.contact_email.trim()) {\n newErrors.contact_email = 'Contact email is required';\n } else if (!/^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/.test(formData.contact_email)) {\n newErrors.contact_email = 'Please enter a valid email address';\n }\n\n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!validateForm()) return;\n\n setLoading(true);\n try {\n const response = await fetch('/api/jobs', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(formData),\n });\n\n const result = await response.json();\n \n if (result.success) {\n onJobCreated(result.data);\n } else {\n alert('Failed to create job: ' + result.error);\n }\n } catch (error) {\n alert('Failed to create job. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n return (\n

\n {/* Job Title */}\n

\n \n Job Title *\n \n \n {errors.title &&

{errors.title}

}\n

\n\n {/* Company */}\n

\n \n Company *\n \n \n {errors.company &&

{errors.company}

}\n

\n\n {/* Location and Salary Row */}\n

\n \n Location *\n \n \n {errors.location &&

{errors.location}

}\n

\n\n

\n \n Salary *\n \n \n {errors.salary &&

{errors.salary}

}\n

\n\n {/* Contact Email */}\n

\n \n Contact Email *\n \n \n {errors.contact_email &&

{errors.contact_email}

}\n

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

\n \n Job Description *\n \n \n {errors.description &&

{errors.description}

}\n

\n\n {/* Form Actions */}\n

\n \n {loading ? 'Posting...' : 'Post Job'}\n \n \n Cancel\n \n

\n );\n}",[],[262,280,272],"components","e9552f08-3fbc-11f0-954e-76b3cceeab13","JobBoard.tsx","e95530a2-3fbc-11f0-954e-76b3cceeab13",10,["D",1748874104950],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport JobForm from \"./JobForm.tsx\";\nimport type { Job } from \"../../shared/types.ts\";\n\ninterface JobBoardProps {\n jobs: Job[];\n setJobs: React.Dispatch>;\n}\n\nexport default function JobBoard({ jobs, setJobs }: JobBoardProps) {\n const [showForm, setShowForm] = useState(false);\n const [searchTerm, setSearchTerm] = useState(\"\");\n\n const filteredJobs = jobs.filter(job =>\n job.title.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.company.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.location.toLowerCase().includes(searchTerm.toLowerCase())\n );\n\n const handleJobCreated = (newJob: Job) => {\n setJobs(prev => [newJob, ...prev]);\n setShowForm(false);\n };\n\n const handleDeleteJob = async (jobId: number) => {\n if (!confirm('Are you sure you want to delete this job posting?')) {\n return;\n }\n\n try {\n const response = await fetch(`/api/jobs/${jobId}`, {\n method: 'DELETE',\n });\n\n const result = await response.json();\n if (result.success) {\n setJobs(prev => prev.filter(job => job.id !== jobId));\n } else {\n alert('Failed to delete job: ' + result.error);\n }\n } catch (error) {\n alert('Failed to delete job. Please try again.');\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 return (\n

\n {/* Header Section */}\n

Job Opportunities

\n {jobs.length} {jobs.length === 1 ? 'position' : 'positions'} available\n

\n setShowForm(true)}\n className=\"bg-blue-600 text-white px-6 py-3 rounded-lg font-medium hover:bg-blue-700 transition-colors flex items-center gap-2\"\n >\n ➕ Post a Job\n \n

\n\n {/* Search Bar */}\n

\n setSearchTerm(e.target.value)}\n className=\"w-full px-4 py-3 pl-12 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent\"\n />\n

\n 🔍\n

\n\n {/* Job Form Modal */}\n {showForm && (\n

Post a New Job

\n setShowForm(false)}\n className=\"text-gray-400 hover:text-gray-600 text-2xl\"\n >\n ✕\n \n

\n setShowForm(false)}\n />\n

\n )}\n\n {/* Jobs List */}\n

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

📭

\n {searchTerm ? 'No jobs match your search' : 'No jobs posted yet'}\n

\n {searchTerm \n ? 'Try adjusting your search terms'\n : 'Be the first to post a job opportunity!'\n }\n

\n ) : (\n filteredJobs.map((job) => (\n \n

\n {job.title}\n

\n \n 🏢 {job.company}\n \n \n 📍 {job.location}\n \n \n 💰 {job.salary}\n \n \n 📅 {formatDate(job.created_at)}\n \n

\n handleDeleteJob(job.id)}\n className=\"text-red-400 hover:text-red-600 p-2 rounded-lg hover:bg-red-50 transition-colors\"\n title=\"Delete job\"\n >\n 🗑️\n \n

\n \n

\n {job.description}\n

\n \n

\n \n 📧 Contact Employer\n \n \n Contact: {job.contact_email}\n \n

\n ))\n )}\n

\n \n );\n}",[],[262,280,282],"164bdd90-3fbd-11f0-967a-76b3cceeab13","ChatRoom.tsx","164bde3a-3fbd-11f0-967a-76b3cceeab13",12,["D",1748874180386],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage, CreateMessageRequest } from \"../../shared/types.ts\";\n\ninterface ChatRoomProps {\n messages: ChatMessage[];\n setMessages: React.Dispatch>;\n}\n\nexport default function ChatRoom({ messages, setMessages }: ChatRoomProps) {\n const [newMessage, setNewMessage] = useState('');\n const [username, setUsername] = useState('');\n const [loading, setLoading] = useState(false);\n const messagesEndRef = useRef(null);\n const chatContainerRef = useRef(null);\n\n // Load username from localStorage\n useEffect(() => {\n const savedUsername = localStorage.getItem('chat-username');\n if (savedUsername) {\n setUsername(savedUsername);\n }\n }, []);\n\n // Auto-scroll to bottom when new messages arrive\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n };\n\n const handleUsernameChange = (e: React.ChangeEvent) => {\n const value = e.target.value;\n setUsername(value);\n localStorage.setItem('chat-username', value);\n };\n\n const handleSendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!username.trim() || !newMessage.trim()) {\n alert('Please enter both username and message');\n return;\n }\n\n const messageData: CreateMessageRequest = {\n username: username.trim(),\n message: newMessage.trim()\n };\n\n setLoading(true);\n try {\n const response = await fetch('/api/chat/messages', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(messageData),\n });\n\n const result = await response.json();\n \n if (result.success) {\n setMessages(prev => [...prev, result.data]);\n setNewMessage('');\n } else {\n alert('Failed to send message: ' + result.error);\n }\n } catch (error) {\n alert('Failed to send message. Please try again.');\n } finally {\n setLoading(false);\n }\n };\n\n const refreshMessages = async () => {\n try {\n const response = await fetch('/api/chat/messages');\n const result = await response.json();\n \n if (result.success) {\n setMessages(result.data);\n }\n } catch (error) {\n console.error('Failed to refresh messages:', error);\n }\n };\n\n const formatTime = (dateString: string) => {\n return new Date(dateString).toLocaleTimeString('en-US', {\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const formatDate = (dateString: string) => {\n const date = new Date(dateString);\n const today = new Date();\n const yesterday = new Date(today);\n yesterday.setDate(yesterday.getDate() - 1);\n\n if (date.toDateString() === today.toDateString()) {\n return 'Today';\n } else if (date.toDateString() === yesterday.toDateString()) {\n return 'Yesterday';\n } else {\n return date.toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric'\n });\n }\n };\n\n // Group messages by date\n const groupedMessages = messages.reduce((groups, message) => {\n const date = new Date(message.created_at).toDateString();\n if (!groups[date]) {\n groups[date] = [];\n }\n groups[date].push(message);\n return groups;\n }, {} as Record);\n\n return (\n

\n {/* Header */}\n

💬 Community Chat

\n Discuss job opportunities and connect with others\n

\n \n 🔄 Refresh\n \n

\n\n {/* Username Input */}\n

\n \n Your Name\n \n \n

\n\n {/* Chat Container */}\n

\n {/* Messages Area */}\n \n {Object.keys(groupedMessages).length === 0 ? (\n

💬

\n No messages yet\n

\n Be the first to start the conversation!\n

\n ) : (\n Object.entries(groupedMessages).map(([date, dayMessages]) => (\n

\n {/* Date Separator */}\n

\n {formatDate(dayMessages[0].created_at)}\n

\n\n {/* Messages for this date */}\n {dayMessages.map((message, index) => (\n 0 && dayMessages[index - 1].username === message.username\n ? 'mt-1'\n : 'mt-4'\n }`}\n >\n {/* Avatar */}\n

\n {message.username.charAt(0).toUpperCase()}\n

\n\n {/* Message Content */}\n

\n {/* Username and time (only show if different from previous message) */}\n {(index === 0 || dayMessages[index - 1].username !== message.username) && (\n

\n \n {message.username}\n \n \n {formatTime(message.created_at)}\n \n

\n )}\n\n {/* Message text */}\n

\n {message.message}\n

\n ))}\n

\n ))\n )}\n

\n\n {/* Message Input */}\n

\n \n );\n}",[],[262,280,290],"d78fa852-3fbc-11f0-ab78-76b3cceeab13","App.tsx","d78fa910-3fbc-11f0-ab78-76b3cceeab13",9,["D",1748874075127],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport ChatRoom from \"./ChatRoom.tsx\";\nimport type { Job, ChatMessage } from \"../../shared/types.ts\";\n\ninterface InitialData {\n jobs: Job[];\n messages: ChatMessage[];\n}\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState<'jobs' | 'chat'>('jobs');\n const [jobs, setJobs] = useState([]);\n const [messages, setMessages] = useState([]);\n const [loading, setLoading] = useState(true);\n\n useEffect(() => {\n // Load initial data from server-side injection\n const initialData = (window as any).__INITIAL_DATA__ as InitialData;\n if (initialData) {\n setJobs(initialData.jobs || []);\n setMessages(initialData.messages || []);\n setLoading(false);\n } else {\n // Fallback: fetch data if not injected\n loadInitialData();\n }\n }, []);\n\n const loadInitialData = async () => {\n try {\n const [jobsRes, messagesRes] = await Promise.all([\n fetch('/api/jobs'),\n fetch('/api/chat/messages')\n ]);\n\n const jobsData = await jobsRes.json();\n const messagesData = await messagesRes.json();\n\n if (jobsData.success) setJobs(jobsData.data);\n if (messagesData.success) setMessages(messagesData.data);\n } catch (error) {\n console.error('Failed to load initial data:', error);\n } finally {\n setLoading(false);\n }\n };\n\n if (loading) {\n return (\n

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

\n {/* Header */}\n

💼 Job Board

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

\n setActiveTab('jobs')}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n activeTab === 'jobs'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n 📋 Job Listings\n \n setActiveTab('chat')}\n className={`px-3 py-2 rounded-md text-sm font-medium transition-colors ${\n activeTab === 'chat'\n ? 'bg-blue-100 text-blue-700'\n : 'text-gray-500 hover:text-gray-700 hover:bg-gray-100'\n }`}\n >\n 💬 Chat Room\n \n

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

\n {activeTab === 'jobs' ? (\n \n ) : (\n \n )}\n

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

\n );\n}",[],[262,280,298],"d78fd840-3fbc-11f0-ab78-76b3cceeab13",["D",1748874075127],[223,224,225,226],[262,280],"cc53f236-3fbc-11f0-b5c6-76b3cceeab13",["D",1748874056215],[222,227,228],[262],["D",1748874207961],[],[18,94],"b8ba7eac-3fbc-11f0-bcb4-76b3cceeab13","jobs.ts","b8ba7f4c-3fbc-11f0-bcb4-76b3cceeab13",["D",1748874023404],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, createJob, deleteJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const jobList = await getAllJobs();\n return c.json({\n success: true,\n data: jobList\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch jobs\"\n } as ApiResponse, 500);\n }\n});\n\n// Create a new job\njobs.post(\"/\", async (c) => {\n try {\n const jobData = await c.req.json() as CreateJobRequest;\n \n // Basic validation\n if (!jobData.title || !jobData.company || !jobData.description || \n !jobData.location || !jobData.salary || !jobData.contact_email) {\n return c.json({\n success: false,\n error: \"All fields are required\"\n } as ApiResponse, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(jobData.contact_email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n } as ApiResponse, 400);\n }\n\n const newJob = await createJob(jobData);\n return c.json({\n success: true,\n data: newJob\n } as ApiResponse, 201);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to create job\"\n } as ApiResponse, 500);\n }\n});\n\n// Delete a job\njobs.delete(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid job ID\"\n } as ApiResponse, 400);\n }\n\n const deleted = await deleteJob(id);\n if (!deleted) {\n return c.json({\n success: false,\n error: \"Job not found\"\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: { id }\n } as ApiResponse<{ id: number }>);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to delete job\"\n } as ApiResponse, 500);\n }\n});\n\nexport default jobs;",[],[18,84,317],"beb8474e-3fbc-11f0-9f58-76b3cceeab13","chat.ts","beb84802-3fbc-11f0-9f58-76b3cceeab13",6,["D",1748874033456],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getRecentMessages, createMessage } from \"../database/queries.ts\";\nimport type { CreateMessageRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get recent chat messages\nchat.get(\"/messages\", async (c) => {\n try {\n const messages = await getRecentMessages(50);\n return c.json({\n success: true,\n data: messages\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch messages\"\n } as ApiResponse, 500);\n }\n});\n\n// Send a new message\nchat.post(\"/messages\", async (c) => {\n try {\n const messageData = await c.req.json() as CreateMessageRequest;\n \n // Basic validation\n if (!messageData.username || !messageData.message) {\n return c.json({\n success: false,\n error: \"Username and message are required\"\n } as ApiResponse, 400);\n }\n\n // Trim and validate length\n messageData.username = messageData.username.trim();\n messageData.message = messageData.message.trim();\n\n if (messageData.username.length < 1 || messageData.username.length > 50) {\n return c.json({\n success: false,\n error: \"Username must be 1-50 characters\"\n } as ApiResponse, 400);\n }\n\n if (messageData.message.length < 1 || messageData.message.length > 500) {\n return c.json({\n success: false,\n error: \"Message must be 1-500 characters\"\n } as ApiResponse, 400);\n }\n\n const newMessage = await createMessage(messageData);\n return c.json({\n success: true,\n data: newMessage\n } as ApiResponse, 201);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to send message\"\n } as ApiResponse, 500);\n }\n});\n\nexport default chat;",[],[18,84,324],["D",1748874023404],[218,219],[18,84],"b1872806-3fbc-11f0-98b3-76b3cceeab13","queries.ts","b18728ba-3fbc-11f0-98b3-76b3cceeab13",4,["D",1748874011323],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_TABLE } from \"./migrations.ts\";\nimport type { Job, CreateJobRequest, ChatMessage, CreateMessageRequest } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} \n ORDER BY created_at DESC\n `);\n return result.rows as Job[];\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} (title, company, description, location, salary, contact_email)\n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n jobData.title,\n jobData.company,\n jobData.description,\n jobData.location,\n jobData.salary,\n jobData.contact_email\n ]);\n\n const insertId = result.lastInsertRowId;\n \n const newJob = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} WHERE id = ?\n `, [insertId]);\n\n return newJob.rows[0] as Job;\n}\n\nexport async function deleteJob(id: number): Promise {\n const result = await sqlite.execute(`\n DELETE FROM ${JOBS_TABLE} WHERE id = ?\n `, [id]);\n\n return result.changes > 0;\n}\n\n// Chat queries\nexport async function getRecentMessages(limit: number = 50): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} \n ORDER BY created_at DESC \n LIMIT ?\n `, [limit]);\n \n // Reverse to show oldest first\n return (result.rows as ChatMessage[]).reverse();\n}\n\nexport async function createMessage(messageData: CreateMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_TABLE} (username, message)\n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n const insertId = result.lastInsertRowId;\n \n const newMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} WHERE id = ?\n `, [insertId]);\n\n return newMessage.rows[0] as ChatMessage;\n}",[],[18,68,335],"ab91b2fe-3fbc-11f0-bf6d-76b3cceeab13","migrations.ts","ab91b3d0-3fbc-11f0-bf6d-76b3cceeab13",["D",1748874001324],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'job_board_jobs_v1';\nconst CHAT_TABLE = 'job_board_chat_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 description TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT NOT NULL,\n contact_email TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create chat messages table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${CHAT_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, CHAT_TABLE };",[],[18,68,343],["D",1748874001324],[215,216],[18,68],["D",1748874001324],[214,217,220],[18],["D",1748873938460],{"_11":12,"_159":74},{"_11":12,"_155":-5,"_73":74,"_31":72,"_156":157,"_158":30},{"_43":107,"_13":16,"_37":40,"_147":114,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":14,"_154":12},"ctx",{"_56":-5,"_178":392,"_393":394,"_395":396,"_397":30,"_398":30,"_399":30,"_400":24,"_401":-5,"_402":-7,"_403":-7,"_404":26,"_405":30,"_406":30,"_407":-5,"_408":30,"_409":30,"_410":30,"_411":-5},"ENV",{"_363":364,"_365":366,"_367":16,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387,"_388":389,"_390":391},"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"]

History · backend