\n \n\n",[],[102,120],"3e83fbea-3fb7-11f0-a0d7-76b3cceeab13","components","e8b36a7c-6f2d-4dc0-851e-2ea0c84674a2",10,["D",1748871670881],[133,134,135,136,137],[102,127],{"_35":170,"_13":171,"_38":172,"_40":128,"_42":43,"_44":129,"_46":47,"_48":173,"_17":50,"_51":52,"_53":174,"_55":56,"_57":-5,"_83":175,"_18":176},{"_35":162,"_13":163,"_38":164,"_40":128,"_42":43,"_44":165,"_46":47,"_48":166,"_17":50,"_51":52,"_53":167,"_55":56,"_57":-5,"_83":168,"_18":169},{"_35":154,"_13":155,"_38":156,"_40":128,"_42":43,"_44":157,"_46":47,"_48":158,"_17":50,"_51":52,"_53":159,"_55":56,"_57":-5,"_83":160,"_18":161},{"_35":146,"_13":147,"_38":148,"_40":128,"_42":43,"_44":149,"_46":47,"_48":150,"_17":50,"_51":52,"_53":151,"_55":56,"_57":-5,"_83":152,"_18":153},{"_35":138,"_13":139,"_38":140,"_40":128,"_42":43,"_44":141,"_46":47,"_48":142,"_17":50,"_51":52,"_53":143,"_55":56,"_57":-5,"_83":144,"_18":145},"79b6e6aa-3fb7-11f0-81b4-76b3cceeab13","JobForm.tsx","79b6e75e-3fb7-11f0-81b4-76b3cceeab13",13,["D",1748871770198],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CreateJobRequest } 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 location: '',\n type: 'full-time',\n salary_range: '',\n description: '',\n requirements: '',\n contact_email: '',\n expires_at: ''\n });\n\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [success, setSuccess] = useState(false);\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 const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n setLoading(true);\n setError(null);\n\n try {\n // Prepare data for submission\n const submitData = {\n ...formData,\n salary_range: formData.salary_range || undefined,\n expires_at: formData.expires_at || 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 if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to create job posting');\n }\n\n setSuccess(true);\n setTimeout(() => {\n onJobPosted();\n }, 2000);\n\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to create job posting');\n } finally {\n setLoading(false);\n }\n };\n\n if (success) {\n return (\n

🎉

Job Posted Successfully!

Your job posting is now live and visible to candidates.

Redirecting to job board...

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

Post a New Job

Share your IT opportunity with talented professionals

\n\n

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

\n ⚠️\n {error}\n

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

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

\n\n {/* Company and Location */}\n

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

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

\n\n {/* Job Type and Salary */}\n

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

\n \n Salary Range\n \n \n

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

\n \n Contact Email *\n \n \n

\n \n Expires On\n \n \n

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

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

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

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

\n\n {/* Submit Button */}\n

\n window.location.reload()}\n className=\"px-6 py-2 border border-gray-300 rounded-md text-gray-700 hover:bg-gray-50 transition-colors\"\n >\n Cancel\n \n \n {loading ? (\n \n

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

\n\n {/* Tips */}\n

💡 Tips for a Great Job Posting

• Be specific about the role and responsibilities
• Include both required and preferred qualifications
• Mention your company culture and benefits
• Use clear, inclusive language
• Provide a realistic salary range if possible

