[{"_1":2,"_167":-5,"_168":-5},"loaderData",{"_3":4,"_91":92,"_158":159,"_166":-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,"_153":-5,"_154":-5,"_155":156,"_130":131,"_143":144,"_100":101,"_98":99,"_119":-7,"_50":51,"_157":26},"type","val","author","a0bf3b31-15a5-4d5c-880e-4b1e22c9bc18",{"_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":120,"_121":26,"_122":120,"_123":120,"_124":120,"_125":31,"_126":31,"_127":31,"_128":-5,"_20":129,"_134":135,"_140":-7,"_141":142,"_143":144,"_145":146},"name","lucia_adapter_base","valNameId","f074aa64-5590-11ef-90c4-de64eea55b61","parentFolderId","eecc26b7-476b-4e93-9487-ae8b4988d6e5","isOwned","privacy","public","readme","Copied from ","valType","script","currentVersion","07813e20-5591-11ef-bcd3-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",1723126685628],"version",1,"currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount","commentCount","prCount","mergedPr",{"_130":131,"_132":133},"handle","stevekrouse","profileImageUrl","https://images.clerk.dev/uploaded/img_2PqHa2Gsy93xQrjh2w78Xu0cChW.jpeg","forkedVal",{"_114":136,"_130":137,"_98":99,"_119":138,"_139":-5},"1c344298-daeb-11ee-b9f3-8aad37b30b4b","pomdtr",4,"prDisabledHint","interval","slug","stevekrouse/lucia_adapter_base","description","Copied from https://github.com/lucia-auth/lucia/blob/main/packages/adapter-sqlite/src/base.ts","versions",[147,150],{"_119":120,"_148":-5,"_117":149,"_114":112},"prId",["D",1723126685628],{"_119":31,"_148":-5,"_117":151,"_114":152},["D",1723126646978],"f077c14a-5590-11ef-90c4-de64eea55b61","recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.dependencies",{"_160":161,"_162":31,"_163":142,"_164":31,"_94":165},"dependenciesList",[],"dependenciesCount","valname","page",{"_114":112,"_98":99,"_130":131,"_11":96,"_119":120,"_100":101,"_115":116,"_105":106,"_113":26,"_141":142},"routes/_app","actionData","errors"]