\n \n

Loading ModernShop...

\n \n \n \n\n",[],[86,137],"e33da34c-3f95-11f0-847a-76b3cceeab13","components","e3e1d536-dbac-41f2-a020-5f2c6c8716ff",["D",1748857344309],[149,150,151],[86,144],{"_34":181,"_13":182,"_63":183,"_65":145,"_66":67,"_68":69,"_70":71,"_36":184,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":185,"_18":186},{"_34":159,"_13":160,"_63":161,"_65":145,"_66":67,"_68":69,"_70":71,"_36":162,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":163,"_18":164},{"_34":152,"_13":153,"_63":154,"_65":145,"_66":67,"_68":69,"_70":71,"_36":155,"_17":31,"_73":112,"_74":156,"_76":49,"_77":-5,"_100":157,"_18":158},"e33d78ae-3f95-11f0-847a-76b3cceeab13","App.tsx","5e99b641-2b02-4509-994e-b31a9939ce84",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect, createContext, useContext } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { User, CartItem, Category, Product, ToastMessage, AppState } from \"../../shared/types.ts\";\n\n// Import components\nimport Layout from \"./layout/Layout.tsx\";\nimport HomePage from \"./pages/HomePage.tsx\";\nimport ShopPage from \"./pages/ShopPage.tsx\";\nimport ProductPage from \"./pages/ProductPage.tsx\";\nimport CartPage from \"./pages/CartPage.tsx\";\nimport CheckoutPage from \"./pages/CheckoutPage.tsx\";\nimport LoginPage from \"./pages/LoginPage.tsx\";\nimport SignupPage from \"./pages/SignupPage.tsx\";\nimport AccountPage from \"./pages/AccountPage.tsx\";\nimport OrderConfirmationPage from \"./pages/OrderConfirmationPage.tsx\";\nimport ToastContainer from \"./ui/ToastContainer.tsx\";\n\n// App Context\ninterface AppContextType extends AppState {\n setUser: (user: User | null) => void;\n setCart: (cart: CartItem[]) => void;\n setDarkMode: (darkMode: boolean) => void;\n setLoading: (loading: boolean) => void;\n setError: (error: string | null) => void;\n addToast: (toast: Omit) => void;\n removeToast: (id: string) => void;\n categories: Category[];\n featuredProducts: Product[];\n}\n\nconst AppContext = createContext(null);\n\nexport const useApp = () => {\n const context = useContext(AppContext);\n if (!context) {\n throw new Error('useApp must be used within AppProvider');\n }\n return context;\n};\n\n// Simple router\nfunction useRouter() {\n const [currentPath, setCurrentPath] = useState(window.location.pathname);\n const [searchParams, setSearchParams] = useState(new URLSearchParams(window.location.search));\n\n useEffect(() => {\n const handlePopState = () => {\n setCurrentPath(window.location.pathname);\n setSearchParams(new URLSearchParams(window.location.search));\n };\n\n window.addEventListener('popstate', handlePopState);\n return () => window.removeEventListener('popstate', handlePopState);\n }, []);\n\n const navigate = (path: string, replace = false) => {\n if (replace) {\n window.history.replaceState({}, '', path);\n } else {\n window.history.pushState({}, '', path);\n }\n setCurrentPath(path.split('?')[0]);\n setSearchParams(new URLSearchParams(path.split('?')[1] || ''));\n };\n\n return { currentPath, searchParams, navigate };\n}\n\ninterface AppProps {\n initialData: {\n featuredProducts?: Product[];\n categories?: Category[];\n user?: User;\n cart?: { items: CartItem[] };\n };\n}\n\nexport default function App({ initialData }: AppProps) {\n const { currentPath, searchParams, navigate } = useRouter();\n \n // App state\n const [user, setUser] = useState(initialData.user || null);\n const [cart, setCart] = useState(initialData.cart?.items || []);\n const [darkMode, setDarkMode] = useState(() => {\n const saved = localStorage.getItem('darkMode');\n return saved ? JSON.parse(saved) : false;\n });\n const [loading, setLoading] = useState(false);\n const [error, setError] = useState(null);\n const [toasts, setToasts] = useState([]);\n \n // Static data from initial load\n const [categories] = useState(initialData.categories || []);\n const [featuredProducts] = useState(initialData.featuredProducts || []);\n\n // Dark mode effect\n useEffect(() => {\n localStorage.setItem('darkMode', JSON.stringify(darkMode));\n if (darkMode) {\n document.documentElement.classList.add('dark');\n } else {\n document.documentElement.classList.remove('dark');\n }\n }, [darkMode]);\n\n // Check authentication on mount\n useEffect(() => {\n checkAuth();\n loadCart();\n }, []);\n\n const checkAuth = async () => {\n try {\n const response = await fetch('/api/auth/me', {\n credentials: 'include'\n });\n \n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n setUser(data.data);\n }\n }\n } catch (error) {\n console.error('Auth check failed:', error);\n }\n };\n\n const loadCart = async () => {\n try {\n const response = await fetch('/api/cart', {\n credentials: 'include'\n });\n \n if (response.ok) {\n const data = await response.json();\n if (data.success) {\n setCart(data.data.items);\n }\n }\n } catch (error) {\n console.error('Failed to load cart:', error);\n }\n };\n\n const addToast = (toast: Omit) => {\n const id = Math.random().toString(36).substr(2, 9);\n const newToast: ToastMessage = { ...toast, id };\n setToasts(prev => [...prev, newToast]);\n \n // Auto remove after duration\n setTimeout(() => {\n removeToast(id);\n }, toast.duration || 5000);\n };\n\n const removeToast = (id: string) => {\n setToasts(prev => prev.filter(toast => toast.id !== id));\n };\n\n const contextValue: AppContextType = {\n user,\n cart,\n darkMode,\n loading,\n error,\n setUser,\n setCart,\n setDarkMode,\n setLoading,\n setError,\n addToast,\n removeToast,\n categories,\n featuredProducts\n };\n\n // Route components\n const renderPage = () => {\n // Extract product ID from path like /product/123\n const productMatch = currentPath.match(/^\\/product\\/(\\d+)$/);\n if (productMatch) {\n return ;\n }\n\n // Extract order ID from confirmation path\n const confirmationMatch = currentPath.match(/^\\/confirmation\\/(\\d+)$/);\n if (confirmationMatch) {\n return ;\n }\n\n switch (currentPath) {\n case '/':\n return ;\n case '/shop':\n return ;\n case '/cart':\n return ;\n case '/checkout':\n return ;\n case '/login':\n return ;\n case '/signup':\n return ;\n case '/account':\n return ;\n default:\n return (\n

404

Page not found

\n navigate('/')}\n className=\"btn-primary px-6 py-3 rounded-lg text-white font-medium\"\n >\n Go Home\n \n

\n );\n }\n };\n\n return (\n \n \n {renderPage()}\n \n \n \n );\n}",[],[86,144,153],"e33d766a-3f95-11f0-847a-76b3cceeab13","ui","540b9290-1f68-4581-981a-80cb53ae63f8",["D",1748857344309],[165,166],[86,144,160],{"_34":174,"_13":175,"_63":176,"_65":161,"_66":67,"_68":69,"_70":71,"_36":177,"_17":31,"_73":112,"_74":178,"_76":49,"_77":-5,"_100":179,"_18":180},{"_34":167,"_13":168,"_63":169,"_65":161,"_66":67,"_68":69,"_70":71,"_36":170,"_17":31,"_73":112,"_74":171,"_76":49,"_77":-5,"_100":172,"_18":173},"e33d6f62-3f95-11f0-847a-76b3cceeab13","ToastContainer.tsx","204cd574-0057-4996-b8ba-a5d12054110b",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { ToastMessage } from \"../../../shared/types.ts\";\n\ninterface ToastContainerProps {\n toasts: ToastMessage[];\n onRemove: (id: string) => void;\n}\n\nexport default function ToastContainer({ toasts, onRemove }: ToastContainerProps) {\n if (toasts.length === 0) return null;\n\n return (\n

\n {toasts.map((toast) => (\n \n ))}\n

\n );\n}\n\ninterface ToastProps {\n toast: ToastMessage;\n onRemove: (id: string) => void;\n}\n\nfunction Toast({ toast, onRemove }: ToastProps) {\n const getToastStyles = () => {\n switch (toast.type) {\n case 'success':\n return 'bg-green-50 dark:bg-green-900 border-green-200 dark:border-green-700 text-green-800 dark:text-green-200';\n case 'error':\n return 'bg-red-50 dark:bg-red-900 border-red-200 dark:border-red-700 text-red-800 dark:text-red-200';\n case 'warning':\n return 'bg-yellow-50 dark:bg-yellow-900 border-yellow-200 dark:border-yellow-700 text-yellow-800 dark:text-yellow-200';\n case 'info':\n return 'bg-blue-50 dark:bg-blue-900 border-blue-200 dark:border-blue-700 text-blue-800 dark:text-blue-200';\n default:\n return 'bg-gray-50 dark:bg-gray-800 border-gray-200 dark:border-gray-600 text-gray-800 dark:text-gray-200';\n }\n };\n\n const getIcon = () => {\n switch (toast.type) {\n case 'success':\n return (\n \n );\n case 'error':\n return (\n \n );\n case 'warning':\n return (\n \n );\n case 'info':\n return (\n \n );\n default:\n return null;\n }\n };\n\n return (\n

\n {getIcon()}\n

\n {toast.title}\n

\n {toast.message && (\n

\n {toast.message}\n

\n )}\n

\n onRemove(toast.id)}\n className=\"inline-flex text-gray-400 hover:text-gray-600 dark:hover:text-gray-300 transition-colors\"\n >\n \n \n

\n );\n}",[],[86,144,160,168],"e33d66b6-3f95-11f0-847a-76b3cceeab13","ProductCard.tsx","ef9f6751-3615-4753-8fc0-8d1b4920c726",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport type { Product } from \"../../../shared/types.ts\";\nimport { formatPrice, calculateDiscount, generateStars } from \"../../../shared/utils.ts\";\nimport { useApp } from \"../App.tsx\";\n\ninterface ProductCardProps {\n product: Product;\n navigate: (path: string) => void;\n}\n\nexport default function ProductCard({ product, navigate }: ProductCardProps) {\n const { addToast, setCart } = useApp();\n const [isAddingToCart, setIsAddingToCart] = useState(false);\n const [imageLoaded, setImageLoaded] = useState(false);\n\n const discount = product.originalPrice \n ? calculateDiscount(product.originalPrice, product.price)\n : 0;\n\n const handleAddToCart = async (e: React.MouseEvent) => {\n e.stopPropagation(); // Prevent navigation to product page\n \n if (!product.inStock) {\n addToast({\n type: 'error',\n title: 'Out of Stock',\n message: 'This product is currently unavailable.'\n });\n return;\n }\n\n setIsAddingToCart(true);\n\n try {\n const response = await fetch('/api/cart/add', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json',\n },\n credentials: 'include',\n body: JSON.stringify({\n productId: product.id,\n quantity: 1\n })\n });\n\n const data = await response.json();\n\n if (data.success) {\n addToast({\n type: 'success',\n title: 'Added to Cart',\n message: `${product.name} has been added to your cart.`\n });\n\n // Refresh cart\n const cartResponse = await fetch('/api/cart', {\n credentials: 'include'\n });\n \n if (cartResponse.ok) {\n const cartData = await cartResponse.json();\n if (cartData.success) {\n setCart(cartData.data.items);\n }\n }\n } else {\n addToast({\n type: 'error',\n title: 'Error',\n message: data.error || 'Failed to add item to cart.'\n });\n }\n } catch (error) {\n console.error('Add to cart error:', error);\n addToast({\n type: 'error',\n title: 'Error',\n message: 'Failed to add item to cart. Please try again.'\n });\n } finally {\n setIsAddingToCart(false);\n }\n };\n\n return (\n

