[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_242":243,"_244":245},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",7,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","store.ts","latestPath","fileId","2b090e9e-b256-11f1-ad06-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { cities, hash, match, validateEvent, type EventData } from \"./core.ts\";\nexport interface Statement { sql: string; args?: (string | number | null)[]; }\nexport interface Result { rows: Record[]; rowsAffected: number; }\nexport interface Database { execute(q: Statement | string): Promise; batch(q: Statement[], mode?: \"write\" | \"read\" | \"deferred\"): Promise; }\nexport const database = sqlite as unknown as Database;\nexport function createStore(db: Database, prefix = \"ccn_\") {\n if (!/^ccn_(?:test_[a-f0-9]+_)?$/.test(prefix)) throw new Error(\"Invalid storage namespace\");\n const sql = (text: string) => text.replaceAll(\"ccn_\", prefix);\n const q = (text: string, args: (string | number | null)[] = []) => db.execute({ sql: sql(text), args });\n const batch = (items: Statement[]) => db.batch(items.map((x) => ({ ...x, sql: sql(x.sql) })), \"write\");\n let ready: Promise | undefined;\n async function init(): Promise {\n if (ready) return ready;\n ready = (async () => {\n const schemas = [\n \"CREATE TABLE IF NOT EXISTS ccn_migrations (version INTEGER PRIMARY KEY, applied_at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_events (id TEXT PRIMARY KEY, city TEXT NOT NULL, source TEXT NOT NULL, json TEXT NOT NULL, hash TEXT NOT NULL, translation TEXT, translation_hash TEXT, review TEXT NOT NULL DEFAULT 'draft', approved_hash TEXT, duplicate_of TEXT, first_seen INTEGER NOT NULL, last_seen INTEGER NOT NULL, verified INTEGER NOT NULL, fixture INTEGER NOT NULL DEFAULT 0)\",\n \"CREATE INDEX IF NOT EXISTS ccn_events_city ON ccn_events(city, review)\",\n \"CREATE TABLE IF NOT EXISTS ccn_records (key TEXT PRIMARY KEY, event_id TEXT NOT NULL, source TEXT NOT NULL, city TEXT NOT NULL, url TEXT NOT NULL, json TEXT NOT NULL, hash TEXT NOT NULL, first_seen INTEGER NOT NULL, last_seen INTEGER NOT NULL, verified INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_duplicates (id TEXT PRIMARY KEY, left_id TEXT NOT NULL, right_id TEXT NOT NULL, state TEXT NOT NULL, reason TEXT NOT NULL, created INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_editorial (id TEXT PRIMARY KEY, event_id TEXT, action TEXT NOT NULL, note TEXT NOT NULL, seconds INTEGER NOT NULL DEFAULT 0, at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_publications (key TEXT PRIMARY KEY, city TEXT NOT NULL, mode TEXT NOT NULL, destination TEXT NOT NULL, text TEXT NOT NULL, state TEXT NOT NULL, attempts INTEGER NOT NULL DEFAULT 0, retry_at INTEGER NOT NULL DEFAULT 0, claimed_at INTEGER, claim_token TEXT, message_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, needs_correction INTEGER NOT NULL DEFAULT 0, reason TEXT)\",\n \"CREATE TABLE IF NOT EXISTS ccn_publication_items (publication_key TEXT NOT NULL, event_id TEXT NOT NULL, hash TEXT NOT NULL, PRIMARY KEY (publication_key, event_id))\",\n \"CREATE TABLE IF NOT EXISTS ccn_sources (id TEXT PRIMARY KEY, permission TEXT NOT NULL DEFAULT 'pending', poll_allowed INTEGER NOT NULL DEFAULT 0, checked INTEGER, next_due INTEGER NOT NULL DEFAULT 0, count INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'unverified', error TEXT, basis TEXT NOT NULL DEFAULT '')\",\n \"CREATE TABLE IF NOT EXISTS ccn_cache (url TEXT PRIMARY KEY, body TEXT NOT NULL, etag TEXT, expires INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_translations (key TEXT PRIMARY KEY, status TEXT NOT NULL, json TEXT, provider TEXT NOT NULL, tokens INTEGER NOT NULL DEFAULT 0, error TEXT, created INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_usage (day TEXT PRIMARY KEY, requests INTEGER NOT NULL DEFAULT 0, tokens INTEGER NOT NULL DEFAULT 0)\",\n \"CREATE TABLE IF NOT EXISTS ccn_settings (key TEXT PRIMARY KEY, value TEXT NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_runs (id TEXT PRIMARY KEY, kind TEXT NOT NULL, city TEXT, status TEXT NOT NULL, summary TEXT NOT NULL, at INTEGER NOT NULL, duration INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_leases (name TEXT PRIMARY KEY, owner TEXT NOT NULL, until_at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_submissions (id TEXT PRIMARY KEY, kind TEXT NOT NULL, json TEXT NOT NULL, contact TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'pending', at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_clicks (day TEXT NOT NULL, campaign TEXT NOT NULL, kind TEXT NOT NULL, target TEXT NOT NULL, count INTEGER NOT NULL, PRIMARY KEY(day,campaign,kind,target))\",\n \"CREATE TABLE IF NOT EXISTS ccn_subscribers (day TEXT NOT NULL, city TEXT NOT NULL, total INTEGER, status TEXT NOT NULL, PRIMARY KEY(day,city))\",\n \"CREATE TABLE IF NOT EXISTS ccn_rates (key TEXT PRIMARY KEY, count INTEGER NOT NULL, expires INTEGER NOT NULL)\",\n ];\n await batch(schemas.map((text) => ({ sql: text })));\n await q(\"INSERT OR IGNORE INTO ccn_migrations VALUES (1, ?)\", [Date.now()]);\n for (const [key, value] of [[\"kill\", \"1\"], [\"translation_daily_cap\", \"12\"], ...Object.keys(cities).flatMap((city) => [[`${city}:paused`, \"1\"], [`${city}:enabled`, \"0\"], [`${city}:dryRun`, \"1\"]])]) await q(\"INSERT OR IGNORE INTO ccn_settings VALUES (?, ?)\", [key, value]);\n })().catch((e) => { ready = undefined; throw e; });\n return ready;\n }\n async function setting(key: string, fallback = \"\"): Promise { await init(); const r = await q(\"SELECT value FROM ccn_settings WHERE key=?\", [key]); return r.rows.length ? String(r.rows[0].value) : fallback; }\n async function set(key: string, value: string): Promise { await init(); await q(\"INSERT INTO ccn_settings VALUES (?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value\", [key, value]); }\n async function flags(city: string) { return { kill: (await setting(\"kill\", \"1\")) !== \"0\", paused: (await setting(`${city}:paused`, \"1\")) !== \"0\", enabled: (await setting(`${city}:enabled`, \"0\")) === \"1\", dryRun: (await setting(`${city}:dryRun`, \"1\")) !== \"0\" }; }\n async function lease(name: string, ttl = 90000): Promise {\n await init(); const owner = crypto.randomUUID(), now = Date.now();\n const r = await q(\"INSERT INTO ccn_leases VALUES (?,?,?) ON CONFLICT(name) DO UPDATE SET owner=excluded.owner, until_at=excluded.until_at WHERE ccn_leases.until_at {\n await batch([\n { sql: \"UPDATE ccn_events SET review='draft', approved_hash=NULL, translation=NULL, translation_hash=NULL WHERE id=?\", args: [id] },\n { sql: \"UPDATE ccn_publications SET needs_correction=1, reason=? WHERE key IN (SELECT publication_key FROM ccn_publication_items WHERE event_id=?) AND state IN ('sent','sending','delivery_unknown')\", args: [reason, id] },\n { sql: \"UPDATE ccn_publications SET state='invalidated', reason=? WHERE key IN (SELECT publication_key FROM ccn_publication_items WHERE event_id=?) AND state IN ('pending','retry')\", args: [reason, id] },\n ]);\n }\n async function ingest(events: EventData[]): Promise<{ inserted: number; unchanged: number; changed: number; duplicates: number; review: number }> {\n await init(); const stats = { inserted: 0, unchanged: 0, changed: 0, duplicates: 0, review: 0 };\n for (const raw of events.slice(0, 40)) {\n validateEvent(raw); const now = Date.now(); const key = await hash(`${raw.city}|${raw.source}|${raw.sourceItemId}|${raw.date}|${raw.start}`); const event = { ...raw, id: key }; const text = JSON.stringify(event); const digest = await hash(text);\n const old = (await q(\"SELECT * FROM ccn_records WHERE key=?\", [key])).rows[0];\n if (old) {\n await q(\"UPDATE ccn_records SET last_seen=?, verified=? WHERE key=?\", [now, now, key]);\n if (old.hash === digest) { await q(\"UPDATE ccn_events SET last_seen=?, verified=? WHERE id=?\", [now, now, String(old.event_id)]); stats.unchanged++; continue; }\n const canonical = String(old.event_id);\n await invalidate(canonical, \"Source details changed; check affected Telegram messages\");\n await q(\"UPDATE ccn_records SET json=?,hash=?,last_seen=?,verified=? WHERE key=?\", [text, digest, now, now, key]);\n if (canonical === key) await q(\"UPDATE ccn_events SET json=?,hash=?,last_seen=?,verified=? WHERE id=?\", [text, digest, now, now, canonical]);\n stats.changed++; continue;\n }\n const existing = await q(\"SELECT id,json FROM ccn_events WHERE city=? AND duplicate_of IS NULL AND fixture=0 LIMIT 1001\", [event.city]);\n if (existing.rows.length > 1000) throw new Error(\"Manual archival required: matching set exceeds safety limit\");\n let canonical = key; const uncertain: string[] = [];\n for (const row of existing.rows) { const decision = match(event, JSON.parse(String(row.json)) as EventData); if (decision === \"same\") { canonical = String(row.id); break; } if (decision === \"review\") uncertain.push(String(row.id)); }\n const statements: Statement[] = [{ sql: \"INSERT INTO ccn_records VALUES (?,?,?,?,?,?,?,?,?,?,?)\", args: [key, canonical, event.source, event.city, event.url, text, digest, now, now, now] }];\n if (canonical === key) statements.push({ sql: \"INSERT INTO ccn_events (id,city,source,json,hash,review,first_seen,last_seen,verified) VALUES (?,?,?,?,?,?,?,?,?)\", args: [key, event.city, event.source, text, digest, uncertain.length ? \"duplicate_review\" : \"draft\", now, now, now] });\n for (const other of uncertain) if (canonical === key) statements.push({ sql: \"INSERT OR IGNORE INTO ccn_duplicates VALUES (?,?,?,?,?,?)\", args: [[key, other].sort().join(\":\"), key, other, \"pending\", \"Similar title or same venue/time; human review required\", now] });\n await batch(statements);\n if (canonical !== key) { stats.duplicates++; await invalidate(canonical, \"New source provenance added; verify conflicting metadata\"); } else { stats.inserted++; if (uncertain.length) stats.review++; }\n }\n return stats;\n }\n async function audit(eventId: string | null, action: string, note = \"\", seconds = 0) { await q(\"INSERT INTO ccn_editorial VALUES (?,?,?,?,?,?)\", [crypto.randomUUID(), eventId, action, note.slice(0, 1000), Math.min(3600, Math.max(0, seconds)), Date.now()]); }\n async function budget(cap: number, day = new Date().toISOString().slice(0, 10)): Promise {\n if (!Number.isFinite(cap) || cap < 1) return false;\n const r = await q(\"INSERT INTO ccn_usage(day,requests,tokens) VALUES (?,1,0) ON CONFLICT(day) DO UPDATE SET requests=ccn_usage.requests+1 WHERE ccn_usage.requests 0;\n }\n async function rate(key: string, limit: number, ttl: number): Promise {\n const now = Date.now(); const r = await q(\"INSERT INTO ccn_rates VALUES (?,1,?) ON CONFLICT(key) DO UPDATE SET count=CASE WHEN ccn_rates.expires 0;\n }\n async function claim(key: string): Promise | null> {\n const now = Date.now(), token = crypto.randomUUID();\n const r = await q(\"UPDATE ccn_publications SET state='sending',attempts=attempts+1,claimed_at=?,claim_token=? WHERE key=? AND state IN ('pending','retry') AND retry_at<=? AND expires>? AND attempts<3 RETURNING *\", [now, token, key, now, now]); return r.rows[0] || null;\n }\n async function recover(): Promise {\n const now = Date.now();\n await q(\"UPDATE ccn_publications SET state='delivery_unknown', reason='Worker ended during send; reconcile manually' WHERE state='sending' AND claimed_at;\n","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { cities, hash, match, validateEvent, type EventData } from \"./core.ts\";\nexport interface Statement { sql: string; args?: (string | number | null)[]; }\nexport interface Result { rows: Record[]; rowsAffected: number; }\nexport interface Database { execute(q: Statement | string): Promise; batch(q: Statement[], mode?: \"write\" | \"read\" | \"deferred\"): Promise; }\nexport const database = sqlite as unknown as Database;\nexport function createStore(db: Database, prefix = \"ccn_\") {\n if (!/^ccn_(?:test_[a-f0-9]+_)?$/.test(prefix)) throw new Error(\"Invalid storage namespace\");\n const sql = (text: string) => text.replaceAll(\"ccn_\", prefix);\n const q = (text: string, args: (string | number | null)[] = []) => db.execute({ sql: sql(text), args });\n const batch = (items: Statement[]) => db.batch(items.map((x) => ({ ...x, sql: sql(x.sql) })), \"write\");\n let ready: Promise | undefined;\n async function init(): Promise {\n if (ready) return ready;\n ready = (async () => {\n const schemas = [\n \"CREATE TABLE IF NOT EXISTS ccn_migrations (version INTEGER PRIMARY KEY, applied_at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_events (id TEXT PRIMARY KEY, city TEXT NOT NULL, source TEXT NOT NULL, json TEXT NOT NULL, hash TEXT NOT NULL, translation TEXT, translation_hash TEXT, review TEXT NOT NULL DEFAULT 'draft', approved_hash TEXT, duplicate_of TEXT, first_seen INTEGER NOT NULL, last_seen INTEGER NOT NULL, verified INTEGER NOT NULL, fixture INTEGER NOT NULL DEFAULT 0)\",\n \"CREATE INDEX IF NOT EXISTS ccn_events_city ON ccn_events(city, review)\",\n \"CREATE TABLE IF NOT EXISTS ccn_records (key TEXT PRIMARY KEY, event_id TEXT NOT NULL, source TEXT NOT NULL, city TEXT NOT NULL, url TEXT NOT NULL, json TEXT NOT NULL, hash TEXT NOT NULL, first_seen INTEGER NOT NULL, last_seen INTEGER NOT NULL, verified INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_duplicates (id TEXT PRIMARY KEY, left_id TEXT NOT NULL, right_id TEXT NOT NULL, state TEXT NOT NULL, reason TEXT NOT NULL, created INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_editorial (id TEXT PRIMARY KEY, event_id TEXT, action TEXT NOT NULL, note TEXT NOT NULL, seconds INTEGER NOT NULL DEFAULT 0, at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_publications (key TEXT PRIMARY KEY, city TEXT NOT NULL, mode TEXT NOT NULL, destination TEXT NOT NULL, text TEXT NOT NULL, state TEXT NOT NULL, attempts INTEGER NOT NULL DEFAULT 0, retry_at INTEGER NOT NULL DEFAULT 0, claimed_at INTEGER, claim_token TEXT, message_id TEXT, created INTEGER NOT NULL, expires INTEGER NOT NULL, needs_correction INTEGER NOT NULL DEFAULT 0, reason TEXT)\",\n \"CREATE TABLE IF NOT EXISTS ccn_publication_items (publication_key TEXT NOT NULL, event_id TEXT NOT NULL, hash TEXT NOT NULL, PRIMARY KEY (publication_key, event_id))\",\n \"CREATE TABLE IF NOT EXISTS ccn_sources (id TEXT PRIMARY KEY, permission TEXT NOT NULL DEFAULT 'pending', poll_allowed INTEGER NOT NULL DEFAULT 0, checked INTEGER, next_due INTEGER NOT NULL DEFAULT 0, count INTEGER NOT NULL DEFAULT 0, status TEXT NOT NULL DEFAULT 'unverified', error TEXT, basis TEXT NOT NULL DEFAULT '')\",\n \"CREATE TABLE IF NOT EXISTS ccn_cache (url TEXT PRIMARY KEY, body TEXT NOT NULL, etag TEXT, expires INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_translations (key TEXT PRIMARY KEY, status TEXT NOT NULL, json TEXT, provider TEXT NOT NULL, tokens INTEGER NOT NULL DEFAULT 0, error TEXT, created INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_usage (day TEXT PRIMARY KEY, requests INTEGER NOT NULL DEFAULT 0, tokens INTEGER NOT NULL DEFAULT 0)\",\n \"CREATE TABLE IF NOT EXISTS ccn_settings (key TEXT PRIMARY KEY, value TEXT NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_runs (id TEXT PRIMARY KEY, kind TEXT NOT NULL, city TEXT, status TEXT NOT NULL, summary TEXT NOT NULL, at INTEGER NOT NULL, duration INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_leases (name TEXT PRIMARY KEY, owner TEXT NOT NULL, until_at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_submissions (id TEXT PRIMARY KEY, kind TEXT NOT NULL, json TEXT NOT NULL, contact TEXT NOT NULL, status TEXT NOT NULL DEFAULT 'pending', at INTEGER NOT NULL)\",\n \"CREATE TABLE IF NOT EXISTS ccn_clicks (day TEXT NOT NULL, campaign TEXT NOT NULL, kind TEXT NOT NULL, target TEXT NOT NULL, count INTEGER NOT NULL, PRIMARY KEY(day,campaign,kind,target))\",\n \"CREATE TABLE IF NOT EXISTS ccn_subscribers (day TEXT NOT NULL, city TEXT NOT NULL, total INTEGER, status TEXT NOT NULL, PRIMARY KEY(day,city))\",\n \"CREATE TABLE IF NOT EXISTS ccn_rates (key TEXT PRIMARY KEY, count INTEGER NOT NULL, expires INTEGER NOT NULL)\",\n ];\n await batch(schemas.map((text) => ({ sql: text })));\n await q(\"INSERT OR IGNORE INTO ccn_migrations VALUES (1, ?)\", [Date.now()]);\n for (const [key, value] of [[\"kill\", \"1\"], [\"translation_daily_cap\", \"12\"], ...Object.keys(cities).flatMap((city) => [[`${city}:paused`, \"1\"], [`${city}:enabled`, \"0\"], [`${city}:dryRun`, \"1\"]])]) await q(\"INSERT OR IGNORE INTO ccn_settings VALUES (?, ?)\", [key, value]);\n })().catch((e) => { ready = undefined; throw e; });\n return ready;\n }\n async function setting(key: string, fallback = \"\"): Promise { await init(); const r = await q(\"SELECT value FROM ccn_settings WHERE key=?\", [key]); return r.rows.length ? String(r.rows[0].value) : fallback; }\n async function set(key: string, value: string): Promise { await init(); await q(\"INSERT INTO ccn_settings VALUES (?,?) ON CONFLICT(key) DO UPDATE SET value=excluded.value\", [key, value]); }\n async function flags(city: string) { return { kill: (await setting(\"kill\", \"1\")) !== \"0\", paused: (await setting(`${city}:paused`, \"1\")) !== \"0\", enabled: (await setting(`${city}:enabled`, \"0\")) === \"1\", dryRun: (await setting(`${city}:dryRun`, \"1\")) !== \"0\" }; }\n async function lease(name: string, ttl = 90000): Promise {\n await init(); const owner = crypto.randomUUID(), now = Date.now();\n const r = await q(\"INSERT INTO ccn_leases VALUES (?,?,?) ON CONFLICT(name) DO UPDATE SET owner=excluded.owner, until_at=excluded.until_at WHERE ccn_leases.until_at {\n await batch([\n { sql: \"UPDATE ccn_events SET review='draft', approved_hash=NULL, translation=NULL, translation_hash=NULL WHERE id=?\", args: [id] },\n { sql: \"UPDATE ccn_publications SET needs_correction=1, reason=? WHERE key IN (SELECT publication_key FROM ccn_publication_items WHERE event_id=?) AND state IN ('sent','sending','delivery_unknown')\", args: [reason, id] },\n { sql: \"UPDATE ccn_publications SET state='invalidated', reason=? WHERE key IN (SELECT publication_key FROM ccn_publication_items WHERE event_id=?) AND state IN ('pending','retry')\", args: [reason, id] },\n ]);\n }\n async function ingest(events: EventData[]): Promise<{ inserted: number; unchanged: number; changed: number; duplicates: number; review: number }> {\n await init(); const stats = { inserted: 0, unchanged: 0, changed: 0, duplicates: 0, review: 0 };\n for (const raw of events.slice(0, 40)) {\n validateEvent(raw); const now = Date.now(); const key = await hash(`${raw.city}|${raw.source}|${raw.sourceItemId}|${raw.date}|${raw.start}`); const event = { ...raw, id: key }; const text = JSON.stringify(event); const digest = await hash(text);\n const old = (await q(\"SELECT * FROM ccn_records WHERE key=?\", [key])).rows[0];\n if (old) {\n await q(\"UPDATE ccn_records SET last_seen=?, verified=? WHERE key=?\", [now, now, key]);\n if (old.hash === digest) { await q(\"UPDATE ccn_events SET last_seen=?, verified=? WHERE id=?\", [now, now, String(old.event_id)]); stats.unchanged++; continue; }\n const canonical = String(old.event_id);\n await invalidate(canonical, \"Source details changed; check affected Telegram messages\");\n await q(\"UPDATE ccn_records SET json=?,hash=?,last_seen=?,verified=? WHERE key=?\", [text, digest, now, now, key]);\n if (canonical === key) await q(\"UPDATE ccn_events SET json=?,hash=?,last_seen=?,verified=? WHERE id=?\", [text, digest, now, now, canonical]);\n stats.changed++; continue;\n }\n const existing = await q(\"SELECT id,json FROM ccn_events WHERE city=? AND duplicate_of IS NULL AND fixture=0 LIMIT 1001\", [event.city]);\n if (existing.rows.length > 1000) throw new Error(\"Manual archival required: matching set exceeds safety limit\");\n let canonical = key; const uncertain: string[] = [];\n for (const row of existing.rows) { const decision = match(event, JSON.parse(String(row.json)) as EventData); if (decision === \"same\") { canonical = String(row.id); break; } if (decision === \"review\") uncertain.push(String(row.id)); }\n const statements: Statement[] = [{ sql: \"INSERT INTO ccn_records VALUES (?,?,?,?,?,?,?,?,?,?)\", args: [key, canonical, event.source, event.city, event.url, text, digest, now, now, now] }];\n if (canonical === key) statements.push({ sql: \"INSERT INTO ccn_events (id,city,source,json,hash,review,first_seen,last_seen,verified) VALUES (?,?,?,?,?,?,?,?,?)\", args: [key, event.city, event.source, text, digest, uncertain.length ? \"duplicate_review\" : \"draft\", now, now, now] });\n for (const other of uncertain) if (canonical === key) statements.push({ sql: \"INSERT OR IGNORE INTO ccn_duplicates VALUES (?,?,?,?,?,?)\", args: [[key, other].sort().join(\":\"), key, other, \"pending\", \"Similar title or same venue/time; human review required\", now] });\n await batch(statements);\n if (canonical !== key) { stats.duplicates++; await invalidate(canonical, \"New source provenance added; verify conflicting metadata\"); } else { stats.inserted++; if (uncertain.length) stats.review++; }\n }\n return stats;\n }\n async function audit(eventId: string | null, action: string, note = \"\", seconds = 0) { await q(\"INSERT INTO ccn_editorial VALUES (?,?,?,?,?,?)\", [crypto.randomUUID(), eventId, action, note.slice(0, 1000), Math.min(3600, Math.max(0, seconds)), Date.now()]); }\n async function budget(cap: number, day = new Date().toISOString().slice(0, 10)): Promise {\n if (!Number.isFinite(cap) || cap < 1) return false;\n const r = await q(\"INSERT INTO ccn_usage(day,requests,tokens) VALUES (?,1,0) ON CONFLICT(day) DO UPDATE SET requests=ccn_usage.requests+1 WHERE ccn_usage.requests 0;\n }\n async function rate(key: string, limit: number, ttl: number): Promise {\n const now = Date.now(); const r = await q(\"INSERT INTO ccn_rates VALUES (?,1,?) ON CONFLICT(key) DO UPDATE SET count=CASE WHEN ccn_rates.expires 0;\n }\n async function claim(key: string): Promise | null> {\n const now = Date.now(), token = crypto.randomUUID();\n const r = await q(\"UPDATE ccn_publications SET state='sending',attempts=attempts+1,claimed_at=?,claim_token=? WHERE key=? AND state IN ('pending','retry') AND retry_at<=? AND expires>? AND attempts<3 RETURNING *\", [now, token, key, now, now]); return r.rows[0] || null;\n }\n async function recover(): Promise {\n const now = Date.now();\n await q(\"UPDATE ccn_publications SET state='delivery_unknown', reason='Worker ended during send; reconcile manually' WHERE state='sending' AND claimed_at;\n","createdAt",["D",1789621867508],"branchVersion","branchId","6de82370-98e9-41cd-add4-480bf35c921b","id","47a79ebc-05ee-454e-983d-7f48a62bccc0","telegram-city-network",["D",1789621418009],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","City events: Shymkent review pilot, isolated from live Almaty","imageUrl","f5be24e4-c798-4816-91e5-037b60b986f5","pinnedFileId","01a0adbf-b85c-735b-b5fd-9913cdd6d31f","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","7f67379d-2d38-49bd-81ac-2c7f92a739e2","tursoName","47a79ebc05ee454e983d7f48a62bccc0","tursoHostname","47a79ebc05ee454e983d7f48a62bccc0-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789710048837],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"isOwned",59,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","omriluz","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18ycWxkOWxiOE00SkVtZENmRWM4YWxLWTRVUFMifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":237,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":238,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":239,"_84":240,"_86":241,"_88":25},"tree",[192,195,196,197,198,199,200],"files",[192,193,194,195,196,197,198,199,200],"counts",{"_182":63,"_183":147,"_184":63,"_185":186,"_187":188},"contents",[130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":177,"_32":50,"_30":178,"_138":-5,"_41":42,"_40":141,"_139":59,"_38":179,"_13":63,"_33":180,"_35":-5,"_24":25,"_142":-5,"_27":181},{"_43":171,"_32":172,"_30":173,"_138":-5,"_41":42,"_40":141,"_139":25,"_38":174,"_13":63,"_33":20,"_35":175,"_24":25,"_142":-5,"_27":176},{"_43":164,"_32":165,"_30":166,"_138":-5,"_41":42,"_40":167,"_139":25,"_38":168,"_13":63,"_33":34,"_35":169,"_24":25,"_142":-5,"_27":170},{"_43":158,"_32":159,"_30":57,"_138":-5,"_41":42,"_40":141,"_139":25,"_38":160,"_13":63,"_33":161,"_35":162,"_24":25,"_142":-5,"_27":163},{"_43":151,"_32":152,"_30":153,"_138":-5,"_41":42,"_40":154,"_139":25,"_38":155,"_13":141,"_33":34,"_35":156,"_24":25,"_142":-5,"_27":157},{"_43":144,"_32":145,"_30":146,"_138":-5,"_41":42,"_40":147,"_139":59,"_38":148,"_13":63,"_33":34,"_35":149,"_24":25,"_142":-5,"_27":150},{"_43":137,"_32":28,"_30":31,"_138":-5,"_41":42,"_40":14,"_139":25,"_38":140,"_13":141,"_33":34,"_35":37,"_24":25,"_142":-5,"_27":143},"618bce1e-311d-41f6-a36c-52f59d0cc26c","parentId","latest",["D",1789621867508],1,"label",[28],"3239a98d-091e-4c53-909b-8c1e34bcc928","source_probe.ts","5ad50dc2-b255-11f1-9d96-1607ee4eb77e",4,["D",1789621509077],"import {load} from 'npm:cheerio@1.0.0';\nimport robotsParser from 'npm:robots-parser@3.0.1';\nconst targets=['https://sxodim.com/shymkent','https://topbilet.kz/en/afisha','https://shanintheatre.kz/','https://foodfair.kz/','https://ticketon.kz/shymkent'];\nasync function request(url:string){const r=await fetch(url,{signal:AbortSignal.timeout(7000),redirect:'manual',headers:{'User-Agent':'CityEventsReview/0.1','Accept':'text/html,text/plain'}});if(!r.ok){await r.body?.cancel();return {status:r.status,text:'',location:r.headers.get('location')}}const text=await r.text();if(text.length>2000000)throw Error('response too large');return {status:r.status,text,location:null};}\nfor(const url of targets){try{const origin=new URL(url).origin;const robots=await request(origin+'/robots.txt');if(![200,404,410].includes(robots.status)){console.log(JSON.stringify({url,blocked:'robots HTTP '+robots.status,location:robots.location}));continue;}if(robots.status===200&&(/^\\s*({text:$(e).text().trim().replace(/\\s+/g,' ').slice(0,120),href:$(e).attr('href')})).get();console.log(JSON.stringify({url,status:page.status,location:page.location,robots:robots.text.slice(0,2500),title:$('title').text(),ld:$('script[type=\"application/ld+json\"]').map((_,e)=>$(e).text().slice(0,5000)).get().slice(0,2),events:links.filter(x=>/event\\/|impression|афиш|afisha|репертуар|policy|agreement|terms|правил/i.test(x.href+' '+x.text)).slice(0,12),footer:$('footer').text().trim().replace(/\\s+/g,' ').slice(0,2200),mainText:($('main').text()||$('body').text()).trim().replace(/\\s+/g,' ').slice(0,1800)}));}catch(e){console.log(JSON.stringify({url,error:e instanceof Error?e.message:'probe failed'}));}}\nexport {};",[145],"98f10aef-c284-43c2-b5b1-6f2e9a8ea8e9","inspect.ts","36d1778a-b255-11f1-97e1-1607ee4eb77e",3,["D",1789621469673],"const names=['github','GITHUB_TOKEN','GH_TOKEN','TELEGRAM_BOT_TOKEN','VAL_TOWN_API_KEY'];console.log(JSON.stringify({runtime:Deno.version,bindings:Object.fromEntries(names.map(k=>[k,!!Deno.env.get(k)]))}));export {};",[152],"c5027077-df61-454c-a8dd-c4b246889ef4","index.tsx",["D",1789621418009],"http","/** @jsxImportSource npm:hono@4/jsx */\nimport { Hono } from \"npm:hono@4\";\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// In-memory state. Resets whenever the server restarts.\n// For persistence across restarts, use std/sqlite or std/blob.\nlet count = 0;\n\nconst Layout = ({ title, children }: { title: string; children: any }) => (\n \n \n {title}\n \n \n \n \n \n \n \n {children}\n \n \n);\n\nconst app = new Hono();\n\napp.get(\"/\", (c) =>\n c.html(\n \n

