[{"_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","4665abaede64d7a40f12c22a2a13ecb98867c1ee","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","wahobd","name","TaskWaho","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","e1facabc-33c6-11f0-8d8d-9e149126039e","createdAt",["D",1747558973632],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","8e0cb670-0173-11f0-8fc2-29ca0ea0c0ed","pinnedFileId","pinPreview","screenshotVersion","likeCount","cf832929-9b29-451f-a2c4-eccee50aba5c","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ1TFF3NjBXTTBuSThiWUhvMGJibVVxZmNSMCJ9","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",17,"e1fafc6c-33c6-11f0-8d8d-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},"4e3ff120-33c7-11f0-a36a-9e149126039e","queries.ts","fileId","4e3ff1ca-33c7-11f0-a36a-9e149126039e","parentId","214a2c50-722f-419f-a3a8-275f6e8ea7e4","branchId","branchVersion",3,"latest",true,["D",1747559155276],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, TASKS_TABLE, EARNINGS_TABLE, SETTINGS_TABLE } from \"./schema.ts\";\n\n// Types\nexport interface User {\n id: number;\n username: string;\n email: string | null;\n balance: number;\n created_at: string;\n}\n\nexport interface Task {\n id: number;\n title: string;\n description: string | null;\n reward: number;\n user_id: number;\n completed: boolean;\n created_at: string;\n}\n\nexport interface Earning {\n id: number;\n user_id: number;\n amount: number;\n description: string | null;\n created_at: string;\n}\n\nexport interface Settings {\n id: number;\n user_id: number;\n theme: string;\n notifications_enabled: boolean;\n created_at: string;\n}\n\n// User queries\nexport async function createUser(username: string, passwordHash: string, email?: string): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (username, password_hash, email) VALUES (?, ?, ?)`,\n [username, passwordHash, email || null]\n );\n \n // Create default settings for the user\n if (result.lastInsertId) {\n await sqlite.execute(\n `INSERT INTO ${SETTINGS_TABLE} (user_id) VALUES (?)`,\n [result.lastInsertId]\n );\n }\n \n return result.lastInsertId || 0;\n}\n\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${USERS_TABLE} WHERE username = ?`,\n [username]\n );\n \n return result.rows[0] || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, balance, created_at FROM ${USERS_TABLE} WHERE id = ?`,\n [id]\n );\n \n return result.rows[0] || null;\n}\n\nexport async function updateUserBalance(userId: number, amount: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${USERS_TABLE} SET balance = balance + ? WHERE id = ?`,\n [amount, userId]\n );\n \n return result.rowsAffected > 0;\n}\n\n// Task queries\nexport async function createTask(title: string, description: string | null, reward: number, userId: number): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TASKS_TABLE} (title, description, reward, user_id) VALUES (?, ?, ?, ?)`,\n [title, description, reward, userId]\n );\n \n return result.lastInsertId || 0;\n}\n\nexport async function getTasks(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.rows.map(row => ({\n ...row,\n completed: Boolean(row.completed)\n }));\n}\n\nexport async function getTaskById(taskId: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${TASKS_TABLE} WHERE id = ? AND user_id = ?`,\n [taskId, userId]\n );\n \n if (!result.rows[0]) return null;\n \n return {\n ...result.rows[0],\n completed: Boolean(result.rows[0].completed)\n };\n}\n\nexport async function completeTask(taskId: number, userId: number): Promise {\n const task = await getTaskById(taskId, userId);\n if (!task || task.completed) return false;\n \n // Start a transaction\n await sqlite.execute('BEGIN TRANSACTION');\n \n try {\n // Mark task as completed\n await sqlite.execute(\n `UPDATE ${TASKS_TABLE} SET completed = 1 WHERE id = ? AND user_id = ?`,\n [taskId, userId]\n );\n \n // Add reward to user balance\n await updateUserBalance(userId, task.reward);\n \n // Record the earning\n await sqlite.execute(\n `INSERT INTO ${EARNINGS_TABLE} (user_id, amount, description) VALUES (?, ?, ?)`,\n [userId, task.reward, `Completed task: ${task.title}`]\n );\n \n await sqlite.execute('COMMIT');\n return true;\n } catch (error) {\n await sqlite.execute('ROLLBACK');\n throw error;\n }\n}\n\n// Earnings queries\nexport async function getEarnings(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${EARNINGS_TABLE} WHERE user_id = ? ORDER BY created_at DESC`,\n [userId]\n );\n \n return result.rows;\n}\n\n// Settings queries\nexport async function getSettings(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT * FROM ${SETTINGS_TABLE} WHERE user_id = ?`,\n [userId]\n );\n \n if (!result.rows[0]) return null;\n \n return {\n ...result.rows[0],\n notifications_enabled: Boolean(result.rows[0].notifications_enabled)\n };\n}\n\nexport async function updateSettings(userId: number, theme?: string, notificationsEnabled?: boolean): Promise {\n const updates = [];\n const params = [];\n \n if (theme !== undefined) {\n updates.push('theme = ?');\n params.push(theme);\n }\n \n if (notificationsEnabled !== undefined) {\n updates.push('notifications_enabled = ?');\n params.push(notificationsEnabled ? 1 : 0);\n }\n \n if (updates.length === 0) return false;\n \n params.push(userId);\n \n const result = await sqlite.execute(\n `UPDATE ${SETTINGS_TABLE} SET ${updates.join(', ')} WHERE user_id = ?`,\n params\n );\n \n return result.rowsAffected > 0;\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/wahobd/TaskWaho/code/backend/database/queries.ts","extension","actionData","errors"]