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`;",[],[174],"files",[152,172],"counts",{"_185":32,"_186":160,"_187":32,"_188":189},"pulls","branches","forks","envVars",{"_190":32,"_191":32},"count","emptyCount","contents",[194,197],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":138,"_159":160,"_161":108,"_104":195,"_99":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_98":196},["D",1733330961596],[154],{"_102":173,"_95":174,"_155":115,"_157":-5,"_158":138,"_159":137,"_161":108,"_104":198,"_99":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_98":199},["D",1733331240873],[174],"upstreamProject",{"_102":145,"_95":202,"_111":-5,"_112":-5,"_109":110,"_23":203},"socialDataProxy",{"_93":94,"_130":131},"upstreamBranch",{"_102":141,"_104":206,"_207":208,"_95":43,"_139":145,"_99":209,"_140":-5,"_142":-5,"_210":211,"_106":-5,"_149":22,"_109":110,"_148":94,"_16":119,"_147":202},["D",1744656008411],"updatedAt",["D",1751461957101],31,"lockfileKey","1755533726533-esm.town_v_stevekrouse_socialDataProxy@31-main","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":218,"_192":223,"_228":229,"_232":233,"_236":-5,"_181":237,"_244":245,"_246":137,"_247":209},{"_102":103,"_95":96,"_104":219,"_106":-5,"_107":108,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":115,"_116":108,"_117":-5,"_118":32,"_16":119,"_120":121,"_122":121,"_123":124,"_125":124,"_126":124,"_127":121,"_128":121,"_23":220,"_132":221,"_135":222,"_149":22},["D",1745961995980],{"_93":94,"_130":131},{"_93":94,"_134":131},{"_99":137,"_95":43,"_102":138,"_139":103,"_140":141,"_142":32,"_143":110,"_144":145,"_146":119,"_147":96,"_148":94},[224,226],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":138,"_159":160,"_161":108,"_104":195,"_99":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_98":225},[154],{"_102":173,"_95":174,"_155":115,"_157":-5,"_158":138,"_159":137,"_161":108,"_104":198,"_99":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_98":227},[174],"readme",{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":138,"_159":160,"_161":108,"_104":230,"_99":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_98":231},["D",1733330961596],[154],"upstream",{"_102":141,"_104":234,"_207":235,"_95":43,"_139":145,"_99":209,"_140":-5,"_142":-5,"_210":211,"_106":-5,"_149":22,"_109":110,"_148":94,"_16":119,"_147":202},["D",1744656008411],["D",1751461957101],"pull",[238,241],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":138,"_159":160,"_161":108,"_104":162,"_99":32,"_163":164,"_165":166,"_167":22,"_168":-5,"_169":239,"_98":240},[],[154],{"_102":173,"_95":174,"_155":115,"_157":-5,"_158":138,"_159":137,"_161":108,"_104":175,"_99":176,"_163":177,"_165":178,"_167":22,"_168":-5,"_169":242,"_98":243},[],[174],"previews",[241],"ahead","behind","actionData","errors"]

Usage Dashboard

Raw Data

Missing query parameter

Missing `query` parameter

stevekrouse

visionaryPeachAsp