[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_466":467,"_468":469},"routes/_app.x.$handle.$name",{"_105":104,"_32":45,"_114":91,"_27":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_20":-5,"_126":127,"_128":129,"_130":49,"_131":132,"_133":25,"_134":-5,"_135":-5,"_136":137},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":49},"version",86,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",true,"deletedHere","path","backend/db.ts","latestPath","fileId","019f4e53-354b-724f-878e-a3cc99eb9dc9","name","db.ts","fileType","script","content","import sqlite from \"https://esm.town/v/std/db/main.ts\";\nimport { CLAIMED_OUTPUT } from \"../shared/types.ts\";\n\nconst TABLE_NAME = \"leads\";\n\nawait createTable();\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\nexport async function createProcessingLead(\n inputData: Record,\n): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, input_data, output_data)\n VALUES (?, ?, ?)`,\n [Date.now(), JSON.stringify(inputData), \"\"],\n );\n return Number(result.lastInsertRowid);\n}\n\n// Atomically claim a just-created lead for scoring. Returns false if the\n// lead doesn't exist or was already claimed/finished, so concurrent /process\n// calls can't double-score (and double-spend on) the same lead.\nexport async function claimLead(id: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ? AND output_data = ''`,\n [CLAIMED_OUTPUT, id],\n );\n return result.rowsAffected > 0;\n}\n\nexport async function updateLeadOutput(\n id: number,\n outputData: Record,\n) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ?`,\n [JSON.stringify(outputData), id],\n );\n}\n\nexport async function getAllLeads(): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} ORDER BY timestamp DESC`,\n );\n return rowsToLeads(result);\n}\n\nexport async function getLeadById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME} WHERE id = ?`,\n [id],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Find an existing lead by the github_username stored in its input, so the\n// GitHub cron appends new activity to the same person instead of creating a\n// duplicate lead.\nexport async function findLeadByGithubUsername(\n login: string,\n): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TABLE_NAME}\n WHERE json_extract(input_data, '$.github_username') = ?`,\n [login],\n );\n const leads = rowsToLeads(result);\n return leads[0] || null;\n}\n\n// Append new GitHub events to an existing lead's input, deduplicated by\n// event id so repeat sweeps don't grow the lead unboundedly.\nexport async function appendFollowup(\n id: number,\n newEvents: Array<{ id?: string }>,\n) {\n const lead = await getLeadById(id);\n if (!lead) return;\n const input = JSON.parse(lead.input_data);\n const events: Array<{ id?: string }> = Array.isArray(input.events) ? input.events : [];\n const existingIds = new Set(events.map((e) => e.id).filter(Boolean));\n events.push(...newEvents.filter((e) => !e.id || !existingIds.has(e.id)));\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET input_data = ? WHERE id = ?`,\n [JSON.stringify({ ...input, events }), id],\n );\n}\n\nfunction rowsToLeads(result: { columns: string[]; rows: unknown[] }): Lead[] {\n return result.rows.map((row: any) => {\n const obj: Record = {};\n result.columns.forEach((col, idx) => {\n obj[col] = row[idx];\n });\n return obj as Lead;\n });\n}\n\nasync function createTable() {\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n timestamp INTEGER NOT NULL,\n input_data TEXT NOT NULL,\n output_data TEXT NOT NULL\n )`,\n );\n}\n\nexport function isProcessing(lead: Lead): boolean {\n return lead.output_data === \"\" || lead.output_data === CLAIMED_OUTPUT;\n}\n\nexport function isFailed(lead: Lead): boolean {\n if (isProcessing(lead)) return false;\n try {\n return Boolean(JSON.parse(lead.output_data).error);\n } catch {\n return true;\n }\n}\n","createdAt",["D",1784148427921],"branchVersion","branchId","3707f499-097d-4e07-a507-b21e0bcfbbb0","id","1248533c-8cdc-4f42-9610-73e9cbc5e37d","dbpro-leads",["D",1783725503703],"deletedAt","legacyEnvVars",false,"privacy","public","httpPrivacy","description","GitHub lead qualification for DB Pro / Mira","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789549199&sig=d54b8f4321c3c4c5ef0f5ef6df79b4950fde1dc8fe81ea79059f2ca922e3cdef","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019f4e53-354b-724f-878e-e9177d5c065a","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","ba7bb5fb-1abb-4ffb-8f3d-7c244782e5f7","tursoName","1248533c8cdc4f42961073e9cbc5e37d","tursoHostname","1248533c8cdc4f42961073e9cbc5e37d-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789526460011],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_18":-5,"_110":111,"_112":25},"branch",{"_13":90,"_32":91,"_43":42,"_92":44,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":45,"_103":104},"isOwned",166,"main","projectId","forkedBranchId","2beae49c-ed74-11f0-997b-42dde27851f2","forkedBranchVersion",144,"forkedProjectPrivacy","forkedProjectId","2be6e306-ed74-11f0-997b-42dde27851f2","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","valdottown","handle","displayName","Val Town ","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJyWnQ5cFE0c3pleVRCSEVTWmxzaXJsTUlGciJ9","tier","business","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":461,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":25,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":462,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":463,"_85":464,"_87":465,"_89":49},"tree",[230,234,243,245,252,255,258,260,261],"files",[230,231,232,233,234,235,236,237,238,239,240,241,242,243,244,245,246,247,248,249,250,251,252,253,254,255,256,257,258,259,260,261],"counts",{"_219":64,"_220":166,"_221":64,"_222":223,"_224":225},"contents",[151,152,153,154,155,156,157,158,159],"upstreamProject",{"_43":99,"_32":147,"_53":148,"_55":56,"_50":51,"_83":149},"upstreamBranch",{"_43":94,"_38":138,"_139":140,"_32":91,"_92":99,"_13":141,"_93":142,"_95":143,"_144":145,"_47":-5,"_89":49,"_50":51,"_103":146,"_65":101,"_102":147},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1767974365657],"updatedAt",["D",1783726173324],146,"6b736e3c-daf9-11f0-9e58-42dde27851f2",138,"lockfileKey","1783726173402-esm.town_v_templates_github-leads@146-main","templates","github-leads","Find customers to sell to from GitHub activity",{"_105":146,"_113":150},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789549199&sig=85ec03bbe2ae9af315fa5e89fceebe840b59020b3ec43df39e2ab37ef0d215ad",{"_43":214,"_32":215,"_30":216,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":217,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":218},{"_43":209,"_32":210,"_30":211,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":212,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":213},{"_43":203,"_32":204,"_30":205,"_162":-5,"_41":42,"_40":206,"_164":25,"_38":207,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":208},{"_43":197,"_32":198,"_30":199,"_162":-5,"_41":42,"_40":200,"_164":25,"_38":201,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":202},{"_43":191,"_32":192,"_30":193,"_162":-5,"_41":42,"_40":194,"_164":25,"_38":195,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":196},{"_43":186,"_32":187,"_30":188,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":189,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":190},{"_43":179,"_32":180,"_30":181,"_162":-5,"_41":42,"_40":182,"_164":25,"_38":183,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_27":185},{"_43":171,"_32":172,"_30":173,"_162":-5,"_41":42,"_40":174,"_164":49,"_38":175,"_13":176,"_34":20,"_36":177,"_24":49,"_169":-5,"_27":178},{"_43":160,"_32":161,"_30":59,"_162":-5,"_41":42,"_40":163,"_164":25,"_38":165,"_13":166,"_34":167,"_36":168,"_24":49,"_169":-5,"_27":170},"cb7ac0dc-3fb4-4c02-a9cb-9ecb78681cc9","main.ts","parentId",75,"latest",["D",1784148366847],1,"http","// http: entrypoint — the dashboard, wrapped in Val Town OAuth.\nimport { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport app from \"./outputs/dashboard/server.ts\";\n\nexport default oauthMiddleware(app.fetch);\n","label",[161],"5f7724aa-340b-47e8-aea8-316401870895","README.md","019f4e53-354b-724f-878e-e330fea73434",79,["D",1784148394313],5,"# GitHub Leads\n\nWatches Mira's GitHub. When someone new stars, forks, or opens an issue, AI\nresearches who they are — name, company, size — and writes a lead card with a\nsuggested opener. Qualified leads ping Slack.\n\n```mermaid\nflowchart LR\n A[\"inputs/github.ts\"] --> B[(\"leads\")]\n B --> C[\"processing/qualify.ts\"]\n C --> B\n B --> D[\"outputs/slack.ts\"]\n B --> E[\"outputs/dashboard\"]\n```\n\n## Customizing\n\n| to change... | edit... |\n| ------------------------- | ------------------------------------------------- |\n| who counts as a good lead | [processing/PROMPT.md](./processing/PROMPT.md) |\n| which repos we watch | the top of [inputs/github.ts](./inputs/github.ts) |\n| where leads go | add a file to [outputs/](./outputs/) |\n| where leads come from | add a file to [inputs/](./inputs/) |\n\n## Environment variables\n\n- **`GITHUB_TOKEN`** (required) — we poll the watched repos' public activity\n hourly, and GitHub allows only 60 unauthenticated requests per hour per IP —\n a budget Val Town's shared IPs burn through. A token gives this val its own\n 5,000/hour. It reads only public data, so it needs **no scopes**:\n [create it prefilled](https://github.com/settings/tokens/new?description=github-leads&scopes=),\n then [set it](/environment-variables?key=GITHUB_TOKEN)\n- **`OPENAI_API_KEY`** (optional) — research and card writing (gpt-5 with web\n search). Without it we use Val Town's built-in OpenAI proxy, which covers\n day-to-day lead volume (~100/day cap). Set your own key to backfill history:\n [get a key](https://platform.openai.com/api-keys), then\n [set it](/environment-variables?key=OPENAI_API_KEY). Each lead costs roughly\n $0.05.\n- **`SLACK_WEBHOOK_URL`** (optional) — qualified-lead pings. Without it, leads\n still land in the dashboard, just no notifications.\n [Create an incoming webhook](https://docs.val.town/guides/slack/send-messages-to-slack/),\n then [set it](/environment-variables?key=SLACK_WEBHOOK_URL)",[172],"319c428c-c8b0-4785-acdf-41faa385294a","utils","d3b96674-808d-11f1-a2d7-1607ee4eb77e",64,["D",1784148205583],"directory",[180],"63665ad5-7dc7-479b-b2fe-d8168e44182b","shared","019f4e53-354b-724f-878e-d9f9de0d3c67",["D",1783725503703],[187],"97ff939e-0e50-48e9-92b2-e1b330d488a3","processing","d2df6c9e-808d-11f1-978e-1607ee4eb77e",62,["D",1784148204143],[192],"239f795e-2e46-4c93-aee0-2b877abd7c36","outputs","d352efc0-808d-11f1-96e7-1607ee4eb77e",63,["D",1784148204925],[198],"a9ae1a9b-3628-4c21-b06f-02f2e1b999e0","inputs","d292f7ec-808d-11f1-8cb9-1607ee4eb77e",61,["D",1784148203624],[204],"40906d12-a9ec-4c9a-9826-65891e5764da","frontend","019f4e53-354b-724f-878e-d1b873bb8e72",["D",1783725503703],[210],"21e2f7d9-0c78-407f-bbdf-972ab523f472","backend","019f4e53-354b-724f-878e-acd986d56452",["D",1783725503703],[215],"pulls","branches","forks","envVars",{"_226":228,"_229":64},"connections",{"_226":166,"_227":64},"count","unfilledCount",3,"emptyCount",{"_43":214,"_32":215,"_30":216,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":458,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":459,"_27":460},{"_43":450,"_32":344,"_30":451,"_162":216,"_41":42,"_40":452,"_164":49,"_38":453,"_13":454,"_34":35,"_36":455,"_24":49,"_169":-5,"_263":456,"_27":457},{"_43":442,"_32":443,"_30":444,"_162":216,"_41":42,"_40":445,"_164":49,"_38":446,"_13":228,"_34":35,"_36":447,"_24":49,"_169":-5,"_263":448,"_27":449},{"_43":435,"_32":436,"_30":437,"_162":216,"_41":42,"_40":166,"_164":49,"_38":438,"_13":64,"_34":35,"_36":439,"_24":49,"_169":-5,"_263":440,"_27":441},{"_43":209,"_32":210,"_30":211,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":432,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":433,"_27":434},{"_43":428,"_32":399,"_30":394,"_162":211,"_41":42,"_40":166,"_164":49,"_38":429,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":430,"_27":431},{"_43":421,"_32":422,"_30":423,"_162":394,"_41":42,"_40":166,"_164":49,"_38":424,"_13":64,"_34":35,"_36":425,"_24":49,"_169":-5,"_263":426,"_27":427},{"_43":414,"_32":415,"_30":416,"_162":394,"_41":42,"_40":166,"_164":49,"_38":417,"_13":64,"_34":35,"_36":418,"_24":49,"_169":-5,"_263":419,"_27":420},{"_43":407,"_32":408,"_30":409,"_162":394,"_41":42,"_40":166,"_164":49,"_38":410,"_13":64,"_34":35,"_36":411,"_24":49,"_169":-5,"_263":412,"_27":413},{"_43":400,"_32":401,"_30":402,"_162":394,"_41":42,"_40":166,"_164":49,"_38":403,"_13":64,"_34":35,"_36":404,"_24":49,"_169":-5,"_263":405,"_27":406},{"_43":391,"_32":392,"_30":393,"_162":394,"_41":42,"_40":166,"_164":49,"_38":395,"_13":64,"_34":35,"_36":396,"_24":49,"_169":-5,"_263":397,"_27":398},{"_43":385,"_32":336,"_30":386,"_162":211,"_41":42,"_40":166,"_164":49,"_38":387,"_13":64,"_34":20,"_36":388,"_24":49,"_169":-5,"_263":389,"_27":390},{"_43":378,"_32":379,"_30":380,"_162":211,"_41":42,"_40":166,"_164":49,"_38":381,"_13":64,"_34":35,"_36":382,"_24":49,"_169":-5,"_263":383,"_27":384},{"_43":203,"_32":204,"_30":205,"_162":-5,"_41":42,"_40":206,"_164":25,"_38":375,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":376,"_27":377},{"_43":367,"_32":368,"_30":369,"_162":205,"_41":42,"_40":370,"_164":25,"_38":371,"_13":166,"_34":302,"_36":372,"_24":49,"_169":-5,"_263":373,"_27":374},{"_43":197,"_32":198,"_30":199,"_162":-5,"_41":42,"_40":200,"_164":25,"_38":364,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":365,"_27":366},{"_43":359,"_32":334,"_30":328,"_162":199,"_41":42,"_40":360,"_164":25,"_38":361,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":362,"_27":363},{"_43":351,"_32":352,"_30":353,"_162":328,"_41":42,"_40":354,"_164":49,"_38":355,"_13":64,"_34":35,"_36":356,"_24":49,"_169":-5,"_263":357,"_27":358},{"_43":343,"_32":344,"_30":345,"_162":328,"_41":42,"_40":346,"_164":49,"_38":347,"_13":64,"_34":35,"_36":348,"_24":49,"_169":-5,"_263":349,"_27":350},{"_43":335,"_32":336,"_30":337,"_162":328,"_41":42,"_40":338,"_164":49,"_38":339,"_13":64,"_34":20,"_36":340,"_24":49,"_169":-5,"_263":341,"_27":342},{"_43":325,"_32":326,"_30":327,"_162":328,"_41":42,"_40":329,"_164":49,"_38":330,"_13":64,"_34":35,"_36":331,"_24":49,"_169":-5,"_263":332,"_27":333},{"_43":317,"_32":318,"_30":319,"_162":199,"_41":42,"_40":320,"_164":49,"_38":321,"_13":166,"_34":302,"_36":322,"_24":49,"_169":-5,"_263":323,"_27":324},{"_43":191,"_32":192,"_30":193,"_162":-5,"_41":42,"_40":194,"_164":25,"_38":314,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":315,"_27":316},{"_43":306,"_32":307,"_30":308,"_162":193,"_41":42,"_40":309,"_164":49,"_38":310,"_13":64,"_34":20,"_36":311,"_24":49,"_169":-5,"_263":312,"_27":313},{"_43":297,"_32":298,"_30":299,"_162":193,"_41":42,"_40":300,"_164":49,"_38":301,"_13":166,"_34":302,"_36":303,"_24":49,"_169":-5,"_263":304,"_27":305},{"_43":186,"_32":187,"_30":188,"_162":-5,"_41":42,"_40":166,"_164":49,"_38":294,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":295,"_27":296},{"_43":286,"_32":287,"_30":288,"_162":188,"_41":42,"_40":289,"_164":49,"_38":290,"_13":64,"_34":35,"_36":291,"_24":49,"_169":-5,"_263":292,"_27":293},{"_43":279,"_32":280,"_30":281,"_162":188,"_41":42,"_40":166,"_164":49,"_38":282,"_13":64,"_34":35,"_36":283,"_24":49,"_169":-5,"_263":284,"_27":285},{"_43":179,"_32":180,"_30":181,"_162":-5,"_41":42,"_40":182,"_164":25,"_38":276,"_13":64,"_34":184,"_36":-5,"_24":49,"_169":-5,"_263":277,"_27":278},{"_43":269,"_32":33,"_30":270,"_162":181,"_41":42,"_40":271,"_164":49,"_38":272,"_13":64,"_34":35,"_36":273,"_24":49,"_169":-5,"_263":274,"_27":275},{"_43":171,"_32":172,"_30":173,"_162":-5,"_41":42,"_40":174,"_164":49,"_38":266,"_13":176,"_34":20,"_36":177,"_24":49,"_169":-5,"_263":267,"_27":268},{"_43":160,"_32":161,"_30":59,"_162":-5,"_41":42,"_40":163,"_164":25,"_38":262,"_13":166,"_34":167,"_36":168,"_24":49,"_169":-5,"_263":264,"_27":265},["D",1784148366847],"children",[],[161],["D",1784148394313],[],[172],"0ab91abd-2b7f-47ad-af7e-2f7da2ef9a59","e0a0b13a-808d-11f1-8fff-1607ee4eb77e",65,["D",1784148227242],"// The leads table: every person who ever touched the watched repos, and\n// where they are in the pipeline (pending → done/error).\nimport sqlite from \"https://esm.town/v/std/db/main.ts\";\n\n// TODO(steve): rename to \"leads\" once the old leads table is deleted.\nconst TABLE = \"leads_v2\";\n\nexport interface LeadRow {\n login: string;\n activity: string | null; // JSON: [{ type, repo, when?, title? }]\n email: string | null;\n status: \"pending\" | \"scoring\" | \"done\" | \"error\";\n verdict: \"MESSAGE\" | \"WATCH\" | \"IGNORE\" | \"NEEDS_ID\" | null;\n card: string | null; // markdown lead card\n error: string | null;\n flagged: string | null; // e.g. \"maintainer?\" — needs a human look, not scoring\n created_at: number;\n scored_at: number | null;\n notified_at: number | null;\n}\n\nawait sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE} (\n login TEXT PRIMARY KEY,\n activity TEXT,\n email TEXT,\n status TEXT NOT NULL DEFAULT 'pending',\n verdict TEXT,\n card TEXT,\n error TEXT,\n flagged TEXT,\n created_at INTEGER,\n scored_at INTEGER,\n notified_at INTEGER\n )`,\n);\n\n// New person enters the pipeline. Returns false if we already know them.\nexport async function insertPending(\n login: string,\n activity: unknown[],\n opts: { email?: string; flagged?: string } = {},\n): Promise {\n const result = await sqlite.execute(\n `INSERT OR IGNORE INTO ${TABLE} (login, activity, email, status, flagged, created_at)\n VALUES (?, ?, ?, 'pending', ?, ?)`,\n [login, JSON.stringify(activity), opts.email ?? null, opts.flagged ?? null, Date.now()],\n );\n return result.rowsAffected > 0;\n}\n\n// Atomically claim the oldest pending lead for scoring; null when queue empty.\nexport async function claimNext(): Promise {\n const next = await sqlite.execute(\n `SELECT login FROM ${TABLE} WHERE status = 'pending' AND flagged IS NULL\n ORDER BY created_at LIMIT 1`,\n );\n const login = (next.rows[0] as any)?.login ?? (next.rows[0] as any)?.[0];\n if (!login) return null;\n const claimed = await sqlite.execute(\n `UPDATE ${TABLE} SET status = 'scoring' WHERE login = ? AND status = 'pending'`,\n [login],\n );\n if (claimed.rowsAffected === 0) return null; // raced; caller just tries again next tick\n return await getLead(login);\n}\n\nexport async function finishLead(login: string, verdict: string | null, card: string) {\n await sqlite.execute(\n `UPDATE ${TABLE} SET status = 'done', verdict = ?, card = ?, error = NULL, scored_at = ? WHERE login = ?`,\n [verdict, card, Date.now(), login],\n );\n}\n\nexport async function failLead(login: string, error: string) {\n // Back to pending so the next tick retries; keep the error for visibility.\n await sqlite.execute(\n `UPDATE ${TABLE} SET status = 'pending', error = ? WHERE login = ?`,\n [error, login],\n );\n}\n\nexport async function setEmail(login: string, email: string) {\n await sqlite.execute(`UPDATE ${TABLE} SET email = ? WHERE login = ?`, [email, login]);\n}\n\nexport async function markNotified(login: string) {\n await sqlite.execute(`UPDATE ${TABLE} SET notified_at = ? WHERE login = ?`, [Date.now(), login]);\n}\n\nexport async function getLead(login: string): Promise {\n const r = await sqlite.execute(`SELECT * FROM ${TABLE} WHERE login = ?`, [login]);\n return (rowsToObjects(r)[0] as LeadRow) ?? null;\n}\n\nexport async function listLeads(): Promise {\n const r = await sqlite.execute(\n `SELECT * FROM ${TABLE} ORDER BY COALESCE(scored_at, created_at) DESC`,\n );\n return rowsToObjects(r) as LeadRow[];\n}\n\nexport async function unnotifiedMessages(): Promise {\n const r = await sqlite.execute(\n `SELECT * FROM ${TABLE} WHERE verdict = 'MESSAGE' AND notified_at IS NULL AND status = 'done'`,\n );\n return rowsToObjects(r) as LeadRow[];\n}\n\nfunction rowsToObjects(result: { columns: string[]; rows: unknown[] }) {\n return result.rows.map((row: any) => {\n if (row && !Array.isArray(row) && typeof row === \"object\") return row;\n const obj: Record = {};\n result.columns.forEach((col, idx) => (obj[col] = row[idx]));\n return obj;\n });\n}\n",[],[180,33],["D",1784148205583],[259],[180],"9292886e-9385-4aa1-9f93-0bc8b908694f","types.ts","019f4e53-354b-724f-878e-d51fcce433a7",["D",1783725503703],"// Types shared between the Hono backend and the React frontend.\n\nexport interface LeadOutput {\n name?: string;\n company?: string;\n score?: number;\n reasoning?: string;\n error?: string;\n [key: string]: unknown;\n}\n\nexport type LeadStatus = \"processing\" | \"done\" | \"failed\";\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input: Record;\n output: LeadOutput | null;\n status: LeadStatus;\n score: number | null;\n}\n\n// A lead still \"processing\" after this long almost certainly crashed.\nexport const PROCESSING_TIMEOUT_MS = 3 * 60 * 1000;\n\n// A lead is qualified at or above this score: green in the UI, and the bar\n// any notification (email digest, Slack, etc.) should trigger on.\nexport const QUALIFIED_SCORE = 80;\n\n// Sentinel the backend writes into output_data when it claims a lead for\n// scoring, so concurrent /process calls can't double-score it. Both \"\" (just\n// created) and this sentinel mean \"still processing\".\nexport const CLAIMED_OUTPUT = \"claimed\";\n\ninterface LeadRow {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n}\n\n// Turn a raw DB row (input_data/output_data as JSON strings) into the shape the\n// frontend consumes: parsed fields plus a single computed status. Keeping this\n// one function as the source of truth means the server and client never disagree\n// about whether a lead is processing, done, or failed.\nexport function toClientLead(row: LeadRow, now: number): Lead {\n let input: Record = {};\n try {\n input = JSON.parse(row.input_data);\n } catch { /* leave as {} */ }\n\n const base = { id: row.id, timestamp: row.timestamp, input };\n\n // Empty or claimed output = the agent hasn't written a result yet.\n if (row.output_data === \"\" || row.output_data === CLAIMED_OUTPUT) {\n const timedOut = now - row.timestamp > PROCESSING_TIMEOUT_MS;\n return { ...base, output: null, status: timedOut ? \"failed\" : \"processing\", score: null };\n }\n\n let output: LeadOutput;\n try {\n output = JSON.parse(row.output_data);\n } catch {\n return { ...base, output: { error: \"Malformed output\" }, status: \"failed\", score: null };\n }\n\n if (output.error) return { ...base, output, status: \"failed\", score: null };\n\n return {\n ...base,\n output,\n status: \"done\",\n score: typeof output.score === \"number\" ? output.score : 0,\n };\n}\n",[],[187,280],"b46bf358-083d-451b-a1ff-3399cfc77b1c","config.ts","f8dc0c82-7ee8-11f1-8177-1607ee4eb77e",29,["D",1783967449755],"// Shared configuration for GitHub lead intake (cron + backfill).\n\n// GitHub orgs to watch. The relationship label gives the scoring agent\n// context: activity on your own repos is a much hotter signal than activity\n// on a competitor's.\nexport const WATCHED = [\n { org: \"dbprohq\", relationship: \"our repos (DB Pro)\" },\n { org: \"miracodeai\", relationship: \"our repos (Mira)\" },\n // { org: \"some-competitor\", relationship: \"competitor's repos\" },\n];\n\n// Your own team — never lead-scored. Add/remove GitHub usernames freely.\nexport const EXCLUDE_USERS = new Set([\n \"JSMira\",\n \"jayhyp\",\n \"JackHyp\",\n \"coolio85\",\n \"modrink\",\n \"JDSmith97\",\n]);\n",[],[187,287],["D",1783725503703],[256,257],[187],"9e82104b-6ff9-416c-8334-71dbff20cda1","qualify.ts","f0a873ce-808d-11f1-a453-1607ee4eb77e",77,["D",1784148383032],"interval","// cron: research pending leads one at a time — recover email, gpt-5 + web\n// search against PROMPT.md, write verdict + card back to the db.\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { emailsFromGitHubUsername } from \"https://esm.town/v/stevekrouse/github-user-email/index.ts\";\nimport OpenAI from \"npm:openai\";\nimport { claimNext, failLead, finishLead, setEmail } from \"../utils/db.ts\";\n\nconst openai = new OpenAI({ apiKey: Deno.env.get(\"OPENAI_API_KEY\") });\nconst PROMPT = await readFile(\"/processing/PROMPT.md\", import.meta.url);\n\n// Stop claiming new work near the runtime ceiling; the next tick continues.\nconst TIME_BUDGET_MS = 4 * 60 * 1000;\n\n// Models sometimes wrap output in ``` fences — strip if present.\nexport function stripFences(text: string): string {\n const m = text.trim().match(/^```(?:markdown|md)?\\s*\\n([\\s\\S]*?)\\n?```$/);\n return (m ? m[1] : text).trim();\n}\n\nexport function parseVerdict(markdown: string): string | null {\n return markdown.match(/^Verdict:\\s*(MESSAGE|WATCH|IGNORE|NEEDS_ID)/im)?.[1] ?? null;\n}\n\nexport async function qualify(lead: { login: string; activity: string | null; email: string | null }) {\n let email = lead.email;\n if (!email) {\n try {\n const emails = await emailsFromGitHubUsername(lead.login);\n email = emails.find((e: string) => !e.includes(\"noreply\")) ?? null;\n if (email) await setEmail(lead.login, email);\n } catch { /* email recovery is best-effort */ }\n }\n\n const response = await openai.responses.create({\n model: \"gpt-5\",\n tools: [{ type: \"web_search\" }],\n instructions: PROMPT,\n input: JSON.stringify({\n github_username: lead.login,\n activity: JSON.parse(lead.activity ?? \"[]\"),\n ...(email && { email }),\n }),\n });\n if (response.status !== \"completed\") {\n throw new Error(`Model response ${response.status}`);\n }\n const card = stripFences(response.output_text);\n return { card, verdict: parseVerdict(card) };\n}\n\nexport default async function () {\n const start = Date.now();\n while (Date.now() - start < TIME_BUDGET_MS) {\n const lead = await claimNext();\n if (!lead) return; // queue empty\n try {\n const { card, verdict } = await qualify(lead);\n await finishLead(lead.login, verdict, card);\n console.log(`${lead.login} -> ${verdict}`);\n } catch (err) {\n console.error(`${lead.login} failed:`, err);\n await failLead(lead.login, String(err));\n return; // don't tight-loop on a systemic failure; retry next tick\n }\n }\n}\n",[],[192,298],"00429835-c119-433a-bb32-14850cf46174","PROMPT.md","e75528d0-808d-11f1-b0cc-1607ee4eb77e",66,["D",1784148238496],"You do lead enrichment and qualification for people who interact with Mira's GitHub repos. Mira (miracode.ai) is a self-hosted, BYOK AI code reviewer — code never leaves your infra, you pick the model, no per-seat pricing.\n\nInput: a GitHub username, their activity on our repos (dates, issue/PR titles), sometimes an email. Research them: GitHub, LinkedIn, personal sites, their company.\n\nThe best leads work at companies where self-hosting matters (regulated, European, on-prem), with a real engineering team, and personally are senior enough to champion tools, and show real usage (issues/PRs > stars). Students, bots, drive-by stars are not leads.\n\nNever invent a company, title, or email — null out and downgrade the verdict instead.\n\nReply in markdown as follows:\n\nVerdict: MESSAGE | WATCH | IGNORE | NEEDS_ID (MESSAGE = a founder should DM them this week; NEEDS_ID = hot activity, unknown person)\nName — title, company (~size)\nWhy: 2–3 sentences, concrete evidence, where facts came from.\nOpener: one line, founder-to-user: reference their specific activity, thank contributors, ask a real question about their setup. Never salesy, never flattery.\nLinks: github · linkedin · company · email\n",[],[192,307],["D",1784148204143],[253,254],[192],"1722b3de-3270-4c5d-bb19-60e1707f7d03","slack.ts","000676b8-808e-11f1-9c99-1607ee4eb77e",78,["D",1784148383598],"// cron: send unnotified MESSAGE-verdict cards to Slack.\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport slackifyMarkdown from \"npm:slackify-markdown\";\nimport { markNotified, unnotifiedMessages } from \"../utils/db.ts\";\n\nexport default async function () {\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (!webhookUrl) return; // no-op until configured\n\n const webhook = new IncomingWebhook(webhookUrl);\n for (const lead of await unnotifiedMessages()) {\n await webhook.send({\n text: slackifyMarkdown(`🎯 **New qualified lead: ${lead.login}**\\n\\n${lead.card}`),\n });\n // Mark after the send succeeds; a Slack hiccup means we retry next tick.\n await markNotified(lead.login);\n console.log(`notified: ${lead.login}`);\n }\n}\n",[],[198,318],"5582ceb7-e420-453e-ba01-8007562cd43b","server.ts","1a9b404e-808e-11f1-994f-1607ee4eb77e","05b6d134-808e-11f1-a4db-1607ee4eb77e",72,["D",1784148324513],"// http: the dashboard — browse every lead, filter by verdict, score anyone.\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { insertPending, listLeads } from \"../../utils/db.ts\";\nimport { requireOrgMember } from \"./auth.tsx\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors so the platform surfaces the real error.\napp.onError((err) => Promise.reject(err));\n\napp.use(\"/*\", requireOrgMember);\n\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/outputs/dashboard/index.html\", import.meta.url);\n const data = { initialLeads: await listLeads() };\n // Escape \"<\" so card content can't terminate the script tag early.\n const json = JSON.stringify(data).replace(/\", ``);\n return c.html(html);\n});\n\napp.get(\"/api/leads\", async (c) => c.json(await listLeads()));\n\n// The score-anyone box: insert as pending; the qualify cron picks it up.\napp.post(\"/api/leads\", async (c) => {\n const { github_username } = await c.req.json();\n if (!github_username?.trim()) {\n return c.json({ ok: false, error: \"github_username required\" }, 400);\n }\n const login = github_username.trim();\n const isNew = await insertPending(login, [{ type: \"manual\", when: new Date().toISOString().slice(0, 10) }]);\n return c.json({ ok: true, login, isNew });\n});\n\n// Serve the frontend module.\napp.get(\"/public/**/*\", (c) =>\n serveFile(c.req.path.replace(\"/public\", \"/outputs/dashboard\"), import.meta.url));\n\nexport default app;\n",[],[198,334,326],"dashboard","28cfadd3-da06-4f63-8142-fe85dce67a05","index.html","1ee47fda-808e-11f1-8b8f-1607ee4eb77e",73,["D",1784148331712],"\n\n \n \n \n GitHub Leads\n \n \n \n

\n \n \n \n\n",[],[198,334,336],"c9301f40-db92-4a61-817f-087c2ab6c384","auth.tsx","0ed6945c-808e-11f1-9b85-1607ee4eb77e",71,["D",1784148304776],"/** @jsxImportSource npm:hono@4/jsx */\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The template's own live preview (owned by the \"templates\" org) is publicly\n// viewable. Your remix is owned by your org, so it requires login.\nconst IS_TEMPLATE_PREVIEW = parseVal().username === \"templates\";\n\n// Auth guard for the dashboard. The x-debug-token header bypass lets headless\n// agents (and curl) hit the dashboard for debugging without a browser login.\nexport async function requireOrgMember(c: any, next: any) {\n if (IS_TEMPLATE_PREVIEW && c.req.method === \"GET\") return next();\n const debugToken = Deno.env.get(\"DEBUG_TOKEN\");\n if (debugToken && c.req.header(\"x-debug-token\") === debugToken) return next();\n const session = await getOAuthUserData(c.req.raw);\n if (!session) return c.html();\n if (!session.isOrgMember) {\n return c.html(, 403);\n }\n await next();\n}\n\nfunction Shell({ title, children }: { title: string; children: any }) {\n return (\n \n \n \n \n {title}\n \n \n \n

\n {children}\n

\n \n \n );\n}\n\nfunction LoginPage() {\n return (\n \n

🔒

GitHub Leads Dashboard

\n \n $\"\"$ \n Sign in with Val Town\n \n

\n \n );\n}\n\nfunction UnauthorizedPage({ username }: { username: string }) {\n return (\n \n

⛔

Access Denied

\n You must be a member of this val's organization to view the dashboard.\n

\n Logged in as {username}\n

\n \n );\n}\n",[],[198,334,344],"40e065b0-d585-4434-a844-7b625d7bdc19","app.tsx","2d703346-808e-11f1-a292-1607ee4eb77e",74,["D",1784148356104],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\n// The dashboard app: verdict-filterable list of lead cards.\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport { marked } from \"https://esm.sh/marked@12\";\n\ninterface Lead {\n login: string;\n email: string | null;\n status: string;\n verdict: string | null;\n card: string | null;\n error: string | null;\n flagged: string | null;\n created_at: number;\n scored_at: number | null;\n}\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__: { initialLeads: Lead[] };\n }\n}\n\nconst VERDICTS = [\"ALL\", \"MESSAGE\", \"WATCH\", \"NEEDS_ID\", \"IGNORE\", \"PENDING\"] as const;\nconst BADGE: Record = {\n MESSAGE: \"bg-green-100 text-green-800\",\n WATCH: \"bg-yellow-100 text-yellow-800\",\n NEEDS_ID: \"bg-gray-200 text-gray-700\",\n IGNORE: \"bg-gray-100 text-gray-400\",\n PENDING: \"bg-blue-100 text-blue-800\",\n};\n\nfunction bucket(lead: Lead): string {\n if (lead.status !== \"done\") return \"PENDING\";\n return lead.verdict ?? \"NEEDS_ID\";\n}\n\n// First non-verdict line of the card is \"Name — title, company\".\nfunction headline(lead: Lead): string {\n const lines = (lead.card ?? \"\").split(\"\\n\").map((l) => l.trim()).filter(Boolean);\n return lines.find((l) => !l.startsWith(\"Verdict:\")) ?? lead.login;\n}\n\nfunction App({ initialLeads }: { initialLeads: Lead[] }) {\n const [leads, setLeads] = useState(initialLeads);\n const [filter, setFilter] = useState<(typeof VERDICTS)[number]>(\"ALL\");\n const [open, setOpen] = useState(null);\n const [username, setUsername] = useState(\"\");\n\n const counts = useMemo(() => {\n const c: Record = {};\n for (const l of leads) c[bucket(l)] = (c[bucket(l)] ?? 0) + 1;\n return c;\n }, [leads]);\n\n const visible = filter === \"ALL\" ? leads : leads.filter((l) => bucket(l) === filter);\n\n async function scoreUsername(e: React.FormEvent) {\n e.preventDefault();\n if (!username.trim()) return;\n await fetch(\"/api/leads\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ github_username: username.trim() }),\n });\n setUsername(\"\");\n setLeads(await (await fetch(\"/api/leads\")).json());\n }\n\n return (\n

