\n \n \n\n",[],[76,126],"f58ac0e4-3f44-11f0-b05a-76b3cceeab13","components","6d88f213-be7d-47f8-ae4c-9eae0ae9fb74",12,["D",1748822585812],[139,140,141,142],[76,133],{"_37":167,"_13":168,"_40":169,"_42":134,"_43":44,"_45":135,"_47":48,"_49":170,"_17":65,"_52":107,"_54":171,"_56":57,"_58":-5,"_93":172,"_18":173},{"_37":159,"_13":160,"_40":161,"_42":134,"_43":44,"_45":162,"_47":48,"_49":163,"_17":65,"_52":107,"_54":164,"_56":57,"_58":-5,"_93":165,"_18":166},{"_37":151,"_13":152,"_40":153,"_42":134,"_43":44,"_45":154,"_47":48,"_49":155,"_17":65,"_52":107,"_54":156,"_56":57,"_58":-5,"_93":157,"_18":158},{"_37":143,"_13":144,"_40":145,"_42":134,"_43":44,"_45":146,"_47":48,"_49":147,"_17":65,"_52":107,"_54":148,"_56":57,"_58":-5,"_93":149,"_18":150},"231ffe66-3f45-11f0-9c8b-76b3cceeab13","JobForm.tsx","231fff1a-3f45-11f0-9c8b-76b3cceeab13",14,["D",1748822662302],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CreateJobRequest, ApiResponse, Job } from \"../../shared/types.ts\";\n\ninterface JobFormProps {\n onJobPosted: () => void;\n}\n\nexport default function JobForm({ onJobPosted }: JobFormProps) {\n const [formData, setFormData] = useState({\n title: '',\n company: '',\n description: '',\n requirements: '',\n location: '',\n salary: '',\n type: 'full-time',\n remote: false\n });\n \n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [success, setSuccess] = useState(false);\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\n setSuccess(false);\n\n try {\n // Prepare data for submission\n const submitData = {\n ...formData,\n salary: formData.salary.trim() || undefined\n };\n\n const response = await fetch('/api/jobs', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(submitData),\n });\n\n const result: ApiResponse = await response.json();\n\n if (result.success) {\n setSuccess(true);\n // Reset form\n setFormData({\n title: '',\n company: '',\n description: '',\n requirements: '',\n location: '',\n salary: '',\n type: 'full-time',\n remote: false\n });\n \n // Notify parent component\n setTimeout(() => {\n onJobPosted();\n }, 1500);\n } else {\n setError(result.error || 'Failed to post job');\n }\n } catch (err) {\n setError('Failed to post job. Please try again.');\n console.error('Error posting job:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const handleChange = (e: React.ChangeEvent) => {\n const { name, value, type } = e.target;\n \n if (type === 'checkbox') {\n const checked = (e.target as HTMLInputElement).checked;\n setFormData(prev => ({ ...prev, [name]: checked }));\n } else {\n setFormData(prev => ({ ...prev, [name]: value }));\n }\n };\n\n if (success) {\n return (\n

🎉

Job Posted Successfully!

\n Your job posting has been published and is now visible to all users.\n

\n Redirecting to job board in a moment...\n

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

Post a New Job

\n Share your job opportunity with the community. All fields marked with * are required.\n

\n\n {error && (\n

⚠️

Error posting job

{error}

\n )}\n\n

\n \n Job Title *\n \n \n

\n\n

\n \n Company *\n \n \n

\n\n

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

\n\n

\n \n Salary (Optional)\n \n \n

\n\n

\n \n Location *\n \n \n

\n\n

\n \n \n This is a remote position\n \n

\n\n

\n \n Job Description *\n \n \n

\n\n

\n \n Requirements *\n \n \n

\n\n

\n {\n setFormData({\n title: '',\n company: '',\n description: '',\n requirements: '',\n location: '',\n salary: '',\n type: 'full-time',\n remote: false\n });\n setError(null);\n }}\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 Clear Form\n \n \n {loading ? (\n \n

\n Posting...\n \n ) : (\n 'Post Job'\n )}\n \n

