[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_348":349,"_350":351},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":-7,"_18":19,"_17":-7,"_262":-5,"_20":263,"_22":264,"_265":266,"_267":268,"_26":269,"_24":270,"_271":-5,"_272":-5,"_273":69,"_274":275,"_276":64,"_277":-5,"_278":-5,"_279":280},"routes/_app.x.$handle.$name.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":25,"_26":27,"_28":-5,"_29":-5,"_30":-5,"_31":-5,"_32":-5},"handle","logan1","name","corvette","branchName","main","version","path","cron/enrich.ts","project",{"_33":204,"_13":14,"_47":205,"_206":-5,"_207":69,"_208":209,"_210":209,"_211":212,"_213":-5,"_214":215,"_216":182,"_217":64,"_218":-5,"_219":-5,"_220":66,"_221":222,"_223":224,"_225":226,"_227":228,"_229":-5,"_230":231,"_232":231,"_233":234,"_235":234,"_236":234,"_237":231,"_238":231,"_239":240,"_241":242,"_243":244,"_245":69},"tree",[54,55,56,57,58],"file",{"_33":34,"_35":36,"_37":38,"_13":39,"_40":41,"_42":43,"_17":44,"_45":46,"_47":48,"_49":50,"_51":-5,"_18":52},"contents",[],"upstream","pull","ahead","behind","envVars","id","609d0c57-2d1f-44c9-a158-027ccd505fdd","branchId","86e98f95-71bb-401c-ac30-44ee51ed36fc","fileId","466804f6-af86-11f1-8153-1607ee4eb77e","enrich.ts","content","// Enrichment cron (every 30 min). Steps, each logged to poll_log as enrich::\n// queue release quiet-hours pushes after 07:00 ET (\"Overnight: N listings\" + the individual embeds)\n// verify re-fetch active listing URLs (oldest verified_at first, 8/run, 12 h cadence) and mark gone rows: 404 / Craigslist removal\n// banner / SOLD thread title kill on sight, soft body-text signals need two sightings; auction lots go at auction_date + 1.\n// status 'new' -> dead + gone_at; in-progress rows keep their status, get gone_at + GONE flag (digest lists them).\n// decode NHTSA vPIC DecodeVinValues for rows with a VIN and no decode yet (cap 15/run): stores year/model/body/plant/engine,\n// flags VIN MISMATCH when the listing's year/model/body/trim disagree with the VIN (also from the VIN's own engine/body chars)\n// recalls NHTSA recalls by make/model/year, cached per model year in `recalls` (refreshed weekly)\n// geocode Census onelineaddress for street addresses, Nominatim for \"City, ST\" (cached in geocache; 1 req/s), fills lat/lon/dist/STRETCH\n// drive OSRM drive miles from 16105 for rows with coordinates (bands are drive-based: core <= 350, STRETCH 350-425, FAR 425-600)\n// vdp ClassicCars.com / JK's Galleria detail pages for rows missing miles/VIN/price (cap 3/run)\n// price re-derive age-driven flags (STALE / MOTIVATED / PRICE ANOMALY / SELLER MOTIVE / FIRM / REPOST) and the flags column for active rows\n// season Sundays: one season_log row (active count, P25/median by gen x trans, drop/firm/storage shares, CL density at 300/350)\n// Admin: ?job=enrich[&force=1][&step=queue|verify|decode|recalls|geocode|drive|vdp|price|season] (force on verify: 30 rows, ignore the 12 h cadence)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, logPoll, pushDiscord, discordText, ageDays, today, decorateNotes, flagsFor, distFrom16105, CORE_MI, CENTER, PRICE_MIN, PRICE_MAX, UA, sleep, normalizeVin, bandFor, driveMiles, findVin, parseMiles, parsePrice, inferTrans, upsertListing, score, conditionPoints, MOTIVE_RE, FIRM_RE, type Gen, type Trans, type Body } from \"../lib/core.ts\";\nimport { getState, setState, pendingQueue, markReleased, isQuietHour, priceTrail, trailStats, motivatedFlag, p25For, isAnomaly, stripPrefixes, p25, goneSignal } from \"../lib/enrich.ts\";\n\nconst TIME_BUDGET_MS = 40_000;\nconst DECODE_CAP = 15;\nconst GEOCODE_CAP = 20;\nconst VERIFY_CAP = 8;\nconst VERIFY_EVERY_H = 12;\n\nexport async function releaseQueue(): Promise<{ released: number }> {\n if (isQuietHour()) return { released: 0 };\n const q = await pendingQueue();\n if (!q.length) return { released: 0 };\n await discordText(`**Overnight: ${q.length} listing${q.length === 1 ? \"\" : \"s\"}** queued between 23:00 and 07:00 ET`);\n const done: number[] = [];\n for (const item of q) { const ok = await pushDiscord(item.payload); if (ok) done.push(item.id); await sleep(400); }\n await markReleased(done);\n return { released: done.length };\n}\n\n// ---------- verify: is the ad still up? (the missed counter only covers sources that return their full inventory) ----------\nexport async function markGone(rowid: number, reason: string, opts: { status: string; flags: string; notes: string }) {\n const flags = String(opts.flags || \"\").split(\"|\").filter((f) => f && !f.startsWith(\"GONE\"));\n flags.unshift(`GONE ${reason}`.slice(0, 60));\n const notes = decorateNotes(String(opts.notes || \"\"), flags);\n await sqlite.execute({ sql: `update listings set status=case when status='new' then 'dead' else status end, gone_at=coalesce(gone_at, ?), verified_at=?, verify_fails=0, flags=?, notes=? where rowid_pk=?`,\n args: [today(), new Date().toISOString(), flags.join(\"|\"), notes, rowid] });\n}\nasync function verifyStep(started: number, force = false): Promise<{ checked: number; gone: number; soft: number; auctionsEnded: number; errors: number; goneIds: string[] }> {\n const out = { checked: 0, gone: 0, soft: 0, auctionsEnded: 0, errors: 0, goneIds: [] as string[] };\n // 1. auction lots whose sale date has passed: gone without a fetch (the lot page stays up for months with the result on it)\n const ended = await sqlite.execute(`select rowid_pk, id, flags, notes from listings where gone_at is null and status <> 'dead' and auction_date is not null and auction_date < date('now','-1 day')`);\n for (const r of ended.rows as any[]) { await markGone(Number(r.rowid_pk), `auction ended`, r); out.auctionsEnded++; out.goneIds.push(String(r.id)); }\n // 2. re-fetch the rest, least recently verified first; Facebook needs a logged-in browser (tracker 'Gone' button / Chrome sweep)\n const cap = force ? 30 : VERIFY_CAP;\n const rows = await sqlite.execute({ sql: `select rowid_pk, id, url, source, status, flags, notes, verify_fails from listings where gone_at is null and status <> 'dead' and last_seen >= date('now','-60 day')\n and url not like '%facebook.com%' and url not like '%fb.com%' and (verified_at is null or verified_at < ? or ?) order by verified_at is not null, verified_at, score desc limit ${cap}`,\n args: [new Date(Date.now() - VERIFY_EVERY_H * 3600000).toISOString(), force ? 1 : 0] });\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > (force ? TIME_BUDGET_MS : TIME_BUDGET_MS / 2)) break; // runs first: leave half the budget for decode/geocode/drive/price\n out.checked++;\n let sig: ReturnType = null; let status = 0;\n try {\n const res = await fetch(String(r.url), { headers: { \"user-agent\": UA, accept: \"text/html,*/*\" }, redirect: \"follow\", signal: AbortSignal.timeout(12000) });\n status = res.status; const html = await res.text();\n sig = goneSignal(String(r.url), status, html, res.url);\n } catch (e) { out.errors++; console.warn(\"verify\", r.id, String(e).slice(0, 80)); await sleep(300); continue; } // network error: no verdict, try again next run\n if (!sig) { await sqlite.execute({ sql: `update listings set verified_at=?, verify_fails=0 where rowid_pk=?`, args: [new Date().toISOString(), r.rowid_pk] }); }\n else if (sig.sure || Number(r.verify_fails || 0) + 1 >= 2) { await markGone(Number(r.rowid_pk), sig.reason, r); out.gone++; out.goneIds.push(String(r.id)); }\n else { await sqlite.execute({ sql: `update listings set verified_at=?, verify_fails=verify_fails+1 where rowid_pk=?`, args: [new Date().toISOString(), r.rowid_pk] }); out.soft++; }\n await sleep(700);\n }\n return out;\n}\n\n// ---------- VIN structure (C4/C5 Corvette: 1G1YY 2/3 x 5 ) ----------\nexport const VIN_ENGINE: Record = { P: \"LT1 5.7\", J: \"LT4 5.7\", Z: \"LT5 5.7 (ZR-1)\", G: \"LS1 5.7\", S: \"LS6 5.7 (Z06)\", \"8\": \"L98 5.7\" };\nexport function vinBody(vin: string | null, year: number | null): Body {\n const v = normalizeVin(vin); if (!v) return \"unknown\";\n const c = v[5];\n if (c === \"3\") return \"convertible\";\n if (c === \"2\") return \"coupe\";\n if (c === \"1\") return year != null && year >= 2001 ? \"hardtop\" : \"frc\"; // 1999-2000 FRC; 2001-04 Z06 hardtop\n return \"unknown\";\n}\nexport function vinEngine(vin: string | null): string | null { const v = normalizeVin(vin); return v ? VIN_ENGINE[v[7]] ?? null : null; }\nexport interface DecodeSummary { year: number | null; make: string; model: string; body: string; plant: string; engine: string | null; series: string; trim: string; error: string; api: boolean }\nexport function summarizeDecode(vin: string, r: Record): DecodeSummary {\n return {\n year: r.ModelYear ? Number(r.ModelYear) : null, make: r.Make || \"\", model: r.Model || \"\", body: r.BodyClass || \"\", plant: [r.PlantCity, r.PlantState].filter(Boolean).join(\", \"),\n engine: r.EngineModel || vinEngine(vin), series: r.Series || \"\", trim: r.Trim || \"\", error: r.ErrorCode || \"\", api: true,\n };\n}\n// pure: compare the listing with the VIN decode; returns mismatch strings (empty = consistent)\nexport function decodeMismatch(l: { year: number | null; body: Body; trans: Trans; trim: string; vin: string | null }, d: DecodeSummary): string[] {\n const out: string[] = [];\n if (d.year != null && l.year != null && d.year !== l.year) out.push(`year ${l.year} vs VIN ${d.year}`);\n if (d.model && !/corvette/i.test(d.model)) out.push(`VIN is a ${d.make} ${d.model}`);\n const vb = vinBody(l.vin, d.year ?? l.year);\n if (l.body !== \"unknown\" && vb !== \"unknown\" && l.body !== vb && !(l.body === \"hardtop\" && vb === \"frc\") && !(l.body === \"frc\" && vb === \"hardtop\")) out.push(`body ${l.body} vs VIN ${vb}`);\n const eng = vinEngine(l.vin) || \"\";\n if (/Z06/i.test(l.trim) && eng && !/LS6/.test(eng)) out.push(`Z06 claimed, VIN engine ${eng}`);\n if (/LT4/i.test(l.trim) && eng && !/LT4/.test(eng)) out.push(`LT4 claimed, VIN engine ${eng}`);\n if (/ZR-?1/i.test(l.trim) && eng && !/LT5/.test(eng)) out.push(`ZR-1 claimed, VIN engine ${eng}`);\n if (!/Z06/i.test(l.trim) && /LS6/.test(eng) && l.trans === \"auto\") out.push(`VIN says Z06 (LS6) - never automatic`);\n return out;\n}\n\nasync function decodeStep(started: number): Promise<{ decoded: number; mismatched: number; errors: number }> {\n const out = { decoded: 0, mismatched: 0, errors: 0 };\n const rows = await sqlite.execute(`select rowid_pk, vin, year, body, trans, trim, notes, flags from listings where vin is not null and decode is null order by score desc, last_seen desc limit ${DECODE_CAP}`);\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > TIME_BUDGET_MS) break;\n try {\n const res = await fetch(`https://vpic.nhtsa.dot.gov/api/vehicles/DecodeVinValues/${r.vin}?format=json`, { headers: { \"user-agent\": UA, accept: \"application/json\" } });\n if (!res.ok) { out.errors++; continue; }\n const j = await res.json(); const d = summarizeDecode(String(r.vin), (j.Results && j.Results[0]) || {});\n const mm = decodeMismatch({ year: r.year == null ? null : Number(r.year), body: r.body, trans: r.trans, trim: String(r.trim || \"\"), vin: r.vin }, d);\n let flags = String(r.flags || \"\").split(\"|\").filter((f: string) => f && !f.startsWith(\"VIN MISMATCH\"));\n if (mm.length) { flags.push(`VIN MISMATCH ${mm.join(\"; \")}`.slice(0, 120)); out.mismatched++; }\n const notes = decorateNotes(String(r.notes || \"\"), flags);\n await sqlite.execute({ sql: `update listings set decode=?, decode_at=?, decode_mismatch=?, flags=?, notes=?, year=coalesce(year, ?), body=case when body='unknown' then ? else body end where rowid_pk=?`,\n args: [JSON.stringify(d), today(), mm.length ? mm.join(\"; \") : null, flags.join(\"|\"), notes, d.year, vinBody(r.vin, d.year), r.rowid_pk] });\n out.decoded++;\n } catch (e) { out.errors++; console.warn(\"decode\", r.vin, String(e).slice(0, 100)); }\n await sleep(500);\n }\n return out;\n}\n\nasync function recallsStep(): Promise<{ years: number[] }> {\n const stale = await sqlite.execute(`select y.year from (select distinct year from listings where year between 1992 and 2004) y left join recalls r on r.year=y.year where r.year is null or r.fetched < date('now','-7 day') limit 4`);\n const done: number[] = [];\n for (const row of stale.rows as any[]) {\n const y = Number(row.year);\n try {\n const res = await fetch(`https://api.nhtsa.gov/recalls/recallsByVehicle?make=chevrolet&model=corvette&modelYear=${y}`, { headers: { \"user-agent\": UA, accept: \"application/json\" } });\n if (!res.ok) continue;\n const j = await res.json();\n const items: any[] = (j.results || []).filter((x: any) => /general motors|chevrolet/i.test(String(x.Manufacturer || \"\"))); // drop aftermarket-part recalls\n const summary = items.map((x) => `${x.NHTSACampaignNumber} ${String(x.Component || \"\").slice(0, 40)}: ${String(x.Summary || \"\").slice(0, 120)}`).join(\"\\n\");\n await sqlite.execute({ sql: `insert or replace into recalls (year, count, summary, fetched) values (?,?,?,?)`, args: [y, items.length, summary.slice(0, 4000), today()] });\n done.push(y);\n } catch (e) { console.warn(\"recalls\", y, String(e).slice(0, 80)); }\n await sleep(400);\n }\n return { years: done };\n}\n\n// ---------- geocoding ----------\nexport async function ensureGeocache() { await sqlite.execute(`create table if not exists geocache (q text primary key, lat real, lon real, src text, ts text not null)`); }\nasync function geocodeOne(q: string): Promise<{ lat: number; lon: number; src: string } | null> {\n const c = await sqlite.execute({ sql: `select lat, lon, src from geocache where q=?`, args: [q] });\n if (c.rows.length) { const r: any = c.rows[0]; return r.lat == null ? null : { lat: Number(r.lat), lon: Number(r.lon), src: String(r.src) }; }\n let hit: { lat: number; lon: number; src: string } | null = null;\n try {\n if (/^\\d+\\s+\\S+/.test(q)) { // street address -> Census\n const res = await fetch(`https://geocoding.geo.census.gov/geocoder/locations/onelineaddress?address=${encodeURIComponent(q)}&benchmark=Public_AR_Current&format=json`, { headers: { \"user-agent\": UA } });\n const j = res.ok ? await res.json() : null; const m = j?.result?.addressMatches?.[0];\n if (m) hit = { lat: Number(m.coordinates.y), lon: Number(m.coordinates.x), src: \"census\" };\n }\n if (!hit) { // city -> Nominatim (1 req/s, identify ourselves)\n await sleep(1100);\n const res = await fetch(`https://nominatim.openstreetmap.org/search?q=${encodeURIComponent(q)}&format=json&limit=1&countrycodes=us`, { headers: { \"user-agent\": \"corvette-search-pipeline/1.0 (val.town cron; loganjtaylor1999@gmail.com)\" } });\n const j = res.ok ? await res.json() : null;\n if (Array.isArray(j) && j[0]) hit = { lat: Number(j[0].lat), lon: Number(j[0].lon), src: \"nominatim\" };\n }\n } catch (e) { console.warn(\"geocode\", q, String(e).slice(0, 80)); return null; }\n await sqlite.execute({ sql: `insert or replace into geocache (q, lat, lon, src, ts) values (?,?,?,?,?)`, args: [q, hit?.lat ?? null, hit?.lon ?? null, hit?.src ?? \"none\", today()] });\n return hit;\n}\n// clean \"336 Route 130 - CL newyork\" / \"Boardman, OH\" style loc strings into something a geocoder understands\nexport function geocodeQuery(loc: string): string | null {\n let q = (loc || \"\").replace(/\\s*-\\s*CL \\w+$/i, \"\").replace(/^CL \\w+$/i, \"\").trim();\n if (!q) return null;\n if (/^\\d+\\s+\\S+/.test(q) && !/,/.test(q)) return null; // bare street with no city - the metro fallback already placed it\n return q.slice(0, 100);\n}\nasync function geocodeStep(started: number): Promise<{ tried: number; filled: number }> {\n await ensureGeocache();\n const out = { tried: 0, filled: 0 };\n const rows = await sqlite.execute(`select rowid_pk, loc, flags, notes from listings where (lat is null or geocode_src='metro') and loc <> '' and status <> 'dead' and last_seen >= date('now','-30 day') order by score desc limit ${GEOCODE_CAP}`);\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > TIME_BUDGET_MS) break;\n const q = geocodeQuery(String(r.loc)); if (!q) { await sqlite.execute({ sql: `update listings set geocode_src=coalesce(geocode_src,'none') where rowid_pk=?`, args: [r.rowid_pk] }); continue; }\n out.tried++;\n const hit = await geocodeOne(q);\n if (!hit) { await sqlite.execute({ sql: `update listings set geocode_src=case when geocode_src='metro' then 'metro' else 'none' end where rowid_pk=?`, args: [r.rowid_pk] }); continue; }\n const dist = distFrom16105(hit.lat, hit.lon);\n let flags = String(r.flags || \"\").split(\"|\").filter((f: string) => f && f !== \"STRETCH\");\n if (dist != null && dist > CORE_MI) flags.push(\"STRETCH\");\n await sqlite.execute({ sql: `update listings set lat=?, lon=?, dist=?, stretch=?, geocode_src=?, flags=?, notes=? where rowid_pk=?`, args: [hit.lat, hit.lon, dist, dist != null && dist > CORE_MI ? 1 : 0, hit.src, flags.join(\"|\"), decorateNotes(String(r.notes || \"\"), flags), r.rowid_pk] });\n out.filled++;\n }\n return out;\n}\n\n// re-derive age-driven flags for active rows; score is recomputed only for the dist point when coordinates arrived\nasync function priceStep(started: number): Promise<{ rows: number; motivated: number; anomaly: number; stale: number }> {\n const out = { rows: 0, motivated: 0, anomaly: 0, stale: 0 };\n const rows = await sqlite.execute(`select rowid_pk, vin, year, trans, trim, price, dist, drive_mi, reposts, notes, flags, posted_at, first_seen, drops, motivated, anomaly, raw from listings where status <> 'dead' and last_seen >= date('now','-30 day')`);\n const cache = new Map();\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > TIME_BUDGET_MS) break;\n const age = ageDays(r.posted_at, r.first_seen);\n const trail = await priceTrail(Number(r.rowid_pk));\n if (!trail.length && r.price != null) { await sqlite.execute({ sql: `insert into price_history (rowid_pk, price, seen) values (?,?,?)`, args: [r.rowid_pk, r.price, r.first_seen] }); trail.push(Number(r.price)); }\n const ts = trailStats(trail);\n const motivated = motivatedFlag(ts.drops, age);\n const key = `${r.year}|${r.trans}`;\n if (!cache.has(key)) cache.set(key, (await p25For(r.year == null ? null : Number(r.year), String(r.trans))).p25);\n const anomaly = isAnomaly(r.price == null ? null : Number(r.price), cache.get(key) ?? null);\n const keep = String(r.flags || \"\").split(\"|\").filter((f: string) => /^(DEAD |VIN MISMATCH|GONE)/.test(f));\n const oor = String(r.flags || \"\").includes(\"OUT-OF-REGION SITE\");\n const flags = [...keep, ...flagsFor({ vin: r.vin, trim: String(r.trim || \"\"), trans: r.trans, text: String(r.raw || \"\"), dist: r.dist == null ? null : Number(r.dist), drive: r.drive_mi, ageDays: age, anomaly, motivated, lastDrop: ts.lastDrop, reposts: Number(r.reposts || 0), outOfRegionSite: oor })];\n const notes = decorateNotes(String(r.notes || \"\"), flags);\n const band = bandFor(driveMiles(r.dist == null ? null : Number(r.dist), r.drive_mi));\n if (notes !== r.notes || flags.join(\"|\") !== r.flags || motivated !== !!r.motivated || anomaly !== !!r.anomaly || ts.drops !== Number(r.drops)) {\n await sqlite.execute({ sql: `update listings set notes=?, flags=?, drops=?, motivated=?, anomaly=?, band=?, stretch=? where rowid_pk=?`, args: [notes, flags.join(\"|\"), ts.drops, motivated ? 1 : 0, anomaly ? 1 : 0, band, band !== \"core\" || (r.dist != null && Number(r.dist) > CORE_MI) ? 1 : 0, r.rowid_pk] });\n }\n out.rows++; if (motivated) out.motivated++; if (anomaly) out.anomaly++; if (age > 45) out.stale++;\n }\n return out;\n}\n\n// ---------- drive miles via the public OSRM demo server (expansion-plan 2b): bands are drive-based, not straight-line ----------\nasync function driveStep(started: number): Promise<{ routed: number; failed: number }> {\n const out = { routed: 0, failed: 0 };\n const rows = await sqlite.execute(`select rowid_pk, lat, lon, dist from listings where lat is not null and lon is not null and drive_mi is null and status <> 'dead' and last_seen >= date('now','-30 day') order by score desc limit 12`);\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > TIME_BUDGET_MS) break;\n try {\n const res = await fetch(`https://router.project-osrm.org/route/v1/driving/${CENTER.lon},${CENTER.lat};${r.lon},${r.lat}?overview=false`, { headers: { \"user-agent\": UA }, signal: AbortSignal.timeout(15000) });\n const j = res.ok ? await res.json() : null;\n const m = j?.routes?.[0]?.distance;\n if (!m) { out.failed++; continue; }\n const drive = Math.round(Number(m) / 1609.344);\n const band = bandFor(drive);\n await sqlite.execute({ sql: `update listings set drive_mi=?, band=?, stretch=? where rowid_pk=?`, args: [drive, band, band !== \"core\" || (r.dist != null && Number(r.dist) > CORE_MI) ? 1 : 0, r.rowid_pk] });\n out.routed++;\n } catch (e) { out.failed++; console.warn(\"osrm\", r.rowid_pk, String(e).slice(0, 80)); }\n await sleep(600);\n }\n return out;\n}\n\n// ---------- VDP enrichment: ClassicCars.com JSON-LD (miles, VIN, transmission) and JK's Galleria DealerCarSearch VDPs (price, miles, VIN) ----------\nasync function vdpStep(started: number): Promise<{ fetched: number; filled: number }> {\n const out = { fetched: 0, filled: 0 };\n const rows = await sqlite.execute(`select rowid_pk, source, external_id, url, year, gen, trans, body, miles, price, title, seller, loc, lat, lon, notes, raw from listings\n where status <> 'dead' and last_seen >= date('now','-30 day') and ((source='classiccars' and (miles is null or vin is null)) or (source='jkgalleria' and price is null)) and (notes not like '%VDP checked%') order by score desc limit 3`);\n for (const r of rows.rows as any[]) {\n if (Date.now() - started > TIME_BUDGET_MS) break;\n out.fetched++;\n try {\n const res = await fetch(String(r.url), { headers: { \"user-agent\": UA, accept: \"text/html,*/*\" }, signal: AbortSignal.timeout(15000) });\n const html = res.ok ? await res.text() : \"\";\n if (!html) { await sqlite.execute({ sql: `update listings set notes=notes || ' | VDP checked http ' || ? where rowid_pk=?`, args: [res.status, r.rowid_pk] }); continue; }\n const miles = parseMiles((html.match(/\"mileageFromOdometer\"[\\s\\S]{0,80}?\"value\":\\s*\"?(\\d+)/) || html.match(/Mileage:?<\\/[a-z]+>\\s*<[^>]+>\\s*([\\d,]+)/i) || html.match(/([\\d,]{5,7})\\s*(?:miles|mi\\b)/i) || [])[1]);\n const vin = findVin((html.match(/\"vehicleIdentificationNumber\":\\s*\"([A-Z0-9]{17})\"/) || [])[1] || \"\") || findVin(html.slice(0, 200000));\n const transM = html.match(/Transmission:?<\\/span>\\s*]*>\\s*(Automatic|Manual)/i) || html.match(/\"vehicleTransmission\":\\s*\"([^\"]+)\"/);\n const trans = transM ? inferTrans(transM[1]) : r.trans;\n const price = r.price ?? parsePrice((html.match(/\"price\":\\s*\"?(\\d{4,6})/) || html.match(/\\$\\s?([\\d,]{5,7})/) || [])[1]);\n if (price != null && (price < PRICE_MIN || price > PRICE_MAX)) { // the list page had no price; the VDP says it is outside the band\n await sqlite.execute({ sql: `update listings set price=?, status=case when status='new' then 'dead' else status end, notes=notes || ' | VDP checked ' || ? || ' price $' || ? || ' out of band' where rowid_pk=?`, args: [price, today(), price, r.rowid_pk] });\n continue;\n }\n const up = await upsertListing({ vin: vin || null, year: r.year, gen: r.gen, trans: trans === \"unknown\" ? r.trans : trans, body: r.body, miles: miles ?? r.miles, price, title: r.title, seller: r.seller, loc: r.loc, lat: r.lat, lon: r.lon,\n source: r.source, externalId: r.external_id, url: r.url, notes: `VDP checked ${today()}${vin ? \" VIN \" + vin : \"\"}${miles ? \" \" + miles + \" mi\" : \"\"}` }, { push: true });\n if (up) out.filled++;\n } catch (e) { console.warn(\"vdp\", r.rowid_pk, String(e).slice(0, 80)); await sqlite.execute({ sql: `update listings set notes=notes || ' | VDP checked error' where rowid_pk=?`, args: [r.rowid_pk] }); }\n await sleep(2500);\n }\n return out;\n}\n\n// ---------- weekly season_log (Sundays): measured seasonality for this radius (expansion-plan fix 18) ----------\nasync function seasonStep(force = false): Promise<{ week?: string; skipped?: string }> {\n const d = new Date(); const week = d.toISOString().slice(0, 10);\n const isSunday = new Intl.DateTimeFormat(\"en-US\", { timeZone: \"America/New_York\", weekday: \"short\" }).format(d) === \"Sun\";\n const done = await getState(\"season_week\");\n if (!force && (!isSunday || done === week)) return { skipped: done === week ? `logged ${done}` : \"not Sunday\" };\n const act = await sqlite.execute(`select gen, trans, price, flags, raw from listings where status <> 'dead' and last_seen >= date('now','-7 day') and band in ('core','stretch')`);\n const rows = act.rows as any[];\n const priced = (g: string, t: string) => rows.filter((r) => r.gen === g && r.trans === t && r.price != null).map((r) => Number(r.price));\n const med = (v: number[]) => v.length ? v.slice().sort((a, b) => a - b)[Math.floor(v.length / 2)] : null;\n const share = (fn: (r: any) => boolean) => rows.length ? Math.round(100 * rows.filter(fn).length / rows.length) / 100 : null;\n const cl = async (radius: number) => { try { const res = await fetch(`https://www.craigslist.org/search/city/new-castle-pa?cat=cta&query=corvette&postal=16105&radius=${radius}&min_auto_year=1992&max_auto_year=2004`, { headers: { \"user-agent\": UA }, signal: AbortSignal.timeout(15000) }); const t = res.ok ? await res.text() : \"\"; return (t.match(/

