🎉

Thank you!

\n Your order #{orderId} is confirmed.\n

\n\n {error &&

{error}

}\n\n {data && (\n

\n {data.items.map((it, i) => (\n

\n {it.name} × {it.quantity}\n {money(it.price_cents * it.quantity)}\n

\n ))}\n

\n Total paid\n {money(data.order.total_cents)}\n

\n A receipt was sent to {data.order.email}. Shipping to {data.order.name}.\n

\n )}\n\n \n Continue shopping\n \n

\n );\n}\n",[187,103,101],"bc9a4524-1131-4de2-aa3f-dae154274e82",["D",1780815759688],"import React, { useState } from \"https://esm.sh/react@18.2.0\";\nimport { money, type CartLine, type Product } from \"../store.ts\";\n\nexport function Checkout(\n { cart, products, stripeEnabled, onBack, onPaid }: {\n cart: CartLine[];\n products: Product[];\n stripeEnabled: boolean;\n onBack: () => void;\n onPaid: (orderId: string) => void;\n },\n) {\n const [name, setName] = useState(\"\");\n const [email, setEmail] = useState(\"\");\n const [address, setAddress] = useState(\"\");\n const [busy, setBusy] = useState(false);\n const [error, setError] = useState(\"\");\n\n const byId = new Map(products.map((p) => [p.id, p]));\n const lines = cart\n .map((l) => ({ line: l, product: byId.get(l.id) }))\n .filter((x) => x.product) as { line: CartLine; product: Product }[];\n const total = lines.reduce((s, x) => s + x.product.price_cents * x.line.quantity, 0);\n\n async function pay(e: React.FormEvent) {\n e.preventDefault();\n setBusy(true);\n setError(\"\");\n try {\n const res = await fetch(\"/api/checkout\", {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ cart, name, email, address }),\n });\n const data = await res.json();\n if (!res.ok) throw new Error(data.error || \"Checkout failed\");\n if (data.mode === \"stripe\") {\n window.location.href = data.checkoutUrl; // redirect to Stripe\n } else {\n onPaid(data.orderId);\n }\n } catch (err) {\n setError(err instanceof Error ? err.message : \"Something went wrong\");\n setBusy(false);\n }\n }\n\n return (\n

Shipping & contact

\n \n \n

\n Shipping address\n setAddress(e.target.value)}\n placeholder=\"123 Main St, Springfield, USA\"\n className=\"w-full rounded-lg border border-slate-200 px-3 py-2 outline-none focus:ring-2 focus:ring-indigo-500 h-24 resize-none\"\n />\n

\n\n {error &&

{error}

}\n\n

\n {stripeEnabled\n ? \"🔒 Secure payments by Stripe — you'll be redirected to enter card details.\"\n : \"🧪 Demo mode — no Stripe key set, so the payment is simulated. Add STRIPE_SECRET_KEY to go live.\"}\n

\n\n \n {busy ? \"Processing…\" : stripeEnabled ? `Pay ${money(total)} with card` : `Pay ${money(total)} (demo)`}\n \n \n \n\n

Order summary

\n {lines.map(({ line, product }) => (\n

\n {product.emoji}\n {product.name} × {line.quantity}\n {money(product.price_cents * line.quantity)}\n

\n ))}\n

\n Total\n {money(total)}\n

\n );\n}\n\nfunction Field(\n { label, value, onChange, placeholder, type = \"text\" }: {\n label: string;\n value: string;\n onChange: (v: string) => void;\n placeholder?: string;\n type?: string;\n },\n) {\n return (\n

\n {label}\n onChange(e.target.value)}\n className=\"w-full rounded-lg border border-slate-200 px-3 py-2 outline-none focus:ring-2 focus:ring-indigo-500\"\n />\n

\n );\n}\n",[187,103,92],"5c4529f9-a756-462b-840f-0e06a43a7235",["D",1780815728191],"import React from \"https://esm.sh/react@18.2.0\";\nimport { money, type Product } from \"../store.ts\";\n\nexport function Catalog(\n { products, onAdd }: { products: Product[]; onAdd: (id: number) => void },\n) {\n return (\n

