\n \n \n\n","label",[162,67],"frontend","pulls","branches","forks","envVars",{"_170":26,"_172":26},"connections",{"_170":26,"_171":26},"count","unfilledCount","emptyCount",{"_32":328,"_13":287,"_65":281,"_42":-5,"_34":35,"_155":39,"_156":85,"_36":329,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":330,"_17":331},{"_32":324,"_13":316,"_65":311,"_42":281,"_34":35,"_155":39,"_156":85,"_36":325,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":326,"_17":327},{"_32":317,"_13":318,"_65":319,"_42":311,"_34":35,"_155":39,"_156":85,"_36":320,"_38":26,"_68":199,"_158":321,"_69":24,"_160":-5,"_201":322,"_17":323},{"_32":308,"_13":309,"_65":310,"_42":311,"_34":35,"_155":39,"_156":85,"_36":312,"_38":26,"_68":199,"_158":313,"_69":24,"_160":-5,"_201":314,"_17":315},{"_32":304,"_13":296,"_65":291,"_42":281,"_34":35,"_155":39,"_156":85,"_36":305,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":306,"_17":307},{"_32":297,"_13":298,"_65":299,"_42":291,"_34":35,"_155":39,"_156":85,"_36":300,"_38":26,"_68":199,"_158":301,"_69":24,"_160":-5,"_201":302,"_17":303},{"_32":288,"_13":289,"_65":290,"_42":291,"_34":35,"_155":39,"_156":85,"_36":292,"_38":26,"_68":199,"_158":293,"_69":24,"_160":-5,"_201":294,"_17":295},{"_32":279,"_13":280,"_65":83,"_42":281,"_34":35,"_155":39,"_156":85,"_36":282,"_38":26,"_68":283,"_158":284,"_69":24,"_160":-5,"_201":285,"_17":286},{"_32":275,"_13":162,"_65":154,"_42":-5,"_34":35,"_155":39,"_156":85,"_36":276,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":277,"_17":278},{"_32":271,"_13":249,"_65":244,"_42":154,"_34":35,"_155":39,"_156":85,"_36":272,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":273,"_17":274},{"_32":264,"_13":265,"_65":266,"_42":244,"_34":35,"_155":39,"_156":85,"_36":267,"_38":26,"_68":199,"_158":268,"_69":24,"_160":-5,"_201":269,"_17":270},{"_32":257,"_13":258,"_65":259,"_42":244,"_34":35,"_155":39,"_156":85,"_36":260,"_38":26,"_68":199,"_158":261,"_69":24,"_160":-5,"_201":262,"_17":263},{"_32":250,"_13":251,"_65":252,"_42":244,"_34":35,"_155":39,"_156":85,"_36":253,"_38":26,"_68":199,"_158":254,"_69":24,"_160":-5,"_201":255,"_17":256},{"_32":241,"_13":242,"_65":243,"_42":244,"_34":35,"_155":39,"_156":85,"_36":245,"_38":26,"_68":199,"_158":246,"_69":24,"_160":-5,"_201":247,"_17":248},{"_32":153,"_13":67,"_65":66,"_42":154,"_34":35,"_155":39,"_156":85,"_36":238,"_38":26,"_68":21,"_158":159,"_69":24,"_160":-5,"_201":239,"_17":240},{"_32":231,"_13":232,"_65":233,"_42":154,"_34":35,"_155":39,"_156":85,"_36":234,"_38":26,"_68":199,"_158":235,"_69":24,"_160":-5,"_201":236,"_17":237},{"_32":226,"_13":225,"_65":220,"_42":-5,"_34":35,"_155":39,"_156":85,"_36":227,"_38":26,"_68":228,"_158":-5,"_69":24,"_160":-5,"_201":229,"_17":230},{"_32":217,"_13":218,"_65":219,"_42":220,"_34":35,"_155":39,"_156":85,"_36":221,"_38":26,"_68":199,"_158":222,"_69":24,"_160":-5,"_201":223,"_17":224},{"_32":210,"_13":211,"_65":212,"_42":-5,"_34":35,"_155":39,"_156":85,"_36":213,"_38":26,"_68":21,"_158":214,"_69":24,"_160":-5,"_201":215,"_17":216},{"_32":204,"_13":205,"_65":206,"_42":-5,"_34":35,"_155":108,"_156":85,"_36":207,"_38":26,"_68":199,"_158":200,"_69":24,"_160":-5,"_201":208,"_17":209},{"_32":194,"_13":195,"_65":196,"_42":-5,"_34":35,"_155":197,"_156":85,"_36":198,"_38":26,"_68":199,"_158":200,"_69":24,"_160":-5,"_201":202,"_17":203},"1575f0fa-3fb7-11f0-991f-76b3cceeab13","new-file-7867.tsx","1575f1a4-3fb7-11f0-991f-76b3cceeab13",2,["D",1748871602005],"script","","children",[],[195],"551b818e-3fb7-11f0-8588-76b3cceeab13","new-file-1946.tsx","551b821a-3fb7-11f0-8588-76b3cceeab13",["D",1748871708785],[],[205],"ef3fc6fe-3fb6-11f0-9264-76b3cceeab13","README.md","ba878a6e-4210-499d-8093-571281db1731",["D",1748871537859],"# 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.",[],[211],"ef3fc366-3fb6-11f0-9264-76b3cceeab13","types.ts","b200d77f-9266-4e81-af8e-4deb3d4b6775","247ffcda-e1f3-4add-8048-f2bbb5500d58",["D",1748871537859],"// Shared types for the job board application\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}",[],[225,218],"shared","ef3fc53c-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],"directory",[190],[225],"ef3fba92-3fb6-11f0-9264-76b3cceeab13","index.tsx","4bbe0d3d-b46a-449a-9c63-8b3c7e63c4b7",["D",1748871537859],"/** @jsxImportSource https://esm.sh/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();",[],[162,232],["D",1748871537859],[],[162,67],"ef3faf0c-3fb6-11f0-9264-76b3cceeab13","JobForm.tsx","4391c459-b239-48dc-8cc9-bdd75a44bce7","276a86d9-4f05-4e18-8f60-5add9f629553",["D",1748871537859],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Job, CreateJobRequest, ApiResponse } from \"../../shared/types.ts\";\n\ninterface JobFormProps {\n onJobCreated: (job: Job) => void;\n}\n\nexport default function JobForm({ onJobCreated }: 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 [error, setError] = useState(null);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\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(formData)\n });\n\n const result: ApiResponse = await response.json();\n\n if (result.success && result.data) {\n onJobCreated(result.data);\n // Reset form\n setFormData({\n title: '',\n company: '',\n description: '',\n location: '',\n salary: '',\n contact_email: ''\n });\n } else {\n setError(result.error || 'Failed to create job posting');\n }\n } catch (err) {\n setError('Failed to create job posting');\n } finally {\n setLoading(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({\n ...prev,\n [name]: value\n }));\n };\n\n return (\n \n );\n}",[],[162,249,242],"components","ef3fa7d2-3fb6-11f0-9264-76b3cceeab13","JobBoard.tsx","0f064e64-f6e6-439e-9414-25ea212fe21d",["D",1748871537859],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport JobForm from \"./JobForm.tsx\";\nimport type { Job, ApiResponse } from \"../../shared/types.ts\";\n\nexport default function JobBoard() {\n const [jobs, setJobs] = useState([]);\n const [loading, setLoading] = useState(true);\n const [showForm, setShowForm] = useState(false);\n const [error, setError] = useState(null);\n\n const fetchJobs = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/jobs');\n const result: ApiResponse = await response.json();\n \n if (result.success && result.data) {\n setJobs(result.data);\n setError(null);\n } else {\n setError(result.error || 'Failed to fetch jobs');\n }\n } catch (err) {\n setError('Failed to fetch jobs');\n } finally {\n setLoading(false);\n }\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: ApiResponse<{ id: number }> = await response.json();\n \n if (result.success) {\n setJobs(prev => prev.filter(job => job.id !== jobId));\n } else {\n alert(result.error || 'Failed to delete job');\n }\n } catch (err) {\n alert('Failed to delete job');\n }\n };\n\n useEffect(() => {\n fetchJobs();\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 if (loading) {\n return (\n

Loading jobs...

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

\n {/* Header with Post Job Button */}\n

