\n \n\n\n",[18,69],"83ed44a2-6658-42e5-888f-b3d969e297d8",["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",[18,104],"a801c42d-e3a2-4980-92d6-116ba75e0053",["D",1780815728191],[18,93],"pulls","branches",1,"forks","envVars",{"_228":26,"_230":26},"connections",{"_228":26,"_229":26},"count","unfilledCount","emptyCount",{"_37":346,"_13":329,"_67":323,"_47":-5,"_39":40,"_192":341,"_201":24,"_41":347,"_43":26,"_70":94,"_190":-5,"_71":30,"_193":-5,"_252":348,"_17":349},{"_37":338,"_13":339,"_67":340,"_47":323,"_39":40,"_192":341,"_201":24,"_41":342,"_43":26,"_70":84,"_190":343,"_71":30,"_193":-5,"_252":344,"_17":345},{"_37":330,"_13":331,"_67":332,"_47":323,"_39":40,"_192":333,"_201":24,"_41":334,"_43":26,"_70":84,"_190":335,"_71":30,"_193":-5,"_252":336,"_17":337},{"_37":320,"_13":321,"_67":322,"_47":323,"_39":40,"_192":324,"_201":24,"_41":325,"_43":26,"_70":84,"_190":326,"_71":30,"_193":-5,"_252":327,"_17":328},{"_37":189,"_13":18,"_67":114,"_47":-5,"_39":40,"_192":44,"_201":24,"_41":317,"_43":26,"_70":94,"_190":-5,"_71":30,"_193":-5,"_252":318,"_17":319},{"_37":217,"_13":93,"_67":92,"_47":114,"_39":40,"_192":87,"_201":24,"_41":314,"_43":26,"_70":94,"_190":-5,"_71":30,"_193":-5,"_252":315,"_17":316},{"_37":306,"_13":307,"_67":308,"_47":92,"_39":40,"_192":309,"_201":24,"_41":310,"_43":26,"_70":84,"_190":311,"_71":30,"_193":-5,"_252":312,"_17":313},{"_37":299,"_13":300,"_67":301,"_47":92,"_39":40,"_192":87,"_201":24,"_41":302,"_43":26,"_70":84,"_190":303,"_71":30,"_193":-5,"_252":304,"_17":305},{"_37":291,"_13":292,"_67":293,"_47":92,"_39":40,"_192":294,"_201":24,"_41":295,"_43":26,"_70":84,"_190":296,"_71":30,"_193":-5,"_252":297,"_17":298},{"_37":283,"_13":284,"_67":285,"_47":92,"_39":40,"_192":286,"_201":24,"_41":287,"_43":26,"_70":84,"_190":288,"_71":30,"_193":-5,"_252":289,"_17":290},{"_37":213,"_13":104,"_67":103,"_47":114,"_39":40,"_192":97,"_201":24,"_41":280,"_43":26,"_70":84,"_190":215,"_71":30,"_193":-5,"_252":281,"_17":282},{"_37":209,"_13":69,"_67":68,"_47":114,"_39":40,"_192":44,"_201":24,"_41":277,"_43":26,"_70":21,"_190":211,"_71":30,"_193":-5,"_252":278,"_17":279},{"_37":205,"_13":113,"_67":112,"_47":114,"_39":40,"_192":107,"_201":24,"_41":274,"_43":26,"_70":84,"_190":207,"_71":30,"_193":-5,"_252":275,"_17":276},{"_37":200,"_13":83,"_67":82,"_47":114,"_39":40,"_192":77,"_201":24,"_41":271,"_43":26,"_70":84,"_190":203,"_71":30,"_193":-5,"_252":272,"_17":273},{"_37":263,"_13":264,"_67":265,"_47":-5,"_39":40,"_192":266,"_201":24,"_41":267,"_43":26,"_70":21,"_190":268,"_71":30,"_193":-5,"_252":269,"_17":270},{"_37":255,"_13":256,"_67":127,"_47":-5,"_39":40,"_192":257,"_201":24,"_41":258,"_43":222,"_70":259,"_190":260,"_71":30,"_193":-5,"_252":261,"_17":262},{"_37":248,"_13":249,"_67":250,"_47":-5,"_39":40,"_192":154,"_201":24,"_41":251,"_43":26,"_70":84,"_190":74,"_71":30,"_193":-5,"_252":253,"_17":254},"d3064572-6426-4660-a363-73d8e4578568","new-file-8581.ts","59f31392-623f-11f1-b892-1607ee4eb77e",["D",1780815965664],"children",[],[249],"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",[],[256],"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",[],[264],["D",1780815718674],[],[18,83],["D",1780815783059],[],[18,113],["D",1780815710768],[],[18,69],["D",1780815781883],[],[18,104],"96bc0a70-0fce-4781-9d56-5ff58a4f3f95","Success.tsx","e3f4f70a-623e-11f1-91ac-1607ee4eb77e",13,["D",1780815767681],"import React, { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { money } from \"../store.ts\";\n\ninterface OrderData {\n order: { id: string; name: string; email: string; total_cents: number; status: string };\n items: { name: string; quantity: number; price_cents: number }[];\n}\n\nexport function Success({ orderId, onHome }: { orderId: string; onHome: () => void }) {\n const [data, setData] = useState(null);\n const [error, setError] = useState(\"\");\n\n useEffect(() => {\n fetch(`/api/order/${orderId}`)\n .then((r) => r.json())\n .then((d) => (d.error ? setError(d.error) : setData(d)))\n .catch(() => setError(\"Could not load your order.\"));\n }, [orderId]);\n\n return (\n

🎉

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",[],[18,93,284],"bc9a4524-1131-4de2-aa3f-dae154274e82","Checkout.tsx","df2d389a-623e-11f1-be3d-1607ee4eb77e",12,["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",[],[18,93,292],"5c4529f9-a756-462b-840f-0e06a43a7235","Catalog.tsx","cc6736f2-623e-11f1-be3d-1607ee4eb77e",["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",[],[18,93,300],"d4beb8c1-5b61-4ac2-aa6c-c73d387abb68","Cart.tsx","d3244e6c-623e-11f1-be3d-1607ee4eb77e",11,["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",[],[18,93,307],["D",1780815728191],[237,238,239,240],[18,93],["D",1780815710768],[236,241,242,243,244],[18],"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",[],[329,321],"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",[],[329,331],"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",[],[329,339],"fdf958f9-853d-4d9d-9cc9-a80cfa6feb98",["D",1780815675501],[232,233,234],[329],["D",1780815511978],["D",1789515055826],{"_11":12,"_167":74},{"_11":12,"_163":74,"_73":74,"_31":72,"_164":165,"_166":30},{"_43":154,"_13":16,"_37":40,"_155":116,"_156":-5,"_157":-5,"_158":-5,"_159":-5,"_160":-5,"_161":14,"_162":12},"ctx",{"_57":-5,"_186":388,"_389":390,"_391":392,"_393":30,"_394":30,"_395":30,"_396":24,"_397":-5,"_398":-7,"_399":-7,"_400":26,"_401":30,"_402":30,"_403":-5,"_404":30,"_405":30,"_406":30,"_407":-5},"ENV",{"_359":360,"_361":362,"_363":16,"_364":365,"_366":367,"_368":369,"_370":371,"_372":373,"_374":375,"_376":377,"_378":379,"_380":381,"_382":383,"_384":385,"_386":387},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","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 · frontend