navigate(`/product/${product.id}`)}\n >\n {/* Image Container */}\n

\n {/* Badges */}\n {discount > 0 && (\n

\n -{discount}%\n

\n )}\n {product.featured && !discount && (\n

\n Featured\n

\n )}\n\n {/* Product Image */}\n

\n setImageLoaded(true)}\n loading=\"lazy\"\n />\n

\n\n {/* Quick Add to Cart Button */}\n

\n \n {isAddingToCart ? (\n \n

\n Adding...\n \n ) : product.inStock ? (\n 'Quick Add to Cart'\n ) : (\n 'Out of Stock'\n )}\n \n

\n\n {/* Product Info */}\n

\n {/* Brand */}\n

\n {product.brand}\n

\n\n {/* Product Name */}\n

\n {product.name}\n

\n\n {/* Rating */}\n

\n {generateStars(product.rating)}\n

\n \n ({product.reviewCount})\n \n

\n\n {/* Price */}\n

\n \n {formatPrice(product.price)}\n \n {product.originalPrice && (\n \n {formatPrice(product.originalPrice)}\n \n )}\n

\n \n {/* Stock Status */}\n

\n {product.inStock ? (\n \n In Stock\n \n ) : (\n \n Out of Stock\n \n )}\n

\n\n {/* Category */}\n

\n {product.category}\n

\n );\n}",[],[86,144,160,175],"e33d64ae-3f95-11f0-847a-76b3cceeab13","layout","1ad0c55a-99e4-448c-964f-8d5609fa7f76",["D",1748857344309],[187,188,189],[86,144,182],{"_34":204,"_13":205,"_63":206,"_65":183,"_66":67,"_68":69,"_70":71,"_36":207,"_17":31,"_73":112,"_74":208,"_76":49,"_77":-5,"_100":209,"_18":210},{"_34":197,"_13":198,"_63":199,"_65":183,"_66":67,"_68":69,"_70":71,"_36":200,"_17":31,"_73":112,"_74":201,"_76":49,"_77":-5,"_100":202,"_18":203},{"_34":190,"_13":191,"_63":192,"_65":183,"_66":67,"_68":69,"_70":71,"_36":193,"_17":31,"_73":112,"_74":194,"_76":49,"_77":-5,"_100":195,"_18":196},"e33d622e-3f95-11f0-847a-76b3cceeab13","Layout.tsx","9a935a1e-d700-46d3-b3ac-3f90a70fcc95",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport Header from \"./Header.tsx\";\nimport Footer from \"./Footer.tsx\";\n\ninterface LayoutProps {\n children: React.ReactNode;\n navigate: (path: string) => void;\n currentPath: string;\n}\n\nexport default function Layout({ children, navigate, currentPath }: LayoutProps) {\n return (\n

\n {children}\n

\n );\n}",[],[86,144,182,191],"e33d50c2-3f95-11f0-847a-76b3cceeab13","Header.tsx","8399bf03-1112-4c15-adc5-3d747c514adb",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useRef, useEffect } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { useApp } from \"../App.tsx\";\n\ninterface HeaderProps {\n navigate: (path: string) => void;\n currentPath: string;\n}\n\nexport default function Header({ navigate, currentPath }: HeaderProps) {\n const { user, cart, darkMode, setDarkMode, categories } = useApp();\n const [isMenuOpen, setIsMenuOpen] = useState(false);\n const [isUserMenuOpen, setIsUserMenuOpen] = useState(false);\n const [searchQuery, setSearchQuery] = useState('');\n const userMenuRef = useRef(null);\n\n const cartItemCount = cart.reduce((sum, item) => sum + item.quantity, 0);\n\n // Close user menu when clicking outside\n useEffect(() => {\n const handleClickOutside = (event: MouseEvent) => {\n if (userMenuRef.current && !userMenuRef.current.contains(event.target as Node)) {\n setIsUserMenuOpen(false);\n }\n };\n\n document.addEventListener('mousedown', handleClickOutside);\n return () => document.removeEventListener('mousedown', handleClickOutside);\n }, []);\n\n const handleSearch = (e: React.FormEvent) => {\n e.preventDefault();\n if (searchQuery.trim()) {\n navigate(`/shop?search=${encodeURIComponent(searchQuery.trim())}`);\n setSearchQuery('');\n }\n };\n\n const handleLogout = async () => {\n try {\n await fetch('/api/auth/logout', {\n method: 'POST',\n credentials: 'include'\n });\n window.location.reload(); // Simple way to reset app state\n } catch (error) {\n console.error('Logout failed:', error);\n }\n };\n\n return (\n

\n {/* Logo */}\n

\n navigate('/')}\n className=\"flex items-center space-x-2 text-xl font-bold text-indigo-600 dark:text-indigo-400 hover:text-indigo-700 dark:hover:text-indigo-300 transition-colors\"\n >\n 🛍️\n ModernShop\n \n

\n\n {/* Search Bar - Desktop */}\n

\n \n

\n\n {/* Navigation Links - Desktop */}\n

\n navigate('/')}\n className={`text-sm font-medium transition-colors ${\n currentPath === '/' \n ? 'text-indigo-600 dark:text-indigo-400' \n : 'text-gray-700 dark:text-gray-300 hover:text-indigo-600 dark:hover:text-indigo-400'\n }`}\n >\n Home\n \n navigate('/shop')}\n className={`text-sm font-medium transition-colors ${\n currentPath === '/shop' \n ? 'text-indigo-600 dark:text-indigo-400' \n : 'text-gray-700 dark:text-gray-300 hover:text-indigo-600 dark:hover:text-indigo-400'\n }`}\n >\n Shop\n \n \n {/* Categories Dropdown */}\n

\n \n

\n {categories.map((category) => (\n navigate(`/shop?category=${category.slug}`)}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 dark:text-gray-300 hover:bg-gray-100 dark:hover:bg-gray-700 transition-colors\"\n >\n {category.name}\n \n ))}\n

\n\n {/* Right side actions */}\n

\n {/* Dark mode toggle */}\n setDarkMode(!darkMode)}\n className=\"p-2 text-gray-500 dark:text-gray-400 hover:text-gray-700 dark:hover:text-gray-200 transition-colors\"\n aria-label=\"Toggle dark mode\"\n >\n {darkMode ? (\n \n ) : (\n \n )}\n \n\n {/* Cart */}\n navigate('/cart')}\n className=\"relative p-2 text-gray-500 dark:text-gray-400 hover:text-gray-700 dark:hover:text-gray-200 transition-colors\"\n aria-label=\"Shopping cart\"\n >\n \n {cartItemCount > 0 && (\n \n {cartItemCount}\n \n )}\n \n\n {/* User menu */}\n {user ? (\n

\n setIsUserMenuOpen(!isUserMenuOpen)}\n className=\"flex items-center space-x-2 text-sm text-gray-700 dark:text-gray-300 hover:text-gray-900 dark:hover:text-gray-100 transition-colors\"\n >\n \n {user.firstName}\n \n \n\n {isUserMenuOpen && (\n

\n {\n navigate('/account');\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 dark:text-gray-300 hover:bg-gray-100 dark:hover:bg-gray-700 transition-colors\"\n >\n My Account\n \n {\n navigate('/account#orders');\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 dark:text-gray-300 hover:bg-gray-100 dark:hover:bg-gray-700 transition-colors\"\n >\n Order History\n \n

\n {\n handleLogout();\n setIsUserMenuOpen(false);\n }}\n className=\"block w-full text-left px-4 py-2 text-sm text-gray-700 dark:text-gray-300 hover:bg-gray-100 dark:hover:bg-gray-700 transition-colors\"\n >\n Sign Out\n \n

\n )}\n

\n ) : (\n

\n navigate('/login')}\n className=\"text-sm font-medium text-gray-700 dark:text-gray-300 hover:text-indigo-600 dark:hover:text-indigo-400 transition-colors\"\n >\n Sign In\n \n navigate('/signup')}\n className=\"btn-primary px-4 py-2 rounded-lg text-white text-sm font-medium\"\n >\n Sign Up\n \n

\n )}\n\n {/* Mobile menu button */}\n setIsMenuOpen(!isMenuOpen)}\n className=\"md:hidden p-2 text-gray-500 dark:text-gray-400 hover:text-gray-700 dark:hover:text-gray-200 transition-colors\"\n aria-label=\"Toggle menu\"\n >\n \n \n