\n Gear that just works\n

\n Thoughtfully designed everyday products. Free shipping over $100.\n

\n {products.map((p) => (\n \n

\n {p.emoji}\n

{p.name}

{p.description}

\n {money(p.price_cents)}\n onAdd(p.id)}\n className=\"px-4 py-2 rounded-lg bg-indigo-600 text-white text-sm font-semibold hover:bg-indigo-700 active:scale-95 transition\"\n >\n Add to cart\n \n

\n ))}\n

\n \n );\n}\n",[187,103,68],"d4beb8c1-5b61-4ac2-aa6c-c73d387abb68",["D",1780815739498],"import React from \"https://esm.sh/react@18.2.0\";\nimport { money, type CartLine, type Product } from \"../store.ts\";\n\nexport function Cart(\n { cart, products, setQty, remove, onCheckout, onContinue }: {\n cart: CartLine[];\n products: Product[];\n setQty: (id: number, q: number) => void;\n remove: (id: number) => void;\n onCheckout: () => void;\n onContinue: () => void;\n },\n) {\n const byId = new Map(products.map((p) => [p.id, p]));\n const lines = cart\n .map((l) => ({ line: l, product: byId.get(l.id) }))\n .filter((x) => x.product) as { line: CartLine; product: Product }[];\n const total = lines.reduce((s, x) => s + x.product.price_cents * x.line.quantity, 0);\n\n if (lines.length === 0) {\n return (\n

🛒

Your cart is empty

\n \n Browse products\n \n

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

Your cart

\n {lines.map(({ line, product }) => (\n

{product.emoji}

{product.name}

{money(product.price_cents)} each

\n setQty(product.id, line.quantity - 1)}\n className=\"w-8 h-8 rounded-md border border-slate-200 text-slate-600 hover:bg-slate-50\"\n >−\n {line.quantity}\n setQty(product.id, line.quantity + 1)}\n className=\"w-8 h-8 rounded-md border border-slate-200 text-slate-600 hover:bg-slate-50\"\n >+\n

\n {money(product.price_cents * line.quantity)}\n

\n remove(product.id)}\n className=\"text-slate-400 hover:text-red-500 ml-1\"\n title=\"Remove\"\n >✕\n

\n ))}\n

\n \n

Subtotal

{money(total)}

\n \n Proceed to checkout\n \n

