[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_163":164,"_165":166},"routes/_app.x.$handle.$name",{"_93":92,"_32":45,"_101":83,"_27":102,"_13":14,"_103":-5,"_11":104,"_105":106,"_107":108,"_109":110,"_111":112,"_20":-5,"_113":-5,"_114":-5,"_115":25,"_116":117,"_118":25,"_119":-5,"_120":-5,"_121":122},"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":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":77,"_78":79,"_80":81,"_82":25},"version",12,"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","53f7ca04-2781-11f0-b46e-569c3dd06744","name","fileType","script","content","import type { CompiledQuery, DatabaseConnection, Dialect, QueryResult, Selectable } from 'npm:kysely';\nimport { Kysely } from 'npm:kysely';\nimport { DummyDriver, SqliteAdapter, SqliteIntrospector, SqliteQueryCompiler } from 'npm:kysely';\nimport SqlString from 'npm:sqlstring';\n\nimport { db as restdriver } from 'https://esm.town/v/sqlite/db';\n\ninterface Database {\n vals: ValsTable;\n}\ninterface ValsTable {\n id: string;\n name: string;\n code: string;\n version: number;\n type: 'script' | 'rpc' | 'interval' | 'httpnext' | 'http' | 'express' | 'email';\n privacy: 'public';\n created_at: string;\n author_id: string;\n author_username: string;\n}\ntype Val = Selectable;\n\nclass VTDriver extends DummyDriver {\n async acquireConnection(): Promise {\n return new VTConnection();\n }\n}\nclass VTConnection implements DatabaseConnection {\n async executeQuery(compiledQuery: CompiledQuery): Promise> {\n console.log(compiledQuery);\n const formattedQuery = SqlString.format(compiledQuery.sql, compiledQuery.parameters);\n console.log(formattedQuery);\n const { columns, rows } = await restdriver.execute(formattedQuery) as any;\n const res = { rows: rows.map( row => Object.fromEntries( row.map((v, i) => [columns[i], v]) ) ) };\n return Promise.resolve(res);\n }\n\n async *streamQuery(): AsyncIterableIterator> {\n throw new Error('streamQuery not implemented');\n }\n}\n\nconst dialect: Dialect = {\n createAdapter: () => new SqliteAdapter(),\n createDriver: () => new VTDriver(),\n createIntrospector: (db) => new SqliteIntrospector(db),\n createQueryCompiler: () => new SqliteQueryCompiler(),\n};\n\nexport const vtdb = new Kysely({ dialect });\nexport default vtdb;","import type { CompiledQuery, DatabaseConnection, Dialect, QueryResult, Selectable } from 'npm:kysely';\nimport { Kysely } from 'npm:kysely';\nimport { DummyDriver, SqliteAdapter, SqliteIntrospector, SqliteQueryCompiler } from 'npm:kysely';\nimport SqlString from 'npm:sqlstring';\n\nimport { db as restdriver } from 'https://esm.town/v/sqlite/db';\n\ninterface Database {\n vals: ValsTable;\n}\ninterface ValsTable {\n id: string;\n name: string;\n code: string;\n version: number;\n type: 'script' | 'rpc' | 'interval' | 'httpnext' | 'http' | 'express' | 'email';\n privacy: 'public';\n created_at: string;\n author_id: string;\n author_username: string;\n}\ntype Val = Selectable;\n\nclass VTDriver extends DummyDriver {\n async acquireConnection(): Promise {\n return new VTConnection();\n }\n}\nclass VTConnection implements DatabaseConnection {\n async executeQuery(compiledQuery: CompiledQuery): Promise> {\n const formattedQuery = SqlString.format(compiledQuery.sql, compiledQuery.parameters);\n const { columns, rows } = await restdriver.execute(formattedQuery) as any;\n const res = { rows: rows.map( row => Object.fromEntries( row.map((v, i) => [columns[i], v]) ) ) };\n return Promise.resolve(res);\n }\n\n async *streamQuery(): AsyncIterableIterator> {\n throw new Error('streamQuery not implemented');\n }\n}\n\nconst dialect: Dialect = {\n createAdapter: () => new SqliteAdapter(),\n createDriver: () => new VTDriver(),\n createIntrospector: (db) => new SqliteIntrospector(db),\n createQueryCompiler: () => new SqliteQueryCompiler(),\n};\n\nexport const vtdb = new Kysely({ dialect });\nexport default vtdb;","createdAt",["D",1739056486526],"branchVersion","branchId","53f4c520-2781-11f0-b46e-569c3dd06744","id","53f476b0-2781-11f0-b46e-569c3dd06744","vtdb",["D",1746209686126],"deletedAt","legacyEnvVars",true,"privacy","public","httpPrivacy","description","imageUrl","8d6857d3-cf1c-4e98-a094-0e379c10badf","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",6,"orgId","4f4797d6-1767-45ca-8dc5-5113174ca1c1","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","valPerm","blobPerm","emailPerm","sqlitePerm","projectPerm","telemetryPerm","r","user",{"_93":92,"_100":96},"org",{"_93":92,"_94":-5,"_95":96,"_18":55,"_97":98,"_99":25},"branch",{"_13":14,"_32":83,"_43":42,"_84":44,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":45,"_91":92},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","g","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJqRlBqSjdFTUlTVmVORmpObmFqZmJLVWh5VCJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_43":44,"_32":45,"_38":159,"_47":-5,"_48":49,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":49,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":-5,"_67":-5,"_68":-5,"_69":-5,"_70":-5,"_71":-5,"_72":-5,"_73":-5,"_74":75,"_76":160,"_78":161,"_80":162,"_82":25},"tree",[150,151],"files",[150,151],"counts",{"_140":137,"_141":135,"_142":137,"_143":144,"_145":146},"contents",[123,124],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":132,"_32":133,"_30":134,"_126":-5,"_41":42,"_40":135,"_127":49,"_38":136,"_13":137,"_33":20,"_35":138,"_24":25,"_130":-5,"_27":139},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":49,"_38":128,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_27":131},"544cdaf8-2781-11f0-b46e-569c3dd06744","parentId","latest",["D",1739056486526],11,"label",[28],"53f7e19c-2781-11f0-b46e-569c3dd06744","README.md","53f7e214-2781-11f0-b46e-569c3dd06744",1,["D",1739054794435],0,"# Val Town Database\n\nThis val exports `vtdb`, a correctly typed **Kysely** instance\nto query the [@sqlite.db](https://www.val.town/v/sqlite/db) database containing public vals.\n\nExample usage:\n\n```ts\nimport { vtdb } from 'https://esm.town/v/g/vtdb';\n\nconst vals = await vtdb.selectFrom('vals')\n .selectAll()\n .orderBy('created_at desc')\n .limit(5)\n .execute();\nconsole.log(vals.map((val) => val.name));\n```",[133],"pulls","branches","forks","envVars",{"_147":137,"_149":137},"connections",{"_147":137,"_148":137},"count","unfilledCount","emptyCount",{"_43":132,"_32":133,"_30":134,"_126":-5,"_41":42,"_40":135,"_127":49,"_38":156,"_13":137,"_33":20,"_35":138,"_24":25,"_130":-5,"_153":157,"_27":158},{"_43":125,"_32":28,"_30":31,"_126":-5,"_41":42,"_40":14,"_127":49,"_38":152,"_13":129,"_33":34,"_35":37,"_24":25,"_130":-5,"_153":154,"_27":155},["D",1739056486526],"children",[],[28],["D",1739054794435],[],[133],["D",1746209686126],{"_93":92,"_100":96},{"_93":92,"_94":-5,"_95":96,"_18":55,"_97":98,"_99":25},{"_13":14,"_32":83,"_43":42,"_84":44,"_85":-5,"_86":-5,"_87":-5,"_88":-5,"_89":-5,"_90":45,"_91":92},"ctx",{"_76":-5,"_120":196,"_197":198,"_199":200,"_201":25,"_202":25,"_203":25,"_204":49,"_205":-5,"_206":-7,"_207":-7,"_208":137,"_209":25,"_210":25,"_211":-5,"_212":25,"_213":25,"_214":25,"_215":-5},"ENV",{"_167":168,"_169":170,"_171":83,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189,"_190":191,"_192":193,"_194":195},"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 · v12