\n );\n}",[],[102,127,139],"48ec0564-3fb7-11f0-a9f3-76b3cceeab13","JobCard.tsx","48ec0604-3fb7-11f0-a9f3-76b3cceeab13",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}",[],[102,127,147],"5eadfe7a-3fb7-11f0-b1ac-76b3cceeab13","JobBoard.tsx","5eadff4c-3fb7-11f0-b1ac-76b3cceeab13",12,["D",1748871724845],"/** @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}",[],[102,127,155],"9968b2d0-3fb7-11f0-815a-76b3cceeab13","ChatRoom.tsx","9968b398-3fb7-11f0-815a-76b3cceeab13",14,["D",1748871823365],"/** @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\nexport default function ChatRoom() {\n const [messages, setMessages] = useState([]);\n const [newMessage, setNewMessage] = useState('');\n const [username, setUsername] = useState('');\n const [loading, setLoading] = useState(true);\n const [sending, setSending] = useState(false);\n const [error, setError] = useState(null);\n const [connected, setConnected] = useState(false);\n \n const messagesEndRef = useRef(null);\n const eventSourceRef = 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 // Save username to localStorage\n useEffect(() => {\n if (username) {\n localStorage.setItem('chat-username', username);\n }\n }, [username]);\n\n // Scroll to bottom when new messages arrive\n useEffect(() => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n }, [messages]);\n\n // Fetch initial messages\n const fetchMessages = async () => {\n try {\n setLoading(true);\n const response = await fetch('/api/chat/messages');\n if (!response.ok) throw new Error('Failed to fetch messages');\n \n const data = await response.json();\n setMessages(data);\n setError(null);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to load messages');\n } finally {\n setLoading(false);\n }\n };\n\n // Set up real-time updates with Server-Sent Events\n const setupEventSource = () => {\n if (eventSourceRef.current) {\n eventSourceRef.current.close();\n }\n\n const lastMessageTime = messages.length > 0 \n ? messages[messages.length - 1].timestamp \n : new Date(0).toISOString();\n\n const eventSource = new EventSource(`/api/chat/stream?since=${encodeURIComponent(lastMessageTime)}`);\n \n eventSource.onopen = () => {\n setConnected(true);\n setError(null);\n };\n\n eventSource.onmessage = (event) => {\n try {\n const data = JSON.parse(event.data);\n \n if (data.type === 'message') {\n setMessages(prev => {\n // Avoid duplicates\n const exists = prev.some(msg => msg.id === data.data.id);\n if (exists) return prev;\n return [...prev, data.data];\n });\n } else if (data.type === 'error') {\n setError(data.message);\n }\n } catch (err) {\n console.error('Error parsing SSE data:', err);\n }\n };\n\n eventSource.onerror = () => {\n setConnected(false);\n setError('Connection lost. Trying to reconnect...');\n \n // Retry connection after 3 seconds\n setTimeout(() => {\n setupEventSource();\n }, 3000);\n };\n\n eventSourceRef.current = eventSource;\n };\n\n // Initialize chat\n useEffect(() => {\n fetchMessages();\n }, []);\n\n // Set up real-time updates after initial load\n useEffect(() => {\n if (!loading && messages.length > 0) {\n setupEventSource();\n }\n\n return () => {\n if (eventSourceRef.current) {\n eventSourceRef.current.close();\n }\n };\n }, [loading, messages.length]);\n\n // Send message\n const sendMessage = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!newMessage.trim() || !username.trim()) return;\n\n setSending(true);\n try {\n const messageData: CreateMessageRequest = {\n username: username.trim(),\n message: newMessage.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 if (!response.ok) {\n const errorData = await response.json();\n throw new Error(errorData.error || 'Failed to send message');\n }\n\n setNewMessage('');\n setError(null);\n } catch (err) {\n setError(err instanceof Error ? err.message : 'Failed to send message');\n } finally {\n setSending(false);\n }\n };\n\n const formatTime = (timestamp: string) => {\n return new Date(timestamp).toLocaleTimeString('en-US', {\n hour: '2-digit',\n minute: '2-digit'\n });\n };\n\n const formatDate = (timestamp: string) => {\n const date = new Date(timestamp);\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', { month: 'short', day: 'numeric' });\n }\n };\n\n // Group messages by date\n const groupedMessages = messages.reduce((groups, message) => {\n const date = new Date(message.timestamp).toDateString();\n if (!groups[date]) {\n groups[date] = [];\n }\n groups[date].push(message);\n return groups;\n }, {} as Record);\n\n return (\n