Job Postings

Browse and post job opportunities

\n setShowForm(!showForm)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-lg hover:bg-blue-700 transition-colors\"\n >\n {showForm ? 'Cancel' : '+ Post Job'}\n \n

\n\n {/* Error Message */}\n {error && (\n

\n {error}\n

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

Post a New Job

\n \n

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

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

📋

No job postings yet. Be the first to post one!

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

{job.title}

{job.company}

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

\n handleDeleteJob(job.id)}\n className=\"text-red-500 hover:text-red-700 text-sm px-2 py-1 rounded hover:bg-red-50\"\n title=\"Delete job posting\"\n >\n 🗑️\n \n

\n \n

{job.description}

\n \n

\n \n Contact: {job.contact_email}\n \n \n Apply Now\n \n

\n ))\n )}\n

\n );\n}",[],[162,249,251],"ef3f9c10-3fb6-11f0-9264-76b3cceeab13","ChatRoom.tsx","718c44b2-eb34-47fe-a7e0-04462b84d8af",["D",1748871537859],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage, CreateMessageRequest, ApiResponse } from \"../../shared/types.ts\";\n\nexport default function ChatRoom() {\n const [messages, setMessages] = useState([]);\n const [username, setUsername] = useState('');\n const [message, setMessage] = useState('');\n const [loading, setLoading] = useState(true);\n const [sending, setSending] = useState(false);\n const [error, setError] = useState(null);\n const messagesEndRef = useRef(null);\n const chatContainerRef = useRef(null);\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n };\n\n const fetchMessages = async () => {\n try {\n const response = await fetch('/api/chat/messages');\n const result: ApiResponse = await response.json();\n \n if (result.success && result.data) {\n setMessages(result.data);\n setError(null);\n } else {\n setError(result.error || 'Failed to fetch messages');\n }\n } catch (err) {\n setError('Failed to fetch messages');\n } finally {\n setLoading(false);\n }\n };\n\n const sendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!username.trim() || !message.trim()) {\n return;\n }\n\n setSending(true);\n setError(null);\n\n try {\n const messageData: CreateMessageRequest = {\n username: username.trim(),\n message: message.trim()\n };\n\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: ApiResponse = await response.json();\n\n if (result.success && result.data) {\n setMessages(prev => [...prev, result.data!]);\n setMessage('');\n setTimeout(scrollToBottom, 100);\n } else {\n setError(result.error || 'Failed to send message');\n }\n } catch (err) {\n setError('Failed to send message');\n } finally {\n setSending(false);\n }\n };\n\n const refreshMessages = async () => {\n await fetchMessages();\n setTimeout(scrollToBottom, 100);\n };\n\n useEffect(() => {\n fetchMessages();\n }, []);\n\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\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 if (loading) {\n return (\n

