[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_193":194,"_195":196},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":88,"_27":55,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":25,"_120":121,"_122":60,"_123":-5,"_124":-5,"_125":126},"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":55,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":25},"version",82,"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","main.ts","latestPath","fileId","84f393f2-af6e-11f0-a165-0224a6c84d84","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite2@3-main/main.tsx\";\n\nconst TABLE_NAME = \"sqlfs_files\";\n\nexport const sqlfs = {\n /**\n * Write a new file to the sqlfs file system. Overwrites\n * files if they already exist.\n */\n async writeFileText(path: string, content: string): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLE_NAME} (path, content) VALUES (?, ?) ON CONFLICT DO UPDATE SET content = ?`,\n args: [path, content, content],\n });\n },\n /**\n * Read a file from the sqlfs file system. Throws NotFoundError\n * if the file does not exist.\n */\n async readFileText(path: string): Promise {\n const { rows: [file] } = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAME} WHERE path = ?`,\n args: [path],\n });\n if (!file) {\n throw new Deno.errors.NotFound(`No such file or directory ${path}`);\n }\n return file.content as string;\n },\n /**\n * Remove a file from the sqlfs file system. Only works for files\n * right now, does nothing for directories.\n */\n async remove(path: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE_NAME} WHERE path = ?`,\n args: [path],\n });\n },\n\n /**\n * Non-standard method for debugging purposes only.\n */\n async _listAllFiles(): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT path FROM ${TABLE_NAME};`,\n args: [],\n });\n return rows.map((r) => r.path as string);\n },\n};\n\nconsole.log(await sqlfs.writeFileText(\"canary.txt\", \"hi\"));\nconsole.log(await sqlfs._listAllFiles());\n\nif (\n Deno.env.get(\"VALTOWN_ENTRYPOINT\")?.startsWith(\n \"https://esm.town/v/tmcw/sqlfs\",\n )\n) {\n // The current reference version of sqlfs\n const VERSION = 0;\n // Figure out what the latest migrated version is for this installation\n await sqlite.execute(\"CREATE TABLE IF NOT EXISTS sqlfs_meta (version int)\");\n const { rows: [{ m }] } = await sqlite.execute(\n \"SELECT coalesce(max(version), 0) as m from sqlfs_meta;\",\n );\n if (m as number < 1) {\n console.log(\"migration 1\");\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (path TEXT PRIMARY KEY, content TEXT)`,\n );\n await sqlite.execute(\n \"INSERT INTO sqlfs_meta (version) VALUES (1);\",\n );\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite2@3-main/main.tsx\";\n\nconst TABLE_NAME = \"sqlfs_files\";\n\nexport const sqlfs = {\n /**\n * Write a new file to the sqlfs file system. Overwrites\n * files if they already exist.\n */\n async writeFileText(path: string, content: string): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO ${TABLE_NAME} (path, content) VALUES (?, ?) ON CONFLICT DO UPDATE SET content = ?`,\n args: [path, content, content],\n });\n },\n /**\n * Read a file from the sqlfs file system. Throws NotFoundError\n * if the file does not exist.\n */\n async readFileText(path: string): Promise {\n const { rows: [file] } = await sqlite.execute({\n sql: `SELECT * FROM ${TABLE_NAME} WHERE path = ?`,\n args: [path],\n });\n if (!file) {\n throw new Deno.errors.NotFound(`No such file or directory ${path}`);\n }\n return file.content as string;\n },\n /**\n * Remove a file from the sqlfs file system. Only works for files\n * right now, does nothing for directories.\n */\n async remove(path: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${TABLE_NAME} WHERE path = ?`,\n args: [path],\n });\n },\n\n /**\n * Non-standard method for debugging purposes only.\n */\n async _listAllFiles(): Promise {\n const { rows } = await sqlite.execute({\n sql: `SELECT path FROM ${TABLE_NAME};`,\n args: [],\n });\n return rows.map((r) => r.path as string);\n },\n};\n\nconsole.log(await sqlfs.writeFileText(\"canary.txt\", \"hi\"));\nconsole.log(await sqlfs.writeFileText(\"canary.html\", \"

hi

