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 = \"jobPostingApp\";\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`;","deleted","subdomain",[102],"permalink","https://www.val.town/x/Marcyatieno/jobPostingApp/code/main.tsx","extension","routes/embed","actionData","errors"]