[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_226":227,"_228":229},"routes/_app.x.$handle.$name",{"_102":101,"_32":51,"_110":92,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_21":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":25,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_49":50,"_32":51,"_37":52,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",5,"changes",[19,20],"aiChatInfo","userId",{"_21":42,"_23":-7,"_24":25,"_26":25,"_27":43,"_29":43},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":-5,"_37":38,"_39":14,"_40":41,"_24":25},"previous","deleted",false,"deletedHere","path","backend/routes","latestPath","fileId","c295fc04-ed6f-4796-ac85-c37fff6da112","name","routes","fileType","directory","content","createdAt",["D",1748874023404],"branchVersion","branchId","8618f974-3fbc-11f0-a8c7-76b3cceeab13",{"_30":44,"_32":45,"_34":46,"_36":47,"_37":48,"_39":14,"_40":41,"_24":25},"backend/routes/jobs.ts","b8ba7f4c-3fbc-11f0-bcb4-76b3cceeab13","jobs.ts","script","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 return c.json({\n success: true,\n data: jobList\n } as ApiResponse);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to fetch jobs\"\n } as ApiResponse, 500);\n }\n});\n\n// Create a new job\njobs.post(\"/\", async (c) => {\n try {\n const jobData = await c.req.json() as CreateJobRequest;\n \n // Basic validation\n if (!jobData.title || !jobData.company || !jobData.description || \n !jobData.location || !jobData.salary || !jobData.contact_email) {\n return c.json({\n success: false,\n error: \"All fields are required\"\n } as ApiResponse, 400);\n }\n\n // Validate email format\n const emailRegex = /^[^\\s@]+@[^\\s@]+\\.[^\\s@]+$/;\n if (!emailRegex.test(jobData.contact_email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n } as ApiResponse, 400);\n }\n\n const newJob = await createJob(jobData);\n return c.json({\n success: true,\n data: newJob\n } as ApiResponse, 201);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to create job\"\n } as ApiResponse, 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 return c.json({\n success: false,\n error: \"Invalid job ID\"\n } as ApiResponse, 400);\n }\n\n const deleted = await deleteJob(id);\n if (!deleted) {\n return c.json({\n success: false,\n error: \"Job not found\"\n } as ApiResponse, 404);\n }\n\n return c.json({\n success: true,\n data: { id }\n } as ApiResponse<{ id: number }>);\n } catch (error) {\n return c.json({\n success: false,\n error: \"Failed to delete job\"\n } as ApiResponse, 500);\n }\n});\n\nexport default jobs;",["D",1748874023404],"id","861883e0-3fbc-11f0-a8c7-76b3cceeab13","Test",["D",1748873938460],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","3ea53940-3fa3-11f0-b6e9-ab0b2f88b858","pinnedFileId","c6a7a4f4-3fbc-11f0-83b4-76b3cceeab13","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","4053117a-9429-4db4-aaa3-e410f34322c7","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_109":105},"org",{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},"branch",{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"isOwned",15,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","Alashakawee","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHd4akd5bjl5MUlETjhrTEl2YUMxQmpWM3oifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_49":50,"_32":51,"_37":222,"_53":-5,"_54":25,"_55":56,"_57":56,"_58":-5,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":64,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":223,"_86":224,"_88":225,"_90":25},"tree",[167,173,175],"files",[167,168,169,170,171,172,173,174,175],"counts",{"_157":68,"_158":139,"_159":68,"_160":161,"_162":163},"contents",[132,133,134],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_49":151,"_32":152,"_30":153,"_138":-5,"_40":41,"_39":154,"_140":64,"_37":155,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_27":156},{"_49":145,"_32":146,"_30":147,"_138":-5,"_40":41,"_39":148,"_140":64,"_37":149,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_27":150},{"_49":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":64,"_37":141,"_13":68,"_34":21,"_36":142,"_24":25,"_143":-5,"_27":144},"92ee8efc-3fbc-11f0-9f9e-76b3cceeab13","README.md","92ee8fc4-3fbc-11f0-9f9e-76b3cceeab13","parentId",1,"latest",["D",1748873959989],"# 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",[136],"a739e014-3fbc-11f0-aa5b-76b3cceeab13","shared","0b87d2d5-4b88-4b12-a5bb-2e374f4aa6cf",2,["D",1748873994037],[146],"ab91be52-3fbc-11f0-bf6d-76b3cceeab13","backend","57babc71-0200-4a22-baa1-c60a85ad96dc",3,["D",1748874001324],[152],"pulls","branches","forks","envVars",{"_164":68,"_166":68},"connections",{"_164":68,"_165":68},"count","unfilledCount","emptyCount",{"_49":151,"_32":152,"_30":153,"_138":-5,"_40":41,"_39":154,"_140":64,"_37":219,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_177":220,"_27":221},{"_49":215,"_32":207,"_30":201,"_138":153,"_40":41,"_39":154,"_140":64,"_37":216,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_177":217,"_27":218},{"_49":208,"_32":209,"_30":210,"_138":201,"_40":41,"_39":154,"_140":64,"_37":211,"_13":68,"_34":46,"_36":212,"_24":25,"_143":-5,"_177":213,"_27":214},{"_49":198,"_32":199,"_30":200,"_138":201,"_40":41,"_39":202,"_140":64,"_37":203,"_13":68,"_34":46,"_36":204,"_24":25,"_143":-5,"_177":205,"_27":206},{"_49":194,"_32":33,"_30":31,"_138":153,"_40":41,"_39":14,"_140":64,"_37":195,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_177":196,"_27":197},{"_49":190,"_32":45,"_30":44,"_138":31,"_40":41,"_39":14,"_140":64,"_37":191,"_13":68,"_34":46,"_36":47,"_24":25,"_143":-5,"_177":192,"_27":193},{"_49":145,"_32":146,"_30":147,"_138":-5,"_40":41,"_39":148,"_140":64,"_37":187,"_13":68,"_34":35,"_36":-5,"_24":25,"_143":-5,"_177":188,"_27":189},{"_49":180,"_32":181,"_30":182,"_138":147,"_40":41,"_39":148,"_140":64,"_37":183,"_13":68,"_34":46,"_36":184,"_24":25,"_143":-5,"_177":185,"_27":186},{"_49":135,"_32":136,"_30":137,"_138":-5,"_40":41,"_39":139,"_140":64,"_37":176,"_13":68,"_34":21,"_36":142,"_24":25,"_143":-5,"_177":178,"_27":179},["D",1748873959989],"children",[],[136],"a739da4c-3fbc-11f0-aa5b-76b3cceeab13","types.ts","a739db14-3fbc-11f0-aa5b-76b3cceeab13",["D",1748873994037],"// Shared TypeScript types for the Job Board & Chat App\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}",[],[146,181],["D",1748873994037],[174],[146],"b8ba7eac-3fbc-11f0-bcb4-76b3cceeab13",["D",1748874023404],[],[152,33,45],"b8ba84c4-3fbc-11f0-bcb4-76b3cceeab13",["D",1748874023404],[172],[152,33],"b1872806-3fbc-11f0-98b3-76b3cceeab13","queries.ts","b18728ba-3fbc-11f0-98b3-76b3cceeab13","9df0d22e-2792-48a5-bea6-ac59ae4adde9",4,["D",1748874011323],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { JOBS_TABLE, CHAT_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 const insertId = result.lastInsertRowId;\n \n const newJob = await sqlite.execute(`\n SELECT * FROM ${JOBS_TABLE} WHERE id = ?\n `, [insertId]);\n\n return newJob.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_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_TABLE} (username, message)\n VALUES (?, ?)\n `, [messageData.username, messageData.message]);\n\n const insertId = result.lastInsertRowId;\n \n const newMessage = await sqlite.execute(`\n SELECT * FROM ${CHAT_TABLE} WHERE id = ?\n `, [insertId]);\n\n return newMessage.rows[0] as ChatMessage;\n}",[],[152,207,199],"database","ab91b2fe-3fbc-11f0-bf6d-76b3cceeab13","migrations.ts","ab91b3d0-3fbc-11f0-bf6d-76b3cceeab13",["D",1748874001324],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst JOBS_TABLE = 'job_board_jobs_v1';\nconst CHAT_TABLE = 'job_board_chat_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 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 // Create chat messages table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${CHAT_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 console.log('Database migrations completed');\n}\n\nexport { JOBS_TABLE, CHAT_TABLE };",[],[152,207,209],"ab91c528-3fbc-11f0-bf6d-76b3cceeab13",["D",1748874001324],[169,170],[152,207],["D",1748874001324],[168,171],[152],["D",1748873938460],{"_102":101,"_109":105},{"_102":101,"_103":-5,"_104":105,"_18":60,"_106":107,"_108":25},{"_13":91,"_32":92,"_49":41,"_93":50,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":51,"_100":101},"ctx",{"_84":-5,"_129":259,"_260":261,"_262":263,"_264":25,"_265":25,"_266":25,"_267":64,"_268":-5,"_269":-7,"_270":-7,"_271":68,"_272":25,"_273":25,"_274":-5,"_275":25,"_276":25,"_277":25,"_278":-5},"ENV",{"_230":231,"_232":233,"_234":92,"_235":236,"_237":238,"_239":240,"_241":242,"_243":244,"_245":246,"_247":248,"_249":250,"_251":252,"_253":254,"_255":256,"_257":258},"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 · v5