[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_103":104,"_105":106},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","recoolit","name","devstats","path","main.tsx","project",{"_22":45,"_11":12,"_33":46,"_47":-5,"_48":42,"_49":50,"_51":50,"_52":-5,"_53":-5,"_54":55,"_56":25,"_57":32,"_58":-5,"_59":-5,"_60":36,"_61":62,"_63":-5,"_64":-5,"_65":-5,"_66":-5,"_67":68,"_69":68,"_70":71,"_72":71,"_73":71,"_74":68,"_75":68,"_76":77,"_78":79,"_80":81,"_82":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":-5,"_13":44},"permalink","https://www.val.town/x/recoolit/devstats/code/main.tsx","extension","id","80efd5c0-eda8-4965-a7a6-c98b0ee8a13c","fileId","01a0823d-be87-701b-a53a-e2f2614d2a5c","parentId","branchId","80ff2861-6ee6-4e2b-8061-47ad7253413f","branchVersion",1,"latest",true,"createdAt",["D",1788891479608],"version",0,"fileType","http","content","import { cors } from \"npm:hono@4.12.27/cors\";\nimport { Hono } from \"npm:hono@4.12.27\";\nimport { sqlite } from \"https://esm.town/v/std/sqlite@27-main/global.ts\";\nimport * as d3 from \"npm:d3@7.9.0\";\n\nconst KEY = \"devstats\";\nconst TABLE_NAME = `${KEY}_devstats`;\n\nconst app = new Hono();\n\napp.use(\"*\", cors());\n\napp.get(\"/\", async (c) => {\n const numFormat = new Intl.NumberFormat(\"en\");\n const rows = await getRows();\n const max = d3.max(rows, (r) => r.date);\n const html = `\n \n \n \n \n \n DevStats Dashboard\n \n \n \n \n \n \n \n \n \n

\n Developer Statistics\n ${max ? `Updated ${max}` : \"\"}\n

\n This page receives data from our GitHub Actions runs and other developer-adjacent\n data, and then shows us statistics of those values over time. We're using it to track\n how our dependencies sizes and other stats affect our application.\n

\n \n

\n View source: Val Town (generated with Deno ${Deno.version.deno})\n

\n \n \n \n `;\n\n return c.html(html);\n});\n\nconst script = (async () => {\n const Plot = await import(\n \"https://cdn.jsdelivr.net/npm/@observablehq/plot@0.6/+esm\"\n );\n const d3 = await import(\"https://cdn.jsdelivr.net/npm/d3@7/+esm\");\n const data = ((window as any).DATA as Rows).map((d) => ({\n ...d,\n date: new Date(d.date + \"+05\"),\n }));\n\n const domain = d3.extent(data, (d) => d.date);\n\n const groups: Record = {};\n for (let x of data) {\n groups[x.name] = groups[x.name] || [];\n groups[x.name].push(x);\n }\n const container = document.querySelector(\"#plot\")!;\n\n Object.entries(groups).map(([name, data], i, { length }) => {\n const wrap = container.appendChild(document.createElement(\"div\"));\n const c = d3.schemeTableau10[i];\n wrap.className = `relative bg-[${c}] border-t border-[${c}] bg-opacity-10 ${\n i === length - 1 ? \"border-b\" : \"\"\n }`;\n const title = wrap.appendChild(document.createElement(\"h2\"));\n title.className =\n `text-xs bg-[${c}] text-[${c}] block p-1 rounded bg-opacity-10 font-semibold font-mono absolute top-1 left-1`;\n title.innerText = name;\n const div = wrap.appendChild(document.createElement(\"div\"));\n const width = div.getBoundingClientRect().width;\n const plot = Plot.lineY(data, {\n x: \"date\",\n y: \"value\",\n curve: \"step-after\",\n stroke: () => c,\n tip: true,\n }).plot({\n width,\n x: { domain, grid: true },\n y: { grid: true, label: null, paddingOuter: 100 },\n marginLeft: 80,\n marginBottom: 40,\n marginTop: 40,\n height: 300,\n });\n div.append(plot);\n });\n}).toString().split(\"\\n\").slice(1).slice(0, -1).join(\"\\n\");\n\nasync function getRows() {\n const result = await sqlite.execute(`SELECT * FROM ${TABLE_NAME}`);\n const rows = result.rows.map((r) => ({\n id: String(r[0]),\n name: String(r[1]),\n value: +r[2],\n date: String(r[3]),\n }));\n return rows;\n}\n\ntype Rows = Awaited>;\n\napp.get(\"/api\", async function apiRoute(c) {\n try {\n return c.json(await getRows());\n } catch (error) {\n console.error(\"Error fetching data:\", error);\n return c.text(\"Error fetching data\", 500);\n }\n});\n\napp.post(\"/\", async (c) => {\n try {\n const authHeader = c.req.header(\"Authorization\");\n if (authHeader !== `Bearer ${Deno.env.get(\"DEVSTATS_KEY\")}`) {\n return c.text(\"Unauthorized\", 401);\n }\n\n const { name, value } = await c.req.json();\n\n if (!name || !value) {\n return c.text(\"Missing name or value in the request body\", 400);\n }\n\n await sqlite.execute({\n sql: `INSERT INTO ${TABLE_NAME} (name, value) VALUES (?, ?)`,\n args: [name, value],\n });\n\n return c.text(\"Data inserted successfully\", 201);\n } catch (error) {\n console.error(\"Error inserting data:\", error);\n return c.text(\"Error inserting data\", 500);\n }\n});\n\nexport default async function (req: Request): Promise {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n value REAL NOT NULL,\n date DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n return app.fetch(req);\n}","deleted",false,"label",[14],"83d85571-2725-4ca9-810b-9563d92fe629",["D",1788891479608],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","24e016a4-daf4-4d3c-9c2c-64a293e82092","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a0823d-1875-760d-9f5f-0c87c58ddfdf","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_102":-5},"org",{"_9":10,"_96":97,"_98":-5,"_54":-5,"_99":100,"_101":42},"branch",{"_35":30,"_11":83,"_22":28,"_84":45,"_85":86,"_87":88,"_89":50,"_90":91,"_92":93,"_94":12,"_95":10},"isOwned","main","projectId","forkedBranchId","cadd1346-25dc-11f0-9d0b-569c3dd06744","forkedBranchVersion",239,"forkedProjectPrivacy","forkedProjectId","cadcbb44-25dc-11f0-9d0b-569c3dd06744","forkedProjectOrgId","f407f111-fdbb-4126-923f-44aed4d9e9ad","projectName","userHandle","displayName","Recoolit","avatar","tier","free","canRestrictVals","profileImageUrl","ctx",{"_76":-5,"_136":137,"_138":139,"_140":141,"_142":42,"_143":42,"_144":42,"_145":32,"_146":-5,"_147":-7,"_148":-7,"_149":36,"_150":42,"_151":42,"_152":-5,"_153":42,"_154":42,"_155":42,"_156":-5},"ENV",{"_107":108,"_109":110,"_111":83,"_112":113,"_114":115,"_116":117,"_118":119,"_120":121,"_122":123,"_124":125,"_126":127,"_128":129,"_130":131,"_132":133,"_134":135},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]