\n \n …\n ·source\n

\n\n

Switched view

\n\n

\n \n Listening\n \n \n

\n \n

\n\n

\n\n \n\n\n",[],[76,152],["D",1778813991894],[161,162],[82],{"_37":171,"_13":172,"_40":173,"_42":83,"_43":44,"_45":84,"_47":48,"_49":174,"_17":51,"_52":111,"_54":175,"_56":57,"_58":-5,"_93":176,"_18":177},{"_37":163,"_13":164,"_40":165,"_42":83,"_43":44,"_45":166,"_47":48,"_49":167,"_17":51,"_52":111,"_54":168,"_56":57,"_58":-5,"_93":169,"_18":170},"34c47ae4-500a-11f1-a435-ee650bb23af1","queries.ts","34c47bb6-500a-11f1-a435-ee650bb23af1",3,["D",1778814019030],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport interface ViewSummary {\n name: string;\n description: string | null;\n updated_at: string;\n current_version_id: number | null;\n}\n\nexport interface Version {\n id: number;\n view_name: string;\n html: string;\n description: string | null;\n created_at: string;\n}\n\nexport interface Rule {\n id: number;\n view_name: string;\n start_time: string;\n end_time: string;\n description: string | null;\n enabled: number;\n created_at: string;\n}\n\nconst ROW = (rows: any[]): T[] => rows as T[];\n\nexport async function listViews(): Promise {\n const r = await sqlite.execute(\n `SELECT name, description, updated_at, current_version_id\n FROM views ORDER BY updated_at DESC`,\n );\n return ROW(r.rows);\n}\n\nexport async function getView(name: string): Promise<\n { view: ViewSummary; latest: Version | null } | null\n> {\n const v = await sqlite.execute({\n sql:\n \"SELECT name, description, updated_at, current_version_id FROM views WHERE name = ?\",\n args: [name],\n });\n if (v.rows.length === 0) return null;\n const view = v.rows[0] as unknown as ViewSummary;\n let latest: Version | null = null;\n if (view.current_version_id) {\n const ver = await sqlite.execute({\n sql: \"SELECT * FROM versions WHERE id = ?\",\n args: [view.current_version_id],\n });\n if (ver.rows.length > 0) latest = ver.rows[0] as unknown as Version;\n }\n return { view, latest };\n}\n\n/**\n * Save a new version of a view. Creates the view if it doesn't exist.\n * Returns the new version id.\n */\nexport async function saveView(\n name: string,\n html: string,\n description: string | null = null,\n): Promise<{ versionId: number; created: boolean }> {\n const existing = await sqlite.execute({\n sql: \"SELECT name FROM views WHERE name = ?\",\n args: [name],\n });\n const created = existing.rows.length === 0;\n\n if (created) {\n await sqlite.execute({\n sql: \"INSERT INTO views (name, description) VALUES (?, ?)\",\n args: [name, description],\n });\n } else {\n await sqlite.execute({\n sql:\n \"UPDATE views SET updated_at = datetime('now'), description = COALESCE(?, description) WHERE name = ?\",\n args: [description, name],\n });\n }\n\n const ins = await sqlite.execute({\n sql:\n \"INSERT INTO versions (view_name, html, description) VALUES (?, ?, ?) RETURNING id\",\n args: [name, html, description],\n });\n const versionId = ins.rows[0]?.id as number;\n\n await sqlite.execute({\n sql: \"UPDATE views SET current_version_id = ? WHERE name = ?\",\n args: [versionId, name],\n });\n return { versionId, created };\n}\n\nexport async function listVersions(viewName: string): Promise {\n const r = await sqlite.execute({\n sql:\n `SELECT id, view_name, description, created_at, substr(html, 1, 0) as html\n FROM versions WHERE view_name = ? ORDER BY created_at DESC LIMIT 50`,\n args: [viewName],\n });\n return ROW(r.rows);\n}\n\nexport async function revertView(\n viewName: string,\n versionId: number,\n): Promise {\n const v = await sqlite.execute({\n sql: \"SELECT id FROM versions WHERE id = ? AND view_name = ?\",\n args: [versionId, viewName],\n });\n if (v.rows.length === 0) return false;\n await sqlite.execute({\n sql:\n \"UPDATE views SET current_version_id = ?, updated_at = datetime('now') WHERE name = ?\",\n args: [versionId, viewName],\n });\n return true;\n}\n\nexport async function getActiveView(): Promise {\n const r = await sqlite.execute(\n \"SELECT value FROM state WHERE key = 'active_view'\",\n );\n return (r.rows[0]?.value as string) || \"Welcome\";\n}\n\nexport async function setActiveView(name: string): Promise {\n const v = await sqlite.execute({\n sql: \"SELECT name FROM views WHERE name = ?\",\n args: [name],\n });\n if (v.rows.length === 0) return false;\n await sqlite.execute({\n sql:\n \"INSERT INTO state (key, value, updated_at) VALUES ('active_view', ?, datetime('now')) \" +\n \"ON CONFLICT(key) DO UPDATE SET value = excluded.value, updated_at = excluded.updated_at\",\n args: [name],\n });\n return true;\n}\n\nexport async function listRules(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM rules WHERE enabled = 1 ORDER BY start_time\",\n );\n return ROW(r.rows);\n}\n\nexport async function addRule(\n viewName: string,\n startTime: string,\n endTime: string,\n description: string | null = null,\n): Promise {\n const v = await sqlite.execute({\n sql: \"SELECT name FROM views WHERE name = ?\",\n args: [viewName],\n });\n if (v.rows.length === 0) throw new Error(`View not found: ${viewName}`);\n const r = await sqlite.execute({\n sql:\n \"INSERT INTO rules (view_name, start_time, end_time, description) VALUES (?, ?, ?, ?) RETURNING id\",\n args: [viewName, startTime, endTime, description],\n });\n return r.rows[0]?.id as number;\n}\n\nexport async function deleteRule(id: number): Promise {\n const r = await sqlite.execute({\n sql: \"DELETE FROM rules WHERE id = ?\",\n args: [id],\n });\n return r.rowsAffected > 0;\n}\n\n/** Returns the view name that should be displayed right now, given active rules. */\nexport async function applicableRuleView(\n now: Date = new Date(),\n): Promise {\n const hh = String(now.getHours()).padStart(2, \"0\");\n const mm = String(now.getMinutes()).padStart(2, \"0\");\n const cur = `${hh}:${mm}`;\n const rules = await listRules();\n // Find a rule whose [start, end) window contains `cur`. Supports overnight rules where end < start.\n for (const r of rules) {\n if (r.start_time <= r.end_time) {\n if (cur >= r.start_time && cur < r.end_time) return r.view_name;\n } else {\n // Overnight (e.g., 22:00 -> 06:00)\n if (cur >= r.start_time || cur < r.end_time) return r.view_name;\n }\n }\n return null;\n}\n",[],[82,164],"2498050a-500a-11f1-bc46-ee650bb23af1","migrations.ts","249805f0-500a-11f1-bc46-ee650bb23af1",["D",1778813991894],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nconst SCHEMA_VERSION = 1;\n\nexport async function migrate() {\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS schema_migrations (\n version INTEGER PRIMARY KEY\n )\n `);\n\n const result = await sqlite.execute(\n \"SELECT version FROM schema_migrations ORDER BY version DESC LIMIT 1\",\n );\n const current = result.rows[0]?.version as number ?? 0;\n if (current >= SCHEMA_VERSION) return;\n\n if (current < 1) {\n await sqlite.batch([\n {\n sql: `CREATE TABLE views (\n name TEXT PRIMARY KEY,\n description TEXT,\n current_version_id INTEGER,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE versions (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n view_name TEXT NOT NULL,\n html TEXT NOT NULL,\n description TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (view_name) REFERENCES views(name) ON DELETE CASCADE\n )`,\n args: [],\n },\n {\n sql: `CREATE INDEX idx_versions_view ON versions(view_name, created_at DESC)`,\n args: [],\n },\n {\n sql: `CREATE TABLE rules (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n view_name TEXT NOT NULL,\n start_time TEXT NOT NULL,\n end_time TEXT NOT NULL,\n description TEXT,\n enabled INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n FOREIGN KEY (view_name) REFERENCES views(name) ON DELETE CASCADE\n )`,\n args: [],\n },\n {\n sql: `CREATE TABLE state (\n key TEXT PRIMARY KEY,\n value TEXT NOT NULL,\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n args: [],\n },\n { sql: \"INSERT INTO schema_migrations (version) VALUES (1)\", args: [] },\n ]);\n console.log(\"✅ migrated to schema v1\");\n }\n\n // Seed default welcome view if nothing exists yet\n const seeded = await sqlite.execute(\"SELECT COUNT(*) as c FROM views\");\n if ((seeded.rows[0]?.c as number) === 0) {\n await seedWelcomeView();\n }\n}\n\nasync function seedWelcomeView() {\n const welcome = `\n\n\n\n\n\n\n

Welcome 👋

This is your voice-controlled dashboard. Tap the mic to start.

Tap the floating mic button

\n Bottom-right of the screen. You'll be asked for mic access.\n

Just talk

\n \"Make me a Pomodoro timer.\" \"Show the weather in São Paulo.\" \"Build a habit tracker.\"\n

Iterate

\n \"Add a checklist.\" \"Make it darker.\" \"Switch to my recipe view.\"\n

\n 💡 Every view is named and version-history is preserved. Ask the agent to list your views\n or set a morning rule like \"always show my focus view between 7 and 11 AM.\"\n

\n\n`;\n\n await sqlite.batch([\n {\n sql:\n \"INSERT INTO views (name, description) VALUES ('Welcome', 'Default landing view')\",\n args: [],\n },\n {\n sql:\n \"INSERT INTO versions (view_name, html, description) VALUES (?, ?, ?)\",\n args: [\"Welcome\", welcome, \"Initial welcome view\"],\n },\n ]);\n const v = await sqlite.execute(\n \"SELECT id FROM versions WHERE view_name = 'Welcome'\",\n );\n const versionId = v.rows[0]?.id;\n await sqlite.execute({\n sql: \"UPDATE views SET current_version_id = ? WHERE name = 'Welcome'\",\n args: [versionId as any],\n });\n await sqlite.execute({\n sql: \"INSERT INTO state (key, value) VALUES ('active_view', ?)\",\n args: [\"Welcome\"],\n });\n console.log(\"✅ seeded Welcome view\");\n}\n",[],[82,172],"0d024bc6-500a-11f1-bd98-ee650bb23af1",["D",1778813952334],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Voice-controlled full-screen dashboard with OpenAI Realtime.","imageUrl","userId","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","orgId","d663a026-6449-42f6-9156-1d4a2d64d38c","tursoName","0d024bc6500a11f1bd98ee650bb23af1","tursoHostname","0d024bc6500a11f1bd98ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789689063122],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_235":231},"org",{"_11":12,"_228":229,"_230":231,"_188":189,"_232":233,"_234":57},"branch",{"_17":126,"_13":16,"_37":44,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789705397&sig=e00bd7625d4d9fe8debbf30dc7267c6f38003a367b0346bf98ca4c3cf57c89f3","tier","pro","canRestrictVals","profileImageUrl","adoptOrgId",{"_37":178,"_13":14,"_49":312,"_180":-5,"_181":57,"_182":183,"_184":183,"_185":186,"_187":-5,"_188":189,"_190":125,"_191":48,"_192":-5,"_193":-5,"_194":51,"_195":196,"_197":198,"_199":200,"_201":313,"_203":-5,"_204":205,"_206":205,"_207":208,"_209":208,"_210":208,"_211":205,"_212":205,"_213":314,"_215":315,"_217":316,"_219":57},[273,276,278,284,285],"files",[273,274,275,276,277,278,279,280,281,282,283,284,285],"counts",{"_264":51,"_265":65,"_266":65,"_31":267,"_268":269},[254,255,256,257,258],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_37":81,"_13":82,"_40":83,"_42":-5,"_43":44,"_45":84,"_47":48,"_49":85,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":263},{"_37":75,"_13":76,"_40":77,"_42":-5,"_43":44,"_45":78,"_47":48,"_49":79,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":262},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":72,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_18":261},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":64,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_18":260},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":50,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_18":259},[39],[61],[69],[76],[82],"pulls","branches","forks",{"_270":51,"_272":51},"connections",{"_270":51,"_271":51},"count","unfilledCount","emptyCount",{"_37":81,"_13":82,"_40":83,"_42":-5,"_43":44,"_45":84,"_47":48,"_49":158,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":310,"_18":311},{"_37":171,"_13":172,"_40":173,"_42":83,"_43":44,"_45":84,"_47":48,"_49":174,"_17":51,"_52":111,"_54":175,"_56":57,"_58":-5,"_93":308,"_18":309},{"_37":163,"_13":164,"_40":165,"_42":83,"_43":44,"_45":166,"_47":48,"_49":167,"_17":51,"_52":111,"_54":168,"_56":57,"_58":-5,"_93":306,"_18":307},{"_37":75,"_13":76,"_40":77,"_42":-5,"_43":44,"_45":78,"_47":48,"_49":147,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":304,"_18":305},{"_37":151,"_13":152,"_40":153,"_42":77,"_43":44,"_45":78,"_47":48,"_49":154,"_17":51,"_52":24,"_54":155,"_56":57,"_58":-5,"_93":302,"_18":303},{"_37":68,"_13":69,"_40":70,"_42":-5,"_43":44,"_45":71,"_47":48,"_49":99,"_17":51,"_52":73,"_54":-5,"_56":57,"_58":-5,"_93":300,"_18":301},{"_37":139,"_13":140,"_40":141,"_42":70,"_43":44,"_45":142,"_47":48,"_49":143,"_17":51,"_52":111,"_54":144,"_56":57,"_58":-5,"_93":298,"_18":299},{"_37":131,"_13":132,"_40":133,"_42":70,"_43":44,"_45":134,"_47":48,"_49":135,"_17":51,"_52":53,"_54":136,"_56":57,"_58":-5,"_93":296,"_18":297},{"_37":123,"_13":124,"_40":125,"_42":70,"_43":44,"_45":126,"_47":48,"_49":127,"_17":65,"_52":53,"_54":128,"_56":57,"_58":-5,"_93":294,"_18":295},{"_37":115,"_13":116,"_40":117,"_42":70,"_43":44,"_45":118,"_47":48,"_49":119,"_17":51,"_52":53,"_54":120,"_56":57,"_58":-5,"_93":292,"_18":293},{"_37":107,"_13":108,"_40":109,"_42":70,"_43":44,"_45":71,"_47":48,"_49":110,"_17":51,"_52":111,"_54":112,"_56":57,"_58":-5,"_93":290,"_18":291},{"_37":60,"_13":61,"_40":62,"_42":-5,"_43":44,"_45":63,"_47":48,"_49":96,"_17":65,"_52":24,"_54":66,"_56":57,"_58":-5,"_93":288,"_18":289},{"_37":38,"_13":39,"_40":41,"_42":-5,"_43":44,"_45":46,"_47":48,"_49":92,"_17":51,"_52":53,"_54":55,"_56":57,"_58":-5,"_93":286,"_18":287},[],[39],[],[61],[],[69,108],[],[69,116],[],[69,124],[],[69,132],[],[69,140],[279,280,281,282,283],[69],[],[76,152],[277],[76],[],[82,164],[],[82,172],[274,275],[82],["D",1778813952334],["D",1789689063122],{"_11":12,"_235":231},{"_11":12,"_228":229,"_230":231,"_188":189,"_232":233,"_234":57},{"_17":126,"_13":16,"_37":44,"_220":178,"_221":-5,"_222":-5,"_223":-5,"_224":-5,"_225":-5,"_226":14,"_227":12},"ctx",{"_213":-5,"_251":350,"_351":352,"_353":354,"_355":57,"_356":57,"_357":57,"_358":48,"_359":-5,"_360":-7,"_361":-7,"_362":51,"_363":57,"_364":57,"_365":-5,"_366":57,"_367":57,"_368":57,"_369":-5},"ENV",{"_321":322,"_323":324,"_325":16,"_326":327,"_328":329,"_330":331,"_332":333,"_334":335,"_336":337,"_338":339,"_340":341,"_342":343,"_344":345,"_346":347,"_348":349},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","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"]

Code