[{"_1":2,"_180":-5,"_181":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":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","isTeamOrgMember","ENV",{"_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,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","1ed3b00b191d67ef967325d666dac7a18ce9a124","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",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":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",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_155":156,"_177":178,"_179":-5},"handle","cricks_unmixed4u","name","studiokare-auth","path","backend/queries.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":112,"_113":-5,"_12":114,"_115":-5,"_116":20,"_117":-5,"_118":-5,"_119":33,"_14":120,"_121":-5,"_122":-5,"_123":-5,"_124":125,"_126":125,"_127":128,"_129":128,"_130":128,"_131":125,"_132":125,"_23":133,"_136":137,"_141":142,"_154":20},"id","efb5ea0a-22b4-11f1-ba00-42dde27851f2","createdAt",["D",1773829593631],"deletedAt","legacyEnvVars","privacy","public","description","Reusable magic-link email auth for Val Town apps","imageUrl","0b86c720-ddc6-11ef-94bf-d1c3ffb48162","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","7018ec7d-7a8e-4e8f-93d1-ab6a7334ca50","tursoName","tursoHostname","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_134":135},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJzSEJuSGdYT2dQSmprejVnU0VqalpDaWhKUSJ9","org",{"_95":96,"_138":135,"_12":114,"_139":140},"avatar","tier","free","branch",{"_143":144,"_97":45,"_103":145,"_146":104,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":-5,"_152":98,"_153":96},"version",19,"efb6332a-22b4-11f1-ba00-42dde27851f2","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_103":157,"_97":158,"_159":160,"_161":162,"_163":145,"_164":165,"_166":167,"_105":168,"_143":33,"_169":170,"_171":172,"_173":20,"_174":-5,"_99":175},"a2a3c264-22b9-11f1-897b-42dde27851f2","queries.ts","fileId","a2a3c2dc-22b9-11f1-897b-42dde27851f2","parentId","019d009a-6591-73e9-b396-2b5afca90f64","branchId","branchVersion",1,"latest",true,["D",1773831611794],"fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\nimport type { StudioKareSession, StudioKareUser } from \"../types.ts\";\n\nexport function createAuthQueries(prefix: string) {\n const usersTable = `${prefix}_users`;\n const sessionsTable = `${prefix}_sessions`;\n const magicLinksTable = `${prefix}_magic_links`;\n\n // ---- Users ----\n\n async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT id, email, created_at FROM ${usersTable} 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\n async function getUserById(id: string): Promise {\n const result = await sqlite.execute({\n sql: `SELECT id, email, created_at FROM ${usersTable} 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\n async function createUser(id: string, email: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${usersTable} (id, email) VALUES (?, ?)`,\n args: [id, email],\n });\n return { id, email, createdAt: new Date().toISOString() };\n }\n\n // ---- Sessions ----\n\n async function createSessionRecord(sessionId: string, userId: string, expiresAt: Date): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${sessionsTable} (id, user_id, expires_at) VALUES (?, ?, ?)`,\n args: [sessionId, userId, expiresAt.toISOString()],\n });\n }\n\n 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 ${sessionsTable} s\n JOIN ${usersTable} 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\n async function updateSessionExpiry(sessionId: string, expiresAt: Date): Promise {\n await sqlite.execute({\n sql: `UPDATE ${sessionsTable} SET expires_at = ? WHERE id = ?`,\n args: [expiresAt.toISOString(), sessionId],\n });\n }\n\n async function deleteSessionRecord(sessionId: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${sessionsTable} WHERE id = ?`,\n args: [sessionId],\n });\n }\n\n // ---- Magic Links ----\n\n async function createMagicLinkRecord(id: string, email: string, expiresAt: Date, userId?: string): Promise {\n await sqlite.execute({\n sql: `INSERT INTO ${magicLinksTable} (id, email, expires_at, user_id) VALUES (?, ?, ?, ?)`,\n args: [id, email, expiresAt.toISOString(), userId ?? null],\n });\n }\n\n 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 ${magicLinksTable} 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\n async function updateUserEmail(userId: string, newEmail: string): Promise {\n await sqlite.execute({\n sql: `UPDATE ${usersTable} SET email = ? WHERE id = ?`,\n args: [newEmail, userId],\n });\n }\n\n async function deleteMagicLinkRecord(id: string): Promise {\n await sqlite.execute({\n sql: `DELETE FROM ${magicLinksTable} WHERE id = ?`,\n args: [id],\n });\n }\n\n return {\n getUserByEmail,\n getUserById,\n createUser,\n createSessionRecord,\n getSessionRecord,\n updateSessionExpiry,\n deleteSessionRecord,\n createMagicLinkRecord,\n getMagicLinkRecord,\n updateUserEmail,\n deleteMagicLinkRecord,\n };\n}\n\nexport type AuthQueries = ReturnType;\n","deleted","label",[176,158],"backend","permalink","https://www.val.town/x/cricks_unmixed4u/studiokare-auth/code/backend/queries.ts","extension","actionData","errors"]