Persistent Job Board

\n {userId ? (\n // Existing app content\n <>\n {/* Existing JSX remains the same */}\n

\n ✅ Logged in as User {userId}\n

\n \n ) : (\n

Loading... Please wait

\n )}\n

\n );\n}\n\n// Rest of the client-side code remains the same\n\nexport default async function server(request: Request): Promise {\n try {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const KEY = new URL(import.meta.url).pathname.split(\"/\").at(-1);\n const SCHEMA_VERSION = 12; // Incrementing for user-specific data\n\n // Enhanced table creation with user-specific tables\n const createTablesWithRetry = async () => {\n const tableCreationQueries = [\n // Existing job, message, and applicant tables\n {\n name: 'users',\n query: `CREATE TABLE IF NOT EXISTS ${KEY}_users_${SCHEMA_VERSION} (\n id TEXT PRIMARY KEY,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`\n },\n {\n name: 'user_data',\n query: `CREATE TABLE IF NOT EXISTS ${KEY}_user_data_${SCHEMA_VERSION} (\n user_id TEXT NOT NULL,\n data_key TEXT NOT NULL,\n data_value TEXT NOT NULL,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n PRIMARY KEY (user_id, data_key)\n )`\n }\n ];\n\n // Existing table creation logic\n // ... (keep the previous implementation)\n };\n\n // New authentication route\n if (request.method === 'POST' && new URL(request.url).pathname === '/auth') {\n try {\n // Generate or retrieve user ID\n const userId = crypto.randomUUID(); // Generates a unique identifier\n \n // Store user in database\n await sqlite.execute(\n `INSERT OR IGNORE INTO ${KEY}_users_${SCHEMA_VERSION} (id) VALUES (?)`,\n [userId]\n );\n\n return new Response(JSON.stringify({ userId }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (authError) {\n console.error('Authentication error:', authError);\n return new Response(JSON.stringify({ error: 'Authentication failed' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Data saving route\n if (request.method === 'POST' && new URL(request.url).pathname === '/save-data') {\n try {\n const { userId, key, value } = await request.json();\n \n // Upsert user data\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${KEY}_user_data_${SCHEMA_VERSION} \n (user_id, data_key, data_value) VALUES (?, ?, ?)`,\n [userId, key, value]\n );\n\n return new Response(JSON.stringify({ success: true }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (saveError) {\n console.error('Data save error:', saveError);\n return new Response(JSON.stringify({ error: 'Failed to save data' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Data retrieval route\n if (request.method === 'GET' && new URL(request.url).pathname === '/data') {\n try {\n const url = new URL(request.url);\n const userId = url.searchParams.get('userId');\n const key = url.searchParams.get('key');\n\n const result = await sqlite.execute(\n `SELECT data_value FROM ${KEY}_user_data_${SCHEMA_VERSION} \n WHERE user_id = ? AND data_key = ?`,\n [userId, key]\n );\n\n if (result.rows.length > 0) {\n return new Response(JSON.stringify({ \n value: result.rows[0].data_value \n }), {\n headers: { 'Content-Type': 'application/json' }\n });\n }\n\n return new Response(JSON.stringify({ value: null }), {\n headers: { 'Content-Type': 'application/json' }\n });\n } catch (retrieveError) {\n console.error('Data retrieval error:', retrieveError);\n return new Response(JSON.stringify({ error: 'Failed to retrieve data' }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n }\n\n // Existing routes for jobs, messages, and applications\n // ... (keep previous route handlers)\n\n return new Response(`\n \n \n Persistent Job Board\n \n \n \n

\n \n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n } catch (globalError) {\n console.error('Global server error:', globalError);\n return new Response(JSON.stringify({ \n error: 'Unexpected server error', \n details: globalError.toString() \n }), { \n status: 500,\n headers: { 'Content-Type': 'application/json' } \n });\n }\n}\n\n// CSS remains the same as in the previous implementation\nconst css = `\n /* Previous CSS remains unchanged */\n`;","createdAt",["D",1739852383452],"version",15,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","Marcyatieno","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ0OXZ1Q1hFeG9ROTJGSkRJTzlJczcwYXRHbCJ9","forkedVal","interval","slug","Marcyatieno/jobPostingApp","description","@jsxImportSource https://esm.sh/react@18.2.0","versions",[142,145,149,153,157,161,165,169,173,177,181,185,189,193,196,199],{"_118":119,"_143":-5,"_116":144,"_113":111},"prId",["D",1739852383452],{"_118":146,"_143":-5,"_116":147,"_113":148},14,["D",1739852340776],"7ad9d808-edaf-11ef-b953-e6cdfca9ef9f",{"_118":150,"_143":-5,"_116":151,"_113":152},13,["D",1739851577910],"b425506c-edad-11ef-89ec-e6cdfca9ef9f",{"_118":154,"_143":-5,"_116":155,"_113":156},12,["D",1739827817721],"61f86e8c-ed76-11ef-8abb-e6cdfca9ef9f",{"_118":158,"_143":-5,"_116":159,"_113":160},11,["D",1739827748980],"38fed106-ed76-11ef-8a84-e6cdfca9ef9f",{"_118":162,"_143":-5,"_116":163,"_113":164},10,["D",1739827096776],"b440422a-ed74-11ef-b795-e6cdfca9ef9f",{"_118":166,"_143":-5,"_116":167,"_113":168},9,["D",1739826788862],"fcb9626c-ed73-11ef-9dbd-e6cdfca9ef9f",{"_118":170,"_143":-5,"_116":171,"_113":172},8,["D",1739825817772],"b9ecf4e6-ed71-11ef-9a89-e6cdfca9ef9f",{"_118":174,"_143":-5,"_116":175,"_113":176},7,["D",1739825118192],"18ec67bc-ed70-11ef-9177-e6cdfca9ef9f",{"_118":178,"_143":-5,"_116":179,"_113":180},6,["D",1739824783412],"51611d00-ed6f-11ef-ba59-e6cdfca9ef9f",{"_118":182,"_143":-5,"_116":183,"_113":184},5,["D",1739824454489],"8d54d5e6-ed6e-11ef-886f-e6cdfca9ef9f",{"_118":186,"_143":-5,"_116":187,"_113":188},4,["D",1739822688559],"70c57312-ed6a-11ef-8cf8-e6cdfca9ef9f",{"_118":190,"_143":-5,"_116":191,"_113":192},3,["D",1739822562594],"25ac0594-ed6a-11ef-958f-e6cdfca9ef9f",{"_118":90,"_143":-5,"_116":194,"_113":195},["D",1739822491283],"fb2df2a0-ed69-11ef-bf47-e6cdfca9ef9f",{"_118":125,"_143":-5,"_116":197,"_113":198},["D",1739822397158],"c30fc088-ed69-11ef-8828-e6cdfca9ef9f",{"_118":31,"_143":-5,"_116":200,"_113":201},["D",1739822107149],"16351fd4-ed69-11ef-9c26-e6cdfca9ef9f","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":209,"_210":211,"_94":212},"single","redirect","/v/Marcyatieno/jobPostingApp/versions",{"_113":111,"_114":115,"_118":119,"_116":213,"_214":99,"_100":101,"_108":109,"_130":131,"_11":96,"_215":-5,"_216":-5,"_217":-5,"_206":26,"_136":137},["D",1739852383452],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

jobPostingApp

Version 15