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};",[],[181],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":195,"_99":32,"_161":186,"_163":72,"_165":22,"_166":-5,"_167":196,"_98":197},"94b8bdda-bca3-11ef-9810-e6cdfca9ef9f","fascinatingYellowRhinoceros","94b8be84-bca3-11ef-9810-e6cdfca9ef9f",108,["D",1734459623254],[],[192],{"_102":199,"_95":200,"_151":201,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":202,"_99":203,"_161":162,"_163":204,"_165":22,"_166":-5,"_167":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],{"_102":208,"_95":209,"_151":210,"_153":-5,"_154":136,"_155":211,"_157":158,"_104":212,"_99":213,"_161":162,"_163":214,"_165":22,"_166":-5,"_167":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",[148,170,179,190,198,207],"counts",{"_221":32,"_222":223,"_224":32,"_225":32},"pulls","branches",1,"forks","envVars","contents",[228,231,234,237,240,243],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":229,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":230},["D",1734459712225],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":174,"_157":158,"_104":232,"_99":32,"_161":162,"_163":176,"_165":22,"_166":-5,"_98":233},["D",1734107563618],[172],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":235,"_99":185,"_161":186,"_163":187,"_165":22,"_166":-5,"_98":236},["D",1734459204961],[181],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":238,"_99":32,"_161":186,"_163":72,"_165":22,"_166":-5,"_98":239},["D",1734459623254],[192],{"_102":199,"_95":200,"_151":201,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":241,"_99":203,"_161":162,"_163":204,"_165":22,"_166":-5,"_98":242},["D",1748698111328],[200],{"_102":208,"_95":209,"_151":210,"_153":-5,"_154":136,"_155":211,"_157":158,"_104":244,"_99":213,"_161":162,"_163":214,"_165":22,"_166":-5,"_98":245},["D",1734625195533],[209],"file","upstreamProject","upstreamBranch","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":255,"_226":260,"_273":-7,"_274":-5,"_275":-5,"_217":276,"_295":296},{"_102":103,"_95":96,"_104":256,"_106":-5,"_107":22,"_108":109,"_110":-5,"_111":-5,"_14":112,"_113":-5,"_114":22,"_115":-5,"_116":32,"_16":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":257,"_130":258,"_133":259,"_145":22},["D",1734103624902],{"_93":94,"_128":129},{"_93":94,"_132":129},{"_99":135,"_95":43,"_102":136,"_137":103,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},[261,263,265,267,269,271],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":229,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_98":262},[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":174,"_157":158,"_104":232,"_99":32,"_161":162,"_163":176,"_165":22,"_166":-5,"_98":264},[172],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":235,"_99":185,"_161":186,"_163":187,"_165":22,"_166":-5,"_98":266},[181],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":238,"_99":32,"_161":186,"_163":72,"_165":22,"_166":-5,"_98":268},[192],{"_102":199,"_95":200,"_151":201,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":241,"_99":203,"_161":162,"_163":204,"_165":22,"_166":-5,"_98":270},[200],{"_102":208,"_95":209,"_151":210,"_153":-5,"_154":136,"_155":211,"_157":158,"_104":244,"_99":213,"_161":162,"_163":214,"_165":22,"_166":-5,"_98":272},[209],"readme","upstream","pull",[277,280,283,286,289,292],{"_102":149,"_95":150,"_151":152,"_153":-5,"_154":136,"_155":156,"_157":158,"_104":159,"_99":160,"_161":162,"_163":164,"_165":22,"_166":-5,"_167":278,"_98":279},[],[150],{"_102":171,"_95":172,"_151":173,"_153":-5,"_154":136,"_155":174,"_157":158,"_104":175,"_99":32,"_161":162,"_163":176,"_165":22,"_166":-5,"_167":281,"_98":282},[],[172],{"_102":180,"_95":181,"_151":182,"_153":-5,"_154":136,"_155":183,"_157":158,"_104":184,"_99":185,"_161":186,"_163":187,"_165":22,"_166":-5,"_167":284,"_98":285},[],[181],{"_102":191,"_95":192,"_151":193,"_153":-5,"_154":136,"_155":194,"_157":158,"_104":195,"_99":32,"_161":186,"_163":72,"_165":22,"_166":-5,"_167":287,"_98":288},[],[192],{"_102":199,"_95":200,"_151":201,"_153":-5,"_154":136,"_155":135,"_157":158,"_104":202,"_99":203,"_161":162,"_163":204,"_165":22,"_166":-5,"_167":290,"_98":291},[],[200],{"_102":208,"_95":209,"_151":210,"_153":-5,"_154":136,"_155":211,"_157":158,"_104":212,"_99":213,"_161":162,"_163":214,"_165":22,"_166":-5,"_167":293,"_98":294},[],[209],"previews",[283,286],"actionData","errors"]