[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_325":326,"_327":328},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_110":91,"_27":111,"_13":14,"_112":-5,"_11":113,"_114":115,"_116":117,"_118":119,"_120":121,"_20":-5,"_122":-5,"_123":-5,"_124":25,"_125":126,"_127":60,"_128":-5,"_129":-5,"_130":131},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",73,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","lib/enrich.ts","latestPath","fileId","2954cc82-af86-11f1-b398-1607ee4eb77e","name","enrich.ts","fileType","script","content","// Enrichment helpers (flags, not fit-score rules): price anomaly vs a rolling P25, price history /\r\n// MOTIVATED, notes prefixes, quiet-hours push queue. Pure helpers are exported for unit tests; the\r\n// sqlite-backed functions run inside upsertListing (cheap local queries only) and cron/enrich.ts.\r\n// NOTHING here touches score().\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\n\r\nexport async function ensureEnrichSchema() {\r\n await sqlite.batch([\r\n `create table if not exists price_history (id integer primary key autoincrement, rowid_pk integer not null, price integer, seen text not null)`,\r\n `create index if not exists ph_row on price_history(rowid_pk, id)`,\r\n `create table if not exists push_queue (id integer primary key autoincrement, rowid_pk integer, payload text not null, queued text not null, released text)`,\r\n `create table if not exists enrich_state (key text primary key, value text)`,\r\n ]);\r\n}\r\nexport async function getState(key: string): Promise {\r\n const r = await sqlite.execute({ sql: `select value from enrich_state where key=?`, args: [key] });\r\n return r.rows.length ? String((r.rows[0] as any).value) : null;\r\n}\r\nexport async function setState(key: string, value: string | null) {\r\n if (value == null) await sqlite.execute({ sql: `delete from enrich_state where key=?`, args: [key] });\r\n else await sqlite.execute({ sql: `insert or replace into enrich_state (key, value) values (?,?)`, args: [key, value] });\r\n}\r\n\r\n// ---------- price anomaly: < 0.75 x rolling 90-day P25 for year-band x trans (min 8 rows) ----------\r\nexport function p25(values: number[]): number | null {\r\n const v = values.filter((x) => Number.isFinite(x)).sort((a, b) => a - b);\r\n if (!v.length) return null;\r\n const pos = 0.25 * (v.length - 1); const lo = Math.floor(pos), hi = Math.ceil(pos);\r\n return v[lo] + (v[hi] - v[lo]) * (pos - lo);\r\n}\r\nexport const ANOMALY_RATIO = 0.75, P25_MIN_ROWS = 8;\r\nexport function isAnomaly(price: number | null | undefined, p25Value: number | null): boolean {\r\n return price != null && p25Value != null && price < ANOMALY_RATIO * p25Value;\r\n}\r\n// year bands match the scoring buckets so the P25 compares like with like\r\nexport function yearBand(year: number | null): [number, number] | null {\r\n if (year == null) return null;\r\n if (year >= 1999 && year <= 2004) return [1999, 2004];\r\n if (year >= 1997 && year <= 1998) return [1997, 1998];\r\n if (year >= 1994 && year <= 1996) return [1994, 1996];\r\n if (year >= 1992 && year <= 1993) return [1992, 1993];\r\n return null;\r\n}\r\nexport async function p25For(year: number | null, trans: string): Promise<{ p25: number | null; basis: string }> {\r\n const band = yearBand(year); if (!band) return { p25: null, basis: \"no band\" };\r\n const since = new Date(Date.now() - 90 * 86400000).toISOString().slice(0, 10);\r\n const base = `from listings where price is not null and first_seen >= ? and year between ? and ? and status <> 'dead'`;\r\n const byTrans = await sqlite.execute({ sql: `select price ${base} and trans=?`, args: [since, band[0], band[1], trans] });\r\n if (byTrans.rows.length >= P25_MIN_ROWS) return { p25: p25((byTrans.rows as any[]).map((r) => Number(r.price))), basis: `${band[0]}-${band[1]} ${trans} n=${byTrans.rows.length}` };\r\n const comps = await sqlite.execute({ sql: `select sold_price price from comps where sold_price is not null and year between ? and ? and (trans=? or trans='unknown') and sold_date >= date('now','-365 day')`, args: [band[0], band[1], trans] });\r\n const pool = [...(byTrans.rows as any[]), ...(comps.rows as any[])].map((r) => Number(r.price));\r\n if (pool.length >= P25_MIN_ROWS) return { p25: p25(pool), basis: `${band[0]}-${band[1]} ${trans} +comps n=${pool.length}` };\r\n return { p25: null, basis: \"insufficient rows\" };\r\n}\r\n\r\n// ---------- price history + MOTIVATED ----------\r\nexport const MOTIVATED_AGE_ANY_DROP = 25;\r\nexport function motivatedFlag(drops: number, ageDays: number): boolean {\r\n return drops >= 2 || (ageDays >= MOTIVATED_AGE_ANY_DROP && drops >= 1);\r\n}\r\nexport function trailStats(trail: (number | null)[]): { drops: number; lastDrop: number; fromMax: number } {\r\n const t = trail.filter((x): x is number => x != null);\r\n let drops = 0, lastDrop = 0;\r\n for (let i = 1; i < t.length; i++) if (t[i] < t[i - 1]) { drops++; lastDrop = t[i - 1] - t[i]; }\r\n const fromMax = t.length ? Math.max(...t) - t[t.length - 1] : 0;\r\n return { drops, lastDrop, fromMax };\r\n}\r\nexport const fmtTrail = (trail: (number | null)[]) => trail.map((p) => p == null ? \"$?\" : `$${p.toLocaleString(\"en-US\")}`).join(\" -> \");\r\nexport async function recordPrice(rowid: number, price: number | null, when = new Date().toISOString().slice(0, 10)): Promise {\r\n const last = await sqlite.execute({ sql: `select price from price_history where rowid_pk=? order by id desc limit 1`, args: [rowid] });\r\n const prev = last.rows.length ? (last.rows[0] as any).price : undefined;\r\n if (prev === undefined || (price != null && Number(prev) !== price)) {\r\n await sqlite.execute({ sql: `insert into price_history (rowid_pk, price, seen) values (?,?,?)`, args: [rowid, price, when] });\r\n }\r\n return await priceTrail(rowid) as number[];\r\n}\r\nexport async function priceTrail(rowid: number): Promise<(number | null)[]> {\r\n const all = await sqlite.execute({ sql: `select price from price_history where rowid_pk=? order by id`, args: [rowid] });\r\n return (all.rows as any[]).map((r) => r.price == null ? null : Number(r.price));\r\n}\r\n\r\n// ---------- notes prefixes: flags rendered as \"FLAG | FLAG | \" ahead of the free-text notes ----------\r\nconst FLAG_TOKEN = `(?:DEAD [^|]+|NO VIN|PRICE ANOMALY|STALE \\\\d+d|DROP \\\\$[\\\\d,]+|MOTIVATED|DEALER FEE\\\\?|MANUAL-ONLY MODEL|STRETCH|FAR|OUT OF RANGE|OUT-OF-REGION SITE|SCAM\\\\?|SELLER MOTIVE|FIRM|REPOST x\\\\d+|VIN MISMATCH[^|]*)`;\r\nexport const PREFIX_RE = new RegExp(`^(?:${FLAG_TOKEN} \\\\| )+`);\r\nconst LONE_PREFIX_RE = new RegExp(`^(?:${FLAG_TOKEN}(?: \\\\| )?)+$`);\r\nexport function stripPrefixes(notes: string): string { const n = (notes || \"\").replace(PREFIX_RE, \"\"); return LONE_PREFIX_RE.test(n) ? \"\" : n; }\r\nexport function buildPrefix(flags: string[]): string { return flags.length ? flags.join(\" | \") + \" | \" : \"\"; }\r\n\r\n// ---------- quiet hours (23:00-07:00 America/New_York) ----------\r\nexport function etHour(d: Date): number {\r\n return Number(new Intl.DateTimeFormat(\"en-US\", { timeZone: \"America/New_York\", hour: \"numeric\", hour12: false }).format(d).replace(/^24$/, \"0\"));\r\n}\r\nexport function isQuietHour(d = new Date()): boolean { const h = etHour(d); return h >= 23 || h < 7; }\r\nexport async function queuePush(rowid: number | null, payload: unknown) {\r\n await sqlite.execute({ sql: `insert into push_queue (rowid_pk, payload, queued) values (?,?,?)`, args: [rowid, JSON.stringify(payload), new Date().toISOString()] });\r\n}\r\nexport async function pendingQueue(): Promise<{ id: number; rowid_pk: number | null; payload: any }[]> {\r\n const r = await sqlite.execute(`select id, rowid_pk, payload from push_queue where released is null order by id`);\r\n return (r.rows as any[]).map((x) => ({ id: Number(x.id), rowid_pk: x.rowid_pk == null ? null : Number(x.rowid_pk), payload: JSON.parse(String(x.payload)) }));\r\n}\r\nexport async function markReleased(ids: number[]) {\r\n if (!ids.length) return;\r\n await sqlite.execute({ sql: `update push_queue set released=? where id in (${ids.map(() => \"?\").join(\",\")})`, args: [new Date().toISOString(), ...ids] });\r\n}\r\n\r\n// ---------- disappearance (missed counter -> dead at 3, only for status 'new') ----------\r\nexport const DEAD_AFTER_MISSED = 3;\r\nexport function missedUpdates(rows: { rowid_pk: number; external_id: string | null; missed: number; status: string }[], seen: Set) {\r\n const inc: number[] = [], dead: number[] = [];\r\n for (const r of rows) {\r\n if (r.external_id && seen.has(r.external_id)) continue;\r\n if (r.status === \"dead\") continue;\r\n inc.push(r.rowid_pk);\r\n if (r.missed + 1 >= DEAD_AFTER_MISSED && r.status === \"new\") dead.push(r.rowid_pk);\r\n }\r\n return { inc, dead };\r\n}\r\nexport async function applyMissed(source: string, seen: Set): Promise<{ inc: number; dead: number }> {\r\n const r = await sqlite.execute({ sql: `select rowid_pk, external_id, missed, status from listings where source=? and status <> 'dead' and last_seen >= date('now','-60 day')`, args: [source] });\r\n const u = missedUpdates(r.rows as any[], seen);\r\n const now = new Date().toISOString().slice(0, 10);\r\n const stmts: { sql: string; args: any[] }[] = [];\r\n if (u.inc.length) stmts.push({ sql: `update listings set missed=missed+1 where rowid_pk in (${u.inc.map(() => \"?\").join(\",\")})`, args: u.inc });\r\n if (u.dead.length) stmts.push({ sql: `update listings set status='dead', gone_at=coalesce(gone_at, ?) where rowid_pk in (${u.dead.map(() => \"?\").join(\",\")})`, args: [now, ...u.dead] });\r\n if (stmts.length) await sqlite.batch(stmts);\r\n return { inc: u.inc.length, dead: u.dead.length };\r\n}\r\n","// Enrichment helpers (flags, not fit-score rules): price anomaly vs a rolling P25, price history /\n// MOTIVATED, notes prefixes, quiet-hours push queue. Pure helpers are exported for unit tests; the\n// sqlite-backed functions run inside upsertListing (cheap local queries only) and cron/enrich.ts.\n// NOTHING here touches score().\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function ensureEnrichSchema() {\n await sqlite.batch([\n `create table if not exists price_history (id integer primary key autoincrement, rowid_pk integer not null, price integer, seen text not null)`,\n `create index if not exists ph_row on price_history(rowid_pk, id)`,\n `create table if not exists push_queue (id integer primary key autoincrement, rowid_pk integer, payload text not null, queued text not null, released text)`,\n `create table if not exists enrich_state (key text primary key, value text)`,\n ]);\n const cols = new Set(((await sqlite.execute(`pragma table_info(listings)`)).rows as any[]).map((r) => String(r.name)));\n if (!cols.has(\"verified_at\")) await sqlite.execute(`alter table listings add column verified_at text`); // last time the verify step re-fetched the listing URL\n if (!cols.has(\"verify_fails\")) await sqlite.execute(`alter table listings add column verify_fails integer not null default 0`); // consecutive soft gone signals (2 -> gone)\n}\nexport async function getState(key: string): Promise {\n const r = await sqlite.execute({ sql: `select value from enrich_state where key=?`, args: [key] });\n return r.rows.length ? String((r.rows[0] as any).value) : null;\n}\nexport async function setState(key: string, value: string | null) {\n if (value == null) await sqlite.execute({ sql: `delete from enrich_state where key=?`, args: [key] });\n else await sqlite.execute({ sql: `insert or replace into enrich_state (key, value) values (?,?)`, args: [key, value] });\n}\n\n// ---------- price anomaly: < 0.75 x rolling 90-day P25 for year-band x trans (min 8 rows) ----------\nexport function p25(values: number[]): number | null {\n const v = values.filter((x) => Number.isFinite(x)).sort((a, b) => a - b);\n if (!v.length) return null;\n const pos = 0.25 * (v.length - 1); const lo = Math.floor(pos), hi = Math.ceil(pos);\n return v[lo] + (v[hi] - v[lo]) * (pos - lo);\n}\nexport const ANOMALY_RATIO = 0.75, P25_MIN_ROWS = 8;\nexport function isAnomaly(price: number | null | undefined, p25Value: number | null): boolean {\n return price != null && p25Value != null && price < ANOMALY_RATIO * p25Value;\n}\n// year bands match the scoring buckets so the P25 compares like with like\nexport function yearBand(year: number | null): [number, number] | null {\n if (year == null) return null;\n if (year >= 1999 && year <= 2004) return [1999, 2004];\n if (year >= 1997 && year <= 1998) return [1997, 1998];\n if (year >= 1994 && year <= 1996) return [1994, 1996];\n if (year >= 1992 && year <= 1993) return [1992, 1993];\n return null;\n}\nexport async function p25For(year: number | null, trans: string): Promise<{ p25: number | null; basis: string }> {\n const band = yearBand(year); if (!band) return { p25: null, basis: \"no band\" };\n const since = new Date(Date.now() - 90 * 86400000).toISOString().slice(0, 10);\n const base = `from listings where price is not null and first_seen >= ? and year between ? and ? and status <> 'dead'`;\n const byTrans = await sqlite.execute({ sql: `select price ${base} and trans=?`, args: [since, band[0], band[1], trans] });\n if (byTrans.rows.length >= P25_MIN_ROWS) return { p25: p25((byTrans.rows as any[]).map((r) => Number(r.price))), basis: `${band[0]}-${band[1]} ${trans} n=${byTrans.rows.length}` };\n const comps = await sqlite.execute({ sql: `select sold_price price from comps where sold_price is not null and year between ? and ? and (trans=? or trans='unknown') and sold_date >= date('now','-365 day')`, args: [band[0], band[1], trans] });\n const pool = [...(byTrans.rows as any[]), ...(comps.rows as any[])].map((r) => Number(r.price));\n if (pool.length >= P25_MIN_ROWS) return { p25: p25(pool), basis: `${band[0]}-${band[1]} ${trans} +comps n=${pool.length}` };\n return { p25: null, basis: \"insufficient rows\" };\n}\n\n// ---------- price history + MOTIVATED ----------\nexport const MOTIVATED_AGE_ANY_DROP = 25;\nexport function motivatedFlag(drops: number, ageDays: number): boolean {\n return drops >= 2 || (ageDays >= MOTIVATED_AGE_ANY_DROP && drops >= 1);\n}\nexport function trailStats(trail: (number | null)[]): { drops: number; lastDrop: number; fromMax: number } {\n const t = trail.filter((x): x is number => x != null);\n let drops = 0, lastDrop = 0;\n for (let i = 1; i < t.length; i++) if (t[i] < t[i - 1]) { drops++; lastDrop = t[i - 1] - t[i]; }\n const fromMax = t.length ? Math.max(...t) - t[t.length - 1] : 0;\n return { drops, lastDrop, fromMax };\n}\nexport const fmtTrail = (trail: (number | null)[]) => trail.map((p) => p == null ? \"$?\" : `$${p.toLocaleString(\"en-US\")}`).join(\" -> \");\nexport async function recordPrice(rowid: number, price: number | null, when = new Date().toISOString().slice(0, 10)): Promise {\n const last = await sqlite.execute({ sql: `select price from price_history where rowid_pk=? order by id desc limit 1`, args: [rowid] });\n const prev = last.rows.length ? (last.rows[0] as any).price : undefined;\n if (prev === undefined || (price != null && Number(prev) !== price)) {\n await sqlite.execute({ sql: `insert into price_history (rowid_pk, price, seen) values (?,?,?)`, args: [rowid, price, when] });\n }\n return await priceTrail(rowid) as number[];\n}\nexport async function priceTrail(rowid: number): Promise<(number | null)[]> {\n const all = await sqlite.execute({ sql: `select price from price_history where rowid_pk=? order by id`, args: [rowid] });\n return (all.rows as any[]).map((r) => r.price == null ? null : Number(r.price));\n}\n\n// ---------- notes prefixes: flags rendered as \"FLAG | FLAG | \" ahead of the free-text notes ----------\nconst FLAG_TOKEN = `(?:DEAD [^|]+|NO VIN|PRICE ANOMALY|STALE \\\\d+d|DROP \\\\$[\\\\d,]+|MOTIVATED|DEALER FEE\\\\?|MANUAL-ONLY MODEL|STRETCH|FAR|OUT OF RANGE|OUT-OF-REGION SITE|SCAM\\\\?|SELLER MOTIVE|FIRM|REPOST x\\\\d+|VIN MISMATCH[^|]*)`;\nexport const PREFIX_RE = new RegExp(`^(?:${FLAG_TOKEN} \\\\| )+`);\nconst LONE_PREFIX_RE = new RegExp(`^(?:${FLAG_TOKEN}(?: \\\\| )?)+$`);\nexport function stripPrefixes(notes: string): string { const n = (notes || \"\").replace(PREFIX_RE, \"\"); return LONE_PREFIX_RE.test(n) ? \"\" : n; }\nexport function buildPrefix(flags: string[]): string { return flags.length ? flags.join(\" | \") + \" | \" : \"\"; }\n\n// ---------- quiet hours (23:00-07:00 America/New_York) ----------\nexport function etHour(d: Date): number {\n return Number(new Intl.DateTimeFormat(\"en-US\", { timeZone: \"America/New_York\", hour: \"numeric\", hour12: false }).format(d).replace(/^24$/, \"0\"));\n}\nexport function isQuietHour(d = new Date()): boolean { const h = etHour(d); return h >= 23 || h < 7; }\nexport async function queuePush(rowid: number | null, payload: unknown) {\n await sqlite.execute({ sql: `insert into push_queue (rowid_pk, payload, queued) values (?,?,?)`, args: [rowid, JSON.stringify(payload), new Date().toISOString()] });\n}\nexport async function pendingQueue(): Promise<{ id: number; rowid_pk: number | null; payload: any }[]> {\n const r = await sqlite.execute(`select id, rowid_pk, payload from push_queue where released is null order by id`);\n return (r.rows as any[]).map((x) => ({ id: Number(x.id), rowid_pk: x.rowid_pk == null ? null : Number(x.rowid_pk), payload: JSON.parse(String(x.payload)) }));\n}\nexport async function markReleased(ids: number[]) {\n if (!ids.length) return;\n await sqlite.execute({ sql: `update push_queue set released=? where id in (${ids.map(() => \"?\").join(\",\")})`, args: [new Date().toISOString(), ...ids] });\n}\n\n// ---------- disappearance (missed counter -> dead at 3, only for status 'new') ----------\nexport const DEAD_AFTER_MISSED = 3;\nexport function missedUpdates(rows: { rowid_pk: number; external_id: string | null; missed: number; status: string }[], seen: Set) {\n const inc: number[] = [], dead: number[] = [];\n for (const r of rows) {\n if (r.external_id && seen.has(r.external_id)) continue;\n if (r.status === \"dead\") continue;\n inc.push(r.rowid_pk);\n if (r.missed + 1 >= DEAD_AFTER_MISSED && r.status === \"new\") dead.push(r.rowid_pk);\n }\n return { inc, dead };\n}\nexport async function applyMissed(source: string, seen: Set): Promise<{ inc: number; dead: number }> {\n const r = await sqlite.execute({ sql: `select rowid_pk, external_id, missed, status from listings where source=? and status <> 'dead' and last_seen >= date('now','-60 day')`, args: [source] });\n const u = missedUpdates(r.rows as any[], seen);\n const now = new Date().toISOString().slice(0, 10);\n const stmts: { sql: string; args: any[] }[] = [];\n if (u.inc.length) stmts.push({ sql: `update listings set missed=missed+1 where rowid_pk in (${u.inc.map(() => \"?\").join(\",\")})`, args: u.inc });\n if (u.dead.length) stmts.push({ sql: `update listings set status='dead', gone_at=coalesce(gone_at, ?) where rowid_pk in (${u.dead.map(() => \"?\").join(\",\")})`, args: [now, ...u.dead] });\n if (stmts.length) await sqlite.batch(stmts);\n return { inc: u.inc.length, dead: u.dead.length };\n}\n\n// ---------- gone detection (cron/enrich.ts verify step): re-fetch the listing URL and decide whether the ad is still up ----------\n// Pure so scripts/test_local.ts can pin the per-platform signatures. `sure` signals (HTTP 404/410, Craigslist's own removal\n// banners, a forum thread whose title carries the SOLD prefix) kill the row on the first sighting; soft body-text signals need\n// two consecutive sightings (12 h apart) because a template FAQ or a \"recently sold\" sidebar can carry the same words.\nexport interface GoneSignal { reason: string; sure: boolean }\nconst GONE_TITLE_RE = /^\\s*(?:\\[?\$?\\*?sold\\*?\$?\\]?\\b|withdrawn\\b|no longer available\\b)|\$(?:sold|withdrawn)\$|\\bsold\\s*[-|:]\\s*/i;\nconst GONE_BODY_RE = /this (?:listing|ad|vehicle|item|posting|post|lot|car|auction) (?:has been|is|was|is no longer) (?:sold|removed|deleted|expired|closed|withdrawn|no longer (?:available|active|for sale)|not (?:available|active))|(?:listing|ad|item|lot|vehicle) (?:not found|could not be found|does not exist|no longer exists|has been removed|is no longer (?:available|active))|(?:sorry,? )?(?:that|this) (?:page|listing|ad|vehicle) (?:does not exist|could not be found|is no longer available)|the specified thread (?:does not exist|has been removed)/i;\nconst GONE_AUCTION_RE = /\\b(?:auction|bidding) (?:has |is )?(?:closed|ended)\\b|\\blot closed\\b|\\bthis (?:lot|auction) (?:has )?ended\\b/i; // no \"hammer price\": result tables on live lot pages carry it\nexport function goneSignal(url: string, status: number, html: string, finalUrl?: string): GoneSignal | null {\n if (status === 404 || status === 410) return { reason: `http ${status}`, sure: true };\n if (status === 0 || status === 403 || status === 429 || status >= 500) return null; // blocked / down: no verdict\n const host = (url.match(/^https?:\\/\\/(?:www\\.)?([^/]+)/) || [, \"\"])[1].toLowerCase();\n const doc = html.slice(0, 400000).replace(/||/gi, \" \");\n const title = (doc.match(/]*>([\\s\\S]*?)<\\/title>/i) || [, \"\"])[1].replace(/&[a-z#0-9]+;/g, \" \").replace(/\\s+/g, \" \").trim();\n const text = doc.replace(/<[^>]+>/g, \" \").replace(/&[a-z#0-9]+;/g, \" \").replace(/\\s+/g, \" \");\n if (finalUrl) { // a listing URL that lands on the site root / a search page was removed and redirected\n try { const f = new URL(finalUrl), o = new URL(url); if (f.host.replace(/^www\\./, \"\") === o.host.replace(/^www\\./, \"\") && o.pathname.length > 8 && (f.pathname === \"/\" || /\\/(search|inventory|listings|classifieds|for-sale)\\/?$/.test(f.pathname))) return { reason: \"redirected to index\", sure: true }; } catch { /* ignore */ }\n }\n if (/craigslist\\.org$/.test(host)) {\n const m = text.match(/This posting has (?:been deleted by its author|expired|been flagged for removal|been removed)/i);\n if (m) return { reason: m[0].replace(/^This posting has (?:been )?/, \"\").toLowerCase(), sure: true };\n if (!/postingbody|posting-body|attrgroup|postingtitletext/.test(html)) return { reason: \"no posting body\", sure: false }; // an error / interstitial page, not the ad\n return null;\n }\n if (/corvetteforum\\.com|corvetteactioncenter\\.com|digitalcorvettes\\.com$/.test(host)) { // forum threads: the SOLD prefix lives in the title; body text is untrusted (buyers post \"sold?\" all day)\n if (GONE_TITLE_RE.test(title)) return { reason: \"sold (thread title)\", sure: true };\n if (/specified thread does not exist|no thread with that id|thread (?:has been )?(?:deleted|removed)/i.test(text)) return { reason: \"thread removed\", sure: true };\n return null;\n }\n if (/hibid\\.com|carsandbids\\.com|carlisleauctions\\.com|estatesales\\.org|auctionzip\\.com$/.test(host)) { // auctions: auction_date handles most of it (verify step); the page confirms\n if (GONE_TITLE_RE.test(title)) return { reason: \"sold (title)\", sure: true };\n if (/carsandbids\\.com/.test(host) && /\\bSold for \\$[\\d,]+|\\bBid to \\$[\\d,]+|auction (?:has )?ended|This auction has ended/i.test(text)) return { reason: \"auction ended\", sure: true };\n if (GONE_AUCTION_RE.test(text)) return { reason: \"auction ended\", sure: false };\n return null;\n }\n if (GONE_TITLE_RE.test(title)) return { reason: \"sold (title)\", sure: true };\n const m = text.match(GONE_BODY_RE);\n if (m) return { reason: m[0].toLowerCase().slice(0, 60), sure: false };\n return null;\n}\n","createdAt",["D",1789472818436],"branchVersion","branchId","86e98f95-71bb-401c-ac30-44ee51ed36fc","id","00cc23ab-c212-43f5-a7c5-1ba797ecaa18","corvette",["D",1789312547277],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","C4/C5 Corvette search pipeline (CL, forums, auctions, comps)","imageUrl","87445237-7d14-45c7-b3a2-72e031f10ec1","pinnedFileId","2b16e0f0-af8b-11f1-8152-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_101":100,"_109":105},"org",{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",79,"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",{"_44":45,"_32":46,"_39":320,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":321,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":322,"_85":323,"_87":324,"_89":25},"tree",[191,196,201,203,207,208],"files",[191,192,193,194,195,196,197,198,199,200,201,202,203,204,205,206,207,208],"counts",{"_180":64,"_181":145,"_182":64,"_183":184,"_185":186},"contents",[132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":174,"_32":175,"_30":176,"_141":-5,"_42":43,"_41":177,"_143":60,"_39":178,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_27":179},{"_44":168,"_32":169,"_30":170,"_141":-5,"_42":43,"_41":171,"_143":60,"_39":172,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_27":173},{"_44":162,"_32":163,"_30":164,"_141":-5,"_42":43,"_41":165,"_143":60,"_39":166,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_27":167},{"_44":155,"_32":156,"_30":157,"_141":-5,"_42":43,"_41":158,"_143":60,"_39":159,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_27":161},{"_44":149,"_32":150,"_30":151,"_141":-5,"_42":43,"_41":145,"_143":60,"_39":152,"_13":64,"_34":20,"_36":153,"_24":25,"_147":-5,"_27":154},{"_44":138,"_32":139,"_30":140,"_141":-5,"_42":43,"_41":142,"_143":25,"_39":144,"_13":145,"_34":35,"_36":146,"_24":25,"_147":-5,"_27":148},"ea5cb00b-e6e0-426d-a498-8816e3f5a576","probe_gone.ts","194ffcf6-b0fa-11f1-8ccc-1607ee4eb77e","parentId",72,"latest",["D",1789472406655],1,"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { UA } from \"./lib/core.ts\";\nconst r = await sqlite.execute(`select rowid_pk, id, source, url, title, price, status, last_seen, auction_date from listings where status <> 'dead' and source in ('gateway','hibid','jkgalleria','ncrs','ncrs-cats','vettefinders-c4','vetteregistry','classiccars','corvettemag','carlisle-fall-2026','carsandbids-rss') order by source`);\nconst SIG = /deleted by its author|posting has expired|flagged for removal|no longer available|has been sold|listing not found|page not found|thread (does not exist|has been deleted)|is no longer active|listing is closed|auction (has )?ended|lot closed|vehicle (is |has been )?sold|sold-banner|\"sold\"|class=\"[^\"]*sold[^\"]*\"|>\\s*sold\\s*]*>([\\s\\S]*?)<\\/title>/i) || [, \"\"])[1].replace(/\\s+/g, \" \").trim().slice(0, 80);\n const sigs = [...t.matchAll(new RegExp(SIG.source, \"gi\"))].slice(0, 4).map((m) => t.slice(Math.max(0, m.index! - 60), m.index! + 60).replace(/\\s+/g, \" \"));\n out.push(`${row.source} ${row.id} HTTP ${res.status} ${t.length}b final=${res.url !== u ? \"REDIR \" + res.url.slice(0, 70) : \"same\"} title=\"${title}\"\\n sigs=${JSON.stringify(sigs)}`);\n } catch (e) { out.push(`${row.source} ${row.id} ERR ${String(e).slice(0, 60)} ${u.slice(0, 90)}`); }\n}\nconsole.log(out.join(\"\\n\"));\n","label",[139],"00ad9da4-0577-4814-8519-02511a2d4430","README.md","ff70c39e-af85-11f1-9411-1607ee4eb77e",["D",1789312547547],"# corvette\n\nC4 (1994-96) / C5 (1997-2004) Corvette search pipeline for 16105. Forked from logan1/housing. See lib/core.ts.\n",[150],"35cabbb3-b0f6-4c22-a18a-4c6320b0d9b2","lib","16dfa00e-af86-11f1-9559-1607ee4eb77e",2,["D",1789312586746],"directory",[156],"cd673d9b-cac7-4e08-ab58-de2ed36bc4d1","email","a3a2a6f8-afd1-11f1-a05c-1607ee4eb77e",58,["D",1789345035343],[163],"d37d445d-a3e7-4b4d-8e14-d2f34c4797e9","cron","1b0a73f2-af86-11f1-b58b-1607ee4eb77e",4,["D",1789312593913],[169],"b2a361ad-ea6d-43f1-bc22-2eaa212050a7","api","19075df4-af86-11f1-9816-1607ee4eb77e",3,["D",1789312590546],[175],"pulls","branches","forks","envVars",{"_187":189,"_190":64},"connections",{"_187":64,"_188":64},"count","unfilledCount",5,"emptyCount",{"_44":174,"_32":175,"_30":176,"_141":-5,"_42":43,"_41":177,"_143":60,"_39":317,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_210":318,"_27":319},{"_44":309,"_32":310,"_30":311,"_141":176,"_42":43,"_41":312,"_143":60,"_39":313,"_13":158,"_34":290,"_36":314,"_24":25,"_147":-5,"_210":315,"_27":316},{"_44":301,"_32":302,"_30":303,"_141":176,"_42":43,"_41":304,"_143":25,"_39":305,"_13":145,"_34":290,"_36":306,"_24":25,"_147":-5,"_210":307,"_27":308},{"_44":294,"_32":295,"_30":58,"_141":176,"_42":43,"_41":296,"_143":60,"_39":297,"_13":64,"_34":290,"_36":298,"_24":25,"_147":-5,"_210":299,"_27":300},{"_44":285,"_32":286,"_30":287,"_141":176,"_42":43,"_41":288,"_143":25,"_39":289,"_13":158,"_34":290,"_36":291,"_24":25,"_147":-5,"_210":292,"_27":293},{"_44":168,"_32":169,"_30":170,"_141":-5,"_42":43,"_41":171,"_143":60,"_39":282,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_210":283,"_27":284},{"_44":274,"_32":275,"_30":276,"_141":170,"_42":43,"_41":277,"_143":60,"_39":278,"_13":189,"_34":255,"_36":279,"_24":25,"_147":-5,"_210":280,"_27":281},{"_44":266,"_32":267,"_30":268,"_141":170,"_42":43,"_41":269,"_143":25,"_39":270,"_13":158,"_34":255,"_36":271,"_24":25,"_147":-5,"_210":272,"_27":273},{"_44":259,"_32":33,"_30":260,"_141":170,"_42":43,"_41":261,"_143":25,"_39":262,"_13":158,"_34":255,"_36":263,"_24":25,"_147":-5,"_210":264,"_27":265},{"_44":251,"_32":217,"_30":252,"_141":170,"_42":43,"_41":253,"_143":60,"_39":254,"_13":171,"_34":255,"_36":256,"_24":25,"_147":-5,"_210":257,"_27":258},{"_44":162,"_32":163,"_30":164,"_141":-5,"_42":43,"_41":165,"_143":60,"_39":248,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_210":249,"_27":250},{"_44":240,"_32":241,"_30":242,"_141":164,"_42":43,"_41":243,"_143":60,"_39":244,"_13":64,"_34":163,"_36":245,"_24":25,"_147":-5,"_210":246,"_27":247},{"_44":155,"_32":156,"_30":157,"_141":-5,"_42":43,"_41":158,"_143":60,"_39":237,"_13":64,"_34":160,"_36":-5,"_24":25,"_147":-5,"_210":238,"_27":239},{"_44":229,"_32":230,"_30":231,"_141":157,"_42":43,"_41":232,"_143":60,"_39":233,"_13":189,"_34":35,"_36":234,"_24":25,"_147":-5,"_210":235,"_27":236},{"_44":225,"_32":33,"_30":31,"_141":157,"_42":43,"_41":14,"_143":60,"_39":226,"_13":158,"_34":35,"_36":38,"_24":25,"_147":-5,"_210":227,"_27":228},{"_44":216,"_32":217,"_30":218,"_141":157,"_42":43,"_41":219,"_143":60,"_39":220,"_13":221,"_34":35,"_36":222,"_24":25,"_147":-5,"_210":223,"_27":224},{"_44":149,"_32":150,"_30":151,"_141":-5,"_42":43,"_41":145,"_143":60,"_39":213,"_13":64,"_34":20,"_36":153,"_24":25,"_147":-5,"_210":214,"_27":215},{"_44":138,"_32":139,"_30":140,"_141":-5,"_42":43,"_41":142,"_143":25,"_39":209,"_13":145,"_34":35,"_36":146,"_24":25,"_147":-5,"_210":211,"_27":212},["D",1789472406655],"children",[],[139],["D",1789312547547],[],[150],"6ee78f10-cbd9-4ac8-b0e0-b14c1c7f3465","sources.ts","30edcbe2-af86-11f1-9d05-1607ee4eb77e",68,["D",1789422556949],15,"// 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",[],[175,286],"cd618113-b94e-4d68-bdbc-3d77cca4c359","feed.ts",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",[],[175,295],"407cecd5-8016-4e87-adf9-d4f6425e6886","admin.ts","411cebc4-af8b-11f1-871a-1607ee4eb77e",23,["D",1789315209731],"// corvette-admin: token-checked maintenance endpoint for validation and manual runs.\r\n// GET ?job=craigslist | sources | enrich | digest run a job now (digest sends immediately)\r\n// ?job=sources&only= ?job=sources&force=1 one source / ignore the `every` interval\r\n// ?job=enrich[&force=1][&step=queue|decode|recalls|geocode|price]\r\n// ?job=rescore recompute score/flags for every active row (after a rule change)\r\n// GET ?sql=select ... read-only query (SELECT only)\r\n// GET ?testpush=1 send a full test Discord embed\r\n// GET ?pushpending=1 push every active score>=threshold row never alerted (webhook was down)\r\n// POST { id, status } set a listing's status (new|contacted|ppi|offer|dead)\r\n// POST { delete: { id? | rowid? | source? | url_like? | before? } }\r\n// POST { comps: [...] } load auction comps pulled locally (scripts/pull_comps.ts)\r\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\r\nimport { ensureSchema, checkToken, json, CORS, STATUS, pushDiscord, actionLinks, rowToPush, pushThresholdFor, score, flagsFor, decorateNotes, ageDays, conditionPoints, genFor } from \"../lib/core.ts\";\r\nimport craigslist from \"../cron/craigslist.ts\";\r\nimport sources from \"../cron/sources.ts\";\r\nimport enrich from \"../cron/enrich.ts\";\r\nimport { sendDigest } from \"../cron/digest.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 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 k.source && k.external_id && k.url);\r\n let inserted = 0;\r\n for (const k of rows) {\r\n const ex = await sqlite.execute({ sql: `select 1 from comps where source=? and external_id=?`, args: [String(k.source), String(k.external_id)] });\r\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'))\r\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`,\r\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] });\r\n if (!ex.rows.length) inserted++;\r\n }\r\n const n = await sqlite.execute(`select source, count(*) n from comps group by source`);\r\n return json({ ok: true, received: rows.length, inserted, totals: n.rows });\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 === \"sources\") return json(await sources({ only: url.searchParams.get(\"only\") || undefined, force: !!url.searchParams.get(\"force\") }));\r\n if (job === \"enrich\") return json(await enrich({ force: !!url.searchParams.get(\"force\"), step: url.searchParams.get(\"step\") || undefined }));\r\n if (job === \"digest\") return json(await sendDigest(true));\r\n if (job === \"rescore\") {\r\n const rows = await sqlite.execute(`select * from listings where last_seen >= date('now','-60 day')`);\r\n let changed = 0;\r\n for (const r of rows.rows as any[]) {\r\n const text = [r.raw, r.notes].filter(Boolean).join(\" \");\r\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) });\r\n const keep = String(r.flags || \"\").split(\"|\").filter((f: string) => /^(DEAD |VIN MISMATCH|PRICE ANOMALY|DROP |MOTIVATED)/.test(f));\r\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) })];\r\n const flags = [...new Set(fl)].join(\"|\");\r\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++; }\r\n }\r\n return json({ rows: rows.rows.length, changed });\r\n }\r\n\r\n if (url.searchParams.get(\"pushpending\")) {\r\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`);\r\n const out: any[] = [];\r\n for (const row of r.rows as any[]) {\r\n if (Number(row.score) < pushThresholdFor(row.dist == null ? null : Number(row.dist), row.seller)) continue;\r\n const ok = await pushDiscord(rowToPush(row));\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 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,\r\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 };\r\n const ok = await pushDiscord(l);\r\n return json({ pushed: ok, links: actionLinks(l) });\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|sources[&only=key][&force=1]|enrich[&step=..]|digest|rescore ?sql=select... ?testpush=1 ?pushpending=1 POST {id,status} POST {delete:{...}}\" });\r\n}\r\n",[],[175,302],"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",[],[175,310],["D",1789312590546],[192,193,194,195],[175],["D",1789312547277],["D",1789486866837],{"_101":100,"_109":105},{"_101":100,"_102":103,"_104":105,"_18":56,"_106":107,"_108":25},{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"ctx",{"_83":-5,"_129":358,"_359":360,"_361":362,"_363":25,"_364":25,"_365":25,"_366":60,"_367":-5,"_368":-7,"_369":-7,"_370":64,"_371":25,"_372":25,"_373":-5,"_374":25,"_375":25,"_376":25,"_377":-5},"ENV",{"_329":330,"_331":332,"_333":91,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349,"_350":351,"_352":353,"_354":355,"_356":357},"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 · v73