\n \n

Loading beautiful beaded bags...

\n\n \n \n\n",[],[257,267],"a845ee78-3f9c-11f0-8e51-76b3cceeab13","ProductCard.tsx","a845ef22-3f9c-11f0-8e51-76b3cceeab13","040254c3-c489-464f-adb5-0907996d4ec8",12,["D",1748860251902],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { Product } from \"../../shared/types.ts\";\n\ninterface ProductCardProps {\n product: Product;\n onAddToCart: (product: Product) => void;\n}\n\nexport default function ProductCard({ product, onAddToCart }: ProductCardProps) {\n const [isAdding, setIsAdding] = useState(false);\n const [imageLoaded, setImageLoaded] = useState(false);\n\n const handleAddToCart = async () => {\n setIsAdding(true);\n onAddToCart(product);\n \n // Add a small delay for visual feedback\n setTimeout(() => {\n setIsAdding(false);\n }, 600);\n };\n\n return (\n

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

\n {!imageLoaded && (\n

\n )}\n setImageLoaded(true)}\n onError={(e) => {\n // Fallback to a placeholder if image fails to load\n (e.target as HTMLImageElement).src = `data:image/svg+xml,`;\n setImageLoaded(true);\n }}\n />\n \n {/* Category Badge */}\n

\n \n {product.category}\n \n

\n\n {/* Stock Status */}\n {product.in_stock && (\n

\n \n In Stock\n \n

\n )}\n

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

\n {product.name}\n

\n \n

\n {product.description}\n

\n\n

\n ${product.price.toFixed(2)}\n

\n \n \n {isAdding ? (\n \n \n Adding...\n \n ) : !product.in_stock ? (\n 'Out of Stock'\n ) : (\n \n \n Add to Cart\n \n )}\n \n

\n );\n}",[],[257,283,275],"components","d27c2950-3f9c-11f0-9138-76b3cceeab13","OrderForm.tsx","d27c2a18-3f9c-11f0-9138-76b3cceeab13",14,["D",1748860322723],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport type { CartItem, CreateOrderRequest } from \"../../shared/types.ts\";\n\ninterface OrderFormProps {\n isOpen: boolean;\n onClose: () => void;\n cart: CartItem[];\n total: number;\n onOrderComplete: () => void;\n}\n\nexport default function OrderForm({\n isOpen,\n onClose,\n cart,\n total,\n onOrderComplete\n}: OrderFormProps) {\n const [formData, setFormData] = useState({\n customer_name: '',\n customer_email: '',\n customer_phone: '',\n shipping_address: ''\n });\n const [isSubmitting, setIsSubmitting] = useState(false);\n const [orderSuccess, setOrderSuccess] = useState(false);\n const [orderId, setOrderId] = useState(null);\n const [errors, setErrors] = useState>({});\n\n if (!isOpen) return null;\n\n const validateForm = () => {\n const newErrors: Record = {};\n\n if (!formData.customer_name.trim()) {\n newErrors.customer_name = 'Name is required';\n }\n\n if (!formData.customer_email.trim()) {\n newErrors.customer_email = 'Email is required';\n } else if (!/\\S+@\\S+\\.\\S+/.test(formData.customer_email)) {\n newErrors.customer_email = 'Please enter a valid email';\n }\n\n if (!formData.shipping_address.trim()) {\n newErrors.shipping_address = 'Shipping address is required';\n }\n\n setErrors(newErrors);\n return Object.keys(newErrors).length === 0;\n };\n\n const handleSubmit = async (e: React.FormEvent) => {\n e.preventDefault();\n \n if (!validateForm()) return;\n if (cart.length === 0) return;\n\n setIsSubmitting(true);\n\n try {\n const orderData: CreateOrderRequest = {\n ...formData,\n items: cart\n };\n\n const response = await fetch('/api/orders', {\n method: 'POST',\n headers: {\n 'Content-Type': 'application/json'\n },\n body: JSON.stringify(orderData)\n });\n\n const result = await response.json();\n\n if (result.success) {\n setOrderId(result.data);\n setOrderSuccess(true);\n // Reset form\n setFormData({\n customer_name: '',\n customer_email: '',\n customer_phone: '',\n shipping_address: ''\n });\n } else {\n alert('Failed to place order: ' + (result.error || 'Unknown error'));\n }\n } catch (error) {\n console.error('Order submission error:', error);\n alert('Failed to place order. Please try again.');\n } finally {\n setIsSubmitting(false);\n }\n };\n\n const handleClose = () => {\n if (orderSuccess) {\n onOrderComplete();\n setOrderSuccess(false);\n setOrderId(null);\n }\n onClose();\n };\n\n const handleInputChange = (e: React.ChangeEvent) => {\n const { name, value } = e.target;\n setFormData(prev => ({ ...prev, [name]: value }));\n // Clear error when user starts typing\n if (errors[name]) {\n setErrors(prev => ({ ...prev, [name]: '' }));\n }\n };\n\n return (\n <>\n {/* Backdrop */}\n