\"));\nconsole.log(await sqlfs._listAllFiles());\n\nif (\n Deno.env.get(\"VALTOWN_ENTRYPOINT\")?.startsWith(\n \"https://esm.town/v/tmcw/sqlfs\",\n )\n) {\n // The current reference version of sqlfs\n const VERSION = 0;\n // Figure out what the latest migrated version is for this installation\n await sqlite.execute(\"CREATE TABLE IF NOT EXISTS sqlfs_meta (version int)\");\n const { rows: [{ m }] } = await sqlite.execute(\n \"SELECT coalesce(max(version), 0) as m from sqlfs_meta;\",\n );\n if (m as number < 1) {\n console.log(\"migration 1\");\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS ${TABLE_NAME} (path TEXT PRIMARY KEY, content TEXT)`,\n );\n await sqlite.execute(\n \"INSERT INTO sqlfs_meta (version) VALUES (1);\",\n );\n }\n}","createdAt",["D",1761158634795],"branchVersion","branchId","84f0250a-af6e-11f0-a165-0224a6c84d84","id","84efa544-af6e-11f0-a165-0224a6c84d84","sqlfs",["D",1761154965998],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","SQLite as a file system","imageUrl","","19892fed-baf3-41fb-a5cc-96c80e95edec","pinnedFileId","01694548-af75-11f0-8e33-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","f407f111-fdbb-4126-923f-44aed4d9e9ad","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},"branch",{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"isOwned",96,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","tmcw","handle","displayName","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/7935dc1b-7699-4095-366a-2e9103307501/square512?exp=1789541999&sig=89d546164584caf98832cd903579aa2647e5eaaea1875620706ec3ce00a3fc88","tier","pro","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_43":44,"_32":45,"_38":189,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":55,"_18":56,"_57":58,"_59":60,"_61":60,"_62":-5,"_63":64,"_65":66,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":190,"_82":191,"_84":192,"_86":25},"tree",[172,173,174,175],"files",[172,173,174,175],"counts",{"_161":64,"_162":163,"_164":64,"_165":166,"_167":168},"contents",[127,128,129,130],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":153,"_32":154,"_30":58,"_134":-5,"_41":42,"_40":155,"_136":60,"_38":156,"_13":157,"_33":158,"_35":159,"_24":25,"_140":-5,"_27":160},{"_43":150,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":151,"_13":135,"_33":34,"_35":37,"_24":25,"_140":-5,"_27":152},{"_43":142,"_32":143,"_30":144,"_134":-5,"_41":42,"_40":145,"_136":25,"_38":146,"_13":147,"_33":34,"_35":148,"_24":25,"_140":-5,"_27":149},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":60,"_38":137,"_13":138,"_33":34,"_35":139,"_24":25,"_140":-5,"_27":141},"ab006324-af71-11f0-929d-0224a6c84d84","test.ts","edaf538e-af70-11f0-83d6-0224a6c84d84","parentId",41,"latest",["D",1761156318338],8,"import { assertEquals, assertRejects } from \"jsr:@std/assert\";\nimport { sqlfs } from \"./main.ts\";\n\nawait assertRejects(() => sqlfs.readFileText(\"DOES_NOT_EXIST\"));\nconst time = Date.now().toString();\nawait sqlfs.writeFileText(\"time\", time);\nassertEquals(await sqlfs.readFileText(\"time\"), time);\nawait sqlfs.remove(\"time\");\nawait assertRejects(() => sqlfs.readFileText(\"time\"));\n\nconsole.log(\"🤘 Tests passed\");","label",[132],"bb6dca76-af76-11f0-b058-0224a6c84d84","serve-static.ts","6cef3068-af73-11f0-9aaf-0224a6c84d84",74,["D",1761158493375],17,"import {\n serveStatic as baseServeStatic,\n type ServeStaticOptions,\n} from \"npm:hono/serve-static\";\nimport { sqlfs } from \"./main.ts\";\n\nexport const serveStatic = (opts: ServeStaticOptions) => {\n return (c, next) => {\n return baseServeStatic({\n ...opts,\n getContent: async (path: string) => {\n console.log(\"gettng\", path);\n try {\n const str = await sqlfs.readFileText(path);\n return str;\n } catch (e) {\n console.error(e);\n return null;\n }\n },\n })(c, next);\n };\n};",[143],"0fb6b296-af77-11f0-8598-0224a6c84d84",["D",1761158634795],[28],"b32f7a6c-af76-11f0-b830-0224a6c84d84","example-server.ts",73,["D",1761158479555],12,"http","import { Hono } from \"npm:hono\";\nimport { serveStatic } from \"./serve-static.ts\";\nconst app = new Hono();\n\napp.use(\n \"/static/*\",\n serveStatic({\n root: \"./\",\n rewriteRequestPath: (path) => path.replace(/^\\/static/, \"\"),\n }),\n);\n\nexport default app.fetch;",[154],"pulls","branches",1,"forks","envVars",{"_169":64,"_171":64},"connections",{"_169":64,"_170":64},"count","unfilledCount","emptyCount",{"_43":153,"_32":154,"_30":58,"_134":-5,"_41":42,"_40":155,"_136":60,"_38":186,"_13":157,"_33":158,"_35":159,"_24":25,"_140":-5,"_177":187,"_27":188},{"_43":150,"_32":28,"_30":31,"_134":-5,"_41":42,"_40":14,"_136":25,"_38":183,"_13":135,"_33":34,"_35":37,"_24":25,"_140":-5,"_177":184,"_27":185},{"_43":142,"_32":143,"_30":144,"_134":-5,"_41":42,"_40":145,"_136":25,"_38":180,"_13":147,"_33":34,"_35":148,"_24":25,"_140":-5,"_177":181,"_27":182},{"_43":131,"_32":132,"_30":133,"_134":-5,"_41":42,"_40":135,"_136":60,"_38":176,"_13":138,"_33":34,"_35":139,"_24":25,"_140":-5,"_177":178,"_27":179},["D",1761156318338],"children",[],[132],["D",1761158493375],[],[143],["D",1761158634795],[],[28],["D",1761158479555],[],[154],["D",1761154965998],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":56,"_102":103,"_104":25},{"_13":87,"_32":88,"_43":42,"_89":44,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":45,"_96":97},"ctx",{"_80":-5,"_124":226,"_227":228,"_229":230,"_231":25,"_232":25,"_233":25,"_234":60,"_235":-5,"_236":-7,"_237":-7,"_238":64,"_239":25,"_240":25,"_241":-5,"_242":25,"_243":25,"_244":25,"_245":-5},"ENV",{"_197":198,"_199":200,"_201":88,"_202":203,"_204":205,"_206":207,"_208":209,"_210":211,"_212":213,"_214":215,"_216":217,"_218":219,"_220":221,"_222":223,"_224":225},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · v82