\n\n {/* Mobile menu */}\n {isMenuOpen && (\n

\n {/* Mobile search */}\n \n\n {/* Mobile navigation */}\n

\n {\n navigate('/');\n setIsMenuOpen(false);\n }}\n className=\"block w-full text-left py-2 text-gray-700 dark:text-gray-300 hover:text-indigo-600 dark:hover:text-indigo-400 transition-colors\"\n >\n Home\n \n {\n navigate('/shop');\n setIsMenuOpen(false);\n }}\n className=\"block w-full text-left py-2 text-gray-700 dark:text-gray-300 hover:text-indigo-600 dark:hover:text-indigo-400 transition-colors\"\n >\n Shop\n \n \n {/* Mobile categories */}\n

\n {categories.map((category) => (\n {\n navigate(`/shop?category=${category.slug}`);\n setIsMenuOpen(false);\n }}\n className=\"block w-full text-left py-1 text-sm text-gray-600 dark:text-gray-400 hover:text-indigo-600 dark:hover:text-indigo-400 transition-colors\"\n >\n {category.name}\n \n ))}\n

\n )}\n

\n );\n}",[],[86,144,182,198],"e33d449c-3f95-11f0-847a-76b3cceeab13","Footer.tsx","e6b1c3b6-61fa-4b06-a20e-da59205f11d7",["D",1748857344309],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0?deps=react@18.2.0\";\nimport { useApp } from \"../App.tsx\";\n\ninterface FooterProps {\n navigate: (path: string) => void;\n}\n\nexport default function Footer({ navigate }: FooterProps) {\n const { addToast, categories } = useApp();\n const [email, setEmail] = useState('');\n const [isSubscribing, setIsSubscribing] = useState(false);\n\n const handleNewsletterSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n if (!email.trim()) return;\n\n setIsSubscribing(true);\n \n // Simulate newsletter subscription\n setTimeout(() => {\n addToast({\n type: 'success',\n title: 'Subscribed!',\n message: 'Thank you for subscribing to our newsletter.'\n });\n setEmail('');\n setIsSubscribing(false);\n }, 1000);\n };\n\n return (\n \n );\n}",[],[86,144,182,205],["D",1748857344309],[214,215,216],[91],{"_34":262,"_13":263,"_63":264,"_65":92,"_66":67,"_68":69,"_70":71,"_36":265,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":266,"_18":267},{"_34":224,"_13":225,"_63":226,"_65":92,"_66":67,"_68":69,"_70":71,"_36":227,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":228,"_18":229},{"_34":217,"_13":218,"_63":219,"_65":92,"_66":67,"_68":69,"_70":71,"_36":220,"_17":31,"_73":112,"_74":221,"_76":49,"_77":-5,"_100":222,"_18":223},"e33d3d80-3f95-11f0-847a-76b3cceeab13","index.ts","d25b53cb-7eec-4544-acaa-dab8c97bca88",["D",1748857344309],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { readFile, serveFile } from \"https://esm.town/v/std/utils@85-main/index.ts\";\nimport { runMigrations, seedData } from \"./database/migrations.ts\";\nimport { getFeaturedProducts, getCategories } from \"./database/queries.ts\";\n\n// Import routes\nimport auth from \"./routes/auth.ts\";\nimport products from \"./routes/products.ts\";\nimport cart from \"./routes/cart.ts\";\nimport orders from \"./routes/orders.ts\";\n\nconst app = new Hono();\n\n// Unwrap Hono errors to see original error details\napp.onError((err, c) => {\n throw err;\n});\n\n// Initialize database on startup\nlet dbInitialized = false;\nasync function initializeDatabase() {\n if (!dbInitialized) {\n console.log(\"Initializing database...\");\n await runMigrations();\n await seedData();\n dbInitialized = true;\n console.log(\"Database initialized successfully\");\n }\n}\n\n// API Routes\napp.route(\"/api/auth\", auth);\napp.route(\"/api/products\", products);\napp.route(\"/api/cart\", cart);\napp.route(\"/api/orders\", orders);\n\n// Serve static files\napp.get(\"/frontend/*\", c => serveFile(c.req.path, import.meta.url));\napp.get(\"/shared/*\", c => serveFile(c.req.path, import.meta.url));\n\n// Homepage with initial data injection\napp.get(\"/\", async c => {\n await initializeDatabase();\n \n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n\n try {\n // Inject initial data to avoid extra round-trips\n const [featuredProducts, categories] = await Promise.all([\n getFeaturedProducts(8),\n getCategories()\n ]);\n\n const initialData = {\n featuredProducts,\n categories,\n user: null, // Will be set by frontend if authenticated\n cart: { items: [], summary: { subtotal: 0, tax: 0, shipping: 0, total: 0, itemCount: 0 } }\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n // Continue without initial data if there's an error\n }\n\n return c.html(html);\n});\n\n// Catch-all route for SPA routing\napp.get(\"*\", async c => {\n await initializeDatabase();\n \n // For SPA routes, serve the main HTML file\n const path = c.req.path;\n \n // Check if it's a known frontend route\n const frontendRoutes = [\n \"/shop\", \"/product/\", \"/cart\", \"/checkout\", \"/login\", \"/signup\", \n \"/account\", \"/admin\", \"/orders\", \"/confirmation\"\n ];\n \n const isFrontendRoute = frontendRoutes.some(route => \n path.startsWith(route) || path === route\n );\n \n if (isFrontendRoute) {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n try {\n // Inject minimal initial data for SPA routes\n const categories = await getCategories();\n const initialData = {\n categories,\n user: null,\n cart: { items: [], summary: { subtotal: 0, tax: 0, shipping: 0, total: 0, itemCount: 0 } }\n };\n\n const dataScript = ``;\n\n html = html.replace(\"\", `${dataScript}`);\n } catch (error) {\n console.error(\"Error loading initial data:\", error);\n }\n \n return c.html(html);\n }\n \n // For unknown routes, return 404\n return c.text(\"Not Found\", 404);\n});\n\nexport default app;",[],[91,218],"e33d3b8c-3f95-11f0-847a-76b3cceeab13","routes","0ab93ca5-4e35-414a-beba-5fe2ca0297cc",["D",1748857344309],[230,231,232,233],[91,225],{"_34":255,"_13":256,"_63":257,"_65":226,"_66":67,"_68":69,"_70":71,"_36":258,"_17":31,"_73":112,"_74":259,"_76":49,"_77":-5,"_100":260,"_18":261},{"_34":248,"_13":249,"_63":250,"_65":226,"_66":67,"_68":69,"_70":71,"_36":251,"_17":31,"_73":112,"_74":252,"_76":49,"_77":-5,"_100":253,"_18":254},{"_34":241,"_13":242,"_63":243,"_65":226,"_66":67,"_68":69,"_70":71,"_36":244,"_17":31,"_73":112,"_74":245,"_76":49,"_77":-5,"_100":246,"_18":247},{"_34":234,"_13":235,"_63":236,"_65":226,"_66":67,"_68":69,"_70":71,"_36":237,"_17":31,"_73":112,"_74":238,"_76":49,"_77":-5,"_100":239,"_18":240},"e33d35ba-3f95-11f0-847a-76b3cceeab13","products.ts","ecd46cd2-b8ad-4a9f-ab33-18468a989850",["D",1748857344309],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n getProducts, \n getProductById, \n getFeaturedProducts, \n getRelatedProducts,\n getCategories,\n getCategoryBySlug,\n getProductReviews\n} from \"../database/queries.ts\";\nimport type { ProductFilters, ProductSort, PaginationParams, ApiResponse } from \"../../shared/types.ts\";\n\nconst products = new Hono();\n\n// Get all products with filtering, sorting, and pagination\nproducts.get(\"/\", async (c) => {\n try {\n const url = new URL(c.req.url);\n const searchParams = url.searchParams;\n\n // Parse filters\n const filters: ProductFilters = {\n category: searchParams.get(\"category\") || undefined,\n brand: searchParams.get(\"brand\") || undefined,\n minPrice: searchParams.get(\"minPrice\") ? parseFloat(searchParams.get(\"minPrice\")!) : undefined,\n maxPrice: searchParams.get(\"maxPrice\") ? parseFloat(searchParams.get(\"maxPrice\")!) : undefined,\n inStock: searchParams.get(\"inStock\") === \"true\",\n featured: searchParams.get(\"featured\") === \"true\",\n search: searchParams.get(\"search\") || undefined,\n };\n\n // Parse sorting\n const sortField = searchParams.get(\"sortBy\") as ProductSort[\"field\"] || \"createdAt\";\n const sortDirection = searchParams.get(\"sortOrder\") as ProductSort[\"direction\"] || \"desc\";\n const sort: ProductSort = { field: sortField, direction: sortDirection };\n\n // Parse pagination\n const page = parseInt(searchParams.get(\"page\") || \"1\");\n const limit = parseInt(searchParams.get(\"limit\") || \"12\");\n const pagination: PaginationParams = { page, limit };\n\n const result = await getProducts(filters, sort, pagination);\n\n return c.json({\n success: true,\n data: result\n });\n } catch (error) {\n console.error(\"Get products error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch products\"\n }, 500);\n }\n});\n\n// Get featured products\nproducts.get(\"/featured\", async (c) => {\n try {\n const limit = parseInt(c.req.query(\"limit\") || \"8\");\n const featuredProducts = await getFeaturedProducts(limit);\n\n return c.json({\n success: true,\n data: featuredProducts\n });\n } catch (error) {\n console.error(\"Get featured products error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch featured products\"\n }, 500);\n }\n});\n\n// Get product by ID\nproducts.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid product ID\"\n }, 400);\n }\n\n const product = await getProductById(id);\n \n if (!product) {\n return c.json({\n success: false,\n error: \"Product not found\"\n }, 404);\n }\n\n return c.json({\n success: true,\n data: product\n });\n } catch (error) {\n console.error(\"Get product error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch product\"\n }, 500);\n }\n});\n\n// Get related products\nproducts.get(\"/:id/related\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const limit = parseInt(c.req.query(\"limit\") || \"4\");\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid product ID\"\n }, 400);\n }\n\n const relatedProducts = await getRelatedProducts(id, limit);\n\n return c.json({\n success: true,\n data: relatedProducts\n });\n } catch (error) {\n console.error(\"Get related products error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch related products\"\n }, 500);\n }\n});\n\n// Get product reviews\nproducts.get(\"/:id/reviews\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n \n if (isNaN(id)) {\n return c.json({\n success: false,\n error: \"Invalid product ID\"\n }, 400);\n }\n\n const reviews = await getProductReviews(id);\n\n return c.json({\n success: true,\n data: reviews\n });\n } catch (error) {\n console.error(\"Get product reviews error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch product reviews\"\n }, 500);\n }\n});\n\n// Get all categories\nproducts.get(\"/categories/all\", async (c) => {\n try {\n const categories = await getCategories();\n\n return c.json({\n success: true,\n data: categories\n });\n } catch (error) {\n console.error(\"Get categories error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch categories\"\n }, 500);\n }\n});\n\n// Get category by slug\nproducts.get(\"/categories/:slug\", async (c) => {\n try {\n const slug = c.req.param(\"slug\");\n const category = await getCategoryBySlug(slug);\n \n if (!category) {\n return c.json({\n success: false,\n error: \"Category not found\"\n }, 404);\n }\n\n return c.json({\n success: true,\n data: category\n });\n } catch (error) {\n console.error(\"Get category error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch category\"\n }, 500);\n }\n});\n\nexport default products;",[],[91,225,235],"e33d3006-3f95-11f0-847a-76b3cceeab13","orders.ts","9d62d50b-18e2-4880-94ae-5ff3d65ba02c",["D",1748857344309],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { \n createOrder, \n getOrderById, \n getUserOrders,\n getCartItems,\n clearCart\n} from \"../database/queries.ts\";\nimport { authMiddleware } from \"./auth.ts\";\nimport type { CheckoutRequest, ApiResponse } from \"../../shared/types.ts\";\n\nconst orders = new Hono();\n\n// Apply auth middleware to all order routes\norders.use(\"*\", authMiddleware);\n\n// Create new order (checkout)\norders.post(\"/\", async (c) => {\n try {\n const user = c.get(\"user\");\n const body: CheckoutRequest = await c.req.json();\n const { shippingAddress, billingAddress, paymentMethod } = body;\n\n // Validate required fields\n if (!shippingAddress || !billingAddress || !paymentMethod) {\n return c.json({\n success: false,\n error: \"Missing required checkout information\"\n }, 400);\n }\n\n // Get cart items\n const cartItems = await getCartItems(user.userId);\n \n if (cartItems.length === 0) {\n return c.json({\n success: false,\n error: \"Cart is empty\"\n }, 400);\n }\n\n // Calculate totals\n const subtotal = cartItems.reduce((sum, item) => sum + (item.product.price * item.quantity), 0);\n const tax = subtotal * 0.08; // 8% tax\n const shipping = subtotal > 50 ? 0 : 9.99; // Free shipping over $50\n const total = subtotal + tax + shipping;\n\n // Prepare order items\n const orderItems = cartItems.map(item => ({\n productId: item.productId,\n quantity: item.quantity,\n price: item.product.price\n }));\n\n // Create order\n const order = await createOrder({\n userId: user.userId,\n items: orderItems,\n subtotal,\n tax,\n shipping,\n total,\n shippingAddress,\n billingAddress,\n paymentMethod\n });\n\n // Clear cart after successful order\n await clearCart(user.userId);\n\n return c.json({\n success: true,\n data: order,\n message: \"Order placed successfully\"\n });\n } catch (error) {\n console.error(\"Create order error:\", error);\n return c.json({\n success: false,\n error: \"Failed to create order\"\n }, 500);\n }\n});\n\n// Get user's orders\norders.get(\"/\", async (c) => {\n try {\n const user = c.get(\"user\");\n const userOrders = await getUserOrders(user.userId);\n\n return c.json({\n success: true,\n data: userOrders\n });\n } catch (error) {\n console.error(\"Get user orders error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch orders\"\n }, 500);\n }\n});\n\n// Get specific order by ID\norders.get(\"/:id\", async (c) => {\n try {\n const user = c.get(\"user\");\n const orderId = parseInt(c.req.param(\"id\"));\n\n if (isNaN(orderId)) {\n return c.json({\n success: false,\n error: \"Invalid order ID\"\n }, 400);\n }\n\n const order = await getOrderById(orderId);\n\n // Check if user owns this order (or is admin)\n if (order.userId !== user.userId && !user.isAdmin) {\n return c.json({\n success: false,\n error: \"Access denied\"\n }, 403);\n }\n\n return c.json({\n success: true,\n data: order\n });\n } catch (error) {\n console.error(\"Get order error:\", error);\n \n if (error.message === \"Order not found\") {\n return c.json({\n success: false,\n error: \"Order not found\"\n }, 404);\n }\n\n return c.json({\n success: false,\n error: \"Failed to fetch order\"\n }, 500);\n }\n});\n\nexport default orders;",[],[91,225,242],"e33d28cc-3f95-11f0-847a-76b3cceeab13","cart.ts","0f6fa81f-d8bc-452e-88f3-db8d4f363bb2",["D",1748857344309],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport { \n getCartItems, \n addToCart, \n updateCartItem, \n removeFromCart, \n clearCart \n} from \"../database/queries.ts\";\nimport type { CartUpdateRequest, ApiResponse } from \"../../shared/types.ts\";\nimport { generateId } from \"../../shared/utils.ts\";\n\nconst cart = new Hono();\n\n// Get session ID from cookie or create new one\nfunction getSessionId(c: any): string {\n let sessionId = getCookie(c, \"session_id\");\n if (!sessionId) {\n sessionId = generateId();\n // Set session cookie (this would be set by the client)\n }\n return sessionId;\n}\n\n// Get current user from context (set by auth middleware if authenticated)\nfunction getCurrentUser(c: any): { userId: number } | null {\n const user = c.get(\"user\");\n return user ? { userId: user.userId } : null;\n}\n\n// Get cart items\ncart.get(\"/\", async (c) => {\n try {\n const user = getCurrentUser(c);\n const sessionId = user ? undefined : getSessionId(c);\n \n const items = await getCartItems(user?.userId, sessionId);\n\n // Calculate totals\n const subtotal = items.reduce((sum, item) => sum + (item.product.price * item.quantity), 0);\n const tax = subtotal * 0.08; // 8% tax\n const shipping = subtotal > 50 ? 0 : 9.99; // Free shipping over $50\n const total = subtotal + tax + shipping;\n\n return c.json({\n success: true,\n data: {\n items,\n summary: {\n subtotal,\n tax,\n shipping,\n total,\n itemCount: items.reduce((sum, item) => sum + item.quantity, 0)\n }\n }\n });\n } catch (error) {\n console.error(\"Get cart error:\", error);\n return c.json({\n success: false,\n error: \"Failed to fetch cart\"\n }, 500);\n }\n});\n\n// Add item to cart\ncart.post(\"/add\", async (c) => {\n try {\n const body: CartUpdateRequest = await c.req.json();\n const { productId, quantity } = body;\n\n if (!productId || !quantity || quantity < 1) {\n return c.json({\n success: false,\n error: \"Invalid product ID or quantity\"\n }, 400);\n }\n\n const user = getCurrentUser(c);\n const sessionId = user ? undefined : getSessionId(c);\n\n const cartItem = await addToCart(productId, quantity, user?.userId, sessionId);\n\n return c.json({\n success: true,\n data: cartItem,\n message: \"Item added to cart\"\n });\n } catch (error) {\n console.error(\"Add to cart error:\", error);\n return c.json({\n success: false,\n error: \"Failed to add item to cart\"\n }, 500);\n }\n});\n\n// Update cart item quantity\ncart.put(\"/:itemId\", async (c) => {\n try {\n const itemId = parseInt(c.req.param(\"itemId\"));\n const body = await c.req.json();\n const { quantity } = body;\n\n if (isNaN(itemId) || quantity < 0) {\n return c.json({\n success: false,\n error: \"Invalid item ID or quantity\"\n }, 400);\n }\n\n await updateCartItem(itemId, quantity);\n\n return c.json({\n success: true,\n message: quantity === 0 ? \"Item removed from cart\" : \"Cart updated\"\n });\n } catch (error) {\n console.error(\"Update cart error:\", error);\n return c.json({\n success: false,\n error: \"Failed to update cart\"\n }, 500);\n }\n});\n\n// Remove item from cart\ncart.delete(\"/:itemId\", async (c) => {\n try {\n const itemId = parseInt(c.req.param(\"itemId\"));\n\n if (isNaN(itemId)) {\n return c.json({\n success: false,\n error: \"Invalid item ID\"\n }, 400);\n }\n\n await removeFromCart(itemId);\n\n return c.json({\n success: true,\n message: \"Item removed from cart\"\n });\n } catch (error) {\n console.error(\"Remove from cart error:\", error);\n return c.json({\n success: false,\n error: \"Failed to remove item from cart\"\n }, 500);\n }\n});\n\n// Clear entire cart\ncart.delete(\"/\", async (c) => {\n try {\n const user = getCurrentUser(c);\n const sessionId = user ? undefined : getSessionId(c);\n\n await clearCart(user?.userId, sessionId);\n\n return c.json({\n success: true,\n message: \"Cart cleared\"\n });\n } catch (error) {\n console.error(\"Clear cart error:\", error);\n return c.json({\n success: false,\n error: \"Failed to clear cart\"\n }, 500);\n }\n});\n\nexport default cart;",[],[91,225,249],"e33d2160-3f95-11f0-847a-76b3cceeab13","auth.ts","0c5915e8-6db7-43c0-be96-75eb71a3a44b",["D",1748857344309],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { sign, verify } from \"https://esm.sh/hono@3.11.7/jwt\";\nimport { setCookie, getCookie } from \"https://esm.sh/hono@3.11.7/cookie\";\nimport { getUserByEmail, createUser } from \"../database/queries.ts\";\nimport type { LoginRequest, SignupRequest, ApiResponse } from \"../../shared/types.ts\";\nimport { validateEmail, validatePassword } from \"../../shared/utils.ts\";\n\nconst auth = new Hono();\n\n// Simple password hashing (in production, use bcrypt)\nasync function hashPassword(password: string): Promise {\n const encoder = new TextEncoder();\n const data = encoder.encode(password + \"salt123\"); // Use proper salt in production\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\nasync function verifyPassword(password: string, hash: string): Promise {\n const hashedInput = await hashPassword(password);\n return hashedInput === hash;\n}\n\nconst JWT_SECRET = Deno.env.get(\"JWT_SECRET\") || \"your-secret-key-change-in-production\";\n\n// Login\nauth.post(\"/login\", async (c) => {\n try {\n const body: LoginRequest = await c.req.json();\n const { email, password } = body;\n\n if (!email || !password) {\n return c.json({\n success: false,\n error: \"Email and password are required\"\n }, 400);\n }\n\n if (!validateEmail(email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n }, 400);\n }\n\n const user = await getUserByEmail(email);\n if (!user) {\n return c.json({\n success: false,\n error: \"Invalid credentials\"\n }, 401);\n }\n\n const isValidPassword = await verifyPassword(password, user.passwordHash);\n if (!isValidPassword) {\n return c.json({\n success: false,\n error: \"Invalid credentials\"\n }, 401);\n }\n\n // Create JWT token\n const token = await sign({\n userId: user.id,\n email: user.email,\n isAdmin: user.isAdmin,\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60) // 24 hours\n }, JWT_SECRET);\n\n // Set HTTP-only cookie\n setCookie(c, \"auth_token\", token, {\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 24 * 60 * 60 // 24 hours\n });\n\n const { passwordHash, ...userWithoutPassword } = user;\n\n return c.json({\n success: true,\n data: {\n user: userWithoutPassword,\n token\n },\n message: \"Login successful\"\n });\n } catch (error) {\n console.error(\"Login error:\", error);\n return c.json({\n success: false,\n error: \"Internal server error\"\n }, 500);\n }\n});\n\n// Signup\nauth.post(\"/signup\", async (c) => {\n try {\n const body: SignupRequest = await c.req.json();\n const { email, password, firstName, lastName } = body;\n\n if (!email || !password || !firstName || !lastName) {\n return c.json({\n success: false,\n error: \"All fields are required\"\n }, 400);\n }\n\n if (!validateEmail(email)) {\n return c.json({\n success: false,\n error: \"Invalid email format\"\n }, 400);\n }\n\n const passwordValidation = validatePassword(password);\n if (!passwordValidation.isValid) {\n return c.json({\n success: false,\n error: passwordValidation.errors.join(\", \")\n }, 400);\n }\n\n // Check if user already exists\n const existingUser = await getUserByEmail(email);\n if (existingUser) {\n return c.json({\n success: false,\n error: \"User with this email already exists\"\n }, 409);\n }\n\n // Hash password and create user\n const passwordHash = await hashPassword(password);\n const user = await createUser({\n email,\n passwordHash,\n firstName,\n lastName\n });\n\n // Create JWT token\n const token = await sign({\n userId: user.id,\n email: user.email,\n isAdmin: user.isAdmin,\n exp: Math.floor(Date.now() / 1000) + (24 * 60 * 60) // 24 hours\n }, JWT_SECRET);\n\n // Set HTTP-only cookie\n setCookie(c, \"auth_token\", token, {\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 24 * 60 * 60 // 24 hours\n });\n\n return c.json({\n success: true,\n data: {\n user,\n token\n },\n message: \"Account created successfully\"\n });\n } catch (error) {\n console.error(\"Signup error:\", error);\n return c.json({\n success: false,\n error: \"Internal server error\"\n }, 500);\n }\n});\n\n// Logout\nauth.post(\"/logout\", (c) => {\n setCookie(c, \"auth_token\", \"\", {\n httpOnly: true,\n secure: true,\n sameSite: \"Strict\",\n maxAge: 0\n });\n\n return c.json({\n success: true,\n message: \"Logged out successfully\"\n });\n});\n\n// Get current user\nauth.get(\"/me\", async (c) => {\n try {\n const token = getCookie(c, \"auth_token\") || c.req.header(\"Authorization\")?.replace(\"Bearer \", \"\");\n \n if (!token) {\n return c.json({\n success: false,\n error: \"No authentication token provided\"\n }, 401);\n }\n\n const payload = await verify(token, JWT_SECRET);\n const user = await getUserByEmail(payload.email);\n \n if (!user) {\n return c.json({\n success: false,\n error: \"User not found\"\n }, 404);\n }\n\n const { passwordHash, ...userWithoutPassword } = user;\n\n return c.json({\n success: true,\n data: userWithoutPassword\n });\n } catch (error) {\n console.error(\"Auth verification error:\", error);\n return c.json({\n success: false,\n error: \"Invalid or expired token\"\n }, 401);\n }\n});\n\n// Middleware to verify authentication\nexport async function authMiddleware(c: any, next: any) {\n try {\n const token = getCookie(c, \"auth_token\") || c.req.header(\"Authorization\")?.replace(\"Bearer \", \"\");\n \n if (!token) {\n return c.json({\n success: false,\n error: \"Authentication required\"\n }, 401);\n }\n\n const payload = await verify(token, JWT_SECRET);\n c.set(\"user\", payload);\n \n await next();\n } catch (error) {\n return c.json({\n success: false,\n error: \"Invalid or expired token\"\n }, 401);\n }\n}\n\n// Middleware to verify admin access\nexport async function adminMiddleware(c: any, next: any) {\n const user = c.get(\"user\");\n \n if (!user || !user.isAdmin) {\n return c.json({\n success: false,\n error: \"Admin access required\"\n }, 403);\n }\n \n await next();\n}\n\nexport default auth;",[],[91,225,256],"e33d1d46-3f95-11f0-847a-76b3cceeab13","database","30a876c7-cc33-49f0-914e-2f846a177da7",["D",1748857344309],[268,269],[91,263],{"_34":277,"_13":278,"_63":279,"_65":264,"_66":67,"_68":69,"_70":71,"_36":280,"_17":31,"_73":112,"_74":281,"_76":49,"_77":-5,"_100":282,"_18":283},{"_34":270,"_13":271,"_63":272,"_65":264,"_66":67,"_68":69,"_70":71,"_36":273,"_17":31,"_73":112,"_74":274,"_76":49,"_77":-5,"_100":275,"_18":276},"e33d08ec-3f95-11f0-847a-76b3cceeab13","queries.ts","fedc36dd-2b95-4ed7-86d0-6033e8b45f3c",["D",1748857344309],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport type { \n User, Product, CartItem, Order, OrderItem, Review, Category,\n ProductFilters, ProductSort, PaginationParams, PaginatedResponse\n} from \"../../shared/types.ts\";\nimport { getImageUrl } from \"../../shared/utils.ts\";\n\n// User queries\nexport async function getUserById(id: number): Promise {\n const result = await sqlite.execute(\n \"SELECT id, email, first_name, last_name, is_admin, created_at FROM users WHERE id = ?\",\n [id]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n return {\n id: user.id,\n email: user.email,\n firstName: user.first_name,\n lastName: user.last_name,\n isAdmin: Boolean(user.is_admin),\n createdAt: user.created_at\n };\n}\n\nexport async function getUserByEmail(email: string): Promise<(User & { passwordHash: string }) | null> {\n const result = await sqlite.execute(\n \"SELECT id, email, password_hash, first_name, last_name, is_admin, created_at FROM users WHERE email = ?\",\n [email]\n );\n \n if (result.length === 0) return null;\n \n const user = result[0];\n return {\n id: user.id,\n email: user.email,\n passwordHash: user.password_hash,\n firstName: user.first_name,\n lastName: user.last_name,\n isAdmin: Boolean(user.is_admin),\n createdAt: user.created_at\n };\n}\n\nexport async function createUser(userData: {\n email: string;\n passwordHash: string;\n firstName: string;\n lastName: string;\n}): Promise {\n const result = await sqlite.execute(\n `INSERT INTO users (email, password_hash, first_name, last_name)\n VALUES (?, ?, ?, ?)`,\n [userData.email, userData.passwordHash, userData.firstName, userData.lastName]\n );\n \n const userId = result.lastInsertRowid;\n const user = await getUserById(userId);\n if (!user) throw new Error(\"Failed to create user\");\n \n return user;\n}\n\n// Category queries\nexport async function getCategories(): Promise {\n const result = await sqlite.execute(`\n SELECT c.*, COUNT(p.id) as product_count\n FROM categories c\n LEFT JOIN products p ON c.id = p.category_id\n GROUP BY c.id\n ORDER BY c.name\n `);\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n slug: row.slug,\n description: row.description,\n imageUrl: row.image_url,\n productCount: row.product_count\n }));\n}\n\nexport async function getCategoryBySlug(slug: string): Promise {\n const result = await sqlite.execute(\n \"SELECT * FROM categories WHERE slug = ?\",\n [slug]\n );\n \n if (result.length === 0) return null;\n \n const category = result[0];\n return {\n id: category.id,\n name: category.name,\n slug: category.slug,\n description: category.description,\n imageUrl: category.image_url,\n productCount: 0 // Will be filled separately if needed\n };\n}\n\n// Product queries\nexport async function getProducts(\n filters: ProductFilters = {},\n sort: ProductSort = { field: 'createdAt', direction: 'desc' },\n pagination: PaginationParams = { page: 1, limit: 12 }\n): Promise> {\n let whereClause = \"WHERE 1=1\";\n const params: any[] = [];\n \n if (filters.category) {\n whereClause += \" AND c.slug = ?\";\n params.push(filters.category);\n }\n \n if (filters.brand) {\n whereClause += \" AND p.brand = ?\";\n params.push(filters.brand);\n }\n \n if (filters.minPrice !== undefined) {\n whereClause += \" AND p.price >= ?\";\n params.push(filters.minPrice);\n }\n \n if (filters.maxPrice !== undefined) {\n whereClause += \" AND p.price <= ?\";\n params.push(filters.maxPrice);\n }\n \n if (filters.inStock) {\n whereClause += \" AND p.in_stock = TRUE AND p.stock_quantity > 0\";\n }\n \n if (filters.featured) {\n whereClause += \" AND p.featured = TRUE\";\n }\n \n if (filters.search) {\n whereClause += \" AND (p.name LIKE ? OR p.description LIKE ? OR p.brand LIKE ?)\";\n const searchTerm = `%${filters.search}%`;\n params.push(searchTerm, searchTerm, searchTerm);\n }\n \n const orderClause = `ORDER BY p.${sort.field} ${sort.direction.toUpperCase()}`;\n const offset = (pagination.page - 1) * pagination.limit;\n \n // Get total count\n const countQuery = `\n SELECT COUNT(*) as total\n FROM products p\n LEFT JOIN categories c ON p.category_id = c.id\n ${whereClause}\n `;\n const countResult = await sqlite.execute(countQuery, params);\n const total = countResult[0].total;\n \n // Get products\n const query = `\n SELECT p.*, c.name as category_name, c.slug as category_slug\n FROM products p\n LEFT JOIN categories c ON p.category_id = c.id\n ${whereClause}\n ${orderClause}\n LIMIT ? OFFSET ?\n `;\n \n const result = await sqlite.execute(query, [...params, pagination.limit, offset]);\n \n const products: Product[] = result.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category_name || 'Uncategorized',\n brand: row.brand,\n imageUrl: getImageUrl(row.image_url),\n images: row.images ? JSON.parse(row.images).map(getImageUrl) : [getImageUrl(row.image_url)],\n inStock: Boolean(row.in_stock),\n stockQuantity: row.stock_quantity,\n rating: row.rating,\n reviewCount: row.review_count,\n featured: Boolean(row.featured),\n createdAt: row.created_at\n }));\n \n const totalPages = Math.ceil(total / pagination.limit);\n \n return {\n data: products,\n pagination: {\n page: pagination.page,\n limit: pagination.limit,\n total,\n totalPages,\n hasNext: pagination.page < totalPages,\n hasPrev: pagination.page > 1\n }\n };\n}\n\nexport async function getProductById(id: number): Promise {\n const result = await sqlite.execute(`\n SELECT p.*, c.name as category_name, c.slug as category_slug\n FROM products p\n LEFT JOIN categories c ON p.category_id = c.id\n WHERE p.id = ?\n `, [id]);\n \n if (result.length === 0) return null;\n \n const row = result[0];\n return {\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category_name || 'Uncategorized',\n brand: row.brand,\n imageUrl: getImageUrl(row.image_url),\n images: row.images ? JSON.parse(row.images).map(getImageUrl) : [getImageUrl(row.image_url)],\n inStock: Boolean(row.in_stock),\n stockQuantity: row.stock_quantity,\n rating: row.rating,\n reviewCount: row.review_count,\n featured: Boolean(row.featured),\n createdAt: row.created_at\n };\n}\n\nexport async function getFeaturedProducts(limit: number = 8): Promise {\n const result = await getProducts(\n { featured: true },\n { field: 'rating', direction: 'desc' },\n { page: 1, limit }\n );\n return result.data;\n}\n\nexport async function getRelatedProducts(productId: number, limit: number = 4): Promise {\n const product = await getProductById(productId);\n if (!product) return [];\n \n const result = await sqlite.execute(`\n SELECT p.*, c.name as category_name, c.slug as category_slug\n FROM products p\n LEFT JOIN categories c ON p.category_id = c.id\n WHERE p.id != ? AND (c.name = ? OR p.brand = ?)\n ORDER BY p.rating DESC, p.review_count DESC\n LIMIT ?\n `, [productId, product.category, product.brand, limit]);\n \n return result.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category_name || 'Uncategorized',\n brand: row.brand,\n imageUrl: getImageUrl(row.image_url),\n images: row.images ? JSON.parse(row.images).map(getImageUrl) : [getImageUrl(row.image_url)],\n inStock: Boolean(row.in_stock),\n stockQuantity: row.stock_quantity,\n rating: row.rating,\n reviewCount: row.review_count,\n featured: Boolean(row.featured),\n createdAt: row.created_at\n }));\n}\n\n// Cart queries\nexport async function getCartItems(userId?: number, sessionId?: string): Promise {\n let query = `\n SELECT ci.*, p.*, c.name as category_name\n FROM cart_items ci\n JOIN products p ON ci.product_id = p.id\n LEFT JOIN categories c ON p.category_id = c.id\n `;\n let params: any[] = [];\n \n if (userId) {\n query += \" WHERE ci.user_id = ?\";\n params.push(userId);\n } else if (sessionId) {\n query += \" WHERE ci.session_id = ?\";\n params.push(sessionId);\n } else {\n return [];\n }\n \n const result = await sqlite.execute(query, params);\n \n return result.map(row => ({\n id: row.id,\n productId: row.product_id,\n quantity: row.quantity,\n userId: row.user_id,\n sessionId: row.session_id,\n product: {\n id: row.product_id,\n name: row.name,\n description: row.description,\n price: row.price,\n originalPrice: row.original_price,\n category: row.category_name || 'Uncategorized',\n brand: row.brand,\n imageUrl: getImageUrl(row.image_url),\n images: row.images ? JSON.parse(row.images).map(getImageUrl) : [getImageUrl(row.image_url)],\n inStock: Boolean(row.in_stock),\n stockQuantity: row.stock_quantity,\n rating: row.rating,\n reviewCount: row.review_count,\n featured: Boolean(row.featured),\n createdAt: row.created_at\n }\n }));\n}\n\nexport async function addToCart(productId: number, quantity: number, userId?: number, sessionId?: string): Promise {\n // Check if item already exists in cart\n let existingQuery = \"SELECT * FROM cart_items WHERE product_id = ?\";\n let existingParams = [productId];\n \n if (userId) {\n existingQuery += \" AND user_id = ?\";\n existingParams.push(userId);\n } else if (sessionId) {\n existingQuery += \" AND session_id = ?\";\n existingParams.push(sessionId);\n }\n \n const existing = await sqlite.execute(existingQuery, existingParams);\n \n if (existing.length > 0) {\n // Update quantity\n const newQuantity = existing[0].quantity + quantity;\n await sqlite.execute(\n \"UPDATE cart_items SET quantity = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?\",\n [newQuantity, existing[0].id]\n );\n \n const cartItems = await getCartItems(userId, sessionId);\n return cartItems.find(item => item.id === existing[0].id)!;\n } else {\n // Insert new item\n const result = await sqlite.execute(\n \"INSERT INTO cart_items (product_id, quantity, user_id, session_id) VALUES (?, ?, ?, ?)\",\n [productId, quantity, userId || null, sessionId || null]\n );\n \n const cartItems = await getCartItems(userId, sessionId);\n return cartItems.find(item => item.id === result.lastInsertRowid)!;\n }\n}\n\nexport async function updateCartItem(itemId: number, quantity: number): Promise {\n if (quantity <= 0) {\n await sqlite.execute(\"DELETE FROM cart_items WHERE id = ?\", [itemId]);\n } else {\n await sqlite.execute(\n \"UPDATE cart_items SET quantity = ?, updated_at = CURRENT_TIMESTAMP WHERE id = ?\",\n [quantity, itemId]\n );\n }\n}\n\nexport async function removeFromCart(itemId: number): Promise {\n await sqlite.execute(\"DELETE FROM cart_items WHERE id = ?\", [itemId]);\n}\n\nexport async function clearCart(userId?: number, sessionId?: string): Promise {\n if (userId) {\n await sqlite.execute(\"DELETE FROM cart_items WHERE user_id = ?\", [userId]);\n } else if (sessionId) {\n await sqlite.execute(\"DELETE FROM cart_items WHERE session_id = ?\", [sessionId]);\n }\n}\n\n// Review queries\nexport async function getProductReviews(productId: number): Promise {\n const result = await sqlite.execute(`\n SELECT r.*, u.first_name, u.last_name, u.email\n FROM reviews r\n JOIN users u ON r.user_id = u.id\n WHERE r.product_id = ?\n ORDER BY r.created_at DESC\n `, [productId]);\n \n return result.map(row => ({\n id: row.id,\n productId: row.product_id,\n userId: row.user_id,\n rating: row.rating,\n title: row.title,\n comment: row.comment,\n createdAt: row.created_at,\n user: {\n id: row.user_id,\n email: row.email,\n firstName: row.first_name,\n lastName: row.last_name,\n isAdmin: false,\n createdAt: ''\n }\n }));\n}\n\n// Order queries\nexport async function createOrder(orderData: {\n userId: number;\n items: { productId: number; quantity: number; price: number }[];\n subtotal: number;\n tax: number;\n shipping: number;\n total: number;\n shippingAddress: any;\n billingAddress: any;\n paymentMethod: string;\n}): Promise {\n // Create order\n const orderResult = await sqlite.execute(`\n INSERT INTO orders (\n user_id, subtotal, tax, shipping, total,\n shipping_address, billing_address, payment_method\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n orderData.userId,\n orderData.subtotal,\n orderData.tax,\n orderData.shipping,\n orderData.total,\n JSON.stringify(orderData.shippingAddress),\n JSON.stringify(orderData.billingAddress),\n orderData.paymentMethod\n ]);\n \n const orderId = orderResult.lastInsertRowid;\n \n // Create order items\n for (const item of orderData.items) {\n await sqlite.execute(`\n INSERT INTO order_items (order_id, product_id, quantity, price)\n VALUES (?, ?, ?, ?)\n `, [orderId, item.productId, item.quantity, item.price]);\n }\n \n return getOrderById(orderId);\n}\n\nexport async function getOrderById(id: number): Promise {\n const orderResult = await sqlite.execute(`\n SELECT o.*, u.first_name, u.last_name, u.email\n FROM orders o\n JOIN users u ON o.user_id = u.id\n WHERE o.id = ?\n `, [id]);\n \n if (orderResult.length === 0) {\n throw new Error(\"Order not found\");\n }\n \n const order = orderResult[0];\n \n // Get order items\n const itemsResult = await sqlite.execute(`\n SELECT oi.*, p.name, p.description, p.image_url, p.brand\n FROM order_items oi\n JOIN products p ON oi.product_id = p.id\n WHERE oi.order_id = ?\n `, [id]);\n \n const items: OrderItem[] = itemsResult.map(item => ({\n id: item.id,\n orderId: item.order_id,\n productId: item.product_id,\n quantity: item.quantity,\n price: item.price,\n product: {\n id: item.product_id,\n name: item.name,\n description: item.description,\n price: item.price,\n category: '',\n brand: item.brand,\n imageUrl: getImageUrl(item.image_url),\n images: [getImageUrl(item.image_url)],\n inStock: true,\n stockQuantity: 0,\n rating: 0,\n reviewCount: 0,\n featured: false,\n createdAt: ''\n }\n }));\n \n return {\n id: order.id,\n userId: order.user_id,\n items,\n subtotal: order.subtotal,\n tax: order.tax,\n shipping: order.shipping,\n total: order.total,\n status: order.status,\n shippingAddress: JSON.parse(order.shipping_address),\n billingAddress: JSON.parse(order.billing_address),\n paymentMethod: order.payment_method,\n createdAt: order.created_at,\n updatedAt: order.updated_at,\n user: {\n id: order.user_id,\n email: order.email,\n firstName: order.first_name,\n lastName: order.last_name,\n isAdmin: false,\n createdAt: ''\n }\n };\n}\n\nexport async function getUserOrders(userId: number): Promise {\n const result = await sqlite.execute(`\n SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC\n `, [userId]);\n \n const orders = [];\n for (const orderRow of result) {\n const order = await getOrderById(orderRow.id);\n orders.push(order);\n }\n \n return orders;\n}",[],[91,263,271],"e33ce9f2-3f95-11f0-847a-76b3cceeab13","migrations.ts","021e9a2f-3d6f-475c-afc9-063b5929a972",["D",1748857344309],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nexport async function runMigrations() {\n console.log(\"Running database migrations...\");\n\n // Users table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS users (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n email TEXT UNIQUE NOT NULL,\n password_hash TEXT NOT NULL,\n first_name TEXT NOT NULL,\n last_name TEXT NOT NULL,\n is_admin BOOLEAN DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Categories table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS categories (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n slug TEXT UNIQUE NOT NULL,\n description TEXT,\n image_url TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n // Products table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS products (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n price DECIMAL(10,2) NOT NULL,\n original_price DECIMAL(10,2),\n category_id INTEGER,\n brand TEXT NOT NULL,\n image_url TEXT NOT NULL,\n images TEXT, -- JSON array of image URLs\n in_stock BOOLEAN DEFAULT TRUE,\n stock_quantity INTEGER DEFAULT 0,\n rating DECIMAL(3,2) DEFAULT 0,\n review_count INTEGER DEFAULT 0,\n featured BOOLEAN DEFAULT FALSE,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (category_id) REFERENCES categories (id)\n )\n `);\n\n // Cart items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS cart_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER,\n session_id TEXT,\n product_id INTEGER NOT NULL,\n quantity INTEGER NOT NULL DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,\n FOREIGN KEY (product_id) REFERENCES products (id) ON DELETE CASCADE\n )\n `);\n\n // Orders table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS orders (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n user_id INTEGER NOT NULL,\n subtotal DECIMAL(10,2) NOT NULL,\n tax DECIMAL(10,2) NOT NULL,\n shipping DECIMAL(10,2) NOT NULL,\n total DECIMAL(10,2) NOT NULL,\n status TEXT DEFAULT 'pending',\n shipping_address TEXT NOT NULL, -- JSON\n billing_address TEXT NOT NULL, -- JSON\n payment_method TEXT NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n updated_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users (id)\n )\n `);\n\n // Order items table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS order_items (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_id INTEGER NOT NULL,\n product_id INTEGER NOT NULL,\n quantity INTEGER NOT NULL,\n price DECIMAL(10,2) NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (order_id) REFERENCES orders (id) ON DELETE CASCADE,\n FOREIGN KEY (product_id) REFERENCES products (id)\n )\n `);\n\n // Reviews table\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS reviews (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n product_id INTEGER NOT NULL,\n user_id INTEGER NOT NULL,\n rating INTEGER NOT NULL CHECK (rating >= 1 AND rating <= 5),\n title TEXT NOT NULL,\n comment TEXT,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (product_id) REFERENCES products (id) ON DELETE CASCADE,\n FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE,\n UNIQUE(product_id, user_id)\n )\n `);\n\n // Sessions table for cart persistence\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY,\n user_id INTEGER,\n data TEXT, -- JSON\n expires_at DATETIME NOT NULL,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY (user_id) REFERENCES users (id) ON DELETE CASCADE\n )\n `);\n\n console.log(\"Database migrations completed successfully\");\n}\n\nexport async function seedData() {\n console.log(\"Seeding sample data...\");\n\n // Check if data already exists\n const existingProducts = await sqlite.execute(\"SELECT COUNT(*) as count FROM products\");\n if (existingProducts[0].count > 0) {\n console.log(\"Sample data already exists, skipping seed\");\n return;\n }\n\n // Create admin user\n await sqlite.execute(`\n INSERT INTO users (email, password_hash, first_name, last_name, is_admin)\n VALUES ('admin@example.com', '$2a$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'Admin', 'User', TRUE)\n `);\n\n // Create sample user\n await sqlite.execute(`\n INSERT INTO users (email, password_hash, first_name, last_name, is_admin)\n VALUES ('user@example.com', '$2a$10$92IXUNpkjO0rOQ5byMi.Ye4oKoEa3Ro9llC/.og/at2.uheWG/igi', 'John', 'Doe', FALSE)\n `);\n\n // Create categories\n const categories = [\n { name: 'Electronics', slug: 'electronics', description: 'Latest electronic devices and gadgets' },\n { name: 'Computers', slug: 'computers', description: 'Laptops, desktops, and computer accessories' },\n { name: 'Mobile Phones', slug: 'mobile-phones', description: 'Smartphones and mobile accessories' },\n { name: 'Audio', slug: 'audio', description: 'Headphones, speakers, and audio equipment' },\n { name: 'Wearables', slug: 'wearables', description: 'Smart watches and fitness trackers' },\n { name: 'Cameras', slug: 'cameras', description: 'Digital cameras and photography equipment' }\n ];\n\n for (const category of categories) {\n await sqlite.execute(`\n INSERT INTO categories (name, slug, description)\n VALUES (?, ?, ?)\n `, [category.name, category.slug, category.description]);\n }\n\n // Create sample products\n const products = [\n {\n name: 'MacBook Pro 16\"',\n description: 'Powerful laptop with M2 Pro chip, perfect for professionals and creators.',\n price: 2499.00,\n originalPrice: 2699.00,\n categoryId: 2,\n brand: 'Apple',\n imageUrl: 'laptop-1.jpg',\n images: JSON.stringify(['laptop-1.jpg', 'laptop-2.jpg', 'laptop-3.jpg']),\n stockQuantity: 15,\n rating: 4.8,\n reviewCount: 124,\n featured: true\n },\n {\n name: 'iPhone 15 Pro',\n description: 'Latest iPhone with titanium design and advanced camera system.',\n price: 999.00,\n categoryId: 3,\n brand: 'Apple',\n imageUrl: 'phone-1.jpg',\n images: JSON.stringify(['phone-1.jpg', 'phone-2.jpg']),\n stockQuantity: 25,\n rating: 4.9,\n reviewCount: 89,\n featured: true\n },\n {\n name: 'Sony WH-1000XM5',\n description: 'Industry-leading noise canceling wireless headphones.',\n price: 399.00,\n originalPrice: 449.00,\n categoryId: 4,\n brand: 'Sony',\n imageUrl: 'headphones-1.jpg',\n images: JSON.stringify(['headphones-1.jpg']),\n stockQuantity: 30,\n rating: 4.7,\n reviewCount: 156,\n featured: false\n },\n {\n name: 'Apple Watch Series 9',\n description: 'Advanced smartwatch with health monitoring and fitness tracking.',\n price: 429.00,\n categoryId: 5,\n brand: 'Apple',\n imageUrl: 'watch-1.jpg',\n images: JSON.stringify(['watch-1.jpg']),\n stockQuantity: 20,\n rating: 4.6,\n reviewCount: 78,\n featured: true\n },\n {\n name: 'Canon EOS R6 Mark II',\n description: 'Professional mirrorless camera with exceptional image quality.',\n price: 2499.00,\n categoryId: 6,\n brand: 'Canon',\n imageUrl: 'camera-1.jpg',\n images: JSON.stringify(['camera-1.jpg']),\n stockQuantity: 8,\n rating: 4.9,\n reviewCount: 45,\n featured: false\n },\n {\n name: 'iPad Pro 12.9\"',\n description: 'Ultimate iPad experience with M2 chip and Liquid Retina XDR display.',\n price: 1099.00,\n categoryId: 2,\n brand: 'Apple',\n imageUrl: 'tablet-1.jpg',\n images: JSON.stringify(['tablet-1.jpg']),\n stockQuantity: 18,\n rating: 4.8,\n reviewCount: 92,\n featured: false\n },\n {\n name: 'Sonos Era 100',\n description: 'Smart speaker with incredible sound and voice control.',\n price: 249.00,\n categoryId: 4,\n brand: 'Sonos',\n imageUrl: 'speaker-1.jpg',\n images: JSON.stringify(['speaker-1.jpg']),\n stockQuantity: 35,\n rating: 4.5,\n reviewCount: 67,\n featured: false\n },\n {\n name: 'Logitech MX Master 3S',\n description: 'Advanced wireless mouse for productivity and precision.',\n price: 99.00,\n categoryId: 2,\n brand: 'Logitech',\n imageUrl: 'keyboard-1.jpg',\n images: JSON.stringify(['keyboard-1.jpg']),\n stockQuantity: 50,\n rating: 4.4,\n reviewCount: 134,\n featured: false\n }\n ];\n\n for (const product of products) {\n await sqlite.execute(`\n INSERT INTO products (\n name, description, price, original_price, category_id, brand,\n image_url, images, stock_quantity, rating, review_count, featured\n ) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\n `, [\n product.name, product.description, product.price, product.originalPrice || null,\n product.categoryId, product.brand, product.imageUrl, product.images,\n product.stockQuantity, product.rating, product.reviewCount, product.featured\n ]);\n }\n\n // Create sample reviews\n const reviews = [\n { productId: 1, userId: 2, rating: 5, title: 'Excellent laptop!', comment: 'Perfect for my development work. Fast and reliable.' },\n { productId: 1, userId: 1, rating: 4, title: 'Great performance', comment: 'Love the display and battery life.' },\n { productId: 2, userId: 2, rating: 5, title: 'Best iPhone yet', comment: 'Camera quality is amazing and the titanium feels premium.' },\n { productId: 3, userId: 1, rating: 5, title: 'Amazing sound quality', comment: 'Noise cancellation is incredible for flights.' }\n ];\n\n for (const review of reviews) {\n await sqlite.execute(`\n INSERT INTO reviews (product_id, user_id, rating, title, comment)\n VALUES (?, ?, ?, ?, ?)\n `, [review.productId, review.userId, review.rating, review.title, review.comment]);\n }\n\n console.log(\"Sample data seeded successfully\");\n}",[],[91,263,278],"e3367388-3f95-11f0-847a-76b3cceeab13",["D",1748857344309],"legacyEnvVars","public","httpPrivacy","description","imageUrl","userId","c4bd24b0-3f7c-11f0-ad5b-814c56c8abb0","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","tursoName","tursoHostname","tursoMeasuredAt","pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_326":322},"org",{"_11":12,"_320":-5,"_321":322,"_291":292,"_323":324,"_325":49},"branch",{"_17":69,"_13":16,"_34":67,"_40":284,"_43":35,"_44":42,"_317":51,"_318":41,"_319":54,"_55":14,"_52":12},"forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18yeHdRQjZEaWNlNG56cDExM1VzSkFDSk5XY3EifQ","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_34":284,"_13":14,"_36":443,"_47":-5,"_286":49,"_50":287,"_288":287,"_289":-5,"_290":-5,"_291":292,"_293":-5,"_294":49,"_295":-5,"_296":-5,"_297":31,"_53":54,"_298":-5,"_299":-5,"_300":-5,"_301":-5,"_302":303,"_304":303,"_305":306,"_307":306,"_308":306,"_309":303,"_310":303,"_311":444,"_313":445,"_315":446,"_48":49},[365,375,387,390],"files",[365,366,367,368,369,370,371,372,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390],"counts",{"_356":31,"_357":69,"_358":31,"_33":359,"_360":361},[348,349,350,351],"upstreamProject","upstreamBranch",{"_34":35,"_36":346,"_38":347,"_13":16,"_40":41,"_17":42,"_43":-5,"_44":-5,"_45":46,"_47":-5,"_48":49,"_50":51,"_52":12,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1748853801153],["D",1748854572059],{"_34":90,"_13":91,"_63":92,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":93,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_18":355},{"_34":85,"_13":86,"_63":87,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":88,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_18":354},{"_34":79,"_13":80,"_63":81,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":82,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_18":353},{"_34":61,"_13":62,"_63":64,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":72,"_17":31,"_73":24,"_74":75,"_76":49,"_77":-5,"_18":352},[62],[80],[86],[91],"pulls","branches","forks",{"_362":31,"_364":31},"connections",{"_362":31,"_363":31},"count","unfilledCount","emptyCount",{"_34":90,"_13":91,"_63":92,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":211,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":441,"_18":442},{"_34":262,"_13":263,"_63":264,"_65":92,"_66":67,"_68":69,"_70":71,"_36":265,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":439,"_18":440},{"_34":277,"_13":278,"_63":279,"_65":264,"_66":67,"_68":69,"_70":71,"_36":280,"_17":31,"_73":112,"_74":281,"_76":49,"_77":-5,"_100":437,"_18":438},{"_34":270,"_13":271,"_63":272,"_65":264,"_66":67,"_68":69,"_70":71,"_36":273,"_17":31,"_73":112,"_74":274,"_76":49,"_77":-5,"_100":435,"_18":436},{"_34":224,"_13":225,"_63":226,"_65":92,"_66":67,"_68":69,"_70":71,"_36":227,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":433,"_18":434},{"_34":255,"_13":256,"_63":257,"_65":226,"_66":67,"_68":69,"_70":71,"_36":258,"_17":31,"_73":112,"_74":259,"_76":49,"_77":-5,"_100":431,"_18":432},{"_34":248,"_13":249,"_63":250,"_65":226,"_66":67,"_68":69,"_70":71,"_36":251,"_17":31,"_73":112,"_74":252,"_76":49,"_77":-5,"_100":429,"_18":430},{"_34":241,"_13":242,"_63":243,"_65":226,"_66":67,"_68":69,"_70":71,"_36":244,"_17":31,"_73":112,"_74":245,"_76":49,"_77":-5,"_100":427,"_18":428},{"_34":234,"_13":235,"_63":236,"_65":226,"_66":67,"_68":69,"_70":71,"_36":237,"_17":31,"_73":112,"_74":238,"_76":49,"_77":-5,"_100":425,"_18":426},{"_34":217,"_13":218,"_63":219,"_65":92,"_66":67,"_68":69,"_70":71,"_36":220,"_17":31,"_73":112,"_74":221,"_76":49,"_77":-5,"_100":423,"_18":424},{"_34":85,"_13":86,"_63":87,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":123,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":421,"_18":422},{"_34":143,"_13":144,"_63":145,"_65":87,"_66":67,"_68":69,"_70":71,"_36":146,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":419,"_18":420},{"_34":181,"_13":182,"_63":183,"_65":145,"_66":67,"_68":69,"_70":71,"_36":184,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":417,"_18":418},{"_34":204,"_13":205,"_63":206,"_65":183,"_66":67,"_68":69,"_70":71,"_36":207,"_17":31,"_73":112,"_74":208,"_76":49,"_77":-5,"_100":415,"_18":416},{"_34":197,"_13":198,"_63":199,"_65":183,"_66":67,"_68":69,"_70":71,"_36":200,"_17":31,"_73":112,"_74":201,"_76":49,"_77":-5,"_100":413,"_18":414},{"_34":190,"_13":191,"_63":192,"_65":183,"_66":67,"_68":69,"_70":71,"_36":193,"_17":31,"_73":112,"_74":194,"_76":49,"_77":-5,"_100":411,"_18":412},{"_34":159,"_13":160,"_63":161,"_65":145,"_66":67,"_68":69,"_70":71,"_36":162,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":409,"_18":410},{"_34":174,"_13":175,"_63":176,"_65":161,"_66":67,"_68":69,"_70":71,"_36":177,"_17":31,"_73":112,"_74":178,"_76":49,"_77":-5,"_100":407,"_18":408},{"_34":167,"_13":168,"_63":169,"_65":161,"_66":67,"_68":69,"_70":71,"_36":170,"_17":31,"_73":112,"_74":171,"_76":49,"_77":-5,"_100":405,"_18":406},{"_34":152,"_13":153,"_63":154,"_65":145,"_66":67,"_68":69,"_70":71,"_36":155,"_17":31,"_73":112,"_74":156,"_76":49,"_77":-5,"_100":403,"_18":404},{"_34":136,"_13":137,"_63":138,"_65":87,"_66":67,"_68":69,"_70":71,"_36":139,"_17":31,"_73":24,"_74":140,"_76":49,"_77":-5,"_100":401,"_18":402},{"_34":129,"_13":130,"_63":131,"_65":87,"_66":67,"_68":69,"_70":71,"_36":132,"_17":31,"_73":112,"_74":133,"_76":49,"_77":-5,"_100":399,"_18":400},{"_34":79,"_13":80,"_63":81,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":103,"_17":31,"_73":83,"_74":-5,"_76":49,"_77":-5,"_100":397,"_18":398},{"_34":116,"_13":117,"_63":118,"_65":81,"_66":67,"_68":69,"_70":71,"_36":119,"_17":31,"_73":112,"_74":120,"_76":49,"_77":-5,"_100":395,"_18":396},{"_34":108,"_13":109,"_63":110,"_65":81,"_66":67,"_68":69,"_70":71,"_36":111,"_17":31,"_73":112,"_74":113,"_76":49,"_77":-5,"_100":393,"_18":394},{"_34":61,"_13":62,"_63":64,"_65":-5,"_66":67,"_68":69,"_70":71,"_36":99,"_17":31,"_73":24,"_74":75,"_76":49,"_77":-5,"_100":391,"_18":392},[],[62],[],[80,109],[],[80,117],[388,389],[80],[],[86,130],[],[86,137],[],[86,144,153],[],[86,144,160,168],[],[86,144,160,175],[382,383],[86,144,160],[],[86,144,182,191],[],[86,144,182,198],[],[86,144,182,205],[378,379,380],[86,144,182],[377,381,384],[86,144],[376,385,386],[86],[],[91,218],[],[91,225,235],[],[91,225,242],[],[91,225,249],[],[91,225,256],[370,371,372,373],[91,225],[],[91,263,271],[],[91,263,278],[367,368],[91,263],[366,369,374],[91],["D",1748857344309],{"_11":12,"_326":322},{"_11":12,"_320":-5,"_321":322,"_291":292,"_323":324,"_325":49},{"_17":69,"_13":16,"_34":67,"_40":284,"_43":35,"_44":42,"_317":51,"_318":41,"_319":54,"_55":14,"_52":12},"ctx",{"_311":-5,"_343":480,"_481":482,"_483":484,"_485":49,"_486":49,"_487":49,"_488":71,"_489":-5,"_490":-7,"_491":-7,"_492":31,"_493":49,"_494":49,"_495":-5,"_496":49,"_497":49,"_498":49,"_499":-5},"ENV",{"_451":452,"_453":454,"_455":16,"_456":457,"_458":459,"_460":461,"_462":463,"_464":465,"_466":467,"_468":469,"_470":471,"_472":473,"_474":475,"_476":477,"_478":479},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","71c1b20804b3232a7e513be260cfffc1932a9e97","RENDER_GIT_BRANCH","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","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Code