\n \n\n",[],[208,210],"cb8ac96e-3fbd-11f0-87d5-76b3cceeab13","JobList.tsx","cb8aca4a-3fbd-11f0-87d5-76b3cceeab13","76b8926b-da6b-4fc1-8cff-4c0b9bf6cb55",10,["D",1748874484464],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Job, CreateJobRequest } from \"../../shared/types.ts\";\n\ninterface JobListProps {\n jobs: Job[];\n onJobSelect: (job: Job) => void;\n onRefresh: () => void;\n}\n\nexport default function JobList({ jobs, onJobSelect, onRefresh }: JobListProps) {\n const [showCreateForm, setShowCreateForm] = useState(false);\n const [creating, setCreating] = useState(false);\n\n const handleCreateJob = async (event: React.FormEvent) => {\n event.preventDefault();\n setCreating(true);\n\n const formData = new FormData(event.currentTarget);\n const requirements = (formData.get('requirements') as string)\n .split('\\n')\n .map(req => req.trim())\n .filter(req => req.length > 0);\n\n const jobData: CreateJobRequest = {\n title: formData.get('title') as string,\n company: formData.get('company') as string,\n location: formData.get('location') as string,\n description: formData.get('description') as string,\n salary: formData.get('salary') as string || undefined,\n type: formData.get('type') as CreateJobRequest['type'],\n requirements\n };\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(jobData),\n });\n\n if (response.ok) {\n setShowCreateForm(false);\n onRefresh();\n (event.target as HTMLFormElement).reset();\n } else {\n const error = await response.json();\n alert(`Error creating job: ${error.error}`);\n }\n } catch (error) {\n console.error('Error creating job:', error);\n alert('Failed to create job');\n } finally {\n setCreating(false);\n }\n };\n\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'short',\n day: 'numeric'\n });\n };\n\n const getJobTypeBadgeClass = (type: string) => {\n return `job-type-badge job-type-${type}`;\n };\n\n return (\n

Available Jobs

Click on any job to view details and join the discussion

\n setShowCreateForm(!showCreateForm)}\n className=\"inline-flex items-center px-4 py-2 border border-transparent rounded-md shadow-sm text-sm font-medium text-white bg-blue-600 hover:bg-blue-700 focus:outline-none focus:ring-2 focus:ring-offset-2 focus:ring-blue-500\"\n >\n {showCreateForm ? 'Cancel' : '+ Post Job'}\n \n

\n\n {showCreateForm && (\n

Post a New Job

\n Job Title\n \n

\n Company\n \n

\n Location\n \n

\n Salary (Optional)\n \n

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

\n Description\n \n

\n Requirements (one per line)\n \n

\n setShowCreateForm(false)}\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 Cancel\n \n \n {creating ? 'Creating...' : 'Post Job'}\n \n

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

📋

No jobs posted yet

Be the first to post a job and start the conversation!

\n ) : (\n

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

{job.title}

{job.company}

\n \n {job.type}\n \n

\n \n

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

\n \n

{job.description}

\n \n

\n {job.requirements.slice(0, 3).map((req, index) => (\n \n {req}\n \n ))}\n {job.requirements.length > 3 && (\n \n +{job.requirements.length - 3} more\n \n )}\n

\n ))}\n

\n )}\n \n );\n}",[],[208,226,218],"components","d543c410-3fbd-11f0-9a75-76b3cceeab13","JobDetail.tsx","d543c4c4-3fbd-11f0-9a75-76b3cceeab13",11,["D",1748874500774],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { Job } from \"../../shared/types.ts\";\nimport Chat from \"./Chat.tsx\";\n\ninterface JobDetailProps {\n job: Job;\n onBack: () => void;\n}\n\nexport default function JobDetail({ job, onBack }: JobDetailProps) {\n const formatDate = (dateString: string) => {\n return new Date(dateString).toLocaleDateString('en-US', {\n year: 'numeric',\n month: 'long',\n day: 'numeric'\n });\n };\n\n const getJobTypeBadgeClass = (type: string) => {\n return `job-type-badge job-type-${type}`;\n };\n\n return (\n

\n {/* Job Header */}\n

{job.title}

{job.company}

\n \n {job.type}\n \n

\n \n

\n \n 📍\n {job.location}\n \n {job.salary && (\n \n 💰\n {job.salary}\n \n )}\n \n 📅\n Posted {formatDate(job.posted_at)}\n \n

\n\n {/* Job Content */}\n

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

Job Description

\n {job.description.split('\\n').map((paragraph, index) => (\n

{paragraph}

\n ))}\n

