Detect Secrets

\n {results.map(result => (\n

\n {result.name}\n \n {result.pass ? \"✓\" : \"✕\"}\n \n

\n {result.pass\n ? null\n : (\n

\n          Input: {JSON.stringify(result.input)}{\"\\n\"}\n          Expected: {JSON.stringify(result.expected)}{\"\\n\"}\n          Output: {JSON.stringify(result.output)}{\"\\n\"}\n

\n )}\n

\n ))}\n

,\n ),\n {\n headers: {\n \"content-type\": \"text/html\",\n },\n },\n );\n};",[],[182],{"_103":192,"_95":99,"_152":193,"_154":-5,"_155":137,"_156":194,"_158":159,"_105":195,"_100":32,"_162":187,"_164":72,"_166":22,"_167":-5,"_168":196,"_98":197},"94b8bdda-bca3-11ef-9810-e6cdfca9ef9f","94b8be84-bca3-11ef-9810-e6cdfca9ef9f",108,["D",1734459623254],[],[99],{"_103":199,"_95":200,"_152":201,"_154":-5,"_155":137,"_156":136,"_158":159,"_105":202,"_100":203,"_162":163,"_164":204,"_166":22,"_167":-5,"_168":205,"_98":206},"24f6aa50-3e23-11f0-a120-76b3cceeab13","index","b52b7f7a-b966-11ef-b059-e6cdfca9ef9f",["D",1748698111328],55,"import { zip } from \"https://esm.town/v/pomdtr/sql\";\nimport { db } from \"https://esm.town/v/sqlite/db\";\nimport detectSecrets from \"./detectSecrets\";\n\n// const res = await db.execute(\n// `SELECT author_username, name, code\n// from vals\n// where code NOT like '// set%'\n// order by version desc\n// limit 10`,\n// );\n\n// const res = await db.execute(\n// `SELECT created_at\n// from vals\n// where code NOT like '// set%'\n// order by created_at desc\n// limit 10`,\n// );\n\nconst res = await db.execute(\n `SELECT author_username, name, code\n from vals\n where code NOT like '// set%'\n limit 3000\n offset 3000`,\n);\nconst rows = zip(res);\n\nconst scannedCode = rows.map(\n row => ({\n ...row,\n code: undefined, // hide from screen for now\n secrets: detectSecrets(row.code),\n }),\n).filter(row => row.secrets.length > 0);\n\nconst secrets = scannedCode.flatMap(row =>\n row.secrets.map(s => ({\n ...s,\n link: `https://val.town/v/${row.author_username}/${row.name}`,\n }))\n);\n\nexport default () =>\n Response.json(\n secrets.sort((a, b) => b.likelihood - a.likelihood)\n .slice(0, 100),\n );",[],[200],{"_103":208,"_95":209,"_152":210,"_154":-5,"_155":137,"_156":211,"_158":159,"_105":212,"_100":213,"_162":163,"_164":214,"_166":22,"_167":-5,"_168":215,"_98":216},"157e617c-be25-11ef-8441-e6cdfca9ef9f","punctualBlackWildebeest","bdd9e35c-be23-11ef-96db-e6cdfca9ef9f",114,["D",1734625195533],3,"console.log(\"hi\");\n\nconsole.log(\"hi2\");",[],[209],"files",[149,171,180,191,198,207],"counts",{"_221":32,"_222":223,"_224":32,"_225":32},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_103":192,"_95":99,"_152":193,"_154":-5,"_155":137,"_156":194,"_158":159,"_105":230,"_100":32,"_162":187,"_164":72,"_166":22,"_167":-5,"_98":231},["D",1734459623254],[99],"upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name.code.$",{"_93":94,"_95":96,"_97":43,"_100":-7,"_98":99,"_101":240,"_147":245,"_217":264,"_228":265,"_226":267,"_268":-5,"_269":22,"_270":-5,"_271":-5,"_272":-5,"_273":274},{"_103":104,"_95":96,"_105":241,"_107":-5,"_108":22,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":22,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":242,"_131":243,"_134":244,"_146":22},["D",1734103624902],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_100":136,"_95":43,"_103":137,"_138":104,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},[246,249,252,255,258,261],{"_103":150,"_95":151,"_152":153,"_154":-5,"_155":137,"_156":157,"_158":159,"_105":160,"_100":161,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":247,"_98":248},[],[151],{"_103":172,"_95":173,"_152":174,"_154":-5,"_155":137,"_156":175,"_158":159,"_105":176,"_100":32,"_162":163,"_164":177,"_166":22,"_167":-5,"_168":250,"_98":251},[],[173],{"_103":181,"_95":182,"_152":183,"_154":-5,"_155":137,"_156":184,"_158":159,"_105":185,"_100":186,"_162":187,"_164":188,"_166":22,"_167":-5,"_168":253,"_98":254},[],[182],{"_103":192,"_95":99,"_152":193,"_154":-5,"_155":137,"_156":194,"_158":159,"_105":195,"_100":32,"_162":187,"_164":72,"_166":22,"_167":-5,"_168":256,"_98":257},[],[99],{"_103":199,"_95":200,"_152":201,"_154":-5,"_155":137,"_156":136,"_158":159,"_105":202,"_100":203,"_162":163,"_164":204,"_166":22,"_167":-5,"_168":259,"_98":260},[],[200],{"_103":208,"_95":209,"_152":210,"_154":-5,"_155":137,"_156":211,"_158":159,"_105":212,"_100":213,"_162":163,"_164":214,"_166":22,"_167":-5,"_168":262,"_98":263},[],[209],[246,249,252,255,258,261],{"_103":192,"_95":99,"_152":193,"_154":-5,"_155":137,"_156":194,"_158":159,"_105":230,"_100":32,"_162":187,"_164":72,"_166":22,"_167":-5,"_98":266},[99],[],"upstream","showCompareCallout","pull","ahead","behind","templates",[],"actionData","errors"]