[{"_1":2,"_248":-5,"_249":-5},"loaderData",{"_3":4,"_91":92,"_216":217},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":22,"_29":22,"_30":22,"_31":32,"_33":22},"auth",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"tokenType","session_token","sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"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","230fbbe1911b69d46be82b6db4e617b331d282a6","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":22,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":22,"_90":22},"__clerk_ssr_state",{"_9":10,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":-5,"_20":-5,"_21":22},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_81":22,"_21":22,"_82":72,"_83":84,"_85":72,"_86":45,"_87":22,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/_app.x.$handle.$name",{"_93":94,"_95":96,"_97":-7,"_98":72,"_99":-7,"_100":101,"_150":151,"_180":181,"_182":183,"_191":192,"_163":-5,"_199":200,"_204":205,"_212":22,"_213":22,"_214":215},"handle","yawnxyz","name","lucia_adapter_base","branchName","path","version","project",{"_102":103,"_95":96,"_104":105,"_106":-5,"_107":108,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":108,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_149":22},"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,"_129":130},"profileImageUrl","https://images.clerk.dev/oauth_github/img_2NnaHhpxNuH1xWRIRjQNoo16TVc.jpeg","org",{"_93":94,"_133":130},"avatar","branch",{"_99":136,"_95":43,"_102":137,"_138":103,"_139":140,"_141":32,"_142":110,"_143":144,"_145":146,"_147":96,"_148":94},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","tree",[152,171],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":161,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":169,"_98":170},"4872db8a-2793-11f0-9d52-569c3dd06744","README.md","fileId","4872dc3e-2793-11f0-9d52-569c3dd06744","parentId","branchId","branchVersion","latest",["D",1725309141964],"fileType","file","content","Copied from \n\nMigrated from folder: luciaAuthExamples/RoughLuciaExampleOaut/lucia_adapter_base","deleted","label","children",[],[154],{"_102":172,"_95":173,"_155":174,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":175,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_168":178,"_98":179},"4872d112-2793-11f0-9d52-569c3dd06744","main.tsx","4872d1ee-2793-11f0-9d52-569c3dd06744",["D",1725309141964],"script","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}",[],[173],"files",[152,171],"counts",{"_184":32,"_185":136,"_186":32,"_187":188},"pulls","branches","forks","envVars",{"_189":32,"_190":32},"count","emptyCount","contents",[193,196],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":194,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_98":195},["D",1725309141964],[154],{"_102":172,"_95":173,"_155":174,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":197,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_98":198},["D",1725309141964],[173],"upstreamProject",{"_102":144,"_95":96,"_111":-5,"_112":-5,"_109":110,"_23":201},{"_93":202,"_129":203},"stevekrouse","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","upstreamBranch",{"_102":140,"_104":206,"_207":208,"_95":43,"_138":144,"_99":209,"_139":210,"_141":32,"_211":-5,"_106":-5,"_149":22,"_109":110,"_148":202,"_16":146,"_147":96},["D",1746038017495],"updatedAt",["D",1723126685628],2,"ba48f2b2-277f-11f0-b46e-569c3dd06744","lockfileKey","emptyEnvVars","isNew","flags",[],"routes/_app.x.$handle.$name._index",{"_93":94,"_95":96,"_97":-7,"_99":-7,"_100":218,"_191":223,"_228":229,"_232":233,"_236":-5,"_180":237,"_244":245,"_246":136,"_247":209},{"_102":103,"_95":96,"_104":219,"_106":-5,"_107":108,"_109":110,"_111":-5,"_112":-5,"_14":113,"_114":-5,"_115":108,"_116":-5,"_117":32,"_16":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":220,"_131":221,"_134":222,"_149":22},["D",1746217397733],{"_93":94,"_129":130},{"_93":94,"_133":130},{"_99":136,"_95":43,"_102":137,"_138":103,"_139":140,"_141":32,"_142":110,"_143":144,"_145":146,"_147":96,"_148":94},[224,226],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":194,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_98":225},[154],{"_102":172,"_95":173,"_155":174,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":197,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_98":227},[173],"readme",{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":230,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_98":231},["D",1725309141964],[154],"upstream",{"_102":140,"_104":234,"_207":235,"_95":43,"_138":144,"_99":209,"_139":210,"_141":32,"_211":-5,"_106":-5,"_149":22,"_109":110,"_148":202,"_16":146,"_147":96},["D",1746038017495],["D",1723126685628],"pull",[238,241],{"_102":153,"_95":154,"_155":156,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":161,"_99":32,"_162":163,"_164":165,"_166":22,"_167":-5,"_168":239,"_98":240},[],[154],{"_102":172,"_95":173,"_155":174,"_157":-5,"_158":137,"_159":136,"_160":108,"_104":175,"_99":32,"_162":176,"_164":177,"_166":22,"_167":-5,"_168":242,"_98":243},[],[173],"previews",[],"ahead","behind","actionData","errors"]