[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_308":309,"_310":311},"routes/_app.x.$handle.$name",{"_99":98,"_31":44,"_108":89,"_26":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":24,"_123":124,"_125":58,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_31":44,"_37":45,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_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":24},"version",49,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":24},"previous","deleted",false,"deletedHere","path","lib/vibe.ts","latestPath","fileId","e570c70e-af77-11f1-95c6-1607ee4eb77e","name","vibe.ts","fileType","script","content","// Neighborhood vibe layer (Part 5) - filled in after Parts 1-4 deploy. Stubs keep cron/enrich.ts deployable.\nexport async function geocodeStep(_started: number, _budget: number): Promise { return { skipped: \"not implemented yet\" }; }\nexport async function vibeStep(_started: number, _budget: number): Promise { return { skipped: \"not implemented yet\" }; }\n","createdAt",["D",1789306491009],"branchVersion","branchId","a4c5838e-3adb-4640-ab71-e9f3d2b72f0a","id","b7ccec7e-ebe9-4364-ba98-e367c8d8849b","housing",["D",1789248987477],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","DC housing search pipeline","imageUrl","87445237-7d14-45c7-b3a2-72e031f10ec1","pinnedFileId","0544e21c-aef2-11f1-a6f0-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a09786-a61b-74b5-8910-af3116d3de5c","tursoName","b7ccec7eebe94364ba98e367c8d8849b","tursoHostname","b7ccec7eebe94364ba98e367c8d8849b-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789519256886],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},"branch",{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"isOwned",71,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","logan1","handle","displayName","Logan","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFxddfJftSiTFZN49YShT3nY7q8GOQ7dXYM2vJ6XkajnQMGA=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_42":43,"_31":44,"_37":303,"_46":-5,"_47":24,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":304,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":305,"_83":306,"_85":307,"_87":24},"tree",[172,177,182,184],"files",[172,173,174,175,176,177,178,179,180,181,182,183,184,185,186,187,188],"counts",{"_162":62,"_163":138,"_164":62,"_165":166,"_167":168},"contents",[130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":156,"_31":157,"_29":158,"_137":-5,"_40":41,"_39":159,"_139":58,"_37":160,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_26":161},{"_42":150,"_31":151,"_29":152,"_137":-5,"_40":41,"_39":153,"_139":58,"_37":154,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_26":155},{"_42":144,"_31":145,"_29":146,"_137":-5,"_40":41,"_39":147,"_139":58,"_37":148,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_26":149},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":58,"_37":140,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_26":143},"3019fed4-fb55-4304-982a-27563c4bac65","lib","03892172-aef2-11f1-9a6d-1607ee4eb77e","parentId",1,"latest",["D",1789248988970],"directory","label",[135],"27f1b4ee-4369-441d-ac9b-84788125d19c","email","c5747c18-ef02-4239-beb4-bae26fa9425f",32,["D",1789299968238],[145],"a6e88f36-5bc0-4bcb-92fb-69a5d6485a73","cron","041eaecc-aef2-11f1-9a8e-1607ee4eb77e",3,["D",1789248989948],[151],"5c11403c-d645-4b4e-b1c8-b1cc89a025ad","api","03d27d86-aef2-11f1-ba0a-1607ee4eb77e",2,["D",1789248989432],[157],"pulls","branches","forks","envVars",{"_169":159,"_171":62},"connections",{"_169":62,"_170":62},"count","unfilledCount","emptyCount",{"_42":156,"_31":157,"_29":158,"_137":-5,"_40":41,"_39":159,"_139":58,"_37":300,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_191":301,"_26":302},{"_42":293,"_31":294,"_29":56,"_137":158,"_40":41,"_39":295,"_139":58,"_37":296,"_13":159,"_33":272,"_35":297,"_23":24,"_142":-5,"_191":298,"_26":299},{"_42":284,"_31":285,"_29":286,"_137":158,"_40":41,"_39":287,"_139":24,"_37":288,"_13":289,"_33":272,"_35":290,"_23":24,"_142":-5,"_191":291,"_26":292},{"_42":276,"_31":277,"_29":278,"_137":158,"_40":41,"_39":279,"_139":58,"_37":280,"_13":159,"_33":272,"_35":281,"_23":24,"_142":-5,"_191":282,"_26":283},{"_42":267,"_31":268,"_29":269,"_137":158,"_40":41,"_39":270,"_139":24,"_37":271,"_13":138,"_33":272,"_35":273,"_23":24,"_142":-5,"_191":274,"_26":275},{"_42":150,"_31":151,"_29":152,"_137":-5,"_40":41,"_39":153,"_139":58,"_37":264,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_191":265,"_26":266},{"_42":256,"_31":257,"_29":258,"_137":152,"_40":41,"_39":259,"_139":58,"_37":260,"_13":153,"_33":236,"_35":261,"_23":24,"_142":-5,"_191":262,"_26":263},{"_42":248,"_31":249,"_29":250,"_137":152,"_40":41,"_39":251,"_139":24,"_37":252,"_13":159,"_33":236,"_35":253,"_23":24,"_142":-5,"_191":254,"_26":255},{"_42":240,"_31":241,"_29":242,"_137":152,"_40":41,"_39":243,"_139":58,"_37":244,"_13":159,"_33":236,"_35":245,"_23":24,"_142":-5,"_191":246,"_26":247},{"_42":232,"_31":195,"_29":233,"_137":152,"_40":41,"_39":234,"_139":24,"_37":235,"_13":159,"_33":236,"_35":237,"_23":24,"_142":-5,"_191":238,"_26":239},{"_42":144,"_31":145,"_29":146,"_137":-5,"_40":41,"_39":147,"_139":58,"_37":229,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_191":230,"_26":231},{"_42":222,"_31":223,"_29":224,"_137":146,"_40":41,"_39":147,"_139":58,"_37":225,"_13":62,"_33":145,"_35":226,"_23":24,"_142":-5,"_191":227,"_26":228},{"_42":134,"_31":135,"_29":136,"_137":-5,"_40":41,"_39":138,"_139":58,"_37":219,"_13":62,"_33":141,"_35":-5,"_23":24,"_142":-5,"_191":220,"_26":221},{"_42":210,"_31":211,"_29":212,"_137":136,"_40":41,"_39":213,"_139":24,"_37":214,"_13":215,"_33":20,"_35":216,"_23":24,"_142":-5,"_191":217,"_26":218},{"_42":202,"_31":203,"_29":204,"_137":136,"_40":41,"_39":205,"_139":24,"_37":206,"_13":62,"_33":34,"_35":207,"_23":24,"_142":-5,"_191":208,"_26":209},{"_42":194,"_31":195,"_29":196,"_137":136,"_40":41,"_39":197,"_139":24,"_37":198,"_13":153,"_33":34,"_35":199,"_23":24,"_142":-5,"_191":200,"_26":201},{"_42":189,"_31":32,"_29":30,"_137":136,"_40":41,"_39":14,"_139":24,"_37":190,"_13":62,"_33":34,"_35":36,"_23":24,"_142":-5,"_191":192,"_26":193},"9733bcd3-1de2-4753-b534-80a2ed11f44f",["D",1789306491009],"children",[],[135,32],"c4828616-10ba-470b-84a2-9c3b4f91c8de","sources.ts","18a74ccc-af66-11f1-9858-1607ee4eb77e",36,["D",1789302809103],"// Multi-source registry + one parser per platform. Pure functions (text -> hits) so they are\n// unit-testable against scripts/fixtures/*. The cron (cron/sources.ts) does the fetching,\n// rotation, dedupe and upsert. Adding a source = one REGISTRY entry (+ a parser if new platform).\n// Per-source gotchas are documented in valtown/SOURCES.md.\nimport {\n decodeEntities, stripTags, inferArea, inferBeds, inferPrice, parsePrice, type Area, type Listing,\n} from \"./core.ts\";\nimport { parseSearch as clParseSearch } from \"../cron/craigslist.ts\";\n\nexport type Kind = \"listing\" | \"parking\" | \"signal\";\nexport interface Hit {\n extId: string; // stable per-source id (dedupe key)\n url: string;\n addr: string | null; // street address if known\n price: number | null;\n beds: number | null; // null = unknown (caller clamps), 0 = studio\n text: string; // everything we know, for the infer* helpers\n zip?: string | null;\n lat?: number | null; lon?: number | null;\n park?: Listing[\"park\"]; type?: Listing[\"type\"]; ll?: Listing[\"ll\"]; dog?: boolean | null; // structured overrides\n note?: string;\n posted?: string | number | null; // source's first-posted date when it exposes one (listing date, pubDate, issue date)\n detailUrl?: string; // fetch this for structured fields (Nestfully)\n}\nexport interface ParseResult { hits: Hit[]; more?: boolean; }\nexport type Parser = (text: string, ctx: { url: string; zip?: string; area?: Area }) => ParseResult;\n\nexport interface Source {\n key: string; // becomes listings.source and poll_log job 'sources:'\n parser: keyof typeof PARSERS;\n urls: string[]; // fetched in order; parser may request more pages via ParseResult.more + pageUrl()\n every: number; // minutes between runs\n ll: Listing[\"ll\"]; // default landlord type for this source\n kind?: Kind; // default 'listing'\n push?: boolean; // default true for listings; parking/signals never push\n pushMin?: number; // override PUSH_THRESHOLD for this source (RSS = 6)\n enabled?: boolean; // false = skipped without redeploying parsers\n zip?: string; // zip context for parsers that don't carry one (CL sub/prk)\n headers?: Record;\n accept?: \"html\" | \"json\" | \"xml\";\n pageUrl?: (base: string, n: number) => string; // n >= 2\n maxPages?: number;\n detailCap?: number; // detail fetches per run (Nestfully)\n spacingMs?: number; // delay between fetches to the same source\n group?: string; // at most one source per group runs per invocation (Cloudflare bursts: Nestfully)\n}\n\nexport const TARGET_ZIPS = [\"20010\", \"20011\", \"20012\", \"22206\", \"22204\", \"22301\", \"22305\", \"20781\", \"20782\"];\nexport const ZIP_RE = /\\b(2001[012]|2220[46]|2230[15]|2078[12])\\b/;\nconst NAV_HEADERS = {\n \"accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\",\n \"accept-language\": \"en-US,en;q=0.9\",\n \"upgrade-insecure-requests\": \"1\",\n \"sec-fetch-mode\": \"navigate\", \"sec-fetch-dest\": \"document\", \"sec-fetch-site\": \"none\",\n};\n\n// ---------- helpers ----------\nconst clean = (s: string) => decodeEntities(s).replace(/\\s+/g, \" \").trim();\nfunction pipeText(html: string): string {\n // tags -> \" | \" separators so label/value pairs survive\n const t = html.replace(//g, \"\").replace(/|/gi, \"\").replace(/<[^>]+>/g, \" | \");\n return decodeEntities(t).replace(/\\s+/g, \" \").replace(/(\\s*\\|\\s*)+/g, \" | \").trim();\n}\nfunction labelValue(pt: string, label: string): string | null {\n const m = pt.match(new RegExp(label.replace(/[.*+?^${}()|[\\]\\\\]/g, \"\\\\$&\") + \"\\\\s*:?\\\\s*\\\\|\\\\s*([^|]+)\"));\n return m ? m[1].trim() : null;\n}\nexport function inferZip(s: string): string | null { return (s.match(ZIP_RE) || [])[1] || null; }\nfunction bedsFrom(s: string): number | null { return inferBeds(s); }\n\n// ---------- 1a. Nestfully (Bright MLS consumer portal) ----------\nexport const nestfully: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n const descByUrl = new Map();\n const postedByUrl = new Map();\n for (const m of html.matchAll(/\n\n`;\n\nexport default async function (req: Request): Promise {\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\n if (!checkToken(req)) {\n return new Response(\n \"unauthorized: open the tracker link that includes ?token=\",\n { status: 401 },\n );\n }\n return new Response(HTML, {\n headers: {\n \"content-type\": \"text/html; charset=utf-8\",\n \"cache-control\": \"no-store\",\n \"x-robots-tag\": \"noindex\",\n },\n });\n}",[],[157,268],"9d7d683c-4161-4851-a574-edb97359a76c","feed.ts","05d34138-aef2-11f1-8674-1607ee4eb77e",43,["D",1789302877522],"// housing-feed: JSON feed of active listings (GET). The Listing Tracker artifact\r\n// pulls this on open. Token via X-Housing-Token header or ?token= query.\r\n// Returns a bare JSON array of { id, addr, area, price, beds, park, type, ll, dog,\r\n// url, src, note, fs, lv, status, missed }.\r\n//\r\n// ?days=N window on last_seen (default 45)\r\n// ?kinds=all include signal-* and cl-parking rows (excluded by default)\r\n// ?v=2 add age_days + posted_at to each row (default contract unchanged for the tracker)\r\n// ?stats=1 returns a stats object instead of the array (for validation/debug)\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { ensureSchema, activeListings, checkToken, json, CORS } from \"../lib/core.ts\";\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\r\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\r\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\r\n await ensureSchema();\r\n const url = new URL(req.url);\r\n\r\n if (url.searchParams.get(\"stats\")) {\r\n const bySrc = await sqlite.execute(`select source, count(*) n, max(last_seen) last from listings group by source`);\r\n const byArea = await sqlite.execute(`select area, count(*) n, round(avg(price)) avg_price from listings group by area`);\r\n const recent = await sqlite.execute(`select ts, job, ok, fetched, inserted, updated, pushed, detail from poll_log order by id desc limit 15`);\r\n const total = await sqlite.execute(`select count(*) n, sum(score>=8) hot, sum(pushed) pushed from listings`);\r\n return json({ total: total.rows[0], bySource: bySrc.rows, byArea: byArea.rows, recentPolls: recent.rows });\r\n }\r\n\r\n const days = Math.min(365, Math.max(1, Number(url.searchParams.get(\"days\") || 45)));\r\n const list = await activeListings(days, url.searchParams.get(\"kinds\") === \"all\" ? \"all\" : \"listings\", Number(url.searchParams.get(\"v\") || 1)); // ?kinds=all includes signal-*/cl-parking rows; ?v=2 adds age_days/posted_at\r\n return json(list, 200, { \"cache-control\": \"no-store\" });\r\n}\r\n",[],[157,277],"eb020714-f07d-47be-8ab2-53592ab5e58f","admin.ts","066872bc-aef2-11f1-8bc7-1607ee4eb77e",47,["D",1789303422035],9,"// housing-admin: token-checked maintenance endpoint for validation and manual runs.\r\n// GET ?job=craigslist | popville | digest | sources run a job now (digest sends immediately)\r\n// ?job=sources&only= ?job=sources&force=1 one source / ignore the `every` interval\r\n// GET ?sql=select ... read-only query (SELECT only)\r\n// POST { id, status } set a listing's status (new|contacted|touring|applied|dead)\r\n// POST { targets: [...] } load Phase 3 landlord targets ({addr, area, confidence A|B|C, verified_at?, ...}; bonus A +3, B +2, C 0)\r\n// POST { verify_target: { address_norm, result: garage|none|probable } } satellite verdict -> A / demote to C / keep B, stamps verified_at\r\n// GET ?job=backfill_posted[&cap=40] re-fetch Craigslist / Nestfully pages to fill posted_at for score>=6 rows\r\n// GET ?testpush=1 send a test Discord push\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { ensureSchema, checkToken, json, CORS, STATUS, pushDiscord, PUSH_THRESHOLD, normalizeAddress, streetKey, toIsoDate, UA, sleep } from \"../lib/core.ts\";\r\nimport { parseDetail as clParseDetail } from \"../cron/craigslist.ts\";\r\nimport { PARSERS, REGISTRY } from \"../lib/sources.ts\";\r\nimport craigslist from \"../cron/craigslist.ts\";\r\nimport popville from \"../cron/popville.ts\";\r\nimport { sendDigest } from \"../cron/digest.ts\";\r\nimport sources from \"../cron/sources.ts\";\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\r\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\r\n await ensureSchema();\r\n const url = new URL(req.url);\r\n\r\n if (req.method === \"POST\") {\r\n const b = await req.json().catch(() => ({}));\r\n // POST { delete: { id? | source? | url_like? | before? } } - remove rows matching ALL given filters (at least one)\r\n if (b.delete && typeof b.delete === \"object\") {\r\n const w: string[] = []; const a: any[] = [];\r\n if (b.delete.id != null) { w.push(\"id=?\"); a.push(b.delete.id); }\r\n if (b.delete.rowid != null) { w.push(\"rowid_pk=?\"); a.push(Number(b.delete.rowid)); }\r\n if (b.delete.source) { w.push(\"source=?\"); a.push(b.delete.source); }\r\n if (b.delete.url_like) { w.push(\"url like ?\"); a.push(b.delete.url_like); }\r\n if (b.delete.before) { w.push(\"first_seen t.addr && t.area).map((t: any) => ({\r\n sql: `insert or replace into targets (address_norm, addr, area, owner, mailing, garage_evidence, units, beds, bbl, rank, added, confidence, verified_at) values (?,?,?,?,?,?,?,?,?,?,date('now'),?,?)`,\r\n args: [streetKey(normalizeAddress(String(t.addr).split(\",\")[0])), String(t.addr).split(\",\")[0].trim(), t.area, t.owner || \"\", t.mailing || \"\", t.garage_evidence || \"\", t.units ?? null, t.beds ?? null, t.bbl ? 1 : 0, t.rank ?? null,\r\n /^[ABC]$/.test(String(t.confidence || \"\")) ? t.confidence : \"C\", t.verified_at || null],\r\n }));\r\n if (stmts.length) await sqlite.batch(stmts);\r\n const n = await sqlite.execute(`select count(*) n, sum(confidence='A') a, sum(confidence='B') b, sum(confidence='C') c from targets`);\r\n return json({ ok: true, upserted: stmts.length, totals: n.rows[0] });\r\n }\r\n // POST { verify_target: { address_norm, result } } - the Chrome sweep's satellite verdict for a \"VERIFY GARAGE\" push\r\n if (b.verify_target && typeof b.verify_target === \"object\") {\r\n const key = streetKey(normalizeAddress(String(b.verify_target.address_norm || b.verify_target.addr || \"\").split(\",\")[0]));\r\n const result = String(b.verify_target.result || \"\");\r\n if (!key || ![\"garage\", \"none\", \"probable\"].includes(result)) return json({ error: \"need address_norm and result in garage|none|probable\" }, 400);\r\n const conf = result === \"garage\" ? \"A\" : result === \"none\" ? \"C\" : \"B\";\r\n const r = await sqlite.execute({ sql: `update targets set confidence=?, verified_at=date('now') where address_norm=?`, args: [conf, key] });\r\n return json({ ok: true, address_norm: key, confidence: conf, rowsAffected: r.rowsAffected });\r\n }\r\n if (!b.id || !STATUS.includes(b.status)) return json({ error: `need id and status in ${STATUS.join(\"|\")}` }, 400);\r\n const r = await sqlite.execute({ sql: `update listings set status=? where id=?`, args: [b.status, b.id] });\r\n return json({ ok: true, rowsAffected: r.rowsAffected });\r\n }\r\n\r\n const job = url.searchParams.get(\"job\");\r\n if (job === \"craigslist\") return json(await craigslist());\r\n if (job === \"popville\") return json(await popville());\r\n if (job === \"digest\") return json(await sendDigest(true));\r\n if (job === \"sources\") return json(await sources({ only: url.searchParams.get(\"only\") || undefined, force: !!url.searchParams.get(\"force\") }));\r\n if (job === \"backfill_posted\") return json(await backfillPosted(Number(url.searchParams.get(\"cap\") || 40)));\r\n\r\n // push every active score>=8 row that never got a Discord alert (webhook was down / not yet configured)\r\n if (url.searchParams.get(\"pushpending\")) {\r\n const r = await sqlite.execute(`select * from listings where score >= ${PUSH_THRESHOLD} and pushed = 0 and status <> 'dead' and last_seen >= date('now','-14 day') order by score desc`);\r\n const out: any[] = [];\r\n for (const row of r.rows as any[]) {\r\n const ok = await pushDiscord({ id: row.id, addr: row.addr, area: row.area, price: row.price, beds: Number(row.beds), park: row.parking_type, type: row.htype, ll: row.landlord_type, dog: row.pet_ok == null ? null : !!row.pet_ok, url: row.url, source: row.source, score: row.score, notes: row.notes });\r\n if (ok) await sqlite.execute({ sql: `update listings set pushed=1 where rowid_pk=?`, args: [row.rowid_pk] });\r\n out.push({ id: row.id, score: row.score, pushed: ok });\r\n }\r\n return json({ pending: out.length, results: out });\r\n }\r\n\r\n if (url.searchParams.get(\"testpush\")) {\r\n const ok = await pushDiscord({ id: \"TEST\", addr: \"Test push - 123 Example St NW\", area: \"Petworth\", price: 2350, beds: 2, park: \"garage\", type: \"rowhouse\", ll: \"individual\", dog: true, url: \"https://example.com\", source: \"test\", score: 12, notes: \"Pipeline test; ignore.\" });\r\n return json({ pushed: ok });\r\n }\r\n\r\n const sql = url.searchParams.get(\"sql\");\r\n if (sql) {\r\n if (!/^\\s*select\\b/i.test(sql)) return json({ error: \"SELECT only\" }, 400);\r\n const r = await sqlite.execute(sql);\r\n return json({ columns: r.columns, rows: r.rows });\r\n }\r\n return json({ usage: \"?job=craigslist|popville|digest|sources[&only=key][&force=1] ?sql=select... ?testpush=1 POST {id,status}\" });\r\n}\r\n\r\n// Fix 2 backfill: posted_at for Craigslist rows (detail page ) and Nestfully rows (list page datePosted),\r\n// score >= 6 only, capped, polite. Everything else stays null (first_seen is the age fallback).\r\nasync function backfillPosted(cap: number) {\r\n const headers = { \"user-agent\": UA, \"accept\": \"text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8\", \"accept-language\": \"en-US,en;q=0.9\", \"upgrade-insecure-requests\": \"1\", \"sec-fetch-mode\": \"navigate\", \"sec-fetch-dest\": \"document\", \"sec-fetch-site\": \"none\" };\r\n const out: any[] = []; let fetches = 0;\r\n // step 0 (no fetch): Nestfully / add-endpoint notes already carry \"posted YYYY-MM-DD\" from the list page\r\n const fromNotes = await sqlite.execute(`select rowid_pk, notes from listings where posted_at is null and notes like '%posted 20__-__-__%'`);\r\n let notesFilled = 0;\r\n for (const row of fromNotes.rows as any[]) {\r\n const m = String(row.notes).match(/posted (\\d{4}-\\d{2}-\\d{2})/); const d = m ? toIsoDate(m[1]) : null;\r\n if (d) { await sqlite.execute({ sql: `update listings set posted_at=? where rowid_pk=? and posted_at is null`, args: [d, row.rowid_pk] }); notesFilled++; }\r\n }\r\n out.push({ step: \"posted_at from notes\", filled: notesFilled });\r\n const cl = await sqlite.execute(`select rowid_pk, url, addr from listings where source='craigslist' and posted_at is null and score >= 6 order by score desc`);\r\n for (const row of cl.rows as any[]) {\r\n if (fetches >= cap) break;\r\n fetches++;\r\n try {\r\n const res = await fetch(String(row.url), { headers }); const text = res.ok ? await res.text() : \"\";\r\n const posted = text ? toIsoDate(clParseDetail(text).posted) : null;\r\n if (posted) await sqlite.execute({ sql: `update listings set posted_at=? where rowid_pk=?`, args: [posted, row.rowid_pk] });\r\n out.push({ addr: row.addr, http: res.status, posted });\r\n } catch (e) { out.push({ addr: row.addr, error: String(e).slice(0, 80) }); }\r\n await sleep(1500);\r\n }\r\n const nf = await sqlite.execute(`select source, count(*) n from listings where source like 'nestfully-%' and posted_at is null and score >= 6 group by source`);\r\n for (const g of nf.rows as any[]) {\r\n if (fetches >= cap) break;\r\n const zip = String(g.source).replace(\"nestfully-\", \"\");\r\n const reg = REGISTRY.find((s) => s.key === g.source); if (!reg) continue;\r\n const byId = new Map();\r\n await sleep(6000); // Cloudflare 403s Nestfully bursts - one zip at a time, spaced\r\n for (let page = 1; page <= 3 && fetches < cap; page++) {\r\n fetches++;\r\n const u = page > 1 && reg.pageUrl ? reg.pageUrl(reg.urls[0], page) : reg.urls[0];\r\n try {\r\n let res = await fetch(u, { headers: { \"user-agent\": UA, ...(reg.headers || headers) } });\r\n if (res.status === 403 || res.status === 429) { await sleep(8000); res = await fetch(u, { headers: { \"user-agent\": UA, ...(reg.headers || headers) } }); }\r\n if (!res.ok) { out.push({ source: g.source, page, http: res.status }); break; }\r\n const r = PARSERS.nestfully(await res.text(), { url: u, zip });\r\n for (const h of r.hits) if (h.posted) byId.set(h.extId, String(h.posted).slice(0, 10));\r\n if (!r.more) break;\r\n } catch (e) { out.push({ source: g.source, page, error: String(e).slice(0, 80) }); break; }\r\n await sleep(5000);\r\n }\r\n let updated = 0;\r\n for (const [extId, posted] of byId) {\r\n const r = await sqlite.execute({ sql: `update listings set posted_at=? where source=? and external_id=? and posted_at is null`, args: [posted, g.source, extId] });\r\n updated += Number(r.rowsAffected || 0);\r\n }\r\n out.push({ source: g.source, listPagesParsed: byId.size, updated });\r\n }\r\n // re-derive STALE prefixes for rows that now have a posted_at\r\n const stale = await sqlite.execute(`select rowid_pk, notes, posted_at, first_seen from listings where posted_at is not null and score >= 6`);\r\n let restamped = 0;\r\n for (const row of stale.rows as any[]) {\r\n const age = Math.round((Date.now() - Date.parse(String(row.posted_at || row.first_seen))) / 86400000);\r\n const base = String(row.notes || \"\").replace(/^STALE \\d+d \\| /, \"\");\r\n const notes = age > 45 ? `STALE ${age}d | ${base}` : base;\r\n if (notes !== row.notes) { await sqlite.execute({ sql: `update listings set notes=? where rowid_pk=?`, args: [notes, row.rowid_pk] }); restamped++; }\r\n }\r\n return { fetches, restamped, out };\r\n}\r\n",[],[157,285],"1fba8fc3-f36b-4b1c-90e3-1d45a5867818","add.ts",42,["D",1789302872872],"// housing-add: manual ingestion endpoint (POST). Claude in Chrome and Logan post\r\n// FB / sign / portal finds here. Shared-secret header X-Housing-Token.\r\n//\r\n// Body (JSON, single object or array):\r\n// { addr, area?, price?, beds?, park?, type?, ll?, dog?, url, src, note?, text?, posted? (yyyy-mm-dd first-posted date) }\r\n// `text` is optional free text (the listing body) used to infer any field left blank.\r\nimport {\r\n AREAS, PARK, HTYPE, LL, ensureSchema, upsertListing, inferArea, inferPark, inferType, inferLL, inferDog,\r\n inferBeds, clampBeds, parsePrice, inferPrice, checkToken, json, CORS, type Area,\r\n} from \"../lib/core.ts\";\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\r\n if (req.method !== \"POST\") return json({ error: \"POST only\" }, 405);\r\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\r\n\r\n let body: any;\r\n try { body = await req.json(); } catch { return json({ error: \"invalid JSON\" }, 400); }\r\n const items: any[] = Array.isArray(body) ? body : [body];\r\n if (items.length === 0 || items.length > 50) return json({ error: \"1-50 listings per request\" }, 400);\r\n\r\n await ensureSchema();\r\n const results: any[] = [];\r\n for (const it of items) {\r\n const text = [it.addr, it.title, it.note, it.text].filter(Boolean).join(\" \\n \");\r\n const url = String(it.url || \"\").trim();\r\n const src = String(it.src || it.source || \"manual\").toLowerCase().trim();\r\n if (!url && !it.addr) { results.push({ error: \"need url or addr\", input: it }); continue; }\r\n\r\n let area: Area | null = AREAS.includes(it.area) ? it.area : inferArea(text);\r\n if (!area) { results.push({ error: `area required; one of ${AREAS.join(\" | \")}`, input: it }); continue; }\r\n\r\n let beds = it.beds != null && it.beds !== \"\" ? Number(it.beds) : inferBeds(text);\r\n if (beds === 0) { results.push({ skipped: \"studio\", input: it }); continue; }\r\n beds = clampBeds(beds);\r\n\r\n const park = PARK.includes(it.park) ? it.park : inferPark(text);\r\n const type = HTYPE.includes(it.type) ? it.type : inferType(text);\r\n // FB/CL/sign posts default to individual-landlord signal; portals default to pm\r\n const llDefault = [\"fb\", \"fbm\", \"facebook\", \"craigslist\", \"sign\", \"popville\", \"manual\"].includes(src) ? \"individual\" : \"pm\";\r\n const ll = LL.includes(it.ll) ? it.ll : inferLL(text, llDefault);\r\n const dog = typeof it.dog === \"boolean\" ? it.dog : inferDog(text);\r\n const price = it.price != null && it.price !== \"\" ? parsePrice(it.price) : inferPrice(text);\r\n\r\n const r = await upsertListing({\r\n addr: it.addr ? String(it.addr).trim() : null,\r\n area, price, beds, source: src, externalId: it.externalId || it.external_id || null, url: url || \"\",\r\n park, type, ll, dog, notes: String(it.note || \"\").trim(), raw: it.text ? String(it.text) : undefined, unit: it.unit || null,\r\n postedAt: it.posted || it.posted_at || null,\r\n }, { push: true });\r\n results.push(r);\r\n }\r\n return json({ ok: true, results });\r\n}\r\n",[],[157,294],["D",1789248989432],[173,174,175,176],[157],["D",1789248987477],["D",1789519256886],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":24},{"_13":88,"_31":89,"_42":41,"_90":43,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":44,"_97":98},"ctx",{"_81":-5,"_127":341,"_342":343,"_344":345,"_346":24,"_347":24,"_348":24,"_349":58,"_350":-5,"_351":-7,"_352":-7,"_353":62,"_354":24,"_355":24,"_356":-5,"_357":24,"_358":24,"_359":24,"_360":-5},"ENV",{"_312":313,"_314":315,"_316":89,"_317":318,"_319":320,"_321":322,"_323":324,"_325":326,"_327":328,"_329":330,"_331":332,"_333":334,"_335":336,"_337":338,"_339":340},"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 · v49