[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_239":240,"_241":242},"routes/_app.x.$handle.$name",{"_94":93,"_31":44,"_102":84,"_26":103,"_13":14,"_104":-5,"_11":105,"_106":107,"_108":109,"_110":111,"_112":113,"_20":-5,"_114":-5,"_115":-5,"_116":24,"_117":118,"_119":24,"_120":-5,"_121":-5,"_122":123},"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":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":24},"version",7,"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","backend/index.ts","latestPath","fileId","a1fa76e4-3fbd-11f0-96f1-76b3cceeab13","name","index.ts","fileType","script","content","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// 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;","createdAt",["D",1748874414734],"branchVersion","branchId","4eefeace-3fbd-11f0-9f87-76b3cceeab13","id","4eef7a58-3fbd-11f0-9f87-76b3cceeab13","Jobposting",["D",1748874275414],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","5d335530-3fae-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","87bce618-de29-462f-9a71-e210990e2b5c","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_94":93,"_101":97},"org",{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},"branch",{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","faithyz","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHg3S3JPSUx5UlNjNFFqQ2kzNm5pemQ2VkYifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":235,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":-5,"_52":-5,"_18":53,"_54":30,"_55":56,"_57":56,"_58":-5,"_59":60,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":236,"_78":237,"_80":238,"_82":24},"tree",[160,168,170],"files",[160,161,162,163,164,165,166,167,168,169,170],"counts",{"_150":60,"_151":131,"_152":60,"_153":154,"_155":156},"contents",[124,125,126],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_132":56,"_37":148,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":149},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":56,"_37":141,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_26":143},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":56,"_37":133,"_13":60,"_33":20,"_35":134,"_23":24,"_135":-5,"_26":136},"7af5cb2a-3fbd-11f0-8972-76b3cceeab13","README.md","7af5cbca-3fbd-11f0-8972-76b3cceeab13","parentId",1,"latest",["D",1748874349269],"# Job Posting Chat Platform\n\nA platform where users can view job postings and chat about them in real-time.\n\n## Features\n\n- View job postings\n- Real-time chat for each job posting\n- Simple, clean interface\n- No authentication required (anonymous chat)\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 endpoints\n│ │ └── chat.ts # Chat endpoints\n│ └── index.ts # Main Hono server\n├── frontend/\n│ ├── components/\n│ │ ├── App.tsx # Main app component\n│ │ ├── JobList.tsx # Job listings\n│ │ ├── JobDetail.tsx # Individual job view\n│ │ └── Chat.tsx # Chat component\n│ ├── index.html # Main HTML template\n│ └── index.tsx # Frontend entry point\n└── shared/\n └── types.ts # Shared TypeScript types\n```\n\n## Usage\n\n1. Visit the homepage to see all job postings\n2. Click on a job to view details and join the chat\n3. Chat messages are stored and displayed in real-time\n4. No registration required - just start chatting!","label",[128],"7f1753c2-3fbd-11f0-a966-76b3cceeab13","shared","767d0179-067a-499d-9782-c0a9d917bffc",2,["D",1748874356199],"directory",[138],"83c20b06-3fbd-11f0-966b-76b3cceeab13","backend","302a2e11-4b8a-4fb1-bfb8-126e7acfdf89",3,["D",1748874364027],[145],"pulls","branches","forks","envVars",{"_157":60,"_159":60},"connections",{"_157":60,"_158":60},"count","unfilledCount","emptyCount",{"_42":144,"_31":145,"_29":146,"_130":-5,"_40":41,"_39":147,"_132":56,"_37":232,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":233,"_26":234},{"_42":228,"_31":220,"_29":214,"_130":146,"_40":41,"_39":147,"_132":56,"_37":229,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":230,"_26":231},{"_42":221,"_31":222,"_29":223,"_130":214,"_40":41,"_39":147,"_132":56,"_37":224,"_13":60,"_33":34,"_35":225,"_23":24,"_135":-5,"_172":226,"_26":227},{"_42":211,"_31":212,"_29":213,"_130":214,"_40":41,"_39":215,"_132":56,"_37":216,"_13":60,"_33":34,"_35":217,"_23":24,"_135":-5,"_172":218,"_26":219},{"_42":207,"_31":198,"_29":192,"_130":146,"_40":41,"_39":193,"_132":56,"_37":208,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":209,"_26":210},{"_42":199,"_31":200,"_29":201,"_130":192,"_40":41,"_39":202,"_132":56,"_37":203,"_13":60,"_33":34,"_35":204,"_23":24,"_135":-5,"_172":205,"_26":206},{"_42":189,"_31":190,"_29":191,"_130":192,"_40":41,"_39":193,"_132":56,"_37":194,"_13":60,"_33":34,"_35":195,"_23":24,"_135":-5,"_172":196,"_26":197},{"_42":185,"_31":32,"_29":30,"_130":146,"_40":41,"_39":14,"_132":24,"_37":186,"_13":60,"_33":34,"_35":36,"_23":24,"_135":-5,"_172":187,"_26":188},{"_42":137,"_31":138,"_29":139,"_130":-5,"_40":41,"_39":140,"_132":56,"_37":182,"_13":60,"_33":142,"_35":-5,"_23":24,"_135":-5,"_172":183,"_26":184},{"_42":175,"_31":176,"_29":177,"_130":139,"_40":41,"_39":140,"_132":56,"_37":178,"_13":60,"_33":34,"_35":179,"_23":24,"_135":-5,"_172":180,"_26":181},{"_42":127,"_31":128,"_29":129,"_130":-5,"_40":41,"_39":131,"_132":56,"_37":171,"_13":60,"_33":20,"_35":134,"_23":24,"_135":-5,"_172":173,"_26":174},["D",1748874349269],"children",[],[128],"7f1738ec-3fbd-11f0-a966-76b3cceeab13","types.ts","7f1739be-3fbd-11f0-a966-76b3cceeab13",["D",1748874356199],"// Shared types for the job posting chat platform\n\nexport interface Job {\n id: number;\n title: string;\n company: string;\n location: string;\n description: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n posted_at: string;\n requirements: string[];\n}\n\nexport interface ChatMessage {\n id: number;\n job_id: number;\n username: string;\n message: string;\n timestamp: string;\n}\n\nexport interface CreateJobRequest {\n title: string;\n company: string;\n location: string;\n description: string;\n salary?: string;\n type: 'full-time' | 'part-time' | 'contract' | 'internship';\n requirements: string[];\n}\n\nexport interface CreateMessageRequest {\n job_id: number;\n username: string;\n message: string;\n}",[],[138,176],["D",1748874356199],[169],[138],"a1fa7612-3fbd-11f0-96f1-76b3cceeab13",["D",1748874414734],[],[145,32],"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;",[],[145,198,190],"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;",[],[145,198,200],"934f3dc8-3fbd-11f0-bfdd-76b3cceeab13",["D",1748874390122],[165,166],[145,198],"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}",[],[145,220,212],"database","83c201ec-3fbd-11f0-966b-76b3cceeab13","migrations.ts","83c20296-3fbd-11f0-966b-76b3cceeab13",["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 };",[],[145,220,222],"83c20c96-3fbd-11f0-966b-76b3cceeab13",["D",1748874364027],[162,163],[145,220],["D",1748874364027],[161,164,167],[145],["D",1748874275414],{"_94":93,"_101":97},{"_94":93,"_95":-5,"_96":97,"_18":53,"_98":99,"_100":24},{"_13":83,"_31":84,"_42":41,"_85":43,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":-5,"_91":44,"_92":93},"ctx",{"_76":-5,"_121":272,"_273":274,"_275":276,"_277":24,"_278":24,"_279":24,"_280":56,"_281":-5,"_282":-7,"_283":-7,"_284":60,"_285":24,"_286":24,"_287":-5,"_288":24,"_289":24,"_290":24,"_291":-5},"ENV",{"_243":244,"_245":246,"_247":84,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257,"_258":259,"_260":261,"_262":263,"_264":265,"_266":267,"_268":269,"_270":271},"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 · v7