\n\n

Requirements

\n •\n {requirement}\n

\n\n {/* Chat Section */}\n

\n 💬 Discussion\n

\n Join the conversation about this job posting. Ask questions, share insights, or connect with other candidates.\n

\n \n

\n );\n}",[],[208,226,228],"e752c46c-3fbd-11f0-b697-76b3cceeab13","Chat.tsx","e752c534-3fbd-11f0-b697-76b3cceeab13",12,["D",1748874531074],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, useRef } from \"https://esm.sh/react@18.2.0\";\nimport type { ChatMessage, CreateMessageRequest } from \"../../shared/types.ts\";\n\ninterface ChatProps {\n jobId: number;\n}\n\nexport default function Chat({ jobId }: ChatProps) {\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 messagesEndRef = useRef(null);\n\n useEffect(() => {\n fetchMessages();\n \n // Set up polling for new messages every 3 seconds\n const interval = setInterval(fetchMessages, 3000);\n return () => clearInterval(interval);\n }, [jobId]);\n\n useEffect(() => {\n scrollToBottom();\n }, [messages]);\n\n useEffect(() => {\n // Get username from localStorage or generate a random one\n const savedUsername = localStorage.getItem('chat_username');\n if (savedUsername) {\n setUsername(savedUsername);\n } else {\n const randomUsername = `User${Math.floor(Math.random() * 1000)}`;\n setUsername(randomUsername);\n localStorage.setItem('chat_username', randomUsername);\n }\n }, []);\n\n const fetchMessages = async () => {\n try {\n const response = await fetch(`/api/chat/${jobId}`);\n if (response.ok) {\n const messagesData = await response.json();\n setMessages(messagesData);\n } else {\n console.error('Failed to fetch messages');\n }\n } catch (error) {\n console.error('Error fetching messages:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const scrollToBottom = () => {\n messagesEndRef.current?.scrollIntoView({ behavior: 'smooth' });\n };\n\n const handleSendMessage = async (event: React.FormEvent) => {\n event.preventDefault();\n \n if (!newMessage.trim() || !username.trim()) return;\n\n setSending(true);\n\n const messageData: CreateMessageRequest = {\n job_id: jobId,\n username: username.trim(),\n message: newMessage.trim()\n };\n\n try {\n const response = await fetch('/api/chat', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n body: JSON.stringify(messageData),\n });\n\n if (response.ok) {\n setNewMessage('');\n // Immediately fetch new messages to show the sent message\n await fetchMessages();\n } else {\n const error = await response.json();\n alert(`Error sending message: ${error.error}`);\n }\n } catch (error) {\n console.error('Error sending message:', error);\n alert('Failed to send message');\n } finally {\n setSending(false);\n }\n };\n\n const handleUsernameChange = (newUsername: string) => {\n setUsername(newUsername);\n localStorage.setItem('chat_username', newUsername);\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 messageDate = new Date(timestamp);\n const today = new Date();\n const yesterday = new Date(today);\n yesterday.setDate(yesterday.getDate() - 1);\n\n if (messageDate.toDateString() === today.toDateString()) {\n return 'Today';\n } else if (messageDate.toDateString() === yesterday.toDateString()) {\n return 'Yesterday';\n } else {\n return messageDate.toLocaleDateString('en-US', {\n month: 'short',\n day: 'numeric'\n });\n }\n };\n\n if (loading) {\n return (\n

Loading chat...

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

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

\n \n Your Name\n \n handleUsernameChange(e.target.value)}\n className=\"block w-full border-gray-300 rounded-md shadow-sm focus:ring-blue-500 focus:border-blue-500 sm:text-sm px-3 py-2 border\"\n placeholder=\"Enter your name\"\n maxLength={50}\n />\n

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

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

💬

No messages yet. Be the first to start the conversation!

\n ) : (\n

\n {messages.map((message, index) => {\n const showDate = index === 0 || \n formatDate(message.timestamp) !== formatDate(messages[index - 1].timestamp);\n \n return (\n

\n {showDate && (\n

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

\n )}\n

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

\n {message.message}\n

\n );\n })}\n

\n )}\n

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

