Cache Database

\n ← Back to Test Page\n \n

\n \n

\n \n \n

\n \n

\n\n \n\n",[],[203],{"_104":210,"_95":211,"_155":212,"_157":-5,"_158":140,"_159":213,"_161":162,"_106":214,"_100":215,"_164":216,"_166":217,"_167":22,"_168":218,"_169":219,"_98":220},"bc926922-4e49-11f0-b0d9-76b3cceeab13","index.ts","4c2ecd08-492e-11f0-804b-76b3cceeab13",89,["D",1750473905167],33,"http","import { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono@3\";\nimport { deleteCookie, getSignedCookie, setSignedCookie } from \"npm:hono@3/cookie\";\nimport {\n cachePlant,\n clearCache,\n getCachedPlant,\n getCacheStats,\n initializeCache,\n listCachedPlants,\n type PlantInfo,\n} from \"./backend/database/cache.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Authentication configuration\nconst ADMIN_USERNAME = Deno.env.get(\"ADMIN_USERNAME\") || \"admin\";\nconst ADMIN_PASSWORD = Deno.env.get(\"ADMIN_PASSWORD\") || \"password123\";\nconst SESSION_SECRET = Deno.env.get(\"SESSION_SECRET\") || \"your-secret-key-change-this\";\n\n// Simple session management\n// const activeSessions = new Set();\n// app.use(\"*\", cookie({ secret: SESSION_SECRET }));\n\n// Generate a simple session token\nfunction generateSessionToken(): string {\n return crypto.randomUUID();\n}\n\n// Authentication middleware\nasync function requireAuth(c: any, next: any) {\n const sessionToken = await getSignedCookie(c, SESSION_SECRET, \"admin_session\");\n\n console.log(`requireAuthSession token: ${sessionToken}`);\n\n if (!sessionToken) {\n return c.redirect(\"/login\");\n }\n\n await next();\n}\n\n// Check if user is authenticated (for API endpoints)\nfunction isAuthenticated(c: any): boolean {\n const sessionToken = getSignedCookie(c, SESSION_SECRET, \"admin_session\");\n console.log(`Session token: ${sessionToken}`);\n\n return sessionToken;\n}\n\n// Initialize OpenAI\nconst openai = new OpenAI();\n\n// Initialize cache on startup with error handling\ntry {\n await initializeCache();\n console.log(\"Cache initialized successfully\");\n} catch (error) {\n console.error(\"Failed to initialize cache:\", error);\n}\n\n// Simple test page - now at root\napp.get(\"/\", async (c) => {\n const html = await readFile(\"/test.html\", import.meta.url);\n return c.html(html);\n});\n\n// Login page\napp.get(\"/login\", async (c) => {\n const html = await readFile(\"/login.html\", import.meta.url);\n return c.html(html);\n});\n\n// Login form handler\napp.post(\"/login\", async (c) => {\n const formData = await c.req.formData();\n const username = formData.get(\"username\") as string;\n const password = formData.get(\"password\") as string;\n\n console.log(`Login attempt: ${username} / ${password}`);\n\n if (username === ADMIN_USERNAME && password === ADMIN_PASSWORD) {\n // Create session\n const sessionToken = generateSessionToken();\n // activeSessions.add(sessionToken);\n\n // Set session cookie (expires in 24 hours)\n await setSignedCookie(c, \"admin_session\", sessionToken, SESSION_SECRET, {\n path: \"/\",\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 24 * 60 * 60, // 24 hours\n });\n\n return c.redirect(\"/admin\");\n } else {\n return c.redirect(\"/login?error=invalid\");\n }\n});\n\n// Logout handler\napp.post(\"/logout\", async (c) => {\n // const sessionToken = getSignedCookie(c, \"admin_session\");\n deleteCookie(c, \"admin_session\");\n return c.redirect(\"/\");\n});\n\n// API info endpoint moved to /api\napp.get(\"/api\", async (c) => {\n // Only show cache stats if authenticated\n let cacheInfo = {};\n if (isAuthenticated(c)) {\n const stats = await getCacheStats();\n cacheInfo = {\n totalCachedPlants: stats.totalEntries,\n oldestEntry: stats.oldestEntry,\n newestEntry: stats.newestEntry,\n };\n } else {\n cacheInfo = {\n note: \"Cache statistics require admin authentication\",\n };\n }\n\n return c.json({\n message: \"Plant Information API\",\n usage: \"GET /plant/:name - Get information about a specific plant\",\n example: \"/plant/rose\",\n testPage: \"/ - Simple testing interface\",\n adminPage: \"/admin - Cache database admin interface (requires login)\",\n loginPage: \"/login - Admin login\",\n cache: cacheInfo,\n endpoints: {\n \"/cache/stats\": \"Get cache statistics (requires authentication)\",\n \"/cache/list\": \"List all cached plants (requires authentication)\",\n \"/cache/clear\": \"Clear the cache - POST request (requires authentication)\",\n },\n });\n});\n\n// Admin page to view cache database - requires authentication\napp.get(\"/admin\", requireAuth, async (c) => {\n const html = await readFile(\"/admin.html\", import.meta.url);\n return c.html(html);\n});\n\napp.get(\"/plant/:name\", async (c) => {\n const plantName = c.req.param(\"name\");\n\n if (!plantName) {\n return c.json({ error: \"Plant name is required\" }, 400);\n }\n\n try {\n // First, check if we have cached information for this plant\n console.log(`Checking cache for plant: \"${plantName}\"`);\n const cachedPlant = await getCachedPlant(plantName);\n console.log(`Cache result:`, cachedPlant ? \"HIT\" : \"MISS\");\n\n if (cachedPlant) {\n // Return cached response with cache indicator\n console.log(`Returning cached data for: \"${plantName}\"`);\n return c.json({\n ...cachedPlant,\n _cached: true,\n _cacheTimestamp: new Date().toISOString(),\n });\n }\n\n console.log(`Fetching fresh data from OpenAI for: \"${plantName}\"`);\n // If not cached, fetch from OpenAI\n const prompt =\n `Please provide detailed information about the plant \"${plantName}\" in the following JSON format. Be specific and accurate:\n\n{\n \"name\": \"Common and scientific name\",\n \"description\": \"Detailed description of the plant including appearance and characteristics\",\n \"lightNeeds\": \"Specific light requirements (full sun, partial shade, etc.)\",\n \"soilNeeds\": \"Soil type and pH requirements\",\n \"moistureNeeds\": \"Watering requirements and frequency\",\n \"bloomTime\": \"When the plant blooms (seasons/months)\",\n \"height\": \"Mature height range\",\n \"spread\": \"Mature spread/width range\"\n}\n\nOnly return the JSON object, no additional text.`;\n\n const completion = await openai.chat.completions.create({\n messages: [\n { role: \"user\", content: prompt },\n ],\n model: \"gpt-4o-mini\",\n max_tokens: 500,\n temperature: 0.3, // Lower temperature for more consistent, factual responses\n });\n\n const responseText = completion.choices[0]?.message?.content;\n\n if (!responseText) {\n return c.json({ error: \"No response from OpenAI\" }, 500);\n }\n\n try {\n // Clean the response text by removing markdown code blocks if present\n let cleanedResponse = responseText.trim();\n if (cleanedResponse.startsWith(\"```json\")) {\n cleanedResponse = cleanedResponse.replace(/^```json\\s*/, \"\").replace(/\\s*```$/, \"\");\n } else if (cleanedResponse.startsWith(\"```\")) {\n cleanedResponse = cleanedResponse.replace(/^```\\s*/, \"\").replace(/\\s*```$/, \"\");\n }\n\n // Parse the JSON response from OpenAI\n const plantInfo: PlantInfo = JSON.parse(cleanedResponse);\n\n // Validate that all required fields are present\n const requiredFields = [\n \"name\",\n \"description\",\n \"lightNeeds\",\n \"soilNeeds\",\n \"moistureNeeds\",\n \"bloomTime\",\n \"height\",\n \"spread\",\n ];\n const missingFields = requiredFields.filter(field => !plantInfo[field as keyof PlantInfo]);\n\n if (missingFields.length > 0) {\n return c.json({\n error: \"Incomplete plant information\",\n missingFields,\n partialData: plantInfo,\n }, 500);\n }\n\n // Cache the successful response\n console.log(`Caching plant data for: \"${plantName}\"`);\n await cachePlant(plantName, plantInfo);\n console.log(`Successfully cached plant data for: \"${plantName}\"`);\n\n // Return the response with cache indicator\n return c.json({\n ...plantInfo,\n _cached: false,\n _cacheTimestamp: new Date().toISOString(),\n });\n } catch (parseError) {\n // If JSON parsing fails, return the raw response for debugging\n return c.json({\n error: \"Failed to parse plant information\",\n rawResponse: responseText,\n }, 500);\n }\n } catch (error) {\n console.error(\"Error fetching plant information:\", error);\n return c.json({\n error: \"Failed to fetch plant information\",\n details: error instanceof Error ? error.message : \"Unknown error\",\n }, 500);\n }\n});\n\n// Health check endpoint\napp.get(\"/health\", (c) => {\n return c.json({ status: \"healthy\", timestamp: new Date().toISOString() });\n});\n\n// Test database endpoint\napp.get(\"/test-db\", async (c) => {\n try {\n console.log(\"Testing database connection...\");\n\n // Test basic SQLite functionality\n const testResult = await sqlite.execute(\"SELECT 1 as test\");\n console.log(\"Basic SQLite test result:\", testResult);\n\n // Test table creation\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS test_table (id INTEGER PRIMARY KEY, name TEXT)`);\n console.log(\"Test table created\");\n\n // Test insert\n await sqlite.execute(`INSERT INTO test_table (name) VALUES (?)`, [\"test\"]);\n console.log(\"Test insert completed\");\n\n // Test select\n const selectResult = await sqlite.execute(`SELECT * FROM test_table`);\n console.log(\"Test select result:\", selectResult);\n\n return c.json({\n message: \"Database test successful\",\n testResult,\n selectResult,\n });\n } catch (error) {\n console.error(\"Database test failed:\", error);\n return c.json({\n error: \"Database test failed\",\n details: error instanceof Error ? error.message : \"Unknown error\",\n }, 500);\n }\n});\n\n// Cache management endpoints - require authentication\napp.get(\"/cache/stats\", async (c) => {\n if (!isAuthenticated(c)) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const stats = await getCacheStats();\n return c.json(stats);\n});\n\napp.get(\"/cache/list\", async (c) => {\n if (!isAuthenticated(c)) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n const cachedPlants = await listCachedPlants();\n return c.json({\n totalEntries: cachedPlants.length,\n plants: cachedPlants,\n });\n});\n\n// Admin endpoint to get full cache data including plant info - requires authentication\napp.get(\"/admin/cache/full\", async (c) => {\n // if (!isAuthenticated(c)) {\n // return c.json({ error: \"Authentication required\" }, 401);\n // }\n\n try {\n const result = await sqlite.execute(\n `SELECT id, plant_name, normalized_name, plant_info, created_at, updated_at \n FROM plant_cache_v1 ORDER BY created_at DESC`,\n );\n\n console.log(\"Full cache data:\", result.rows);\n\n const rows: { key: string; value: string }[] = result.rows.map(row =>\n Object.fromEntries(row.map((value, index) => [result.columns[index], value])) as any\n );\n\n const fullCacheData = rows.map(row => ({\n id: row.id,\n plantName: row.plant_name,\n normalizedName: row.normalized_name,\n plantInfo: JSON.parse(row.plant_info as string),\n createdAt: row.created_at,\n updatedAt: row.updated_at,\n }));\n\n return c.json({\n totalEntries: fullCacheData.length,\n entries: fullCacheData,\n });\n } catch (error) {\n console.error(\"Error getting full cache data:\", error);\n return c.json({\n error: \"Failed to retrieve cache data\",\n details: error instanceof Error ? error.message : \"Unknown error\",\n }, 500);\n }\n});\n\napp.post(\"/cache/clear\", async (c) => {\n if (!isAuthenticated(c)) {\n return c.json({ error: \"Authentication required\" }, 401);\n }\n\n try {\n await clearCache();\n return c.json({\n message: \"Cache cleared successfully\",\n timestamp: new Date().toISOString(),\n });\n } catch (error) {\n return c.json({\n error: \"Failed to clear cache\",\n details: error instanceof Error ? error.message : \"Unknown error\",\n }, 500);\n }\n});\n\nexport default app.fetch; // This is the entry point for HTTP vals","plantfo",[],[211],{"_104":222,"_95":223,"_155":224,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":225,"_100":32,"_164":197,"_166":226,"_167":22,"_168":-5,"_169":227,"_98":228},"0d4015b2-49e1-11f0-bf0d-76b3cceeab13","login.html","0d401666-49e1-11f0-bf0d-76b3cceeab13",["D",1749989138712],"\n\n\n \n \n Admin Login\n \n\n\n

Admin Login

\n \n \n \n

\n ← Back to Plant API\n

\n \n

\n \n \n\n",[],[223],{"_104":230,"_95":231,"_155":232,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":233,"_100":234,"_164":197,"_166":235,"_167":22,"_168":-5,"_169":236,"_98":237},"0d403e66-49e1-11f0-bf0d-76b3cceeab13","test.html","6a55552c-4398-11f0-aea1-76b3cceeab13",["D",1749989138712],3,"\n\n \n \n \n Plantfo - API\n \n \n \n

\n 🌱 Plantfo: The API for Plant Care Info\n

\n Enter a plant name to get detailed information from the API\n

\n \n 🔧 Admin Panel\n \n

\n\n \n

\n 📖 How to Use the API\n

\n Main Endpoint:\n GET /plant/{plant-name}\n

Examples:

\n GET /plant/rose\n
\n GET /plant/japanese%20maple (URL encode spaces)\n
\n GET /plant/tomato\n

Other Endpoints:

\n GET /api -\n API information and statistics\n

\n Response: JSON object with plant details\n including name, description, care requirements, and more.\n

\n Caching: Responses are cached for faster\n subsequent requests. Look for _cached: true in the response.\n

\n\n

\n \n \n Get Plant Info\n \n

\n\n \n

\n Fetching plant information...\n

\n\n

API Response

Request URL:

\n \n \n Copy\n \n

\n \n Enter a plant name above to see the API response\n

\n \n \n\n \n \n",[],[231],"files",[152,171,178,190,201,209,221,229],"counts",{"_242":32,"_243":160,"_244":32,"_245":32},"pulls","branches","forks","envVars","contents",[248],{"_104":179,"_95":180,"_155":181,"_157":174,"_158":140,"_159":101,"_161":22,"_106":249,"_100":183,"_164":184,"_166":185,"_167":22,"_168":-5,"_98":250},["D",1750476626413],[154,173,180],{"_104":172,"_95":173,"_155":174,"_157":156,"_158":140,"_159":175,"_161":162,"_106":252,"_100":32,"_164":165,"_166":-5,"_167":22,"_168":-5,"_98":253},["D",1749521875841],[154,173],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":43,"_100":101,"_98":99,"_102":262,"_150":267,"_238":292,"_197":293,"_246":295,"_298":-5,"_299":22,"_300":-5,"_301":-5,"_302":-5,"_303":304},{"_104":105,"_95":96,"_106":263,"_108":-5,"_109":22,"_110":111,"_112":113,"_114":115,"_14":116,"_117":-5,"_118":22,"_119":-5,"_120":32,"_16":121,"_122":123,"_124":123,"_125":126,"_127":126,"_128":126,"_129":123,"_130":123,"_23":264,"_134":265,"_137":266,"_149":22},["D",1749295353081],{"_93":94,"_132":133},{"_93":94,"_136":133},{"_100":139,"_95":43,"_104":140,"_141":105,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":96,"_148":94},[268,277,280,283,286,289],{"_104":153,"_95":154,"_155":156,"_157":-5,"_158":140,"_159":160,"_161":162,"_106":163,"_100":32,"_164":165,"_166":-5,"_167":22,"_168":-5,"_169":269,"_98":276},[270],{"_104":172,"_95":173,"_155":174,"_157":156,"_158":140,"_159":175,"_161":162,"_106":176,"_100":32,"_164":165,"_166":-5,"_167":22,"_168":-5,"_169":271,"_98":275},[272],{"_104":179,"_95":180,"_155":181,"_157":174,"_158":140,"_159":101,"_161":22,"_106":182,"_100":183,"_164":184,"_166":185,"_167":22,"_168":-5,"_169":273,"_98":274},[],[154,173,180],[154,173],[154],{"_104":191,"_95":192,"_155":193,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":195,"_100":196,"_164":197,"_166":198,"_167":22,"_168":-5,"_169":278,"_98":279},[],[192],{"_104":202,"_95":203,"_155":204,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":205,"_100":160,"_164":197,"_166":206,"_167":22,"_168":-5,"_169":281,"_98":282},[],[203],{"_104":210,"_95":211,"_155":212,"_157":-5,"_158":140,"_159":213,"_161":162,"_106":214,"_100":215,"_164":216,"_166":217,"_167":22,"_168":218,"_169":284,"_98":285},[],[211],{"_104":222,"_95":223,"_155":224,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":225,"_100":32,"_164":197,"_166":226,"_167":22,"_168":-5,"_169":287,"_98":288},[],[223],{"_104":230,"_95":231,"_155":232,"_157":-5,"_158":140,"_159":194,"_161":162,"_106":233,"_100":234,"_164":197,"_166":235,"_167":22,"_168":-5,"_169":290,"_98":291},[],[231],[268,270,272,277,280,283,286,289],{"_104":172,"_95":173,"_155":174,"_157":156,"_158":140,"_159":175,"_161":162,"_106":252,"_100":32,"_164":165,"_166":-5,"_167":22,"_168":-5,"_98":294},[154,173],[296],{"_104":179,"_95":180,"_155":181,"_157":174,"_158":140,"_159":101,"_161":22,"_106":249,"_100":183,"_164":184,"_166":185,"_167":22,"_168":-5,"_98":297},[154,173,180],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]