Hello from Hono JSX

\n A minimal Val Town starter.{\" \"}\n \n Remix this val.\n \n

\n Server count:{\" \"}\n {count}\n

\n \n Increment\n \n

\n Lives in memory on the server. Resets when the val restarts.\n

\n \n ,\n ));\n\napp.get(\"/about\", (c) =>\n c.html(\n \n

About

Server-rendered with Hono JSX on Val Town.

\n ,\n ));\n\n// API routes\napp.post(\"/api/increment\", (c) => c.json({ count: ++count }));\n\n// Serve static files\napp.get(\"/public/*\", (c) => serveFile(c.req.path));\n\n// View source on Val Town\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Unwrap and rethrow Hono errors as the original error\napp.onError((err) => Promise.reject(err));\n\nexport default app.fetch;",[159],"268554a2-699d-46e3-ae3f-8b232bee9fb6","core.ts","093be7e6-b256-11f1-958a-1607ee4eb77e",5,["D",1789621801551],"export type Locale = \"kk\" | \"en\" | \"ru\";\nexport interface City {\n slug: string; brand: string; title: string; locale: Locale; timezone: string;\n currency: string; sources: string[]; destinationBinding: string; tokenBinding: string;\n enabled: boolean; shadowOnly: boolean; dryRun: boolean; reviewRequired: boolean;\n publicCalendar: boolean; publishTime: string; windowMinutes: number; categories: string[];\n}\nexport const categories = [\"concert\", \"theatre\", \"classes\", \"family\", \"nightlife\", \"exhibition\", \"sport\", \"other\"];\nconst common = { timezone: \"Asia/Almaty\", currency: \"KZT\", reviewRequired: true, dryRun: true, publishTime: \"10:00\", windowMinutes: 15, categories };\nexport const cities: Record = {\n shymkent: { ...common, slug: \"shymkent\", brand: \"Shymkent Plans\", title: \"Шымкентте не бар?\", locale: \"kk\", sources: [\"sxodim\", \"foodfair\"], destinationBinding: \"SHYMKENT_CHAT_ID\", tokenBinding: \"CITY_TELEGRAM_BOT_TOKEN\", enabled: true, shadowOnly: false, publicCalendar: true },\n almaty: { ...common, slug: \"almaty\", brand: \"Almaty Expats\", title: \"Almaty Expats\", locale: \"en\", sources: [\"sxodim\"], destinationBinding: \"ALMATY_SHADOW_DESTINATION\", tokenBinding: \"CITY_TELEGRAM_BOT_TOKEN\", enabled: true, shadowOnly: true, publicCalendar: false },\n astana: { ...common, slug: \"astana\", brand: \"Astana Plans\", title: \"Куда сходить в Астане\", locale: \"ru\", sources: [\"sxodim\"], destinationBinding: \"ASTANA_CHAT_ID\", tokenBinding: \"CITY_TELEGRAM_BOT_TOKEN\", enabled: false, shadowOnly: true, publicCalendar: false },\n};\nexport interface EventData {\n id: string; source: string; sourceItemId: string; city: string; url: string; bookingUrl: string | null;\n title: string; venue: string; address: string | null; category: string;\n date: string | null; endDate: string | null; start: number | null; end: number | null;\n timezone: string; price: number | null; priceText: string | null; currency: string | null;\n eventLanguage: string | null; age: string | null; cancelled: boolean; issues: string[];\n}\nexport interface Translation { title: string; description: string; locale: Locale; provider: string; }\nexport const clean = (x: unknown): string => typeof x === \"string\" ? x.replace(/[\\u200b-\\u200d\\ufeff]/g, \"\").replace(/\\s+/g, \" \").trim() : \"\";\nexport const escape = (x: unknown): string => String(x ?? \"\").replaceAll(\"&\", \"&\").replaceAll(\"<\", \"<\").replaceAll(\">\", \">\").replaceAll('\"', \""\").replaceAll(\"'\", \"'\");\nexport async function hash(x: string): Promise {\n return Array.from(new Uint8Array(await crypto.subtle.digest(\"SHA-256\", new TextEncoder().encode(x))), (b) => b.toString(16).padStart(2, \"0\")).join(\"\");\n}\nexport function localParts(ms: number, timezone: string) {\n const values = Object.fromEntries(new Intl.DateTimeFormat(\"en-CA\", { timeZone: timezone, year: \"numeric\", month: \"2-digit\", day: \"2-digit\", hour: \"2-digit\", minute: \"2-digit\", second: \"2-digit\", hourCycle: \"h23\" }).formatToParts(new Date(ms)).map((p) => [p.type, p.value]));\n return { date: `${values.year}-${values.month}-${values.day}`, time: `${values.hour}:${values.minute}`, second: values.second };\n}\nexport function validDate(s: string): boolean {\n if (!/^\\d{4}-\\d{2}-\\d{2}$/.test(s)) return false;\n const [y, m, d] = s.split(\"-\").map(Number);\n return y >= 1900 && y <= 2199 && m >= 1 && m <= 12 && d >= 1 && d <= new Date(Date.UTC(y, m, 0)).getUTCDate();\n}\nexport function parseDate(value: unknown, timezone: string): { date: string | null; ms: number | null; issue: string | null } {\n let s = clean(value);\n const local = s.match(/^(\\d{2})\\.(\\d{2})\\.(\\d{4})(?:\\s+(\\d{2}):(\\d{2})(?::(\\d{2}))?)?$/);\n if (local) s = `${local[3]}-${local[2]}-${local[1]}${local[4] ? `T${local[4]}:${local[5]}:${local[6] || \"00\"}` : \"\"}`;\n const m = s.match(/^(\\d{4}-\\d{2}-\\d{2})(?:[T ](\\d{2}):(\\d{2})(?::(\\d{2}))?(Z|[+-]\\d{2}:\\d{2})?)?$/);\n if (!m || !validDate(m[1])) return { date: null, ms: null, issue: \"Missing or ambiguous date/year\" };\n if (!m[2]) return { date: m[1], ms: null, issue: \"Time not listed; review required\" };\n if (+m[2] > 23 || +m[3] > 59 || +(m[4] || 0) > 59) return { date: null, ms: null, issue: \"Invalid time\" };\n if (m[5]) {\n if (m[5] !== \"Z\" && (!/^[+-](?:0\\d|1[0-4]):[0-5]\\d$/.test(m[5]))) return { date: null, ms: null, issue: \"Invalid offset\" };\n const ms = Date.parse(`${m[1]}T${m[2]}:${m[3]}:${m[4] || \"00\"}${m[5]}`);\n return Number.isFinite(ms) ? { date: localParts(ms, timezone).date, ms, issue: null } : { date: null, ms: null, issue: \"Invalid date\" };\n }\n const desired = `${m[1]}T${m[2]}:${m[3]}:${m[4] || \"00\"}`;\n const wall = Date.parse(desired + \"Z\"); let ms = wall;\n for (let i = 0; i < 4; i++) { const p = localParts(ms, timezone); ms += wall - Date.parse(`${p.date}T${p.time}:${p.second}Z`); }\n const same = (candidate: number) => { const p = localParts(candidate, timezone); return `${p.date}T${p.time}:${p.second}` === desired; };\n if (!same(ms) || [-7200000, -3600000, -1800000, 1800000, 3600000, 7200000].some((delta) => same(ms + delta))) return { date: m[1], ms: null, issue: \"Ambiguous or nonexistent local time\" };\n return { date: m[1], ms, issue: null };\n}\nexport function addDays(date: string, days: number): string { return new Date(Date.parse(date + \"T12:00:00Z\") + days * 86400000).toISOString().slice(0, 10); }\nexport function weekend(now: number, timezone: string): [string, string] {\n const today = localParts(now, timezone).date; const day = new Date(today + \"T12:00:00Z\").getUTCDay();\n const first = day === 0 ? today : addDays(today, day === 6 ? 0 : 6 - day);\n return [first, day === 0 ? today : addDays(first, 1)];\n}\nexport function schedule(city: City, now: number): { key: string; edition: \"daily\" | \"weekend\"; due: boolean; from: string; to: string } {\n const p = localParts(now, city.timezone); const minute = (t: string) => +t.slice(0, 2) * 60 + +t.slice(3, 5);\n const edition = new Date(p.date + \"T12:00:00Z\").getUTCDay() === 5 ? \"weekend\" : \"daily\";\n return { key: `${city.slug}:${p.date}`, edition, due: minute(p.time) >= minute(city.publishTime) && minute(p.time) < minute(city.publishTime) + city.windowMinutes, from: p.date, to: addDays(p.date, edition === \"weekend\" ? 2 : 1) };\n}\nexport function safeUrl(value: string, hosts?: string[]): string {\n const u = new URL(value);\n if (u.protocol !== \"https:\" || u.username || u.password || u.port || u.hostname === \"localhost\" || u.hostname.endsWith(\".local\") || /^[\\d.]+$/.test(u.hostname) || u.hostname.includes(\":\")) throw new Error(\"Unsafe URL\");\n if (hosts && !hosts.includes(u.hostname)) throw new Error(\"Unapproved host\");\n u.hash = \"\"; for (const k of [...u.searchParams.keys()]) if (/^utm_|^(fbclid|gclid)$/.test(k)) u.searchParams.delete(k);\n return u.href;\n}\nexport const normalized = (s: string) => clean(s).toLocaleLowerCase().normalize(\"NFKC\").replace(/ё/g, \"е\").replace(/[^\\p{L}\\p{N}]+/gu, \" \").trim();\nexport function match(a: EventData, b: EventData): \"same\" | \"review\" | \"different\" {\n if (a.city !== b.city || !a.date || a.date !== b.date) return \"different\";\n if (a.start !== null && b.start !== null && a.start !== b.start) return \"different\";\n const title = normalized(a.title), other = normalized(b.title), venue = normalized(a.venue), otherVenue = normalized(b.venue);\n if (a.url === b.url && a.start === b.start && a.date === b.date) return \"same\";\n if (title && title === other && venue && venue === otherVenue && a.start !== null && a.start === b.start) return \"same\";\n if ((title && title === other) || (venue && venue === otherVenue && a.start !== null && a.start === b.start)) return \"review\";\n return \"different\";\n}\nexport function eligible(e: EventData, now = Date.now()): boolean {\n if (e.cancelled || !e.date) return false;\n if (e.end !== null) return e.end > now;\n if (e.start !== null && !e.endDate) return e.start > now;\n return (e.endDate || e.date) >= localParts(now, e.timezone).date;\n}\nexport function validateTranslation(x: unknown, locale: Locale, provider: string): Translation {\n if (!x || typeof x !== \"object\") throw new Error(\"Translation schema invalid\");\n const o = x as Record;\n if (Object.keys(o).sort().join(\",\") !== \"description,title\") throw new Error(\"Translation fields invalid\");\n for (const [key, limit] of [[\"title\", 260], [\"description\", 280]] as const) if (typeof o[key] !== \"string\" || !clean(o[key]) || (o[key] as string).length > limit || /[<>\\r\\n]|https?:\\/\\//i.test(o[key] as string)) throw new Error(\"Translation text invalid\");\n return { title: clean(o.title), description: clean(o.description), locale, provider };\n}\nexport function validateEvent(e: EventData): void {\n if (!cities[e.city] || !e.title || e.title.length > 260 || e.venue.length > 400 || !categories.includes(e.category)) throw new Error(\"Invalid event metadata\");\n safeUrl(e.url); if (e.bookingUrl) safeUrl(e.bookingUrl);\n if (e.date && !validDate(e.date)) throw new Error(\"Invalid event date\");\n if (e.endDate && (!validDate(e.endDate) || (e.date && e.endDate < e.date))) throw new Error(\"Invalid end date\");\n if (e.price !== null && (!Number.isFinite(e.price) || e.price < 0)) throw new Error(\"Invalid price\");\n if (e.end !== null && (e.start === null || e.end <= e.start)) throw new Error(\"Invalid event end\");\n}\nconst words = {\n kk: { time: \"Уақыты көрсетілмеген\", price: \"Бағасы көрсетілмеген\", venue: \"Мекенжайы нақтылануда\", language: \"Іс-шара тілі көрсетілмеген\", link: \"Дереккөз / билеттер\", daily: \"Бүгін және ертең\", weekend: \"Демалыс күндеріне жоспар\", footer: \"Өзгерістерді ұйымдастырушыдан тексеріңіз.\" },\n en: { time: \"Time not listed\", price: \"Price not listed\", venue: \"Venue to be confirmed\", language: \"Event language not listed\", link: \"Source / tickets\", daily: \"Today and tomorrow\", weekend: \"Weekend plans\", footer: \"Check the organizer for changes.\" },\n ru: { time: \"Время не указано\", price: \"Цена не указана\", venue: \"Адрес уточняется\", language: \"Язык мероприятия не указан\", link: \"Источник / билеты\", daily: \"Сегодня и завтра\", weekend: \"Планы на выходные\", footer: \"Проверяйте изменения у организатора.\" },\n};\nexport function renderEvent(e: EventData, t: Translation, locale: Locale): string {\n const w = words[locale];\n const timing = e.start !== null ? new Intl.DateTimeFormat(locale, { timeZone: e.timezone, dateStyle: \"medium\", timeStyle: \"short\" }).format(new Date(e.start)) : `${e.date || \"?\"}${e.endDate ? \" – \" + e.endDate : \"\"} · ${w.time}`;\n const price = e.priceText || (e.price !== null ? `${e.price.toLocaleString(locale)} ${e.currency || \"\"}` : w.price);\n return [`${escape(t.title)}`, escape(t.description), `📅 ${escape(timing)}`, `📍 ${escape([e.venue, e.address].filter(Boolean).join(\", \") || w.venue)}`, `💰 ${escape(price)}`, escape(e.eventLanguage || w.language), e.age ? escape(e.age) : \"\", `${w.link} · ${escape(e.source)}`].filter(Boolean).join(\"\\n\");\n}\nexport function renderDigest(city: City, entries: { event: EventData; translation: Translation }[], edition: \"daily\" | \"weekend\"): { text: string; ids: string[] } {\n const w = words[city.locale]; const parts = [`${escape(city.title)} · ${w[edition]}`]; const ids: string[] = [];\n for (const item of entries.slice(0, 5)) { const text = renderEvent(item.event, item.translation, city.locale); if ([...parts, text, w.footer].join(\"\\n\\n\").length > 3900) break; parts.push(text); ids.push(item.event.id); }\n return { text: ids.length ? [...parts, `${w.footer}`].join(\"\\n\\n\") : \"\", ids };\n}\nexport function canPublish(city: City, flags: { kill: boolean; paused: boolean; enabled: boolean; dryRun: boolean }, destination: string | undefined): boolean {\n return city.enabled && !city.shadowOnly && city.slug === \"shymkent\" && !flags.kill && !flags.paused && flags.enabled && !flags.dryRun && !!destination && destination !== \"@almaty_expats\";\n}\nexport function sendOutcome(status: number, payload: { ok?: boolean; parameters?: { retry_after?: number }; result?: { message_id?: number } }, attempts: number): { state: string; delay: number; messageId?: number } {\n if (payload.ok === true && Number.isSafeInteger(payload.result?.message_id)) return { state: \"sent\", delay: 0, messageId: payload.result!.message_id };\n if (status === 429 && attempts < 3) return { state: \"retry\", delay: Math.min(3600, Math.max(1, Number(payload.parameters?.retry_after) || 60)) * 1000 };\n if (status >= 500 || status === 408) return { state: \"delivery_unknown\", delay: 0 };\n return { state: \"failed\", delay: 0 };\n}\nexport const botPreview = (agent: string) => /bot|crawler|spider|preview|facebookexternalhit|telegram|whatsapp|slack|discord/i.test(agent);\nexport const ownerId = \"f5be24e4-c798-4816-91e5-037b60b986f5\";\n",[165],"d139edf0-c553-4e8a-98f1-2d90b37b1a11","README.md","01a0adbf-b85c-735b-b5fd-96a5ae956fb7",["D",1789621418009],"# hono-jsx-starter\n\nA minimal [Hono](https://hono.dev) + Hono JSX starter for Val Town.\nServer-rendered HTML, no build step, no React.\n\n## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| **[`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter)** *(you're here)* | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| [`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter) | Client-side React SPA with a Hono API backend. |\n\n## What's here\n\n```\nindex.tsx Hono app, Layout, routes\npublic/\n favicon.svg Static asset\n counter.ts Tiny client-side script\n```\n\nThe whole app fits in one file. As you grow it, the natural next moves are:\n\n- Pull `Layout` into its own `.tsx` file once you have 3+ pages.\n- Split routes with `app.route(\"/api\", api)` if `/api/*` grows.\n- Add more files under `public/` — they're served by a single\n `app.get(\"/public/*\", ...)` route.\n\n## Patterns worth knowing\n\n**JSX pragma.** Every `.tsx` file that uses JSX needs this at the top:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\n```\n\n**Server state.** The counter on `/` is `let count = 0` at module scope. It\nlives in memory on the Val Town server and survives across requests — but resets\nwhenever the val restarts (deploys, idle timeouts, etc.). For persistent state,\nswap it for [`std/sqlite`](https://www.val.town/x/std/sqlite) or\n[`std/blob`](https://www.val.town/x/std/blob).\n\n**API routes.** The `Increment` button POSTs to `/api/increment`, which returns\nJSON. Mix server-rendered pages and JSON endpoints in the same Hono app:\n\n```ts\napp.post(\"/api/increment\", (c) => c.json({ count: ++count }));\n```\n\n**Static files.** `serveFile` reads the file by path and serves it with the\nright content-type. `.ts` files are transpiled to JS on request by Val Town — so\nyou can write `public/counter.ts` and reference it as\n`

Diff · v7