\n );\n}",[],[208,226,236],"b42f9e48-3fbd-11f0-aa5d-76b3cceeab13","App.tsx","b42f9efc-3fbd-11f0-aa5d-76b3cceeab13",9,["D",1748874445274],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Job } from \"../../shared/types.ts\";\nimport JobList from \"./JobList.tsx\";\nimport JobDetail from \"./JobDetail.tsx\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__?: {\n jobs: Job[];\n };\n }\n}\n\nexport default function App() {\n const [jobs, setJobs] = useState([]);\n const [selectedJob, setSelectedJob] = useState(null);\n const [loading, setLoading] = useState(true);\n const [view, setView] = useState<'list' | 'detail'>('list');\n\n useEffect(() => {\n // Use initial data if available, otherwise fetch\n if (window.__INITIAL_DATA__?.jobs) {\n setJobs(window.__INITIAL_DATA__.jobs);\n setLoading(false);\n } else {\n fetchJobs();\n }\n }, []);\n\n const fetchJobs = async () => {\n try {\n const response = await fetch('/api/jobs');\n if (response.ok) {\n const jobsData = await response.json();\n setJobs(jobsData);\n } else {\n console.error('Failed to fetch jobs');\n }\n } catch (error) {\n console.error('Error fetching jobs:', error);\n } finally {\n setLoading(false);\n }\n };\n\n const handleJobSelect = (job: Job) => {\n setSelectedJob(job);\n setView('detail');\n };\n\n const handleBackToList = () => {\n setSelectedJob(null);\n setView('list');\n };\n\n const refreshJobs = () => {\n setLoading(true);\n fetchJobs();\n };\n\n if (loading) {\n return (\n

Loading jobs...

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

💼 Job Chat Platform

\n {view === 'detail' && (\n \n ← Back to Jobs\n \n )}\n

\n\n

\n {view === 'list' ? (\n \n ) : (\n selectedJob && (\n \n )\n )}\n