\n );\n}\n",[187,103,83],"pulls","branches",1,"forks","envVars",{"_216":26,"_218":26},"connections",{"_216":26,"_217":26},"count","unfilledCount","emptyCount",{"_36":336,"_13":319,"_66":313,"_46":-5,"_38":39,"_181":331,"_182":24,"_40":337,"_42":26,"_69":104,"_184":-5,"_71":30,"_185":-5,"_240":338,"_17":339},{"_36":328,"_13":329,"_66":330,"_46":313,"_38":39,"_181":331,"_182":24,"_40":332,"_42":26,"_69":70,"_184":333,"_71":30,"_185":-5,"_240":334,"_17":335},{"_36":320,"_13":321,"_66":322,"_46":313,"_38":39,"_181":323,"_182":24,"_40":324,"_42":26,"_69":70,"_184":325,"_71":30,"_185":-5,"_240":326,"_17":327},{"_36":310,"_13":311,"_66":312,"_46":313,"_38":39,"_181":314,"_182":24,"_40":315,"_42":26,"_69":70,"_184":316,"_71":30,"_185":-5,"_240":317,"_17":318},{"_36":306,"_13":187,"_66":180,"_46":-5,"_38":39,"_181":278,"_182":24,"_40":307,"_42":26,"_69":104,"_184":-5,"_71":30,"_185":-5,"_240":308,"_17":309},{"_36":179,"_13":103,"_66":102,"_46":180,"_38":39,"_181":43,"_182":24,"_40":303,"_42":26,"_69":104,"_184":-5,"_71":30,"_185":-5,"_240":304,"_17":305},{"_36":204,"_13":83,"_66":82,"_46":102,"_38":39,"_181":77,"_182":24,"_40":300,"_42":26,"_69":70,"_184":206,"_71":30,"_185":-5,"_240":301,"_17":302},{"_36":200,"_13":68,"_66":67,"_46":102,"_38":39,"_181":43,"_182":24,"_40":297,"_42":26,"_69":70,"_184":202,"_71":30,"_185":-5,"_240":298,"_17":299},{"_36":196,"_13":92,"_66":91,"_46":102,"_38":39,"_181":86,"_182":24,"_40":294,"_42":26,"_69":70,"_184":198,"_71":30,"_185":-5,"_240":295,"_17":296},{"_36":192,"_13":101,"_66":100,"_46":102,"_38":39,"_181":95,"_182":24,"_40":291,"_42":26,"_69":70,"_184":194,"_71":30,"_185":-5,"_240":292,"_17":293},{"_36":283,"_13":284,"_66":285,"_46":180,"_38":39,"_181":286,"_182":24,"_40":287,"_42":26,"_69":70,"_184":288,"_71":30,"_185":-5,"_240":289,"_17":290},{"_36":275,"_13":276,"_66":277,"_46":180,"_38":39,"_181":278,"_182":24,"_40":279,"_42":26,"_69":21,"_184":280,"_71":30,"_185":-5,"_240":281,"_17":282},{"_36":267,"_13":268,"_66":269,"_46":180,"_38":39,"_181":270,"_182":24,"_40":271,"_42":26,"_69":70,"_184":272,"_71":30,"_185":-5,"_240":273,"_17":274},{"_36":259,"_13":260,"_66":261,"_46":180,"_38":39,"_181":262,"_182":24,"_40":263,"_42":26,"_69":70,"_184":264,"_71":30,"_185":-5,"_240":265,"_17":266},{"_36":251,"_13":252,"_66":253,"_46":-5,"_38":39,"_181":254,"_182":24,"_40":255,"_42":26,"_69":21,"_184":256,"_71":30,"_185":-5,"_240":257,"_17":258},{"_36":243,"_13":244,"_66":117,"_46":-5,"_38":39,"_181":245,"_182":24,"_40":246,"_42":210,"_69":247,"_184":248,"_71":30,"_185":-5,"_240":249,"_17":250},{"_36":236,"_13":237,"_66":238,"_46":-5,"_38":39,"_181":144,"_182":24,"_40":239,"_42":26,"_69":70,"_184":74,"_71":30,"_185":-5,"_240":241,"_17":242},"d3064572-6426-4660-a363-73d8e4578568","new-file-8581.ts","59f31392-623f-11f1-b892-1607ee4eb77e",["D",1780815965664],"children",[],[237],"65bdc85d-4c43-421b-86c6-4daa0fca084b","main.ts",7,["D",1780815707691],"http","// Entry point — delegates to the Hono app in backend/index.ts\nexport { default } from \"./backend/index.ts\";\n",[],[244],"dc6e9aa7-aa15-4468-ad29-2ef5e821e0f2","README.md","00f2de26-623f-11f1-be3d-1607ee4eb77e",16,["D",1780815816348],"# 🛍️ Nimbus Store\n\nA fully functional product-selling website with a shopping cart, checkout, order\nstorage, and **Stripe payments** — built on Val Town.\n\n## Features\n\n- **Product catalog** seeded into SQLite (8 demo products, easy to edit)\n- **Shopping cart** with quantities, persisted in the browser (`localStorage`)\n- **Checkout** with shipping/contact form and live order summary\n- **Payments** in two modes (auto-detected):\n - 🧪 **Demo mode** (default) — simulated instant payment, works out of the box\n - 🔒 **Live Stripe mode** — real card payments via Stripe Checkout, enabled\n the moment you set `STRIPE_SECRET_KEY`\n- **Orders** persisted to SQLite with line items, total, and status\n- **Confirmation page** that reads the order back from the server\n\n## Architecture\n\n```mermaid\nflowchart LR\n U[Browser · React SPA] -->|/api/products| S[Hono backend]\n U -->|/api/checkout| S\n U -->|/api/order/:id| S\n S --> DB[(SQLite)]\n S -->|live mode| Stripe[Stripe Checkout]\n Stripe -->|success_url| U\n```\n\n- `main.ts` — entry point, re-exports the backend\n- `backend/index.ts` — Hono app: API routes + serves the SPA\n- `backend/db.ts` — SQLite schema, product seed, order storage\n- `backend/payments.ts` — Stripe Checkout session helper\n- `frontend/` — React UI (Catalog, Cart, Checkout, Success) styled with Twind/Tailwind\n\n## Going live with real payments\n\n1. Create a Stripe account and grab your **Secret key** from\n (use a `sk_test_...` key to test first).\n2. Add it as an environment variable named `STRIPE_SECRET_KEY`:\n\n 👉 Add STRIPE_SECRET_KEY here: https://www.val.town/x/vegita/ugtest-clone/environment-variables?key=STRIPE_SECRET_KEY\n\n3. That's it — the checkout automatically switches from demo mode to real Stripe\n Checkout. Use Stripe's test card `4242 4242 4242 4242`, any future expiry, any CVC.\n\n## Editing products\n\nProducts live in the `SEED_PRODUCTS` array in `backend/db.ts`. To re-seed after\nchanging them, bump the `_v1` table-name suffix at the top of that file.\n",[],[252],"b00af8e0-5930-463a-b9a6-503e486b285e","store.ts","c6bb3b4a-623e-11f1-be3d-1607ee4eb77e",9,["D",1780815718674],"import { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\n\nexport interface Product {\n id: number;\n name: string;\n description: string;\n price_cents: number;\n emoji: string;\n stock: number;\n}\n\nexport interface CartLine { id: number; quantity: number }\n\nconst CART_KEY = \"nimbus_cart_v1\";\n\nexport function money(cents: number): string {\n return \"$\" + (cents / 100).toFixed(2);\n}\n\nfunction loadCart(): CartLine[] {\n try {\n return JSON.parse(localStorage.getItem(CART_KEY) || \"[]\");\n } catch {\n return [];\n }\n}\n\nexport function useCart() {\n const [cart, setCart] = useState(loadCart);\n\n useEffect(() => {\n localStorage.setItem(CART_KEY, JSON.stringify(cart));\n }, [cart]);\n\n function add(id: number) {\n setCart((c) => {\n const found = c.find((l) => l.id === id);\n if (found) return c.map((l) => (l.id === id ? { ...l, quantity: l.quantity + 1 } : l));\n return [...c, { id, quantity: 1 }];\n });\n }\n\n function setQty(id: number, quantity: number) {\n setCart((c) =>\n quantity <= 0\n ? c.filter((l) => l.id !== id)\n : c.map((l) => (l.id === id ? { ...l, quantity } : l))\n );\n }\n\n function remove(id: number) {\n setCart((c) => c.filter((l) => l.id !== id));\n }\n\n function clear() {\n setCart([]);\n }\n\n const count = cart.reduce((s, l) => s + l.quantity, 0);\n\n return { cart, add, setQty, remove, clear, count };\n}\n",[],[187,260],"3fa7abfa-29b0-449c-b4c2-75dff7e82e75","main.tsx","ed1afc08-623e-11f1-be3d-1607ee4eb77e",15,["D",1780815783059],"import React from \"https://esm.sh/react@18.2.0\";\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./App.tsx\";\n\ncreateRoot(document.getElementById(\"root\")!).render();\n",[],[187,268],"fce5d6c6-ea0f-4d8f-96cf-645d5bf641b1","index.html","c204835e-623e-11f1-91ac-1607ee4eb77e",8,["D",1780815710768],"\n\n\n \n \n Nimbus Store\n 🛍️\" />\n \n \n\n\n