Loading chat...

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

\n {/* Chat Header */}\n

💬 Public Chat Room

Discuss job opportunities and connect with others

\n \n 🔄 Refresh\n \n

\n\n {/* Error Message */}\n {error && (\n

\n {error}\n

\n )}\n\n {/* Messages Container */}\n

\n {Object.keys(groupedMessages).length === 0 ? (\n

💬

No messages yet. Start the conversation!

\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((msg, index) => {\n const prevMsg = index > 0 ? dayMessages[index - 1] : null;\n const isConsecutive = prevMsg && prevMsg.username === msg.username;\n \n return (\n

\n {!isConsecutive && (\n

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

\n )}\n

\n {msg.message}\n

\n );\n })}\n

\n ))\n )}\n

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

\n setUsername(e.target.value)}\n placeholder=\"Your name\"\n maxLength={50}\n className=\"w-32 px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n />\n

\n setMessage(e.target.value)}\n placeholder=\"Type your message...\"\n maxLength={500}\n className=\"w-full px-3 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-blue-500\"\n />\n

\n \n {sending ? 'Sending...' : 'Send'}\n \n

\n {message.length}/500 characters\n

\n );\n}",[],[162,249,258],"ef3f94b8-3fb6-11f0-9264-76b3cceeab13","App.tsx","b29b6957-4738-448a-8f94-70f429b50507",["D",1748871537859],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport ChatRoom from \"./ChatRoom.tsx\";\n\ntype Tab = 'jobs' | 'chat';\n\nexport default function App() {\n const [activeTab, setActiveTab] = useState('jobs');\n\n return (\n