\n \n {/* Modal */}\n

\n {orderSuccess ? (\n /* Success State */\n

\n \n

\n Order Placed Successfully!\n

\n \n

\n Thank you for your order. Your order number is #{orderId}.\n

\n \n

\n We'll send you an email confirmation shortly with tracking information.\n

\n \n \n Continue Shopping\n \n

\n ) : (\n /* Order Form */\n <>\n {/* Header */}\n

\n Checkout\n

\n \n \n \n

\n\n {/* Order Summary */}\n

Order Summary

\n {cart.map(item => (\n

\n {item.product.name} × {item.quantity}\n ${(item.product.price * item.quantity).toFixed(2)}\n

\n ))}\n

\n Total:\n ${total.toFixed(2)}\n

\n\n {/* Form */}\n

\n {/* Customer Name */}\n

\n \n Full Name *\n \n \n {errors.customer_name && (\n

{errors.customer_name}

\n )}\n

\n\n {/* Email */}\n

\n \n Email Address *\n \n \n {errors.customer_email && (\n

{errors.customer_email}

\n )}\n

\n\n {/* Phone */}\n

\n \n Phone Number\n \n \n

\n\n {/* Shipping Address */}\n

\n \n Shipping Address *\n \n \n {errors.shipping_address && (\n

{errors.shipping_address}

\n )}\n

\n\n {/* Submit Button */}\n \n {isSubmitting ? (\n \n \n Placing Order...\n \n ) : (\n `Place Order - $${total.toFixed(2)}`\n )}\n \n\n

\n By placing this order, you agree to our terms and conditions.\n

\n \n \n )}\n

\n \n );\n}",[],[257,283,285],"b9be609a-3f9c-11f0-ae5a-76b3cceeab13","Cart.tsx","b9be6158-3f9c-11f0-ae5a-76b3cceeab13",13,["D",1748860281213],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React from \"https://esm.sh/react@18.2.0\";\nimport type { CartItem } from \"../../shared/types.ts\";\n\ninterface CartProps {\n isOpen: boolean;\n onClose: () => void;\n cart: CartItem[];\n onUpdateQuantity: (productId: number, quantity: number) => void;\n onRemoveItem: (productId: number) => void;\n onCheckout: () => void;\n total: number;\n}\n\nexport default function Cart({\n isOpen,\n onClose,\n cart,\n onUpdateQuantity,\n onRemoveItem,\n onCheckout,\n total\n}: CartProps) {\n if (!isOpen) return null;\n\n const itemCount = cart.reduce((sum, item) => sum + item.quantity, 0);\n\n return (\n <>\n {/* Backdrop */}\n

\n \n {/* Cart Sidebar */}\n

\n {/* Header */}\n

\n Shopping Cart ({itemCount})\n

\n \n \n \n

\n\n {/* Cart Items */}\n

