[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_283":284,"_285":286},"routes/_app.x.$handle.$name",{"_103":102,"_32":44,"_112":89,"_27":113,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_20":-5,"_124":125,"_126":127,"_128":26,"_129":130,"_131":24,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":24,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":26},"version",13,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","migrate-add-cost-columns.ts","latestPath","fileId","1b7f6a54-efd3-11f0-bb51-42dde27851f2","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\n/**\n * Migration script to add cost tracking columns to existing table\n * Run this once to add cost, input_tokens, output_tokens, and total_tokens columns\n */\nasync function migrate() {\n const TABLE_NAME = \"github_leads_v3\";\n \n try {\n // Check if columns already exist\n const tableInfo = await sqlite.execute(\n `PRAGMA table_info(${TABLE_NAME})`\n );\n \n const existingColumns = new Set(\n tableInfo.rows.map((row: any) => row[1]) // column name is at index 1\n );\n \n console.log(\"Existing columns:\", Array.from(existingColumns));\n \n // Add columns if they don't exist\n const columnsToAdd = [\n { name: \"cost\", type: \"REAL\" },\n { name: \"input_tokens\", type: \"INTEGER\" },\n { name: \"output_tokens\", type: \"INTEGER\" },\n { name: \"total_tokens\", type: \"INTEGER\" },\n ];\n \n for (const column of columnsToAdd) {\n if (!existingColumns.has(column.name)) {\n console.log(`Adding column: ${column.name}`);\n await sqlite.execute(\n `ALTER TABLE ${TABLE_NAME} ADD COLUMN ${column.name} ${column.type}`\n );\n console.log(`✓ Added ${column.name}`);\n } else {\n console.log(`Column ${column.name} already exists, skipping`);\n }\n }\n \n console.log(\"Migration completed successfully!\");\n } catch (error) {\n console.error(\"Migration failed:\", error);\n throw error;\n }\n}\n\n// Run the migration\nawait migrate();\n","createdAt",["D",1768235042688],"branchVersion","branchId","93d1eab2-efcf-11f0-b668-42dde27851f2","id","93cf21f6-efcf-11f0-b668-42dde27851f2","github-potential-customers",["D",1768233526523],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Find people to hire or sell to from GitHub activity","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/37849e88-afe2-4cab-8fff-ad3f050d1200/square512?exp=1789581599&sig=671c41a00b3ebb399f0d82b0da17916ee897c0ba822ed03d97be811759f8d248","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18","pinnedFileId","019bb2ee-653f-7550-9be6-069697efa7ce","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","ba7bb5fb-1abb-4ffb-8f3d-7c244782e5f7","tursoName","93cf21f6efcf11f0b66842dde27851f2","tursoHostname","93cf21f6efcf11f0b66842dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789556471789],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_103":102,"_111":107},"org",{"_103":102,"_104":105,"_106":107,"_18":-5,"_108":109,"_110":24},"branch",{"_13":88,"_32":89,"_42":41,"_90":43,"_91":92,"_93":94,"_95":49,"_96":97,"_98":99,"_100":44,"_101":102},"isOwned",33,"main","projectId","forkedBranchId","2beae49c-ed74-11f0-997b-42dde27851f2","forkedBranchVersion",89,"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",{"_42":43,"_32":44,"_37":278,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":54,"_18":55,"_56":57,"_58":24,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":279,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":280,"_83":281,"_85":282,"_87":26},"tree",[237,238,239,240,241,242,243,244,245,246],"files",[237,238,239,240,241,242,243,244,245,246],"counts",{"_227":62,"_228":164,"_229":62,"_230":231,"_232":233},"contents",[150,151,152,153,154,155,156,157,158,159],"upstreamProject",{"_42":97,"_32":145,"_51":146,"_53":147,"_48":49,"_81":148},"upstreamBranch",{"_42":92,"_37":136,"_137":138,"_32":89,"_90":97,"_13":139,"_91":140,"_93":141,"_142":143,"_46":-5,"_87":26,"_48":49,"_101":144,"_63":99,"_100":145},"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","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/aeec28de-dccc-49ab-3dcc-66b67afd7700/square512?exp=1789581599&sig=9583071459ff32e24a5dd142cb9f0bf8c2e8c0bde03bf1c471215263eea9c0dd",{"_103":144,"_111":149},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789581599&sig=bed85510764f48a9de82762af4b4ce99c525d0ab75e5b57f327c71a53e183d4a",{"_42":220,"_32":221,"_30":222,"_163":-5,"_40":41,"_39":204,"_165":26,"_37":223,"_13":224,"_33":20,"_35":225,"_23":26,"_168":-5,"_27":226},{"_42":214,"_32":215,"_30":216,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":217,"_13":62,"_33":20,"_35":218,"_23":26,"_168":-5,"_27":219},{"_42":207,"_32":208,"_30":209,"_163":-5,"_40":41,"_39":210,"_165":26,"_37":211,"_13":164,"_33":34,"_35":212,"_23":26,"_168":-5,"_27":213},{"_42":199,"_32":200,"_30":201,"_163":-5,"_40":41,"_39":202,"_165":26,"_37":203,"_13":204,"_33":34,"_35":205,"_23":26,"_168":-5,"_27":206},{"_42":192,"_32":193,"_30":194,"_163":-5,"_40":41,"_39":195,"_165":26,"_37":196,"_13":164,"_33":34,"_35":197,"_23":26,"_168":-5,"_27":198},{"_42":186,"_32":187,"_30":188,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":189,"_13":62,"_33":183,"_35":190,"_23":26,"_168":-5,"_27":191},{"_42":179,"_32":180,"_30":181,"_163":-5,"_40":41,"_39":164,"_165":26,"_37":182,"_13":62,"_33":183,"_35":184,"_23":26,"_168":-5,"_27":185},{"_42":173,"_32":174,"_30":57,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":175,"_13":62,"_33":176,"_35":177,"_23":26,"_168":-5,"_27":178},{"_42":170,"_32":28,"_30":31,"_163":-5,"_40":41,"_39":14,"_165":26,"_37":171,"_13":62,"_33":34,"_35":36,"_23":26,"_168":-5,"_27":172},{"_42":160,"_32":161,"_30":162,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":166,"_13":62,"_33":34,"_35":167,"_23":26,"_168":-5,"_27":169},"93d635a4-efcf-11f0-b668-42dde27851f2","welcome-ui.tsx","019bb2ee-653f-7550-9be6-0b0f9277c8f0","parentId",1,"latest",["D",1768233526523],"/** @jsxImportSource npm:hono@4/jsx */\nimport { processLead } from \"./agent.ts\";\nimport { GITHUB_ORG } from \"./github.cron.ts\";\n\nconst ACTIVITY_TYPES = [\n { value: \"WatchEvent\", label: \"⭐ Star\" },\n { value: \"ForkEvent\", label: \"🍴 Fork\" },\n { value: \"IssuesEvent\", label: \"📝 Issue\" },\n { value: \"PullRequestEvent\", label: \"🔀 PR\" },\n];\n\nfunction createMockEvent(username: string, activityType: string, org: string) {\n const now = new Date().toISOString();\n const repoName = `${org}/example-repo`;\n\n const baseEvent = {\n id: `mock-${Date.now()}`,\n type: activityType,\n actor: {\n id: 0,\n login: username,\n display_login: username,\n gravatar_id: \"\",\n url: `https://api.github.com/users/${username}`,\n avatar_url: `https://github.com/${username}.png`,\n },\n repo: {\n id: 0,\n name: repoName,\n url: `https://api.github.com/repos/${repoName}`,\n },\n public: true,\n created_at: now,\n org: {\n id: 0,\n login: org,\n gravatar_id: \"\",\n url: `https://api.github.com/orgs/${org}`,\n avatar_url: `https://github.com/${org}.png`,\n },\n };\n\n switch (activityType) {\n case \"WatchEvent\":\n return { ...baseEvent, payload: { action: \"started\" } };\n case \"ForkEvent\":\n return {\n ...baseEvent,\n payload: {\n forkee: { full_name: `${username}/${repoName.split(\"/\")[1]}` },\n },\n };\n case \"IssuesEvent\":\n return {\n ...baseEvent,\n payload: {\n action: \"opened\",\n issue: { number: 1, title: \"Example issue\" },\n },\n };\n case \"PullRequestEvent\":\n return {\n ...baseEvent,\n payload: {\n action: \"opened\",\n pull_request: { number: 1, title: \"Example PR\" },\n },\n };\n default:\n return baseEvent;\n }\n}\n\nexport async function handleTestRequest(req: Request): Promise {\n try {\n const { username, activityType } = await req.json();\n\n if (!username || !activityType) {\n return Response.json({ error: \"Missing username or activityType\" }, {\n status: 400,\n });\n }\n\n const mockEvent = createMockEvent(username, activityType, GITHUB_ORG);\n const result = await processLead([mockEvent]);\n\n return Response.json({\n success: true,\n message: \"Lead processed! Refresh to see results.\",\n result,\n });\n } catch (error) {\n console.error(\"Test request error:\", error);\n return Response.json({ error: error.message }, { status: 500 });\n }\n}\n\ninterface WelcomePanelProps {\n testEndpoint: string;\n}\n\nexport function WelcomePanel({ testEndpoint }: WelcomePanelProps) {\n const scriptData = JSON.stringify({ testEndpoint });\n\n return (\n

\n \n Simulate Activity:\n \n @\n \n \n {ACTIVITY_TYPES.map((type) => (\n \n ))}\n \n \n Run\n \n \n

\n\n \n

\n );\n}","label",[161],"1b7f6946-efd3-11f0-bb51-42dde27851f2",["D",1768235042688],[28],"93d62884-efcf-11f0-b668-42dde27851f2","main.ts",["D",1768233526523],"http","import { Hono } from \"npm:hono@4\";\nimport { processLead, reanalyzeLead } from \"./agent.ts\";\nimport { app as dashboard } from \"./dashboard.tsx\";\nimport { handleTestRequest } from \"./welcome-ui.tsx\";\n\nconst app = new Hono();\n\napp.post(\"/\", async (c) => {\n // Early API key check to avoid confusing when using the tester ui\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n\n const body = await c.req.json();\n const url = new URL(c.req.url);\n const query = Object.fromEntries(url.searchParams);\n const inputData = Object.keys(query).length\n ? { ...body, _query: query }\n : body;\n\n // Fire-and-forget request for quick response and processing in another 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(inputData),\n });\n\n return c.json({ ok: true });\n});\n\napp.post(\"/process\", async (c) => {\n const inputData = await c.req.json();\n await processLead(inputData);\n return c.json({ ok: true });\n});\n\n// Test endpoint for the welcome UI\napp.post(\"/test\", async (c) => {\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n return handleTestRequest(c.req.raw);\n});\n\n// Reanalyze a lead\napp.post(\"/lead/:id/reanalyze\", async (c) => {\n if (!Deno.env.get(\"OPENAI_API_KEY\")) {\n return c.json(\n { error: \"Add OPENAI_API_KEY in Environment Variables\" },\n 503,\n );\n }\n \n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n return c.json({ error: \"Invalid lead ID\" }, { status: 400 });\n }\n \n try {\n const result = await reanalyzeLead(id);\n return c.json({ ok: true, ...result });\n } catch (error) {\n return c.json({ error: error.message }, { status: 500 });\n }\n});\n\napp.route(\"/\", dashboard);\n\nexport default app.fetch;\n",[174],"93d61f42-efcf-11f0-b668-42dde27851f2","github.cron.ts","019bb2ee-653f-7550-9be6-01e587ac7398",["D",1768233526523],"interval","import { processLead } from \"./agent.ts\";\nimport { appendFollowup, findLeadByInputPath } from \"./db.ts\";\nimport { Octokit } from \"npm:octokit@5.0.5\";\n\nexport const GITHUB_ORG = \"val-town\";\n\nexport default async function (interval: Interval) {\n const lastChecked = interval.lastRunAt ?? new Date(0);\n\n const octokit = new Octokit({ auth: Deno.env.get(\"GITHUB_TOKEN\") });\n const recentEvents = await octokit.paginate(\n octokit.rest.activity.listPublicOrgEvents,\n { org: GITHUB_ORG, per_page: 100 },\n );\n\n const newEvents = recentEvents\n .filter((e: any) => new Date(e.created_at) > lastChecked)\n .filter((e: any) => e.actor?.login && !e.actor?.login.includes(\"[bot]\"));\n console.log(`Processing ${newEvents.length} new events`);\n\n const actorEvents = Map.groupBy(newEvents, (e) => e.actor.login);\n console.log(`Found ${actorEvents.size} users`);\n\n await Promise.all(\n Array.from(actorEvents, async ([login, events]) => {\n const existingLead = await findLeadByInputPath(\"actor.login\", login);\n if (existingLead) {\n await appendFollowup(existingLead.id, events);\n } else {\n await processLead(events);\n }\n }),\n );\n}",[180],"93d5ff4e-efcf-11f0-b668-42dde27851f2","digest.ts","019bb2ee-653f-7550-9be5-fe8c59dfdc41",["D",1768233526523],"import { email } from \"https://esm.town/v/std/email\";\nimport { httpEndpoint } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getAllLeads } from \"./db.ts\";\n\n// ============================================================================\n// CONFIGURE: Add email addresses to receive the daily digest\n// ============================================================================\nconst RECIPIENTS = [\n \"steve@val.town\",\n \"charlie@val.town\",\n];\n\nfunction getSource(inputData) {\n const input = typeof inputData === \"string\"\n ? JSON.parse(inputData)\n : inputData;\n const first = Array.isArray(input) ? input[0] : input;\n if (first?.actor?.login) return \"github\";\n if (first?._query?.source) return first._query.source;\n return null;\n}\n\nfunction getRepos(inputData): string[] {\n const input = typeof inputData === \"string\"\n ? JSON.parse(inputData)\n : inputData;\n const events = Array.isArray(input) ? input : [input];\n const repos = new Set();\n for (const event of events) {\n if (event?.repo?.name) {\n repos.add(event.repo.name);\n }\n }\n return Array.from(repos);\n}\n\nfunction formatHTML(matches, dashboardUrl) {\n const typeStyles: Record = {\n customer: { bg: \"#d1fae5\", color: \"#047857\" },\n hire: { bg: \"#ede9fe\", color: \"#6d28d9\" },\n };\n\n const rows = matches.map((l) => {\n const scoreDisplay = l.score\n ? `${l.score}`\n : \"\";\n\n const leadTypesDisplay = l.leadTypes && l.leadTypes.length > 0\n ? l.leadTypes.map((type: string) => {\n const style = typeStyles[type] || { bg: \"#f3f4f6\", color: \"#374151\" };\n return `${type}`;\n }).join(\"\")\n : \"\";\n\n const sourceTag = l.source\n ? `${l.source}`\n : \"\";\n\n const reposDisplay = l.repos && l.repos.length > 0\n ? `

