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};",[],[99],{"_104":178,"_95":179,"_140":180,"_142":-5,"_143":131,"_144":181,"_146":147,"_106":182,"_100":31,"_150":173,"_152":66,"_154":26,"_155":183,"_98":184},"94b8bdda-bca3-11ef-9810-e6cdfca9ef9f","fascinatingYellowRhinoceros","94b8be84-bca3-11ef-9810-e6cdfca9ef9f",108,["D",1734459623254],[],[179],{"_104":186,"_95":187,"_140":188,"_142":-5,"_143":131,"_144":189,"_146":147,"_106":190,"_100":191,"_150":173,"_152":192,"_154":26,"_155":193,"_98":194},"d01142ec-b980-11ef-bd9a-e6cdfca9ef9f","index","b52b7f7a-b966-11ef-b059-e6cdfca9ef9f",104,["D",1734114836945],54,"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 );",[],[187],{"_104":196,"_95":197,"_140":198,"_142":-5,"_143":131,"_144":101,"_146":147,"_106":199,"_100":200,"_150":151,"_152":201,"_154":26,"_155":202,"_98":203},"157e617c-be25-11ef-8441-e6cdfca9ef9f","punctualBlackWildebeest","bdd9e35c-be23-11ef-96db-e6cdfca9ef9f",["D",1734625195533],3,"console.log(\"hi\");\n\nconsole.log(\"hi2\");",[],[197],"counts",{"_206":31,"_207":208,"_209":31,"_210":31},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_104":168,"_95":99,"_140":169,"_142":-5,"_143":131,"_144":170,"_146":147,"_106":215,"_100":172,"_150":173,"_152":174,"_154":26,"_98":216},["D",1734459204961],[99],"upstream","routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":41,"_100":101,"_98":99,"_102":220,"_213":224,"_211":226,"_217":-5,"_227":-5},{"_104":105,"_95":96,"_106":221,"_108":-5,"_109":110,"_111":-5,"_112":-5,"_11":113,"_114":-5,"_115":26,"_116":117,"_118":117,"_119":120,"_121":120,"_122":120,"_123":117,"_124":26,"_20":222,"_128":223},["D",1734103624902],{"_93":94,"_126":127},{"_100":130,"_95":41,"_104":131,"_132":105,"_133":-5,"_134":-5},{"_104":168,"_95":99,"_140":169,"_142":-5,"_143":131,"_144":170,"_146":147,"_106":215,"_100":172,"_150":173,"_152":174,"_154":26,"_98":225},[99],[],"pull","routes/_app","actionData","errors"]