{props.children}

\n \n \n );\n};\n\nconst Home: FC = async () => {\n const entries = await sqlite.execute(\n \"SELECT * FROM entries ORDER BY created_at DESC\"\n );\n return (\n \n

Database Entries

Manage entries via the /poe endpoint

\n {entries.rows.length > 0 ? (\n

\n {entry.name}: {entry.text}\n
\n {entry.created_at}\n

\n ) : (\n

No entries yet

\n )}\n \n );\n};\n\napp.get(\"/\", async (c) => {\n return c.html(await Home());\n});\n\napp.get(\"/poe\", (c) => {\n return c.json({ status: \"ready\", endpoint: \"/poe\", method: \"POST\" });\n});\n\napp.post(\"/poe\", async (c) => {\n try {\n const body = await c.req.json();\n const userMessage = body.query?.[0]?.query || \"\";\n const response = await handleCommand(userMessage);\n return c.json({ version: \"1.0\", type: \"response\", text: response });\n } catch (error) {\n return c.json({\n version: \"1.0\",\n type: \"response\",\n text: `Error: ${error.message}`,\n });\n }\n});\n\nasync function handleCommand(message: string): Promise {\n const trimmed = message.trim();\n\n if (trimmed.startsWith(\"--post \")) {\n const args = trimmed.slice(7).trim();\n const spaceIndex = args.indexOf(\" \");\n if (spaceIndex === -1) return \"Usage: --post ENTRY_NAME ENTRY_TEXT\";\n const entryName = args.slice(0, spaceIndex).trim();\n const entryText = args.slice(spaceIndex + 1).trim();\n if (!entryName || !entryText)\n return \"Both ENTRY_NAME and ENTRY_TEXT are required\";\n await sqlite.execute(\n \"INSERT OR REPLACE INTO entries (name, text) VALUES (?, ?)\",\n [entryName, entryText]\n );\n return `✓ Entry \"${entryName}\" saved successfully`;\n }\n\n if (trimmed.startsWith(\"--get \")) {\n const entryName = trimmed.slice(6).trim();\n if (!entryName) return \"Usage: --get ENTRY_NAME\";\n const result = await sqlite.execute(\n \"SELECT text FROM entries WHERE name = ?\",\n [entryName]\n );\n if (result.rows.length === 0) return `Entry \"${entryName}\" not found`;\n return result.rows[0].text as string;\n }\n\n if (trimmed.startsWith(\"--del \")) {\n const entryName = trimmed.slice(6).trim();\n if (!entryName) return \"Usage: --del ENTRY_NAME\";\n const result = await sqlite.execute(\n \"DELETE FROM entries WHERE name = ?\",\n [entryName]\n );\n if (result.rowsAffected === 0) return `Entry \"${entryName}\" not found`;\n return `✓ Entry \"${entryName}\" deleted successfully`;\n }\n\n if (trimmed === \"--clear\") {\n await sqlite.execute(\"DELETE FROM entries\");\n return \"✓ Database cleared successfully\";\n }\n\n if (trimmed === \"--exp\") {\n const result = await sqlite.execute(\n \"SELECT name, text FROM entries ORDER BY name\"\n );\n if (result.rows.length === 0) return \"Database is empty\";\n let export_data = \"# Database Export\\n\\n\";\n for (const row of result.rows) {\n export_data += `## ${row.name}\\n${row.text}\\n\\n---\\n\\n`;\n }\n return export_data;\n }\n\n return await callNvidiaAPI(message, \"sarvamai/sarvam-2b-instruct\");\n}\n\nasync function callNvidiaAPI(\n message: string,\n model: string = \"nvidia/llama-3.1-nemotron-70b-instruct\"\n): Promise {\n if (!NVIDIA_API_KEY)\n return \"NVIDIA API key not configured. Set NVIDIA_API_KEY environment variable.\";\n\n try {\n const response = await fetch(NVIDIA_API_URL, {\n method: \"POST\",\n headers: {\n \"Content-Type\": \"application/json\",\n Authorization: `Bearer ${NVIDIA_API_KEY}`,\n },\n body: JSON.stringify({\n model: model,\n messages: [{ role: \"user\", content: message }],\n temperature: 0.7,\n max_tokens: 1024,\n }),\n });\n\n if (!response.ok) {\n const errorText = await response.text();\n return `NVIDIA API error: ${response.status} - ${errorText}`;\n }\n\n const data = await response.json();\n return data.choices?.[0]?.message?.content || \"No response from AI\";\n } catch (error) {\n return `Error calling NVIDIA API: ${error.message}`;\n }\n}\n\nexport default app.fetch;","deleted","label",[100],"permalink","https://www.val.town/x/aibotcommander/Database-Generator/code/main.tsx","extension","actionData","errors"]