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};",[],[177],{"_104":187,"_95":188,"_140":189,"_142":-5,"_143":131,"_144":190,"_145":160,"_106":191,"_100":31,"_148":182,"_150":66,"_151":26,"_152":192,"_98":193},"94b8bdda-bca3-11ef-9810-e6cdfca9ef9f","fascinatingYellowRhinoceros","94b8be84-bca3-11ef-9810-e6cdfca9ef9f",108,["D",1734459623254],[],[188],{"_104":195,"_95":196,"_140":197,"_142":-5,"_143":131,"_144":198,"_145":160,"_106":199,"_100":200,"_148":182,"_150":201,"_151":26,"_152":202,"_98":203},"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 );",[],[196],{"_104":205,"_95":206,"_140":207,"_142":-5,"_143":131,"_144":208,"_145":160,"_106":209,"_100":210,"_148":163,"_150":211,"_151":26,"_152":212,"_98":213},"157e617c-be25-11ef-8441-e6cdfca9ef9f","punctualBlackWildebeest","bdd9e35c-be23-11ef-96db-e6cdfca9ef9f",114,["D",1734625195533],3,"console.log(\"hi\");\n\nconsole.log(\"hi2\");",[],[206],"counts",{"_216":31,"_217":147,"_218":31,"_219":31},"pulls","branches","forks","envVars","contents",[],{"_104":168,"_95":99,"_140":169,"_142":-5,"_143":131,"_144":170,"_145":160,"_106":223,"_100":31,"_148":163,"_150":172,"_151":26,"_98":224},["D",1734107563618],[99],"upstream","routes/_app.x.$handle.$name.branch.$branch.version.$version.code.$",{"_93":94,"_95":96,"_97":41,"_100":101,"_98":99,"_102":228,"_149":232,"_220":234,"_225":-5,"_235":-5},{"_104":105,"_95":96,"_106":229,"_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":230,"_128":231},["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,"_145":160,"_106":223,"_100":31,"_148":163,"_150":172,"_151":26,"_98":233},[99],[],"pull","routes/_app","actionData","errors"]