\n );\n}",[],[76,133,144],"0abb7684-3f45-11f0-bbb6-76b3cceeab13","JobBoard.tsx","0abb7756-3f45-11f0-bbb6-76b3cceeab13",13,["D",1748822621377],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\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 [error, setError] = useState(null);\n const [searchTerm, setSearchTerm] = useState('');\n const [filterType, setFilterType] = useState('all');\n const [filterRemote, setFilterRemote] = useState('all');\n\n useEffect(() => {\n fetchJobs();\n }, []);\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 console.error('Error fetching jobs:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const filteredJobs = jobs.filter(job => {\n const matchesSearch = job.title.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.company.toLowerCase().includes(searchTerm.toLowerCase()) ||\n job.description.toLowerCase().includes(searchTerm.toLowerCase());\n \n const matchesType = filterType === 'all' || job.type === filterType;\n const matchesRemote = filterRemote === 'all' || \n (filterRemote === 'remote' && job.remote) ||\n (filterRemote === 'onsite' && !job.remote);\n\n return matchesSearch && matchesType && matchesRemote;\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 getJobTypeColor = (type: string) => {\n const colors = {\n 'full-time': 'bg-green-100 text-green-800',\n 'part-time': 'bg-blue-100 text-blue-800',\n 'contract': 'bg-purple-100 text-purple-800',\n 'internship': 'bg-orange-100 text-orange-800'\n };\n return colors[type as keyof typeof colors] || 'bg-gray-100 text-gray-800';\n };\n\n if (loading) {\n return (\n

\n Loading jobs...\n

\n );\n }\n\n if (error) {\n return (\n

⚠️

Error loading jobs

{error}

\n \n Try again\n \n

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

\n {/* Header */}\n

Job Opportunities

\n \n 🔄 Refresh\n \n

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

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

\n \n

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

\n\n

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

\n\n {/* Job Count */}\n

\n Showing {filteredJobs.length} of {jobs.length} jobs\n

\n\n {/* Job Listings */}\n {filteredJobs.length === 0 ? (\n

🔍

No jobs found

\n {jobs.length === 0 \n ? \"No jobs have been posted yet. Be the first to post a job!\"\n : \"Try adjusting your search criteria to find more opportunities.\"\n }\n

\n ) : (\n

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

{job.title}

\n \n 🏢 {job.company}\n \n \n 📍 {job.location}\n \n {job.remote && (\n \n 🌐 Remote\n \n )}\n {job.salary && (\n \n 💰 {job.salary}\n \n )}\n

\n \n {job.type}\n \n \n {formatDate(job.created_at)}\n \n

\n\n

Description

{job.description}

\n \n

Requirements

{job.requirements}

\n ))}\n

\n )}\n

\n );\n}",[],[76,133,152],"3d905f20-3f45-11f0-864b-76b3cceeab13","ChatRoom.tsx","3d905fde-3f45-11f0-864b-76b3cceeab13",15,["D",1748822706659],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage, CreateChatMessageRequest, ApiResponse } from \"../../shared/types.ts\";\n\nexport default function ChatRoom() {\n const [messages, setMessages] = useState([]);\n const [loading, setLoading] = useState(true);\n const [error, setError] = useState(null);\n const [username, setUsername] = useState('');\n const [message, setMessage] = useState('');\n const [sending, setSending] = useState(false);\n const messagesEndRef = useRef(null);\n const chatContainerRef = useRef(null);\n\n // Auto-refresh messages every 3 seconds\n useEffect(() => {\n fetchMessages();\n const interval = setInterval(fetchMessages, 3000);\n return () => clearInterval(interval);\n }, []);\n\n // Scroll to bottom when new messages arrive\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\n\n // Load username from localStorage\n useEffect(() => {\n const savedUsername = localStorage.getItem('chatUsername');\n if (savedUsername) {\n setUsername(savedUsername);\n }\n }, []);\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 console.error('Error fetching messages:', err);\n } finally {\n setLoading(false);\n }\n };\n\n const handleSendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!username.trim() || !message.trim()) {\n return;\n }\n\n setSending(true);\n \n try {\n const messageData: CreateChatMessageRequest = {\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) {\n setMessage('');\n // Save username to localStorage\n localStorage.setItem('chatUsername', username.trim());\n // Refresh messages immediately\n await fetchMessages();\n } else {\n setError(result.error || 'Failed to send message');\n }\n } catch (err) {\n setError('Failed to send message');\n console.error('Error sending message:', err);\n } finally {\n setSending(false);\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, share insights, and connect with the community\n