Community Chat

Connect with fellow IT professionals and discuss opportunities

\n\n

\n {/* Connection Status */}\n

\n {connected ? 'Connected' : 'Connecting...'}\n {messages.length > 0 && (\n {messages.length} messages\n )}\n

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

\n ⚠️\n {error}\n \n Retry\n \n

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

\n {loading ? (\n

Loading messages...

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

💬

No messages yet

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].timestamp)}\n

\n \n {/* Messages for this date */}\n {dayMessages.map((message, index) => {\n const isOwnMessage = message.username === username;\n const showUsername = index === 0 || dayMessages[index - 1].username !== message.username;\n \n return (\n \n

\n {showUsername && (\n

\n {message.username}\n

\n )}\n \n

{message.message}

\n {formatTime(message.timestamp)}\n

\n );\n })}\n

\n ))}\n

\n )}\n

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

\n {/* Username Input */}\n {!username && (\n

\n setUsername(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 maxLength={50}\n />\n

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

\n setNewMessage(e.target.value)}\n disabled={!username || sending}\n className=\"flex-1 px-3 py-2 border border-gray-300 rounded-md focus:outline-none focus:ring-2 focus:ring-blue-500 disabled:bg-gray-100\"\n maxLength={500}\n />\n \n {sending ? (\n

\n ) : (\n '📤'\n )}\n \n

\n \n {/* Character Count */}\n