\n );\n}",[],[208,226,244],"b42faa6e-3fbd-11f0-aa5d-76b3cceeab13",["D",1748874445274],[176,177,178,179],[208,226],"aadb1b1a-3fbd-11f0-9f87-76b3cceeab13",["D",1748874429624],[175,180,181],[208],"f8e3700a-3fbd-11f0-8c4d-76b3cceeab13","index.ts","302a2e11-4b8a-4fb1-bfb8-126e7acfdf89",["D",1748874560539],"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { runMigrations } from \"./database/migrations.ts\";\nimport { getAllJobs } from \"./database/queries.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\nawait runMigrations();\n\n// Add sample data if no jobs exist\nconst existingJobs = await getAllJobs();\nif (existingJobs.length === 0) {\n const { createJob } = await import(\"./database/queries.ts\");\n \n const sampleJobs = [\n {\n title: \"Senior Frontend Developer\",\n company: \"TechFlow Inc\",\n location: \"San Francisco, CA\",\n description: \"We're looking for a senior frontend developer to join our growing team. You'll be working on cutting-edge web applications using React, TypeScript, and modern development tools. This is a great opportunity to work with a talented team and make a real impact on our products.\",\n salary: \"$140k - $180k\",\n type: \"full-time\" as const,\n requirements: [\n \"5+ years of React experience\",\n \"Strong TypeScript skills\",\n \"Experience with modern build tools\",\n \"Knowledge of testing frameworks\",\n \"Excellent communication skills\"\n ]\n },\n {\n title: \"Product Manager\",\n company: \"StartupXYZ\",\n location: \"Remote\",\n description: \"Join our fast-growing startup as a Product Manager! You'll be responsible for defining product strategy, working with engineering teams, and driving product development from conception to launch. We're looking for someone who thrives in a fast-paced environment.\",\n salary: \"$120k - $160k\",\n type: \"full-time\" as const,\n requirements: [\n \"3+ years of product management experience\",\n \"Experience with agile development\",\n \"Strong analytical skills\",\n \"Excellent stakeholder management\",\n \"Background in tech products\"\n ]\n },\n {\n title: \"UX/UI Designer\",\n company: \"Design Studio Pro\",\n location: \"New York, NY\",\n description: \"We're seeking a creative UX/UI Designer to help us create beautiful and intuitive user experiences. You'll work closely with our product and engineering teams to design user interfaces that delight our customers.\",\n type: \"contract\" as const,\n requirements: [\n \"Portfolio demonstrating UX/UI skills\",\n \"Proficiency in Figma and Adobe Creative Suite\",\n \"Understanding of user-centered design principles\",\n \"Experience with prototyping tools\",\n \"Strong presentation skills\"\n ]\n },\n {\n title: \"Data Science Intern\",\n company: \"Analytics Corp\",\n location: \"Boston, MA\",\n description: \"Great opportunity for a student or recent graduate to gain hands-on experience in data science. You'll work on real projects involving machine learning, data analysis, and visualization.\",\n salary: \"$25/hour\",\n type: \"internship\" as const,\n requirements: [\n \"Currently pursuing degree in Data Science, Statistics, or related field\",\n \"Knowledge of Python and pandas\",\n \"Familiarity with machine learning concepts\",\n \"Strong mathematical background\",\n \"Eagerness to learn and grow\"\n ]\n }\n ];\n\n for (const job of sampleJobs) {\n await createJob(job);\n }\n \n console.log('Sample jobs created');\n}\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 with initial data\napp.get(\"/\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial job data to avoid extra round-trips\n try {\n const initialJobs = await getAllJobs();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n \n return c.html(html);\n});\n\n// Catch-all for SPA routing\napp.get(\"*\", async c => {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n try {\n const initialJobs = await getAllJobs();\n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n \n return c.html(html);\n});\n\nexport default app.fetch;",[],[267,260],"backend","934f37a6-3fbd-11f0-bfdd-76b3cceeab13","jobs.ts","934f383c-3fbd-11f0-bfdd-76b3cceeab13","d5d37d87-3d17-4073-83f3-57aed15e533d",5,["D",1748874390122],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllJobs, getJobById, createJob } from \"../database/queries.ts\";\nimport type { CreateJobRequest } from \"../../shared/types.ts\";\n\nconst jobs = new Hono();\n\n// Get all jobs\njobs.get(\"/\", async (c) => {\n try {\n const allJobs = await getAllJobs();\n return c.json(allJobs);\n } catch (error) {\n console.error(\"Error fetching jobs:\", error);\n return c.json({ error: \"Failed to fetch jobs\" }, 500);\n }\n});\n\n// Get specific job by ID\njobs.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid job ID\" }, 400);\n }\n \n const job = await getJobById(id);\n if (!job) {\n return c.json({ error: \"Job not found\" }, 404);\n }\n \n return c.json(job);\n } catch (error) {\n console.error(\"Error fetching job:\", error);\n return c.json({ error: \"Failed to fetch job\" }, 500);\n }\n});\n\n// Create new job\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.location || !jobData.description) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (!['full-time', 'part-time', 'contract', 'internship'].includes(jobData.type)) {\n return c.json({ error: \"Invalid job type\" }, 400);\n }\n \n if (!Array.isArray(jobData.requirements)) {\n return c.json({ error: \"Requirements must be an array\" }, 400);\n }\n \n const newJob = await createJob(jobData);\n return c.json(newJob, 201);\n } catch (error) {\n console.error(\"Error creating job:\", error);\n return c.json({ error: \"Failed to create job\" }, 500);\n }\n});\n\nexport default jobs;",[],[267,277,269],"routes","9947139a-3fbd-11f0-8b35-76b3cceeab13","chat.ts","9947148a-3fbd-11f0-8b35-76b3cceeab13",6,["D",1748874399972],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getMessagesByJobId, createMessage } from \"../database/queries.ts\";\nimport type { CreateMessageRequest } from \"../../shared/types.ts\";\n\nconst chat = new Hono();\n\n// Get messages for a specific job\nchat.get(\"/:jobId\", async (c) => {\n try {\n const jobId = parseInt(c.req.param(\"jobId\"));\n if (isNaN(jobId)) {\n return c.json({ error: \"Invalid job ID\" }, 400);\n }\n \n const messages = await getMessagesByJobId(jobId);\n return c.json(messages);\n } catch (error) {\n console.error(\"Error fetching messages:\", error);\n return c.json({ error: \"Failed to fetch messages\" }, 500);\n }\n});\n\n// Post a new message\nchat.post(\"/\", async (c) => {\n try {\n const messageData: CreateMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.job_id || !messageData.username || !messageData.message) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n \n if (typeof messageData.job_id !== 'number') {\n return c.json({ error: \"job_id must be a number\" }, 400);\n }\n \n if (messageData.username.trim().length === 0) {\n return c.json({ error: \"Username cannot be empty\" }, 400);\n }\n \n if (messageData.message.trim().length === 0) {\n return c.json({ error: \"Message cannot be empty\" }, 400);\n }\n \n // Sanitize input\n const sanitizedMessage = {\n ...messageData,\n username: messageData.username.trim().slice(0, 50), // Limit username length\n message: messageData.message.trim().slice(0, 1000) // Limit message length\n };\n \n const newMessage = await createMessage(sanitizedMessage);\n return c.json(newMessage, 201);\n } catch (error) {\n console.error(\"Error creating message:\", error);\n return c.json({ error: \"Failed to create message\" }, 500);\n }\n});\n\nexport default chat;",[],[267,277,279],"934f3dc8-3fbd-11f0-bfdd-76b3cceeab13",["D",1748874390122],[171,172],[267,277],"8cabb672-3fbd-11f0-ae23-76b3cceeab13","queries.ts","8cabb712-3fbd-11f0-ae23-76b3cceeab13","26f02f60-e3b7-4e29-a7b2-4d4eadc83ba1",4,["D",1748874378984],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, MESSAGES_TABLE } from \"./migrations.ts\";\nimport type { Job, ChatMessage, CreateJobRequest, CreateMessageRequest } from \"../../shared/types.ts\";\n\n// Job queries\nexport async function getAllJobs(): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} ORDER BY posted_at DESC`);\n return result.rows.map(row => ({\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n }));\n}\n\nexport async function getJobById(id: number): Promise {\n const result = await sqlite.execute(`SELECT * FROM ${JOBS_TABLE} WHERE id = ?`, [id]);\n if (result.rows.length === 0) return null;\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n };\n}\n\nexport async function createJob(jobData: CreateJobRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${JOBS_TABLE} (title, company, location, description, salary, type, requirements) \n VALUES (?, ?, ?, ?, ?, ?, ?) RETURNING *`,\n [\n jobData.title,\n jobData.company,\n jobData.location,\n jobData.description,\n jobData.salary || null,\n jobData.type,\n JSON.stringify(jobData.requirements)\n ]\n );\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n title: row.title as string,\n company: row.company as string,\n location: row.location as string,\n description: row.description as string,\n salary: row.salary as string || undefined,\n type: row.type as Job['type'],\n posted_at: row.posted_at as string,\n requirements: JSON.parse(row.requirements as string)\n };\n}\n\n// Chat message queries\nexport async function getMessagesByJobId(jobId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${MESSAGES_TABLE} WHERE job_id = ? ORDER BY timestamp ASC`,\n [jobId]\n );\n \n return result.rows.map(row => ({\n id: row.id as number,\n job_id: row.job_id as number,\n username: row.username as string,\n message: row.message as string,\n timestamp: row.timestamp as string\n }));\n}\n\nexport async function createMessage(messageData: CreateMessageRequest): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${MESSAGES_TABLE} (job_id, username, message) \n VALUES (?, ?, ?) RETURNING *`,\n [messageData.job_id, messageData.username, messageData.message]\n );\n \n const row = result.rows[0];\n return {\n id: row.id as number,\n job_id: row.job_id as number,\n username: row.username as string,\n message: row.message as string,\n timestamp: row.timestamp as string\n };\n}",[],[267,299,291],"database","83c201ec-3fbd-11f0-966b-76b3cceeab13","migrations.ts","83c20296-3fbd-11f0-966b-76b3cceeab13",3,["D",1748874364027],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'job_postings_v1';\nconst MESSAGES_TABLE = 'chat_messages_v1';\n\nexport async function runMigrations() {\n // Create jobs table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${JOBS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n location TEXT NOT NULL,\n description TEXT NOT NULL,\n salary TEXT,\n type TEXT NOT NULL CHECK (type IN ('full-time', 'part-time', 'contract', 'internship')),\n requirements TEXT NOT NULL, -- JSON array of strings\n posted_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create chat messages table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${MESSAGES_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n job_id INTEGER NOT NULL,\n username TEXT NOT NULL,\n message TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (job_id) REFERENCES ${JOBS_TABLE} (id)\n )`);\n\n console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, MESSAGES_TABLE };",[],[267,299,301],"83c20c96-3fbd-11f0-966b-76b3cceeab13",["D",1748874364027],[168,169],[267,299],"83c20b06-3fbd-11f0-966b-76b3cceeab13",["D",1748874364027],[167,170,173],[267],["D",1748874275414],{"_11":12,"_121":70},{"_11":12,"_117":-5,"_69":70,"_31":68,"_118":119,"_120":30},{"_39":108,"_13":16,"_33":36,"_109":74,"_110":-5,"_111":-5,"_112":-5,"_113":-5,"_114":-5,"_115":14,"_116":12},"ctx",{"_52":-5,"_140":353,"_354":355,"_356":357,"_358":30,"_359":30,"_360":30,"_361":24,"_362":-5,"_363":-7,"_364":-7,"_365":26,"_366":30,"_367":30,"_368":-5,"_369":30,"_370":30,"_371":30,"_372":-5},"ENV",{"_324":325,"_326":327,"_328":16,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352},"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 · shared