\n {cart.length === 0 ? (\n

\n \n

Your cart is empty

\n \n Continue Shopping\n \n

\n ) : (\n

\n {cart.map(item => (\n

\n {/* Product Image */}\n {\n (e.target as HTMLImageElement).src = `data:image/svg+xml,`;\n }}\n />\n \n {/* Product Info */}\n

\n {item.product.name}\n

\n ${item.product.price.toFixed(2)} each\n

\n \n {/* Quantity Controls */}\n

\n onUpdateQuantity(item.product.id, item.quantity - 1)}\n className=\"w-6 h-6 rounded-full bg-gray-200 hover:bg-gray-300 flex items-center justify-center text-gray-600\"\n >\n \n \n \n \n {item.quantity}\n \n \n onUpdateQuantity(item.product.id, item.quantity + 1)}\n className=\"w-6 h-6 rounded-full bg-gray-200 hover:bg-gray-300 flex items-center justify-center text-gray-600\"\n >\n \n \n

\n \n {/* Item Total and Remove */}\n

\n ${(item.product.price * item.quantity).toFixed(2)}\n

\n onRemoveItem(item.product.id)}\n className=\"text-red-500 hover:text-red-700 text-sm mt-1\"\n >\n Remove\n \n

\n ))}\n

\n )}\n

\n\n {/* Footer */}\n {cart.length > 0 && (\n

\n {/* Total */}\n

\n Total:\n ${total.toFixed(2)}\n

\n \n {/* Checkout Button */}\n \n Proceed to Checkout\n \n \n {/* Continue Shopping */}\n \n Continue Shopping\n \n

\n )}\n

\n \n );\n}",[],[257,283,293],"9b8ea350-3f9c-11f0-ae57-76b3cceeab13","App.tsx","9b8ea422-3f9c-11f0-ae57-76b3cceeab13",11,["D",1748860230564],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport React, { useState, useEffect } from \"https://esm.sh/react@18.2.0\";\nimport type { Product, CartItem } from \"../../shared/types.ts\";\nimport ProductCard from \"./ProductCard.tsx\";\nimport Cart from \"./Cart.tsx\";\nimport OrderForm from \"./OrderForm.tsx\";\n\ninterface InitialData {\n products: Product[];\n categories: string[];\n}\n\nexport default function App() {\n const [products, setProducts] = useState([]);\n const [categories, setCategories] = useState([]);\n const [selectedCategory, setSelectedCategory] = useState(\"all\");\n const [cart, setCart] = useState([]);\n const [isCartOpen, setIsCartOpen] = useState(false);\n const [isCheckoutOpen, setIsCheckoutOpen] = useState(false);\n const [loading, setLoading] = useState(true);\n const [searchTerm, setSearchTerm] = useState(\"\");\n\n useEffect(() => {\n // Load initial data from window or fetch from API\n const initialData = (window as any).__INITIAL_DATA__ as InitialData;\n if (initialData) {\n setProducts(initialData.products);\n setCategories(initialData.categories);\n setLoading(false);\n } else {\n fetchProducts();\n }\n }, []);\n\n const fetchProducts = async () => {\n try {\n const response = await fetch(\"/api/products\");\n const result = await response.json();\n if (result.success) {\n setProducts(result.data);\n const uniqueCategories = [...new Set(result.data.map((p: Product) => p.category))];\n setCategories(uniqueCategories);\n }\n } catch (error) {\n console.error(\"Failed to fetch products:\", error);\n } finally {\n setLoading(false);\n }\n };\n\n const addToCart = (product: Product) => {\n setCart(prevCart => {\n const existingItem = prevCart.find(item => item.product.id === product.id);\n if (existingItem) {\n return prevCart.map(item =>\n item.product.id === product.id\n ? { ...item, quantity: item.quantity + 1 }\n : item\n );\n } else {\n return [...prevCart, { product, quantity: 1 }];\n }\n });\n };\n\n const updateCartQuantity = (productId: number, quantity: number) => {\n if (quantity <= 0) {\n removeFromCart(productId);\n return;\n }\n setCart(prevCart =>\n prevCart.map(item =>\n item.product.id === productId\n ? { ...item, quantity }\n : item\n )\n );\n };\n\n const removeFromCart = (productId: number) => {\n setCart(prevCart => prevCart.filter(item => item.product.id !== productId));\n };\n\n const clearCart = () => {\n setCart([]);\n };\n\n const getCartTotal = () => {\n return cart.reduce((total, item) => total + (item.product.price * item.quantity), 0);\n };\n\n const getCartItemCount = () => {\n return cart.reduce((total, item) => total + item.quantity, 0);\n };\n\n const filteredProducts = products.filter(product => {\n const matchesCategory = selectedCategory === \"all\" || product.category === selectedCategory;\n const matchesSearch = product.name.toLowerCase().includes(searchTerm.toLowerCase()) ||\n product.description.toLowerCase().includes(searchTerm.toLowerCase());\n return matchesCategory && matchesSearch && product.in_stock;\n });\n\n if (loading) {\n return (\n