\n \n\n\n",[],[187,276],"83ed44a2-6658-42e5-888f-b3d969e297d8","App.tsx","ec678876-623e-11f1-ad12-1607ee4eb77e",14,["D",1780815781883],"import React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { useCart, type Product } from \"./store.ts\";\nimport { Catalog } from \"./components/Catalog.tsx\";\nimport { Cart } from \"./components/Cart.tsx\";\nimport { Checkout } from \"./components/Checkout.tsx\";\nimport { Success } from \"./components/Success.tsx\";\n\ntype View = \"catalog\" | \"cart\" | \"checkout\" | \"success\";\n\nexport function App() {\n const [products, setProducts] = useState([]);\n const [stripeEnabled, setStripeEnabled] = useState(false);\n const [view, setView] = useState(\"catalog\");\n const [orderId, setOrderId] = useState(\"\");\n const [loading, setLoading] = useState(true);\n const cart = useCart();\n\n useEffect(() => {\n // If Stripe redirected back with ?order=..., show the success page.\n const params = new URLSearchParams(location.search);\n const returned = params.get(\"order\");\n if (location.pathname === \"/success\" && returned) {\n setOrderId(returned);\n setView(\"success\");\n cart.clear();\n history.replaceState({}, \"\", \"/\");\n }\n fetch(\"/api/products\")\n .then((r) => r.json())\n .then((d) => {\n setProducts(d.products || []);\n setStripeEnabled(!!d.stripeEnabled);\n })\n .finally(() => setLoading(false));\n }, []);\n\n function goPaid(id: string) {\n setOrderId(id);\n cart.clear();\n setView(\"success\");\n window.scrollTo(0, 0);\n }\n\n return (\n

