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":212,"_160":161,"_105":213,"_100":214,"_163":215,"_165":216,"_166":22,"_167":217,"_168":218,"_98":219},"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",[],[210],{"_103":221,"_95":222,"_154":223,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":224,"_100":32,"_163":196,"_165":225,"_166":22,"_167":-5,"_168":226,"_98":227},"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",[],[222],{"_103":229,"_95":230,"_154":231,"_156":-5,"_157":139,"_158":193,"_160":161,"_105":232,"_100":233,"_163":196,"_165":234,"_166":22,"_167":-5,"_168":235,"_98":236},"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",[],[230],"files",[151,170,177,189,200,208,220,228],"counts",{"_241":32,"_242":159,"_243":32,"_244":32},"pulls","branches","forks","envVars","contents",[],{"_103":178,"_157":139,"_154":180,"_95":179,"_165":184,"_163":183,"_100":182,"_156":173,"_105":248,"_158":138,"_167":-5,"_98":249},["D",1750476922237],[153,172,179],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.branch.$branch.history_.$",{"_93":94,"_95":96,"_97":43,"_98":99,"_101":258,"_196":263,"_266":267,"_318":319,"_331":-7,"_332":32,"_333":22},{"_103":104,"_95":96,"_105":259,"_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":260,"_133":261,"_136":262,"_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":178,"_95":179,"_154":180,"_156":173,"_157":139,"_158":138,"_160":161,"_105":264,"_100":182,"_163":183,"_165":184,"_166":22,"_167":-5,"_98":265},["D",1750476922237],[153,172,179],"history",[268,270,276,282,288,294,299,304,309,315],{"_103":178,"_157":139,"_154":180,"_95":179,"_165":184,"_163":183,"_100":182,"_156":173,"_105":269,"_158":138,"_167":-5},["D",1750476922237],{"_103":271,"_157":139,"_154":180,"_95":179,"_165":272,"_163":183,"_100":273,"_156":173,"_105":274,"_158":275,"_167":-5},"128f54ba-4e50-11f0-8f5b-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute({\n sql: `SELECT plant_info FROM plant_cache_v1 WHERE normalized_name = ? LIMIT 1`,\n args: [normalizedName],\n });\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO plant_cache_v1 \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n args: [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n });\n\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",8,["D",1750476626413],93,{"_103":277,"_157":139,"_154":180,"_95":179,"_165":278,"_163":183,"_100":279,"_156":173,"_105":280,"_158":281,"_167":-5},"dabe66a2-4e4f-11f0-8834-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute({\n sql: `SELECT plant_info FROM plant_cache_v1${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n args: [normalizedName],\n });\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO plant_cache_v1 \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n args: [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n });\n\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",7,["D",1750476532769],92,{"_103":283,"_157":139,"_154":180,"_95":179,"_165":284,"_163":183,"_100":285,"_156":173,"_105":286,"_158":287,"_167":-5},"1e74ce46-4e4f-11f0-b8cd-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute({\n sql: `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n args: [normalizedName],\n });\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO plant_cache_v1 \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n args: [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n });\n\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",6,["D",1750476216875],91,{"_103":289,"_157":139,"_154":180,"_95":179,"_165":290,"_163":183,"_100":291,"_156":173,"_105":292,"_158":293,"_167":-5},"0adfa82a-4e4e-11f0-813c-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute({\n sql: `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n args: [normalizedName],\n });\n\n await sqlite.execute({\n sql: `insert into kv(key, value) values (:key, :value)`,\n args: { key: \"specialkey\", value: \"specialvalue\" },\n });\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${TABLE_NAME} \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n );\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",5,["D",1750475754524],90,{"_103":295,"_157":139,"_154":180,"_95":179,"_165":296,"_163":183,"_100":195,"_156":173,"_105":297,"_158":298,"_167":-5},"71814118-4e46-11f0-b3ea-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute(\n `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n [normalizedName],\n );\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${TABLE_NAME} \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n );\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",["D",1750472490736],86,{"_103":300,"_157":139,"_154":180,"_95":179,"_165":301,"_163":183,"_100":233,"_156":173,"_105":302,"_158":303,"_167":-5},"60ed7b78-4e46-11f0-a314-76b3cceeab13","import { sqlite } from \"https://esm.town/v/std/sqlite./sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = \"plant_cache_v1\";\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n\n console.log(\"Cache table created successfully\");\n\n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, \"\") // Remove special characters\n .replace(/\\s+/g, \" \") // Normalize whitespace\n .replace(/\\s/g, \"_\"); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n const result = await sqlite.execute(\n `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n [normalizedName],\n );\n\n console.log(`getCachedPlant: query result:`, result);\n\n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n\n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error(\"Error retrieving cached plant:\", error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n\n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n\n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${TABLE_NAME} \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now,\n ],\n );\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error(\"Error caching plant:\", error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n\n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`,\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n\n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`,\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n\n return {\n totalEntries,\n oldestEntry,\n newestEntry,\n };\n } catch (error) {\n console.error(\"Error getting cache stats:\", error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null,\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise<\n Array<{\n plantName: string;\n normalizedName: string;\n createdAt: string;\n }>\n> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`,\n );\n\n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string,\n }));\n } catch (error) {\n console.error(\"Error listing cached plants:\", error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error(\"Error clearing cache:\", error);\n throw error;\n }\n}",["D",1750472462924],85,{"_103":305,"_157":139,"_154":180,"_95":179,"_165":306,"_163":183,"_100":159,"_156":173,"_105":307,"_158":308,"_167":-5},"1ce1c7fc-4731-11f0-9401-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = 'plant_cache_v1';\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n \n console.log(\"Cache table created successfully\");\n \n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, '') // Remove special characters\n .replace(/\\s+/g, ' ') // Normalize whitespace\n .replace(/\\s/g, '_'); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n \n try {\n const result = await sqlite.execute(\n `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n [normalizedName]\n );\n \n console.log(`getCachedPlant: query result:`, result);\n \n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n \n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error('Error retrieving cached plant:', error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n \n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n \n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${TABLE_NAME} \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now\n ]\n );\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error('Error caching plant:', error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n \n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n \n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n \n return {\n totalEntries,\n oldestEntry,\n newestEntry\n };\n } catch (error) {\n console.error('Error getting cache stats:', error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`\n );\n \n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string\n }));\n } catch (error) {\n console.error('Error listing cached plants:', error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error('Error clearing cache:', error);\n throw error;\n }\n}",["D",1749693671193],50,{"_103":310,"_157":139,"_154":180,"_95":179,"_165":311,"_163":183,"_100":312,"_156":173,"_105":313,"_158":314,"_167":-5},"eef3f15a-472e-11f0-93b9-76b3cceeab13","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n// Plant information interface\nexport interface PlantInfo {\n name: string;\n description: string;\n lightNeeds: string;\n soilNeeds: string;\n moistureNeeds: string;\n bloomTime: string;\n height: string;\n spread: string;\n}\n\n// Cache entry interface\nexport interface CacheEntry {\n id?: number;\n plantName: string;\n normalizedName: string;\n plantInfo: PlantInfo;\n createdAt: string;\n updatedAt: string;\n}\n\nconst TABLE_NAME = 'plant_cache_v1';\n\n// Initialize the cache table\nexport async function initializeCache(): Promise {\n try {\n console.log(\"Initializing cache table...\");\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n plant_name TEXT NOT NULL,\n normalized_name TEXT NOT NULL UNIQUE,\n plant_info TEXT NOT NULL,\n created_at TEXT NOT NULL,\n updated_at TEXT NOT NULL\n )`);\n \n console.log(\"Cache table created successfully\");\n \n // Create index for faster lookups\n await sqlite.execute(`CREATE INDEX IF NOT EXISTS idx_normalized_name ON ${TABLE_NAME} (normalized_name)`);\n console.log(\"Cache index created successfully\");\n } catch (error) {\n console.error(\"Error initializing cache:\", error);\n throw error;\n }\n}\n\n// Normalize plant name for consistent caching\nfunction normalizePlantName(name: string): string {\n return name.toLowerCase()\n .trim()\n .replace(/[^\\w\\s]/g, '') // Remove special characters\n .replace(/\\s+/g, ' ') // Normalize whitespace\n .replace(/\\s/g, '_'); // Replace spaces with underscores\n}\n\n// Get cached plant information\nexport async function getCachedPlant(plantName: string): Promise {\n const normalizedName = normalizePlantName(plantName);\n console.log(`getCachedPlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n \n try {\n const result = await sqlite.execute(\n `SELECT plant_info FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n [normalizedName]\n );\n \n console.log(`getCachedPlant: query result:`, result);\n \n if (result.rows && result.rows.length > 0) {\n const plantInfo = JSON.parse(result.rows[0].plant_info as string);\n console.log(`getCachedPlant: found cached data for \"${normalizedName}\"`);\n return plantInfo;\n }\n \n console.log(`getCachedPlant: no cached data found for \"${normalizedName}\"`);\n return null;\n } catch (error) {\n console.error('Error retrieving cached plant:', error);\n return null;\n }\n}\n\n// Cache plant information\nexport async function cachePlant(plantName: string, plantInfo: PlantInfo): Promise {\n const normalizedName = normalizePlantName(plantName);\n const now = new Date().toISOString();\n \n console.log(`cachePlant: original=\"${plantName}\", normalized=\"${normalizedName}\"`);\n \n try {\n // Use INSERT OR REPLACE to handle duplicates\n await sqlite.execute(\n `INSERT OR REPLACE INTO ${TABLE_NAME} \n (plant_name, normalized_name, plant_info, created_at, updated_at) \n VALUES (?, ?, ?, ?, ?)`,\n [\n plantName,\n normalizedName,\n JSON.stringify(plantInfo),\n now,\n now\n ]\n );\n console.log(`cachePlant: successfully cached \"${normalizedName}\"`);\n } catch (error) {\n console.error('Error caching plant:', error);\n // Don't throw error - caching failure shouldn't break the API\n }\n}\n\n// Get cache statistics\nexport async function getCacheStats(): Promise<{\n totalEntries: number;\n oldestEntry: string | null;\n newestEntry: string | null;\n}> {\n try {\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLE_NAME}`);\n const totalEntries = countResult.rows[0]?.count as number || 0;\n \n const oldestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at ASC LIMIT 1`\n );\n const oldestEntry = oldestResult.rows[0]?.created_at as string || null;\n \n const newestResult = await sqlite.execute(\n `SELECT created_at FROM ${TABLE_NAME} ORDER BY created_at DESC LIMIT 1`\n );\n const newestEntry = newestResult.rows[0]?.created_at as string || null;\n \n return {\n totalEntries,\n oldestEntry,\n newestEntry\n };\n } catch (error) {\n console.error('Error getting cache stats:', error);\n return {\n totalEntries: 0,\n oldestEntry: null,\n newestEntry: null\n };\n }\n}\n\n// List all cached plants (for debugging/admin purposes)\nexport async function listCachedPlants(): Promise> {\n try {\n const result = await sqlite.execute(\n `SELECT plant_name, normalized_name, created_at FROM ${TABLE_NAME} ORDER BY created_at DESC`\n );\n \n return result.rows.map(row => ({\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n createdAt: row.created_at as string\n }));\n } catch (error) {\n console.error('Error listing cached plants:', error);\n return [];\n }\n}\n\n// Clear cache (for maintenance)\nexport async function clearCache(): Promise {\n try {\n await sqlite.execute(`DELETE FROM ${TABLE_NAME}`);\n } catch (error) {\n console.error('Error clearing cache:', error);\n throw error;\n }\n}\n\n// Get detailed cached plant information (for admin interface)\nexport async function getCachedPlantDetails(normalizedName: string): Promise {\n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE normalized_name = ? LIMIT 1`,\n [normalizedName]\n );\n \n if (result.rows && result.rows.length > 0) {\n const row = result.rows[0];\n return {\n id: row.id as number,\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n plantInfo: JSON.parse(row.plant_info as string),\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string\n };\n }\n \n return null;\n } catch (error) {\n console.error('Error retrieving cached plant details:', error);\n return null;\n }\n}\n\n// Delete a specific cached plant (for admin interface)\nexport async function deleteCachedPlant(normalizedName: string): Promise {\n try {\n const result = await sqlite.execute(\n `DELETE FROM ${TABLE_NAME} WHERE normalized_name = ?`,\n [normalizedName]\n );\n \n // Check if any rows were affected\n return (result.changes || 0) > 0;\n } catch (error) {\n console.error('Error deleting cached plant:', error);\n throw error;\n }\n}\n\n// Export all cache data (for admin interface)\nexport async function exportCacheData(): Promise<{\n exportTimestamp: string;\n totalEntries: number;\n plants: CacheEntry[];\n}> {\n try {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY created_at DESC`\n );\n \n const plants: CacheEntry[] = result.rows.map(row => ({\n id: row.id as number,\n plantName: row.plant_name as string,\n normalizedName: row.normalized_name as string,\n plantInfo: JSON.parse(row.plant_info as string),\n createdAt: row.created_at as string,\n updatedAt: row.updated_at as string\n }));\n \n return {\n exportTimestamp: new Date().toISOString(),\n totalEntries: plants.length,\n plants\n };\n } catch (error) {\n console.error('Error exporting cache data:', error);\n throw error;\n }\n}",1,["D",1749692735138],28,{"_103":316,"_157":139,"_154":180,"_95":179,"_165":306,"_163":183,"_100":32,"_156":173,"_105":317,"_158":174,"_167":-5},"1ee05730-45a1-11f0-ba4d-76b3cceeab13",["D",1749521875841],"versions",[320,322,323,324,325,326,327,328,329,330],{"_196":268,"_321":270},"previous",{"_196":270,"_321":276},{"_196":276,"_321":282},{"_196":282,"_321":288},{"_196":288,"_321":294},{"_196":294,"_321":299},{"_196":299,"_321":304},{"_196":304,"_321":309},{"_196":309,"_321":315},{"_196":315,"_321":-5},"versionNumber","page","hasNext","actionData","errors"]

History for cache.ts