${\n l.repos.map((repo: string) =>\n `📦 ${\n repo.split(\"/\")[1]\n }`\n ).join(\"\")\n }

`\n : \"\";\n\n return `\n \n \n

\n ${scoreDisplay}${l.name} ${leadTypesDisplay}${sourceTag}\n

\n ${l.reasoning}\n

\n ${reposDisplay}\n \n \n `;\n }).join(\"\");\n\n return `\n \n \n \n \n

🎯 ${matches.length} Qualified Lead${\n matches.length !== 1 ? \"s\" : \"\"\n }

\n \n \n ${rows}\n \n

\n View dashboard\n

\n \n \n `;\n}\n\nexport default async function (interval?: { lastRunAt?: Date }) {\n console.log(\"interval received:\", JSON.stringify(interval));\n\n if (RECIPIENTS.length === 0) {\n console.log(\"No RECIPIENTS configured in digest.ts, skipping email\");\n return { sent: false, reason: \"no_recipients\" };\n }\n\n const dashboardUrl = await httpEndpoint(\"main.ts\", import.meta.url);\n const since = interval?.lastRunAt?.getTime() ??\n Date.now() - 24 * 60 * 60 * 1000;\n\n console.log(\"looking back to:\", new Date(since).toISOString());\n\n const leads = await getAllLeads();\n console.log(\"total leads in db:\", leads.length);\n\n const matches = leads\n .filter((l) => l.timestamp > since)\n .filter((l) => JSON.parse(l.output_data).match)\n .map((l) => ({\n id: l.id,\n source: getSource(l.input_data),\n repos: getRepos(l.input_data),\n ...JSON.parse(l.output_data),\n }))\n .sort((a, b) => (b.score ?? 0) - (a.score ?? 0));\n\n console.log(\"matches found:\", matches.length);\n\n if (matches.length === 0) {\n console.log(\"No matches since\", new Date(since).toISOString());\n return { sent: false };\n }\n\n const subject = `🎯 ${matches.length} Qualified Lead${\n matches.length !== 1 ? \"s\" : \"\"\n }`;\n await email({\n to: RECIPIENTS,\n subject,\n html: formatHTML(matches, dashboardUrl),\n });\n\n console.log(\n `Sent digest: ${matches.length} leads to ${RECIPIENTS.join(\", \")}`,\n );\n return { sent: true, count: matches.length };\n}",[187],"fb938388-efd2-11f0-bb51-42dde27851f2","db.ts","019bb2ee-653f-7550-9be5-fbf6f6bc4a00",8,["D",1768234989120],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst TABLE_NAME = \"github_leads_v3\";\n\nawait createTable();\n\nexport interface Lead {\n id: number;\n timestamp: number;\n input_data: string;\n output_data: string;\n cost?: number;\n input_tokens?: number;\n output_tokens?: number;\n total_tokens?: number;\n}\n\nexport async function storeLead(\n inputData: Record | Record[],\n outputData: Record,\n usage?: {\n cost: number;\n input_tokens: number;\n output_tokens: number;\n total_tokens: number;\n },\n) {\n // Always store as array\n const inputArray = Array.isArray(inputData) ? inputData : [inputData];\n await sqlite.execute(\n `INSERT INTO ${TABLE_NAME} (timestamp, input_data, output_data, cost, input_tokens, output_tokens, total_tokens)\n VALUES (?, ?, ?, ?, ?, ?, ?)`,\n [\n Date.now(),\n JSON.stringify(inputArray),\n JSON.stringify(outputData),\n usage?.cost || null,\n usage?.input_tokens || null,\n usage?.output_tokens || null,\n usage?.total_tokens || null,\n ],\n );\n}\n\nexport async function updateLeadOutput(\n id: number,\n outputData: Record,\n usage?: {\n cost: number;\n input_tokens: number;\n output_tokens: number;\n total_tokens: number;\n },\n) {\n if (usage) {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ?, cost = ?, input_tokens = ?, output_tokens = ?, total_tokens = ? WHERE id = ?`,\n [\n JSON.stringify(outputData),\n usage.cost,\n usage.input_tokens,\n usage.output_tokens,\n usage.total_tokens,\n id,\n ],\n );\n } else {\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET output_data = ? WHERE id = ?`,\n [JSON.stringify(outputData), id],\n );\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 result.rows as unknown as Lead[];\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 return result.rows[0] as unknown as Lead;\n}\n\nexport async function findLeadByInputPath(\n path: string,\n value: string,\n): Promise {\n const leads = await getAllLeads();\n return leads.find((lead) => {\n const input = JSON.parse(lead.input_data);\n // Check first event in array for the path\n const firstEvent = Array.isArray(input) ? input[0] : input;\n return path.split(\".\").reduce((obj, key) => obj?.[key], firstEvent) ===\n value;\n }) || null;\n}\n\nexport async function appendFollowup(\n id: number,\n data: Record | Record[],\n) {\n const lead = await getLeadById(id);\n const input = JSON.parse(lead!.input_data);\n const events = Array.isArray(input) ? input : [input];\n if (Array.isArray(data)) events.push(...data);\n else events.push(data);\n await sqlite.execute(\n `UPDATE ${TABLE_NAME} SET input_data = ? WHERE id = ?`,\n [JSON.stringify(events), id],\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 cost REAL,\n input_tokens INTEGER,\n output_tokens INTEGER,\n total_tokens INTEGER\n )`,\n );\n}\n",[193],"1580af78-efd3-11f0-bb51-42dde27851f2","dashboard.tsx","019bb2ee-653f-7550-9be5-f50f592755ca",12,["D",1768235032627],7,"/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport { getAllLeads, getLeadById, Lead } from \"./db.ts\";\nimport { WelcomePanel } from \"./welcome-ui.tsx\"; // DELETE THIS LINE to remove onboarding UI\nimport { marked } from \"npm:marked@11\";\n\nexport const app = new Hono();\n\nfunction getRepos(input: unknown): string[] {\n const events = Array.isArray(input) ? input : [input];\n const repos = new Set();\n for (const event of events) {\n if (event?.repo?.name) {\n repos.add(event.repo.name);\n }\n }\n return Array.from(repos);\n}\n\nfunction getSource(input: unknown): string | null {\n const first = Array.isArray(input) ? input[0] : input;\n if (first?.actor?.login) return \"github\";\n if (first?._query?.source) return first._query.source;\n return null;\n}\n\nfunction getUsername(input: unknown): string | null {\n const first = Array.isArray(input) ? input[0] : input;\n return first?.actor?.login || null;\n}\n\nfunction ReposList({ repos }: { repos: string[] }) {\n if (repos.length === 0) return null;\n return (\n

\n Repositories ({repos.length})\n

\n {repos.map((repo) => (\n \n \n {repo}\n \n ))}\n

\n );\n}\n\nfunction Layout({ children, title }: { children: any; title: string }) {\n return (\n \n \n \n \n {title}\n \n \n \n {children}\n \n );\n}\n\nfunction SourceBadge({ source }: { source: string | null }) {\n if (!source) return null;\n\n if (source === \"github\") {\n return (\n \n \n GitHub\n \n );\n }\n\n return (\n \n {source}\n \n );\n}\n\nfunction ScoreBadge({ score }: { score?: number }) {\n if (score === undefined || score === null) return null;\n\n const color = score >= 70\n ? \"bg-blue-100 text-blue-700\"\n : score >= 50\n ? \"bg-amber-100 text-amber-700\"\n : \"bg-gray-100 text-gray-500\";\n\n return (\n \n {score}\n \n );\n}\n\nfunction LeadTypeBadges({ leadTypes }: { leadTypes?: string[] }) {\n if (!leadTypes || leadTypes.length === 0) return null;\n\n const typeStyles: Record = {\n customer: \"bg-emerald-100 text-emerald-700\",\n hire: \"bg-purple-100 text-purple-700\",\n };\n\n return (\n <>\n {leadTypes.map((type) => (\n \n {type}\n \n ))}\n \n );\n}\n\nfunction LeadRow({ lead, isMatch }: { lead: Lead; isMatch: boolean }) {\n const output = JSON.parse(lead.output_data);\n const input = JSON.parse(lead.input_data);\n const eventCount = Array.isArray(input) ? input.length : 1;\n const source = getSource(input);\n const date = new Date(lead.timestamp).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n\n return (\n \n \n \n \n {output.name || \"Unknown\"}\n \n \n \n {eventCount > 1 && (\n \n {eventCount}\n \n )}\n {lead.cost !== undefined && lead.cost !== null && (\n \n ${lead.cost.toFixed(4)}\n \n )}\n {date}\n \n );\n}\n\nconst Arrow = () => (\n \n \n \n);\n\nfunction DataValue(\n { value, path, keyName }: { value: unknown; path: string; keyName?: string },\n) {\n if (value === null || value === undefined) {\n return (\n \n {keyName && {keyName}:}\n null\n \n );\n }\n\n if (typeof value !== \"object\") {\n return (\n \n {keyName && {keyName}:}\n {String(value)}\n \n );\n }\n\n if (Array.isArray(value)) {\n if (value.length === 0) {\n return (\n \n {keyName && {keyName}:}\n []\n \n );\n }\n const id = `arr-${path}`;\n return (\n

\n \n \n {keyName && {keyName}}\n [{value.length}]\n

\n {value.map((item, idx) => (\n

\n \n

\n ))}\n

\n \n );\n }\n\n const entries = Object.entries(value);\n if (entries.length === 0) {\n return (\n \n {keyName && {keyName}:}\n {\"{}\"}\n \n );\n }\n const id = `obj-${path}`;\n return (\n

\n \n \n {keyName && {keyName}}\n {`{${entries.length}}`}\n

\n {entries.map(([k, v]) => (\n

\n \n

\n ))}\n

\n \n );\n}\n\nfunction DataTable({ title, data }: { title: string; data: unknown }) {\n if (data === null || data === undefined) return null;\n\n if (Array.isArray(data)) {\n return (\n

\n {title} ({data.length})\n

\n {data.map((item, idx) => (\n

Event {idx + 1}

\n {Object.entries(item).map(([k, v]) => (\n

\n \n

\n ))}\n

\n );\n }\n\n const entries = Object.entries(data as Record);\n if (entries.length === 0) return null;\n\n return (\n

\n {title}\n

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

\n \n

\n ))}\n

\n );\n}\n\napp.get(\"/\", async (c) => {\n const leads = await getAllLeads();\n const baseUrl = new URL(c.req.url).origin;\n const testEndpoint = `${baseUrl}/test`;\n\n const matches = leads.filter((l) => JSON.parse(l.output_data).match === true);\n const nonMatches = leads.filter((l) =>\n JSON.parse(l.output_data).match !== true\n );\n\n return c.html(\n \n

\n \n\n

GitHub Leads

\n \n view source\n \n

\n {leads.length} leads · {matches.length} matches\n {(() => {\n const totalCost = leads.reduce((sum, l) => sum + (l.cost || 0), 0);\n return totalCost > 0 ? ` · ${totalCost.toFixed(4)} total cost` : '';\n })()}\n

\n\n {leads.length === 0\n ? (\n

\n No leads yet. Configure your GitHub org and wait for activity, or\n use \"Try It Out\" above.\n

\n )\n : (\n

\n {matches.map((lead) => )}\n\n {nonMatches.length > 0 && (\n

\n \n {nonMatches.length} not matched\n v\n \n

\n {nonMatches.map((lead) => (\n \n ))}\n

\n )}\n

\n ,\n );\n});\n\napp.get(\"/lead/:id\", async (c) => {\n const id = parseInt(c.req.param(\"id\"));\n const lead = await getLeadById(id);\n\n if (!lead) {\n return c.html(\n \n

Lead Not Found

\n \n ← Back\n \n

\n ,\n 404,\n );\n }\n\n const input = JSON.parse(lead.input_data);\n const output = JSON.parse(lead.output_data);\n console.log(\"Raw reasoning data:\", JSON.stringify(output.reasoning));\n console.log(\"Reasoning with visible newlines:\", output.reasoning.replace(/\\n/g, '\\\\n'));\n const repos = getRepos(input);\n const source = getSource(input);\n const username = getUsername(input);\n\n return c.html(\n \n

\n \n ← Back\n \n\n

\n {output.name || \"Unknown\"}\n

\n \n \n \n

\n {username && (\n \n @{username}\n \n )}\n

\n {new Date(lead.timestamp).toLocaleString()}\n

\n {lead.cost !== undefined && lead.cost !== null && (\n

\n Cost: ${lead.cost.toFixed(4)}\n {lead.input_tokens !== undefined && lead.output_tokens !== undefined && (\n \n ({lead.input_tokens?.toLocaleString()} in / {lead.output_tokens?.toLocaleString()} out)\n \n )}\n

\n )}\n

\n\n {/* Result Summary */}\n \n

\n \n \n {output.match ? \"Match\" : \"No Match\"}\n \n

\n\n {/* Reanalyze Button */}\n

\n location.reload())`}\n class=\"px-4 py-2 bg-gray-100 hover:bg-gray-200 text-gray-700 border border-gray-200 disabled:opacity-50 font-medium rounded-lg text-sm\"\n >\n Reanalyze\n \n

\n\n {/* GitHub Repositories */}\n \n\n {/* AI Output first */}\n \n\n {/* Input Data second */}\n \n

\n ,\n );\n});\n\nexport default app.fetch;",[200],"02cc56fc-efd3-11f0-bb51-42dde27851f2","agent.ts","019bb2ee-653f-7550-9be5-f0e72231c1f3",9,["D",1768235001251],"import { readFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Agent, run, webSearchTool } from \"npm:@openai/agents@0.3.0\";\nimport { getLeadById, storeLead, updateLeadOutput } from \"./db.ts\";\n\nconst PROMPT = await readFile(\"/PROMPT.txt\");\nconst agent = new Agent({\n name: \"Researcher\",\n model: \"gpt-5\",\n tools: [webSearchTool()],\n instructions: PROMPT,\n});\n\n// GPT-5 pricing per 1M tokens\nconst GPT5_INPUT_COST = 1.25; // $1.25 per 1M input tokens\nconst GPT5_OUTPUT_COST = 10.0; // $10.00 per 1M output tokens\n\nfunction calculateCost(inputTokens: number, outputTokens: number): number {\n const inputCost = (inputTokens / 1_000_000) * GPT5_INPUT_COST;\n const outputCost = (outputTokens / 1_000_000) * GPT5_OUTPUT_COST;\n return inputCost + outputCost;\n}\n\nasync function analyzeLead(inputData: any) {\n const result = await run(agent, JSON.stringify(inputData));\n const outputData = JSON.parse(result.finalOutput);\n \n // Extract usage information\n const usage = result.context_wrapper?.usage;\n const usageData = usage ? {\n cost: calculateCost(usage.input_tokens, usage.output_tokens),\n input_tokens: usage.input_tokens,\n output_tokens: usage.output_tokens,\n total_tokens: usage.total_tokens,\n } : undefined;\n \n return { outputData, usage: usageData };\n}\n\nexport async function processLead(inputData: any) {\n const { outputData, usage } = await analyzeLead(inputData);\n await storeLead(inputData, outputData, usage);\n console.log(outputData);\n if (usage) {\n console.log(`Cost: $${usage.cost.toFixed(4)} (${usage.input_tokens} in, ${usage.output_tokens} out)`);\n }\n return { outputData, usage };\n}\n\nexport async function reanalyzeLead(id: number) {\n const lead = await getLeadById(id);\n if (!lead) throw new Error(`Lead ${id} not found`);\n\n const { outputData, usage } = await analyzeLead(lead.input_data);\n await updateLeadOutput(id, outputData, usage);\n return { outputData, usage };\n}\n",[208],"93d5833e-efcf-11f0-b668-42dde27851f2","README.md","019bb2ee-653f-7550-9be5-eedc86c66089",["D",1768233526523],"# GitHub Leads\n\nFind potential customers from GitHub activity. Monitor your org's repos for\nstars, forks, issues, and PRs — then use AI to qualify leads automatically.\n\n![image.png](https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/fa6f2423-2001-4c80-c5fb-7a85e1b47100/public)\n\n## What this does\n\n1. A cron job monitors public activity on your GitHub org\n2. When someone stars, forks, or opens an issue/PR, they're captured\n3. An AI agent researches the person and scores them as a lead\n4. Qualified leads appear in your dashboard with periodic digest emails\n\n## Getting started\n\n1. Click [**Remix**](/?intent=remix)\n2. Add environment variables:\n - `OPENAI_API_KEY` — for AI lead qualification\n - `GITHUB_TOKEN` — for accessing GitHub API\n ([create one here](https://github.com/settings/tokens))\n3. Configure your settings:\n - Edit `GITHUB_ORG` in [`github.cron.ts`](./github.cron.ts)\n - Edit `RECIPIENTS` in [`digest.ts`](./digest.ts)\n - Customize [`PROMPT.txt`](./PROMPT.txt) with your ICP criteria\n4. Open [`main.ts`](./main.ts) to view your dashboard\n\n**Note:** GitHub's Events API only returns the 300 most recent events per org.\n\n## How it works\n\n**GitHub Monitoring** ([`github.cron.ts`](./github.cron.ts))\n\n- Runs hourly to check for new activity on your org\n- Captures stars, forks, issues, PRs, and other public events\n- Groups events by user to avoid duplicate leads\n\n**AI Agent** ([`agent.ts`](./agent.ts))\n\n- Researches each GitHub user's profile, repos, and linked sites\n- Uses web search to learn about their company and role\n- Scores them against your ICP defined in [`PROMPT.txt`](./PROMPT.txt)\n- Returns `{name, match, score, leadTypes, reasoning}`\n\n**Storage** ([`db.ts`](./db.ts))\n\n- Every lead is stored in SQLite with columns:\n - `id` — auto-incremented\n - `timestamp` — when first seen\n - `input_data` — the GitHub event(s) that triggered it\n - `output_data` — AI result\n\n**Dashboard** ([`main.ts`](./main.ts))\n\n- Qualified leads (match=true) appear at the top\n- Shows score and lead type tags (customer/hire)\n- Click a lead to see full details and GitHub activity\n\n**Email Digest** ([`digest.ts`](./digest.ts))\n\n- Sends daily emails (1pm UTC) with new qualified leads\n- Edit `RECIPIENTS` array to configure who receives them\n\n## Customization\n\n- Edit [`PROMPT.txt`](./PROMPT.txt) to define your ideal customer profile\n- Adjust the GitHub sweep frequency in [`github.cron.ts`](./github.cron.ts)\n interval settings (default: hourly)\n- Adjust the email digest schedule in [`digest.ts`](./digest.ts) interval\n settings (default: daily at 1pm UTC)\n\n## Testing\n\nUse the test bar in the dashboard to evaluate any GitHub username instantly.",[215],"25dfa154-efd2-11f0-afc9-42dde27851f2","PROMPT.txt","019bb2ee-653f-7550-9be5-ea727f84dce2",["D",1768234630599],2,"You are an assistant to the CEO of Val Town.\n\nVal Town is like Zapier for people who know how to code, a tool for writing code and getting it running in the cloud,\nparticularly useful for lightweight automations in technical teams.\n\nI'm sending you data about GitHub activity and it's your job to exhuastively research the person by visiting their \nlinks, finding their personal and company sites, blogs they've written, etc to determine if they are in Val Town's \nideal customer profile.\n\nVal Town's ideal customer profile:\n\n1. Founder\n2. B2B SaaS Startup\n3. Seed-stage (approximately)\n4. They know how to code\n\nReturn your final response in JSON only with the following schema:\n\n{\n \"name\": string,\n \"match\": boolean,\n \"score\": number,\n \"reasoning\": string\n}\n\nFor the \"reasoning\" field, write in Markdown. Include newlines where appropriate.",[221],"pulls","branches","forks","envVars",{"_234":224,"_236":62},"connections",{"_234":62,"_235":62},"count","unfilledCount","emptyCount",{"_42":220,"_32":221,"_30":222,"_163":-5,"_40":41,"_39":204,"_165":26,"_37":275,"_13":224,"_33":20,"_35":225,"_23":26,"_168":-5,"_248":276,"_27":277},{"_42":214,"_32":215,"_30":216,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":272,"_13":62,"_33":20,"_35":218,"_23":26,"_168":-5,"_248":273,"_27":274},{"_42":207,"_32":208,"_30":209,"_163":-5,"_40":41,"_39":210,"_165":26,"_37":269,"_13":164,"_33":34,"_35":212,"_23":26,"_168":-5,"_248":270,"_27":271},{"_42":199,"_32":200,"_30":201,"_163":-5,"_40":41,"_39":202,"_165":26,"_37":266,"_13":204,"_33":34,"_35":205,"_23":26,"_168":-5,"_248":267,"_27":268},{"_42":192,"_32":193,"_30":194,"_163":-5,"_40":41,"_39":195,"_165":26,"_37":263,"_13":164,"_33":34,"_35":197,"_23":26,"_168":-5,"_248":264,"_27":265},{"_42":186,"_32":187,"_30":188,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":260,"_13":62,"_33":183,"_35":190,"_23":26,"_168":-5,"_248":261,"_27":262},{"_42":179,"_32":180,"_30":181,"_163":-5,"_40":41,"_39":164,"_165":26,"_37":257,"_13":62,"_33":183,"_35":184,"_23":26,"_168":-5,"_248":258,"_27":259},{"_42":173,"_32":174,"_30":57,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":254,"_13":62,"_33":176,"_35":177,"_23":26,"_168":-5,"_248":255,"_27":256},{"_42":170,"_32":28,"_30":31,"_163":-5,"_40":41,"_39":14,"_165":26,"_37":251,"_13":62,"_33":34,"_35":36,"_23":26,"_168":-5,"_248":252,"_27":253},{"_42":160,"_32":161,"_30":162,"_163":-5,"_40":41,"_39":164,"_165":24,"_37":247,"_13":62,"_33":34,"_35":167,"_23":26,"_168":-5,"_248":249,"_27":250},["D",1768233526523],"children",[],[161],["D",1768235042688],[],[28],["D",1768233526523],[],[174],["D",1768233526523],[],[180],["D",1768233526523],[],[187],["D",1768234989120],[],[193],["D",1768235032627],[],[200],["D",1768235001251],[],[208],["D",1768233526523],[],[215],["D",1768234630599],[],[221],["D",1768233526523],["D",1789556471789],{"_103":102,"_111":107},{"_103":102,"_104":105,"_106":107,"_18":-5,"_108":109,"_110":24},{"_13":88,"_32":89,"_42":41,"_90":43,"_91":92,"_93":94,"_95":49,"_96":97,"_98":99,"_100":44,"_101":102},"ctx",{"_81":-5,"_133":316,"_317":318,"_319":320,"_321":26,"_322":26,"_323":26,"_324":24,"_325":-5,"_326":-7,"_327":-7,"_328":62,"_329":26,"_330":26,"_331":-5,"_332":26,"_333":26,"_334":26,"_335":-5},"ENV",{"_287":288,"_289":290,"_291":89,"_292":293,"_294":295,"_296":297,"_298":299,"_300":301,"_302":303,"_304":305,"_306":307,"_308":309,"_310":311,"_312":313,"_314":315},"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 · v13