[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_178":179,"_180":181},"routes/_app.x.$handle.$name",{"_98":97,"_32":45,"_106":85,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":119,"_120":121,"_122":25,"_123":124,"_125":49,"_126":-5,"_127":-5,"_128":129},"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":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":78,"_79":80,"_81":82,"_83":25},"version",4,"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.tsx","latestPath","fileId","1e47167e-277e-11f0-b46e-569c3dd06744","name","fileType","http","content","import { delay } from \"https://deno.land/x/delay@v0.2.0/mod.ts\";\nimport { extractValInfo } from \"https://esm.town/v/pomdtr/extractValInfo\";\nimport { Statement, StatementInstance } from \"https://esm.town/v/postpostscript/sqliteBuilder\";\nimport { sqliteDump } from \"https://esm.town/v/postpostscript/sqliteDump\";\nimport { createSqlite } from \"https://esm.town/v/postpostscript/sqliteWasm\";\nimport type { InStatement } from \"https://esm.town/v/std/sqlite\";\nimport { toHonoHandler } from \"https://esm.town/v/vladimyr/toHonoHandler\";\nimport { type ResultSet } from \"npm:@libsql/client\";\nimport { Hono } from \"npm:hono\";\n\nconst dumped = {\n tables: [\"authIdExampleComments_comment\"],\n subset: {\n authIdExampleComments_comment:\n Statement`SELECT * FROM authIdExampleComments_comment WHERE username = \"postpostscript\"`,\n },\n};\n\nexport const sqlitePublic = {\n execute,\n batch,\n};\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${ENDPOINT}/execute`, {\n method: \"POST\",\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw new Error(await res.text());\n }\n return res.json();\n}\n\nasync function batch(statements: InStatement[]): Promise {\n const res = await fetch(`${ENDPOINT}/batch`, {\n method: \"POST\",\n body: JSON.stringify({ statements }),\n });\n if (!res.ok) {\n throw new Error(await res.text());\n }\n return res.json();\n}\n\nexport const { httpEndpoint: ENDPOINT } = extractValInfo(import.meta.url);\n\ntype SqliteDB = ReturnType;\n\nclass SqliteServer {\n constructor(\n private dbFactory: () => Promise,\n ) {}\n\n async handleExecute(req: Request) {\n const { statement } = await req.json();\n const sqlite = await this.dbFactory();\n const res = await sqlite.execute(statement);\n return Response.json(res);\n }\n\n async handleBatch(req: Request) {\n const { statements } = await req.json();\n const sqlite = await this.dbFactory();\n const res = await sqlite.batch(statements);\n return Response.json(res);\n }\n}\n\nconst sqliteServer = new SqliteServer(\n async () => {\n const dump = await sqliteDump(dumped);\n const sqlite = createSqlite();\n sqlite.batch(dump);\n return sqlite;\n },\n);\n\nconst app = new Hono();\napp.post(\"/execute\", toHonoHandler(sqliteServer.handleExecute));\napp.post(\"/batch\", toHonoHandler(sqliteServer.handleBatch));\nexport default app.fetch;","import { delay } from \"https://deno.land/x/delay@v0.2.0/mod.ts\";\nimport { extractValInfo } from \"https://esm.town/v/pomdtr/extractValInfo\";\nimport { Statement, StatementInstance } from \"https://esm.town/v/postpostscript/sqliteBuilder\";\nimport { sqliteDump } from \"https://esm.town/v/postpostscript/sqliteDump\";\nimport { createSqlite } from \"https://esm.town/v/postpostscript/sqliteWasm\";\nimport type { InStatement } from \"https://esm.town/v/std/sqlite\";\nimport { toHonoHandler } from \"https://esm.town/v/vladimyr/toHonoHandler\";\nimport { type ResultSet } from \"npm:@libsql/client\";\nimport { Hono } from \"npm:hono\";\n\nconst dumped = {\n tables: [\"authIdExampleComments_comment\"],\n subset: {\n authIdExampleComments_comment:\n Statement`SELECT * FROM authIdExampleComments_comment WHERE username = \"postpostscript\"`,\n },\n};\n\nexport const sqlitePublic = {\n execute,\n batch,\n};\n\nasync function execute(statement: InStatement): Promise {\n const res = await fetch(`${ENDPOINT}/execute`, {\n method: \"POST\",\n body: JSON.stringify({ statement }),\n });\n if (!res.ok) {\n throw new Error(await res.text());\n }\n return res.json();\n}\n\nasync function batch(statements: InStatement[]): Promise {\n const res = await fetch(`${ENDPOINT}/batch`, {\n method: \"POST\",\n body: JSON.stringify({ statements }),\n });\n if (!res.ok) {\n throw new Error(await res.text());\n }\n return res.json();\n}\n\nexport const { httpEndpoint: ENDPOINT } = extractValInfo(import.meta.url);\n\ntype SqliteDB = ReturnType;\n\nclass SqliteServer {\n constructor(\n private dbFactory: () => Promise,\n ) {}\n\n async handleExecute(req: Request) {\n const { statement } = await req.json();\n const sqlite = await this.dbFactory();\n const res = await sqlite.execute(statement);\n return Response.json(res);\n }\n\n async handleBatch(req: Request) {\n const { statements } = await req.json();\n const sqlite = await this.dbFactory();\n const res = await sqlite.batch(statements);\n return Response.json(res);\n }\n}\n\nconst sqliteServer = new SqliteServer(async () => {\n const dump = await sqliteDump(dumped);\n const sqlite = createSqlite();\n sqlite.batch(dump);\n return sqlite;\n});\n\nconst app = new Hono();\napp.post(\"/execute\", toHonoHandler(sqliteServer.handleExecute));\napp.post(\"/batch\", toHonoHandler(sqliteServer.handleBatch));\nexport default app.fetch;","createdAt",["D",1709873004037],"branchVersion","branchId","1e4253be-277e-11f0-b46e-569c3dd06744","id","1e420440-277e-11f0-b46e-569c3dd06744","sqlitePublic",["D",1746208307547],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","88c3d49e-6fe9-46c0-9133-ae5bac6940bd","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","5d2bf6b7-c427-467d-8bf6-994b2b39221c","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":55,"_102":103,"_104":25},"branch",{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":51,"_91":92,"_93":94,"_95":45,"_96":97},"isOwned",10,"main","projectId","forkedBranchId","65c1bda6-2760-11f0-86ff-569c3dd06744","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","65c17094-2760-11f0-86ff-569c3dd06744","forkedProjectOrgId","1073b191-f665-405d-9530-545465c93575","projectName","userHandle","vladimyr","handle","displayName","avatar","https://images.clerk.dev/oauth_github/img_2TYEBDWl6QE7Nsk4AHoXsDuwvBE.png","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":174,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":31,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":69,"_70":69,"_71":72,"_73":72,"_74":72,"_75":69,"_76":69,"_77":175,"_79":176,"_81":177,"_83":25},"tree",[165,166],"files",[165,166],"counts",{"_155":61,"_156":151,"_157":61,"_158":159,"_160":161},"contents",[139,140],"upstreamProject",{"_43":92,"_32":45,"_53":-5,"_54":-5,"_50":51,"_77":137},"upstreamBranch",{"_43":88,"_38":130,"_131":132,"_32":85,"_86":92,"_13":133,"_87":-5,"_89":-5,"_134":135,"_47":-5,"_83":25,"_50":51,"_96":136,"_62":94,"_95":45},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1746195542598],"updatedAt",["D",1709989854213],133,"lockfileKey","1755555072563-esm.town_v_postpostscript_sqlitePublic@133-main","postpostscript",{"_98":136,"_105":138},"https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJjdlhaRXl0WXVNSlhZcWU0ckI2c1BOMjNhQSJ9",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":49,"_38":152,"_13":61,"_33":20,"_35":153,"_24":25,"_146":-5,"_27":154},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":25,"_38":144,"_13":145,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":147},"1e5a64d6-277e-11f0-b46e-569c3dd06744","parentId","latest",["D",1709873004037],3,"label",[28],"1e471e4e-277e-11f0-b46e-569c3dd06744","README.md","1e471ee4-277e-11f0-b46e-569c3dd06744",1,["D",1709872249618],"Migrated from folder: a0_forks/sqlitePublic",[149],"pulls","branches","forks","envVars",{"_162":61,"_164":61},"connections",{"_162":61,"_163":61},"count","unfilledCount","emptyCount",{"_43":148,"_32":149,"_30":150,"_142":-5,"_41":42,"_40":151,"_143":49,"_38":171,"_13":61,"_33":20,"_35":153,"_24":25,"_146":-5,"_168":172,"_27":173},{"_43":141,"_32":28,"_30":31,"_142":-5,"_41":42,"_40":14,"_143":25,"_38":167,"_13":145,"_33":34,"_35":37,"_24":25,"_146":-5,"_168":169,"_27":170},["D",1709873004037],"children",[],[28],["D",1709872249618],[],[149],["D",1746208307547],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":25},{"_13":84,"_32":85,"_43":42,"_86":44,"_87":88,"_89":61,"_90":51,"_91":92,"_93":94,"_95":45,"_96":97},"ctx",{"_77":-5,"_127":211,"_212":213,"_214":215,"_216":25,"_217":25,"_218":25,"_219":49,"_220":-5,"_221":-7,"_222":-7,"_223":61,"_224":25,"_225":25,"_226":-5,"_227":25,"_228":25,"_229":25,"_230":-5},"ENV",{"_182":183,"_184":185,"_186":85,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202,"_203":204,"_205":206,"_207":208,"_209":210},"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 · v4