[{"_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","Aditi_Deshmukh","name","PetWebsite","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","b4836c04-3b11-11f0-b905-9e149126039e","createdAt",["D",1748360767746],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","6663e170-3b11-11f0-b284-7173a8a6f515","pinnedFileId","pinPreview","screenshotVersion","likeCount","bb6c8ba0-ae36-4df2-9912-6a5eb6ccb1c3","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_93":94,"_127":128},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4Z1hKOEY1SmlvTkJhZnhjaUtrb1hDZk04OCJ9","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",19,"b483a91c-3b11-11f0-b905-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},"419995f0-3b12-11f0-974a-9e149126039e","queries.ts","fileId","419996e0-3b12-11f0-974a-9e149126039e","parentId","8e085336-bebc-47bc-bdf7-f16e5b5ad1a5","branchId","branchVersion",5,"latest",true,["D",1748361004447],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { User, Pet, AdoptionApplication, GroomingAppointment, VetAppointment, Product, CartItem, Order } from \"../../shared/types.ts\";\n\n// User queries\nexport async function createUser(email: string, passwordHash: string, name: string, phone?: string, address?: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO users_v1 (email, password_hash, name, phone, address)\n VALUES (?, ?, ?, ?, ?)\n `, [email, passwordHash, name, phone || null, address || null]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const result = await sqlite.execute(`\n SELECT id, email, name, phone, address, role, created_at\n FROM users_v1 \n WHERE email = ?\n `, [email]);\n \n return result.rows[0] as User || null;\n}\n\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT id, email, name, phone, address, role, created_at\n FROM users_v1 \n WHERE id = ?\n `, [id]);\n \n return result.rows[0] as User || null;\n}\n\nexport async function getUserPasswordHash(email: string): Promise {\n const result = await sqlite.execute(`\n SELECT password_hash FROM users_v1 WHERE email = ?\n `, [email]);\n \n return result.rows[0]?.password_hash as string || null;\n}\n\n// Pet queries\nexport async function createPet(petData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO pets_v1 (\n name, species, breed, age, gender, size, color, description,\n health_status, vaccination_status, spayed_neutered, good_with_kids,\n good_with_pets, energy_level, adoption_fee, owner_id\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n petData.name, petData.species, petData.breed, petData.age, petData.gender,\n petData.size, petData.color, petData.description, petData.health_status,\n petData.vaccination_status, petData.spayed_neutered, petData.good_with_kids,\n petData.good_with_pets, petData.energy_level, petData.adoption_fee, petData.owner_id\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getAllPets(status?: string): Promise {\n let query = `\n SELECT p.*, u.name as owner_name, u.email as owner_email\n FROM pets_v1 p\n JOIN users_v1 u ON p.owner_id = u.id\n `;\n const params: any[] = [];\n \n if (status) {\n query += ` WHERE p.status = ?`;\n params.push(status);\n }\n \n query += ` ORDER BY p.created_at DESC`;\n \n const result = await sqlite.execute(query, params);\n return result.rows as Pet[];\n}\n\nexport async function getPetById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT p.*, u.name as owner_name, u.email as owner_email, u.phone as owner_phone\n FROM pets_v1 p\n JOIN users_v1 u ON p.owner_id = u.id\n WHERE p.id = ?\n `, [id]);\n \n return result.rows[0] as Pet || null;\n}\n\nexport async function updatePetStatus(id: number, status: string): Promise {\n await sqlite.execute(`\n UPDATE pets_v1 SET status = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?\n `, [status, id]);\n}\n\n// Adoption application queries\nexport async function createAdoptionApplication(applicationData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO adoption_applications_v1 (\n pet_id, applicant_id, housing_type, has_yard, other_pets,\n experience, reason, references\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n applicationData.pet_id, applicationData.applicant_id, applicationData.housing_type,\n applicationData.has_yard, applicationData.other_pets, applicationData.experience,\n applicationData.reason, applicationData.references\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getAdoptionApplicationsByPet(petId: number): Promise {\n const result = await sqlite.execute(`\n SELECT a.*, u.name as applicant_name, u.email as applicant_email, u.phone as applicant_phone\n FROM adoption_applications_v1 a\n JOIN users_v1 u ON a.applicant_id = u.id\n WHERE a.pet_id = ?\n ORDER BY a.created_at DESC\n `, [petId]);\n \n return result.rows as AdoptionApplication[];\n}\n\nexport async function updateAdoptionApplicationStatus(id: number, status: string): Promise {\n await sqlite.execute(`\n UPDATE adoption_applications_v1 SET status = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?\n `, [status, id]);\n}\n\n// Grooming service queries\nexport async function getGroomingServices(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM grooming_services_v1 ORDER BY category, price\n `);\n \n return result.rows;\n}\n\nexport async function createGroomingAppointment(appointmentData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO grooming_appointments_v1 (\n user_id, service_id, pet_name, pet_breed, appointment_date,\n appointment_time, notes\n ) VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n appointmentData.user_id, appointmentData.service_id, appointmentData.pet_name,\n appointmentData.pet_breed, appointmentData.appointment_date, appointmentData.appointment_time,\n appointmentData.notes\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getGroomingAppointmentsByUser(userId: number): Promise {\n const result = await sqlite.execute(`\n SELECT ga.*, gs.name as service_name, gs.price as service_price\n FROM grooming_appointments_v1 ga\n JOIN grooming_services_v1 gs ON ga.service_id = gs.id\n WHERE ga.user_id = ?\n ORDER BY ga.appointment_date DESC, ga.appointment_time DESC\n `, [userId]);\n \n return result.rows as GroomingAppointment[];\n}\n\n// Veterinary service queries\nexport async function getVeterinaryServices(): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM veterinary_services_v1 ORDER BY category, price\n `);\n \n return result.rows;\n}\n\nexport async function createVetAppointment(appointmentData: Omit): Promise {\n const result = await sqlite.execute(`\n INSERT INTO vet_appointments_v1 (\n user_id, service_id, pet_name, pet_species, appointment_date,\n appointment_time, symptoms\n ) VALUES (?, ?, ?, ?, ?, ?, ?)\n `, [\n appointmentData.user_id, appointmentData.service_id, appointmentData.pet_name,\n appointmentData.pet_species, appointmentData.appointment_date, appointmentData.appointment_time,\n appointmentData.symptoms\n ]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function getVetAppointmentsByUser(userId: number): Promise {\n const result = await sqlite.execute(`\n SELECT va.*, vs.name as service_name, vs.price as service_price\n FROM vet_appointments_v1 va\n JOIN veterinary_services_v1 vs ON va.service_id = vs.id\n WHERE va.user_id = ?\n ORDER BY va.appointment_date DESC, va.appointment_time DESC\n `, [userId]);\n \n return result.rows as VetAppointment[];\n}\n\n// Product queries\nexport async function getAllProducts(category?: string): Promise {\n let query = `SELECT * FROM products_v1 WHERE in_stock = true`;\n const params: any[] = [];\n \n if (category) {\n query += ` AND category = ?`;\n params.push(category);\n }\n \n query += ` ORDER BY name`;\n \n const result = await sqlite.execute(query, params);\n return result.rows as Product[];\n}\n\nexport async function getProductById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM products_v1 WHERE id = ?\n `, [id]);\n \n return result.rows[0] as Product || null;\n}\n\n// Cart queries\nexport async function addToCart(userId: number, productId: number, quantity: number): Promise {\n await sqlite.execute(`\n INSERT OR REPLACE INTO cart_items_v1 (user_id, product_id, quantity)\n VALUES (?, ?, COALESCE((SELECT quantity FROM cart_items_v1 WHERE user_id = ? AND product_id = ?), 0) + ?)\n `, [userId, productId, userId, productId, quantity]);\n}\n\nexport async function getCartItems(userId: number): Promise {\n const result = await sqlite.execute(`\n SELECT ci.*, p.name, p.price, p.category, (ci.quantity * p.price) as total_price\n FROM cart_items_v1 ci\n JOIN products_v1 p ON ci.product_id = p.id\n WHERE ci.user_id = ?\n ORDER BY ci.created_at DESC\n `, [userId]);\n \n return result.rows;\n}\n\nexport async function removeFromCart(userId: number, productId: number): Promise {\n await sqlite.execute(`\n DELETE FROM cart_items_v1 WHERE user_id = ? AND product_id = ?\n `, [userId, productId]);\n}\n\nexport async function clearCart(userId: number): Promise {\n await sqlite.execute(`\n DELETE FROM cart_items_v1 WHERE user_id = ?\n `, [userId]);\n}\n\n// Order queries\nexport async function createOrder(userId: number, totalAmount: number, shippingAddress: string, paymentMethod: string): Promise {\n const result = await sqlite.execute(`\n INSERT INTO orders_v1 (user_id, total_amount, shipping_address, payment_method)\n VALUES (?, ?, ?, ?)\n `, [userId, totalAmount, shippingAddress, paymentMethod]);\n \n return result.lastInsertRowid as number;\n}\n\nexport async function createOrderItems(orderId: number, cartItems: any[]): Promise {\n for (const item of cartItems) {\n await sqlite.execute(`\n INSERT INTO order_items_v1 (order_id, product_id, quantity, price)\n VALUES (?, ?, ?, ?)\n `, [orderId, item.product_id, item.quantity, item.price]);\n }\n}\n\nexport async function getOrdersByUser(userId: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM orders_v1 WHERE user_id = ? ORDER BY created_at DESC\n `, [userId]);\n \n return result.rows as Order[];\n}","deleted","label",[167,168,149],"backend","database","permalink","https://www.val.town/x/Aditi_Deshmukh/PetWebsite/code/backend/database/queries.ts","extension","actionData","errors"]