[{"_1":2,"_174":-5,"_175":-5},"loaderData",{"_3":4,"_92":93},"root",{"_5":6,"_35":36,"_65":66},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":32,"_33":20,"_34":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","isTeamOrgMember","ENV",{"_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":64},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","5aae8c594f4ceb0bfd0f0c6fa62a207a75f96ff1","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",{"_67":68},"__internal_clerk_state",{"_69":70,"_71":46,"_72":73,"_74":73,"_75":20,"_76":73,"_77":73,"_78":73,"_79":73,"_80":81,"_90":20,"_91":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",{"_82":20,"_19":20,"_83":73,"_84":85,"_86":73,"_87":46,"_88":20,"_89":73},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_94":95,"_96":97,"_98":99,"_100":101,"_148":149,"_171":172,"_173":-5},"handle","Ruona26","name","Ecom","path","backend/database/queries.ts","project",{"_102":103,"_96":97,"_104":105,"_106":-5,"_107":20,"_108":109,"_110":-5,"_111":-5,"_12":112,"_113":-5,"_114":20,"_115":-5,"_116":-5,"_117":32,"_14":118,"_119":120,"_121":120,"_122":123,"_124":123,"_125":123,"_126":120,"_127":120,"_23":128,"_131":132,"_134":135,"_147":20},"id","25954140-3fba-11f0-a686-76b3cceeab13","createdAt",["D",1748872917547],"deletedAt","legacyEnvVars","privacy","public","description","imageUrl","e98e4480-3fb9-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","d876a188-ba82-4750-b3c5-30dfbef193fb","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_94":95,"_129":130},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ4eEhSMUpzU2VmWksxYzcyUVh6b25PbDkxZyJ9","org",{"_94":95,"_133":130,"_12":112},"avatar","branch",{"_136":137,"_96":44,"_102":138,"_139":103,"_140":-5,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":97,"_146":95},"version",27,"259583bc-3fba-11f0-a686-76b3cceeab13","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","isOwned","file",{"_102":150,"_96":151,"_152":153,"_154":155,"_156":138,"_157":158,"_159":160,"_104":161,"_136":32,"_162":163,"_164":165,"_166":20,"_167":-5,"_98":168},"1f63920c-3fbc-11f0-9c09-76b3cceeab13","queries.ts","fileId","1f6392b6-3fbc-11f0-9c09-76b3cceeab13","parentId","9edd98a5-21c5-4494-8d81-32f11e9772e7","branchId","branchVersion",5,"latest",true,["D",1748873766143],"fileType","script","content","import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { Product, CartItem, User, Order, ContactMessage } from \"../../shared/types.ts\";\n\n// Product queries\nexport async function getAllProducts(): Promise {\n const rows = await sqlite.execute(\"SELECT * FROM products WHERE in_stock = 1 ORDER BY created_at DESC\");\n return rows.map(row => ({\n id: row.id,\n name: row.name,\n brand: row.brand,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category,\n size: JSON.parse(row.sizes),\n color: JSON.parse(row.colors),\n description: row.description,\n images: JSON.parse(row.images),\n inStock: Boolean(row.in_stock),\n rating: row.rating,\n reviewCount: row.review_count\n }));\n}\n\nexport async function getProductById(id: number): Promise {\n const rows = await sqlite.execute(\"SELECT * FROM products WHERE id = ?\", [id]);\n if (rows.length === 0) return null;\n \n const row = rows[0];\n return {\n id: row.id,\n name: row.name,\n brand: row.brand,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category,\n size: JSON.parse(row.sizes),\n color: JSON.parse(row.colors),\n description: row.description,\n images: JSON.parse(row.images),\n inStock: Boolean(row.in_stock),\n rating: row.rating,\n reviewCount: row.review_count\n };\n}\n\nexport async function getProductsByCategory(category: string): Promise {\n const rows = await sqlite.execute(\n \"SELECT * FROM products WHERE category = ? AND in_stock = 1 ORDER BY created_at DESC\", \n [category]\n );\n return rows.map(row => ({\n id: row.id,\n name: row.name,\n brand: row.brand,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category,\n size: JSON.parse(row.sizes),\n color: JSON.parse(row.colors),\n description: row.description,\n images: JSON.parse(row.images),\n inStock: Boolean(row.in_stock),\n rating: row.rating,\n reviewCount: row.review_count\n }));\n}\n\nexport async function searchProducts(query: string): Promise {\n const rows = await sqlite.execute(\n \"SELECT * FROM products WHERE (name LIKE ? OR brand LIKE ? OR category LIKE ?) AND in_stock = 1 ORDER BY created_at DESC\",\n [`%${query}%`, `%${query}%`, `%${query}%`]\n );\n return rows.map(row => ({\n id: row.id,\n name: row.name,\n brand: row.brand,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category,\n size: JSON.parse(row.sizes),\n color: JSON.parse(row.colors),\n description: row.description,\n images: JSON.parse(row.images),\n inStock: Boolean(row.in_stock),\n rating: row.rating,\n reviewCount: row.review_count\n }));\n}\n\n// User queries\nexport async function createUser(email: string, passwordHash: string, firstName: string, lastName: string): Promise {\n const result = await sqlite.execute(\n \"INSERT INTO users (email, password_hash, first_name, last_name) VALUES (?, ?, ?, ?)\",\n [email, passwordHash, firstName, lastName]\n );\n return result.lastInsertRowid;\n}\n\nexport async function getUserByEmail(email: string): Promise {\n const rows = await sqlite.execute(\"SELECT * FROM users WHERE email = ?\", [email]);\n if (rows.length === 0) return null;\n \n const row = rows[0];\n return {\n id: row.id,\n email: row.email,\n firstName: row.first_name,\n lastName: row.last_name,\n createdAt: row.created_at\n };\n}\n\nexport async function getUserById(id: number): Promise {\n const rows = await sqlite.execute(\"SELECT * FROM users WHERE id = ?\", [id]);\n if (rows.length === 0) return null;\n \n const row = rows[0];\n return {\n id: row.id,\n email: row.email,\n firstName: row.first_name,\n lastName: row.last_name,\n createdAt: row.created_at\n };\n}\n\nexport async function verifyUserPassword(email: string): Promise {\n const rows = await sqlite.execute(\"SELECT password_hash FROM users WHERE email = ?\", [email]);\n return rows.length > 0 ? rows[0].password_hash : null;\n}\n\n// Cart queries\nexport async function addToCart(userId: number | null, productId: number, size: string, color: string, quantity: number): Promise {\n const result = await sqlite.execute(\n \"INSERT INTO cart_items (user_id, product_id, size, color, quantity) VALUES (?, ?, ?, ?, ?)\",\n [userId, productId, size, color, quantity]\n );\n return result.lastInsertRowid;\n}\n\nexport async function getCartItems(userId: number | null): Promise {\n const rows = await sqlite.execute(`\n SELECT ci.*, p.name, p.brand, p.price, p.images, p.in_stock\n FROM cart_items ci\n JOIN products p ON ci.product_id = p.id\n WHERE ci.user_id = ? OR (ci.user_id IS NULL AND ? IS NULL)\n ORDER BY ci.created_at DESC\n `, [userId, userId]);\n\n return rows.map(row => ({\n id: row.id,\n productId: row.product_id,\n product: {\n id: row.product_id,\n name: row.name,\n brand: row.brand,\n price: row.price,\n images: JSON.parse(row.images),\n inStock: Boolean(row.in_stock)\n } as Product,\n size: row.size,\n color: row.color,\n quantity: row.quantity\n }));\n}\n\nexport async function updateCartItemQuantity(id: number, quantity: number): Promise {\n await sqlite.execute(\"UPDATE cart_items SET quantity = ? WHERE id = ?\", [quantity, id]);\n}\n\nexport async function removeFromCart(id: number): Promise {\n await sqlite.execute(\"DELETE FROM cart_items WHERE id = ?\", [id]);\n}\n\nexport async function clearCart(userId: number | null): Promise {\n await sqlite.execute(\"DELETE FROM cart_items WHERE user_id = ? OR (user_id IS NULL AND ? IS NULL)\", [userId, userId]);\n}\n\n// Contact queries\nexport async function saveContactMessage(name: string, email: string, subject: string, message: string): Promise {\n const result = await sqlite.execute(\n \"INSERT INTO contact_messages (name, email, subject, message) VALUES (?, ?, ?, ?)\",\n [name, email, subject, message]\n );\n return result.lastInsertRowid;\n}\n\nexport async function getContactMessages(): Promise {\n const rows = await sqlite.execute(\"SELECT * FROM contact_messages ORDER BY created_at DESC\");\n return rows.map(row => ({\n id: row.id,\n name: row.name,\n email: row.email,\n subject: row.subject,\n message: row.message,\n createdAt: row.created_at\n }));\n}\n\n// Order queries\nexport async function createOrder(userId: number, total: number, shippingAddress: any, paymentMethod: string): Promise {\n const result = await sqlite.execute(\n \"INSERT INTO orders (user_id, total, shipping_address, payment_method) VALUES (?, ?, ?, ?)\",\n [userId, total, JSON.stringify(shippingAddress), paymentMethod]\n );\n return result.lastInsertRowid;\n}\n\nexport async function addOrderItems(orderId: number, items: CartItem[]): Promise {\n for (const item of items) {\n await sqlite.execute(\n \"INSERT INTO order_items (order_id, product_id, size, color, quantity, price) VALUES (?, ?, ?, ?, ?, ?)\",\n [orderId, item.productId, item.size, item.color, item.quantity, item.product.price]\n );\n }\n}","deleted","label",[169,170,151],"backend","database","permalink","https://www.val.town/x/Ruona26/Ecom/code/backend/database/queries.ts","extension","actionData","errors"]