[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_244":245,"_246":247},"routes/_app.x.$handle.$name",{"_99":98,"_32":45,"_108":89,"_27":36,"_13":14,"_109":-5,"_11":110,"_111":112,"_113":114,"_115":116,"_117":118,"_20":-5,"_119":-5,"_120":-5,"_121":25,"_122":123,"_124":58,"_125":-5,"_126":-5,"_127":128},"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":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":70,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":82,"_83":84,"_85":86,"_87":25},"version",32,"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","cron.ts","latestPath","fileId","781f76ee-8058-11f1-8238-1607ee4eb77e","name","fileType","script","content","","// Interval-Val (fileType: \"interval\") - läuft täglich und aktualisiert die\n// News- und Event-Daten der Website. Cron-Ausdrücke auf Val Town laufen in UTC.\n//\n// Vorschlag: \"0 5 * * *\" -> 05:00 UTC = 06:00/07:00 Schweizer Zeit (je nach\n// Sommer-/Winterzeit), also kurz nach Mitternacht bis früh morgens - gute Zeit\n// für den täglichen Refresh, bevor die ersten Besucher des Tages kommen.\n//\n// Einrichtung auf val.town: neuen Val anlegen, Typ \"Cron/Interval\", diesen\n// Code einfügen, Schedule auf \"0 5 * * *\" setzen.\nimport { initDb } from \"./db.ts\";\nimport { fetchAllNews } from \"./fetchNews.ts\";\nimport { fetchAllEvents } from \"./fetchEvents.ts\";\n\nexport default async function (interval: Interval) {\n await initDb();\n\n const newsResult = await fetchAllNews();\n const eventsResult = await fetchAllEvents();\n\n console.log(\"Tägliches Update abgeschlossen\", {\n lastRunAt: interval.lastRunAt,\n news: newsResult,\n events: eventsResult,\n });\n}","createdAt",["D",1784125338446],"branchVersion","branchId","5f23184d-5735-4300-bb27-b89e5778352c","id","92e5d7b6-2ea8-4dab-9801-d3505afc45ec","Zueri-Aktuell",["D",1784123665648],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","d194864a-924a-4483-8e98-b9a725ddacca","pinnedFileId","b0ca049a-8054-11f1-94bb-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019f660a-aa7b-75ab-874d-ec9e86ee3f5b","tursoName","92e5d7b62ea84dab9801d3505afc45ec","tursoHostname","92e5d7b62ea84dab9801d3505afc45ec-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789559472742],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_99":98,"_107":103},"org",{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},"branch",{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"isOwned",37,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","daniweidmannnetizen","handle","displayName","daniweidmann-netizen","avatar","https://avatars.githubusercontent.com/u/294083355?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":239,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":36,"_53":-5,"_18":54,"_55":56,"_57":58,"_59":-5,"_60":-5,"_61":62,"_63":64,"_65":66,"_67":68,"_69":240,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":241,"_83":242,"_85":243,"_87":25},"tree",[206,207,208,209,210,211,212,213],"files",[206,207,208,209,210,211,212,213],"counts",{"_195":62,"_196":197,"_198":62,"_199":200,"_201":202},"contents",[129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":192,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_142":25,"_38":193,"_13":161,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":194},{"_43":185,"_32":186,"_30":187,"_140":-5,"_41":42,"_40":188,"_142":58,"_38":189,"_13":161,"_33":34,"_35":190,"_24":25,"_146":-5,"_27":191},{"_43":178,"_32":179,"_30":180,"_140":-5,"_41":42,"_40":181,"_142":58,"_38":182,"_13":161,"_33":34,"_35":183,"_24":25,"_146":-5,"_27":184},{"_43":171,"_32":172,"_30":173,"_140":-5,"_41":42,"_40":174,"_142":58,"_38":175,"_13":144,"_33":34,"_35":176,"_24":25,"_146":-5,"_27":177},{"_43":164,"_32":165,"_30":166,"_140":-5,"_41":42,"_40":167,"_142":58,"_38":168,"_13":161,"_33":34,"_35":169,"_24":25,"_146":-5,"_27":170},{"_43":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_142":58,"_38":160,"_13":161,"_33":34,"_35":162,"_24":25,"_146":-5,"_27":163},{"_43":148,"_32":149,"_30":56,"_140":-5,"_41":42,"_40":150,"_142":58,"_38":151,"_13":152,"_33":153,"_35":154,"_24":25,"_146":-5,"_27":155},{"_43":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":25,"_38":143,"_13":144,"_33":34,"_35":145,"_24":25,"_146":-5,"_27":147},"9cb28d6a-15a9-4a87-b319-40ff4d6dae0b","pages.tsx","b47a1e66-8056-11f1-9d52-1607ee4eb77e","parentId",29,"latest",["D",1784125005993],3,"/** @jsxImportSource npm:hono/jsx */\n// Alle Seiten-Komponenten der Website (server-seitig gerendert - wichtig für\n// SEO und schnelle Ladezeiten, beides Voraussetzungen für gute Google-\n// Rankings und eine AdSense-Freischaltung).\nimport { jsx } from \"npm:hono/jsx\";\nimport type { FC } from \"npm:hono/jsx\";\n\nconst SITE_NAME = \"Zürich Aktuell\";\nconst SITE_TAGLINE =\n \"News, Veranstaltungen & Öffnungszeiten für den Kanton Zürich\";\n\nexport const Layout: FC<\n { title: string; description: string; children: any; path: string }\n> = ({\n title,\n description,\n children,\n path,\n}) => (\n \n \n \n \n {title} | {SITE_NAME}\n \n \n \n {/* AdSense: Publisher-ID hier einsetzen, sobald das Konto freigeschaltet ist */}\n {/* */}\n \n \n \n \n

\n {SITE_NAME}\n \n

\n\n

{children}

\n\n \n \n \n);\n\nconst CookieBanner: FC = () => (\n \n

\n \n Diese Website verwendet Cookies für Reichweitenmessung und Werbung\n (Google AdSense). Mehr dazu in der{\" \"}\n Datenschutzerklärung.\n \n \n Akzeptieren\n \n

\n \n \n \n);\n\n// Werbeblock-Platzhalter. Sobald das AdSense-Konto freigeschaltet ist, den\n// Kommentar durch das echte -Tag ersetzen.\nexport const AdSlot: FC<{ label?: string }> = ({ label = \"Anzeige\" }) => (\n

\n {label} (AdSense-Platzhalter)\n

\n);\n\nfunction fmtDate(iso: string | null | undefined): string {\n if (!iso) return \"\";\n try {\n return new Date(iso).toLocaleDateString(\"de-CH\", {\n day: \"2-digit\",\n month: \"long\",\n year: \"numeric\",\n });\n } catch {\n return iso;\n }\n}\n\nexport const HomePage: FC<{ news: any[]; events: any[] }> = (\n { news, events },\n) => (\n \n

{SITE_NAME}

{SITE_TAGLINE}

\n\n \n\n

Aktuelle News

\n \n alle News →\n \n

\n \n {item.title}\n \n
\n {item.source} · {fmtDate(item.published_at)}\n
\n

\n Noch keine News geladen - der tägliche Job läuft bald.\n

\n\n \n\n

Kommende Veranstaltungen

\n \n alle Events →\n \n

\n
{ev.title}
\n
\n {fmtDate(ev.event_date)} · {ev.location}\n
\n

\n \n);\n\nexport const NewsPage: FC<{ news: any[] }> = ({ news }) => (\n \n

News aus dem Kanton Zürich

\n \n

\n \n {item.title}\n \n
\n {item.source} · {fmtDate(item.published_at)}\n
\n {item.summary &&
{item.summary}
}\n

Noch keine News vorhanden.

\n \n);\n\nexport const EventsPage: FC<{ events: any[] }> = ({ events }) => (\n \n

Veranstaltungen im Kanton Zürich

\n \n

\n
{ev.title}
\n
\n {fmtDate(ev.event_date)} · {ev.location}\n
\n {ev.description &&
{ev.description}\n
}\n {ev.link && (\n \n Mehr Infos →\n \n )}\n

\n \n);\n\nexport const HoursPage: FC<{\n holidays: { date: string; name: string }[];\n sundayShopping: { date: string; label: string; hours: string }[];\n yearRound: string[];\n}> = ({ holidays, sundayShopping, yearRound }) => (\n \n

\n Öffnungszeiten & Feiertage Kanton Zürich 2026\n

\n \n\n

Gesetzliche Feiertage 2026

\n {h.name}\n {fmtDate(h.date)}\n

\n\n

Verkaufsoffene Sonntage 2026

\n {s.label}\n {fmtDate(s.date)} · {s.hours}\n

\n\n

Ganzjährig sonntags geöffnet

\n \n);\n\nexport const ImpressumPage: FC = () => (\n \n

Impressum

\n [Dein Name / Firmenname]\n

[Strasse Nr.]

[PLZ Ort], Schweiz

E-Mail: [deine-email@beispiel.ch]

\n Verantwortlich für den Inhalt dieser Website gemäss Art. 3 Abs. 1 lit. s\n UWG. Bitte diese Angaben vor dem Live-Schalten mit deinen echten\n Kontaktdaten ersetzen - das ist Pflicht für AdSense und für den\n Marktauftritt in der Schweiz.\n

\n \n);\n\nexport const DatenschutzPage: FC = () => (\n \n

Datenschutzerklärung

\n Diese Website nutzt Google AdSense, einen Werbedienst der Google Ireland\n Limited. Google AdSense kann Cookies und ähnliche Technologien\n einsetzen, um Anzeigen basierend auf früheren Besuchen dieser oder\n anderer Websites auszuspielen.\n

\n Nutzer können der Verwendung von Cookies für personalisierte Werbung\n unter{\" \"}\n \n adssettings.google.com\n {\" \"}\n widersprechen.\n

\n Es werden keine über das für den Betrieb der Website und die\n Werbeeinblendung notwendige Mass hinausgehenden personenbezogenen Daten\n erhoben oder weitergegeben.\n

\n Hinweis: Dies ist ein Muster-Text. Bitte vor Live-Schaltung durch eine\n vollständige, rechtlich geprüfte Datenschutzerklärung ersetzen (inkl.\n Verweis auf die Google-Erklärung{\" \"}\n \n Wie Google-Partnerseiten Daten verwenden\n ) - Pflicht für die AdSense-Freischaltung.\n

\n \n);","label",[138],"78f2232a-86db-4d90-860d-afcd7731c55f","main.ts",28,["D",1784124999099],8,"http","/** @jsxImportSource npm:hono/jsx */\n// Haupt-HTTP-Val: rendert die komplette Website server-seitig (gut für SEO\n// und AdSense - Google sieht sofort echten, crawlbaren Content statt einer\n// leeren SPA-Hülle).\nimport { Hono } from \"npm:hono\";\nimport { jsx } from \"npm:hono/jsx\";\nimport { parseVal } from \"https://esm.town/v/std/utils/index.ts\";\nimport { getLatestNews, getUpcomingEvents, initDb } from \"./db.ts\";\nimport {\n DatenschutzPage,\n EventsPage,\n HomePage,\n HoursPage,\n ImpressumPage,\n NewsPage,\n} from \"./pages.tsx\";\nimport {\n HOLIDAYS_2026,\n SUNDAY_SHOPPING_2026,\n YEAR_ROUND_SUNDAY_SHOPS,\n} from \"./data_holidays2026.ts\";\n\nconst app = new Hono();\n\napp.onError((err, c) => {\n console.error(err);\n return c.text(\"Ein Fehler ist aufgetreten. Details in den Val-Logs.\", 500);\n});\n\n// Stellt sicher, dass die Tabellen existieren (idempotent, günstig genug\n// um bei jedem Request zu prüfen).\napp.use(\"*\", async (c, next) => {\n await initDb();\n await next();\n});\n\napp.get(\"/\", async (c) => {\n const news = await getLatestNews(10);\n const events = await getUpcomingEvents(10);\n return c.html();\n});\n\napp.get(\"/news\", async (c) => {\n const news = await getLatestNews(50);\n return c.html();\n});\n\napp.get(\"/veranstaltungen\", async (c) => {\n const events = await getUpcomingEvents(50);\n return c.html();\n});\n\napp.get(\"/oeffnungszeiten\", (c) => {\n return c.html(\n ,\n );\n});\n\napp.get(\"/impressum\", (c) => c.html());\napp.get(\"/datenschutz\", (c) => c.html());\n\n// ads.txt - MUSS die echte AdSense-Publisher-ID enthalten, sobald das Konto\n// existiert (Format: google.com, pub-XXXXXXXXXXXXXXXX, DIRECT, f08c47fec0942fa0)\napp.get(\"/ads.txt\", (c) => {\n return c.text(\n \"# TODO: echte pub-ID von Google AdSense hier eintragen\\n# google.com, pub-XXXXXXXXXXXXXXXX, DIRECT, f08c47fec0942fa0\\n\",\n );\n});\n\napp.get(\"/robots.txt\", (c) => {\n return c.text(\"User-agent: *\\nAllow: /\\nSitemap: /sitemap.xml\\n\");\n});\n\napp.get(\"/sitemap.xml\", (c) => {\n const pages = [\n \"\",\n \"news\",\n \"veranstaltungen\",\n \"oeffnungszeiten\",\n \"impressum\",\n \"datenschutz\",\n ];\n const base = new URL(c.req.url).origin;\n const body =\n `\\n\\n` +\n pages.map((p) => ` ${base}/${p}`).join(\"\\n\") +\n `\\n`;\n return c.body(body, 200, { \"Content-Type\": \"application/xml\" });\n});\n\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\nexport default app.fetch;",[149],"4223da75-7d57-4e01-b401-c837b91596a0","fetchNews.ts","44630fc0-8056-11f1-8593-1607ee4eb77e",25,["D",1784124767987],2,"// Fetches and parses public RSS feeds, keeps items relevant to Kanton Zürich.\n//\n// Verified working feed (no API key required):\n// SRF \"Schweiz\" news RSS: https://www.srf.ch/news/bnf/rss/1890\n//\n// You can add more feeds to NEWS_FEEDS below. Good candidates to check\n// periodically (some Swiss news sites gate their RSS behind changing IDs):\n// - https://www.srf.ch/news/bnf/rss/19032223 (SRF \"Das Neueste\")\n// - Regional newspaper RSS pages listed on the paper's own /rss page\n// (e.g. tagesanzeiger.ch, nzz.ch, zuonline.ch) — copy the exact URL\n// shown on their RSS overview page, they change periodically.\nimport { insertNewsItem, logRun, pruneOldNews } from \"./db.ts\";\n\nconst NEWS_FEEDS: { url: string; source: string }[] = [\n { url: \"https://www.srf.ch/news/bnf/rss/1890\", source: \"SRF Schweiz\" },\n];\n\n// Keywords used to decide whether a national news item is relevant enough\n// to a Kanton Zürich audience to show on the site. Broaden/narrow as needed.\nconst RELEVANCE_KEYWORDS = [\n \"zürich\",\n \"zurich\",\n \"winterthur\",\n \"uster\",\n \"dietikon\",\n \"bülach\",\n \"dübendorf\",\n \"kloten\",\n \"wetzikon\",\n \"kanton zürich\",\n \"zvv\",\n \"sbb zürich\",\n];\n\nfunction isRelevant(title: string, summary: string): boolean {\n const haystack = `${title} ${summary}`.toLowerCase();\n return RELEVANCE_KEYWORDS.some((kw) => haystack.includes(kw));\n}\n\nfunction extractTag(xml: string, tag: string): string | null {\n const match = xml.match(\n new RegExp(`<${tag}[^>]*>([\\\\s\\\\S]*?)`, \"i\"),\n );\n if (!match) return null;\n return match[1]\n .replace(//g, \"$1\")\n .replace(/<[^>]+>/g, \"\")\n .trim();\n}\n\nfunction parseRssItems(\n xml: string,\n): { title: string; link: string; summary: string; pubDate: string }[] {\n const itemBlocks = xml.match(//gi) ?? [];\n return itemBlocks.map((block) => ({\n title: extractTag(block, \"title\") ?? \"(ohne Titel)\",\n link: extractTag(block, \"link\") ?? \"\",\n summary: extractTag(block, \"description\") ?? \"\",\n pubDate: extractTag(block, \"pubDate\") ?? new Date().toISOString(),\n }));\n}\n\nexport async function fetchAllNews() {\n let totalInserted = 0;\n const errors: string[] = [];\n\n for (const feed of NEWS_FEEDS) {\n try {\n const res = await fetch(feed.url, {\n headers: {\n \"User-Agent\": \"Mozilla/5.0 (compatible; ZuerichInfoBot/1.0)\",\n },\n });\n if (!res.ok) {\n errors.push(`${feed.source}: HTTP ${res.status}`);\n continue;\n }\n const xml = await res.text();\n const items = parseRssItems(xml);\n\n for (const item of items) {\n if (!isRelevant(item.title, item.summary)) continue;\n if (!item.link) continue;\n\n let publishedAt: string;\n try {\n publishedAt = new Date(item.pubDate).toISOString();\n } catch {\n publishedAt = new Date().toISOString();\n }\n\n await insertNewsItem({\n source: feed.source,\n title: item.title,\n summary: item.summary.slice(0, 400),\n link: item.link,\n publishedAt,\n });\n totalInserted++;\n }\n } catch (err) {\n errors.push(\n `${feed.source}: ${err instanceof Error ? err.message : String(err)}`,\n );\n }\n }\n\n await pruneOldNews(30);\n\n if (errors.length > 0) {\n await logRun(\n \"news\",\n totalInserted > 0 ? \"ok\" : \"error\",\n errors.join(\" | \"),\n );\n } else {\n await logRun(\"news\", \"ok\", `${totalInserted} Artikel verarbeitet`);\n }\n\n return { inserted: totalInserted, errors };\n}",[157],"268d2009-1014-4f57-a5d7-97494171eabc","fetchEvents.ts","5c7ba5d6-8056-11f1-9f5d-1607ee4eb77e",24,["D",1784124764383],"// Events-Fetcher für Kanton Zürich.\n//\n// Es gibt keine öffentliche, schlüssellose Live-API mit allen Veranstaltungen\n// im Kanton Zürich. Zwei Stufen:\n//\n// 1. Falls die Umgebungsvariable ST_API_KEY gesetzt ist (kostenloser Key von\n// https://developer.myswitzerland.io/), werden aktuelle Events über die\n// offizielle Switzerland-Tourism-API nachgeladen.\n// 2. Andernfalls (Standard) wird die kuratierte Liste bekannter Grossanlässe\n// aus data_events2026.ts eingespielt, damit die Seite nie leer ist.\n//\n// Setze den Key in Val Town unter \"Environment Variables\" des Vals, dann\n// läuft Stufe 1 automatisch mit.\nimport { insertEvent, logRun, pruneOldEvents } from \"./db.ts\";\nimport { SEED_EVENTS_2026 } from \"./data_events2026.ts\";\n\nconst ST_API_KEY = Deno.env.get(\"ST_API_KEY\");\n\nasync function fetchFromSwitzerlandTourism(): Promise {\n if (!ST_API_KEY) return 0;\n\n let inserted = 0;\n try {\n const res = await fetch(\n \"https://opendata.myswitzerland.io/v1/events?facets=place.canton:ZH&expand=true&hitsPerPage=50\",\n { headers: { \"x-api-key\": ST_API_KEY } },\n );\n if (!res.ok) {\n await logRun(\"events\", \"error\", `ST API HTTP ${res.status}`);\n return 0;\n }\n const data = await res.json();\n const items = Array.isArray(data?.data) ? data.data : [];\n\n for (const raw of items) {\n const title = raw?.identifier?.name?.de ?? raw?.name?.de ??\n \"Veranstaltung\";\n const description = raw?.abstract?.de ?? raw?.description?.de ?? \"\";\n const location = raw?.place?.name ?? \"Kanton Zürich\";\n const eventDate = raw?.schedules?.[0]?.startDate ?? null;\n const link = raw?.url?.de ?? raw?.identifier?.url ?? \"\";\n if (!link) continue;\n\n await insertEvent({ title, description, location, eventDate, link });\n inserted++;\n }\n } catch (err) {\n await logRun(\n \"events\",\n \"error\",\n err instanceof Error ? err.message : String(err),\n );\n }\n return inserted;\n}\n\nasync function seedFallbackEvents(): Promise {\n for (const e of SEED_EVENTS_2026) {\n await insertEvent({\n title: e.title,\n description: e.description,\n location: e.location,\n eventDate: e.eventDate,\n link: e.link,\n });\n }\n return SEED_EVENTS_2026.length;\n}\n\nexport async function fetchAllEvents() {\n const fromApi = await fetchFromSwitzerlandTourism();\n const fromSeed = await seedFallbackEvents();\n\n await pruneOldEvents();\n await logRun(\n \"events\",\n \"ok\",\n `${fromApi} via ST-API, ${fromSeed} aus kuratierter Liste eingespielt/aktualisiert`,\n );\n\n return { fromApi, fromSeed };\n}",[165],"cbdf3495-27c6-42e8-8a8e-ce0f01c81fa8","db.ts","2ac19fe6-8056-11f1-a3d2-1607ee4eb77e",23,["D",1784124761625],"// Val-scoped SQLite database setup.\n// Docs: https://docs.val.town/reference/std/sqlite/usage/\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport async function initDb() {\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS news_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n source TEXT NOT NULL,\n title TEXT NOT NULL,\n summary TEXT,\n link TEXT NOT NULL UNIQUE,\n published_at TEXT NOT NULL,\n fetched_at TEXT NOT NULL\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n title TEXT NOT NULL,\n description TEXT,\n location TEXT,\n event_date TEXT,\n link TEXT UNIQUE,\n fetched_at TEXT NOT NULL\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS fetch_log (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n job TEXT NOT NULL,\n status TEXT NOT NULL,\n detail TEXT,\n ran_at TEXT NOT NULL\n )`);\n}\n\nexport async function logRun(\n job: string,\n status: \"ok\" | \"error\",\n detail: string,\n) {\n await sqlite.execute({\n sql:\n \"INSERT INTO fetch_log (job, status, detail, ran_at) VALUES (?, ?, ?, ?)\",\n args: [job, status, detail, new Date().toISOString()],\n });\n}\n\nexport async function insertNewsItem(item: {\n source: string;\n title: string;\n summary: string;\n link: string;\n publishedAt: string;\n}) {\n try {\n await sqlite.execute({\n sql:\n `INSERT INTO news_items (source, title, summary, link, published_at, fetched_at)\n VALUES (?, ?, ?, ?, ?, ?)\n ON CONFLICT(link) DO UPDATE SET\n title = excluded.title,\n summary = excluded.summary,\n fetched_at = excluded.fetched_at`,\n args: [\n item.source,\n item.title,\n item.summary,\n item.link,\n item.publishedAt,\n new Date().toISOString(),\n ],\n });\n } catch (err) {\n // Older SQLite versions on Val Town may not support ON CONFLICT with all\n // clauses identically; fall back to ignore-on-duplicate.\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO news_items (source, title, summary, link, published_at, fetched_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n item.source,\n item.title,\n item.summary,\n item.link,\n item.publishedAt,\n new Date().toISOString(),\n ],\n });\n }\n}\n\nexport async function insertEvent(item: {\n title: string;\n description: string;\n location: string;\n eventDate: string | null;\n link: string;\n}) {\n await sqlite.execute({\n sql:\n `INSERT OR IGNORE INTO events (title, description, location, event_date, link, fetched_at)\n VALUES (?, ?, ?, ?, ?, ?)`,\n args: [\n item.title,\n item.description,\n item.location,\n item.eventDate,\n item.link,\n new Date().toISOString(),\n ],\n });\n}\n\nexport async function pruneOldNews(keepDays = 30) {\n await sqlite.execute(\n `DELETE FROM news_items WHERE fetched_at < datetime('now', '-${keepDays} days')`,\n );\n}\n\nexport async function pruneOldEvents() {\n await sqlite.execute(\n `DELETE FROM events WHERE event_date < date('now', '-1 day')`,\n );\n}\n\nexport async function getLatestNews(limit = 25) {\n const result = await sqlite.execute({\n sql: \"SELECT * FROM news_items ORDER BY published_at DESC LIMIT ?\",\n args: [limit],\n });\n return result.rows;\n}\n\nexport async function getUpcomingEvents(limit = 40) {\n const result = await sqlite.execute({\n sql: `SELECT * FROM events\n WHERE event_date IS NULL OR event_date >= date('now')\n ORDER BY event_date ASC LIMIT ?`,\n args: [limit],\n });\n return result.rows;\n}\n\nexport async function getLastFetchTimes() {\n const result = await sqlite.execute(\n \"SELECT job, MAX(ran_at) as last_ran, status FROM fetch_log GROUP BY job\",\n );\n return result.rows;\n}",[172],"22cc7ca6-5ef7-4367-92b3-d70d4869c545","data_holidays2026.ts","7ed4b0fa-8056-11f1-8c03-1607ee4eb77e",22,["D",1784124754796],"// Offizielle Feiertage Kanton Zürich 2026.\n// Quelle: Finanzdirektion Kanton Zürich, Personalamt (Feiertage 2026, PDF).\nexport interface Holiday {\n date: string; // ISO yyyy-mm-dd\n name: string;\n note?: string;\n}\n\nexport const HOLIDAYS_2026: Holiday[] = [\n { date: \"2026-01-01\", name: \"Neujahr\" },\n { date: \"2026-04-03\", name: \"Karfreitag\" },\n { date: \"2026-04-06\", name: \"Ostermontag\" },\n { date: \"2026-05-01\", name: \"Tag der Arbeit\" },\n { date: \"2026-05-14\", name: \"Auffahrt\" },\n { date: \"2026-05-25\", name: \"Pfingstmontag\" },\n { date: \"2026-08-01\", name: \"Bundesfeier\" },\n { date: \"2026-12-25\", name: \"Weihnachten\" },\n { date: \"2026-12-26\", name: \"Stephanstag\" },\n];\n\n// Nur in der Stadt Zürich arbeitsfrei bzw. halber Feiertag (nicht kantonal,\n// nur bei entsprechender Regelung im Betrieb/Vertrag).\nexport const LOCAL_HALF_DAYS_ZURICH_CITY_2026: Holiday[] = [\n {\n date: \"2026-04-20\",\n name: \"Sechseläuten (Nachmittag)\",\n note: \"nur Stadt Zürich, nicht gesetzlich\",\n },\n {\n date: \"2026-12-24\",\n name: \"Heiligabend (Nachmittag)\",\n note: \"nur Stadt Zürich, nicht gesetzlich\",\n },\n];\n\nexport const SUNDAY_SHOPPING_2026 = [\n { date: \"2026-05-31\", label: \"Pfingstsonntag\", hours: \"10:00–18:00\" },\n { date: \"2026-11-29\", label: \"1. Advent\", hours: \"11:00–18:00\" },\n { date: \"2026-12-06\", label: \"Samichlaus-Sonntag\", hours: \"11:00–18:00\" },\n { date: \"2026-12-20\", label: \"4. Advent\", hours: \"11:00–18:00\" },\n];\n\nexport const YEAR_ROUND_SUNDAY_SHOPS = [\n \"ShopVille Zürich HB (365 Tage im Jahr, auch an Feiertagen)\",\n \"Flughafen Zürich Airport (Läden im öffentlichen Bereich)\",\n];",[179],"d59a0d06-1483-4156-ad38-0f242a93af5e","data_events2026.ts","9c97933c-8056-11f1-9187-1607ee4eb77e",21,["D",1784124752285],"// Kuratierte Liste bekannter, wiederkehrender Grossveranstaltungen im Kanton\n// Zürich für 2026 (recherchiert Juli 2026). Dient als verlässliche\n// Grundlage, solange kein automatischer Event-Feed konfiguriert ist, und\n// als Fallback, falls der externe Event-Fetch (fetchEvents.ts) mal fehlschlägt.\n//\n// Bitte Daten jährlich prüfen/aktualisieren - Quellen u.a. sechselaeuten.ch,\n// streetparade.com, zuerich.com.\nexport interface SeedEvent {\n title: string;\n description: string;\n location: string;\n eventDate: string; // ISO yyyy-mm-dd (Start), oder Zeitraum in description\n link: string;\n}\n\nexport const SEED_EVENTS_2026: SeedEvent[] = [\n {\n title: \"Sechseläuten 2026\",\n description:\n \"Zürcher Frühlingsfest der Zünfte. Kinderumzug am Sonntag 19. April ab 14:30 Uhr, \" +\n \"Zünfteumzug durch die Altstadt am Montag 20. April ab 15 Uhr, Verbrennung des Böögg \" +\n \"zum Sechs-Uhr-Geläut von St. Peter.\",\n location: \"Zürich Altstadt / Sechseläutenplatz\",\n eventDate: \"2026-04-20\",\n link: \"https://www.sechselaeuten.ch/\",\n },\n {\n title: \"Street Parade 2026\",\n description:\n \"33. Street Parade am Zürichsee, ca. 13:00 bis Mitternacht. Rund 30 Love Mobiles auf der \" +\n \"2,4 km langen Strecke zwischen Utoquai und Hafen Enge. Eintritt frei.\",\n location: \"Zürich, rund um den Zürichsee\",\n eventDate: \"2026-08-08\",\n link: \"https://www.streetparade.com/\",\n },\n {\n title: \"Sonntagsverkauf: Pfingstsonntag\",\n description:\n \"Verkaufsoffener Sonntag in der Zürcher Innenstadt und Einkaufszentren, 10-18 Uhr.\",\n location: \"Zürich Innenstadt, Sihlcity, Glatt, Letzipark u.a.\",\n eventDate: \"2026-05-31\",\n link: \"https://www.sonntagsverkaeufe.ch/\",\n },\n {\n title: \"Sonntagsverkauf: 1. Advent\",\n description: \"Verkaufsoffener Sonntag zum Adventsstart, 11-18 Uhr.\",\n location: \"Zürich Innenstadt\",\n eventDate: \"2026-11-29\",\n link: \"https://www.sonntagsverkaeufe.ch/\",\n },\n {\n title: \"Sonntagsverkauf: Samichlaus-Sonntag\",\n description:\n \"Verkaufsoffener Sonntag rund um den Samichlaustag, 11-18 Uhr.\",\n location: \"Zürich Innenstadt\",\n eventDate: \"2026-12-06\",\n link: \"https://www.sonntagsverkaeufe.ch/\",\n },\n {\n title: \"Sonntagsverkauf: 4. Advent\",\n description: \"Letzter verkaufsoffener Sonntag vor Weihnachten, 11-18 Uhr.\",\n location: \"Zürich Innenstadt\",\n eventDate: \"2026-12-20\",\n link: \"https://www.sonntagsverkaeufe.ch/\",\n },\n {\n title: \"Polarzauber im Hauptbahnhof (Christkindlimarkt)\",\n description:\n \"Weihnachtsmarkt in der Haupthalle des Zürcher Hauptbahnhofs mit rund 100-140 Marktständen \" +\n \"und dem beleuchteten Swarovski-Weihnachtsbaum.\",\n location: \"Zürich HB, Haupthalle\",\n eventDate: \"2026-11-19\",\n link:\n \"https://www.zuerich.com/de/besuchen/shopping/christkindlimarkt-im-hauptbahnhof\",\n },\n];",[186],"5a321007-82aa-4f56-9f4d-3d698701bceb",["D",1784125338446],[28],"pulls","branches",1,"forks","envVars",{"_203":62,"_205":62},"connections",{"_203":62,"_204":62},"count","unfilledCount","emptyCount",{"_43":192,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_142":25,"_38":236,"_13":161,"_33":34,"_35":37,"_24":25,"_146":-5,"_215":237,"_27":238},{"_43":185,"_32":186,"_30":187,"_140":-5,"_41":42,"_40":188,"_142":58,"_38":233,"_13":161,"_33":34,"_35":190,"_24":25,"_146":-5,"_215":234,"_27":235},{"_43":178,"_32":179,"_30":180,"_140":-5,"_41":42,"_40":181,"_142":58,"_38":230,"_13":161,"_33":34,"_35":183,"_24":25,"_146":-5,"_215":231,"_27":232},{"_43":171,"_32":172,"_30":173,"_140":-5,"_41":42,"_40":174,"_142":58,"_38":227,"_13":144,"_33":34,"_35":176,"_24":25,"_146":-5,"_215":228,"_27":229},{"_43":164,"_32":165,"_30":166,"_140":-5,"_41":42,"_40":167,"_142":58,"_38":224,"_13":161,"_33":34,"_35":169,"_24":25,"_146":-5,"_215":225,"_27":226},{"_43":156,"_32":157,"_30":158,"_140":-5,"_41":42,"_40":159,"_142":58,"_38":221,"_13":161,"_33":34,"_35":162,"_24":25,"_146":-5,"_215":222,"_27":223},{"_43":148,"_32":149,"_30":56,"_140":-5,"_41":42,"_40":150,"_142":58,"_38":218,"_13":152,"_33":153,"_35":154,"_24":25,"_146":-5,"_215":219,"_27":220},{"_43":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":25,"_38":214,"_13":144,"_33":34,"_35":145,"_24":25,"_146":-5,"_215":216,"_27":217},["D",1784125005993],"children",[],[138],["D",1784124999099],[],[149],["D",1784124767987],[],[157],["D",1784124764383],[],[165],["D",1784124761625],[],[172],["D",1784124754796],[],[179],["D",1784124752285],[],[186],["D",1784125338446],[],[28],["D",1784123665648],["D",1789559472742],{"_99":98,"_107":103},{"_99":98,"_100":101,"_102":103,"_18":54,"_104":105,"_106":25},{"_13":88,"_32":89,"_43":42,"_90":44,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":45,"_97":98},"ctx",{"_81":-5,"_126":277,"_278":279,"_280":281,"_282":25,"_283":25,"_284":25,"_285":58,"_286":-5,"_287":-7,"_288":-7,"_289":62,"_290":25,"_291":25,"_292":-5,"_293":25,"_294":25,"_295":25,"_296":-5},"ENV",{"_248":249,"_250":251,"_252":89,"_253":254,"_255":256,"_257":258,"_259":260,"_261":262,"_263":264,"_265":266,"_267":268,"_269":270,"_271":272,"_273":274,"_275":276},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","5015b8df46402d8bba4f485ecc37aec202b0e06b","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 · v32