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};",[],[169],{"_104":179,"_95":99,"_140":180,"_142":-5,"_143":131,"_144":101,"_146":162,"_106":181,"_100":31,"_149":174,"_151":66,"_153":26,"_154":182,"_98":183},"94b8bdda-bca3-11ef-9810-e6cdfca9ef9f","94b8be84-bca3-11ef-9810-e6cdfca9ef9f",["D",1734459623254],[],[99],{"_104":185,"_95":186,"_140":187,"_142":-5,"_143":131,"_144":188,"_146":162,"_106":189,"_100":190,"_149":174,"_151":191,"_153":26,"_154":192,"_98":193},"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 );",[],[186],"counts",{"_196":31,"_197":198,"_199":31,"_200":31},"pulls","branches",1,"forks","envVars","contents",[],"file",{"_104":179,"_95":99,"_140":180,"_142":-5,"_143":131,"_144":101,"_146":162,"_106":205,"_100":31,"_149":174,"_151":66,"_153":26,"_98":206},["D",1734459623254],[99],"upstream","routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":41,"_100":101,"_98":99,"_102":210,"_203":214,"_201":216,"_207":-5,"_217":-5},{"_104":105,"_95":96,"_106":211,"_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":212,"_128":213},["D",1734103624902],{"_93":94,"_126":127},{"_100":130,"_95":41,"_104":131,"_132":105,"_133":-5,"_134":-5},{"_104":179,"_95":99,"_140":180,"_142":-5,"_143":131,"_144":101,"_146":162,"_106":205,"_100":31,"_149":174,"_151":66,"_153":26,"_98":215},[99],[],"pull","routes/_app","actionData","errors"]