[{"_1":2,"_176":-5,"_177":-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","0fffb492b08724537e73cd8bc4c3f31babbf0bd5","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,"_150":151,"_173":174,"_175":-5},"handle","charmaine","name","TastkIt","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,"_149":20},"id","5e192470-3644-11f0-a4c9-9e149126039e","createdAt",["D",1747832771281],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","c156eb0e-8b9d-4104-a055-502e9a0eb441","pinnedFileId","pinPreview","screenshotVersion","likeCount","2019e55b-c541-4c51-bef0-008eef10ef88","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJ4cFpFME5pSXNZamJNd296dlZSYVJ0OVF1RSJ9","org",{"_93":94,"_131":128,"_12":111},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":139,"_140":141,"_142":108,"_143":144,"_145":146,"_147":96,"_148":94},"version",14,"5e1aa35e-3644-11f0-a4c9-9e149126039e","projectId","forkedBranchId","bc9a7108-34c7-11f0-9565-9e149126039e","forkedBranchVersion",58,"forkedProjectPrivacy","forkedProjectId","bc9a2766-34c7-11f0-9565-9e149126039e","forkedProjectOrgId","39c8580e-ee92-40a4-b9a2-165f574b6ae2","projectName","userHandle","isOwned","file",{"_101":152,"_95":153,"_154":155,"_156":157,"_158":136,"_159":160,"_161":162,"_103":163,"_134":32,"_164":165,"_166":167,"_168":20,"_169":-5,"_97":170},"5e1c940c-3644-11f0-a4c9-9e149126039e","queries.ts","fileId","73ba4434-aff2-4846-8ff3-30cfc1ee2a4e","parentId","84ae2a43-05e1-4b3c-b52e-689bf473eb4c","branchId","branchVersion",1,"latest",true,["D",1747832771281],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { USERS_TABLE, PROJECTS_TABLE, TASKS_TABLE } from \"./migrations.ts\";\nimport { User, Project, Task, CreateUserInput, CreateProjectInput, CreateTaskInput, UpdateTaskInput } from \"../../shared/types.ts\";\n\n// Função simples para hash de senha\nasync function hashPassword(password: string): Promise {\n // Em produção, use uma biblioteca de hash mais segura\n // Esta é uma implementação básica para demonstração\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"taskmaster-salt\");\n const hashBuffer = await crypto.subtle.digest(\"SHA-256\", data);\n const hashArray = Array.from(new Uint8Array(hashBuffer));\n return hashArray.map(b => b.toString(16).padStart(2, '0')).join('');\n}\n\n// Função para verificar senha\nasync function verifyPasswordHash(password: string, hash: string): Promise {\n const calculatedHash = await hashPassword(password);\n return calculatedHash === hash;\n}\n\n// ==================== Funções de Usuário ====================\n\nexport async function createUser(input: CreateUserInput): Promise {\n try {\n // Verificar novamente se o email ou username já existem (para evitar condições de corrida)\n const existingEmail = await getUserByEmail(input.email);\n if (existingEmail) {\n throw new Error(\"Email já está em uso\");\n }\n \n const existingUsername = await getUserByUsername(input.username);\n if (existingUsername) {\n throw new Error(\"Nome de usuário já está em uso\");\n }\n \n const passwordHash = await hashPassword(input.password);\n \n const result = await sqlite.execute(\n `INSERT INTO ${USERS_TABLE} (username, email, password_hash) \n VALUES (?, ?, ?) \n RETURNING id, username, email, created_at, updated_at`,\n [input.username, input.email, passwordHash]\n );\n \n if (!result.rows || result.rows.length === 0) {\n throw new Error(\"Falha ao criar usuário: nenhum dado retornado\");\n }\n \n return result.rows[0] as User;\n } catch (error) {\n console.error(\"Erro detalhado ao criar usuário:\", error);\n throw error; // Re-lançar o erro para ser tratado na camada de API\n }\n}\n\nexport async function getUserByUsername(username: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, password_hash, created_at, updated_at \n FROM ${USERS_TABLE} \n WHERE username = ?`,\n [username]\n );\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, password_hash, created_at, updated_at \n FROM ${USERS_TABLE} \n WHERE email = ?`,\n [email]\n );\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, username, email, created_at, updated_at \n FROM ${USERS_TABLE} \n WHERE id = ?`,\n [id]\n );\n \n return result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function verifyPassword(plainPassword: string, hashedPassword: string): Promise {\n return await verifyPasswordHash(plainPassword, hashedPassword);\n}\n\n// ==================== Funções de Projeto ====================\n\nexport async function createProject(input: CreateProjectInput): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${PROJECTS_TABLE} (name, color, user_id) \n VALUES (?, ?, ?) \n RETURNING id, name, color, user_id, created_at, updated_at`,\n [input.name, input.color || '#808080', input.userId]\n );\n \n return result.rows[0] as Project;\n}\n\nexport async function getProjectsByUserId(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, name, color, user_id, created_at, updated_at \n FROM ${PROJECTS_TABLE} \n WHERE user_id = ? \n ORDER BY created_at ASC`,\n [userId]\n );\n \n return result.rows as Project[];\n}\n\nexport async function getProjectById(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, name, color, user_id, created_at, updated_at \n FROM ${PROJECTS_TABLE} \n WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rows.length > 0 ? result.rows[0] as Project : null;\n}\n\nexport async function updateProject(id: number, userId: number, name: string, color?: string): Promise {\n const updateFields = [];\n const params = [];\n \n if (name) {\n updateFields.push(\"name = ?\");\n params.push(name);\n }\n \n if (color) {\n updateFields.push(\"color = ?\");\n params.push(color);\n }\n \n if (updateFields.length === 0) {\n return await getProjectById(id, userId);\n }\n \n updateFields.push(\"updated_at = datetime('now')\");\n \n const query = `\n UPDATE ${PROJECTS_TABLE} \n SET ${updateFields.join(\", \")} \n WHERE id = ? AND user_id = ? \n RETURNING id, name, color, user_id, created_at, updated_at\n `;\n \n params.push(id, userId);\n \n const result = await sqlite.execute(query, params);\n \n return result.rows.length > 0 ? result.rows[0] as Project : null;\n}\n\nexport async function deleteProject(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${PROJECTS_TABLE} \n WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rowsAffected > 0;\n}\n\n// ==================== Funções de Tarefa ====================\n\nexport async function createTask(input: CreateTaskInput): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${TASKS_TABLE} (title, description, due_date, priority, project_id, user_id) \n VALUES (?, ?, ?, ?, ?, ?) \n RETURNING id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at`,\n [\n input.title, \n input.description || null, \n input.dueDate || null, \n input.priority || 4, \n input.projectId, \n input.userId\n ]\n );\n \n return result.rows[0] as Task;\n}\n\nexport async function getTasksByProjectId(projectId: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at \n FROM ${TASKS_TABLE} \n WHERE project_id = ? AND user_id = ? \n ORDER BY \n completed ASC, \n CASE \n WHEN due_date IS NULL THEN 1 \n ELSE 0 \n END, \n due_date ASC, \n priority ASC`,\n [projectId, userId]\n );\n \n return result.rows as Task[];\n}\n\nexport async function getTasksByUserId(userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at \n FROM ${TASKS_TABLE} \n WHERE user_id = ? \n ORDER BY \n completed ASC, \n CASE \n WHEN due_date IS NULL THEN 1 \n ELSE 0 \n END, \n due_date ASC, \n priority ASC`,\n [userId]\n );\n \n return result.rows as Task[];\n}\n\nexport async function getTaskById(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `SELECT id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at \n FROM ${TASKS_TABLE} \n WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rows.length > 0 ? result.rows[0] as Task : null;\n}\n\nexport async function updateTask(id: number, userId: number, input: UpdateTaskInput): Promise {\n const updateFields = [];\n const params = [];\n \n if (input.title !== undefined) {\n updateFields.push(\"title = ?\");\n params.push(input.title);\n }\n \n if (input.description !== undefined) {\n updateFields.push(\"description = ?\");\n params.push(input.description);\n }\n \n if (input.dueDate !== undefined) {\n updateFields.push(\"due_date = ?\");\n params.push(input.dueDate);\n }\n \n if (input.priority !== undefined) {\n updateFields.push(\"priority = ?\");\n params.push(input.priority);\n }\n \n if (input.completed !== undefined) {\n updateFields.push(\"completed = ?\");\n params.push(input.completed ? 1 : 0);\n }\n \n if (input.projectId !== undefined) {\n updateFields.push(\"project_id = ?\");\n params.push(input.projectId);\n }\n \n if (updateFields.length === 0) {\n return await getTaskById(id, userId);\n }\n \n updateFields.push(\"updated_at = datetime('now')\");\n \n const query = `\n UPDATE ${TASKS_TABLE} \n SET ${updateFields.join(\", \")} \n WHERE id = ? AND user_id = ? \n RETURNING id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at\n `;\n \n params.push(id, userId);\n \n const result = await sqlite.execute(query, params);\n \n return result.rows.length > 0 ? result.rows[0] as Task : null;\n}\n\nexport async function toggleTaskCompletion(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `UPDATE ${TASKS_TABLE} \n SET completed = CASE WHEN completed = 0 THEN 1 ELSE 0 END, \n updated_at = datetime('now') \n WHERE id = ? AND user_id = ? \n RETURNING id, title, description, due_date, priority, completed, project_id, user_id, created_at, updated_at`,\n [id, userId]\n );\n \n return result.rows.length > 0 ? result.rows[0] as Task : null;\n}\n\nexport async function deleteTask(id: number, userId: number): Promise {\n const result = await sqlite.execute(\n `DELETE FROM ${TASKS_TABLE} \n WHERE id = ? AND user_id = ?`,\n [id, userId]\n );\n \n return result.rowsAffected > 0;\n}","deleted","label",[171,172,153],"backend","database","permalink","https://www.val.town/x/charmaine/TastkIt/code/backend/database/queries.ts","extension","actionData","errors"]