[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_95":94,"_31":44,"_103":85,"_26":104,"_13":14,"_105":-5,"_11":106,"_107":108,"_109":110,"_111":112,"_113":114,"_20":-5,"_115":-5,"_116":-5,"_117":24,"_118":119,"_120":24,"_121":-5,"_122":-5,"_123":124},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":24},"version",10,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","frontend/components/JobBoard.tsx","latestPath","fileId","5f79382e-3fb7-11f0-a1b8-76b3cceeab13","name","JobBoard.tsx","fileType","script","content","/** @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';\nimport JobForm from './JobForm.tsx';\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 const result: ApiResponse<{ deleted: boolean }> = 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 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 useEffect(() => {\n fetchJobs();\n }, []);\n\n if (loading) {\n return (\n

Loading jobs...

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

\n {/* Header */}\n

Job Opportunities

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

\n setShowForm(!showForm)}\n className=\"bg-blue-600 text-white px-4 py-2 rounded-md 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 jobs posted yet

Be the first to post a job opportunity!

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

{job.title}

\n at\n {job.company}\n

\n \n

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

\n \n

{job.description}

\n \n

\n \n 📧 Apply Now\n \n {job.contact_email}\n

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

\n ))\n )}\n

\n );\n}","createdAt",["D",1748871726174],"branchVersion","branchId","0e32c124-3fb7-11f0-8003-76b3cceeab13","id","0e326f58-3fb7-11f0-8003-76b3cceeab13","Akeem",["D",1748871589821],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","fae138e0-3fb5-11f0-ad5b-814c56c8abb0","pinnedFileId","42ae328a-3fb7-11f0-9a8e-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","35addfec-5e03-40ea-b4fc-110c38383ad1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_95":94,"_102":98},"org",{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},"branch",{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Akeemtools","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eEUxZlBTS1BTaVhyQnZLWXR2bWxZTEFjdyJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":279,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":57,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":280,"_79":281,"_81":282,"_83":24},"tree",[168,176,181,183],"files",[168,169,170,171,172,173,174,175,176,177,178,179,180,181,182,183],"counts",{"_158":61,"_159":133,"_160":61,"_161":162,"_163":164},"contents",[125,126,127,128],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":156,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":157},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":150,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":151},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":143,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_26":145},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":135,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_26":138},"21324042-3fb7-11f0-a175-76b3cceeab13","README.md","2132410a-3fb7-11f0-a175-76b3cceeab13","parentId",1,"latest",["D",1748871621691],"# 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.","label",[130],"24efb26e-3fb7-11f0-a175-76b3cceeab13","shared","f064f20f-67f3-43e9-99c4-80fde6b235da",2,["D",1748871627939],"directory",[140],"48417090-3fb7-11f0-a6fa-76b3cceeab13","frontend","625dca99-a3a5-4089-aeb4-a70d07f23bdc",8,["D",1748871687214],[147],"296dd500-3fb7-11f0-8fea-76b3cceeab13","backend","e2ca777a-3d6e-4b3c-b161-292f9db9846f",3,["D",1748871635496],[153],"pulls","branches","forks","envVars",{"_165":61,"_167":61},"connections",{"_165":61,"_166":61},"count","unfilledCount","emptyCount",{"_42":152,"_31":153,"_29":154,"_132":-5,"_40":41,"_39":155,"_134":57,"_37":276,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":277,"_26":278},{"_42":272,"_31":264,"_29":258,"_132":154,"_40":41,"_39":155,"_134":57,"_37":273,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":274,"_26":275},{"_42":265,"_31":266,"_29":267,"_132":258,"_40":41,"_39":155,"_134":57,"_37":268,"_13":61,"_33":34,"_35":269,"_23":24,"_137":-5,"_185":270,"_26":271},{"_42":255,"_31":256,"_29":257,"_132":258,"_40":41,"_39":259,"_134":57,"_37":260,"_13":61,"_33":34,"_35":261,"_23":24,"_137":-5,"_185":262,"_26":263},{"_42":251,"_31":242,"_29":236,"_132":154,"_40":41,"_39":237,"_134":57,"_37":252,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":253,"_26":254},{"_42":243,"_31":244,"_29":245,"_132":236,"_40":41,"_39":246,"_134":57,"_37":247,"_13":61,"_33":34,"_35":248,"_23":24,"_137":-5,"_185":249,"_26":250},{"_42":233,"_31":234,"_29":235,"_132":236,"_40":41,"_39":237,"_134":57,"_37":238,"_13":61,"_33":34,"_35":239,"_23":24,"_137":-5,"_185":240,"_26":241},{"_42":226,"_31":227,"_29":55,"_132":154,"_40":41,"_39":228,"_134":24,"_37":229,"_13":61,"_33":34,"_35":230,"_23":24,"_137":-5,"_185":231,"_26":232},{"_42":146,"_31":147,"_29":148,"_132":-5,"_40":41,"_39":149,"_134":57,"_37":223,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":224,"_26":225},{"_42":219,"_31":210,"_29":206,"_132":148,"_40":41,"_39":214,"_134":57,"_37":220,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":221,"_26":222},{"_42":211,"_31":212,"_29":213,"_132":206,"_40":41,"_39":214,"_134":57,"_37":215,"_13":61,"_33":34,"_35":216,"_23":24,"_137":-5,"_185":217,"_26":218},{"_42":205,"_31":32,"_29":30,"_132":206,"_40":41,"_39":14,"_134":57,"_37":207,"_13":61,"_33":34,"_35":36,"_23":24,"_137":-5,"_185":208,"_26":209},{"_42":198,"_31":199,"_29":200,"_132":148,"_40":41,"_39":149,"_134":57,"_37":201,"_13":61,"_33":20,"_35":202,"_23":24,"_137":-5,"_185":203,"_26":204},{"_42":139,"_31":140,"_29":141,"_132":-5,"_40":41,"_39":142,"_134":57,"_37":195,"_13":61,"_33":144,"_35":-5,"_23":24,"_137":-5,"_185":196,"_26":197},{"_42":188,"_31":189,"_29":190,"_132":141,"_40":41,"_39":142,"_134":57,"_37":191,"_13":61,"_33":34,"_35":192,"_23":24,"_137":-5,"_185":193,"_26":194},{"_42":129,"_31":130,"_29":131,"_132":-5,"_40":41,"_39":133,"_134":57,"_37":184,"_13":61,"_33":20,"_35":136,"_23":24,"_137":-5,"_185":186,"_26":187},["D",1748871621691],"children",[],[130],"24efac9c-3fb7-11f0-a175-76b3cceeab13","types.ts","24efad50-3fb7-11f0-a175-76b3cceeab13",["D",1748871627939],"// 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}",[],[140,189],["D",1748871627939],[182],[140],"484164e2-3fb7-11f0-a6fa-76b3cceeab13","index.html","484165c8-3fb7-11f0-a6fa-76b3cceeab13",["D",1748871687214],"\n\n\n \n \n Job Board & Chat\n \n \n \n\n\n

\n \n \n\n",[],[147,199],"5f793770-3fb7-11f0-a1b8-76b3cceeab13","bf232657-ac6a-4bcb-a039-cdb391bf5fa5",["D",1748871726174],[],[147,210,32],"components","4f1abca0-3fb7-11f0-895c-76b3cceeab13","App.tsx","4f1abd86-3fb7-11f0-895c-76b3cceeab13",9,["D",1748871698712],"/** @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\nexport default function App() {\n const [activeTab, setActiveTab] = useState<'jobs' | 'chat'>('jobs');\n\n return (\n

\n {/* Header */}\n