GitHub Leads

\n\n

\n {VERDICTS.map((v) => (\n setFilter(v)}\n className={`px-3 py-1 rounded-full text-sm border ${\n filter === v ? \"bg-gray-900 text-white border-gray-900\" : \"bg-white border-gray-200\"\n }`}\n >\n {v.toLowerCase()} {v === \"ALL\" ? leads.length : counts[v] ?? 0}\n \n ))}\n

\n\n

\n {visible.map((lead) => {\n const b = bucket(lead);\n return (\n

\n setOpen(open === lead.login ? null : lead.login)}\n className=\"w-full text-left px-4 py-3 flex items-center gap-3\"\n >\n \n {b}\n \n \n {lead.login}\n {lead.status === \"done\" && (\n · {headline(lead)}\n )}\n {lead.flagged && · {lead.flagged}}\n {lead.error && · {lead.error}}\n \n \n {open === lead.login && lead.card && (\n \n )}\n

\n );\n })}\n {visible.length === 0 && (\n

Nothing here yet.

\n )}\n

\n );\n}\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No root element found\");\ncreateRoot(root).render();\n",[],[198,334,352],"8edd6668-8bb0-41ec-9c76-f30b60e610d6",70,["D",1784148289445],[247,248,249,250],[198,334],["D",1784148204925],[246,251],[198],"dd36b046-1612-484d-bd5b-82a9b298e6fe","github.ts","fa7f3b30-808d-11f1-80cc-1607ee4eb77e",76,["D",1784148381651],"// cron: poll for new github activity, add to db.\nimport { Octokit } from \"npm:octokit@5.0.5\";\nimport { getLead, insertPending } from \"../utils/db.ts\";\n\n// GitHub orgs we watch. Activity on these repos is what makes someone a lead.\nexport const WATCHED = [\"miracodeai\", \"dbprohq\"];\n\n// Our own team — never lead-scored. The maintainer check below catches\n// unlisted team accounts, but add known handles here.\nexport const EXCLUDE_USERS = new Set([\n \"JSMira\",\n \"jayhyp\",\n \"JackHyp\",\n \"coolio85\",\n \"modrink\",\n \"JDSmith97\",\n]);\n\nexport default async function (interval: Interval) {\n // First run looks back one hour; history was handled by the backlog report.\n const lastChecked = interval.lastRunAt ?? new Date(Date.now() - 60 * 60 * 1000);\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n\n const events = (await Promise.all(\n WATCHED.map((org) =>\n octokit.paginate(octokit.rest.activity.listPublicOrgEvents, { org, per_page: 100 })\n ),\n ))\n .flat()\n .filter((e: any) => new Date(e.created_at) > lastChecked)\n .filter((e: any) =>\n e.actor?.login && !e.actor.login.includes(\"[bot]\") && !EXCLUDE_USERS.has(e.actor.login)\n );\n\n const byActor = Map.groupBy(events, (e: any) => e.actor.login as string);\n console.log(`${events.length} new events from ${byActor.size} people`);\n\n for (const [login, actorEvents] of byActor) {\n if (await getLead(login)) continue; // already known — first contact is the signal\n\n const activity = actorEvents.map((e: any) => ({\n type: e.type,\n repo: e.repo?.name,\n when: e.created_at?.slice(0, 10),\n title: e.payload?.issue?.title ?? e.payload?.pull_request?.title ?? undefined,\n }));\n\n // Maintainer signals: merging others' PRs or pushing straight to the repo.\n // Probably a team account missing from EXCLUDE_USERS — ask, don't score.\n const looksLikeMaintainer = actorEvents.some((e: any) =>\n e.type === \"PushEvent\" ||\n (e.type === \"PullRequestEvent\" && e.payload?.action === \"closed\" &&\n e.payload?.pull_request?.merged &&\n e.payload?.pull_request?.user?.login !== login)\n );\n\n await insertPending(login, activity, {\n flagged: looksLikeMaintainer ? \"maintainer?\" : undefined,\n });\n console.log(`new: ${login}${looksLikeMaintainer ? \" (flagged maintainer?)\" : \"\"}`);\n }\n}\n",[],[204,368],["D",1784148203624],[244],[204],"6b150dc6-91ea-4eba-b53e-78d5d280fa0e","index.tsx","019f4e53-354b-724f-878e-cd7717fc9ea8",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { type Lead } from \"../shared/types.ts\";\nimport { App } from \"./components/App.tsx\";\n\ndeclare global {\n interface Window {\n __INITIAL_DATA__: {\n initialLeads: Lead[];\n webhookUrl: string;\n username: string | null;\n };\n }\n}\n\nconst root = document.getElementById(\"root\");\nif (!root) throw new Error(\"No root element found\");\n\ncreateRoot(root).render();\n",[],[210,379],"04192299-aee4-4b15-b315-bf2fbb18dd0b","019f4e53-354b-724f-878e-c988e759ea01",["D",1783725503703],"\n\n \n \n \n GitHub Leads\n \n \n \n

