[{"_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","4ff166458996ccfe3bfa8627489090938620785a","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,"_147":148,"_169":170,"_171":-5},"handle","cgshaq","name","AccessBankMobile","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,"_146":20},"id","93fde244-6b4e-11f0-ba48-0224a6c84d84","createdAt",["D",1753664568269],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","621eed50-3646-11f0-b033-79986dd337ba","pinnedFileId","pinPreview","screenshotVersion","likeCount","24aca6c6-2196-47e2-8492-13944ae1b063","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4UEo4eXpqZnZPYlE1MVcwTGpkUXJFNFR0YyJ9","org",{"_93":94,"_131":128},"avatar","branch",{"_134":135,"_95":43,"_101":136,"_137":102,"_138":-5,"_139":140,"_141":-5,"_142":-5,"_143":-5,"_144":96,"_145":94},"version",1,"94007342-6b4e-11f0-ba48-0224a6c84d84","projectId","forkedBranchId","forkedBranchVersion",59,"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_101":149,"_95":150,"_151":152,"_153":154,"_155":136,"_156":135,"_157":158,"_103":159,"_134":32,"_160":161,"_162":163,"_164":20,"_165":-5,"_97":166},"940547d2-6b4e-11f0-ba48-0224a6c84d84","queries.ts","fileId","01984e8d-bc0e-764a-9cab-997b09fc72a3","parentId","01984e8d-bc0e-764a-9cab-9c8a8ebb4f1b","branchId","branchVersion","latest",true,["D",1753664568269],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { TABLES } from \"./migrations.ts\";\nimport type { User, Account, Transaction, EuropeanBank } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(userData: {\n id: string;\n loginId: string;\n firstName: string;\n lastName: string;\n email: string;\n phone: string;\n passwordHash: string;\n}): Promise {\n console.log('Creating user in database:', userData.loginId);\n const result = await sqlite.execute(`\n INSERT INTO ${TABLES.USERS} (id, loginId, firstName, lastName, email, phone, passwordHash)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [userData.id, userData.loginId, userData.firstName, userData.lastName, userData.email, userData.phone, userData.passwordHash]);\n console.log('User creation result:', result);\n}\n\nexport async function getUserByLoginId(loginId: string): Promise {\n console.log('Searching for user with loginId:', loginId);\n const result = await sqlite.execute(`\n SELECT id, loginId, firstName, lastName, email, phone, createdAt\n FROM ${TABLES.USERS}\n WHERE loginId = ?\n `, [loginId]);\n \n console.log('Query result:', result);\n return result.rows && result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getUserById(id: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, loginId, firstName, lastName, email, phone, createdAt\n FROM ${TABLES.USERS}\n WHERE id = ?\n `, [id]);\n \n return result.rows && 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, loginId, firstName, lastName, email, phone, createdAt\n FROM ${TABLES.USERS}\n WHERE email = ?\n `, [email]);\n \n return result.rows && result.rows.length > 0 ? result.rows[0] as User : null;\n}\n\nexport async function getUserPasswordHash(loginId: string): Promise {\n const result = await sqlite.execute(`\n SELECT passwordHash FROM ${TABLES.USERS} WHERE loginId = ?\n `, [loginId]);\n \n return result.rows && result.rows.length > 0 ? result.rows[0].passwordHash : null;\n}\n\nexport async function updateUserPassword(loginId: string, passwordHash: string): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.USERS} SET passwordHash = ? WHERE loginId = ?\n `, [passwordHash, loginId]);\n}\n\n// Account queries\nexport async function createAccount(accountData: {\n id: string;\n userId: string;\n accountNumber: string;\n accountType: string;\n balance: number;\n currency: string;\n nextOfKin: string;\n}): Promise {\n await sqlite.execute(`\n INSERT INTO ${TABLES.ACCOUNTS} (id, userId, accountNumber, accountType, balance, currency, nextOfKin)\n VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [accountData.id, accountData.userId, accountData.accountNumber, accountData.accountType, accountData.balance, accountData.currency, accountData.nextOfKin]);\n}\n\nexport async function getAccountsByUserId(userId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.ACCOUNTS} WHERE userId = ?\n `, [userId]);\n \n return result.rows || [];\n}\n\nexport async function getAccountById(accountId: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.ACCOUNTS} WHERE id = ?\n `, [accountId]);\n \n return result.rows && result.rows.length > 0 ? result.rows[0] as Account : null;\n}\n\nexport async function updateAccountBalance(accountId: string, newBalance: number): Promise {\n await sqlite.execute(`\n UPDATE ${TABLES.ACCOUNTS} SET balance = ? WHERE id = ?\n `, [newBalance, accountId]);\n}\n\n// Transaction queries\nexport async function createTransaction(transactionData: {\n id: string;\n accountId: string;\n type: 'credit' | 'debit';\n amount: number;\n currency: string;\n description: string;\n recipientBank?: string;\n recipientAccount?: string;\n recipientName?: string;\n reference: string;\n status: string;\n}): Promise {\n await sqlite.execute(`\n INSERT INTO ${TABLES.TRANSACTIONS} \n (id, accountId, type, amount, currency, description, recipientBank, recipientAccount, recipientName, reference, status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n transactionData.id,\n transactionData.accountId,\n transactionData.type,\n transactionData.amount,\n transactionData.currency,\n transactionData.description,\n transactionData.recipientBank || null,\n transactionData.recipientAccount || null,\n transactionData.recipientName || null,\n transactionData.reference,\n transactionData.status\n ]);\n}\n\nexport async function createTransactionWithDate(transactionData: {\n id: string;\n accountId: string;\n type: 'credit' | 'debit';\n amount: number;\n currency: string;\n description: string;\n recipientBank?: string;\n recipientAccount?: string;\n recipientName?: string;\n reference: string;\n status: string;\n createdAt: string;\n}): Promise {\n await sqlite.execute(`\n INSERT INTO ${TABLES.TRANSACTIONS} \n (id, accountId, type, amount, currency, description, recipientBank, recipientAccount, recipientName, reference, status, createdAt)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n transactionData.id,\n transactionData.accountId,\n transactionData.type,\n transactionData.amount,\n transactionData.currency,\n transactionData.description,\n transactionData.recipientBank || null,\n transactionData.recipientAccount || null,\n transactionData.recipientName || null,\n transactionData.reference,\n transactionData.status,\n transactionData.createdAt\n ]);\n}\n\nexport async function getTransactionsByAccountId(accountId: string, limit: number = 15): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.TRANSACTIONS} \n WHERE accountId = ? \n ORDER BY createdAt DESC \n LIMIT ?\n `, [accountId, limit]);\n \n return result.rows || [];\n}\n\n// European Banks queries\nexport async function getAllEuropeanBanks(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.EUROPEAN_BANKS} ORDER BY name\n `);\n \n return result.rows || [];\n}\n\nexport async function getBankBySwiftCode(swiftCode: string): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM ${TABLES.EUROPEAN_BANKS} WHERE swiftCode = ?\n `, [swiftCode]);\n \n return result.rows && result.rows.length > 0 ? result.rows[0] as EuropeanBank : null;\n}\n\n// Session queries\nexport async function createSession(sessionData: {\n id: string;\n userId: string;\n token: string;\n expiresAt: string;\n}): Promise {\n await sqlite.execute(`\n INSERT INTO ${TABLES.SESSIONS} (id, userId, token, expiresAt)\n VALUES (?, ?, ?, ?)\n `, [sessionData.id, sessionData.userId, sessionData.token, sessionData.expiresAt]);\n}\n\nexport async function getSessionByToken(token: string): Promise<{ userId: string; expiresAt: string } | null> {\n const result = await sqlite.execute(`\n SELECT userId, expiresAt FROM ${TABLES.SESSIONS} WHERE token = ?\n `, [token]);\n \n return result.rows && result.rows.length > 0 ? result.rows[0] as { userId: string; expiresAt: string } : null;\n}\n\nexport async function deleteSession(token: string): Promise {\n await sqlite.execute(`\n DELETE FROM ${TABLES.SESSIONS} WHERE token = ?\n `, [token]);\n}\n\nexport async function deleteExpiredSessions(): Promise {\n await sqlite.execute(`\n DELETE FROM ${TABLES.SESSIONS} WHERE expiresAt < datetime('now')\n `);\n}","deleted","label",[167,168,150],"backend","database","permalink","https://www.val.town/x/cgshaq/AccessBankMobile/code/backend/database/queries.ts","extension","actionData","errors"]