{title} | {SITE

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_230":231,"_232":233},"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",23,"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","db.ts","latestPath","fileId","2ac19fe6-8056-11f1-a3d2-1607ee4eb77e","name","fileType","script","content","","// 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}","createdAt",["D",1784124761625],"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":225,"_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":226,"_71":-5,"_72":73,"_74":73,"_75":76,"_77":76,"_78":76,"_79":73,"_80":73,"_81":227,"_83":228,"_85":229,"_87":25},"tree",[196,197,198,199,200,201,202],"files",[196,197,198,199,200,201,202],"counts",{"_186":62,"_187":160,"_188":62,"_189":190,"_191":192},"contents",[129,130,131,132,133,134,135],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":179,"_32":180,"_30":181,"_139":-5,"_41":42,"_40":182,"_141":58,"_38":183,"_13":143,"_33":34,"_35":184,"_24":25,"_145":-5,"_27":185},{"_43":172,"_32":173,"_30":174,"_139":-5,"_41":42,"_40":175,"_141":58,"_38":176,"_13":143,"_33":34,"_35":177,"_24":25,"_145":-5,"_27":178},{"_43":168,"_32":28,"_30":31,"_139":-5,"_41":42,"_40":14,"_141":58,"_38":169,"_13":170,"_33":34,"_35":37,"_24":25,"_145":-5,"_27":171},{"_43":162,"_32":163,"_30":164,"_139":-5,"_41":42,"_40":165,"_141":25,"_38":166,"_13":160,"_33":34,"_35":36,"_24":25,"_145":-5,"_27":167},{"_43":155,"_32":156,"_30":157,"_139":-5,"_41":42,"_40":158,"_141":25,"_38":159,"_13":160,"_33":34,"_35":36,"_24":25,"_145":-5,"_27":161},{"_43":147,"_32":148,"_30":56,"_139":-5,"_41":42,"_40":149,"_141":25,"_38":150,"_13":151,"_33":152,"_35":153,"_24":25,"_145":-5,"_27":154},{"_43":136,"_32":137,"_30":138,"_139":-5,"_41":42,"_40":140,"_141":25,"_38":142,"_13":143,"_33":34,"_35":144,"_24":25,"_145":-5,"_27":146},"345c57ec-ad20-4d15-b7f5-679338c9a349","pages.tsx","b47a1e66-8056-11f1-9d52-1607ee4eb77e","parentId",19,"latest",["D",1784124664357],2,"/** @jsx jsx */\n/** @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

Aktuelle News

Kommende Veranstaltungen

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

Gesetzliche Feiertage 2026

Verkaufsoffene Sonntage 2026

Ganzjährig sonntags geöffnet

Impressum

Datenschutzerklärung

{SITE_NAME}

Diff · v23