\n {isUsernameModalOpen && (\n

Choose Your Username

\n )}\n\n

🚀 NaijaJobConnect

\n {username && (\n \n 👤 {username}\n \n )}\n \n

\n\n {/* Rest of the existing component remains the same */}\n {/* Job Posting Section, Job Listings, Chat Room sections are unchanged */}\n {/* Only modifications are in the existing code related to username */}\n\n \n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function server(request: Request): Promise {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = \"NaijaHandleFinder\";\n const SCHEMA_VERSION = 3; // Increment schema version due to username changes\n\n // Updated tables to ensure username is part of job and chat records\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_jobs_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n username TEXT NOT NULL,\n title TEXT NOT NULL,\n company TEXT NOT NULL,\n description TEXT NOT NULL,\n location TEXT,\n salary TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_chat_${SCHEMA_VERSION} (\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 // Handle different routes\n if (request.method === 'GET') {\n const url = new URL(request.url);\n \n if (url.pathname === '/jobs') {\n const jobs = await sqlite.execute(`\n SELECT * FROM ${KEY}_jobs_${SCHEMA_VERSION} \n ORDER BY created_at DESC \n LIMIT 20\n `);\n return new Response(JSON.stringify(jobs.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n if (url.pathname === '/chat') {\n const messages = await sqlite.execute(`\n SELECT * FROM ${KEY}_chat_${SCHEMA_VERSION} \n ORDER BY created_at DESC \n LIMIT 50\n `);\n return new Response(JSON.stringify(messages.rows), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n }\n\n if (request.method === 'POST') {\n const body = await request.json();\n const url = new URL(request.url);\n\n if (url.pathname === '/jobs') {\n await sqlite.execute(`\n INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} \n (username, title, company, description, location, salary) \n VALUES (?, ?, ?, ?, ?, ?)\n `, [\n body.username,\n body.title, \n body.company, \n body.description, \n body.location, \n body.salary\n ]);\n return new Response('Job posted successfully', { status: 200 });\n }\n\n if (url.pathname === '/chat') {\n await sqlite.execute(`\n INSERT INTO ${KEY}_chat_${SCHEMA_VERSION} \n (username, message) \n VALUES (?, ?)\n `, [\n body.username,\n body.message\n ]);\n return new Response('Message sent successfully', { status: 200 });\n }\n }\n\n // Serve the main HTML\n return new Response(`\n \n \n NaijaJobConnect\n \n \n \n \n

\n \n \n \n \n `, {\n headers: { \n \"content-type\": \"text/html\",\n \"X-Privacy-Notice\": \"Compliant with NDPA and data protection guidelines\"\n }\n });\n}","deleted","label",[98],"permalink","https://www.val.town/x/StanleyAkegbeotu/NaijaHandleFinder/code/main.tsx","extension","actionData","errors"]