[{"_1":2,"_189":-5,"_190":-5},"loaderData",{"_3":4,"_91":92,"_154":155,"_188":-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,"_149":-5,"_150":-5,"_151":152,"_130":131,"_142":143,"_100":101,"_98":99,"_119":-7,"_50":51,"_153":26},"type","val","author","a8270e74-6479-475a-8025-9b69544ee0e7",{"_98":99,"_95":96,"_100":101,"_102":103,"_104":-5,"_105":106,"_107":108,"_109":110,"_111":112,"_113":26,"_114":112,"_115":116,"_117":118,"_119":31,"_120":26,"_121":31,"_122":31,"_123":124,"_125":31,"_126":31,"_127":31,"_128":-5,"_20":129,"_134":135,"_139":-7,"_140":141,"_142":143,"_144":145},"name","lucia_adapter_base","valNameId","74ae893e-696a-11ef-9c75-de64eea55b61","parentFolderId","c36b7b9a-696a-11ef-845e-de64eea55b61","isOwned","privacy","public","readme","Copied from ","valType","script","currentVersion","74da109a-696a-11ef-9c75-de64eea55b61","legacyPrivate","id","code","import type {\n Adapter,\n DatabaseSession,\n DatabaseUser,\n RegisteredDatabaseSessionAttributes,\n RegisteredDatabaseUserAttributes,\n} from \"npm:lucia\";\n\nexport class SQLiteAdapter implements Adapter {\n private controller: Controller;\n\n private escapedUserTableName: string;\n private escapedSessionTableName: string;\n\n constructor(controller: Controller, tableNames: TableNames) {\n this.controller = controller;\n this.escapedSessionTableName = escapeName(tableNames.sessionTable);\n this.escapedUserTableName = escapeName(tableNames.userTable);\n }\n\n public async deleteSession(sessionId: string): Promise {\n await this.controller.execute(`DELETE FROM ${this.escapedSessionTableName} WHERE id = ?`, [\n sessionId,\n ]);\n }\n\n public async deleteUserSessions(userId: string): Promise {\n await this.controller.execute(\n `DELETE FROM ${this.escapedSessionTableName} WHERE user_id = ?`,\n [userId],\n );\n }\n\n public async getSessionAndUser(\n sessionId: string,\n ): Promise<[session: DatabaseSession | null, user: DatabaseUser | null]> {\n const [databaseSession, databaseUser] = await Promise.all([\n this.getSession(sessionId),\n this.getUserFromSessionId(sessionId),\n ]);\n return [databaseSession, databaseUser];\n }\n\n public async getUserSessions(userId: string): Promise {\n const result = await this.controller.getAll(\n `SELECT * FROM ${this.escapedSessionTableName} WHERE user_id = ?`,\n [userId],\n );\n return result.map((val) => {\n return transformIntoDatabaseSession(val);\n });\n }\n\n public async setSession(databaseSession: DatabaseSession): Promise {\n const value: SessionSchema = {\n id: databaseSession.id,\n user_id: databaseSession.userId,\n expires_at: Math.floor(databaseSession.expiresAt.getTime() / 1000),\n ...databaseSession.attributes,\n };\n const entries = Object.entries(value).filter(([_, v]) => v !== undefined);\n const columns = entries.map(([k]) => escapeName(k));\n const placeholders = Array(columns.length).fill(\"?\");\n const values = entries.map(([_, v]) => v);\n await this.controller.execute(\n `INSERT INTO ${this.escapedSessionTableName} (${\n columns.join(\n \", \",\n )\n }) VALUES (${placeholders.join(\", \")})`,\n values,\n );\n }\n\n public async updateSessionExpiration(sessionId: string, expiresAt: Date): Promise {\n await this.controller.execute(\n `UPDATE ${this.escapedSessionTableName} SET expires_at = ? WHERE id = ?`,\n [Math.floor(expiresAt.getTime() / 1000), sessionId],\n );\n }\n\n public async deleteExpiredSessions(): Promise {\n await this.controller.execute(\n `DELETE FROM ${this.escapedSessionTableName} WHERE expires_at <= ?`,\n [Math.floor(Date.now() / 1000)],\n );\n }\n\n private async getSession(sessionId: string): Promise {\n const result = await this.controller.get(\n `SELECT * FROM ${this.escapedSessionTableName} WHERE id = ?`,\n [sessionId],\n );\n if (!result) return null;\n return transformIntoDatabaseSession(result);\n }\n\n private async getUserFromSessionId(sessionId: string): Promise {\n const result = await this.controller.get(\n `SELECT ${this.escapedUserTableName}.* FROM ${this.escapedSessionTableName} INNER JOIN ${this.escapedUserTableName} ON ${this.escapedUserTableName}.id = ${this.escapedSessionTableName}.user_id WHERE ${this.escapedSessionTableName}.id = ?`,\n [sessionId],\n );\n if (!result) return null;\n return transformIntoDatabaseUser(result);\n }\n}\n\nexport interface TableNames {\n userTable: string;\n sessionTable: string;\n}\n\nexport interface Controller {\n execute(sql: string, args: any[]): Promise;\n get(sql: string, args: any[]): Promise;\n getAll(sql: string, args: any[]): Promise;\n}\n\ninterface SessionSchema extends RegisteredDatabaseSessionAttributes {\n id: string;\n user_id: string;\n expires_at: number;\n}\n\ninterface UserSchema extends RegisteredDatabaseUserAttributes {\n id: string;\n}\n\nfunction transformIntoDatabaseSession(raw: SessionSchema): DatabaseSession {\n const { id, user_id: userId, expires_at: expiresAtUnix, ...attributes } = raw;\n return {\n userId,\n id,\n expiresAt: new Date(expiresAtUnix * 1000),\n attributes,\n };\n}\n\nfunction transformIntoDatabaseUser(raw: UserSchema): DatabaseUser {\n const { id, ...attributes } = raw;\n return {\n id,\n attributes,\n };\n}\n\nfunction escapeName(val: string): string {\n return \"`\" + val + \"`\";\n}","createdAt",["D",1725309141964],"version","currentUserHasLiked","likeCount","forkCount","referenceCount",1,"dependencyCount","commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","yawnxyz","profileImageUrl","https://images.clerk.dev/oauth_github/img_2NnaHhpxNuH1xWRIRjQNoo16TVc.jpeg","forkedVal",{"_114":136,"_130":137,"_98":99,"_119":124,"_138":-5},"07813e20-5591-11ef-bcd3-de64eea55b61","stevekrouse","prDisabledHint","interval","slug","yawnxyz/lucia_adapter_base","description","Copied from https://github.com/lucia-auth/lucia/blob/main/packages/adapter-sqlite/src/base.ts","versions",[146],{"_119":31,"_147":-5,"_117":148,"_114":112},"prId",["D",1725309141964],"recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_93":156,"_130":131,"_98":99,"_20":157,"_153":26,"_94":161,"_144":170,"_119":-5,"_183":31,"_184":185,"_186":124,"_187":-5},"list",{"_114":96,"_130":131,"_117":158,"_159":160,"_132":133},["D",1680302214510],"bio","i make ui for ai",{"_98":99,"_95":96,"_100":101,"_102":103,"_104":162,"_105":106,"_107":108,"_109":110,"_111":112,"_113":26,"_114":112,"_115":116,"_117":163,"_119":31,"_120":26,"_121":31,"_122":31,"_123":124,"_125":31,"_126":31,"_127":31,"_128":-5,"_20":164,"_134":165,"_139":-7,"_140":141,"_142":143,"_144":167},true,["D",1725309141964],{"_130":131,"_132":133},{"_114":136,"_130":137,"_98":99,"_119":124,"_138":166},"Can't create a PR without code or readme changes",[168],{"_119":31,"_147":-5,"_117":169,"_114":112},["D",1725309141964],[171],{"_114":112,"_115":116,"_119":31,"_117":172,"_173":99,"_100":101,"_109":110,"_130":131,"_11":96,"_174":-5,"_175":-5,"_176":-5,"_153":26,"_140":141,"_177":-5,"_178":179},["D",1725309141964],"valName","deletedAt","messageId","threadId","previous","stats",{"_180":181,"_182":31},"additions",149,"deletions","page","pageSize",8,"total","redirect","routes/_app","actionData","errors"]

lucia_adapter_base

Versions

v0