\n \n setView(\"cart\")}\n className=\"relative px-3 py-2 rounded-lg hover:bg-slate-100 transition font-medium\"\n >\n 🛒 Cart\n {cart.count > 0 && (\n \n {cart.count}\n \n )}\n \n

\n\n

\n {loading\n ?

Loading store…

\n : view === \"catalog\"\n ? \n : view === \"cart\"\n ? (\n setView(\"checkout\")}\n onContinue={() => setView(\"catalog\")}\n />\n )\n : view === \"checkout\"\n ? (\n setView(\"cart\")}\n onPaid={goPaid}\n />\n )\n : setView(\"catalog\")} />}\n

\n\n \n

\n );\n}\n",[],[187,284],["D",1780815767681],[],[187,103,101],["D",1780815759688],[],[187,103,92],["D",1780815728191],[],[187,103,68],["D",1780815739498],[],[187,103,83],["D",1780815728191],[225,226,227,228],[187,103],"10d86610-bd46-4c82-8bd8-34529c0068cf",["D",1780815710768],[224,229,230,231,232],[187],"84e8a377-8d4b-4758-af4c-ca4fb1e65660","payments.ts","b2f5320a-623e-11f1-9da1-1607ee4eb77e","506ccb6a-4c69-42df-8c41-cfb898027497",5,["D",1780815685500],"// @ts-ignore\nimport Stripe from \"npm:stripe\";\nimport type { OrderItem } from \"./db.ts\";\n\nexport function stripeEnabled(): boolean {\n return !!Deno.env.get(\"STRIPE_SECRET_KEY\");\n}\n\nfunction getStripe() {\n const key = Deno.env.get(\"STRIPE_SECRET_KEY\");\n if (!key) throw new Error(\"STRIPE_SECRET_KEY is not set\");\n return new Stripe(key);\n}\n\n/**\n * Creates a Stripe Checkout Session and returns the hosted checkout URL.\n * The order id is attached as metadata so the success page can look it up.\n */\nexport async function createStripeCheckout(opts: {\n items: OrderItem[];\n orderId: string;\n email: string;\n origin: string;\n}): Promise {\n const stripe = getStripe();\n const session = await stripe.checkout.sessions.create({\n mode: \"payment\",\n customer_email: opts.email || undefined,\n line_items: opts.items.map((it) => ({\n quantity: it.quantity,\n price_data: {\n currency: \"usd\",\n unit_amount: it.price_cents,\n product_data: { name: it.name },\n },\n })),\n metadata: { orderId: opts.orderId },\n success_url: `${opts.origin}/success?order=${opts.orderId}`,\n cancel_url: `${opts.origin}/cart`,\n });\n if (!session.url) throw new Error(\"Stripe did not return a checkout URL\");\n return session.url;\n}\n",[],[319,311],"backend","c7970b29-d282-41b0-9d06-8388ffdc5c45","index.ts","bdd08eae-623e-11f1-952e-1607ee4eb77e",6,["D",1780815703718],"import { Hono } from \"npm:hono\";\nimport { readFile, parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport {\n createOrder,\n getOrder,\n getProducts,\n getProductsByIds,\n initDb,\n updateOrderStatus,\n type OrderItem,\n} from \"./db.ts\";\nimport { createStripeCheckout, stripeEnabled } from \"./payments.ts\";\n\nconst app = new Hono();\napp.onError((err, c) => {\n console.error(err);\n return c.json({ error: String(err) }, 500);\n});\n\n// ---- API ----\n\napp.get(\"/api/products\", async (c) => {\n const products = await getProducts();\n return c.json({ products, stripeEnabled: stripeEnabled() });\n});\n\ninterface CartLine { id: number; quantity: number }\n\n// Validate a cart against the DB and return priced order items + total.\nasync function priceCart(cart: CartLine[]): Promise<{ items: OrderItem[]; total: number }> {\n const ids = cart.map((l) => l.id);\n const products = await getProductsByIds(ids);\n const byId = new Map(products.map((p) => [p.id, p]));\n const items: OrderItem[] = [];\n for (const line of cart) {\n const p = byId.get(line.id);\n const qty = Math.max(1, Math.min(99, Math.floor(line.quantity)));\n if (!p) continue;\n items.push({ product_id: p.id, name: p.name, price_cents: p.price_cents, quantity: qty });\n }\n const total = items.reduce((s, it) => s + it.price_cents * it.quantity, 0);\n return { items, total };\n}\n\napp.post(\"/api/checkout\", async (c) => {\n const body = await c.req.json().catch(() => null) as\n | { cart: CartLine[]; email: string; name: string; address: string }\n | null;\n if (!body || !Array.isArray(body.cart) || body.cart.length === 0) {\n return c.json({ error: \"Cart is empty.\" }, 400);\n }\n if (!body.email || !body.name || !body.address) {\n return c.json({ error: \"Please fill in name, email, and address.\" }, 400);\n }\n\n const { items, total } = await priceCart(body.cart);\n if (items.length === 0) return c.json({ error: \"No valid items in cart.\" }, 400);\n\n const orderId = crypto.randomUUID().slice(0, 8).toUpperCase();\n const origin = new URL(c.req.url).origin;\n\n // Live Stripe path\n if (stripeEnabled()) {\n await createOrder(\n {\n id: orderId,\n email: body.email,\n name: body.name,\n address: body.address,\n total_cents: total,\n status: \"pending\",\n payment_method: \"stripe\",\n created_at: new Date().toISOString(),\n },\n items,\n );\n try {\n const url = await createStripeCheckout({ items, orderId, email: body.email, origin });\n return c.json({ mode: \"stripe\", checkoutUrl: url });\n } catch (err) {\n console.error(\"Stripe error\", err);\n return c.json({ error: \"Payment provider error. Please try again.\" }, 502);\n }\n }\n\n // Demo path — simulate an instant successful payment.\n await createOrder(\n {\n id: orderId,\n email: body.email,\n name: body.name,\n address: body.address,\n total_cents: total,\n status: \"paid\",\n payment_method: \"demo\",\n created_at: new Date().toISOString(),\n },\n items,\n );\n return c.json({ mode: \"demo\", orderId });\n});\n\napp.get(\"/api/order/:id\", async (c) => {\n const id = c.req.param(\"id\");\n const result = await getOrder(id);\n if (!result) return c.json({ error: \"Order not found\" }, 404);\n // If this was a Stripe order returning from checkout, mark it paid.\n if (result.order.status === \"pending\" && result.order.payment_method === \"stripe\") {\n await updateOrderStatus(id, \"paid\");\n result.order.status = \"paid\";\n }\n return c.json(result);\n});\n\n// ---- View source ----\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// ---- Static frontend ----\napp.get(\"/frontend/**/*\", (c) => serveFile(new URL(c.req.url).pathname, import.meta.url));\n\n// Serve the SPA shell for all page routes.\napp.get(\"*\", async (c) => {\n await initDb();\n const html = await readFile(\"/frontend/index.html\", import.meta.url);\n return c.html(html);\n});\n\nexport default app.fetch;\n",[],[319,321],"10615394-ef89-4d18-b7c0-1243a27e423a","db.ts","acff9b56-623e-11f1-9da1-1607ee4eb77e",4,["D",1780815675501],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\n// Bump this suffix to recreate tables on schema changes.\nconst PRODUCTS = \"store_products_v1\";\nconst ORDERS = \"store_orders_v1\";\nconst ORDER_ITEMS = \"store_order_items_v1\";\n\nexport interface Product {\n id: number;\n name: string;\n description: string;\n price_cents: number;\n emoji: string;\n stock: number;\n}\n\nexport interface OrderItem {\n product_id: number;\n name: string;\n price_cents: number;\n quantity: number;\n}\n\nexport interface Order {\n id: string;\n email: string;\n name: string;\n address: string;\n total_cents: number;\n status: string;\n payment_method: string;\n created_at: string;\n}\n\nconst SEED_PRODUCTS: Omit[] = [\n { name: \"Aurora Wireless Headphones\", description: \"Studio-grade sound with active noise cancelling and 40h battery.\", price_cents: 12900, emoji: \"🎧\", stock: 25 },\n { name: \"Nimbus Mechanical Keyboard\", description: \"Hot-swappable switches, RGB, and a satisfying tactile feel.\", price_cents: 8900, emoji: \"⌨️\", stock: 40 },\n { name: \"Pulse Smartwatch\", description: \"Heart-rate, GPS, sleep tracking, and a 7-day battery.\", price_cents: 19900, emoji: \"⌚\", stock: 18 },\n { name: \"Lumen Desk Lamp\", description: \"Adjustable warmth, touch dimming, and wireless charging base.\", price_cents: 5400, emoji: \"💡\", stock: 60 },\n { name: \"Drift Mechanical Pencil\", description: \"Precision-weighted aluminium body for effortless writing.\", price_cents: 2200, emoji: \"✏️\", stock: 120 },\n { name: \"Orbit Bluetooth Speaker\", description: \"360° sound, waterproof, and a punchy bass response.\", price_cents: 7600, emoji: \"🔊\", stock: 35 },\n { name: \"Verdant Plant Pot\", description: \"Self-watering ceramic pot with a minimalist matte finish.\", price_cents: 3100, emoji: \"🪴\", stock: 80 },\n { name: \"Atlas Travel Backpack\", description: \"Weatherproof 28L pack with a laptop sleeve and USB pass-through.\", price_cents: 9900, emoji: \"🎒\", stock: 22 },\n];\n\nlet initialized = false;\n\nexport async function initDb() {\n if (initialized) return;\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${PRODUCTS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n name TEXT NOT NULL,\n description TEXT NOT NULL,\n price_cents INTEGER NOT NULL,\n emoji TEXT NOT NULL,\n stock INTEGER NOT NULL DEFAULT 0\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ORDERS} (\n id TEXT PRIMARY KEY,\n email TEXT NOT NULL,\n name TEXT NOT NULL,\n address TEXT NOT NULL,\n total_cents INTEGER NOT NULL,\n status TEXT NOT NULL,\n payment_method TEXT NOT NULL,\n created_at TEXT NOT NULL\n )`);\n\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS ${ORDER_ITEMS} (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n order_id TEXT NOT NULL,\n product_id INTEGER NOT NULL,\n name TEXT NOT NULL,\n price_cents INTEGER NOT NULL,\n quantity INTEGER NOT NULL\n )`);\n\n const count = await sqlite.execute(`SELECT COUNT(*) AS c FROM ${PRODUCTS}`);\n if (Number(count.rows[0].c) === 0) {\n for (const p of SEED_PRODUCTS) {\n await sqlite.execute({\n sql: `INSERT INTO ${PRODUCTS} (name, description, price_cents, emoji, stock) VALUES (?, ?, ?, ?, ?)`,\n args: [p.name, p.description, p.price_cents, p.emoji, p.stock],\n });\n }\n }\n\n initialized = true;\n}\n\nexport async function getProducts(): Promise {\n await initDb();\n const res = await sqlite.execute(`SELECT * FROM ${PRODUCTS} ORDER BY id`);\n return res.rows as unknown as Product[];\n}\n\nexport async function getProductsByIds(ids: number[]): Promise {\n await initDb();\n if (ids.length === 0) return [];\n const placeholders = ids.map(() => \"?\").join(\",\");\n const res = await sqlite.execute({\n sql: `SELECT * FROM ${PRODUCTS} WHERE id IN (${placeholders})`,\n args: ids,\n });\n return res.rows as unknown as Product[];\n}\n\nexport async function createOrder(\n order: Order,\n items: OrderItem[],\n): Promise {\n await initDb();\n const stmts = [\n {\n sql: `INSERT INTO ${ORDERS} (id, email, name, address, total_cents, status, payment_method, created_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [order.id, order.email, order.name, order.address, order.total_cents, order.status, order.payment_method, order.created_at],\n },\n ...items.map((it) => ({\n sql: `INSERT INTO ${ORDER_ITEMS} (order_id, product_id, name, price_cents, quantity) VALUES (?, ?, ?, ?, ?)`,\n args: [order.id, it.product_id, it.name, it.price_cents, it.quantity],\n })),\n ];\n await sqlite.batch(stmts);\n}\n\nexport async function getOrder(id: string): Promise<{ order: Order; items: OrderItem[] } | null> {\n await initDb();\n const o = await sqlite.execute({ sql: `SELECT * FROM ${ORDERS} WHERE id = ?`, args: [id] });\n if (o.rows.length === 0) return null;\n const items = await sqlite.execute({ sql: `SELECT * FROM ${ORDER_ITEMS} WHERE order_id = ?`, args: [id] });\n return {\n order: o.rows[0] as unknown as Order,\n items: items.rows as unknown as OrderItem[],\n };\n}\n\nexport async function updateOrderStatus(id: string, status: string): Promise {\n await initDb();\n await sqlite.execute({ sql: `UPDATE ${ORDERS} SET status = ? WHERE id = ?`, args: [status, id] });\n}\n",[],[319,329],"fdf958f9-853d-4d9d-9cc9-a80cfa6feb98",["D",1780815675501],[220,221,222],[319],["D",1780815511978],["D",1789515055826],{"_11":12,"_157":74},{"_11":12,"_153":74,"_73":74,"_31":72,"_154":155,"_156":30},{"_42":144,"_13":16,"_36":39,"_145":106,"_146":-5,"_147":-5,"_148":-5,"_149":-5,"_150":-5,"_151":14,"_152":12},"ctx",{"_56":-5,"_176":378,"_379":380,"_381":382,"_383":30,"_384":30,"_385":30,"_386":24,"_387":-5,"_388":-7,"_389":-7,"_390":26,"_391":30,"_392":30,"_393":-5,"_394":30,"_395":30,"_396":30,"_397":-5},"ENV",{"_349":350,"_351":352,"_353":16,"_354":355,"_356":357,"_358":359,"_360":361,"_362":363,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","fdb67791413f4386b4dbf18f354029a617f6160f","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 · components