Loading beautiful beaded bags...

\n );\n }\n\n return (\n

\n {/* Header */}\n

\n 👜 Beaded Bags Boutique\n

\n \n

\n setIsCartOpen(true)}\n className=\"relative p-2 text-gray-600 hover:text-purple-600 transition-colors\"\n >\n \n {getCartItemCount() > 0 && (\n \n {getCartItemCount()}\n \n )}\n \n

\n\n {/* Hero Section */}\n

\n Handcrafted Beaded Elegance\n

\n Discover our collection of unique, artisan-made beaded bags\n

\n document.getElementById('products')?.scrollIntoView()}\n className=\"bg-white text-purple-600 px-8 py-3 rounded-full font-semibold hover:bg-gray-100 transition-colors\"\n >\n Shop Now\n \n

\n\n {/* Filters and Search */}\n

\n {/* Search */}\n

\n setSearchTerm(e.target.value)}\n className=\"w-full md:w-64 pl-10 pr-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-purple-500 focus:border-transparent\"\n />\n \n

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

\n setSelectedCategory(\"all\")}\n className={`px-4 py-2 rounded-full text-sm font-medium transition-colors ${\n selectedCategory === \"all\"\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n All Categories\n \n {categories.map(category => (\n setSelectedCategory(category)}\n className={`px-4 py-2 rounded-full text-sm font-medium transition-colors ${\n selectedCategory === category\n ? \"bg-purple-600 text-white\"\n : \"bg-gray-200 text-gray-700 hover:bg-gray-300\"\n }`}\n >\n {category}\n \n ))}\n

\n\n {/* Products Grid */}\n

\n {filteredProducts.length === 0 ? (\n

No bags found matching your criteria.

\n ) : (\n

\n {filteredProducts.map(product => (\n \n ))}\n

\n )}\n

\n\n {/* Footer */}\n \n\n {/* Cart Sidebar */}\n setIsCartOpen(false)}\n cart={cart}\n onUpdateQuantity={updateCartQuantity}\n onRemoveItem={removeFromCart}\n onCheckout={() => {\n setIsCartOpen(false);\n setIsCheckoutOpen(true);\n }}\n total={getCartTotal()}\n />\n\n {/* Checkout Modal */}\n setIsCheckoutOpen(false)}\n cart={cart}\n total={getCartTotal()}\n onOrderComplete={() => {\n clearCart();\n setIsCheckoutOpen(false);\n }}\n />\n

