Usage Dashboard

\n \n

Raw Data

\n \n \n \n \n {Object.keys(data[0].users).map(username => (\n \n ))}\n \n \n \n {data.map(item => (\n \n \n {Object.keys(data[0].users).map(username => (\n \n ))}\n \n ))}\n \n

Date	{username}
{item.date}	{item.users[username] \|\| 0}

\n );\n}\n\nfunction App({ initialData }) {\n const [data] = useState(initialData);\n\n return ;\n}\n\nfunction client() {\n const initialData = (window as any).INITIAL_DATA;\n createRoot(document.getElementById(\"root\")).render();\n}\n\nif (typeof document !== \"undefined\") {\n client();\n}\n\nasync function getUsageData() {\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\n const result = await sqlite.execute(`\n SELECT DATE(timestamp) as date, username, COUNT(*) as count\n FROM ${KEY}_usage_${SCHEMA_VERSION}\n GROUP BY DATE(timestamp), username\n ORDER BY date\n `);\n\n const usageByDate = {};\n for (const row of result.rows) {\n if (!usageByDate[row.date]) {\n usageByDate[row.date] = { date: row.date, users: {} };\n }\n usageByDate[row.date].users[row.username] = row.count;\n }\n\n return Object.values(usageByDate);\n}\n\nexport default async function server(req: Request): Promise {\n const url = new URL(req.url);\n\n if (url.pathname === \"/\" && req.method === \"GET\") {\n const data = await getUsageData();\n return new Response(\n `\n \n \n Usage Dashboard\n \n \n \n \n

\n \n \n \n \n `,\n {\n headers: { \"content-type\": \"text/html\" },\n },\n );\n }\n\n // Existing API proxy logic\n const { API_URL } = await import(\"https://esm.town/v/std/API_URL?v=5\");\n const { fetchJSON } = await import(\"https://esm.town/v/stevekrouse/fetchJSON\");\n const { sqlite } = await import(\"https://esm.town/v/stevekrouse/sqlite\");\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 margin: 0;\n font-family: system-ui, sans-serif;\n padding: 20px;\n}\ntable {\n border-collapse: collapse;\n width: 100%;\n}\nth, td {\n border: 1px solid #ddd;\n padding: 8px;\n text-align: left;\n}\nth {\n background-color: #f2f2f2;\n}\n`;","deleted","label",[99],"permalink","https://www.val.town/x/stevekrouse/visionaryPeachAsp/code/main.tsx","extension","actionData","errors"]

Usage Dashboard

Raw Data

Missing query parameter

Missing `query` parameter