🤖 CyberJob Network 💻

\n \n AI Job Suggestion\n \n \n\n {aiSuggestion && (\n \n 🤖 AI Suggestion: {aiSuggestion}\n \n )}\n\n

📋 Job Listings

\n \n {jobs.map((job, index) => (\n \n

\n \n

{job.title}

{job.description}

\n ))}\n

\n\n \n

💬 Public Chat

\n \n {messages.map((msg, index) => (\n \n \n

{msg.content}

\n \n ))}\n \n

\n setNewMessage(e.target.value)}\n placeholder=\"Type a message...\"\n style={{\n width: \"100%\",\n background: \"black\",\n color: \"#00FFD1\",\n border: \"1px solid #00FFD1\",\n }}\n />\n \n \n \n \n View Source\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 { OpenAI } = await import(\"https://esm.town/v/std/openai\");\n const KEY = \"MyProject\";\n const SCHEMA_VERSION = 3;\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_jobs_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_messages_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n content TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n const openai = new OpenAI();\n\n if (request.method === \"POST\") {\n const body = await request.json();\n\n if (request.url.includes(\"/submit-job\")) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_jobs_${SCHEMA_VERSION} (title, description) VALUES (?, ?)`,\n [body.title, body.description],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.url.includes(\"/send-message\")) {\n await sqlite.execute(\n `INSERT INTO ${KEY}_messages_${SCHEMA_VERSION} (content) VALUES (?)`,\n [body.content],\n );\n return new Response(JSON.stringify({ success: true }), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.url.includes(\"/ai-suggestion\")) {\n const completion = await openai.chat.completions.create({\n messages: [\n {\n role: \"system\",\n content:\n \"You are a futuristic AI job suggestion bot. Generate a creative, tech-focused job suggestion that sounds exciting and innovative.\",\n },\n {\n role: \"user\",\n content: \"Give me an interesting job suggestion in the tech industry\",\n },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 100,\n });\n\n return new Response(\n JSON.stringify({\n suggestion: completion.choices[0].message.content,\n }),\n {\n headers: { \"Content-Type\": \"application/json\" },\n },\n );\n }\n }\n\n if (request.method === \"GET\") {\n if (request.url.includes(\"/get-jobs\")) {\n const jobs = await sqlite.execute(`SELECT * FROM ${KEY}_jobs_${SCHEMA_VERSION} ORDER BY timestamp DESC LIMIT 10`);\n return new Response(JSON.stringify(jobs.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n\n if (request.url.includes(\"/get-messages\")) {\n const messages = await sqlite.execute(\n `SELECT * FROM ${KEY}_messages_${SCHEMA_VERSION} ORDER BY timestamp DESC LIMIT 20`,\n );\n return new Response(JSON.stringify(messages.rows), {\n headers: { \"Content-Type\": \"application/json\" },\n });\n }\n }\n\n return new Response(\n `\n \n \n CyberJob Network\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"Content-Type\": \"text/html\" },\n },\n );\n}","deleted","label",[98],"permalink","https://www.val.town/x/mercyngatia/MyProject/code/main.tsx","extension","actionData","errors"]