\n \n {username && `Chatting as ${username}`}\n {!username && (\n setUsername(`User${Math.floor(Math.random() * 1000)}`)}\n className=\"text-blue-600 hover:text-blue-800 underline\"\n >\n Use random name\n \n )}\n \n {newMessage.length}/500\n

\n\n {/* Chat Guidelines */}\n

💡 Chat Guidelines

• Keep discussions professional and respectful
• Share job opportunities, career advice, and industry insights
• No spam, self-promotion, or inappropriate content
• Be helpful and supportive to fellow community members

\n \n );\n}",[],[102,127,163],"3e83f460-3fb7-11f0-a0d7-76b3cceeab13","App.tsx","3e83f51e-3fb7-11f0-a0d7-76b3cceeab13",["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}",[],[102,127,171],"0c09bfc4-3fb7-11f0-9d66-76b3cceeab13",3,["D",1748871586191],[182,183,184],[59],{"_35":205,"_13":206,"_38":207,"_40":70,"_42":43,"_44":178,"_46":47,"_48":208,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":209,"_18":210},{"_35":68,"_13":60,"_38":41,"_40":70,"_42":43,"_44":45,"_46":47,"_48":194,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":195,"_18":196},{"_35":185,"_13":186,"_38":187,"_40":70,"_42":43,"_44":188,"_46":47,"_48":189,"_17":89,"_51":190,"_53":191,"_55":56,"_57":-5,"_83":192,"_18":193},"a2d688a6-3fb7-11f0-8b9c-76b3cceeab13","index.ts","2c8c9258-3fb7-11f0-9480-76b3cceeab13",16,["D",1748871839193],"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 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\n// This is the entry point for HTTP vals\nexport default app.fetch;",[],[59,186],["D",1748871615948],[197,198],[59,60],{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":202,"_17":50,"_51":52,"_53":66,"_55":56,"_57":-5,"_83":203,"_18":204},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":199,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":200,"_18":201},["D",1748871615948],[],[59,60,37],["D",1748871630247],[],[59,60,62],"0c09c1d6-3fb7-11f0-9d66-76b3cceeab13","database","203de2c1-d941-457c-81d0-2d47e5a30a07",["D",1748871586191],[211,212],[59,206],{"_35":221,"_13":222,"_38":223,"_40":207,"_42":43,"_44":178,"_46":47,"_48":224,"_17":50,"_51":52,"_53":225,"_55":56,"_57":-5,"_83":226,"_18":227},{"_35":213,"_13":214,"_38":215,"_40":207,"_42":43,"_44":216,"_46":47,"_48":217,"_17":50,"_51":52,"_53":218,"_55":56,"_57":-5,"_83":219,"_18":220},"15bd4b58-3fb7-11f0-861e-76b3cceeab13","queries.ts","15bd4c16-3fb7-11f0-861e-76b3cceeab13",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}",[],[59,206,214],"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 };",[],[59,206,222],"f01ad88e-3fb6-11f0-a0c3-76b3cceeab13",["D",1748871539335],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","ab434b70-3fb5-11f0-b6e9-ab0b2f88b858","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","fd36482f-5e2f-4625-98a8-542f43351351","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_280":276},"org",{"_11":12,"_274":-5,"_275":276,"_237":238,"_277":278,"_279":56},"branch",{"_17":188,"_13":16,"_35":43,"_266":228,"_267":-5,"_268":-5,"_269":-5,"_270":-5,"_271":-5,"_272":14,"_273":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHhEaVFqc1NscUVUZ3I4V0JUWnNFTDZFU24ifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_35":228,"_13":14,"_48":375,"_230":-5,"_231":56,"_232":233,"_234":233,"_235":-5,"_236":-5,"_237":238,"_239":187,"_240":47,"_241":47,"_242":-5,"_243":50,"_244":245,"_246":-5,"_247":-5,"_248":-5,"_249":-5,"_250":251,"_252":251,"_253":254,"_255":254,"_256":254,"_257":251,"_258":251,"_259":376,"_261":377,"_263":378,"_265":56},[315,323,332,334],"files",[315,316,317,318,319,320,321,322,323,324,325,326,327,328,329,330,331,332,333,334],"counts",{"_306":50,"_307":80,"_308":50,"_32":309,"_310":311},[302,303],{"_35":68,"_13":60,"_38":41,"_40":70,"_42":43,"_44":45,"_46":47,"_48":300,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_18":301},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1748871615948],[59,60],{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":65,"_17":50,"_51":52,"_53":66,"_55":56,"_57":-5,"_18":305},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_18":304},[59,60,37],[59,60,62],"pulls","branches","forks",{"_312":50,"_314":50},"connections",{"_312":50,"_313":50},"count","unfilledCount","emptyCount",{"_35":177,"_13":59,"_38":70,"_40":-5,"_42":43,"_44":178,"_46":47,"_48":179,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":373,"_18":374},{"_35":205,"_13":206,"_38":207,"_40":70,"_42":43,"_44":178,"_46":47,"_48":208,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":371,"_18":372},{"_35":221,"_13":222,"_38":223,"_40":207,"_42":43,"_44":178,"_46":47,"_48":224,"_17":50,"_51":52,"_53":225,"_55":56,"_57":-5,"_83":369,"_18":370},{"_35":213,"_13":214,"_38":215,"_40":207,"_42":43,"_44":216,"_46":47,"_48":217,"_17":50,"_51":52,"_53":218,"_55":56,"_57":-5,"_83":367,"_18":368},{"_35":68,"_13":60,"_38":41,"_40":70,"_42":43,"_44":45,"_46":47,"_48":194,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":365,"_18":366},{"_35":61,"_13":62,"_38":63,"_40":41,"_42":43,"_44":64,"_46":47,"_48":202,"_17":50,"_51":52,"_53":66,"_55":56,"_57":-5,"_83":363,"_18":364},{"_35":36,"_13":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":199,"_17":50,"_51":52,"_53":54,"_55":56,"_57":-5,"_83":361,"_18":362},{"_35":185,"_13":186,"_38":187,"_40":70,"_42":43,"_44":188,"_46":47,"_48":189,"_17":89,"_51":190,"_53":191,"_55":56,"_57":-5,"_83":359,"_18":360},{"_35":101,"_13":102,"_38":103,"_40":-5,"_42":43,"_44":104,"_46":47,"_48":105,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":357,"_18":358},{"_35":126,"_13":127,"_38":128,"_40":103,"_42":43,"_44":129,"_46":47,"_48":130,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":355,"_18":356},{"_35":170,"_13":171,"_38":172,"_40":128,"_42":43,"_44":129,"_46":47,"_48":173,"_17":50,"_51":52,"_53":174,"_55":56,"_57":-5,"_83":353,"_18":354},{"_35":162,"_13":163,"_38":164,"_40":128,"_42":43,"_44":165,"_46":47,"_48":166,"_17":50,"_51":52,"_53":167,"_55":56,"_57":-5,"_83":351,"_18":352},{"_35":154,"_13":155,"_38":156,"_40":128,"_42":43,"_44":157,"_46":47,"_48":158,"_17":50,"_51":52,"_53":159,"_55":56,"_57":-5,"_83":349,"_18":350},{"_35":146,"_13":147,"_38":148,"_40":128,"_42":43,"_44":149,"_46":47,"_48":150,"_17":50,"_51":52,"_53":151,"_55":56,"_57":-5,"_83":347,"_18":348},{"_35":138,"_13":139,"_38":140,"_40":128,"_42":43,"_44":141,"_46":47,"_48":142,"_17":50,"_51":52,"_53":143,"_55":56,"_57":-5,"_83":345,"_18":346},{"_35":119,"_13":120,"_38":121,"_40":103,"_42":43,"_44":104,"_46":47,"_48":122,"_17":50,"_51":24,"_53":123,"_55":56,"_57":-5,"_83":343,"_18":344},{"_35":111,"_13":112,"_38":113,"_40":103,"_42":43,"_44":114,"_46":47,"_48":115,"_17":50,"_51":52,"_53":116,"_55":56,"_57":-5,"_83":341,"_18":342},{"_35":86,"_13":87,"_38":88,"_40":-5,"_42":43,"_44":89,"_46":47,"_48":90,"_17":50,"_51":69,"_53":-5,"_55":56,"_57":-5,"_83":339,"_18":340},{"_35":94,"_13":95,"_38":96,"_40":88,"_42":43,"_44":89,"_46":47,"_48":97,"_17":50,"_51":52,"_53":98,"_55":56,"_57":-5,"_83":337,"_18":338},{"_35":77,"_13":78,"_38":79,"_40":-5,"_42":43,"_44":80,"_46":47,"_48":81,"_17":50,"_51":24,"_53":82,"_55":56,"_57":-5,"_83":335,"_18":336},[],[78],[],[87,95],[333],[87],[],[102,112],[],[102,120],[],[102,127,139],[],[102,127,147],[],[102,127,155],[],[102,127,163],[],[102,127,171],[325,326,327,328,329],[102,127],[324,330,331],[102],[],[59,186],[],[59,60,37],[],[59,60,62],[320,321],[59,60],[],[59,206,214],[],[59,206,222],[317,318],[59,206],[316,319,322],[59],["D",1748871539335],{"_11":12,"_280":276},{"_11":12,"_274":-5,"_275":276,"_237":238,"_277":278,"_279":56},{"_17":188,"_13":16,"_35":43,"_266":228,"_267":-5,"_268":-5,"_269":-5,"_270":-5,"_271":-5,"_272":14,"_273":12},"ctx",{"_259":-5,"_297":412,"_413":414,"_415":416,"_417":56,"_418":56,"_419":56,"_420":47,"_421":-5,"_422":-7,"_423":-7,"_424":50,"_425":56,"_426":56,"_427":-5,"_428":56,"_429":56,"_430":56,"_431":-5},"ENV",{"_383":384,"_385":386,"_387":16,"_388":389,"_390":391,"_392":393,"_394":395,"_396":397,"_398":399,"_400":401,"_402":403,"_404":405,"_406":407,"_408":409,"_410":411},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e8c4b7030cb7600e4eb0736b15f422c8b8bd130f","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"]