{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","children",[],[161],"files",[159],"counts",{"_182":33,"_183":184,"_185":33,"_186":187,"_190":191},"pulls","branches",1,"forks","envVars",{"_188":184,"_189":33},"count","emptyCount","connections",{"_188":33,"_192":33},"unfilledCount","contents",[195],{"_104":160,"_97":161,"_162":116,"_163":-5,"_164":147,"_165":146,"_166":118,"_106":196,"_101":168,"_169":170,"_171":172,"_173":22,"_174":-5,"_100":197},["D",1769408077517],[161],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_95":96,"_97":98,"_99":-7,"_101":-7,"_102":207,"_193":212,"_215":-7,"_216":-5,"_217":-5,"_178":218,"_222":219,"_223":-5,"_224":-5,"_225":22,"_226":22},{"_104":105,"_97":98,"_106":208,"_108":-5,"_109":22,"_110":111,"_112":-5,"_113":-5,"_14":114,"_115":116,"_117":118,"_119":-5,"_120":-5,"_121":33,"_16":122,"_123":124,"_125":126,"_127":128,"_129":128,"_130":131,"_132":131,"_133":131,"_134":128,"_135":128,"_23":209,"_139":210,"_144":211,"_156":22},["D",1769406072883],{"_95":96,"_137":138},{"_95":96,"_141":138,"_14":114,"_142":143},{"_101":146,"_97":45,"_104":147,"_148":105,"_149":-5,"_150":-5,"_151":-5,"_152":-5,"_153":-5,"_154":98,"_155":96},[213],{"_104":160,"_97":161,"_162":116,"_163":-5,"_164":147,"_165":146,"_166":118,"_106":196,"_101":168,"_169":170,"_171":172,"_173":22,"_174":-5,"_100":214},[161],"readme","upstream","pull",[219],{"_104":160,"_97":161,"_162":116,"_163":-5,"_164":147,"_165":146,"_166":118,"_106":167,"_101":168,"_169":170,"_171":172,"_173":22,"_174":-5,"_175":220,"_100":221},[],[161],"preview","ahead","behind","showHomeCustomizationHint","showHTTPPreviewSettingsHint","actionData","errors"]

aibotcommander

Database-Generator