[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_180":181,"_182":183},"routes/_app.x.$handle.$name",{"_105":104,"_32":50,"_114":95,"_27":115,"_13":14,"_116":-5,"_11":117,"_118":119,"_120":121,"_122":123,"_124":125,"_21":-5,"_126":-5,"_127":-5,"_128":25,"_129":130,"_131":25,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_48":49,"_32":50,"_36":51,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":25},"version",2,"changes",[19,20],"aiChatInfo","userId",{"_21":41,"_23":-7,"_24":25,"_26":25,"_27":42,"_29":42},{"_21":22,"_23":-7,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":-5,"_36":37,"_38":14,"_39":40,"_24":25},"previous","deleted",false,"deletedHere","path","database","latestPath","fileId","eda436de-e650-468d-ab28-242ac8c6848e","name","fileType","directory","content","createdAt",["D",1778813991894],"branchVersion","branchId","0d02f72e-500a-11f1-bd98-ee650bb23af1",{"_30":43,"_32":44,"_33":45,"_35":46,"_36":47,"_38":14,"_39":40,"_24":25},"database/migrations.ts","249805f0-500a-11f1-bc46-ee650bb23af1","migrations.ts","script","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",["D",1778813991894],"id","0d024bc6-500a-11f1-bd98-ee650bb23af1","voice-dashboard",["D",1778813952334],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Voice-controlled full-screen dashboard with OpenAI Realtime.","imageUrl","9319c175-2593-4f88-ba21-04f2ef7b1c28","pinnedFileId","63e7ac4c-500a-11f1-9803-ee650bb23af1","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"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",{"_105":104,"_113":109},"org",{"_105":104,"_106":107,"_108":109,"_18":60,"_110":111,"_112":25},"branch",{"_13":94,"_32":95,"_48":40,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",12,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","dcm31","handle","displayName","Charlie","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/3e904faa-3764-4629-c475-f561a49b0000/square512?exp=1789733074&sig=3ab6e7f0651652f76d395d1319d3233a3d0b270b72c4f55b7999bec492b45245","tier","pro","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_32":50,"_36":175,"_52":-5,"_53":25,"_54":55,"_56":55,"_57":58,"_59":-5,"_18":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":176,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":177,"_89":178,"_91":179,"_93":25},"tree",[161,163],"files",[161,162,163],"counts",{"_151":68,"_152":142,"_153":142,"_154":155,"_156":157},"contents",[136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":148,"_32":28,"_30":31,"_141":-5,"_39":40,"_38":14,"_143":64,"_36":149,"_13":68,"_33":34,"_35":-5,"_24":25,"_146":-5,"_27":150},{"_48":138,"_32":139,"_30":140,"_141":-5,"_39":40,"_38":142,"_143":25,"_36":144,"_13":68,"_33":21,"_35":145,"_24":25,"_146":-5,"_27":147},"0d05c35a-500a-11f1-bd98-ee650bb23af1","README.md","0d05c418-500a-11f1-bd98-ee650bb23af1","parentId",1,"latest",["D",1778813952347],"# voice-dashboard\n\nFull-screen dashboard customized by voice. WIP.","label",[139],"24984f88-500a-11f1-bc46-ee650bb23af1",["D",1778813991894],[28],"pulls","branches","forks","envVars",{"_158":68,"_160":68},"connections",{"_158":68,"_159":68},"count","unfilledCount","emptyCount",{"_48":148,"_32":28,"_30":31,"_141":-5,"_39":40,"_38":14,"_143":64,"_36":172,"_13":68,"_33":34,"_35":-5,"_24":25,"_146":-5,"_165":173,"_27":174},{"_48":168,"_32":44,"_30":43,"_141":31,"_39":40,"_38":14,"_143":64,"_36":169,"_13":68,"_33":45,"_35":46,"_24":25,"_146":-5,"_165":170,"_27":171},{"_48":138,"_32":139,"_30":140,"_141":-5,"_39":40,"_38":142,"_143":25,"_36":164,"_13":68,"_33":21,"_35":145,"_24":25,"_146":-5,"_165":166,"_27":167},["D",1778813952347],"children",[],[139],"2498050a-500a-11f1-bc46-ee650bb23af1",["D",1778813991894],[],[28,44],["D",1778813991894],[162],[28],["D",1778813952334],["D",1789689063122],{"_105":104,"_113":109},{"_105":104,"_106":107,"_108":109,"_18":60,"_110":111,"_112":25},{"_13":94,"_32":95,"_48":40,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_133":213,"_214":215,"_216":217,"_218":25,"_219":25,"_220":25,"_221":64,"_222":-5,"_223":-7,"_224":-7,"_225":68,"_226":25,"_227":25,"_228":-5,"_229":25,"_230":25,"_231":25,"_232":-5},"ENV",{"_184":185,"_186":187,"_188":95,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210,"_211":212},"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"]

Diff · v2