\n );\n}",[],[257,283,301],"9b8ec164-3f9c-11f0-ae57-76b3cceeab13",["D",1748860230564],[216,217,218,219],[257,283],"74594f10-3f9c-11f0-b40a-76b3cceeab13",["D",1748860164784],[215,220,221,222],[257],["D",1748860336361],[],[18,93],"6987150e-3f9c-11f0-bd82-76b3cceeab13","static.ts","698715cc-3f9c-11f0-bd82-76b3cceeab13",7,["D",1748860146632],"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 { getAllProducts } from \"../database/queries.ts\";\n\nconst staticRoutes = new Hono();\n\n// Serve frontend files\nstaticRoutes.get(\"/frontend/*\", (c) => serveFile(c.req.path, import.meta.url));\nstaticRoutes.get(\"/shared/*\", (c) => serveFile(c.req.path, import.meta.url));\n\n// Serve main page with initial data\nstaticRoutes.get(\"/\", async (c) => {\n try {\n let html = await readFile(\"/frontend/index.html\", import.meta.url);\n \n // Inject initial product data to avoid extra round-trips\n const products = await getAllProducts();\n const categories = [...new Set(products.map(p => p.category))];\n \n const initialData = {\n products,\n categories\n };\n \n const dataScript = ``;\n \n html = html.replace(\"\", `${dataScript}`);\n return c.html(html);\n } catch (error) {\n return c.text(\"Error loading page\", 500);\n }\n});\n\nexport default staticRoutes;",[],[18,83,320],"58cd3252-3f9c-11f0-bed4-76b3cceeab13","products.ts","58cd332e-3f9c-11f0-bed4-76b3cceeab13",["D",1748860118565],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { getAllProducts, getProductById, getProductsByCategory, createProduct } from \"../database/queries.ts\";\nimport type { ApiResponse, Product } from \"../../shared/types.ts\";\n\nconst products = new Hono();\n\n// Get all products\nproducts.get(\"/\", async (c) => {\n try {\n const category = c.req.query(\"category\");\n let productList: Product[];\n \n if (category) {\n productList = await getProductsByCategory(category);\n } else {\n productList = await getAllProducts();\n }\n \n const response: ApiResponse = {\n success: true,\n data: productList\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch products\"\n };\n return c.json(response, 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 if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid product ID\"\n };\n return c.json(response, 400);\n }\n \n const product = await getProductById(id);\n if (!product) {\n const response: ApiResponse = {\n success: false,\n error: \"Product not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: product\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch product\"\n };\n return c.json(response, 500);\n }\n});\n\n// Create new product (admin endpoint)\nproducts.post(\"/\", async (c) => {\n try {\n const body = await c.req.json();\n const { name, description, price, image_url, category, in_stock = true } = body;\n \n if (!name || !description || !price || !image_url || !category) {\n const response: ApiResponse = {\n success: false,\n error: \"Missing required fields\"\n };\n return c.json(response, 400);\n }\n \n const productId = await createProduct({\n name,\n description,\n price: parseFloat(price),\n image_url,\n category,\n in_stock\n });\n \n const response: ApiResponse = {\n success: true,\n data: productId\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to create product\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get unique categories\nproducts.get(\"/categories/list\", async (c) => {\n try {\n const allProducts = await getAllProducts();\n const categories = [...new Set(allProducts.map(p => p.category))];\n \n const response: ApiResponse = {\n success: true,\n data: categories\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch categories\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default products;",[],[18,83,328],"6327cce4-3f9c-11f0-85eb-76b3cceeab13","orders.ts","6327cd70-3f9c-11f0-85eb-76b3cceeab13",6,["D",1748860135943],"import { Hono } from \"https://esm.sh/hono@3.11.7\";\nimport { createOrder, getAllOrders, getOrderById, updateOrderStatus } from \"../database/queries.ts\";\nimport type { ApiResponse, Order, CreateOrderRequest } from \"../../shared/types.ts\";\n\nconst orders = new Hono();\n\n// Create new order\norders.post(\"/\", async (c) => {\n try {\n const body: CreateOrderRequest = await c.req.json();\n const { customer_name, customer_email, customer_phone, shipping_address, items } = body;\n \n if (!customer_name || !customer_email || !shipping_address || !items || items.length === 0) {\n const response: ApiResponse = {\n success: false,\n error: \"Missing required fields or empty cart\"\n };\n return c.json(response, 400);\n }\n \n // Calculate total amount\n const total_amount = items.reduce((sum, item) => sum + (item.product.price * item.quantity), 0);\n \n const orderId = await createOrder({\n customer_name,\n customer_email,\n customer_phone: customer_phone || \"\",\n shipping_address,\n items,\n total_amount\n });\n \n const response: ApiResponse = {\n success: true,\n data: orderId\n };\n \n return c.json(response, 201);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to create order\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get all orders (admin endpoint)\norders.get(\"/\", async (c) => {\n try {\n const orderList = await getAllOrders();\n \n const response: ApiResponse = {\n success: true,\n data: orderList\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch orders\"\n };\n return c.json(response, 500);\n }\n});\n\n// Get order by ID\norders.get(\"/:id\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n if (isNaN(id)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid order ID\"\n };\n return c.json(response, 400);\n }\n \n const order = await getOrderById(id);\n if (!order) {\n const response: ApiResponse = {\n success: false,\n error: \"Order not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: order\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to fetch order\"\n };\n return c.json(response, 500);\n }\n});\n\n// Update order status (admin endpoint)\norders.patch(\"/:id/status\", async (c) => {\n try {\n const id = parseInt(c.req.param(\"id\"));\n const { status } = await c.req.json();\n \n if (isNaN(id) || !status) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid order ID or status\"\n };\n return c.json(response, 400);\n }\n \n const validStatuses = ['pending', 'processing', 'shipped', 'delivered', 'cancelled'];\n if (!validStatuses.includes(status)) {\n const response: ApiResponse = {\n success: false,\n error: \"Invalid status value\"\n };\n return c.json(response, 400);\n }\n \n const updated = await updateOrderStatus(id, status);\n if (!updated) {\n const response: ApiResponse = {\n success: false,\n error: \"Order not found\"\n };\n return c.json(response, 404);\n }\n \n const response: ApiResponse = {\n success: true,\n data: true\n };\n \n return c.json(response);\n } catch (error) {\n const response: ApiResponse = {\n success: false,\n error: \"Failed to update order status\"\n };\n return c.json(response, 500);\n }\n});\n\nexport default orders;",[],[18,83,335],["D",1748860118565],[210,211,212],[18,83],"503f97ec-3f9c-11f0-8bab-76b3cceeab13","queries.ts","503f9882-3f9c-11f0-8bab-76b3cceeab13",4,["D",1748860104221],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\nimport { PRODUCTS_TABLE, ORDERS_TABLE } from \"./migrations.ts\";\nimport type { Product, Order, CartItem } from \"../../shared/types.ts\";\n\n// Product queries\nexport async function getAllProducts(): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} ORDER BY created_at DESC`);\n return results.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n }));\n}\n\nexport async function getProductById(id: number): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} WHERE id = ?`, [id]);\n if (results.length === 0) return null;\n \n const row = results[0];\n return {\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n };\n}\n\nexport async function getProductsByCategory(category: string): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${PRODUCTS_TABLE} WHERE category = ? ORDER BY created_at DESC`, [category]);\n return results.map(row => ({\n id: row.id,\n name: row.name,\n description: row.description,\n price: row.price,\n image_url: row.image_url,\n category: row.category,\n in_stock: Boolean(row.in_stock),\n created_at: row.created_at\n }));\n}\n\nexport async function createProduct(product: Omit): Promise {\n const result = await sqlite.execute(\n `INSERT INTO ${PRODUCTS_TABLE} (name, description, price, image_url, category, in_stock) VALUES (?, ?, ?, ?, ?, ?)`,\n [product.name, product.description, product.price, product.image_url, product.category, product.in_stock ? 1 : 0]\n );\n return result.lastInsertRowid;\n}\n\n// Order queries\nexport async function createOrder(orderData: {\n customer_name: string;\n customer_email: string;\n customer_phone: string;\n shipping_address: string;\n items: CartItem[];\n total_amount: number;\n}): Promise {\n const itemsJson = JSON.stringify(orderData.items);\n \n const result = await sqlite.execute(\n `INSERT INTO ${ORDERS_TABLE} (customer_name, customer_email, customer_phone, shipping_address, items, total_amount) VALUES (?, ?, ?, ?, ?, ?)`,\n [\n orderData.customer_name,\n orderData.customer_email,\n orderData.customer_phone,\n orderData.shipping_address,\n itemsJson,\n orderData.total_amount\n ]\n );\n \n return result.lastInsertRowid;\n}\n\nexport async function getAllOrders(): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${ORDERS_TABLE} ORDER BY created_at DESC`);\n return results.map(row => ({\n id: row.id,\n customer_name: row.customer_name,\n customer_email: row.customer_email,\n customer_phone: row.customer_phone,\n shipping_address: row.shipping_address,\n items: JSON.parse(row.items),\n total_amount: row.total_amount,\n status: row.status,\n created_at: row.created_at\n }));\n}\n\nexport async function getOrderById(id: number): Promise {\n const results = await sqlite.execute(`SELECT * FROM ${ORDERS_TABLE} WHERE id = ?`, [id]);\n if (results.length === 0) return null;\n \n const row = results[0];\n return {\n id: row.id,\n customer_name: row.customer_name,\n customer_email: row.customer_email,\n customer_phone: row.customer_phone,\n shipping_address: row.shipping_address,\n items: JSON.parse(row.items),\n total_amount: row.total_amount,\n status: row.status,\n created_at: row.created_at\n };\n}\n\nexport async function updateOrderStatus(id: number, status: string): Promise {\n const result = await sqlite.execute(\n `UPDATE ${ORDERS_TABLE} SET status = ? WHERE id = ?`,\n [status, id]\n );\n return result.changes > 0;\n}",[],[18,67,346],"e213c81e-3f9c-11f0-bc48-76b3cceeab13","migrations.ts","4608a69c-3f9c-11f0-93d2-76b3cceeab13",["D",1748860348876],"import { sqlite } from \"https://esm.town/v/stevekrouse/sqlite\";\n\nconst PRODUCTS_TABLE = 'beaded_bags_products_v1';\nconst ORDERS_TABLE = 'beaded_bags_orders_v1';\n\nexport async function runMigrations() {\n // Create products table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PRODUCTS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n price REAL NOT NULL,\n image_url TEXT NOT NULL,\n category TEXT NOT NULL,\n in_stock BOOLEAN DEFAULT 1,\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Create orders table\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ORDERS_TABLE} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n customer_name TEXT NOT NULL,\n customer_email TEXT NOT NULL,\n customer_phone TEXT,\n shipping_address TEXT NOT NULL,\n items TEXT NOT NULL,\n total_amount REAL NOT NULL,\n status TEXT DEFAULT 'pending',\n created_at DATETIME DEFAULT CURRENT_TIMESTAMP\n )`);\n\n // Check if we need to seed sample data\n const existingProducts = await sqlite.execute(`SELECT COUNT(*) as count FROM ${PRODUCTS_TABLE}`);\n if (existingProducts && existingProducts.length > 0 && existingProducts[0].count === 0) {\n await seedSampleProducts();\n }\n}\n\nasync function seedSampleProducts() {\n const sampleProducts = [\n {\n name: \"Elegant Evening Clutch\",\n description: \"Handcrafted beaded clutch perfect for special occasions. Features intricate gold and silver beadwork with a secure magnetic closure.\",\n price: 89.99,\n image_url: \"https://maxm-imggenurl.web.val.run/elegant-beaded-evening-clutch-gold-silver-intricate-pattern\",\n category: \"Evening Bags\"\n },\n {\n name: \"Bohemian Crossbody Bag\",\n description: \"Colorful beaded crossbody bag with adjustable strap. Perfect for festivals and casual outings with vibrant turquoise and coral beads.\",\n price: 65.99,\n image_url: \"https://maxm-imggenurl.web.val.run/bohemian-beaded-crossbody-bag-colorful-turquoise-coral\",\n category: \"Crossbody Bags\"\n },\n {\n name: \"Vintage Pearl Handbag\",\n description: \"Classic handbag adorned with lustrous pearls and delicate beadwork. Timeless design with comfortable handles.\",\n price: 124.99,\n image_url: \"https://maxm-imggenurl.web.val.run/vintage-pearl-beaded-handbag-classic-elegant-white\",\n category: \"Handbags\"\n },\n {\n name: \"Tribal Pattern Tote\",\n description: \"Large tote bag featuring traditional tribal beadwork patterns. Spacious interior perfect for daily use.\",\n price: 78.99,\n image_url: \"https://maxm-imggenurl.web.val.run/tribal-pattern-beaded-tote-bag-traditional-geometric\",\n category: \"Tote Bags\"\n },\n {\n name: \"Floral Beaded Purse\",\n description: \"Delicate purse with beautiful floral beadwork in soft pastels. Features a chain strap and silk lining.\",\n price: 95.99,\n image_url: \"https://maxm-imggenurl.web.val.run/floral-beaded-purse-pastel-colors-chain-strap\",\n category: \"Purses\"\n },\n {\n name: \"Geometric Mini Bag\",\n description: \"Modern mini bag with bold geometric beaded patterns. Perfect statement piece for contemporary fashion.\",\n price: 55.99,\n image_url: \"https://maxm-imggenurl.web.val.run/geometric-beaded-mini-bag-modern-bold-patterns\",\n category: \"Mini Bags\"\n },\n {\n name: \"Sunset Gradient Clutch\",\n description: \"Stunning clutch with gradient beadwork mimicking a beautiful sunset. Orange, pink, and gold beads create a mesmerizing effect.\",\n price: 110.99,\n image_url: \"https://maxm-imggenurl.web.val.run/sunset-gradient-beaded-clutch-orange-pink-gold\",\n category: \"Evening Bags\"\n },\n {\n name: \"Ocean Wave Shoulder Bag\",\n description: \"Medium shoulder bag inspired by ocean waves. Blue and white beads create flowing wave patterns.\",\n price: 85.99,\n image_url: \"https://maxm-imggenurl.web.val.run/ocean-wave-beaded-shoulder-bag-blue-white-flowing\",\n category: \"Shoulder Bags\"\n }\n ];\n\n for (const product of sampleProducts) {\n await sqlite.execute(\n `INSERT INTO ${PRODUCTS_TABLE} (name, description, price, image_url, category) VALUES (?, ?, ?, ?, ?)`,\n [product.name, product.description, product.price, product.image_url, product.category]\n );\n }\n}\n\nexport { PRODUCTS_TABLE, ORDERS_TABLE };",[],[18,67,354],["D",1748860087081],[207,208],[18,67],["D",1748860087081],[206,209,213],[18],["D",1748859975748],{"_11":12,"_152":73},{"_11":12,"_148":-5,"_72":73,"_31":71,"_149":150,"_151":30},{"_42":139,"_13":16,"_36":39,"_140":106,"_141":-5,"_142":-5,"_143":-5,"_144":-5,"_145":-5,"_146":14,"_147":12},"ctx",{"_55":-5,"_171":403,"_404":405,"_406":407,"_408":30,"_409":30,"_410":30,"_411":24,"_412":-5,"_413":-7,"_414":-7,"_415":26,"_416":30,"_417":30,"_418":-5,"_419":30,"_420":30,"_421":30,"_422":-5},"ENV",{"_374":375,"_376":377,"_378":16,"_379":380,"_381":382,"_383":384,"_385":386,"_387":388,"_389":390,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402},"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"]

History · backend