[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_197":198,"_199":200},"routes/_app.x.$handle.$name",{"_102":101,"_32":50,"_111":92,"_27":112,"_13":14,"_113":-5,"_11":114,"_115":116,"_117":118,"_119":120,"_121":122,"_21":-5,"_123":-5,"_124":-5,"_125":25,"_126":127,"_128":25,"_129":-5,"_130":-5,"_131":132},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_38":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",5,"changes",[19,20],"aiChatInfo","userId",{"_21":43,"_23":-7,"_24":25,"_26":25,"_27":44,"_29":44},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous","deleted",false,"deletedHere","path","frontend/Leaderboard.tsx","latestPath","fileId","982e9a5e-5eb7-11f1-8d92-1607ee4eb77e","name","Leaderboard.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { LeaderboardRow } from \"../backend/db.ts\";\n\nconst medal = (rank: number) =>\n rank === 1 ? \"🥇\" : rank === 2 ? \"🥈\" : rank === 3 ? \"🥉\" : `${rank}`;\n\nfunction Row({ row, rank }: { row: LeaderboardRow; rank: number }) {\n return (\n \n \n {medal(rank)}\n \n \n

\n {row.player1} & {row.player2}\n

Game #{row.game_id}

\n \n \n {row.completed_turns}\n \n \n \n {row.avg_speed_score ?? \"—\"}\n \n \n \n );\n}\n\nexport function Leaderboard({ rows }: { rows: LeaderboardRow[] }) {\n return (\n

\n 🌊 Wavelink Leaderboard\n

\n Top 10 games by completed turns, tie-broken by average speed score\n

\n\n

\n \n \n \n \n \n \n \n \n \n \n {rows.length === 0 ? (\n \n \n \n ) : (\n rows.map((row, i) => (\n \n ))\n )}\n \n

Rank	Players	\n Completed turns\n	\n Avg speed\n
\n No games found yet.\n

\n\n \n

\n );\n}\n","createdAt",["D",1780427805019],"branchVersion","branchId","397a77ee-5eb7-11f1-86fe-1607ee4eb77e",{"_30":45,"_32":44,"_34":46,"_36":-5,"_38":47,"_40":14,"_41":42,"_24":25},"frontend","81f26c2f-dd3b-4b1a-a78e-165a5ce919bf","directory",["D",1780427805019],"id","3979cd94-5eb7-11f1-86fe-1607ee4eb77e","wavelink-stats",["D",1780427646150],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Wavelink word game leaderboard / stats dashboard","imageUrl","4672fa32-1c6f-4907-899e-57b7e45b1dcb","pinnedFileId","9d5d78a6-5eb7-11f1-8583-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019e83d1-d41f-725b-9693-b632d430a029","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_102":101,"_110":106},"org",{"_102":101,"_103":104,"_105":106,"_18":60,"_107":108,"_109":25},"branch",{"_13":91,"_32":92,"_48":42,"_93":49,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":50,"_100":101},"isOwned",7,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","potluck","handle","displayName","Potluck Mittal","avatar","https://lh3.googleusercontent.com/a/ACg8ocJYeiSQ8_eyVYtUAg9f5qRwEXzS1AreFm572a1csvZx7c6b_S8=s96-c","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_38":193,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":-5,"_72":-5,"_73":-5,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":194,"_86":195,"_88":196,"_90":25},"tree",[167,169,171],"files",[167,168,169,170,171],"counts",{"_156":68,"_157":158,"_159":68,"_160":161,"_162":163},"contents",[133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":150,"_32":151,"_30":152,"_139":-5,"_41":42,"_40":153,"_141":64,"_38":154,"_13":68,"_34":46,"_36":-5,"_24":25,"_145":-5,"_27":155},{"_48":147,"_32":44,"_30":45,"_139":-5,"_41":42,"_40":14,"_141":64,"_38":148,"_13":68,"_34":46,"_36":-5,"_24":25,"_145":-5,"_27":149},{"_48":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_34":35,"_36":144,"_24":25,"_145":-5,"_27":146},"7ae8ea80-5eb7-11f1-a35c-1607ee4eb77e","introspect.ts","64b7982e-5eb7-11f1-86f1-1607ee4eb77e","parentId",3,"latest",["D",1780427755877],2,"import postgres from \"npm:postgres\";\n\nconst sql = postgres(Deno.env.get(\"WAVELINK_DB_URL\")!, { prepare: false });\n\nconst tables = [\"users\", \"games\", \"pairs\", \"turns\", \"submissions\"];\nconst cols = await sql`\n select table_name, column_name, data_type\n from information_schema.columns\n where table_schema = 'public'\n and table_name in ${sql(tables)}\n order by table_name, ordinal_position\n`;\n\nconst byTable: Record = {};\nfor (const r of cols) {\n (byTable[r.table_name] ??= []).push(`${r.column_name} (${r.data_type})`);\n}\nfor (const t of tables) {\n console.log(`\\n=== ${t} ===`);\n console.log((byTable[t] ?? [\"\"]).join(\"\\n\"));\n}\n\nawait sql.end();\n","label",[137],"982ed38e-5eb7-11f1-8d92-1607ee4eb77e",["D",1780427805019],[44],"8f707072-5eb7-11f1-8167-1607ee4eb77e","backend","5a619fc4-787b-4d43-bf5f-520e1d02f906",4,["D",1780427790340],[151],"pulls","branches",1,"forks","envVars",{"_164":158,"_166":68},"connections",{"_164":158,"_165":68},"count","unfilledCount","emptyCount",{"_48":150,"_32":151,"_30":152,"_139":-5,"_41":42,"_40":153,"_141":64,"_38":190,"_13":68,"_34":46,"_36":-5,"_24":25,"_145":-5,"_173":191,"_27":192},{"_48":183,"_32":184,"_30":185,"_139":152,"_41":42,"_40":153,"_141":64,"_38":186,"_13":68,"_34":35,"_36":187,"_24":25,"_145":-5,"_173":188,"_27":189},{"_48":147,"_32":44,"_30":45,"_139":-5,"_41":42,"_40":14,"_141":64,"_38":180,"_13":68,"_34":46,"_36":-5,"_24":25,"_145":-5,"_173":181,"_27":182},{"_48":176,"_32":33,"_30":31,"_139":45,"_41":42,"_40":14,"_141":64,"_38":177,"_13":68,"_34":35,"_36":37,"_24":25,"_145":-5,"_173":178,"_27":179},{"_48":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":172,"_13":143,"_34":35,"_36":144,"_24":25,"_145":-5,"_173":174,"_27":175},["D",1780427755877],"children",[],[137],"982e9982-5eb7-11f1-8d92-1607ee4eb77e",["D",1780427805019],[],[44,33],["D",1780427805019],[170],[44],"8f703c4c-5eb7-11f1-8167-1607ee4eb77e","db.ts","8f703d28-5eb7-11f1-8167-1607ee4eb77e",["D",1780427790340],"import postgres from \"npm:postgres\";\n\nexport interface LeaderboardRow {\n game_id: number;\n player1: string;\n player2: string;\n completed_turns: number;\n avg_speed_score: number | null;\n}\n\n// A single shared connection. `prepare: false` is required for Neon's\n// pooled (pgbouncer) endpoint.\nconst sql = postgres(Deno.env.get(\"WAVELINK_DB_URL\")!, { prepare: false });\n\n/**\n * Top 10 games ranked by number of completed turns, then by average\n * speed_score. A turn counts as \"completed\" when completed_at is set, and the\n * average speed_score is taken over those completed turns only.\n */\nexport async function getLeaderboard(): Promise {\n return await sql`\n select\n g.id as game_id,\n u1.name as player1,\n u2.name as player2,\n count(t.id) filter (where t.completed_at is not null)::int\n as completed_turns,\n round(\n avg(t.speed_score) filter (where t.completed_at is not null), 1\n )::float as avg_speed_score\n from games g\n join users u1 on u1.id = g.user_id1\n join users u2 on u2.id = g.user_id2\n left join turns t on t.game_id = g.id\n group by g.id, u1.name, u2.name\n order by completed_turns desc, avg_speed_score desc nulls last\n limit 10\n `;\n}\n",[],[151,184],["D",1780427790340],[168],[151],["D",1780427646150],{"_102":101,"_110":106},{"_102":101,"_103":104,"_105":106,"_18":60,"_107":108,"_109":25},{"_13":91,"_32":92,"_48":42,"_93":49,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":-5,"_99":50,"_100":101},"ctx",{"_84":-5,"_130":230,"_231":232,"_233":234,"_235":25,"_236":25,"_237":25,"_238":64,"_239":-5,"_240":-7,"_241":-7,"_242":68,"_243":25,"_244":25,"_245":-5,"_246":25,"_247":25,"_248":25,"_249":-5},"ENV",{"_201":202,"_203":204,"_205":92,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225,"_226":227,"_228":229},"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","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v5