\n Live\n

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

\n {loading ? (\n

\n Loading messages...\n

\n ) : error ? (\n

⚠️

Error loading messages

{error}

\n \n Try again\n \n

\n ) : messages.length === 0 ? (\n

💬

No messages yet

\n Be the first to start the conversation! Share your thoughts about job opportunities.\n

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

\n {/* Date separator */}\n

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

\n \n {/* Messages for this date */}\n {dateMessages.map((msg, index) => {\n const prevMessage = index > 0 ? dateMessages[index - 1] : null;\n const isConsecutive = prevMessage && \n prevMessage.username === msg.username &&\n new Date(msg.created_at).getTime() - new Date(prevMessage.created_at).getTime() < 300000; // 5 minutes\n\n return (\n

\n {!isConsecutive ? (\n

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

\n ) : (\n

\n )}\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 maxLength={50}\n className=\"w-32 px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-blue-500 focus:border-blue-500 text-sm\"\n />\n setMessage(e.target.value)}\n maxLength={500}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md shadow-sm focus:outline-none focus:ring-blue-500 focus:border-blue-500 text-sm\"\n />\n \n {sending ? (\n

\n ) : (\n 'Send'\n )}\n \n

\n Messages are public and visible to all users. Be respectful and professional.\n

\n );\n}",[],[76,133,160],"f58aadb6-3f44-11f0-b05a-76b3cceeab13","App.tsx","f58aae88-3f44-11f0-b05a-76b3cceeab13",["D",1748822585812],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport JobBoard from \"./JobBoard.tsx\";\nimport JobForm from \"./JobForm.tsx\";\nimport ChatRoom from \"./ChatRoom.tsx\";\n\ntype Tab = 'jobs' | 'post-job' | 'chat';\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: 'post-job' as Tab, label: '➕ Post Job', icon: '✏️' },\n { id: 'chat' as Tab, label: '💬 Chat Room', icon: '🗨️' }\n ];\n\n return (\n

\n {/* Header */}\n

🚀

Job Board & Chat

\n Connect • Share • Grow\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 duration-200 ${\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 === 'post-job' && setActiveTab('jobs')} />}\n {activeTab === 'chat' && }\n

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

