[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_330":331,"_332":333},"routes/_app.x.$handle.$name",{"_106":105,"_32":46,"_115":92,"_27":116,"_13":14,"_117":-5,"_11":118,"_119":120,"_121":122,"_123":124,"_125":126,"_20":-5,"_127":128,"_129":130,"_131":25,"_132":133,"_134":61,"_135":-5,"_136":-5,"_137":138},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":73,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":85,"_86":87,"_88":89,"_90":25},"version",111,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","utils/db.ts","latestPath","fileId","e0a0b13a-808d-11f1-8fff-1607ee4eb77e","name","db.ts","fileType","script","content","// 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","// 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\nconst TABLE = \"leads\";\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","createdAt",["D",1784149086730],"branchVersion","branchId","3707f499-097d-4e07-a507-b21e0bcfbbb0","id","1248533c-8cdc-4f42-9610-73e9cbc5e37d","dbpro-leads",["D",1783725503703],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","GitHub lead qualification for DB Pro / Mira","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789541999&sig=e4c5f19fff9498fc87aa42b17560594110330fe305a5b7c1e1d4bd62f0981075","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019f4e53-354b-724f-878e-e9177d5c065a","pinPreview",true,"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",{"_106":105,"_114":110},"org",{"_106":105,"_107":108,"_109":110,"_18":-5,"_111":112,"_113":61},"branch",{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":100,"_101":102,"_103":46,"_104":105},"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",{"_44":45,"_32":46,"_39":325,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":56,"_18":57,"_58":59,"_60":61,"_62":-5,"_63":-5,"_64":65,"_66":67,"_68":69,"_70":71,"_72":326,"_74":-5,"_75":76,"_77":76,"_78":79,"_80":79,"_81":79,"_82":76,"_83":76,"_84":327,"_86":328,"_88":329,"_90":25},"tree",[213,215,222,225,227,228],"files",[213,214,215,216,217,218,219,220,221,222,223,224,225,226,227,228],"counts",{"_202":65,"_203":164,"_204":65,"_205":206,"_207":208},"contents",[152,153,154,155,156,157],"upstreamProject",{"_44":100,"_32":148,"_53":149,"_55":56,"_50":51,"_84":150},"upstreamBranch",{"_44":95,"_39":139,"_140":141,"_32":92,"_93":100,"_13":142,"_94":143,"_96":144,"_145":146,"_48":-5,"_90":25,"_50":51,"_104":147,"_66":102,"_103":148},"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",{"_106":147,"_114":151},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789541999&sig=156ae2b8ac752fc06f52d45eab428b512e0d31e2aab99a830d8bb32149c64f0f",{"_44":196,"_32":197,"_30":198,"_160":-5,"_42":43,"_41":199,"_162":61,"_39":200,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_27":201},{"_44":190,"_32":191,"_30":192,"_160":-5,"_42":43,"_41":193,"_162":61,"_39":194,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_27":195},{"_44":184,"_32":185,"_30":186,"_160":-5,"_42":43,"_41":187,"_162":61,"_39":188,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_27":189},{"_44":177,"_32":178,"_30":179,"_160":-5,"_42":43,"_41":180,"_162":61,"_39":181,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_27":183},{"_44":169,"_32":170,"_30":171,"_160":-5,"_42":43,"_41":172,"_162":25,"_39":173,"_13":174,"_34":20,"_36":175,"_24":25,"_167":-5,"_27":176},{"_44":158,"_32":159,"_30":59,"_160":-5,"_42":43,"_41":161,"_162":61,"_39":163,"_13":164,"_34":165,"_36":166,"_24":25,"_167":-5,"_27":168},"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",[159],"34983a30-98a7-488d-823c-c22ff2b4292e","README.md","019f4e53-354b-724f-878e-e330fea73434",102,["D",1784148801637],6,"# 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) — polling GitHub from shared IPs hits rate\n limits; a scopeless token gives this val its own quota.\n [Create it (prefilled, no scopes)](https://github.com/settings/tokens/new?description=github-leads&scopes=)\n → [paste it here](/environment-variables?key=GITHUB_TOKEN)\n- **`OPENAI_API_KEY`** — **optional**, works without it (Val Town's built-in\n OpenAI covers ~100 leads/day). For more volume:\n [get a key](https://platform.openai.com/api-keys)\n → [paste it here](/environment-variables?key=OPENAI_API_KEY)\n- **Slack** — **optional**, for qualified-lead pings. Connect the Slack\n integration in this val's [settings](/settings) (supplies `SLACK_TOKEN`),\n and set the channel at the top of [outputs/slack.ts](./outputs/slack.ts).",[170],"319c428c-c8b0-4785-acdf-41faa385294a","utils","d3b96674-808d-11f1-a2d7-1607ee4eb77e",64,["D",1784148205583],"directory",[178],"97ff939e-0e50-48e9-92b2-e1b330d488a3","processing","d2df6c9e-808d-11f1-978e-1607ee4eb77e",62,["D",1784148204143],[185],"239f795e-2e46-4c93-aee0-2b877abd7c36","outputs","d352efc0-808d-11f1-96e7-1607ee4eb77e",63,["D",1784148204925],[191],"a9ae1a9b-3628-4c21-b06f-02f2e1b999e0","inputs","d292f7ec-808d-11f1-8cb9-1607ee4eb77e",61,["D",1784148203624],[197],"pulls","branches","forks","envVars",{"_209":211,"_212":65},"connections",{"_209":164,"_210":65},"count","unfilledCount",3,"emptyCount",{"_44":196,"_32":197,"_30":198,"_160":-5,"_42":43,"_41":199,"_162":61,"_39":322,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_230":323,"_27":324},{"_44":314,"_32":315,"_30":316,"_160":198,"_42":43,"_41":317,"_162":61,"_39":318,"_13":164,"_34":249,"_36":319,"_24":25,"_167":-5,"_230":320,"_27":321},{"_44":190,"_32":191,"_30":192,"_160":-5,"_42":43,"_41":193,"_162":61,"_39":311,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_230":312,"_27":313},{"_44":306,"_32":281,"_30":275,"_160":192,"_42":43,"_41":307,"_162":61,"_39":308,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_230":309,"_27":310},{"_44":298,"_32":299,"_30":300,"_160":275,"_42":43,"_41":301,"_162":25,"_39":302,"_13":65,"_34":35,"_36":303,"_24":25,"_167":-5,"_230":304,"_27":305},{"_44":290,"_32":291,"_30":292,"_160":275,"_42":43,"_41":293,"_162":25,"_39":294,"_13":65,"_34":35,"_36":295,"_24":25,"_167":-5,"_230":296,"_27":297},{"_44":282,"_32":283,"_30":284,"_160":275,"_42":43,"_41":285,"_162":25,"_39":286,"_13":65,"_34":20,"_36":287,"_24":25,"_167":-5,"_230":288,"_27":289},{"_44":272,"_32":273,"_30":274,"_160":275,"_42":43,"_41":276,"_162":25,"_39":277,"_13":65,"_34":35,"_36":278,"_24":25,"_167":-5,"_230":279,"_27":280},{"_44":264,"_32":265,"_30":266,"_160":192,"_42":43,"_41":267,"_162":25,"_39":268,"_13":248,"_34":249,"_36":269,"_24":25,"_167":-5,"_230":270,"_27":271},{"_44":184,"_32":185,"_30":186,"_160":-5,"_42":43,"_41":187,"_162":61,"_39":261,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_230":262,"_27":263},{"_44":253,"_32":254,"_30":255,"_160":186,"_42":43,"_41":256,"_162":25,"_39":257,"_13":65,"_34":20,"_36":258,"_24":25,"_167":-5,"_230":259,"_27":260},{"_44":243,"_32":244,"_30":245,"_160":186,"_42":43,"_41":246,"_162":25,"_39":247,"_13":248,"_34":249,"_36":250,"_24":25,"_167":-5,"_230":251,"_27":252},{"_44":177,"_32":178,"_30":179,"_160":-5,"_42":43,"_41":180,"_162":61,"_39":240,"_13":65,"_34":182,"_36":-5,"_24":25,"_167":-5,"_230":241,"_27":242},{"_44":236,"_32":33,"_30":31,"_160":179,"_42":43,"_41":14,"_162":25,"_39":237,"_13":164,"_34":35,"_36":38,"_24":25,"_167":-5,"_230":238,"_27":239},{"_44":169,"_32":170,"_30":171,"_160":-5,"_42":43,"_41":172,"_162":25,"_39":233,"_13":174,"_34":20,"_36":175,"_24":25,"_167":-5,"_230":234,"_27":235},{"_44":158,"_32":159,"_30":59,"_160":-5,"_42":43,"_41":161,"_162":61,"_39":229,"_13":164,"_34":165,"_36":166,"_24":25,"_167":-5,"_230":231,"_27":232},["D",1784148366847],"children",[],[159],["D",1784148801637],[],[170],"9fbde764-86a3-4744-a265-6c108c9485d5",["D",1784149086730],[],[178,33],["D",1784148205583],[226],[178],"264cea89-4a42-46f5-b83e-3192e9a6690a","qualify.ts","f0a873ce-808d-11f1-a453-1607ee4eb77e",90,["D",1784148441349],2,"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 { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\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\n// Uses Val Town's built-in OpenAI proxy unless you bring your own key.\nconst apiKey = Deno.env.get(\"OPENAI_API_KEY\");\nconst openai = apiKey ? new OpenAI({ apiKey }) : new ValTownOpenAI({});\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",[],[185,244],"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",[],[185,254],["D",1784148204143],[223,224],[185],"a4370bd2-ad39-4e08-8dd5-0bd56720f9b4","slack.ts","000676b8-808e-11f1-9c99-1607ee4eb77e",104,["D",1784148826862],"// cron: send unnotified MESSAGE-verdict cards to Slack (Val Town Slack integration).\nimport { WebClient } from \"npm:@slack/web-api\";\nimport slackifyMarkdown from \"npm:slackify-markdown\";\nimport { markNotified, unnotifiedMessages } from \"../utils/db.ts\";\n\n// The channel qualified-lead pings land in.\nconst CHANNEL = \"leads\";\n\nexport default async function () {\n const token = Deno.env.get(\"SLACK_TOKEN\");\n if (!token) return; // no-op until the Slack integration is connected\n\n const slack = new WebClient(token);\n\n const leads = await unnotifiedMessages();\n if (leads.length === 0) return;\n\n // The bot must be in the channel before it can post.\n const channels = await slack.conversations.list({ types: \"public_channel\" });\n const channel = channels.channels?.find((c: any) => c.name === CHANNEL);\n if (!channel?.id) {\n console.error(`Slack channel #${CHANNEL} not found`);\n return;\n }\n if (!channel.is_member) await slack.conversations.join({ channel: channel.id });\n\n for (const lead of leads) {\n await slack.chat.postMessage({\n channel: channel.id,\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",[],[191,265],"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",[],[191,281,273],"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",[],[191,281,283],"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",[],[191,281,291],"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",[],[191,281,299],"8edd6668-8bb0-41ec-9c76-f30b60e610d6",70,["D",1784148289445],[217,218,219,220],[191,281],["D",1784148204925],[216,221],[191],"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",[],[197,315],["D",1784148203624],[214],[197],["D",1783725503703],["D",1789526460011],{"_106":105,"_114":110},{"_106":105,"_107":108,"_109":110,"_18":-5,"_111":112,"_113":61},{"_13":91,"_32":92,"_44":43,"_93":45,"_94":95,"_96":97,"_98":51,"_99":100,"_101":102,"_103":46,"_104":105},"ctx",{"_84":-5,"_136":363,"_364":365,"_366":367,"_368":25,"_369":25,"_370":25,"_371":61,"_372":-5,"_373":-7,"_374":-7,"_375":65,"_376":25,"_377":25,"_378":-5,"_379":25,"_380":25,"_381":25,"_382":-5},"ENV",{"_334":335,"_336":337,"_338":92,"_339":340,"_341":342,"_343":344,"_345":346,"_347":348,"_349":350,"_351":352,"_353":354,"_355":356,"_357":358,"_359":360,"_361":362},"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 · v111