\n \n \n \n\n",[],[210,336],"0d28e93f-09fd-498f-88d9-fc6dc68f1efd","LeadRow.tsx","019f4e53-354b-724f-878e-c0691c6334bc","019f4e53-354b-724f-878e-c6777cad123e",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\n\n// Relative dates keep the feed scannable: \"2h ago\" matters, exact dates don't.\nexport function timeAgo(ts: number): string {\n const mins = Math.floor((Date.now() - ts) / 60_000);\n if (mins < 1) return \"just now\";\n if (mins < 60) return `${mins}m ago`;\n const hours = Math.floor(mins / 60);\n if (hours < 24) return `${hours}h ago`;\n const days = Math.floor(hours / 24);\n if (days < 30) return `${days}d ago`;\n return new Date(ts).toLocaleDateString(\"en-US\", { month: \"short\", day: \"numeric\", year: \"numeric\" });\n}\n\n// Fixed-width score column; green is reserved for qualified,\n// red for failed. Everything else stays quiet.\nfunction Score({ lead }: { lead: Lead }) {\n if (lead.status === \"processing\") {\n return ··;\n }\n if (lead.status === \"failed\") {\n return ✗;\n }\n const score = lead.score ?? 0;\n return (\n = QUALIFIED_SCORE ? \"text-green-700 font-semibold\" : \"text-gray-400\"}>\n {score}\n \n );\n}\n\nconst ROW = \"w-full text-left py-2.5 border-b border-gray-100 grid grid-cols-[2.5rem_1fr_auto] items-baseline gap-3\";\n\nexport function LeadRow({ lead, onSelect }: { lead: Lead; onSelect: (id: number) => void }) {\n const displayName = lead.output?.name || (lead.input.name as string) ||\n (lead.input.github_username as string) || (lead.input.company as string) || \"Unknown\";\n\n return (\n onSelect(lead.id)}\n className={`${ROW} hover:bg-gray-50 cursor-pointer`}\n >\n \n \n {displayName}\n {lead.output?.company && · {lead.output.company}}\n {lead.status === \"processing\" && · scoring…}\n {lead.status === \"failed\" && · failed}\n \n {timeAgo(lead.timestamp)}\n \n );\n}\n\nexport function SampleRow(\n { name, company, score }: { name: string; company: string; score: number },\n) {\n return (\n

