[{"_1":2,"_177":-5,"_178":-5},"loaderData",{"_3":4,"_91":92,"_164":165,"_176":-5},"root",{"_5":6,"_32":33,"_58":59,"_89":90},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":29,"_30":31},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_34":35,"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","fa80b67e1f763bfb4b247c3f5ca4f0b0730f3f5c","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","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","API_URL","https://api.val.town","WORKER_FINGERPRINT","799d99f2805306c2714a7cfefbeae178","clerkState",{"_60":61},"__internal_clerk_state",{"_62":63,"_64":43,"_65":66,"_67":66,"_68":26,"_69":66,"_70":66,"_71":66,"_72":66,"_73":66,"_74":66,"_75":66,"_76":66,"_77":78,"_87":26,"_88":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_79":26,"_80":66,"_81":82,"_83":66,"_84":43,"_85":26,"_86":66},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_93":94,"_95":96,"_94":97,"_159":-5,"_160":-5,"_161":162,"_131":132,"_139":140,"_100":101,"_98":99,"_118":-7,"_50":51,"_163":26},"type","val","author","c2a2fc8a-0a8c-4a4d-aba0-1ce9b42cecee",{"_98":99,"_95":96,"_100":101,"_102":-5,"_103":-5,"_104":105,"_106":107,"_108":109,"_110":111,"_112":26,"_113":111,"_114":115,"_116":117,"_118":119,"_120":26,"_121":122,"_123":31,"_124":125,"_126":90,"_127":31,"_128":31,"_129":-5,"_20":130,"_135":-5,"_136":-7,"_137":138,"_139":140,"_141":142},"name","kyselyVtDialect","valNameId","5244f8e8-efc0-11ee-ac6e-cab58f78796a","parentFolderId","isOwned","privacy","public","readme","# Kysely Dialect for @std/sqlite\n## Caveats\nIt doesn't support transactions, there's no real way to do them on top of @std/sqlite AFAICT.\n## Usage\n```ts\nimport { VtDialect } from \"https://esm.town/v/easrng/kyselyVtDialect\";\nimport { Kysely } from \"npm:kysely\";\n\nconst db = new Kysely({\n dialect: new VtDialect(),\n});\n```\n## Demo\nSee @easrng/kyselyVtDemo, which uses this along with @easrng/kyselyVtTypes to generate schema types.","valType","script","currentVersion","b25fb0b6-efc4-11ee-bd73-cab58f78796a","legacyPrivate","id","code","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as kysely from \"npm:kysely@^0.27.3\";\n\nexport class VtDialect implements kysely.Dialect {\n createAdapter(): kysely.DialectAdapter {\n return new kysely.SqliteAdapter();\n }\n\n createDriver(): kysely.Driver {\n return new VtDriver();\n }\n\n createIntrospector(db: kysely.Kysely): kysely.DatabaseIntrospector {\n return new kysely.SqliteIntrospector(db);\n }\n\n createQueryCompiler(): kysely.QueryCompiler {\n return new kysely.SqliteQueryCompiler();\n }\n}\n\nexport class VtDriver implements kysely.Driver {\n async init(): Promise {\n }\n\n async acquireConnection(): Promise {\n return new VtConnection();\n }\n\n async beginTransaction(\n connection: VtConnection,\n _settings: kysely.TransactionSettings,\n ): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async commitTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async rollbackTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async releaseConnection(connection: VtConnection): Promise {\n }\n\n async destroy(): Promise {\n }\n}\n\nexport class VtConnection implements kysely.DatabaseConnection {\n async executeQuery(compiledQuery: kysely.CompiledQuery): Promise> {\n const result = await sqlite.execute({\n sql: compiledQuery.sql,\n args: compiledQuery.parameters as any,\n });\n return {\n numAffectedRows: BigInt(result.rowsAffected),\n rows: result.rows.map(row => Object.fromEntries(row.map((value, i) => [result.columns[i], value]))) as R[],\n };\n }\n\n async *streamQuery(\n _compiledQuery: kysely.CompiledQuery,\n _chunkSize: number,\n ): AsyncIterableIterator> {\n throw new Error(\"val.town does not support streaming yet\");\n }\n}","createdAt",["D",1711933858030],"version",4,"currentUserHasLiked","likeCount",1,"forkCount","referenceCount",8,"dependencyCount","commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","easrng","profileImageUrl","https://images.clerk.dev/oauth_github/img_2Qn86tpR8Fwsj1TjoMg9t1DCmc2.png","forkedVal","interval","slug","easrng/kyselyVtDialect","description","Kysely Dialect for @std/sqlite Caveats It doesn't support transactions, there's no real way to do them on top of @std/sqlite AFAICT. Usage import { VtDialect } from \"https://esm.town/v/easrng/kyselyVtDialect\";\nimport { Kysely } from \"npm:kysely\";\n\nconst db = new Kysely({\n dialect: new VtDialect(),\n}); Demo See @easrng/kyselyVtDemo, which uses this along with @easrng/kyselyVtTypes to generate schema types.","versions",[143,146,150,153,156],{"_118":119,"_144":-5,"_116":145,"_113":111},"prId",["D",1711933858030],{"_118":147,"_144":-5,"_116":148,"_113":149},3,["D",1711933311855],"6cd40458-efc3-11ee-9d71-cab58f78796a",{"_118":90,"_144":-5,"_116":151,"_113":152},["D",1711933226263],"39cfb8d6-efc3-11ee-b103-cab58f78796a",{"_118":122,"_144":-5,"_116":154,"_113":155},["D",1711932556708],"aab9b1d4-efc1-11ee-88bf-cab58f78796a",{"_118":31,"_144":-5,"_116":157,"_113":158},["D",1711931978812],"5245b7e2-efc0-11ee-ac6e-cab58f78796a","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":166,"_167":168,"_94":169},"single","redirect","/v/easrng/kyselyVtDialect/versions",{"_113":149,"_114":170,"_118":147,"_116":171,"_172":99,"_100":101,"_108":109,"_131":132,"_11":96,"_173":-5,"_174":-5,"_175":-5,"_163":26,"_137":138},"import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport * as kysely from \"npm:kysely@^0.27.3\";\n\nexport class VtDialect implements kysely.Dialect {\n createAdapter(): kysely.DialectAdapter {\n return new kysely.SqliteAdapter();\n }\n\n createDriver(): kysely.Driver {\n return new VtDriver();\n }\n\n createIntrospector(db: kysely.Kysely): kysely.DatabaseIntrospector {\n return new kysely.SqliteIntrospector(db);\n }\n\n createQueryCompiler(): kysely.QueryCompiler {\n return new kysely.SqliteQueryCompiler();\n }\n}\n\nexport class VtDriver implements kysely.Driver {\n async init(): Promise {\n }\n\n async acquireConnection(): Promise {\n return new VtConnection();\n }\n\n async beginTransaction(\n connection: VtConnection,\n _settings: kysely.TransactionSettings,\n ): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async commitTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async rollbackTransaction(connection: VtConnection): Promise {\n throw new Error(\"val.town does not support transactions\");\n }\n\n async releaseConnection(connection: VtConnection): Promise {\n }\n\n async destroy(): Promise {\n }\n}\n\nexport class VtConnection implements kysely.DatabaseConnection {\n async executeQuery(compiledQuery: kysely.CompiledQuery): Promise> {\n const result = await sqlite.execute({\n sql: compiledQuery.sql,\n args: compiledQuery.parameters as any,\n });\n return {\n numAffectedRows: BigInt(result.rowsAffected),\n rows: result.rows as R[],\n };\n }\n\n async *streamQuery(\n _compiledQuery: kysely.CompiledQuery,\n _chunkSize: number,\n ): AsyncIterableIterator> {\n throw new Error(\"val.town does not support streaming yet\");\n }\n}",["D",1711933311855],"valName","deletedAt","messageId","threadId","routes/_app","actionData","errors"]

kyselyVtDialect

Version 3