[{"_1":2,"_172":-5,"_173":-5},"loaderData",{"_3":4,"_91":92},"root",{"_5":6,"_34":35,"_64":65},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":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","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","7037b4412b49b7328160fa57e59f17dfe8779fc7","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":20,"_75":72,"_76":72,"_77":72,"_78":72,"_79":80,"_89":20,"_90":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",{"_81":20,"_19":20,"_82":72,"_83":84,"_85":72,"_86":45,"_87":20,"_88":72},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_93":94,"_95":96,"_97":98,"_99":100,"_146":147,"_169":170,"_171":-5},"handle","jex","name","io","path","backend/database/queries.ts","project",{"_101":102,"_95":96,"_103":104,"_105":-5,"_106":20,"_107":108,"_109":-5,"_110":-5,"_12":111,"_112":-5,"_113":20,"_114":-5,"_115":32,"_14":116,"_117":118,"_119":118,"_120":121,"_122":121,"_123":121,"_124":118,"_125":118,"_23":126,"_129":130,"_132":133,"_145":20},"id","77c1b38c-3947-11f0-b2d8-9e149126039e","createdAt",["D",1748163956311],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","06729840-3947-11f0-b940-6f99fbd8898f","pinnedFileId","pinPreview","screenshotVersion","likeCount","289d8aab-77c7-43d9-a1e8-d8dc0e3c1f1a","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeGE2SUNuVk1TaFdrWlFLRUhZd1B0UWNscDUifQ","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":-5,"_140":-5,"_141":-5,"_142":-5,"_143":96,"_144":94},"version",20,"77c20544-3947-11f0-b2d8-9e149126039e","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":148,"_95":149,"_150":151,"_152":153,"_154":136,"_155":156,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"b9339fe2-3947-11f0-9955-9e149126039e","queries.ts","fileId","b933a172-3947-11f0-9955-9e149126039e","parentId","951c3935-a61e-4c49-8e65-04f8f604b0ca","branchId","branchVersion",5,"latest",true,["D",1748164066107],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { User, Post, Comment, Message, ApiResponse } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(userData: {\n id: string;\n username: string;\n email: string;\n passwordHash: string;\n displayName: string;\n avatar?: string;\n}): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.USERS} (id, username, email, password_hash, display_name, avatar)\n VALUES (?, ?, ?, ?, ?, ?)`,\n [userData.id, userData.username, userData.email, userData.passwordHash, userData.displayName, userData.avatar || null]\n );\n\n return getUserById(userData.id);\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, display_name, avatar, bio, illustration_3d, created_at, updated_at\n FROM ${TABLES.USERS} WHERE id = ?`,\n [id]\n );\n\n if (result.length === 0) {\n throw new Error('User not found');\n }\n\n const row = result[0];\n return {\n id: row.id,\n username: row.username,\n email: row.email,\n displayName: row.display_name,\n avatar: row.avatar,\n bio: row.bio,\n illustration3D: row.illustration_3d,\n createdAt: row.created_at,\n updatedAt: row.updated_at\n };\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, display_name, avatar, bio, illustration_3d, created_at, updated_at\n FROM ${TABLES.USERS} WHERE email = ?`,\n [email]\n );\n\n if (result.length === 0) {\n return null;\n }\n\n const row = result[0];\n return {\n id: row.id,\n username: row.username,\n email: row.email,\n displayName: row.display_name,\n avatar: row.avatar,\n bio: row.bio,\n illustration3D: row.illustration_3d,\n createdAt: row.created_at,\n updatedAt: row.updated_at\n };\n}\n\nexport async function getUserPasswordHash(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT password_hash FROM ${TABLES.USERS} WHERE email = ?`,\n [email]\n );\n\n return result.length > 0 ? result[0].password_hash : null;\n}\n\nexport async function updateUser(id: string, updates: {\n displayName?: string;\n bio?: string;\n illustration3D?: string;\n}): Promise {\n const setParts = [];\n const values = [];\n\n if (updates.displayName !== undefined) {\n setParts.push('display_name = ?');\n values.push(updates.displayName);\n }\n if (updates.bio !== undefined) {\n setParts.push('bio = ?');\n values.push(updates.bio);\n }\n if (updates.illustration3D !== undefined) {\n setParts.push('illustration_3d = ?');\n values.push(updates.illustration3D);\n }\n\n if (setParts.length === 0) {\n return getUserById(id);\n }\n\n setParts.push('updated_at = CURRENT_TIMESTAMP');\n values.push(id);\n\n await sqlite.execute(\n `UPDATE ${TABLES.USERS} SET ${setParts.join(', ')} WHERE id = ?`,\n values\n );\n\n return getUserById(id);\n}\n\n// Post queries\nexport async function createPost(postData: {\n id: string;\n userId: string;\n content: string;\n imageUrl?: string;\n}): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.POSTS} (id, user_id, content, image_url)\n VALUES (?, ?, ?, ?)`,\n [postData.id, postData.userId, postData.content, postData.imageUrl || null]\n );\n\n return getPostById(postData.id);\n}\n\nexport async function getPostById(id: string): Promise {\n const result = await sqlite.execute(\n `SELECT p.*, u.username, u.display_name, u.avatar, u.illustration_3d\n FROM ${TABLES.POSTS} p\n JOIN ${TABLES.USERS} u ON p.user_id = u.id\n WHERE p.id = ?`,\n [id]\n );\n\n if (result.length === 0) {\n throw new Error('Post not found');\n }\n\n const row = result[0];\n return {\n id: row.id,\n userId: row.user_id,\n content: row.content,\n imageUrl: row.image_url,\n likes: row.likes_count,\n comments: row.comments_count,\n createdAt: row.created_at,\n updatedAt: row.updated_at,\n user: {\n id: row.user_id,\n username: row.username,\n email: '', // Don't expose email in posts\n displayName: row.display_name,\n avatar: row.avatar,\n illustration3D: row.illustration_3d,\n createdAt: '',\n updatedAt: ''\n }\n };\n}\n\nexport async function getPosts(page: number = 1, limit: number = 20): Promise<{\n posts: Post[];\n hasMore: boolean;\n total: number;\n}> {\n const offset = (page - 1) * limit;\n\n // Get total count\n const countResult = await sqlite.execute(`SELECT COUNT(*) as count FROM ${TABLES.POSTS}`);\n const total = countResult[0].count;\n\n // Get posts with user data\n const result = await sqlite.execute(\n `SELECT p.*, u.username, u.display_name, u.avatar, u.illustration_3d\n FROM ${TABLES.POSTS} p\n JOIN ${TABLES.USERS} u ON p.user_id = u.id\n ORDER BY p.created_at DESC\n LIMIT ? OFFSET ?`,\n [limit, offset]\n );\n\n const posts = result.map(row => ({\n id: row.id,\n userId: row.user_id,\n content: row.content,\n imageUrl: row.image_url,\n likes: row.likes_count,\n comments: row.comments_count,\n createdAt: row.created_at,\n updatedAt: row.updated_at,\n user: {\n id: row.user_id,\n username: row.username,\n email: '',\n displayName: row.display_name,\n avatar: row.avatar,\n illustration3D: row.illustration_3d,\n createdAt: '',\n updatedAt: ''\n }\n }));\n\n return {\n posts,\n hasMore: offset + limit < total,\n total\n };\n}\n\n// Message queries\nexport async function createMessage(messageData: {\n id: string;\n senderId: string;\n receiverId: string;\n content: string;\n type: string;\n}): Promise {\n await sqlite.execute(\n `INSERT INTO ${TABLES.MESSAGES} (id, sender_id, receiver_id, content, type)\n VALUES (?, ?, ?, ?, ?)`,\n [messageData.id, messageData.senderId, messageData.receiverId, messageData.content, messageData.type]\n );\n\n const result = await sqlite.execute(\n `SELECT m.*, u.username, u.display_name, u.avatar\n FROM ${TABLES.MESSAGES} m\n JOIN ${TABLES.USERS} u ON m.sender_id = u.id\n WHERE m.id = ?`,\n [messageData.id]\n );\n\n const row = result[0];\n return {\n id: row.id,\n senderId: row.sender_id,\n receiverId: row.receiver_id,\n content: row.content,\n type: row.type,\n createdAt: row.created_at,\n sender: {\n id: row.sender_id,\n username: row.username,\n email: '',\n displayName: row.display_name,\n avatar: row.avatar,\n createdAt: '',\n updatedAt: ''\n }\n };\n}\n\nexport async function getMessages(userId1: string, userId2: string, limit: number = 50): Promise {\n const result = await sqlite.execute(\n `SELECT m.*, u.username, u.display_name, u.avatar\n FROM ${TABLES.MESSAGES} m\n JOIN ${TABLES.USERS} u ON m.sender_id = u.id\n WHERE (m.sender_id = ? AND m.receiver_id = ?) OR (m.sender_id = ? AND m.receiver_id = ?)\n ORDER BY m.created_at DESC\n LIMIT ?`,\n [userId1, userId2, userId2, userId1, limit]\n );\n\n return result.map(row => ({\n id: row.id,\n senderId: row.sender_id,\n receiverId: row.receiver_id,\n content: row.content,\n type: row.type,\n createdAt: row.created_at,\n sender: {\n id: row.sender_id,\n username: row.username,\n email: '',\n displayName: row.display_name,\n avatar: row.avatar,\n createdAt: '',\n updatedAt: ''\n }\n })).reverse();\n}\n\n// Like queries\nexport async function toggleLike(userId: string, postId: string): Promise {\n // Check if like exists\n const existingLike = await sqlite.execute(\n `SELECT id FROM ${TABLES.LIKES} WHERE user_id = ? AND post_id = ?`,\n [userId, postId]\n );\n\n if (existingLike.length > 0) {\n // Remove like\n await sqlite.execute(\n `DELETE FROM ${TABLES.LIKES} WHERE user_id = ? AND post_id = ?`,\n [userId, postId]\n );\n \n // Decrement likes count\n await sqlite.execute(\n `UPDATE ${TABLES.POSTS} SET likes_count = likes_count - 1 WHERE id = ?`,\n [postId]\n );\n \n return false;\n } else {\n // Add like\n const likeId = Math.random().toString(36).substring(2) + Date.now().toString(36);\n await sqlite.execute(\n `INSERT INTO ${TABLES.LIKES} (id, user_id, post_id) VALUES (?, ?, ?)`,\n [likeId, userId, postId]\n );\n \n // Increment likes count\n await sqlite.execute(\n `UPDATE ${TABLES.POSTS} SET likes_count = likes_count + 1 WHERE id = ?`,\n [postId]\n );\n \n return true;\n }\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/jex/io/code/backend/database/queries.ts","extension","actionData","errors"]