Val Town Usage Dashboard

\n {usageData.map((entry, idx) => (\n

\n {entry.username}\n {entry.usage_count} queries on {new Date(entry.date).toLocaleDateString()}\n

\n ))}\n

\n View Source\n

\n );\n}\n\nfunction client() {\n createRoot(document.getElementById(\"root\")).render();\n}\nif (typeof document !== \"undefined\") { client(); }\n\nexport default async function(req: Request): Promise {\n const url = new URL(req.url);\n\n // Usage data retrieval route\n if (url.pathname === '/usage-data') {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n \n const usageData = await sqlite.execute(`\n SELECT \n username, \n COUNT(*) as usage_count, \n DATE(timestamp) as date \n FROM ${KEY}_usage_${SCHEMA_VERSION}\n GROUP BY username, DATE(timestamp)\n ORDER BY date DESC\n LIMIT 100\n `);\n\n return Response.json(usageData.rows);\n }\n\n // Main dashboard route\n if (req.method === 'GET' && url.pathname === '/') {\n return new Response(`\n \n \n Val Town Usage Dashboard\n \n \n \n \n

\n \n \n \n `, {\n headers: { 'Content-Type': 'text/html' }\n });\n }\n\n // Existing social data proxy logic remains unchanged\n const Authorization = req.headers.get(\"Authorization\") as string;\n const meRes = await fetch(`${API_URL}/v1/me`, { headers: { Authorization } });\n if (!meRes.ok) {\n return new Response(\"Unauthorized\", { status: 401 });\n }\n const user: User = await meRes.json();\n\n if (user.tier !== \"pro\") {\n return new Response(\"This SocialData Proxy requires Val Town Pro\", { status: 401 });\n }\n\n const query = url.searchParams.get(\"query\");\n if (!query) {\n return new Response(\n `

Missing `query` parameter

\n Learn more\n

`,\n { status: 400, headers: { \"content-type\": \"text/html\" } },\n );\n }\n\n // Create table if not exists\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${KEY}_usage_${SCHEMA_VERSION} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id TEXT NOT NULL,\n username TEXT NOT NULL,\n tier TEXT NOT NULL,\n query TEXT NOT NULL,\n timestamp DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Check usage limit\n const twentyFourHoursAgo = new Date(Date.now() - 24 * 60 * 60 * 1000).toISOString();\n const usageCount = await sqlite.execute(\n `\n SELECT COUNT(*) as count\n FROM ${KEY}_usage_${SCHEMA_VERSION}\n WHERE user_id = ? AND timestamp > ?\n `,\n [user.id, twentyFourHoursAgo],\n );\n\n const count = usageCount.rows[0].count as number;\n if (count >= 100) {\n return new Response(\"You have exceeded the limit of 100 queries per day\", { status: 429 });\n }\n\n // Insert usage data\n await sqlite.execute(\n `\n INSERT INTO ${KEY}_usage_${SCHEMA_VERSION} (user_id, username, tier, query)\n VALUES (?, ?, ?, ?)\n `,\n [user.id, user.username, user.tier, query],\n );\n\n const socialDataURL = new URL(\"https://api.socialdata.tools/twitter/search\");\n socialDataURL.searchParams.set(\"query\", query);\n const socialDataResults = await fetchJSON(socialDataURL.toString(), {\n bearer: Deno.env.get(\"SOCIAL_DATA_API_KEY\"),\n });\n\n return Response.json(socialDataResults);\n}\n\nconst css = `\nbody {\n font-family: system-ui, sans-serif;\n max-width: 900px;\n margin: 0 auto;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.dashboard {\n background-color: white;\n border-radius: 8px;\n padding: 20px;\n box-shadow: 0 4px 6px rgba(0,0,0,0.1);\n}\n\n.usage-details {\n margin-top: 20px;\n display: grid;\n gap: 10px;\n}\n\n.usage-entry {\n display: flex;\n justify-content: space-between;\n padding: 10px;\n background-color: #f9f9f9;\n border-radius: 4px;\n}\n`;","deleted","label",[98],"permalink","https://www.val.town/x/stevekrouse/spectacularAzureAngelfish/code/main.tsx","extension","actionData","errors"]

Val Town Usage Dashboard

Missing query parameter

Missing `query` parameter