Cache Database

\n ← Back to Test Page\n \n

\n \n

\n \n \n

\n \n

\n\n \n\n",[],[202],{"_103":209,"_95":210,"_154":211,"_156":-5,"_157":139,"_158":100,"_160":22,"_105":212,"_99":213,"_163":214,"_165":215,"_166":22,"_167":216,"_168":217,"_98":218},"599aa25c-4cb5-11f0-996f-76b3cceeab13","index.ts","4c2ecd08-492e-11f0-804b-76b3cceeab13",["D",1750300222449],6,"http","import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { deleteCookie, getCookie, setCookie } from \"npm:hono/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\";\n// const SESSION_SECRET = Deno.env.get(\"SESSION_SECRET\") || \"your-secret-key-change-this\";\n\n// Simple session management\nconst activeSessions = new Set();\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 = getCookie(c, \"admin_session\");\n\n if (!sessionToken || !activeSessions.has(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 = getCookie(c, \"admin_session\");\n console.log(`Session token: ${sessionToken}`);\n return sessionToken && activeSessions.has(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 console.log(`New session created: ${sessionToken}`);\n\n // Set session cookie (expires in 24 hours)\n setCookie(c, \"admin_session\", sessionToken, {\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 = getCookie(c, \"admin_session\");\n if (sessionToken) {\n activeSessions.delete(sessionToken);\n }\n\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 const fullCacheData = result.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",[],[210],{"_103":220,"_95":221,"_154":222,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":223,"_99":32,"_163":196,"_165":224,"_166":22,"_167":-5,"_168":225,"_98":226},"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",[],[221],{"_103":228,"_95":229,"_154":230,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":231,"_99":232,"_163":196,"_165":233,"_166":22,"_167":-5,"_168":234,"_98":235},"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",[],[229],"files",[151,170,177,189,200,208,219,227],"counts",{"_240":32,"_241":159,"_242":32,"_243":32},"pulls","branches","forks","envVars","contents",[246,249,252,255,258,261],{"_103":152,"_95":153,"_154":155,"_156":-5,"_157":139,"_158":159,"_160":161,"_105":247,"_99":32,"_163":164,"_165":-5,"_166":22,"_167":-5,"_98":248},["D",1749295614030],[153],{"_103":190,"_95":191,"_154":192,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":250,"_99":195,"_163":196,"_165":197,"_166":22,"_167":-5,"_98":251},["D",1749989138712],[191],{"_103":201,"_95":202,"_154":203,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":253,"_99":159,"_163":196,"_165":205,"_166":22,"_167":-5,"_98":254},["D",1749989138712],[202],{"_103":209,"_95":210,"_154":211,"_156":-5,"_157":139,"_158":100,"_160":22,"_105":256,"_99":213,"_163":214,"_165":215,"_166":22,"_167":216,"_98":257},["D",1750300222449],[210],{"_103":220,"_95":221,"_154":222,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":259,"_99":32,"_163":196,"_165":224,"_166":22,"_167":-5,"_98":260},["D",1749989138712],[221],{"_103":228,"_95":229,"_154":230,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":262,"_99":232,"_163":196,"_165":233,"_166":22,"_167":-5,"_98":263},["D",1749989138712],[229],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_101":272,"_99":100,"_277":278},{"_103":104,"_95":96,"_105":273,"_107":-5,"_108":22,"_109":110,"_111":112,"_113":114,"_14":115,"_116":-5,"_117":22,"_118":-5,"_119":32,"_16":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":274,"_133":275,"_136":276,"_148":22},["D",1749295353081],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_99":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},"changes",[279],{"_196":280,"_282":283,"_98":210},{"_154":211,"_95":210,"_163":214,"_165":215,"_105":281,"_158":100,"_157":139},["D",1750300222449],"previous",{"_154":211,"_95":210,"_163":214,"_165":284},"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { OpenAI } from \"https://esm.town/v/std/openai\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { deleteCookie, getCookie, setCookie } from \"npm:hono/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\nconst activeSessions = new Set();\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 = getCookie(c, \"admin_session\");\n\n if (!sessionToken || !activeSessions.has(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 = getCookie(c, \"admin_session\");\n console.log(`Session token: ${sessionToken}`);\n return sessionToken && activeSessions.has(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 console.log(`New session created: ${sessionToken}`);\n\n // Set session cookie (expires in 24 hours)\n setCookie(c, \"admin_session\", sessionToken, {\n httpOnly: true,\n secure: false,\n sameSite: \"Lax\",\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 = getCookie(c, \"admin_session\");\n if (sessionToken) {\n activeSessions.delete(sessionToken);\n }\n\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 const fullCacheData = result.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","actionData","errors"]