Cache Database

\n ← Back to Test Page\n \n

\n \n

\n \n \n

\n \n

\n\n \n\n",[],[201],{"_103":208,"_95":209,"_154":210,"_156":-5,"_157":139,"_158":211,"_160":161,"_105":212,"_100":213,"_163":214,"_165":215,"_166":22,"_167":216,"_168":217,"_98":218},"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",[],[209],{"_103":220,"_95":221,"_154":222,"_156":-5,"_157":139,"_158":192,"_160":161,"_105":223,"_100":32,"_163":195,"_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":192,"_160":161,"_105":231,"_100":232,"_163":195,"_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,199,207,219,227],"counts",{"_240":32,"_241":159,"_242":32,"_243":32},"pulls","branches","forks","envVars","contents",[],{"_103":190,"_95":99,"_154":191,"_156":-5,"_157":139,"_158":192,"_160":161,"_105":247,"_100":194,"_163":195,"_165":196,"_166":22,"_167":-5,"_98":248},["D",1749989138712],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":257,"_195":262,"_265":266,"_288":289,"_296":-7,"_297":32,"_298":22},{"_103":104,"_95":96,"_105":258,"_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":259,"_133":260,"_136":261,"_148":22},["D",1749295353081],{"_93":94,"_131":132},{"_93":94,"_135":132},{"_100":138,"_95":43,"_103":139,"_140":104,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":96,"_147":94},{"_103":190,"_95":99,"_154":191,"_156":-5,"_157":139,"_158":192,"_160":161,"_105":263,"_100":194,"_163":195,"_165":196,"_166":22,"_167":-5,"_98":264},["D",1749989138712],[99],"history",[267,269,274,279,284],{"_103":190,"_157":139,"_154":191,"_95":99,"_165":196,"_163":195,"_100":194,"_156":-5,"_105":268,"_158":192,"_167":-5},["D",1749989138712],{"_103":270,"_157":139,"_154":191,"_95":99,"_165":271,"_163":195,"_100":232,"_156":-5,"_105":272,"_158":273,"_167":-5},"4c2ee37e-492e-11f0-804b-76b3cceeab13","# Plant Information API\n\nA REST API that provides detailed plant information using OpenAI's GPT model with intelligent caching for improved performance and reduced API costs.\n\n## Project Structure\n\n```\n├── index.ts # Main HTTP entry point (Hono app)\n├── backend/\n│ └── database/\n│ └── cache.ts # Database cache functions\n├── test.html # Plant API testing interface\n├── admin.html # Cache admin interface\n└── README.md\n```\n\n## Features\n\n- Get comprehensive plant information by name\n- Structured JSON response with 8 key plant characteristics\n- Powered by OpenAI GPT-4o-mini for accurate plant data\n- **Intelligent caching system** - stores successful responses and serves cached data for repeated requests\n- Cache management endpoints for monitoring and administration\n- Automatic plant name normalization for consistent caching\n\n## API Endpoints\n\n### GET /\nSimple testing interface for the Plant API with comprehensive features:\n- **Interactive plant lookup**: Enter plant names and see real-time API responses\n- **API documentation**: Built-in instructions showing all available endpoints and usage examples\n- **Request URL display**: Shows the exact URL used for each request with copy-to-clipboard functionality\n- **Response formatting**: Pretty-printed JSON responses with syntax highlighting\n- **Error handling**: Clear display of API errors and network issues\n- **Admin panel access**: Direct link to cache management interface\n- **Caching indicators**: Visual feedback showing whether responses came from cache or fresh API calls\n\n### GET /api\nReturns API information, usage instructions, and cache statistics.\n\n### GET /admin\nSimple admin interface for viewing the cache database. Displays:\n- Total number of cached entries\n- List of all cached plants with their full JSON data\n- Plant names, IDs, and creation timestamps\n\n### GET /plant/:name\nReturns detailed information about a specific plant. If the plant information is already cached, returns the cached response immediately. Otherwise, fetches new information from OpenAI and caches it for future requests.\n\n**Parameters:**\n- `name` (string, required): The name of the plant to look up\n\n**Response Format:**\n```json\n{\n \"name\": \"Common and scientific name\",\n \"description\": \"Detailed description of the plant\",\n \"lightNeeds\": \"Light requirements\",\n \"soilNeeds\": \"Soil type and pH requirements\", \n \"moistureNeeds\": \"Watering requirements\",\n \"bloomTime\": \"Blooming season/months\",\n \"height\": \"Mature height range\",\n \"spread\": \"Mature spread/width range\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n**Cache Indicators:**\n- `_cached`: Boolean indicating if the response came from cache (true) or OpenAI (false)\n- `_cacheTimestamp`: ISO timestamp of when the response was generated\n\n**Example Request:**\n```\nGET /plant/rose\n```\n\n**Example Response (from cache):**\n```json\n{\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants with fragrant blooms...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /health\nHealth check endpoint that returns API status.\n\n### GET /cache/stats\nReturns cache statistics including total cached entries and timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 15,\n \"oldestEntry\": \"2024-01-01T10:00:00.000Z\",\n \"newestEntry\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /cache/list\nReturns a list of all cached plants with their normalized names and creation timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 2,\n \"plants\": [\n {\n \"plantName\": \"Rose\",\n \"normalizedName\": \"rose\",\n \"createdAt\": \"2024-01-01T12:00:00.000Z\"\n },\n {\n \"plantName\": \"Japanese Maple\",\n \"normalizedName\": \"japanese_maple\",\n \"createdAt\": \"2024-01-01T11:30:00.000Z\"\n }\n ]\n}\n```\n\n### POST /cache/clear\nClears all cached plant information. Useful for maintenance or testing.\n\n**Response Format:**\n```json\n{\n \"message\": \"Cache cleared successfully\",\n \"timestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /admin/cache/full\nAdmin endpoint that returns complete cache data including full plant information for each entry. Used by the admin interface.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 2,\n \"entries\": [\n {\n \"id\": 1,\n \"plantName\": \"Rose\",\n \"normalizedName\": \"rose\",\n \"plantInfo\": {\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\"\n },\n \"createdAt\": \"2024-01-01T12:00:00.000Z\",\n \"updatedAt\": \"2024-01-01T12:00:00.000Z\"\n }\n ]\n}\n```\n\n## Error Handling\n\nThe API returns appropriate HTTP status codes:\n- `200`: Success\n- `400`: Bad request (missing plant name)\n- `500`: Server error (OpenAI API issues, parsing errors)\n\nError responses include descriptive error messages and may include additional debugging information.\n\n## Usage Examples\n\n```bash\n# Access the testing interface (web browser)\n# Visit: https://your-api-url/\n\n# Get API information and statistics\ncurl https://your-api-url/api\n\n# Get information about a rose (will cache the response)\ncurl https://your-api-url/plant/rose\n\n# Get information about the same rose again (will return cached response)\ncurl https://your-api-url/plant/rose\n\n# Get information about a tomato plant\ncurl https://your-api-url/plant/tomato\n\n# Get information about a Japanese maple (spaces are handled automatically)\ncurl https://your-api-url/plant/japanese%20maple\n\n# Check cache statistics\ncurl https://your-api-url/cache/stats\n\n# List all cached plants\ncurl https://your-api-url/cache/list\n\n# Clear the cache\ncurl -X POST https://your-api-url/cache/clear\n\n# Access the admin interface (web browser)\n# Visit: https://your-api-url/admin\n```\n\n## Caching Behavior\n\n- **Plant name normalization**: Plant names are normalized (lowercased, special characters removed, spaces converted to underscores) for consistent caching\n- **Cache hits**: Subsequent requests for the same plant (even with different capitalization or spacing) will return cached responses instantly\n- **Cache misses**: New plants trigger OpenAI API calls and the responses are automatically cached\n- **Performance**: Cached responses are served in milliseconds vs. seconds for OpenAI API calls\n- **Cost efficiency**: Reduces OpenAI API usage and associated costs\n\n## Technical Details\n\n- **Main entry point**: `index.ts` at project root with HTTP trigger\n- Built with Hono framework\n- Uses OpenAI GPT-4o-mini model\n- SQLite database for caching with automatic table creation\n- Includes input validation and error handling\n- Returns structured JSON responses\n- Supports URL-encoded plant names\n- Intelligent plant name normalization for cache consistency\n- Cache management endpoints for monitoring and administration",["D",1749912364382],54,{"_103":275,"_157":139,"_154":191,"_95":99,"_165":276,"_163":195,"_100":159,"_156":-5,"_105":277,"_158":278,"_167":-5},"b59b18ae-4781-11f0-8b01-76b3cceeab13","# Plant Information API\n\nA REST API that provides detailed plant information using OpenAI's GPT model with intelligent caching for improved performance and reduced API costs.\n\n## Features\n\n- Get comprehensive plant information by name\n- Structured JSON response with 8 key plant characteristics\n- Powered by OpenAI GPT-4o-mini for accurate plant data\n- **Intelligent caching system** - stores successful responses and serves cached data for repeated requests\n- Cache management endpoints for monitoring and administration\n- Automatic plant name normalization for consistent caching\n\n## API Endpoints\n\n### GET /\nReturns API information, usage instructions, and cache statistics.\n\n### GET /admin\nSimple admin interface for viewing the cache database. Displays:\n- Total number of cached entries\n- List of all cached plants with their full JSON data\n- Plant names, IDs, and creation timestamps\n\n### GET /plant/:name\nReturns detailed information about a specific plant. If the plant information is already cached, returns the cached response immediately. Otherwise, fetches new information from OpenAI and caches it for future requests.\n\n**Parameters:**\n- `name` (string, required): The name of the plant to look up\n\n**Response Format:**\n```json\n{\n \"name\": \"Common and scientific name\",\n \"description\": \"Detailed description of the plant\",\n \"lightNeeds\": \"Light requirements\",\n \"soilNeeds\": \"Soil type and pH requirements\", \n \"moistureNeeds\": \"Watering requirements\",\n \"bloomTime\": \"Blooming season/months\",\n \"height\": \"Mature height range\",\n \"spread\": \"Mature spread/width range\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n**Cache Indicators:**\n- `_cached`: Boolean indicating if the response came from cache (true) or OpenAI (false)\n- `_cacheTimestamp`: ISO timestamp of when the response was generated\n\n**Example Request:**\n```\nGET /plant/rose\n```\n\n**Example Response (from cache):**\n```json\n{\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants with fragrant blooms...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /health\nHealth check endpoint that returns API status.\n\n### GET /cache/stats\nReturns cache statistics including total cached entries and timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 15,\n \"oldestEntry\": \"2024-01-01T10:00:00.000Z\",\n \"newestEntry\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /cache/list\nReturns a list of all cached plants with their normalized names and creation timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 2,\n \"plants\": [\n {\n \"plantName\": \"Rose\",\n \"normalizedName\": \"rose\",\n \"createdAt\": \"2024-01-01T12:00:00.000Z\"\n },\n {\n \"plantName\": \"Japanese Maple\",\n \"normalizedName\": \"japanese_maple\",\n \"createdAt\": \"2024-01-01T11:30:00.000Z\"\n }\n ]\n}\n```\n\n### POST /cache/clear\nClears all cached plant information. Useful for maintenance or testing.\n\n**Response Format:**\n```json\n{\n \"message\": \"Cache cleared successfully\",\n \"timestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /admin/cache/full\nAdmin endpoint that returns complete cache data including full plant information for each entry. Used by the admin interface.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 2,\n \"entries\": [\n {\n \"id\": 1,\n \"plantName\": \"Rose\",\n \"normalizedName\": \"rose\",\n \"plantInfo\": {\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\"\n },\n \"createdAt\": \"2024-01-01T12:00:00.000Z\",\n \"updatedAt\": \"2024-01-01T12:00:00.000Z\"\n }\n ]\n}\n```\n\n## Error Handling\n\nThe API returns appropriate HTTP status codes:\n- `200`: Success\n- `400`: Bad request (missing plant name)\n- `500`: Server error (OpenAI API issues, parsing errors)\n\nError responses include descriptive error messages and may include additional debugging information.\n\n## Usage Examples\n\n```bash\n# Get information about a rose (will cache the response)\ncurl https://your-api-url/plant/rose\n\n# Get information about the same rose again (will return cached response)\ncurl https://your-api-url/plant/rose\n\n# Get information about a tomato plant\ncurl https://your-api-url/plant/tomato\n\n# Get information about a Japanese maple (spaces are handled automatically)\ncurl https://your-api-url/plant/japanese%20maple\n\n# Check cache statistics\ncurl https://your-api-url/cache/stats\n\n# List all cached plants\ncurl https://your-api-url/cache/list\n\n# Clear the cache\ncurl -X POST https://your-api-url/cache/clear\n\n# Access the admin interface (web browser)\n# Visit: https://your-api-url/admin\n```\n\n## Caching Behavior\n\n- **Plant name normalization**: Plant names are normalized (lowercased, special characters removed, spaces converted to underscores) for consistent caching\n- **Cache hits**: Subsequent requests for the same plant (even with different capitalization or spacing) will return cached responses instantly\n- **Cache misses**: New plants trigger OpenAI API calls and the responses are automatically cached\n- **Performance**: Cached responses are served in milliseconds vs. seconds for OpenAI API calls\n- **Cost efficiency**: Reduces OpenAI API usage and associated costs\n\n## Technical Details\n\n- Built with Hono framework\n- Uses OpenAI GPT-4o-mini model\n- SQLite database for caching with automatic table creation\n- Includes input validation and error handling\n- Returns structured JSON responses\n- Supports URL-encoded plant names\n- Intelligent plant name normalization for cache consistency\n- Cache management endpoints for monitoring and administration",["D",1749728287158],53,{"_103":280,"_157":139,"_154":191,"_95":99,"_165":281,"_163":195,"_100":282,"_156":-5,"_105":283,"_158":174,"_167":-5},"1ee06e1e-45a1-11f0-ba4d-76b3cceeab13","# Plant Information API\n\nA REST API that provides detailed plant information using OpenAI's GPT model with intelligent caching for improved performance and reduced API costs.\n\n## Features\n\n- Get comprehensive plant information by name\n- Structured JSON response with 8 key plant characteristics\n- Powered by OpenAI GPT-4o-mini for accurate plant data\n- **Intelligent caching system** - stores successful responses and serves cached data for repeated requests\n- Cache management endpoints for monitoring and administration\n- Automatic plant name normalization for consistent caching\n\n## API Endpoints\n\n### GET /\nReturns API information, usage instructions, and cache statistics.\n\n### GET /plant/:name\nReturns detailed information about a specific plant. If the plant information is already cached, returns the cached response immediately. Otherwise, fetches new information from OpenAI and caches it for future requests.\n\n**Parameters:**\n- `name` (string, required): The name of the plant to look up\n\n**Response Format:**\n```json\n{\n \"name\": \"Common and scientific name\",\n \"description\": \"Detailed description of the plant\",\n \"lightNeeds\": \"Light requirements\",\n \"soilNeeds\": \"Soil type and pH requirements\", \n \"moistureNeeds\": \"Watering requirements\",\n \"bloomTime\": \"Blooming season/months\",\n \"height\": \"Mature height range\",\n \"spread\": \"Mature spread/width range\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n**Cache Indicators:**\n- `_cached`: Boolean indicating if the response came from cache (true) or OpenAI (false)\n- `_cacheTimestamp`: ISO timestamp of when the response was generated\n\n**Example Request:**\n```\nGET /plant/rose\n```\n\n**Example Response (from cache):**\n```json\n{\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants with fragrant blooms...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\",\n \"_cached\": true,\n \"_cacheTimestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /health\nHealth check endpoint that returns API status.\n\n### GET /cache/stats\nReturns cache statistics including total cached entries and timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 15,\n \"oldestEntry\": \"2024-01-01T10:00:00.000Z\",\n \"newestEntry\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n### GET /cache/list\nReturns a list of all cached plants with their normalized names and creation timestamps.\n\n**Response Format:**\n```json\n{\n \"totalEntries\": 2,\n \"plants\": [\n {\n \"plantName\": \"Rose\",\n \"normalizedName\": \"rose\",\n \"createdAt\": \"2024-01-01T12:00:00.000Z\"\n },\n {\n \"plantName\": \"Japanese Maple\",\n \"normalizedName\": \"japanese_maple\",\n \"createdAt\": \"2024-01-01T11:30:00.000Z\"\n }\n ]\n}\n```\n\n### POST /cache/clear\nClears all cached plant information. Useful for maintenance or testing.\n\n**Response Format:**\n```json\n{\n \"message\": \"Cache cleared successfully\",\n \"timestamp\": \"2024-01-01T12:00:00.000Z\"\n}\n```\n\n## Error Handling\n\nThe API returns appropriate HTTP status codes:\n- `200`: Success\n- `400`: Bad request (missing plant name)\n- `500`: Server error (OpenAI API issues, parsing errors)\n\nError responses include descriptive error messages and may include additional debugging information.\n\n## Usage Examples\n\n```bash\n# Get information about a rose (will cache the response)\ncurl https://your-api-url/plant/rose\n\n# Get information about the same rose again (will return cached response)\ncurl https://your-api-url/plant/rose\n\n# Get information about a tomato plant\ncurl https://your-api-url/plant/tomato\n\n# Get information about a Japanese maple (spaces are handled automatically)\ncurl https://your-api-url/plant/japanese%20maple\n\n# Check cache statistics\ncurl https://your-api-url/cache/stats\n\n# List all cached plants\ncurl https://your-api-url/cache/list\n\n# Clear the cache\ncurl -X POST https://your-api-url/cache/clear\n```\n\n## Caching Behavior\n\n- **Plant name normalization**: Plant names are normalized (lowercased, special characters removed, spaces converted to underscores) for consistent caching\n- **Cache hits**: Subsequent requests for the same plant (even with different capitalization or spacing) will return cached responses instantly\n- **Cache misses**: New plants trigger OpenAI API calls and the responses are automatically cached\n- **Performance**: Cached responses are served in milliseconds vs. seconds for OpenAI API calls\n- **Cost efficiency**: Reduces OpenAI API usage and associated costs\n\n## Technical Details\n\n- Built with Hono framework\n- Uses OpenAI GPT-4o-mini model\n- SQLite database for caching with automatic table creation\n- Includes input validation and error handling\n- Returns structured JSON responses\n- Supports URL-encoded plant names\n- Intelligent plant name normalization for cache consistency\n- Cache management endpoints for monitoring and administration",1,["D",1749521875841],{"_103":285,"_157":139,"_154":191,"_95":99,"_165":286,"_163":195,"_100":32,"_156":-5,"_105":287,"_158":194,"_167":-5},"590716da-4392-11f0-9f79-76b3cceeab13","# Plant Information API\n\nA REST API that provides detailed plant information using OpenAI's GPT model.\n\n## Features\n\n- Get comprehensive plant information by name\n- Structured JSON response with 8 key plant characteristics\n- Powered by OpenAI GPT-4o-mini for accurate plant data\n\n## API Endpoints\n\n### GET /\nReturns API information and usage instructions.\n\n### GET /plant/:name\nReturns detailed information about a specific plant.\n\n**Parameters:**\n- `name` (string, required): The name of the plant to look up\n\n**Response Format:**\n```json\n{\n \"name\": \"Common and scientific name\",\n \"description\": \"Detailed description of the plant\",\n \"lightNeeds\": \"Light requirements\",\n \"soilNeeds\": \"Soil type and pH requirements\", \n \"moistureNeeds\": \"Watering requirements\",\n \"bloomTime\": \"Blooming season/months\",\n \"height\": \"Mature height range\",\n \"spread\": \"Mature spread/width range\"\n}\n```\n\n**Example Request:**\n```\nGET /plant/rose\n```\n\n**Example Response:**\n```json\n{\n \"name\": \"Rose (Rosa spp.)\",\n \"description\": \"Roses are woody perennial flowering plants with fragrant blooms...\",\n \"lightNeeds\": \"Full sun (6+ hours direct sunlight daily)\",\n \"soilNeeds\": \"Well-draining, fertile soil with pH 6.0-7.0\",\n \"moistureNeeds\": \"Regular watering, 1-2 inches per week\",\n \"bloomTime\": \"Late spring through fall (May-October)\",\n \"height\": \"1-8 feet depending on variety\",\n \"spread\": \"2-6 feet depending on variety\"\n}\n```\n\n### GET /health\nHealth check endpoint that returns API status.\n\n## Error Handling\n\nThe API returns appropriate HTTP status codes:\n- `200`: Success\n- `400`: Bad request (missing plant name)\n- `500`: Server error (OpenAI API issues, parsing errors)\n\nError responses include descriptive error messages and may include additional debugging information.\n\n## Usage Examples\n\n```bash\n# Get information about a rose\ncurl https://your-api-url/plant/rose\n\n# Get information about a tomato plant\ncurl https://your-api-url/plant/tomato\n\n# Get information about a Japanese maple\ncurl https://your-api-url/plant/japanese%20maple\n```\n\n## Technical Details\n\n- Built with Hono framework\n- Uses OpenAI GPT-4o-mini model\n- Includes input validation and error handling\n- Returns structured JSON responses\n- Supports URL-encoded plant names",["D",1749295628635],"versions",[290,292,293,294,295],{"_195":267,"_291":269},"previous",{"_195":269,"_291":274},{"_195":274,"_291":279},{"_195":279,"_291":284},{"_195":284,"_291":-5},"versionNumber","page","hasNext","actionData","errors"]

History for README.md