[{"_1":2,"_170":-5,"_171":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","notificationCount",0,"flagDenols","ENV",{"_36":37,"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","40390002a9f23719e5ece4788ed87655b391d648","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","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_66":67},"__internal_clerk_state",{"_68":69,"_70":45,"_71":72,"_73":72,"_74":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_150":151,"_167":168,"_169":-5},"handle","yawnxyz","name","lucia_adapter_base","path","main.tsx","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":107,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":107,"_115":-5,"_116":32,"_14":117,"_118":119,"_120":119,"_121":122,"_123":122,"_124":122,"_125":119,"_126":119,"_23":127,"_130":131,"_133":134,"_149":20},"id","486e899a-2793-11f0-9d52-569c3dd06744","createdAt",["D",1746217397733],"deletedAt","legacyEnvVars",true,"privacy","public","description","imageUrl","a8270e74-6479-475a-8025-9b69544ee0e7","pinnedFileId","pinPreview","screenshotVersion","likeCount","8319defa-6e1a-46d4-ba66-2114ffd3360b","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_128":129},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2NnaHhpxNuH1xWRIRjQNoo16TVc.jpeg","org",{"_93":94,"_132":129},"avatar","branch",{"_135":136,"_95":43,"_101":137,"_138":102,"_139":140,"_141":32,"_142":109,"_143":144,"_145":146,"_147":96,"_148":94},"version",1,"486f5bcc-2793-11f0-9d52-569c3dd06744","projectId","forkedBranchId","a17a5da0-25f1-11f0-ad23-569c3dd06744","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","a17a1d22-25f1-11f0-ad23-569c3dd06744","forkedProjectOrgId","e81e7335-6d4c-4764-a902-d0962bbfa9f7","projectName","userHandle","isOwned","file",{"_101":152,"_95":98,"_153":154,"_155":-5,"_156":137,"_157":136,"_158":107,"_103":159,"_135":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"4872d112-2793-11f0-9d52-569c3dd06744","fileId","4872d1ee-2793-11f0-9d52-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1725309141964],"fileType","script","content","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}","deleted","label",[98],"permalink","https://www.val.town/x/yawnxyz/lucia_adapter_base/code/main.tsx","extension","actionData","errors"]