\n );\n}",[],[76,133,168],["D",1748822512071],[177,178,179],[82],{"_37":212,"_13":213,"_40":214,"_42":83,"_43":44,"_45":84,"_47":48,"_49":215,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":216,"_18":217},{"_37":188,"_13":189,"_40":190,"_42":83,"_43":44,"_45":191,"_47":48,"_49":192,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":193,"_18":194},{"_37":180,"_13":181,"_40":182,"_42":83,"_43":44,"_45":183,"_47":48,"_49":184,"_17":65,"_52":107,"_54":185,"_56":57,"_58":-5,"_93":186,"_18":187},"e536212a-3f44-11f0-a997-76b3cceeab13","index.ts","e53621e8-3f44-11f0-a997-76b3cceeab13",10,["D",1748822558425],"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 main page\napp.get(\"/\", async c => {\n let 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: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// 404 handler\napp.notFound(c => {\n return c.json({ error: \"Not found\" }, 404);\n});\n\nexport default app;",[],[82,181],"d7bca0f0-3f44-11f0-84d8-76b3cceeab13","routes","8f4986e5-0f6a-47fc-ae5e-60d1a61a69c5",8,["D",1748822535818],[195,196],[82,189],{"_37":204,"_13":205,"_40":206,"_42":190,"_43":44,"_45":207,"_47":48,"_49":208,"_17":65,"_52":107,"_54":209,"_56":57,"_58":-5,"_93":210,"_18":211},{"_37":197,"_13":198,"_40":199,"_42":190,"_43":44,"_45":191,"_47":48,"_49":200,"_17":65,"_52":107,"_54":201,"_56":57,"_58":-5,"_93":202,"_18":203},"d7bc8084-3f44-11f0-84d8-76b3cceeab13","jobs.ts","d7bc814c-3f44-11f0-84d8-76b3cceeab13",["D",1748822535818],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, getJobById, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest, ApiResponse, Job } 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 const response: ApiResponse = {\n success: true,\n data: jobList\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch jobs'\n };\n return c.json(response, 500);\n }\n});\n\n// Get job by ID\njobs.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: 'Invalid job ID'\n };\n return c.json(response, 400);\n }\n\n const job = await getJobById(id);\n if (!job) {\n const response: ApiResponse = {\n success: false,\n error: 'Job not found'\n };\n return c.json(response, 404);\n }\n\n const response: ApiResponse = {\n success: true,\n data: job\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch job'\n };\n return c.json(response, 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.description || !jobData.requirements || !jobData.location || !jobData.type) {\n const response: ApiResponse = {\n success: false,\n error: 'Missing required fields: title, company, description, requirements, location, type'\n };\n return c.json(response, 400);\n }\n\n const validTypes = ['full-time', 'part-time', 'contract', 'internship'];\n if (!validTypes.includes(jobData.type)) {\n const response: ApiResponse = {\n success: false,\n error: 'Invalid job type. Must be one of: ' + validTypes.join(', ')\n };\n return c.json(response, 400);\n }\n\n const newJob = await createJob(jobData);\n const response: ApiResponse = {\n success: true,\n data: newJob\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to create job'\n };\n return c.json(response, 500);\n }\n});\n\nexport default jobs;",[],[82,189,198],"df448e64-3f44-11f0-828b-76b3cceeab13","chat.ts","df448f22-3f44-11f0-828b-76b3cceeab13",9,["D",1748822548456],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getChatMessages, createChatMessage } from \"../database/queries.ts\";\nimport type { CreateChatMessageRequest, ApiResponse, ChatMessage } 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 \n const response: ApiResponse = {\n success: true,\n data: messages\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to fetch messages'\n };\n return c.json(response, 500);\n }\n});\n\n// Send chat message\nchat.post(\"/messages\", async (c) => {\n try {\n const messageData: CreateChatMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.username || !messageData.message) {\n const response: ApiResponse = {\n success: false,\n error: 'Missing required fields: username, message'\n };\n return c.json(response, 400);\n }\n\n // Trim and validate message length\n messageData.username = messageData.username.trim();\n messageData.message = messageData.message.trim();\n\n if (messageData.username.length === 0 || messageData.message.length === 0) {\n const response: ApiResponse = {\n success: false,\n error: 'Username and message cannot be empty'\n };\n return c.json(response, 400);\n }\n\n if (messageData.username.length > 50) {\n const response: ApiResponse = {\n success: false,\n error: 'Username must be 50 characters or less'\n };\n return c.json(response, 400);\n }\n\n if (messageData.message.length > 500) {\n const response: ApiResponse = {\n success: false,\n error: 'Message must be 500 characters or less'\n };\n return c.json(response, 400);\n }\n\n const newMessage = await createChatMessage(messageData);\n const response: ApiResponse = {\n success: true,\n data: newMessage\n };\n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: error instanceof Error ? error.message : 'Failed to send message'\n };\n return c.json(response, 500);\n }\n});\n\nexport default chat;",[],[82,189,205],"c994dae2-3f44-11f0-8f0d-76b3cceeab13","database","c476fcc3-f031-4c13-932f-1afa518525f3",["D",1748822512071],[218,219],[82,213],{"_37":228,"_13":229,"_40":230,"_42":214,"_43":44,"_45":84,"_47":48,"_49":231,"_17":65,"_52":107,"_54":232,"_56":57,"_58":-5,"_93":233,"_18":234},{"_37":220,"_13":221,"_40":222,"_42":214,"_43":44,"_45":223,"_47":48,"_49":224,"_17":65,"_52":107,"_54":225,"_56":57,"_58":-5,"_93":226,"_18":227},"cfc692f2-3f44-11f0-8fb4-76b3cceeab13","queries.ts","cfc693ce-3f44-11f0-8fb4-76b3cceeab13",7,["D",1748822522462],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_MESSAGES_TABLE } from \"./migrations.ts\";\nimport type { Job, CreateJobRequest, ChatMessage, CreateChatMessageRequest } 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 getJobById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} \n WHERE id = ?\n `, [id]);\n \n return result.rows.length > 0 ? result.rows[0] as Job : null;\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${JOBS_TABLE} (\n title, company, description, requirements, location, salary, type, remote\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n jobData.title,\n jobData.company,\n jobData.description,\n jobData.requirements,\n jobData.location,\n jobData.salary || null,\n jobData.type,\n jobData.remote ? 1 : 0\n ]);\n\n const newJob = await getJobById(result.lastInsertRowId);\n if (!newJob) {\n throw new Error('Failed to create job');\n }\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_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 createChatMessage(messageData: CreateChatMessageRequest): Promise {\n const result = await sqlite.execute(`\n INSERT INTO ${CHAT_MESSAGES_TABLE} (username, message) \n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n const newMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_MESSAGES_TABLE} \n WHERE id = ?\n `, [result.lastInsertRowId]);\n\n if (newMessage.rows.length === 0) {\n throw new Error('Failed to create chat message');\n }\n\n return newMessage.rows[0] as ChatMessage;\n}",[],[82,213,221],"c994d25e-3f44-11f0-8f0d-76b3cceeab13","migrations.ts","c994d358-3f44-11f0-8f0d-76b3cceeab13",["D",1748822512071],"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 requirements TEXT NOT NULL,\n location TEXT NOT NULL,\n salary TEXT,\n type TEXT NOT NULL CHECK (type IN ('full-time', 'part-time', 'contract', 'internship')),\n remote BOOLEAN NOT NULL DEFAULT 0,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_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 successfully');\n}",[],[82,213,229],"58bfaa7c-3f44-11f0-bde5-76b3cceeab13",["D",1748822322775],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","3d964670-3f44-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","fdce5ee7-3223-4972-9952-0bdcd5b87e74","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_287":283},"org",{"_11":12,"_281":-5,"_282":283,"_244":245,"_284":285,"_286":57},"branch",{"_17":120,"_13":16,"_37":44,"_273":235,"_274":-5,"_275":-5,"_276":-5,"_277":-5,"_278":-5,"_279":14,"_280":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4dmN1bVlXQm1lSGVCSGRLc29uTWFPZnRHeiJ9","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":235,"_13":14,"_49":386,"_237":-5,"_238":57,"_239":240,"_241":240,"_242":-5,"_243":-5,"_244":245,"_246":119,"_247":48,"_248":48,"_249":-5,"_250":65,"_251":252,"_253":-5,"_254":-5,"_255":-5,"_256":-5,"_257":258,"_259":258,"_260":261,"_262":261,"_263":261,"_264":258,"_265":258,"_266":387,"_268":388,"_270":389,"_272":57},[326,334,342,344,345],"files",[326,327,328,329,330,331,332,333,334,335,336,337,338,339,340,341,342,343,344,345],"counts",{"_316":65,"_317":318,"_319":65,"_31":320,"_321":322},[306,307,308,309,310],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_37":81,"_13":82,"_40":83,"_42":-5,"_43":44,"_45":84,"_47":48,"_49":85,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":315},{"_37":75,"_13":76,"_40":77,"_42":-5,"_43":44,"_45":78,"_47":48,"_49":79,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":314},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":72,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":313},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_18":312},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":311},[39],[61],[69],[76],[82],"pulls","branches",1,"forks",{"_323":65,"_325":65},"connections",{"_323":65,"_324":65},"count","unfilledCount","emptyCount",{"_37":81,"_13":82,"_40":83,"_42":-5,"_43":44,"_45":84,"_47":48,"_49":174,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":384,"_18":385},{"_37":212,"_13":213,"_40":214,"_42":83,"_43":44,"_45":84,"_47":48,"_49":215,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":382,"_18":383},{"_37":228,"_13":229,"_40":230,"_42":214,"_43":44,"_45":84,"_47":48,"_49":231,"_17":65,"_52":107,"_54":232,"_56":57,"_58":-5,"_93":380,"_18":381},{"_37":220,"_13":221,"_40":222,"_42":214,"_43":44,"_45":223,"_47":48,"_49":224,"_17":65,"_52":107,"_54":225,"_56":57,"_58":-5,"_93":378,"_18":379},{"_37":188,"_13":189,"_40":190,"_42":83,"_43":44,"_45":191,"_47":48,"_49":192,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":376,"_18":377},{"_37":204,"_13":205,"_40":206,"_42":190,"_43":44,"_45":207,"_47":48,"_49":208,"_17":65,"_52":107,"_54":209,"_56":57,"_58":-5,"_93":374,"_18":375},{"_37":197,"_13":198,"_40":199,"_42":190,"_43":44,"_45":191,"_47":48,"_49":200,"_17":65,"_52":107,"_54":201,"_56":57,"_58":-5,"_93":372,"_18":373},{"_37":180,"_13":181,"_40":182,"_42":83,"_43":44,"_45":183,"_47":48,"_49":184,"_17":65,"_52":107,"_54":185,"_56":57,"_58":-5,"_93":370,"_18":371},{"_37":75,"_13":76,"_40":77,"_42":-5,"_43":44,"_45":78,"_47":48,"_49":111,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":368,"_18":369},{"_37":132,"_13":133,"_40":134,"_42":77,"_43":44,"_45":135,"_47":48,"_49":136,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":366,"_18":367},{"_37":167,"_13":168,"_40":169,"_42":134,"_43":44,"_45":135,"_47":48,"_49":170,"_17":65,"_52":107,"_54":171,"_56":57,"_58":-5,"_93":364,"_18":365},{"_37":159,"_13":160,"_40":161,"_42":134,"_43":44,"_45":162,"_47":48,"_49":163,"_17":65,"_52":107,"_54":164,"_56":57,"_58":-5,"_93":362,"_18":363},{"_37":151,"_13":152,"_40":153,"_42":134,"_43":44,"_45":154,"_47":48,"_49":155,"_17":65,"_52":107,"_54":156,"_56":57,"_58":-5,"_93":360,"_18":361},{"_37":143,"_13":144,"_40":145,"_42":134,"_43":44,"_45":146,"_47":48,"_49":147,"_17":65,"_52":107,"_54":148,"_56":57,"_58":-5,"_93":358,"_18":359},{"_37":125,"_13":126,"_40":127,"_42":77,"_43":44,"_45":78,"_47":48,"_49":128,"_17":65,"_52":24,"_54":129,"_56":57,"_58":-5,"_93":356,"_18":357},{"_37":117,"_13":118,"_40":119,"_42":77,"_43":44,"_45":120,"_47":48,"_49":121,"_17":51,"_52":53,"_54":122,"_56":57,"_58":-5,"_93":354,"_18":355},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":99,"_17":65,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":352,"_18":353},{"_37":103,"_13":104,"_40":105,"_42":70,"_43":44,"_45":71,"_47":48,"_49":106,"_17":65,"_52":107,"_54":108,"_56":57,"_58":-5,"_93":350,"_18":351},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":96,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_93":348,"_18":349},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":92,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_93":346,"_18":347},[],[39],[],[61],[],[69,104],[343],[69],[],[76,118],[],[76,126],[],[76,133,144],[],[76,133,152],[],[76,133,160],[],[76,133,168],[336,337,338,339],[76,133],[335,340,341],[76],[],[82,181],[],[82,189,198],[],[82,189,205],[331,332],[82,189],[],[82,213,221],[],[82,213,229],[328,329],[82,213],[327,330,333],[82],["D",1748822322775],{"_11":12,"_287":283},{"_11":12,"_281":-5,"_282":283,"_244":245,"_284":285,"_286":57},{"_17":120,"_13":16,"_37":44,"_273":235,"_274":-5,"_275":-5,"_276":-5,"_277":-5,"_278":-5,"_279":14,"_280":12},"ctx",{"_266":-5,"_303":423,"_424":425,"_426":427,"_428":57,"_429":57,"_430":57,"_431":48,"_432":-5,"_433":-7,"_434":-7,"_435":65,"_436":57,"_437":57,"_438":-5,"_439":57,"_440":57,"_441":57,"_442":-5},"ENV",{"_394":395,"_396":397,"_398":16,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414,"_415":416,"_417":418,"_419":420,"_421":422},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","a3e067d4463eea85f6334f8e583e8516ae58c4f6","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"]

Code