[{"_1":2,"_176":-5,"_177":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","5c349ef9e7d7333839a0634dd567aae2d49623a6","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_150":151,"_173":174,"_175":-5},"handle","jessicaocean","name","OUT-app","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":114,"_115":116,"_117":116,"_118":-5,"_119":32,"_14":120,"_121":122,"_123":122,"_124":125,"_126":125,"_127":125,"_128":122,"_129":122,"_23":130,"_133":134,"_136":137,"_149":20},"id","5f3da4b2-61d6-11f0-b879-0224a6c84d84","createdAt",["D",1752623379720],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","db8c40b0-3679-11f0-8fa1-55b6765ef200","pinnedFileId","86583e9e-61d7-11f0-939e-0224a6c84d84","pinPreview",true,"pinMigrated","screenshotVersion","likeCount","4b0eaab1-a083-4aa8-8d97-1e33d9e8e81f","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_131":132},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeFExeUQyU0VlRHI3UGZ6NTE5RWJwak55S1IifQ","org",{"_94":95,"_135":132,"_12":112},"avatar","branch",{"_138":139,"_96":44,"_102":140,"_141":103,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":-5,"_147":97,"_148":95},"version",101,"5f3e38aa-61d6-11f0-b879-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":152,"_96":153,"_154":155,"_156":157,"_158":140,"_159":160,"_161":116,"_104":162,"_138":163,"_164":165,"_166":167,"_168":20,"_169":-5,"_98":170},"64269f82-61dc-11f0-9667-0224a6c84d84","queries.ts","fileId","49b9e000-61d7-11f0-9440-0224a6c84d84","parentId","f101f742-c565-474d-8f99-ce574bf25d08","branchId","branchVersion",71,"latest",["D",1752625964930],19,"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Activity, SocialCircle } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(user: User): Promise {\n await sqlite.execute(`\n INSERT INTO users_v2 (\n userId, name, email, location_lat, location_lon, location_address,\n childrenInfo, transportModes, socialCircles, sleepSchedules,\n huckleberryData, googleCalendarData, createdAt, updatedAt\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n user.userId,\n user.name,\n user.email,\n user.location.lat,\n user.location.lon,\n user.location.address || null,\n JSON.stringify(user.childrenInfo),\n JSON.stringify(user.transportModes),\n JSON.stringify(user.socialCircles),\n JSON.stringify(user.sleepSchedules),\n user.huckleberryData ? 1 : 0,\n user.googleCalendarData ? 1 : 0,\n user.createdAt,\n user.updatedAt\n ]);\n}\n\nexport async function getUserById(userId: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM users_v2 WHERE userId = ?\",\n [userId]\n );\n\n if (!result || !result.rows || result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n if (!row || !row.userId) {\n return null;\n }\n\n return {\n userId: row.userId,\n name: row.name,\n email: row.email,\n location: {\n lat: row.location_lat,\n lon: row.location_lon,\n address: row.location_address\n },\n childrenInfo: JSON.parse(row.childrenInfo || '[]'),\n transportModes: JSON.parse(row.transportModes || '[]'),\n socialCircles: JSON.parse(row.socialCircles || '{\"oldPals\":[],\"friends\":[],\"newFriends\":[]}'),\n sleepSchedules: JSON.parse(row.sleepSchedules || '[]'),\n huckleberryData: row.huckleberryData === 1,\n googleCalendarData: row.googleCalendarData === 1,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM users_v2 WHERE email = ?\",\n [email]\n );\n\n if (!result || !result.rows || result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n if (!row || !row.userId) {\n return null;\n }\n\n return {\n userId: row.userId,\n name: row.name,\n email: row.email,\n location: {\n lat: row.location_lat,\n lon: row.location_lon,\n address: row.location_address\n },\n childrenInfo: JSON.parse(row.childrenInfo || '[]'),\n transportModes: JSON.parse(row.transportModes || '[]'),\n socialCircles: JSON.parse(row.socialCircles || '{\"oldPals\":[],\"friends\":[],\"newFriends\":[]}'),\n sleepSchedules: JSON.parse(row.sleepSchedules || '[]'),\n huckleberryData: row.huckleberryData === 1,\n googleCalendarData: row.googleCalendarData === 1,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n };\n}\n\nexport async function updateUser(userId: string, updates: Partial): Promise {\n const setParts: string[] = [];\n const values: any[] = [];\n\n if (updates.name !== undefined) {\n setParts.push(\"name = ?\");\n values.push(updates.name);\n }\n if (updates.email !== undefined) {\n setParts.push(\"email = ?\");\n values.push(updates.email);\n }\n if (updates.location !== undefined) {\n setParts.push(\"location_lat = ?, location_lon = ?, location_address = ?\");\n values.push(updates.location.lat, updates.location.lon, updates.location.address || null);\n }\n if (updates.childrenInfo !== undefined) {\n setParts.push(\"childrenInfo = ?\");\n values.push(JSON.stringify(updates.childrenInfo));\n }\n if (updates.transportModes !== undefined) {\n setParts.push(\"transportModes = ?\");\n values.push(JSON.stringify(updates.transportModes));\n }\n if (updates.socialCircles !== undefined) {\n setParts.push(\"socialCircles = ?\");\n values.push(JSON.stringify(updates.socialCircles));\n }\n if (updates.sleepSchedules !== undefined) {\n setParts.push(\"sleepSchedules = ?\");\n values.push(JSON.stringify(updates.sleepSchedules));\n }\n if (updates.huckleberryData !== undefined) {\n setParts.push(\"huckleberryData = ?\");\n values.push(updates.huckleberryData ? 1 : 0);\n }\n if (updates.googleCalendarData !== undefined) {\n setParts.push(\"googleCalendarData = ?\");\n values.push(updates.googleCalendarData ? 1 : 0);\n }\n\n if (setParts.length === 0) return;\n\n setParts.push(\"updatedAt = ?\");\n values.push(new Date().toISOString());\n values.push(userId);\n\n await sqlite.execute(\n `UPDATE users_v2 SET ${setParts.join(\", \")} WHERE userId = ?`,\n values\n );\n}\n\nexport async function addFriendToCircle(userId: string, friendId: string, circle: SocialCircle = 'newFriends'): Promise {\n const user = await getUserById(userId);\n if (!user) throw new Error(\"User not found\");\n\n // Remove from all circles first\n user.socialCircles.oldPals = user.socialCircles.oldPals.filter(id => id !== friendId);\n user.socialCircles.friends = user.socialCircles.friends.filter(id => id !== friendId);\n user.socialCircles.newFriends = user.socialCircles.newFriends.filter(id => id !== friendId);\n\n // Add to specified circle\n user.socialCircles[circle].push(friendId);\n\n await updateUser(userId, { socialCircles: user.socialCircles });\n}\n\nexport async function removeFriendFromAllCircles(userId: string, friendId: string): Promise {\n const user = await getUserById(userId);\n if (!user) throw new Error(\"User not found\");\n\n // Remove from all circles\n user.socialCircles.oldPals = user.socialCircles.oldPals.filter(id => id !== friendId);\n user.socialCircles.friends = user.socialCircles.friends.filter(id => id !== friendId);\n user.socialCircles.newFriends = user.socialCircles.newFriends.filter(id => id !== friendId);\n\n await updateUser(userId, { socialCircles: user.socialCircles });\n}\n\n// Activity queries\nexport async function createActivity(activity: Activity): Promise {\n await sqlite.execute(`\n INSERT INTO activities_v2 (\n activityId, ownerId, type, title, description,\n location_lat, location_lon, location_address,\n startTime, endTime, durationMinutes, targetAudience,\n childrenWelcome, affordances, active, createdAt, updatedAt\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n activity.activityId,\n activity.ownerId,\n activity.type,\n activity.title,\n activity.description || null,\n activity.location.lat,\n activity.location.lon,\n activity.location.address || null,\n activity.startTime || null,\n activity.endTime || null,\n activity.durationMinutes || null,\n JSON.stringify(activity.targetAudience),\n activity.childrenWelcome ? 1 : 0,\n JSON.stringify(activity.affordances),\n activity.active ? 1 : 0,\n activity.createdAt,\n activity.updatedAt\n ]);\n}\n\nexport async function getActivityById(activityId: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM activities_v2 WHERE activityId = ?\",\n [activityId]\n );\n\n if (!result || !result.rows || result.rows.length === 0) return null;\n\n const row = result.rows[0];\n return {\n activityId: row.activityId,\n ownerId: row.ownerId,\n type: row.type,\n title: row.title,\n description: row.description,\n location: {\n lat: row.location_lat,\n lon: row.location_lon,\n address: row.location_address\n },\n startTime: row.startTime,\n endTime: row.endTime,\n durationMinutes: row.durationMinutes,\n targetAudience: JSON.parse(row.targetAudience),\n childrenWelcome: row.childrenWelcome === 1,\n affordances: JSON.parse(row.affordances || '[]'),\n active: row.active === 1,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n };\n}\n\nexport async function getActiveActivities(): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM activities_v2 WHERE active = 1 ORDER BY createdAt DESC\"\n );\n\n if (!result || !result.rows) return [];\n\n return result.rows.map(row => ({\n activityId: row.activityId,\n ownerId: row.ownerId,\n type: row.type,\n title: row.title,\n description: row.description,\n location: {\n lat: row.location_lat,\n lon: row.location_lon,\n address: row.location_address\n },\n startTime: row.startTime,\n endTime: row.endTime,\n durationMinutes: row.durationMinutes,\n targetAudience: JSON.parse(row.targetAudience),\n childrenWelcome: row.childrenWelcome === 1,\n affordances: JSON.parse(row.affordances || '[]'),\n active: row.active === 1,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n }));\n}\n\nexport async function deactivateActivity(activityId: string): Promise {\n await sqlite.execute(\n \"UPDATE activities_v2 SET active = 0, updatedAt = ? WHERE activityId = ?\",\n [new Date().toISOString(), activityId]\n );\n}\n\nexport async function getActivitiesByOwner(ownerId: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM activities_v2 WHERE ownerId = ? ORDER BY createdAt DESC\",\n [ownerId]\n );\n\n if (!result || !result.rows) return [];\n\n return result.rows.map(row => ({\n activityId: row.activityId,\n ownerId: row.ownerId,\n type: row.type,\n title: row.title,\n description: row.description,\n location: {\n lat: row.location_lat,\n lon: row.location_lon,\n address: row.location_address\n },\n startTime: row.startTime,\n endTime: row.endTime,\n durationMinutes: row.durationMinutes,\n targetAudience: JSON.parse(row.targetAudience),\n childrenWelcome: row.childrenWelcome === 1,\n affordances: JSON.parse(row.affordances || '[]'),\n active: row.active === 1,\n createdAt: row.createdAt,\n updatedAt: row.updatedAt\n }));\n}\n\n// Login token queries\nexport async function createLoginToken(email: string, userId: string): Promise {\n const token = 'login_' + Math.random().toString(36).substr(2, 32) + Date.now().toString(36);\n const expiresAt = new Date(Date.now() + 15 * 60 * 1000).toISOString(); // 15 minutes\n const createdAt = new Date().toISOString();\n\n await sqlite.execute(`\n INSERT INTO login_tokens_v1 (token, email, userId, expiresAt, createdAt)\n VALUES (?, ?, ?, ?, ?)\n `, [token, email, userId, expiresAt, createdAt]);\n\n return token;\n}\n\nexport async function getLoginToken(token: string): Promise<{\n token: string;\n email: string;\n userId: string;\n expiresAt: string;\n used: boolean;\n} | null> {\n const result = await sqlite.execute(\n \"SELECT * FROM login_tokens_v1 WHERE token = ?\",\n [token]\n );\n\n if (!result || !result.rows || result.rows.length === 0) {\n return null;\n }\n\n const row = result.rows[0];\n return {\n token: row.token,\n email: row.email,\n userId: row.userId,\n expiresAt: row.expiresAt,\n used: row.used === 1\n };\n}\n\nexport async function markTokenAsUsed(token: string): Promise {\n await sqlite.execute(\n \"UPDATE login_tokens_v1 SET used = 1 WHERE token = ?\",\n [token]\n );\n}\n\nexport async function cleanupExpiredTokens(): Promise {\n const now = new Date().toISOString();\n await sqlite.execute(\n \"DELETE FROM login_tokens_v1 WHERE expiresAt < ?\",\n [now]\n );\n}","deleted","label",[171,172,153],"backend","database","permalink","https://www.val.town/x/jessicaocean/OUT-app/code/backend/database/queries.ts","extension","actionData","errors"]