💼 Job Board & Chat

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

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

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

\n );\n}",[],[147,210,212],"4f1ac768-3fb7-11f0-895c-76b3cceeab13",["D",1748871698712],[178,179],[147,210],["D",1748871687214],[177,180],[147],"42ae31ae-3fb7-11f0-9a8e-76b3cceeab13","index.ts",7,["D",1748871677861],"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 endpoint\napp.get(\"/health\", c => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\nexport default app;",[],[153,227],"3575d730-3fb7-11f0-8b38-76b3cceeab13","jobs.ts","3575d7e4-3fb7-11f0-8b38-76b3cceeab13","2b51992c-0ca1-48d6-ac78-b7fe51d6c511",5,["D",1748871655687],"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 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: \"Failed to fetch jobs\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create a 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 || \n !jobData.location || !jobData.salary || !jobData.contact_email) {\n const response: ApiResponse = {\n success: false,\n error: \"All fields are required\"\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: \"Failed to create job\"\n };\n return c.json(response, 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 const response: ApiResponse = {\n success: false,\n error: \"Invalid job ID\"\n };\n return c.json(response, 400);\n }\n\n const deleted = await deleteJob(id);\n if (!deleted) {\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<{ deleted: boolean }> = {\n success: true,\n data: { deleted: true }\n };\n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to delete job\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default jobs;",[],[153,242,234],"routes","3cf0bd2c-3fb7-11f0-a0d7-76b3cceeab13","chat.ts","3cf0bde0-3fb7-11f0-a0d7-76b3cceeab13",6,["D",1748871668240],"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 messages\nchat.get(\"/messages\", async (c) => {\n try {\n const messages = await getRecentMessages();\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: \"Failed to fetch messages\"\n };\n return c.json(response, 500);\n }\n});\n\n// Send a new message\nchat.post(\"/messages\", async (c) => {\n try {\n const messageData: CreateMessageRequest = await c.req.json();\n \n // Basic validation\n if (!messageData.username || !messageData.message) {\n const response: ApiResponse = {\n success: false,\n error: \"Username and message are required\"\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 > 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 createMessage(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: \"Failed to send message\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default chat;",[],[153,242,244],"3575e1d0-3fb7-11f0-8b38-76b3cceeab13",["D",1748871655687],[173,174],[153,242],"2eca7170-3fb7-11f0-939f-76b3cceeab13","queries.ts","2eca7260-3fb7-11f0-939f-76b3cceeab13","f1adbcf3-23bb-4181-a964-86b9b01da34f",4,["D",1748871644498],"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}",[],[153,264,256],"database","296dcc4a-3fb7-11f0-8fea-76b3cceeab13","migrations.ts","296dcd08-3fb7-11f0-8fea-76b3cceeab13",["D",1748871635496],"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}",[],[153,264,266],"296dd6ea-3fb7-11f0-8fea-76b3cceeab13",["D",1748871635496],[170,171],[153,264],["D",1748871635496],[169,172,175],[153],["D",1748871589821],{"_95":94,"_102":98},{"_95":94,"_96":-5,"_97":98,"_18":53,"_99":100,"_101":24},{"_13":84,"_31":85,"_42":41,"_86":43,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":-5,"_92":44,"_93":94},"ctx",{"_77":-5,"_122":316,"_317":318,"_319":320,"_321":24,"_322":24,"_323":24,"_324":57,"_325":-5,"_326":-7,"_327":-7,"_328":61,"_329":24,"_330":24,"_331":-5,"_332":24,"_333":24,"_334":24,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":85,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"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"]

Diff · v10