[^<]*(?:corvette|vette)/gi) || []).length; } catch { return null; } };\n const c4a = priced(\"C4\", \"auto\"), c5a = priced(\"C5\", \"auto\");\n await sqlite.execute({ sql: `insert or replace into season_log (week, active, in_band, p25_c4_auto, med_c4_auto, p25_c5_auto, med_c5_auto, drops_share, firm_share, storage_share, cl300, cl350, ts) values (?,?,?,?,?,?,?,?,?,?,?,?,?)`,\n args: [week, rows.length, rows.filter((r) => r.price != null && r.price >= 8000 && r.price <= 14500).length, p25(c4a), med(c4a), p25(c5a), med(c5a), share((r) => /DROP \\$/.test(String(r.flags))), share((r) => FIRM_RE.test(String(r.raw || \"\"))), share((r) => MOTIVE_RE.test(String(r.raw || \"\"))), await cl(300), await cl(350), new Date().toISOString()] });\n await setState(\"season_week\", week);\n return { week };\n}\n\nexport default async function run(opts: { force?: boolean; step?: string } = {}) {\n const started = Date.now();\n await ensureSchema();\n const results: Record = {};\n const want = (s: string) => !opts.step || opts.step === s;\n const step = async (name: string, fn: () => Promise) => {\n if (!want(name)) return;\n try { const r = await fn(); results[name] = r; await logPoll(`enrich:${name}`, true, {}, JSON.stringify(r).slice(0, 500)); }\n catch (e) { results[name] = { error: String(e).slice(0, 200) }; await logPoll(`enrich:${name}`, false, {}, String(e).slice(0, 500)); }\n };\n await step(\"queue\", releaseQueue);\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"verify\", () => verifyStep(started, !!opts.force && opts.step === \"verify\"));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"decode\", () => decodeStep(started));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"recalls\", recallsStep);\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"geocode\", () => geocodeStep(started));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"drive\", () => driveStep(started));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"vdp\", () => vdpStep(started));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"price\", () => priceStep(started));\n if (Date.now() - started < TIME_BUDGET_MS) await step(\"season\", () => seasonStep(!!opts.force));\n const summary = { seconds: Math.round((Date.now() - started) / 1000), results };\n console.log(\"enrich\", JSON.stringify(summary).slice(0, 1500));\n return summary;\n}\n","fileType","interval",4,"parentId","1b0a73f2-af86-11f1-b58b-1607ee4eb77e","createdAt",["D",1789473245260],"branchVersion",79,"label",[53,39],"cron",{"_33":161,"_13":162,"_37":163,"_45":-5,"_35":36,"_49":149,"_63":64,"_47":164,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":165,"_18":166},{"_33":126,"_13":53,"_37":46,"_45":-5,"_35":36,"_49":44,"_63":64,"_47":127,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":128,"_18":129},{"_33":110,"_13":111,"_37":112,"_45":-5,"_35":36,"_49":113,"_63":64,"_47":114,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":115,"_18":116},{"_33":73,"_13":74,"_37":75,"_45":-5,"_35":36,"_49":76,"_63":64,"_47":77,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":79,"_18":80},{"_33":59,"_13":60,"_37":61,"_45":-5,"_35":36,"_49":62,"_63":64,"_47":65,"_17":66,"_42":24,"_40":67,"_68":69,"_51":-5,"_70":71,"_18":72},"00ad9da4-0577-4814-8519-02511a2d4430","README.md","ff70c39e-af85-11f1-9411-1607ee4eb77e",1,"latest",true,["D",1789312547547],0,"# corvette\n\nC4 (1994-96) / C5 (1997-2004) Corvette search pipeline for 16105. Forked from logan1/housing. See lib/core.ts.\n","deleted",false,"children",[],[60],"35cabbb3-b0f6-4c22-a18a-4c6320b0d9b2","lib","16dfa00e-af86-11f1-9559-1607ee4eb77e",2,["D",1789312586746],"directory",[81,82,83],[74],{"_33":101,"_13":102,"_37":103,"_45":75,"_35":36,"_49":104,"_63":64,"_47":105,"_17":106,"_42":90,"_40":107,"_68":69,"_51":-5,"_70":108,"_18":109},{"_33":94,"_13":39,"_37":95,"_45":75,"_35":36,"_49":96,"_63":64,"_47":97,"_17":76,"_42":90,"_40":98,"_68":69,"_51":-5,"_70":99,"_18":100},{"_33":84,"_13":85,"_37":86,"_45":75,"_35":36,"_49":87,"_63":64,"_47":88,"_17":89,"_42":90,"_40":91,"_68":69,"_51":-5,"_70":92,"_18":93},"6ee78f10-cbd9-4ac8-b0e0-b14c1c7f3465","sources.ts","30edcbe2-af86-11f1-9d05-1607ee4eb77e",68,["D",1789422556949],15,"script","// Multi-source registry + one parser per platform. Pure functions (text -> hits) so they are unit-testable against\n// scripts/fixtures/*. The cron (cron/sources.ts) does the fetching, rotation, dedupe and upsert. Adding a source =\n// one REGISTRY entry (+ a parser if the platform is new). Per-source gotchas live in valtown/SOURCES.md; verified\n// evidence for every entry is in ../source-inventory.md / .json.\nimport { decodeEntities, stripTags, inferYear, inferTrans, inferBody, inferTitle, inferMiles, inferPrice, inferTrim, findVin, parsePrice, parseMiles, genFor, YEAR_MIN, YEAR_MAX, type Trans, type Body, type Title, type Seller } from \"./core.ts\";\n\nexport type Kind = \"listing\" | \"comp\";\nexport interface Hit {\n extId: string; url: string; title: string; text: string;\n year?: number | null; price?: number | null; miles?: number | null; vin?: string | null;\n trans?: Trans; body?: Body; titleStatus?: Title; seller?: Seller; loc?: string; lat?: number | null; lon?: number | null;\n posted?: string | number | null; auctionDate?: string | null; note?: string; dist?: number | null; // dist = source-reported distance when no coordinates\n soldPrice?: number | null; soldDate?: string | null; // comps\n}\nexport interface ParseResult { hits: Hit[]; more?: boolean }\nexport type Parser = (text: string, ctx: { url: string }) => ParseResult;\nexport interface Source {\n key: string; parser: keyof typeof PARSERS; urls: string[]; every: number; seller: Seller; kind?: Kind;\n push?: boolean; pushMin?: number; enabled?: boolean; headers?: Record; accept?: \"html\" | \"json\" | \"xml\";\n pageUrl?: (base: string, n: number) => string; maxPages?: number; spacingMs?: number; group?: string; full?: boolean; // full = complete inventory (missed logic)\n method?: \"GET\" | \"POST\"; body?: (url: string) => string; // POST APIs (Mecum Algolia)\n}\n\nconst clean = (s: string) => decodeEntities(s).replace(/\\s+/g, \" \").trim();\nconst pipeText = (html: string) => decodeEntities(html.replace(//g, \"\").replace(/|/gi, \"\").replace(/<[^>]+>/g, \" | \")).replace(/\\s+/g, \" \").replace(/(\\s*\\|\\s*)+/g, \" | \").trim();\nexport const CORVETTE_RE = /corvette|\\bvette\\b/i;\nconst yearOk = (y: number | null | undefined) => y != null && y >= YEAR_MIN && y <= YEAR_MAX;\n// fill the structured fields a listing hit lacks from its text (parsers pass what the page gives, this does the rest)\nexport function enrichHit(h: Hit): Hit {\n const t = `${h.title} \\n ${h.text}`;\n return {\n ...h, year: h.year ?? inferYear(t), price: h.price ?? inferPrice(t), miles: h.miles ?? inferMiles(t), vin: h.vin ?? findVin(t),\n trans: h.trans ?? inferTrans(t), body: h.body ?? inferBody(t), titleStatus: h.titleStatus ?? inferTitle(t),\n };\n}\n\n// ---------- RSS / Atom (vBulletin external.php?type=RSS2&forumids=N, XenForo index.rss, Reddit new.rss, Hemmings) ----------\nexport const rss: Parser = (xml, ctx) => {\n const hits: Hit[] = [];\n const items = xml.includes(\"\") || xml.includes(\"]/).slice(1) : xml.split(\"\").slice(1);\n for (const it of items) {\n const g = (re: RegExp) => (it.match(re) || [])[1];\n const title = clean(stripTags((g(/]*>([\\s\\S]*?)<\\/title>/) || \"\").replace(/^$/g, \"\")));\n const link = g(/]*href=\"([^\"]+)\"/) || clean(g(/([\\s\\S]*?)<\\/link>/) || \"\");\n const id = clean(g(/([\\s\\S]*?)<\\/id>/) || g(/]*>([\\s\\S]*?)<\\/guid>/) || link);\n const body = stripTags((g(/([\\s\\S]*?)<\\/content:encoded>/) || g(/]*>([\\s\\S]*?)<\\/content>/) || g(/([\\s\\S]*?)<\\/description>/) || \"\").replace(//g, \"\"));\n const date = g(/([\\s\\S]*?)<\\/pubDate>/) || g(/([\\s\\S]*?)<\\/published>/) || g(/([\\s\\S]*?)<\\/updated>/) || g(/([\\s\\S]*?)<\\/dc:date>/) || \"\";\n if (!link) continue;\n if (date && Number.isFinite(Date.parse(date)) && Date.now() - Date.parse(date) > 90 * 86400000) continue; // XenForo index.rss includes years-old stickies/archived threads\n const text = `${title} \\n ${body}`;\n if (!CORVETTE_RE.test(text) && !/\\bc[45]\\b/i.test(title)) continue;\n if (/reddit\\.com/.test(ctx.url) && !/\\bfor sale\\b|\\bfs\\b|\\bselling\\b|\\bwts\\b|\\$\\s?\\d/i.test(text)) continue; // r/Corvette is mostly discussion; keep only sale posts\n if (/\\bwtb\\b|\\bwanted\\b|\\biso\\b|looking for|\\bparts?\\b.*for sale|\\bwheels?\\b|\\btires?\\b|\\bseats?\\b|\\bhood\\b|\\bexhaust\\b/i.test(title) && !/\\b(19\\d\\d|200\\d)\\b[^|]*\\b(corvette|vette)\\b/i.test(title)) continue;\n const h = enrichHit({ extId: id, url: link, title, text: text.slice(0, 5000), posted: date || null, note: `${ctx.url.replace(/^https?:\\/\\/(www\\.)?/, \"\").split(\"/\")[0]}: ${title.slice(0, 80)}` });\n if (!yearOk(h.year)) continue;\n hits.push(h);\n }\n return { hits };\n};\n\n// ---------- vBulletin forum thread list (CorvetteForum) - fallback when the RSS is blocked ----------\nexport const vbulletin: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n for (const m of html.matchAll(/id=\"td_threadtitle_(\\d+)\"[^>]*title=\"([^\"]*)\"[\\s\\S]*?]*>([\\s\\S]*?)<\\/a>/g)) {\n const [, id, preview, url, t] = m;\n const title = clean(stripTags(t)); const text = `${title} \\n ${clean(preview)}`;\n if (/sticky/i.test(html.slice(Math.max(0, m.index! - 400), m.index!)) && /how to|rules|read (this|first)/i.test(title)) continue;\n if (!CORVETTE_RE.test(text) && !/\\bc[45]\\b/i.test(title)) continue;\n if (/\\bwtb\\b|\\bwanted\\b|\\biso\\b|\\bsold\\b/i.test(title)) continue;\n const h = enrichHit({ extId: id, url, title, text, note: `${ctx.url.replace(/^https?:\\/\\/(www\\.)?/, \"\").split(\"/\")[0]}: ${title.slice(0, 80)}` });\n if (!yearOk(h.year)) continue;\n hits.push(h);\n }\n return { hits };\n};\n\n// ---------- Bring a Trailer model pages: `var auctionsCompletedInitialData = {...}` (24 most recent completed) -> comps ----------\nexport const bat: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n const i = html.indexOf(\"var auctionsCompletedInitialData = \"); if (i < 0) return { hits };\n const j = html.indexOf(\"/* ]]> */\", i); const raw = html.slice(i + \"var auctionsCompletedInitialData = \".length, j > 0 ? j : undefined).trim().replace(/;\\s*$/, \"\");\n let d: any; try { d = JSON.parse(raw); } catch { return { hits }; }\n for (const it of d.items || []) {\n const sold = /Sold for/i.test(String(it.sold_text || \"\"));\n const title = clean(String(it.title || \"\")); const excerpt = clean(stripTags(String(it.excerpt || \"\")));\n const year = inferYear(title); if (!yearOk(year)) continue;\n const miles = (title.match(/\\b(\\d{1,3})k-Mile/i) || [])[1] ? Number((title.match(/\\b(\\d{1,3})k-Mile/i) || [])[1]) * 1000 : inferMiles(`${title} ${excerpt}`);\n const soldDate = it.timestamp_end ? new Date(Number(it.timestamp_end) * 1000).toISOString().slice(0, 10) : null;\n hits.push({ extId: String(it.id), url: String(it.url), title, text: `${title} \\n ${excerpt}`, year, miles, price: null,\n trans: /6-speed|six-speed|manual/i.test(`${title} ${excerpt}`) ? \"manual\" : /automatic|four-speed auto|4l60/i.test(`${title} ${excerpt}`) ? \"auto\" : \"unknown\",\n body: inferBody(title), soldPrice: sold ? Number(it.current_bid) || null : null, soldDate, note: sold ? String(it.sold_text).replace(/<[^>]+>/g, \"\").trim() : `reserve not met - bid to $${it.current_bid}` });\n }\n return { hits };\n};\n\n// ---------- Cars & Bids past auctions (server-rendered cards or __NEXT_DATA__) -> comps ----------\nexport const carsandbids: Parser = (html, ctx) => {\n const hits: Hit[] = [];\n const nd = html.match(/\r\n\r\n\r\n`;\r\n\r\nexport default async function (req: Request): Promise {\r\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\r\n if (!checkToken(req)) return new Response(\"unauthorized: open the tracker link that includes ?token=\", { status: 401 });\r\n return new Response(HTML, { headers: { \"content-type\": \"text/html; charset=utf-8\", \"cache-control\": \"no-store\", \"x-robots-tag\": \"noindex\" } });\r\n}\r\n",[],[162,172],"cd618113-b94e-4d68-bdbc-3d77cca4c359","feed.ts","2b16e0f0-af8b-11f1-8152-1607ee4eb77e",13,["D",1789314768331],"// corvette-feed: JSON feed of tracked listings (GET). The tracker page pulls this on open.\n// Token via X-Corvette-Token header or ?token=. Returns a bare JSON array of\n// { id, vin, year, gen, model, trim, trans, body, miles, price, allin, title, seller, loc, dist, stretch, url, src, note, fs, lv, status, missed, score, flags }.\n//\n// ?days=N window on last_seen (default 60)\n// ?v=2 adds price_trail, age_days, posted_at, drops, motivated, anomaly, lat, lon, gone_at, auction_date, decode, decode_mismatch, pushed\n// ?alive=1 exclude dead rows (default includes them - they carry price context and show greyed in the tracker)\n// ?stats=1 stats object instead of the array\n// ?comps=1 the comps table (auction results) instead of listings\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, activeListings, checkToken, json, CORS, PUSH_THRESHOLD } from \"../lib/core.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (req.method !== \"GET\") return json({ error: \"GET only\" }, 405);\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n await ensureSchema();\n const url = new URL(req.url);\n if (url.searchParams.get(\"stats\")) {\n const bySrc = await sqlite.execute(`select source, count(*) n, sum(status='dead') dead, max(last_seen) last from listings group by source`);\n const byGen = await sqlite.execute(`select gen, trans, count(*) n, round(avg(price)) avg_price, min(price) min_price from listings where status<>'dead' group by gen, trans`);\n const recent = await sqlite.execute(`select ts, job, ok, fetched, inserted, updated, pushed, substr(detail,1,300) detail from poll_log order by id desc limit 15`);\n const total = await sqlite.execute(`select count(*) n, sum(score>=${PUSH_THRESHOLD}) hot, sum(pushed) pushed, sum(status='dead') dead, sum(vin is not null) with_vin from listings`);\n const comps = await sqlite.execute(`select source, count(*) n, min(sold_date) oldest, max(sold_date) newest from comps group by source`);\n return json({ total: total.rows[0], bySource: bySrc.rows, byGenTrans: byGen.rows, comps: comps.rows, recentPolls: recent.rows });\n }\n if (url.searchParams.get(\"comps\")) {\n const r = await sqlite.execute(`select source, external_id, year, gen, trans, body, miles, sold_price, sold_date, url, title, vin from comps order by sold_date desc limit 500`);\n return json(r.rows, 200, { \"cache-control\": \"no-store\" });\n }\n const days = Math.min(365, Math.max(1, Number(url.searchParams.get(\"days\") || 60)));\n const list = await activeListings(days, Number(url.searchParams.get(\"v\") || 1), !url.searchParams.get(\"alive\"));\n return json(list, 200, { \"cache-control\": \"no-store\" });\n}\n",[],[162,181],"33dae6bd-7997-40cb-81a3-ce8f73eb5f97","admin.ts","411cebc4-af8b-11f1-871a-1607ee4eb77e",76,["D",1789472822843],"// corvette-admin: token-checked maintenance endpoint for validation and manual runs.\n// GET ?job=craigslist | sources | enrich | digest run a job now (digest sends immediately)\n// ?job=sources&only= ?job=sources&force=1 one source / ignore the `every` interval\n// ?job=enrich[&force=1][&step=queue|decode|recalls|geocode|price]\n// ?job=rescore recompute score/flags for every active row (after a rule change)\n// GET ?sql=select ... read-only query (SELECT only)\n// GET ?testpush=1 send a full test Discord embed\n// GET ?pushpending=1 push every active score>=threshold row never alerted (webhook was down)\n// POST { id, status[, gone: true|reason] } set a listing's status (new|contacted|ppi|offer|dead); gone -> gone_at + GONE flag\n// GET ?job=enrich&step=verify[&force=1] re-fetch listing URLs now and mark gone ones (force: 30 rows, ignore the 12 h cadence)\n// POST { delete: { id? | rowid? | source? | url_like? | before? } }\n// POST { comps: [...] } load auction comps pulled locally (scripts/pull_comps.ts)\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { ensureSchema, checkToken, json, CORS, STATUS, pushDiscord, actionLinks, rowToPush, pushThresholdFor, score, flagsFor, decorateNotes, ageDays, conditionPoints, genFor } from \"../lib/core.ts\";\nimport craigslist from \"../cron/craigslist.ts\";\nimport sources from \"../cron/sources.ts\";\nimport enrich, { markGone } from \"../cron/enrich.ts\";\nimport { sendDigest } from \"../cron/digest.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n await ensureSchema();\n const url = new URL(req.url);\n\n if (req.method === \"POST\") {\n const b = await req.json().catch(() => ({}));\n if (b.delete && typeof b.delete === \"object\") {\n const w: string[] = []; const a: any[] = [];\n if (b.delete.id != null) { w.push(\"id=?\"); a.push(b.delete.id); }\n if (b.delete.rowid != null) { w.push(\"rowid_pk=?\"); a.push(Number(b.delete.rowid)); }\n if (b.delete.source) { w.push(\"source=?\"); a.push(b.delete.source); }\n if (b.delete.url_like) { w.push(\"url like ?\"); a.push(b.delete.url_like); }\n if (b.delete.before) { w.push(\"first_seen k.source && k.external_id && k.url);\n let inserted = 0;\n for (const k of rows) {\n const ex = await sqlite.execute({ sql: `select 1 from comps where source=? and external_id=?`, args: [String(k.source), String(k.external_id)] });\n await sqlite.execute({ sql: `insert into comps (source, external_id, year, gen, trans, body, miles, sold_price, sold_date, url, title, vin, added) values (?,?,?,?,?,?,?,?,?,?,?,?,date('now'))\n on conflict(source, external_id) do update set sold_price=coalesce(excluded.sold_price, comps.sold_price), sold_date=coalesce(excluded.sold_date, comps.sold_date), miles=coalesce(excluded.miles, comps.miles), trans=case when excluded.trans<>'unknown' then excluded.trans else comps.trans end`,\n args: [String(k.source), String(k.external_id), k.year ?? null, k.gen || genFor(k.year ?? null), k.trans || \"unknown\", k.body || \"unknown\", k.miles ?? null, k.sold_price ?? null, k.sold_date ?? null, String(k.url), String(k.title || \"\").slice(0, 200), k.vin || null] });\n if (!ex.rows.length) inserted++;\n }\n const n = await sqlite.execute(`select source, count(*) n from comps group by source`);\n return json({ ok: true, received: rows.length, inserted, totals: n.rows });\n }\n if (!b.id || !STATUS.includes(b.status)) return json({ error: `need id and status in ${STATUS.join(\"|\")}` }, 400);\n if (b.gone) { // tracker \"Gone\" button (Facebook rows the verify step cannot fetch): dead + gone_at + GONE flag in one call\n const cur = await sqlite.execute({ sql: `select rowid_pk, status, flags, notes from listings where id=?`, args: [b.id] });\n const row: any = cur.rows[0]; if (!row) return json({ error: \"no such id\" }, 404);\n await markGone(Number(row.rowid_pk), String(b.gone === true ? \"marked in tracker\" : b.gone).slice(0, 40), row);\n if (b.status !== \"dead\") await sqlite.execute({ sql: `update listings set status=? where id=?`, args: [b.status, b.id] });\n return json({ ok: true, gone: true });\n }\n const r = await sqlite.execute({ sql: `update listings set status=?, gone_at=case when ?='dead' then gone_at else null end where id=?`, args: [b.status, b.status, b.id] }); // reviving a row clears gone_at\n return json({ ok: true, rowsAffected: r.rowsAffected });\n }\n\n const job = url.searchParams.get(\"job\");\n if (job === \"craigslist\") return json(await craigslist());\n if (job === \"sources\") return json(await sources({ only: url.searchParams.get(\"only\") || undefined, force: !!url.searchParams.get(\"force\") }));\n if (job === \"enrich\") return json(await enrich({ force: !!url.searchParams.get(\"force\"), step: url.searchParams.get(\"step\") || undefined }));\n if (job === \"digest\") return json(await sendDigest(true));\n if (job === \"rescore\") {\n const rows = await sqlite.execute(`select * from listings where last_seen >= date('now','-60 day')`);\n let changed = 0;\n for (const r of rows.rows as any[]) {\n const text = [r.raw, r.notes].filter(Boolean).join(\" \");\n const s = score({ year: r.year == null ? null : Number(r.year), gen: r.gen, trans: r.trans, miles: r.miles == null ? null : Number(r.miles), seller: r.seller, price: r.price == null ? null : Number(r.price), dist: r.dist == null ? null : Number(r.dist), title: r.title, vin: r.vin, conditionPts: conditionPoints(text, r.gen) });\n const keep = String(r.flags || \"\").split(\"|\").filter((f: string) => /^(DEAD |VIN MISMATCH|PRICE ANOMALY|DROP |MOTIVATED)/.test(f));\n const fl = [...keep, ...flagsFor({ vin: r.vin, trim: String(r.trim || \"\"), trans: r.trans, text: String(r.raw || \"\"), dist: r.dist == null ? null : Number(r.dist), ageDays: ageDays(r.posted_at, r.first_seen) })];\n const flags = [...new Set(fl)].join(\"|\");\n if (s !== Number(r.score) || flags !== r.flags) { await sqlite.execute({ sql: `update listings set score=?, flags=?, notes=? where rowid_pk=?`, args: [s, flags, decorateNotes(String(r.notes || \"\"), flags.split(\"|\").filter(Boolean)), r.rowid_pk] }); changed++; }\n }\n return json({ rows: rows.rows.length, changed });\n }\n\n if (url.searchParams.get(\"pushpending\")) {\n const r = await sqlite.execute(`select * from listings where pushed = 0 and status <> 'dead' and last_seen >= date('now','-14 day') and julianday('now') - julianday(coalesce(posted_at, first_seen)) <= 45 order by score desc`);\n const out: any[] = [];\n for (const row of r.rows as any[]) {\n if (Number(row.score) < pushThresholdFor(row.dist == null ? null : Number(row.dist), row.seller)) continue;\n const ok = await pushDiscord(rowToPush(row));\n if (ok) await sqlite.execute({ sql: `update listings set pushed=1 where rowid_pk=?`, args: [row.rowid_pk] });\n out.push({ id: row.id, score: row.score, pushed: ok });\n }\n return json({ pending: out.length, results: out });\n }\n\n if (url.searchParams.get(\"testpush\")) {\n const l = { id: \"1G1YY22G215100001\", rowid: null, vin: \"1G1YY22G215100001\", year: 2001, gen: \"C5\" as const, trim: \"\", trans: \"auto\" as const, body: \"coupe\" as const, miles: 78500, price: 11500, title: \"clean\" as const, seller: \"private\" as const,\n loc: \"Boardman, OH - CL youngstown\", lat: 41.0242, lon: -80.6629, dist: 18, url: \"https://example.com/test-corvette\", source: \"test\", score: 11, flags: [\"MOTIVATED\", \"DROP $500\"], notes: \"Pipeline test; ignore. Service records, column lock recall done.\", trail: [12500, 12000, 11500], ageDays: 12 };\n const ok = await pushDiscord(l);\n return json({ pushed: ok, links: actionLinks(l) });\n }\n\n const sql = url.searchParams.get(\"sql\");\n if (sql) {\n if (!/^\\s*select\\b/i.test(sql)) return json({ error: \"SELECT only\" }, 400);\n const r = await sqlite.execute(sql);\n return json({ columns: r.columns, rows: r.rows });\n }\n return json({ usage: \"?job=craigslist|sources[&only=key][&force=1]|enrich[&step=..]|digest|rescore ?sql=select... ?testpush=1 ?pushpending=1 POST {id,status} POST {delete:{...}}\" });\n}\n",[],[162,189],"4e8a0f88-b47d-4b43-86fa-affd72346a91","add.ts","38cdf558-af8b-11f1-8c3c-1607ee4eb77e",21,["D",1789314991805],"// corvette-add: manual ingestion endpoint (POST). Claude in Chrome and Logan post FB Marketplace / FB group /\n// portal finds here. Shared-secret header X-Corvette-Token (or ?token=).\n//\n// Body (JSON, single object or array <= 50):\n// { url, src, vin?, year?, trans?, body?, miles?, price?, title?, seller?, loc?, lat?, lon?, note?, text?, posted?, external_id?, auction_date? }\n// `text` is the listing body; any field left blank is inferred from it. Returns the upsert result per item\n// (action inserted|updated|merged, id = VIN or \"SRC extId\", score, pushed, dead reason if any).\nimport {\n TRANS, BODY, TITLE, SELLER, ensureSchema, upsertListing, inferYear, inferTrans, inferBody, inferTitle, inferSeller, inferMiles, inferPrice, inferTrim,\n parsePrice, parseMiles, findVin, normalizeVin, validVin, checkToken, json, CORS, YEAR_MIN, YEAR_MAX, type Seller,\n} from \"../lib/core.ts\";\n\nexport default async function (req: Request): Promise {\n if (req.method === \"OPTIONS\") return new Response(null, { status: 204, headers: CORS });\n if (req.method !== \"POST\") return json({ error: \"POST only\" }, 405);\n if (!checkToken(req)) return json({ error: \"unauthorized\" }, 401);\n let body: any;\n try { body = await req.json(); } catch { return json({ error: \"invalid JSON\" }, 400); }\n const items: any[] = Array.isArray(body) ? body : [body];\n if (items.length === 0 || items.length > 50) return json({ error: \"1-50 listings per request\" }, 400);\n await ensureSchema();\n const results: any[] = [];\n for (const it of items) {\n const text = [it.title, it.loc, it.note, it.text].filter(Boolean).join(\" \\n \");\n const url = String(it.url || \"\").trim();\n const src = String(it.src || it.source || \"manual\").toLowerCase().trim();\n if (!url) { results.push({ error: \"need url\", input: it }); continue; }\n const vinIn = it.vin ? normalizeVin(it.vin) : null;\n if (it.vin && !validVin(vinIn)) results.push({ warning: `VIN ${it.vin} failed validation (17 chars, no I/O/Q, check digit); stored without it` });\n const vin = validVin(vinIn) ? vinIn : findVin(text);\n const year = it.year != null && it.year !== \"\" ? Number(it.year) : inferYear(text);\n if (year != null && (year < YEAR_MIN || year > YEAR_MAX)) { results.push({ skipped: `year ${year} outside ${YEAR_MIN}-${YEAR_MAX}`, input: it }); continue; }\n const trans = TRANS.includes(it.trans) ? it.trans : /^a/i.test(String(it.trans || \"\")) ? \"auto\" : /^m/i.test(String(it.trans || \"\")) ? \"manual\" : inferTrans(text);\n const bodyT = BODY.includes(it.body) ? it.body : inferBody(text);\n const title = TITLE.includes(it.title_status || it.title) ? (it.title_status || it.title) : inferTitle(text);\n const sellerDefault: Seller = [\"fb\", \"fbm\", \"facebook\", \"craigslist\", \"forum\", \"manual\", \"sign\"].includes(src) ? \"private\" : [\"autotrader\", \"cars\", \"cargurus\", \"carsforsale\", \"dealer\"].includes(src) ? \"dealer-small\" : \"unknown\";\n const seller = SELLER.includes(it.seller) ? it.seller : inferSeller(text, sellerDefault);\n const miles = it.miles != null && it.miles !== \"\" ? parseMiles(it.miles) : inferMiles(text);\n const price = it.price != null && it.price !== \"\" ? parsePrice(it.price) : inferPrice(text);\n const r = await upsertListing({\n vin, year, trim: inferTrim(String(it.title || it.trim || \"\")), trans, body: bodyT, miles, price, title, seller, loc: String(it.loc || it.location || \"\").trim(),\n lat: it.lat != null ? Number(it.lat) : null, lon: it.lon != null ? Number(it.lon) : null,\n source: src, externalId: it.external_id || it.externalId || (url.match(/(\\d{6,})/) || [])[1] || null, url,\n notes: String(it.note || \"\").trim(), raw: it.text ? String(it.text) : undefined, text, postedAt: it.posted || it.posted_at || null, auctionDate: it.auction_date || null,\n }, { push: true });\n results.push(r);\n }\n return json({ ok: true, results });\n}\n",[],[162,197],"00cc23ab-c212-43f5-a7c5-1ba797ecaa18",["D",1789312547277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","C4/C5 Corvette search pipeline (CL, forums, auctions, comps)","imageUrl","userId","87445237-7d14-45c7-b3a2-72e031f10ec1","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","01a09786-a61b-74b5-8910-af3116d3de5c","tursoName","00cc23abc21243f5a7c51ba797ecaa18","tursoHostname","00cc23abc21243f5a7c51ba797ecaa18-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789486866837],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_261":257},"org",{"_11":12,"_254":255,"_256":257,"_214":215,"_258":259,"_260":69},"branch",{"_17":50,"_13":16,"_33":36,"_246":204,"_247":-5,"_248":-5,"_249":-5,"_250":-5,"_251":-5,"_252":14,"_253":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Logan","avatar","https://lh3.googleusercontent.com/a/ACg8ocIFxddfJftSiTFZN49YShT3nY7q8GOQ7dXYM2vJ6XkajnQMGA=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":204,"_13":14,"_47":343,"_206":-5,"_207":69,"_208":209,"_210":209,"_211":212,"_213":-5,"_214":215,"_216":182,"_217":64,"_218":-5,"_219":-5,"_220":66,"_221":222,"_223":224,"_225":226,"_227":344,"_229":-5,"_230":231,"_232":231,"_233":234,"_235":234,"_236":234,"_237":231,"_238":231,"_239":345,"_241":346,"_243":347,"_245":69},[292,297,302,304,308],"files",[292,293,294,295,296,297,298,299,300,301,302,303,304,305,306,307,308],"counts",{"_283":66,"_284":62,"_285":66,"_32":286,"_287":288},[],{"_33":34,"_13":39,"_37":38,"_45":46,"_35":36,"_49":50,"_63":64,"_47":281,"_17":44,"_42":43,"_40":41,"_68":69,"_51":-5,"_18":282},"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1789473245260],[53,39],"pulls","branches","forks",{"_289":106,"_291":66},"connections",{"_289":66,"_290":66},"count","unfilledCount","emptyCount",{"_33":161,"_13":162,"_37":163,"_45":-5,"_35":36,"_49":149,"_63":64,"_47":164,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":341,"_18":342},{"_33":196,"_13":197,"_37":198,"_45":163,"_35":36,"_49":199,"_63":64,"_47":200,"_17":76,"_42":176,"_40":201,"_68":69,"_51":-5,"_70":339,"_18":340},{"_33":188,"_13":189,"_37":190,"_45":163,"_35":36,"_49":191,"_63":64,"_47":192,"_17":76,"_42":176,"_40":193,"_68":69,"_51":-5,"_70":337,"_18":338},{"_33":180,"_13":181,"_37":182,"_45":163,"_35":36,"_49":183,"_63":64,"_47":184,"_17":66,"_42":176,"_40":185,"_68":69,"_51":-5,"_70":335,"_18":336},{"_33":171,"_13":172,"_37":173,"_45":163,"_35":36,"_49":174,"_63":64,"_47":175,"_17":149,"_42":176,"_40":177,"_68":69,"_51":-5,"_70":333,"_18":334},{"_33":126,"_13":53,"_37":46,"_45":-5,"_35":36,"_49":44,"_63":64,"_47":127,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":331,"_18":332},{"_33":153,"_13":154,"_37":155,"_45":46,"_35":36,"_49":156,"_63":64,"_47":157,"_17":106,"_42":43,"_40":158,"_68":69,"_51":-5,"_70":329,"_18":330},{"_33":144,"_13":145,"_37":146,"_45":46,"_35":36,"_49":147,"_63":64,"_47":148,"_17":149,"_42":43,"_40":150,"_68":69,"_51":-5,"_70":327,"_18":328},{"_33":34,"_13":39,"_37":38,"_45":46,"_35":36,"_49":50,"_63":64,"_47":141,"_17":44,"_42":43,"_40":41,"_68":69,"_51":-5,"_70":325,"_18":326},{"_33":134,"_13":85,"_37":135,"_45":46,"_35":36,"_49":136,"_63":64,"_47":137,"_17":44,"_42":43,"_40":138,"_68":69,"_51":-5,"_70":323,"_18":324},{"_33":110,"_13":111,"_37":112,"_45":-5,"_35":36,"_49":113,"_63":64,"_47":114,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":321,"_18":322},{"_33":118,"_13":119,"_37":120,"_45":112,"_35":36,"_49":121,"_63":64,"_47":122,"_17":66,"_42":111,"_40":123,"_68":69,"_51":-5,"_70":319,"_18":320},{"_33":73,"_13":74,"_37":75,"_45":-5,"_35":36,"_49":76,"_63":64,"_47":77,"_17":66,"_42":78,"_40":-5,"_68":69,"_51":-5,"_70":317,"_18":318},{"_33":101,"_13":102,"_37":103,"_45":75,"_35":36,"_49":104,"_63":64,"_47":105,"_17":106,"_42":90,"_40":107,"_68":69,"_51":-5,"_70":315,"_18":316},{"_33":94,"_13":39,"_37":95,"_45":75,"_35":36,"_49":96,"_63":64,"_47":97,"_17":76,"_42":90,"_40":98,"_68":69,"_51":-5,"_70":313,"_18":314},{"_33":84,"_13":85,"_37":86,"_45":75,"_35":36,"_49":87,"_63":64,"_47":88,"_17":89,"_42":90,"_40":91,"_68":69,"_51":-5,"_70":311,"_18":312},{"_33":59,"_13":60,"_37":61,"_45":-5,"_35":36,"_49":62,"_63":64,"_47":65,"_17":66,"_42":24,"_40":67,"_68":69,"_51":-5,"_70":309,"_18":310},[],[60],[],[74,85],[],[74,39],[],[74,102],[305,306,307],[74],[],[111,119],[303],[111],[],[53,85],[],[53,39],[],[53,145],[],[53,154],[298,299,300,301],[53],[],[162,172],[],[162,181],[],[162,189],[],[162,197],[293,294,295,296],[162],["D",1789312547277],["D",1789486866837],{"_11":12,"_261":257},{"_11":12,"_254":255,"_256":257,"_214":215,"_258":259,"_260":69},{"_17":50,"_13":16,"_33":36,"_246":204,"_247":-5,"_248":-5,"_249":-5,"_250":-5,"_251":-5,"_252":14,"_253":12},"ctx",{"_239":-5,"_278":381,"_382":383,"_384":385,"_386":69,"_387":69,"_388":69,"_389":64,"_390":-5,"_391":-7,"_392":-7,"_393":66,"_394":69,"_395":69,"_396":-5,"_397":69,"_398":69,"_399":69,"_400":-5},"ENV",{"_352":353,"_354":355,"_356":16,"_357":358,"_359":360,"_361":362,"_363":364,"_365":366,"_367":368,"_369":370,"_371":372,"_373":374,"_375":376,"_377":378,"_379":380},"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"]