[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_262":263,"_264":265},"routes/_app.x.$handle.$name",{"_105":104,"_37":50,"_113":95,"_32":107,"_13":14,"_114":-5,"_11":115,"_116":117,"_118":119,"_120":121,"_122":123,"_26":-5,"_124":-5,"_125":-5,"_126":30,"_127":128,"_129":64,"_130":-5,"_131":-5,"_132":133},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_48":49,"_37":50,"_43":51,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":76,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":88,"_89":90,"_91":92,"_93":30},"version",12,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","d21372a0-add4-4fe2-9c7f-03b4a2926ebc","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":14,"_46":47,"_29":30},"previous","deleted",false,"deletedHere","path","frontend/components/Checkout.tsx","latestPath","fileId","df2d389a-623e-11f1-be3d-1607ee4eb77e","name","Checkout.tsx","fileType","script","content","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","createdAt",["D",1780815759688],"branchVersion","branchId","2cca2436-c0f7-4a55-a173-b0da5f1e7f06","id","69ba23fc-3895-41fc-b166-fd26ca7e1e87","ugtest-clone",["D",1780815511978],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter website clone","imageUrl","619e6799-1eab-46cc-8a3f-1b12c112eae1","pinnedFileId","4f7ff14c-623e-11f1-886f-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019ea0df-68c9-773b-a42b-82cae65109db","tursoName","69ba23fc389541fcb166fd26ca7e1e87","tursoHostname","69ba23fc389541fcb166fd26ca7e1e87-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789515055826],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_105":104,"_112":107},"org",{"_105":104,"_106":107,"_108":107,"_19":60,"_109":110,"_111":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"isOwned",17,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vegita","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_48":49,"_37":50,"_43":257,"_52":-5,"_53":30,"_54":55,"_56":55,"_57":58,"_59":-5,"_19":60,"_61":62,"_63":64,"_65":-5,"_66":-5,"_67":68,"_69":70,"_71":72,"_73":74,"_75":258,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":259,"_89":260,"_91":261,"_93":30},"tree",[171,175,182],"files",[171,172,173,174,175,176,177,178,179,180,181,182],"counts",{"_161":68,"_162":143,"_163":68,"_164":165,"_166":167},"contents",[134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_48":155,"_37":156,"_35":157,"_139":-5,"_46":47,"_45":158,"_141":64,"_43":159,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":160},{"_48":148,"_37":149,"_35":150,"_139":-5,"_46":47,"_45":151,"_141":64,"_43":152,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_32":154},{"_48":137,"_37":138,"_35":62,"_139":-5,"_46":47,"_45":140,"_141":64,"_43":142,"_13":143,"_39":144,"_41":145,"_29":30,"_146":-5,"_32":147},"65bdc85d-4c43-421b-86c6-4daa0fca084b","main.ts","parentId",7,"latest",["D",1780815707691],1,"http","// Entry point — delegates to the Hono app in backend/index.ts\nexport { default } from \"./backend/index.ts\";\n","label",[138],"10d86610-bd46-4c82-8bd8-34529c0068cf","frontend","5318d48a-2ba2-470c-a728-73f2d21ad0cf",8,["D",1780815710768],"directory",[149],"fdf958f9-853d-4d9d-9cc9-a80cfa6feb98","backend","506ccb6a-4c69-42df-8c41-cfb898027497",4,["D",1780815675501],[156],"pulls","branches","forks","envVars",{"_168":68,"_170":68},"connections",{"_168":68,"_169":68},"count","unfilledCount","emptyCount",{"_48":155,"_37":156,"_35":157,"_139":-5,"_46":47,"_45":158,"_141":64,"_43":254,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_184":255,"_32":256},{"_48":247,"_37":248,"_35":249,"_139":157,"_46":47,"_45":158,"_141":64,"_43":250,"_13":68,"_39":40,"_41":251,"_29":30,"_146":-5,"_184":252,"_32":253},{"_48":239,"_37":240,"_35":241,"_139":157,"_46":47,"_45":242,"_141":64,"_43":243,"_13":68,"_39":40,"_41":244,"_29":30,"_146":-5,"_184":245,"_32":246},{"_48":231,"_37":232,"_35":233,"_139":157,"_46":47,"_45":234,"_141":64,"_43":235,"_13":68,"_39":40,"_41":236,"_29":30,"_146":-5,"_184":237,"_32":238},{"_48":148,"_37":149,"_35":150,"_139":-5,"_46":47,"_45":151,"_141":64,"_43":228,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_184":229,"_32":230},{"_48":224,"_37":207,"_35":203,"_139":150,"_46":47,"_45":211,"_141":64,"_43":225,"_13":68,"_39":153,"_41":-5,"_29":30,"_146":-5,"_184":226,"_32":227},{"_48":216,"_37":217,"_35":218,"_139":203,"_46":47,"_45":219,"_141":64,"_43":220,"_13":68,"_39":40,"_41":221,"_29":30,"_146":-5,"_184":222,"_32":223},{"_48":208,"_37":209,"_35":210,"_139":203,"_46":47,"_45":211,"_141":64,"_43":212,"_13":68,"_39":40,"_41":213,"_29":30,"_146":-5,"_184":214,"_32":215},{"_48":202,"_37":38,"_35":36,"_139":203,"_46":47,"_45":14,"_141":64,"_43":204,"_13":68,"_39":40,"_41":42,"_29":30,"_146":-5,"_184":205,"_32":206},{"_48":195,"_37":196,"_35":197,"_139":150,"_46":47,"_45":151,"_141":64,"_43":198,"_13":68,"_39":26,"_41":199,"_29":30,"_146":-5,"_184":200,"_32":201},{"_48":187,"_37":188,"_35":189,"_139":150,"_46":47,"_45":190,"_141":64,"_43":191,"_13":68,"_39":40,"_41":192,"_29":30,"_146":-5,"_184":193,"_32":194},{"_48":137,"_37":138,"_35":62,"_139":-5,"_46":47,"_45":140,"_141":64,"_43":183,"_13":143,"_39":144,"_41":145,"_29":30,"_146":-5,"_184":185,"_32":186},["D",1780815707691],"children",[],[138],"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",[],[149,188],"fce5d6c6-ea0f-4d8f-96cf-645d5bf641b1","index.html","c204835e-623e-11f1-91ac-1607ee4eb77e",["D",1780815710768],"\n\n\n \n \n Nimbus Store\n 🛍️\" />\n \n \n\n\n

\n \n\n\n",[],[149,196],"bc9a4524-1131-4de2-aa3f-dae154274e82","983dfad0-7db6-4154-8c76-02e43546023d",["D",1780815759688],[],[149,207,38],"components","5c4529f9-a756-462b-840f-0e06a43a7235","Catalog.tsx","cc6736f2-623e-11f1-be3d-1607ee4eb77e",10,["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",[],[149,207,209],"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",[],[149,207,217],"a801c42d-e3a2-4980-92d6-116ba75e0053",["D",1780815728191],[177,178,179],[149,207],["D",1780815710768],[176,180,181],[149],"84e8a377-8d4b-4758-af4c-ca4fb1e65660","payments.ts","b2f5320a-623e-11f1-9da1-1607ee4eb77e",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",[],[156,232],"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",[],[156,240],"10615394-ef89-4d18-b7c0-1243a27e423a","db.ts","acff9b56-623e-11f1-9da1-1607ee4eb77e",["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",[],[156,248],["D",1780815675501],[172,173,174],[156],["D",1780815511978],["D",1789515055826],{"_105":104,"_112":107},{"_105":104,"_106":107,"_108":107,"_19":60,"_109":110,"_111":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":-5,"_102":50,"_103":104},"ctx",{"_87":-5,"_131":295,"_296":297,"_298":299,"_300":30,"_301":30,"_302":30,"_303":64,"_304":-5,"_305":-7,"_306":-7,"_307":68,"_308":30,"_309":30,"_310":-5,"_311":30,"_312":30,"_313":30,"_314":-5},"ENV",{"_266":267,"_268":269,"_270":95,"_271":272,"_273":274,"_275":276,"_277":278,"_279":280,"_281":282,"_283":284,"_285":286,"_287":288,"_289":290,"_291":292,"_293":294},"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"]

Diff · v12