\n = QUALIFIED_SCORE ? \"text-green-700 font-semibold\" : \"text-gray-400\"}`}>\n {score}\n \n \n {name}\n · {company}\n \n example\n

\n );\n}\n",[],[210,399,392],"components","01907a44-82d6-488c-b9d9-ed3563f41c5b","LeadDetail.tsx","019f4e53-354b-724f-878e-bd193267b39f",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\nimport { timeAgo } from \"./LeadRow.tsx\";\n\nexport function LeadDetail({ lead, onBack }: { lead: Lead; onBack: () => void }) {\n const output = lead.output;\n const score = lead.score ?? 0;\n const displayName = output?.name || (lead.input.name as string) ||\n (lead.input.github_username as string) || (lead.input.company as string) || \"Unknown\";\n\n return (\n

\n \n ← All leads\n \n\n

{displayName}

\n {output?.company && `${output.company} · `}\n {timeAgo(lead.timestamp)}\n

\n\n {lead.status === \"failed\"\n ? (\n

\n {output?.error ||\n \"This lead has been processing for over 3 minutes and likely failed. Try resubmitting it.\"}\n

\n )\n : lead.status === \"processing\"\n ? (\n

\n Scoring — the AI is researching this lead. Usually takes a minute or two.\n

\n )\n : (\n

= QUALIFIED_SCORE ? \"text-green-700\" : \"\"}`}>\n {score}\n / 100\n

\n {output?.reasoning || \"No reasoning provided\"}\n

\n )}\n\n \n {output && lead.status !== \"processing\" && }\n

\n );\n}\n\nfunction DataList({ title, data }: { title: string; data: Record }) {\n const entries = Object.entries(data);\n if (entries.length === 0) return null;\n\n return (\n

{title}

\n {entries.map(([key, value]) => (\n

\n {key}\n \n {typeof value === \"object\" ? JSON.stringify(value) : String(value ?? \"\")}\n \n

\n ))}\n

\n );\n}\n",[],[210,399,401],"c8ad1a15-a309-426a-94c7-5162ab3eb4a2","GithubTester.tsx","019f4e53-354b-724f-878e-baa772436726",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\n\n// One quiet line under the title: score any GitHub username on demand, plus\n// the webhook URL for wiring up other sources (forms, signups, CRMs).\nexport function GithubTester({ webhookUrl, onSent }: { webhookUrl: string; onSent: () => void }) {\n const [handle, setHandle] = React.useState(\"\");\n const [sending, setSending] = React.useState(false);\n const [error, setError] = React.useState(null);\n const [copied, setCopied] = React.useState(false);\n\n const copy = async () => {\n try {\n await navigator.clipboard.writeText(webhookUrl);\n } catch {\n // Clipboard API is blocked by permissions policy inside iframes (like\n // the Val Town preview); fall back to the legacy selection approach.\n const ta = document.createElement(\"textarea\");\n ta.value = webhookUrl;\n ta.style.position = \"fixed\";\n ta.style.opacity = \"0\";\n document.body.appendChild(ta);\n ta.select();\n document.execCommand(\"copy\");\n ta.remove();\n }\n setCopied(true);\n setTimeout(() => setCopied(false), 2000);\n };\n\n const send = async () => {\n const username = handle.trim().replace(/^@/, \"\");\n if (!username || sending) return;\n setSending(true);\n setError(null);\n try {\n const res = await fetch(`${webhookUrl}?source=manual`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ github_username: username }),\n });\n const data = await res.json();\n if (data.error) {\n setError(data.error);\n } else {\n setHandle(\"\");\n onSent();\n }\n } catch (err) {\n setError(err instanceof Error ? err.message : String(err));\n } finally {\n setSending(false);\n }\n };\n\n return (\n

\n setHandle(e.target.value)}\n onKeyDown={(e) => e.key === \"Enter\" && send()}\n placeholder=\"Score a GitHub username…\"\n spellCheck={false}\n className=\"border border-gray-200 px-2.5 py-1.5 w-56 focus:outline-none focus:border-gray-400\"\n />\n \n {sending ? \"sending…\" : \"score\"}\n \n \n or POST JSON to{\" \"}\n this URL{\" \"}\n \n {copied ? \"copied\" : \"copy\"}\n \n \n

\n {error &&

{error}

}\n

\n );\n}\n",[],[210,399,408],"3cfb95f3-3fb1-4031-96bc-f90c717e46a8","Dashboard.tsx","019f4e53-354b-724f-878e-b7ce11d2bf8f",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { type Lead, QUALIFIED_SCORE } from \"../../shared/types.ts\";\nimport { LeadRow, SampleRow } from \"./LeadRow.tsx\";\n\nconst WEEK_MS = 7 * 24 * 60 * 60 * 1000;\n\n// Shown only when there are no leads yet, so the dashboard demonstrates what\n// scored leads look like before the first real one arrives.\nconst SAMPLE_LEADS = [\n { name: \"Maya Chen\", company: \"Parabolic Systems\", score: 92 },\n { name: \"Diego Alvarez\", company: \"Kestrel Analytics\", score: 61 },\n { name: \"Sam Hobbyist\", company: \"Personal blog\", score: 14 },\n];\n\n// Best leads first, but only within the last week — an old high score\n// shouldn't outrank this morning's lead forever. Still-processing leads pin\n// to the top; leads older than a week collapse under \"Earlier\".\nfunction byScoreThenNewest(a: Lead, b: Lead): number {\n if ((a.status === \"processing\") !== (b.status === \"processing\")) {\n return a.status === \"processing\" ? -1 : 1;\n }\n return (b.score ?? 0) - (a.score ?? 0) || b.timestamp - a.timestamp;\n}\n\nexport function Dashboard(\n { leads, onSelect }: { leads: Lead[]; onSelect: (id: number) => void },\n) {\n const sorted = [...leads].sort(byScoreThenNewest);\n const cutoff = Date.now() - WEEK_MS;\n const recent = sorted.filter((l) => l.timestamp >= cutoff);\n const earlier = sorted.filter((l) => l.timestamp < cutoff);\n const qualified = recent.filter(\n (l) => l.status === \"done\" && (l.score ?? 0) >= QUALIFIED_SCORE,\n );\n\n if (leads.length === 0) {\n return (\n

