[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_93":92,"_31":43,"_101":83,"_26":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":24,"_116":117,"_118":24,"_119":-5,"_120":-5,"_121":122},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":76,"_77":78,"_79":80,"_81":24},"version",5,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","index.ts","latestPath","fileId","8c876e60-dfd2-11f0-bfb3-42dde27851f2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst REPO = \"gimlet-io/capacitor\";\n\nexport const cron = \"0 0 * * *\";\n\ntype GitHubRelease = {\n tag_name?: string;\n assets?: Array<{ name?: string; download_count?: number }>;\n};\n\nfunction isAllowedTag(tag: string): boolean {\n // CalVer: v2025-12.1\n if (/^v\\d{4}-(0[1-9]|1[0-2])\\.\\d+$/.test(tag)) return true;\n\n // SemVer: 0.12.0+ (optional leading v), RC included (rc, rc.1, RC1, etc)\n // Examples: v0.12.0, 0.12.0, v0.12.0-rc.1, v0.12.0-RC1\n const m = tag.match(\n /^v?(0)\\.(\\d+)\\.(\\d+)(?:-([rR][cC])\\.?(\\d+))?$/,\n );\n if (!m) return false;\n\n const major = Number(m[1]);\n const minor = Number(m[2]);\n const patch = Number(m[3]);\n if (![major, minor, patch].every(Number.isFinite)) return false;\n\n if (major !== 0) return false;\n if (minor < 12) return false;\n if (minor === 12 && patch < 0) return false;\n return true;\n}\n\nasync function sql(\n strings: TemplateStringsArray,\n ...values: unknown[]\n): Promise {\n let statement = strings[0] ?? \"\";\n const args: unknown[] = [];\n for (let i = 0; i < values.length; i++) {\n statement += \"?\";\n statement += strings[i + 1] ?? \"\";\n args.push(values[i]);\n }\n return await sqlite.execute({ sql: statement, args });\n}\n\nexport default async function capacitorReleaseStatsCollector() {\n const snapshotDate = new Date().toISOString().slice(0, 10); // YYYY-MM-DD (UTC)\n const fetchedAt = new Date().toISOString();\n\n await sql`\n CREATE TABLE IF NOT EXISTS github_release_asset_downloads (\n repo TEXT NOT NULL,\n tag TEXT NOT NULL,\n asset TEXT NOT NULL,\n download_count INTEGER NOT NULL,\n snapshot_date TEXT NOT NULL,\n fetched_at TEXT NOT NULL,\n PRIMARY KEY (repo, tag, asset, snapshot_date)\n );\n `;\n\n await sql`\n CREATE INDEX IF NOT EXISTS idx_github_release_asset_downloads_repo_tag_date\n ON github_release_asset_downloads (repo, tag, snapshot_date);\n `;\n\n const res = await fetch(`https://api.github.com/repos/${REPO}/releases`, {\n headers: {\n \"User-Agent\": \"val-town-capacitor-release-stats\",\n \"Accept\": \"application/vnd.github+json\",\n },\n });\n if (!res.ok) {\n const body = await res.text().catch(() => \"\");\n throw new Error(\n `GitHub API request failed: ${res.status} ${res.statusText}\\n${body}`,\n );\n }\n\n const releases = (await res.json()) as unknown as GitHubRelease[];\n\n let rowsUpserted = 0;\n for (const rel of releases) {\n const tag = rel.tag_name;\n if (!tag || !isAllowedTag(tag)) continue;\n\n for (const a of rel.assets ?? []) {\n const asset = a?.name;\n const downloadCount = a?.download_count;\n if (!asset || typeof downloadCount !== \"number\") continue;\n\n await sql`\n INSERT INTO github_release_asset_downloads\n (repo, tag, asset, download_count, snapshot_date, fetched_at)\n VALUES\n (${REPO}, ${tag}, ${asset}, ${downloadCount}, ${snapshotDate}, ${fetchedAt})\n ON CONFLICT(repo, tag, asset, snapshot_date) DO UPDATE SET\n download_count = excluded.download_count,\n fetched_at = excluded.fetched_at;\n `;\n rowsUpserted++;\n }\n }\n\n return { repo: REPO, snapshotDate, rowsUpserted };\n}\n\n\n","createdAt",["D",1766475584210],"branchVersion","branchId","922b8922-dfc9-11f0-a786-42dde27851f2","id","922b34f4-dfc9-11f0-a786-42dde27851f2","capacitorReleaseStatsCollector",["D",1766471728216],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Daily GitHub release stats → SQLite","imageUrl","019b46a9-67d2-772e-9635-f06418263f90","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019b46a9-67d3-737c-96f5-311157cbdc8f","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},"branch",{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"isOwned",14,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","laszlocph","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zN0NwbFlIVmNuRFpLV09sZ3BnMmtOUHZnOUkifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_41":42,"_31":43,"_36":159,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":-5,"_55":24,"_56":-5,"_57":-5,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":-5,"_65":-5,"_66":67,"_68":67,"_69":70,"_71":70,"_72":70,"_73":67,"_74":67,"_75":160,"_77":161,"_79":162,"_81":24},"tree",[150,151],"files",[150,151],"counts",{"_140":59,"_141":136,"_142":59,"_143":144,"_145":146},"contents",[123,124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":131,"_31":132,"_29":133,"_126":-5,"_39":40,"_38":134,"_127":24,"_36":135,"_13":136,"_32":137,"_34":138,"_23":24,"_129":-5,"_26":139},{"_41":125,"_31":27,"_29":30,"_126":-5,"_39":40,"_38":14,"_127":24,"_36":128,"_13":59,"_32":33,"_34":35,"_23":24,"_129":-5,"_26":130},"8c876dac-dfd2-11f0-bfb3-42dde27851f2","parentId","latest",["D",1766475584210],"label",[27],"8c83933a-dfd2-11f0-be6a-42dde27851f2","index.cron.ts","57b510f4-dfcb-11f0-8bd2-42dde27851f2",4,["D",1766475584196],1,"interval","// Daily cron\nimport { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst REPO = \"gimlet-io/capacitor\";\n\nexport const cron = \"0 0 * * *\";\n\ntype GitHubRelease = {\n tag_name?: string;\n assets?: Array<{ name?: string; download_count?: number }>;\n};\n\nfunction isAllowedTag(tag: string): boolean {\n // CalVer: v2025-12.1\n if (/^v\\d{4}-(0[1-9]|1[0-2])\\.\\d+$/.test(tag)) return true;\n\n // SemVer: 0.12.0+ (optional leading v), RC included (rc, rc.1, RC1, etc)\n // Examples: v0.12.0, 0.12.0, v0.12.0-rc.1, v0.12.0-RC1\n const m = tag.match(\n /^v?(0)\\.(\\d+)\\.(\\d+)(?:-([rR][cC])\\.?(\\d+))?$/,\n );\n if (!m) return false;\n\n const major = Number(m[1]);\n const minor = Number(m[2]);\n const patch = Number(m[3]);\n if (![major, minor, patch].every(Number.isFinite)) return false;\n\n if (major !== 0) return false;\n if (minor < 12) return false;\n if (minor === 12 && patch < 0) return false;\n return true;\n}\n\nasync function sql(\n strings: TemplateStringsArray,\n ...values: unknown[]\n): Promise {\n let statement = strings[0] ?? \"\";\n const args: unknown[] = [];\n for (let i = 0; i < values.length; i++) {\n statement += \"?\";\n statement += strings[i + 1] ?? \"\";\n args.push(values[i]);\n }\n return await sqlite.execute({ sql: statement, args });\n}\n\nexport default async function capacitorReleaseStatsCollector() {\n const snapshotDate = new Date().toISOString().slice(0, 10); // YYYY-MM-DD (UTC)\n const fetchedAt = new Date().toISOString();\n\n await sql`\n CREATE TABLE IF NOT EXISTS github_release_asset_downloads (\n repo TEXT NOT NULL,\n tag TEXT NOT NULL,\n asset TEXT NOT NULL,\n download_count INTEGER NOT NULL,\n snapshot_date TEXT NOT NULL,\n fetched_at TEXT NOT NULL,\n PRIMARY KEY (repo, tag, asset, snapshot_date)\n );\n `;\n\n await sql`\n CREATE INDEX IF NOT EXISTS idx_github_release_asset_downloads_repo_tag_date\n ON github_release_asset_downloads (repo, tag, snapshot_date);\n `;\n\n const res = await fetch(`https://api.github.com/repos/${REPO}/releases`, {\n headers: {\n \"User-Agent\": \"val-town-capacitor-release-stats\",\n \"Accept\": \"application/vnd.github+json\",\n },\n });\n if (!res.ok) {\n const body = await res.text().catch(() => \"\");\n throw new Error(\n `GitHub API request failed: ${res.status} ${res.statusText}\\n${body}`,\n );\n }\n\n const releases = (await res.json()) as unknown as GitHubRelease[];\n\n let rowsUpserted = 0;\n for (const rel of releases) {\n const tag = rel.tag_name;\n if (!tag || !isAllowedTag(tag)) continue;\n\n for (const a of rel.assets ?? []) {\n const asset = a?.name;\n const downloadCount = a?.download_count;\n if (!asset || typeof downloadCount !== \"number\") continue;\n\n await sql`\n INSERT INTO github_release_asset_downloads\n (repo, tag, asset, download_count, snapshot_date, fetched_at)\n VALUES\n (${REPO}, ${tag}, ${asset}, ${downloadCount}, ${snapshotDate}, ${fetchedAt})\n ON CONFLICT(repo, tag, asset, snapshot_date) DO UPDATE SET\n download_count = excluded.download_count,\n fetched_at = excluded.fetched_at;\n `;\n rowsUpserted++;\n }\n }\n\n return { repo: REPO, snapshotDate, rowsUpserted };\n}\n\n\n",[132],"pulls","branches","forks","envVars",{"_147":136,"_149":59},"connections",{"_147":59,"_148":59},"count","unfilledCount","emptyCount",{"_41":131,"_31":132,"_29":133,"_126":-5,"_39":40,"_38":134,"_127":24,"_36":156,"_13":136,"_32":137,"_34":138,"_23":24,"_129":-5,"_153":157,"_26":158},{"_41":125,"_31":27,"_29":30,"_126":-5,"_39":40,"_38":14,"_127":24,"_36":152,"_13":59,"_32":33,"_34":35,"_23":24,"_129":-5,"_153":154,"_26":155},["D",1766475584210],"children",[],[27],["D",1766475584196],[],[132],["D",1766471728216],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":53,"_97":98,"_99":24},{"_13":82,"_31":83,"_41":40,"_84":42,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":43,"_91":92},"ctx",{"_75":-5,"_120":196,"_197":198,"_199":200,"_201":24,"_202":24,"_203":24,"_204":205,"_206":-5,"_207":-7,"_208":-7,"_209":59,"_210":24,"_211":24,"_212":-5,"_213":24,"_214":24,"_215":24,"_216":-5},"ENV",{"_167":168,"_169":170,"_171":83,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets",true,"preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v5