\n {/* Header */}\n

💼 Job Board & Chat

Find opportunities and connect with others

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

\n setActiveTab('jobs')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'jobs'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n 📋 Job Postings\n \n setActiveTab('chat')}\n className={`py-4 px-1 border-b-2 font-medium text-sm ${\n activeTab === 'chat'\n ? 'border-blue-500 text-blue-600'\n : 'border-transparent text-gray-500 hover:text-gray-700 hover:border-gray-300'\n }`}\n >\n 💬 Chat Room\n \n

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

\n {activeTab === 'jobs' && }\n {activeTab === 'chat' && }\n

\n );\n}",[],[162,249,265],"ef3fb6a0-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],[183,184,185,186],[162,249],"ef3fc14a-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],[182,187,188],[162],"ef3f8fc2-3fb6-11f0-9264-76b3cceeab13","index.ts","8752d3f5-f15a-4d37-8827-607e889507ac",["D",1748871537859],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations } from \"./database/migrations.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 on startup\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 the main application\napp.get(\"/\", async c => {\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\n// Health check\napp.get(\"/health\", c => {\n return c.json({ status: \"ok\", timestamp: new Date().toISOString() });\n});\n\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[287,280],"backend","ef3f8964-3fb6-11f0-9264-76b3cceeab13","jobs.ts","32ff77c4-5813-4982-b23d-2d00c8eda94d","e197636a-7185-44f0-bc95-a4b2d9c93eb0",["D",1748871537859],"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;",[],[287,296,289],"routes","ef3f818a-3fb6-11f0-9264-76b3cceeab13","chat.ts","5b83214f-2149-4382-8d7d-966d2695541f",["D",1748871537859],"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;",[],[287,296,298],"ef3f8d92-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],[178,179],[287,296],"ef3f77da-3fb6-11f0-9264-76b3cceeab13","queries.ts","450c297b-e4c4-4c0e-8c45-17a3545d68fd","75a225a9-1ff5-478e-9826-48f00f2a1b03",["D",1748871537859],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_MESSAGES_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 // Get the created job\n const createdJob = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n return createdJob.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_MESSAGES_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_MESSAGES_TABLE} (username, message)\n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n // Get the created message\n const createdMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} WHERE id = ?\n `, [result.lastInsertRowId]);\n\n return createdMessage.rows[0] as ChatMessage;\n}",[],[287,316,309],"database","ef3f6ef2-3fb6-11f0-9264-76b3cceeab13","migrations.ts","a8a81673-d1fd-48d0-84d0-d645109e25e1",["D",1748871537859],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Table names with version numbers for easy schema updates\nexport const JOBS_TABLE = 'jobs_v1';\nexport const CHAT_MESSAGES_TABLE = 'chat_messages_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 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\n // Create chat messages table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${CHAT_MESSAGES_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\n console.log('Database migrations completed');\n}",[],[287,316,318],"ef3f7e74-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],[175,176],[287,316],"ef3f92b0-3fb6-11f0-9264-76b3cceeab13",["D",1748871537859],[174,177,180],[287],["D",1748871537859],{"_11":12,"_122":72},{"_11":12,"_118":-5,"_71":72,"_30":70,"_119":120,"_121":24},{"_38":108,"_13":16,"_32":35,"_109":74,"_110":62,"_111":63,"_112":78,"_113":114,"_115":41,"_116":14,"_117":12},"ctx",{"_51":-5,"_143":369,"_370":371,"_372":373,"_374":24,"_375":24,"_376":24,"_377":85,"_378":-5,"_379":-7,"_380":-7,"_381":26,"_382":24,"_383":24,"_384":-5,"_385":24,"_386":24,"_387":24,"_388":-5},"ENV",{"_340":341,"_342":343,"_344":16,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368},"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 · index.html