\n No leads yet — here's what scored leads look like.\n

\n {SAMPLE_LEADS.map((s) => )}\n

\n );\n }\n\n return (\n

\n {recent.length} {recent.length === 1 ? \"lead\" : \"leads\"} this week\n {qualified.length > 0 && ` · ${qualified.length} qualified`}\n

\n\n {recent.map((l) => )}\n\n {earlier.length > 0 && (\n

\n Earlier · {earlier.length} {earlier.length === 1 ? \"lead\" : \"leads\"}\n

\n {earlier.map((l) => (\n \n ))}\n

\n )}\n

\n );\n}\n",[],[210,399,415],"74d298f7-5965-473c-bf13-c7ede3e5dc98","App.tsx","019f4e53-354b-724f-878e-b0d73fd10ebd",["D",1783725503703],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport { type Lead } from \"../../shared/types.ts\";\nimport { Dashboard } from \"./Dashboard.tsx\";\nimport { LeadDetail } from \"./LeadDetail.tsx\";\nimport { GithubTester } from \"./GithubTester.tsx\";\n\nexport function App(\n { initialLeads = [], webhookUrl = \"\", username = null }: {\n initialLeads?: Lead[];\n webhookUrl?: string;\n username?: string | null;\n },\n) {\n const [leads, setLeads] = React.useState(initialLeads);\n const [selectedId, setSelectedId] = React.useState(null);\n\n const refresh = React.useCallback(async () => {\n try {\n const res = await fetch(\"/api/leads\");\n if (res.ok) setLeads(await res.json());\n } catch (err) {\n console.error(\"Failed to refresh leads\", err);\n }\n }, []);\n\n // Poll only while something is still being researched.\n const hasProcessing = leads.some((l) => l.status === \"processing\");\n React.useEffect(() => {\n if (!hasProcessing) return;\n const timer = setInterval(refresh, 3000);\n return () => clearInterval(timer);\n }, [hasProcessing, refresh]);\n\n const selected = leads.find((l) => l.id === selectedId) ?? null;\n\n return (\n

\n {selected\n ? setSelectedId(null)} />\n : (\n <>\n

GitHub Leads

\n {username && (\n \n {username} ·{\" \"}\n \n \n )}\n

\n \n \n \n )}\n \n

\n );\n}\n",[],[210,399,422],"6973058f-b53a-4c95-a698-a086c6c1e174",["D",1783725503703],[236,237,238,239,240],[210,399],["D",1783725503703],[235,241,242],[210],"ebd9a265-7888-4b76-a36c-8417fc945c5a","notify.ts","019f4e53-354b-724f-878e-a9de4c2b09e8",["D",1783725503703],"import { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { IncomingWebhook } from \"npm:@slack/webhook\";\nimport { LeadOutput, QUALIFIED_SCORE } from \"../shared/types.ts\";\n\n// Set the SLACK_WEBHOOK_URL env var to get a Slack message the moment a lead\n// scores as qualified. Without it, this is a no-op.\n// https://docs.val.town/guides/slack/send-messages-to-slack/\nexport async function notifySlack(output: LeadOutput) {\n const webhookUrl = Deno.env.get(\"SLACK_WEBHOOK_URL\");\n if (!webhookUrl) return;\n if (typeof output.score !== \"number\" || output.score < QUALIFIED_SCORE) return;\n\n // Best-effort: a Slack hiccup should never fail (or retry) the lead scoring.\n try {\n const dashboardUrl = await httpEndpoint(\"main.ts\", import.meta.url);\n const who = [output.name, output.company].filter(Boolean).join(\" · \");\n await new IncomingWebhook(webhookUrl).send({\n text: [\n `🎯 Qualified lead (${output.score}): *${who || \"Unknown\"}*`,\n output.reasoning,\n `<${dashboardUrl}|Open dashboard>`,\n ].filter(Boolean).join(\"\\n\"),\n });\n } catch (err) {\n console.error(\"Slack notification failed:\", err);\n }\n}\n",[],[215,436],"3b53b219-b858-453a-b957-b578ddc00678","index.ts","019f4e53-354b-724f-878e-a4f6b2670ec4",9,["D",1783726140509],"import { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal, readFile, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono@4\";\nimport { toClientLead } from \"../shared/types.ts\";\nimport { processLead } from \"./agent.ts\";\nimport { claimLead, createProcessingLead, getAllLeads, getLeadById } from \"./db.ts\";\nimport { requireOrgMember } from \"./auth.tsx\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors so the platform surfaces the real error, not \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// Serialize every lead the same way for both the initial page load and the API.\nasync function clientLeads() {\n const now = Date.now();\n const rows = await getAllLeads();\n return rows.map((row) => toClientLead(row, now));\n}\n\n// ── Public webhook endpoints (no auth) ──\n\napp.post(\"/\", async (c) => {\n let body: Record;\n try {\n body = await c.req.json();\n } catch {\n return c.json({ ok: false, error: \"Request body must be valid JSON\" }, 400);\n }\n const url = new URL(c.req.url);\n const query = Object.fromEntries(url.searchParams);\n const inputData = Object.keys(query).length ? { ...body, _query: query } : body;\n\n // Create the lead immediately in a processing state and respond fast.\n const leadId = await createProcessingLead(inputData);\n\n // Fire-and-forget the slow scoring in a separate request.\n // https://docs.val.town/vals/http/early-return/\n fetch(`${url.origin}/process`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ leadId }),\n });\n\n return c.json({ ok: true, leadId });\n});\n\napp.post(\"/process\", async (c) => {\n const { leadId } = await c.req.json();\n // This route is public (registered before the auth guard) so POST / can call\n // it fire-and-forget. The atomic claim means each lead is scored exactly\n // once, and the input comes from the DB row — not the request — so this\n // can't be used to re-score, overwrite, or feed the agent forged data.\n if (!(await claimLead(leadId))) return c.json({ ok: false }, 409);\n const lead = await getLeadById(leadId);\n await processLead(leadId, JSON.parse(lead!.input_data));\n return c.json({ ok: true });\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ── Everything below requires an org member (the template preview allows GET) ──\napp.use(\"/*\", requireOrgMember);\n\n// Serve the React dashboard, bootstrapping the leads into the HTML so the list\n// paints immediately instead of flashing empty while the first fetch runs.\napp.get(\"/\", async (c) => {\n let html = await readFile(\"/frontend/index.html\");\n const session = await getOAuthUserData(c.req.raw);\n const data = {\n initialLeads: await clientLeads(),\n webhookUrl: new URL(c.req.url).origin,\n username: session?.user?.username ?? null,\n };\n // Escape \"<\" so lead content containing \"\" can't terminate the tag\n // early (which dumps raw JSON into the page and breaks hydration).\n const json = JSON.stringify(data).replace(/window.__INITIAL_DATA__ = ${json}`;\n html = html.replace(\"\", `${script}`);\n return c.html(html);\n});\n\n// JSON endpoint the frontend polls while leads are still processing.\napp.get(\"/api/leads\", async (c) => c.json(await clientLeads()));\n\n// Serve the frontend modules (/public/**) and shared types (/shared/**).\napp.get(\"/public/**/*\", (c) => serveFile(c.req.path.replace(\"/public\", \"/frontend\")));\napp.get(\"/shared/**/*\", (c) => serveFile(c.req.path));\n\nexport default app;\n",[],[215,443],"8ad6ace0-eeaa-400c-a046-6e867dc473b7","019f4e53-354b-724f-878e-9c93bf2de69c",10,["D",1783726169429],2,"/** @jsxImportSource npm:hono@4/jsx */\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The template's own live preview (owned by the \"templates\" org) is publicly\n// viewable. Your remix is owned by your org, so it requires login.\nconst IS_TEMPLATE_PREVIEW = parseVal().username === \"templates\";\n\n// Auth guard for the dashboard routes. Register the public webhook routes\n// (POST / and /process) BEFORE this so external systems can submit leads\n// without logging in.\nexport async function requireOrgMember(c: any, next: any) {\n if (IS_TEMPLATE_PREVIEW && c.req.method === \"GET\") return next();\n const session = await getOAuthUserData(c.req.raw);\n if (!session) return c.html();\n if (!session.isOrgMember) {\n return c.html(, 403);\n }\n await next();\n}\n\nfunction Shell({ title, children }: { title: string; children: any }) {\n return (\n \n \n \n \n {title}\n \n \n \n

\n {children}\n

\n \n \n );\n}\n\nfunction LoginPage() {\n return (\n \n

🔒

GitHub Leads Dashboard

\n \n $\"\"$ \n Sign in with Val Town\n \n

\n \n );\n}\n\nfunction UnauthorizedPage({ username }: { username: string }) {\n return (\n \n

⛔

Access Denied

\n You must be a member of this val's organization to view the dashboard.\n

\n Logged in as {username}\n

\n \n );\n}\n",[],[215,344],["D",1783725503703],[231,232,233],[215],["D",1783725503703],["D",1789526460011],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_18":-5,"_110":111,"_112":25},{"_13":90,"_32":91,"_43":42,"_92":44,"_93":94,"_95":96,"_97":51,"_98":99,"_100":101,"_102":45,"_103":104},"ctx",{"_83":-5,"_135":499,"_500":501,"_502":503,"_504":49,"_505":49,"_506":49,"_507":25,"_508":-5,"_509":-7,"_510":-7,"_511":64,"_512":49,"_513":49,"_514":-5,"_515":49,"_516":49,"_517":49,"_518":-5},"ENV",{"_470":471,"_472":473,"_474":91,"_475":476,"_477":478,"_479":480,"_481":482,"_483":484,"_485":486,"_487":488,"_489":490,"_491":492,"_493":494,"_495":496,"_497":498},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v86