[{"_1":2,"_194":-5,"_195":-5},"loaderData",{"_3":4,"_96":97},"root",{"_5":6,"_37":38,"_69":70},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20,"_36":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","preferencesChatPanelState","notificationCount",0,"flagDenols","isBusinessOrgMember","isHigherTownieTier","ENV",{"_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":64,"_65":66,"_67":68},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e51bad5fadd85163deda19ce4085f9f29f43aa4b","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","API_URL","https://api.val.town","clerkState",{"_71":72},"__internal_clerk_state",{"_73":74,"_75":48,"_76":77,"_78":77,"_79":20,"_80":77,"_81":77,"_82":77,"_83":77,"_84":85,"_94":20,"_95":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",{"_86":20,"_19":20,"_87":77,"_88":89,"_90":77,"_91":48,"_92":20,"_93":77},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_98":99,"_100":101,"_102":103,"_104":105,"_167":168,"_191":192,"_193":-5},"handle","ozanatgreenpt","name","thirdTimer","path","src/backend/database/auth-queries.ts","project",{"_106":107,"_100":101,"_108":109,"_110":-5,"_111":20,"_112":113,"_114":115,"_116":-5,"_12":117,"_118":119,"_120":121,"_122":-5,"_123":-5,"_124":33,"_14":125,"_126":127,"_128":129,"_130":131,"_132":-5,"_133":134,"_135":134,"_136":137,"_138":137,"_139":137,"_140":134,"_141":134,"_23":142,"_145":146,"_150":151,"_166":20},"id","2564eb70-1099-11f1-8a6a-42dde27851f2","createdAt",["D",1771838536808],"deletedAt","legacyEnvVars","privacy","public","description","This version stores some data, so you can restart the app!","imageUrl","019bfe98-75fd-713b-83d5-edcffcda6af5","pinnedFileId","019c89ce-7cc0-75ad-bf76-e12eeaf4e6b3","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","019bfe98-75fd-713b-83d5-f27288110d30","tursoName","2564eb70109911f18a6a42dde27851f2","tursoHostname","2564eb70109911f18a6a42dde27851f2-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1775868631768],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_98":99,"_143":144},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzM4cGlWZXRaZkpPd3gzTU9Qb1ZJY3V6a2tVZyJ9","org",{"_98":99,"_147":144,"_12":117,"_148":149},"avatar","tier","free","branch",{"_152":153,"_100":46,"_106":154,"_155":107,"_156":-5,"_157":-5,"_158":159,"_160":161,"_162":163,"_164":101,"_165":99},"version",758,"2568f8fa-1099-11f1-8a6a-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","private","forkedProjectId","d56cf5fe-7fe8-11f0-a138-0224a6c84d84","forkedProjectOrgId","7018ec7d-7a8e-4e8f-93d1-ab6a7334ca50","projectName","userHandle","isOwned","file",{"_106":169,"_100":170,"_171":172,"_173":174,"_175":154,"_176":177,"_178":121,"_108":179,"_152":180,"_181":182,"_183":184,"_185":20,"_186":-5,"_102":187},"7189c672-1339-11f1-ae00-42dde27851f2","auth-queries.ts","fileId","5fbedc86-130f-11f1-88b1-42dde27851f2","parentId","aa5128d4-109a-11f1-929b-42dde27851f2","branchId","branchVersion",269,"latest",["D",1772127286387],3,"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport type { StudioKareSession, StudioKareUser } from \"../../shared/auth-types.ts\";\n\n// ---- Users ----\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id, email, created_at FROM studiokare_users WHERE email = ?\",\n args: [email],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const cols = result.columns;\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n id: col(\"id\") as string,\n email: col(\"email\") as string,\n createdAt: col(\"created_at\") as string,\n };\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT id, email, created_at FROM studiokare_users WHERE id = ?\",\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const cols = result.columns;\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n id: col(\"id\") as string,\n email: col(\"email\") as string,\n createdAt: col(\"created_at\") as string,\n };\n}\n\nexport async function createUser(id: string, email: string): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO studiokare_users (id, email) VALUES (?, ?)\",\n args: [id, email],\n });\n return { id, email, createdAt: new Date().toISOString() };\n}\n\n// ---- Sessions ----\n\nexport async function createSessionRecord(sessionId: string, userId: string, expiresAt: Date): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO studiokare_sessions (id, user_id, expires_at) VALUES (?, ?, ?)\",\n args: [sessionId, userId, expiresAt.toISOString()],\n });\n}\n\nexport async function getSessionRecord(\n sessionId: string,\n): Promise<{ session: StudioKareSession; user: StudioKareUser } | null> {\n const result = await sqlite.execute({\n sql: `SELECT s.id, s.user_id, s.expires_at, u.email, u.created_at\n FROM studiokare_sessions s\n JOIN studiokare_users u ON s.user_id = u.id\n WHERE s.id = ?`,\n args: [sessionId],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const cols = result.columns;\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n session: {\n id: col(\"id\") as string,\n userId: col(\"user_id\") as string,\n expiresAt: new Date(col(\"expires_at\") as string),\n },\n user: {\n id: col(\"user_id\") as string,\n email: col(\"email\") as string,\n createdAt: col(\"created_at\") as string,\n },\n };\n}\n\nexport async function updateSessionExpiry(sessionId: string, expiresAt: Date): Promise {\n await sqlite.execute({\n sql: \"UPDATE studiokare_sessions SET expires_at = ? WHERE id = ?\",\n args: [expiresAt.toISOString(), sessionId],\n });\n}\n\nexport async function deleteSessionRecord(sessionId: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM studiokare_sessions WHERE id = ?\",\n args: [sessionId],\n });\n}\n\n// ---- Magic Links ----\n\nexport async function createMagicLinkRecord(id: string, email: string, expiresAt: Date, userId?: string): Promise {\n await sqlite.execute({\n sql: \"INSERT INTO studiokare_magic_links (id, email, expires_at, user_id) VALUES (?, ?, ?, ?)\",\n args: [id, email, expiresAt.toISOString(), userId ?? null],\n });\n}\n\nexport async function getMagicLinkRecord(id: string): Promise<{ email: string; expiresAt: Date; userId: string | null } | null> {\n const result = await sqlite.execute({\n sql: \"SELECT email, expires_at, user_id FROM studiokare_magic_links WHERE id = ?\",\n args: [id],\n });\n if (result.rows.length === 0) return null;\n const row = result.rows[0];\n const cols = result.columns;\n const col = (name: string) => row[cols.indexOf(name)];\n return {\n email: col(\"email\") as string,\n expiresAt: new Date(col(\"expires_at\") as string),\n userId: col(\"user_id\") as string | null,\n };\n}\n\nexport async function updateUserEmail(userId: string, newEmail: string): Promise {\n await sqlite.execute({\n sql: \"UPDATE studiokare_users SET email = ? WHERE id = ?\",\n args: [newEmail, userId],\n });\n}\n\nexport async function deleteMagicLinkRecord(id: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM studiokare_magic_links WHERE id = ?\",\n args: [id],\n });\n}\n\n// ---- Owner Token Linking ----\n\nexport async function linkOwnerToken(ownerToken: string, userId: string): Promise {\n await sqlite.execute({\n sql: \"INSERT OR IGNORE INTO studiokare_owner_tokens (owner_token, user_id) VALUES (?, ?)\",\n args: [ownerToken, userId],\n });\n}\n\nexport async function getOwnerTokensForUser(userId: string): Promise {\n const result = await sqlite.execute({\n sql: \"SELECT owner_token FROM studiokare_owner_tokens WHERE user_id = ?\",\n args: [userId],\n });\n return result.rows.map((row) => row[0] as string);\n}\n","deleted","label",[188,189,190,170],"src","backend","database","permalink","https://www.val.town/x/ozanatgreenpt/thirdTimer/code/src/backend/database/auth-queries.ts","extension","actionData","errors"]