[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_382":383,"_384":385},"routes/_app.x.$handle.$name",{"_109":108,"_37":50,"_117":95,"_32":118,"_13":14,"_119":-5,"_11":120,"_121":122,"_123":124,"_125":126,"_127":128,"_26":-5,"_129":130,"_131":132,"_133":30,"_134":135,"_136":64,"_137":-5,"_138":-5,"_139":140},"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",17,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","ff1db7b4-3bbf-4162-827b-aae8849b61f1","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/contexts/AuthContext.tsx","latestPath","fileId","c9ddf5d4-55ea-11f1-a4f1-ee650bb23af1","name","AuthContext.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport {\n createContext,\n useCallback,\n useContext,\n useEffect,\n useState,\n} from \"https://esm.sh/react@18.2.0\";\nimport type { User } from \"../../shared/types.ts\";\nimport { api } from \"../api/client.ts\";\n\ninterface AuthState {\n user: User | null;\n loading: boolean;\n refresh: () => Promise;\n setRole: (role: \"customer\" | \"seller\" | \"admin\") => Promise;\n}\n\nconst AuthContext = createContext(null);\n\nexport function AuthProvider({ children }: { children: any }) {\n const [user, setUser] = useState(null);\n const [loading, setLoading] = useState(true);\n\n const refresh = useCallback(async () => {\n try {\n const { user } = await api.get<{ user: User | null }>(\"/api/session\");\n setUser(user);\n } catch {\n setUser(null);\n } finally {\n setLoading(false);\n }\n }, []);\n\n useEffect(() => {\n refresh();\n }, [refresh]);\n\n const setRole = useCallback(async (role: \"customer\" | \"seller\" | \"admin\") => {\n await api.post(\"/api/me/role\", { role });\n await refresh();\n }, [refresh]);\n\n return (\n \n {children}\n \n );\n}\n\nexport function useAuth(): AuthState {\n const ctx = useContext(AuthContext);\n if (!ctx) throw new Error(\"useAuth must be used within AuthProvider\");\n return ctx;\n}\n","createdAt",["D",1779460232247],"branchVersion","branchId","1153de52-55ea-11f1-9899-ee650bb23af1","id","114abd18-55ea-11f1-9899-ee650bb23af1","smart-gadgets-store",["D",1779459922585],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Starter template with client-side React & Hono server","imageUrl","4b701ef0-5af2-11f0-b0a0-21ea95346041","pinnedFileId","019e5013-9af2-7410-b348-21fb8edf74bc","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","4b701ef1-5af2-11f0-b0a0-21ea95346041","tursoName","114abd1855ea11f19899ee650bb23af1","tursoHostname","114abd1855ea11f19899ee650bb23af1-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789494036282],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_109":108,"_116":112},"org",{"_109":108,"_110":-5,"_111":112,"_19":60,"_113":114,"_115":30},"branch",{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"isOwned",39,"main","projectId","forkedBranchId","961078ea-f528-11ef-aa68-569c3dd06744","forkedBranchVersion",88,"forkedProjectPrivacy","forkedProjectId","96102714-f528-11ef-aa68-569c3dd06744","forkedProjectOrgId","019aa807-52c2-709c-928b-2029bae9a558","projectName","userHandle","COBRA","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoiZGVmYXVsdCIsImlpZCI6Imluc18yTm10cGhQUklwU0tqZHNiOHNnNGd2ZjJURFUiLCJyaWQiOiJ1c2VyXzJ6WDdqYXdodVpHVnBkN2pxakozbWM5M2tDNSJ9","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_48":49,"_37":50,"_43":377,"_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":378,"_77":-5,"_78":79,"_80":79,"_81":82,"_83":82,"_84":82,"_85":79,"_86":79,"_87":379,"_89":380,"_91":381,"_93":30},"tree",[202,206,222,224,225],"files",[202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219,220,221,222,223,224,225],"counts",{"_192":68,"_193":163,"_194":68,"_195":196,"_197":198},"contents",[152,153,154,155,156],"upstreamProject",{"_48":103,"_37":148,"_57":58,"_59":149,"_54":55,"_87":150},"upstreamBranch",{"_48":98,"_43":141,"_142":143,"_37":95,"_96":103,"_13":144,"_97":-5,"_99":-5,"_145":146,"_52":-5,"_93":30,"_54":55,"_107":147,"_69":105,"_106":148},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],"updatedAt",["D",1785420707976],91,"lockfileKey","1785420708123-esm.town_v_templates_react-hono-starter@91-main","templates","react-hono-starter","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789545599&sig=91cfcc631bd9f3dd8274549c04838d172adf2572755982193460d49bfd04bd62",{"_109":147,"_116":151},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789545599&sig=2316df07e67031dd48e537f6ce0c4c14b92716fed790ec83ecf27974cc65aa31",{"_48":186,"_37":187,"_35":188,"_159":-5,"_46":47,"_45":189,"_161":64,"_43":190,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":191},{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":184,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":185},{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":177,"_161":64,"_43":178,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_32":180},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":171,"_13":68,"_39":26,"_41":172,"_29":30,"_166":-5,"_32":173},{"_48":157,"_37":158,"_35":62,"_159":-5,"_46":47,"_45":160,"_161":64,"_43":162,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_32":167},"b0c7d83a-55ea-11f1-9ebd-ee650bb23af1","index.ts","parentId",8,"latest",["D",1779460190161],1,"http","// Main HTTP entrypoint — serves frontend + API + OAuth.\nimport { parseVal, serveFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { Hono } from \"npm:hono\";\nimport { HttpError, getCurrentUser, requireRole, requireUser } from \"./backend/auth.ts\";\nimport * as db from \"./backend/db.ts\";\nimport * as ai from \"./backend/ai.ts\";\n\nconst app = new Hono();\n\n// --- Error handling: turn HttpError into proper responses ---\napp.onError((err, c) => {\n if (err instanceof HttpError) {\n return c.json({ error: err.message }, err.status as 401 | 403 | 400);\n }\n // Re-throw so Val Town logs the full stack\n return Promise.reject(err);\n});\n\n// --- Frontend routes ---\napp.get(\"/\", () => serveFile(\"/frontend/index.html\"));\napp.get(\"/frontend/**/*\", (c) => serveFile(c.req.path));\napp.get(\"/favicon.ico\", () => serveFile(\"/frontend/favicon.svg\"));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// SPA fallback — let React Router handle client-side routes.\nconst spaPaths = [\n \"/products\",\n \"/products/*\",\n \"/cart\",\n \"/checkout\",\n \"/orders\",\n \"/orders/*\",\n \"/wishlist\",\n \"/dashboard\",\n \"/dashboard/*\",\n \"/seller\",\n \"/seller/*\",\n \"/admin\",\n \"/admin/*\",\n \"/ai\",\n \"/profile\",\n \"/compare\",\n];\nfor (const p of spaPaths) {\n app.get(p, () => serveFile(\"/frontend/index.html\"));\n}\n\n// =========================\n// API\n// =========================\n\n// --- Session ---\napp.get(\"/api/session\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n return c.json({ user, loggedIn: !!user });\n});\n\n// Switch role (demo helper — in production this would be admin-gated).\n// Allows the logged-in user to upgrade themselves to seller or admin so the\n// project is fully explorable end-to-end.\napp.post(\"/api/me/role\", async (c) => {\n const user = await requireUser(c.req.raw);\n const body = await c.req.json().catch(() => ({}));\n const role = body.role;\n if (![\"customer\", \"seller\", \"admin\"].includes(role)) {\n return c.json({ error: \"Invalid role\" }, 400);\n }\n await db.setUserRole(user.id, role);\n return c.json({ ok: true, role });\n});\n\n// --- Categories ---\napp.get(\"/api/categories\", async (c) => {\n const cats = await db.listCategories();\n return c.json(cats);\n});\n\n// --- Products ---\napp.get(\"/api/products\", async (c) => {\n const q = c.req.query();\n const products = await db.listProducts({\n search: q.search || undefined,\n category: q.category || undefined,\n minPrice: q.minPrice ? Number(q.minPrice) : undefined,\n maxPrice: q.maxPrice ? Number(q.maxPrice) : undefined,\n sort: (q.sort as never) || \"newest\",\n limit: q.limit ? Number(q.limit) : 60,\n offset: q.offset ? Number(q.offset) : 0,\n });\n return c.json(products);\n});\n\napp.get(\"/api/products/:slug\", async (c) => {\n const slug = c.req.param(\"slug\");\n const product = await db.getProductBySlug(slug);\n if (!product) return c.json({ error: \"Not found\" }, 404);\n // Track view\n const user = await getCurrentUser(c.req.raw);\n if (user) await db.trackView(user.id, product.id);\n const reviews = await db.listReviews(product.id);\n return c.json({ product, reviews });\n});\n\n// Compare two products\napp.get(\"/api/compare\", async (c) => {\n const a = Number(c.req.query(\"a\"));\n const b = Number(c.req.query(\"b\"));\n const [pa, pb] = await Promise.all([db.getProduct(a), db.getProduct(b)]);\n return c.json({ a: pa, b: pb });\n});\n\n// --- Cart ---\napp.get(\"/api/cart\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.getCart(user.id));\n});\n\napp.post(\"/api/cart\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { productId, quantity } = await c.req.json();\n if (!productId || !quantity) return c.json({ error: \"Bad request\" }, 400);\n await db.addToCart(user.id, Number(productId), Number(quantity));\n return c.json(await db.getCart(user.id));\n});\n\napp.patch(\"/api/cart/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n const id = Number(c.req.param(\"id\"));\n const { quantity } = await c.req.json();\n await db.updateCartItem(user.id, id, Number(quantity));\n return c.json(await db.getCart(user.id));\n});\n\napp.delete(\"/api/cart/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n await db.removeCartItem(user.id, Number(c.req.param(\"id\")));\n return c.json(await db.getCart(user.id));\n});\n\n// --- Wishlist ---\napp.get(\"/api/wishlist\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.getWishlist(user.id));\n});\n\napp.post(\"/api/wishlist/toggle\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { productId } = await c.req.json();\n const added = await db.toggleWishlist(user.id, Number(productId));\n return c.json({ added });\n});\n\n// --- Reviews ---\napp.post(\"/api/products/:id/reviews\", async (c) => {\n const user = await requireUser(c.req.raw);\n const productId = Number(c.req.param(\"id\"));\n const { rating, title, body } = await c.req.json();\n if (!rating || rating < 1 || rating > 5) {\n return c.json({ error: \"Invalid rating\" }, 400);\n }\n await db.upsertReview({\n product_id: productId,\n user_id: user.id,\n rating: Number(rating),\n title: title || null,\n body: body || null,\n });\n return c.json({ ok: true });\n});\n\n// --- Addresses ---\napp.get(\"/api/addresses\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listAddresses(user.id));\n});\n\napp.post(\"/api/addresses\", async (c) => {\n const user = await requireUser(c.req.raw);\n const body = await c.req.json();\n const a = await db.createAddress(user.id, {\n label: body.label || null,\n full_name: body.full_name,\n line1: body.line1,\n line2: body.line2 || null,\n city: body.city,\n state: body.state || null,\n postal_code: body.postal_code,\n country: body.country || \"IN\",\n phone: body.phone || null,\n is_default: body.is_default ? 1 : 0,\n });\n return c.json(a);\n});\n\napp.delete(\"/api/addresses/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n await db.deleteAddress(user.id, Number(c.req.param(\"id\")));\n return c.json({ ok: true });\n});\n\n// --- Orders / Checkout ---\napp.post(\"/api/checkout\", async (c) => {\n const user = await requireUser(c.req.raw);\n const { address } = await c.req.json();\n if (!address || !address.full_name || !address.line1) {\n return c.json({ error: \"Address required\" }, 400);\n }\n const order = await db.createOrder(user.id, address);\n return c.json(order);\n});\n\napp.get(\"/api/orders\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listUserOrders(user.id));\n});\n\napp.get(\"/api/orders/:id\", async (c) => {\n const user = await requireUser(c.req.raw);\n const order = await db.getOrder(Number(c.req.param(\"id\")), user.id);\n if (!order) return c.json({ error: \"Not found\" }, 404);\n return c.json(order);\n});\n\n// --- Recently viewed ---\napp.get(\"/api/recently-viewed\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listRecentlyViewed(user.id));\n});\n\n// --- AI Endpoints ---\napp.get(\"/api/ai/logs\", async (c) => {\n const user = await requireUser(c.req.raw);\n return c.json(await db.listUserAILogs(user.id));\n});\n\napp.post(\"/api/ai/recommend\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { interest } = await c.req.json();\n if (!interest) return c.json({ error: \"Interest required\" }, 400);\n const catalog = await db.listProducts({ limit: 40 });\n const recs = await ai.recommendGadgets(interest, catalog);\n // Hydrate with product objects\n const byId = new Map(catalog.map((p) => [p.id, p]));\n const enriched = recs\n .filter((r) => byId.has(r.productId))\n .map((r) => ({ ...r, product: byId.get(r.productId) }));\n await db.logAI(user?.id ?? null, \"recommend\", interest, JSON.stringify(recs));\n return c.json(enriched);\n});\n\napp.post(\"/api/ai/summarize/:id\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const id = Number(c.req.param(\"id\"));\n const product = await db.getProduct(id);\n if (!product) return c.json({ error: \"Not found\" }, 404);\n const summary = await ai.summarizeProduct(product);\n await db.logAI(user?.id ?? null, \"summary\", String(id), summary);\n return c.json({ summary });\n});\n\napp.post(\"/api/ai/compare\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { a, b } = await c.req.json();\n const [pa, pb] = await Promise.all([\n db.getProduct(Number(a)),\n db.getProduct(Number(b)),\n ]);\n if (!pa || !pb) return c.json({ error: \"Not found\" }, 404);\n const result = await ai.compareProducts(pa, pb);\n await db.logAI(user?.id ?? null, \"compare\", `${a} vs ${b}`, result);\n return c.json({ result });\n});\n\napp.post(\"/api/ai/chat\", async (c) => {\n const user = await getCurrentUser(c.req.raw);\n const { message, history } = await c.req.json();\n if (!message) return c.json({ error: \"Message required\" }, 400);\n const catalog = await db.listProducts({ limit: 20 });\n const reply = await ai.shoppingAssistant(message, history ?? [], catalog);\n await db.logAI(user?.id ?? null, \"chat\", message, reply);\n return c.json({ reply });\n});\n\napp.post(\"/api/ai/search-suggest\", async (c) => {\n const { query } = await c.req.json();\n const suggestions = await ai.searchSuggestions(query ?? \"\");\n return c.json({ suggestions });\n});\n\n// --- Seller routes ---\napp.get(\"/api/seller/products\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(\n await db.listProducts({\n sellerId: user.id,\n status: \"all\",\n limit: 200,\n }),\n );\n});\n\napp.post(\"/api/seller/products\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n const body = await c.req.json();\n if (!body.name || !body.price_cents || !body.category_id) {\n return c.json({ error: \"Missing required fields\" }, 400);\n }\n const p = await db.createProduct({\n seller_id: user.id,\n category_id: Number(body.category_id),\n name: body.name,\n brand: body.brand || null,\n description: body.description || null,\n price_cents: Number(body.price_cents),\n stock: Number(body.stock ?? 0),\n image_url: body.image_url || null,\n specs_json: body.specs_json || null,\n });\n return c.json(p);\n});\n\napp.patch(\"/api/seller/products/:id\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n const id = Number(c.req.param(\"id\"));\n const body = await c.req.json();\n const updated = await db.updateProduct(\n id,\n user.role === \"admin\" ? null : user.id,\n body,\n );\n return c.json(updated);\n});\n\napp.delete(\"/api/seller/products/:id\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n await db.deleteProduct(\n Number(c.req.param(\"id\")),\n user.role === \"admin\" ? null : user.id,\n );\n return c.json({ ok: true });\n});\n\napp.get(\"/api/seller/orders\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(await db.listSellerOrders(user.id));\n});\n\napp.get(\"/api/seller/analytics\", async (c) => {\n const user = await requireRole(c.req.raw, [\"seller\", \"admin\"]);\n return c.json(await db.sellerAnalytics(user.id));\n});\n\n// --- Admin routes ---\napp.get(\"/api/admin/analytics\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.adminAnalytics());\n});\n\napp.get(\"/api/admin/users\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listUsers());\n});\n\napp.patch(\"/api/admin/users/:id/role\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { role } = await c.req.json();\n await db.setUserRole(c.req.param(\"id\"), role);\n return c.json({ ok: true });\n});\n\napp.get(\"/api/admin/products\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listProducts({ status: \"all\", limit: 200 }));\n});\n\napp.patch(\"/api/admin/products/:id/status\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { status } = await c.req.json();\n const updated = await db.updateProduct(Number(c.req.param(\"id\")), null, {\n status,\n });\n return c.json(updated);\n});\n\napp.get(\"/api/admin/orders\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n return c.json(await db.listAllOrders());\n});\n\napp.patch(\"/api/admin/orders/:id/status\", async (c) => {\n await requireRole(c.req.raw, [\"admin\"]);\n const { status } = await c.req.json();\n await db.updateOrderStatus(Number(c.req.param(\"id\")), status);\n return c.json({ ok: true });\n});\n\n// Wrap with OAuth middleware (adds /auth/login, /auth/callback, /auth/logout)\nexport default oauthMiddleware(app.fetch);\n","label",[158],"11599612-55ea-11f1-9899-ee650bb23af1","README.md","019e5013-9af2-7410-b348-1d302973472a",["D",1779459922585],"# React + Hono Starter\n\nA minimal starter template for building client-side React apps with a Hono\nbackend on Val Town. Click **Remix** to get your own copy.\n\n**Want to build UI?** Start writing React components in\n[`frontend/components/`](/frontend/components/). Import them into `App.tsx` and\nyou're good to go. Styling is [Twind](https://twind.style/) — just use Tailwind\nutility classes, zero config.\n\n**Want to add an API?** Add routes in [`index.ts`](/index.ts) (there's a\ncommented-out example). Fetch them from your React components.\n\n## Architecture\n\n```mermaid\ngraph LR\n Browser -->|\"GET /\"| Hono[\"index.ts
(Hono server)\"]\n Hono -->|serves| HTML[\"index.html\"]\n HTML -->|loads| Entry[\"index.tsx\"]\n Entry -->|renders| App[\"App.tsx\"]\n App -->|renders| Counter[\"Counter.tsx\"]\n```\n\n## File structure\n\n```\nindex.ts ← Hono backend (serves frontend + API routes)\nfrontend/\n index.html ← HTML shell (loads Twind + React)\n index.tsx ← React entrypoint (mounts )\n favicon.svg ← App icon\n components/\n App.tsx ← Root component (layout + view source link)\n Counter.tsx ← Example component with state\n```\n\n## How it works\n\n1. **`index.ts`** is the HTTP entrypoint — a Hono server that serves the\n frontend and any API routes you add.\n2. **`frontend/index.html`** loads Twind and the React entrypoint.\n3. **`frontend/index.tsx`** mounts the React app.\n4. **`frontend/components/App.tsx`** is the root layout — add new components\n alongside it.\n5. **`frontend/components/Counter.tsx`** is an example stateful component —\n replace it with your own!\n\n## Next steps\n\n- Add API routes in `index.ts`\n- Add new components in `frontend/components/`\n- Add a SQLite database — see the\n [React Hono Example](https://www.val.town/x/stevekrouse/reactHonoExample) for\n a full-stack example with database, queries, and shared types",[169],"46e509ce-55ea-11f1-b10b-ee650bb23af1","shared","46e50aa0-55ea-11f1-b10b-ee650bb23af1",3,["D",1779460012519],"directory",[175],"115994c8-55ea-11f1-9899-ee650bb23af1","frontend","019e5013-9af2-7410-b348-192e420bc803",["D",1779459922585],[182],"46c2fe92-55ea-11f1-b10b-ee650bb23af1","backend","46c2ff50-55ea-11f1-b10b-ee650bb23af1",2,["D",1779460012296],[187],"pulls","branches","forks","envVars",{"_199":189,"_201":68},"connections",{"_199":68,"_200":68},"count","unfilledCount","emptyCount",{"_48":186,"_37":187,"_35":188,"_159":-5,"_46":47,"_45":189,"_161":64,"_43":374,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":375,"_32":376},{"_48":366,"_37":367,"_35":368,"_159":188,"_46":47,"_45":369,"_161":64,"_43":370,"_13":68,"_39":40,"_41":371,"_29":30,"_166":-5,"_227":372,"_32":373},{"_48":358,"_37":359,"_35":360,"_159":188,"_46":47,"_45":361,"_161":64,"_43":362,"_13":68,"_39":40,"_41":363,"_29":30,"_166":-5,"_227":364,"_32":365},{"_48":350,"_37":351,"_35":352,"_159":188,"_46":47,"_45":353,"_161":64,"_43":354,"_13":68,"_39":40,"_41":355,"_29":30,"_166":-5,"_227":356,"_32":357},{"_48":181,"_37":182,"_35":183,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":347,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":348,"_32":349},{"_48":342,"_37":341,"_35":335,"_159":183,"_46":47,"_45":343,"_161":64,"_43":344,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":345,"_32":346},{"_48":332,"_37":333,"_35":334,"_159":335,"_46":47,"_45":336,"_161":64,"_43":337,"_13":68,"_39":40,"_41":338,"_29":30,"_166":-5,"_227":339,"_32":340},{"_48":328,"_37":320,"_35":315,"_159":183,"_46":47,"_45":163,"_161":64,"_43":329,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":330,"_32":331},{"_48":321,"_37":322,"_35":323,"_159":315,"_46":47,"_45":163,"_161":64,"_43":324,"_13":68,"_39":40,"_41":325,"_29":30,"_166":-5,"_227":326,"_32":327},{"_48":312,"_37":313,"_35":314,"_159":315,"_46":47,"_45":163,"_161":64,"_43":316,"_13":68,"_39":40,"_41":317,"_29":30,"_166":-5,"_227":318,"_32":319},{"_48":307,"_37":306,"_35":302,"_159":183,"_46":47,"_45":308,"_161":64,"_43":309,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":310,"_32":311},{"_48":301,"_37":38,"_35":36,"_159":302,"_46":47,"_45":14,"_161":64,"_43":303,"_13":68,"_39":40,"_41":42,"_29":30,"_166":-5,"_227":304,"_32":305},{"_48":294,"_37":295,"_35":296,"_159":183,"_46":47,"_45":297,"_161":64,"_43":298,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":299,"_32":300},{"_48":287,"_37":288,"_35":289,"_159":183,"_46":47,"_45":290,"_161":64,"_43":291,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":292,"_32":293},{"_48":280,"_37":281,"_35":282,"_159":183,"_46":47,"_45":283,"_161":64,"_43":284,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":285,"_32":286},{"_48":275,"_37":274,"_35":268,"_159":183,"_46":47,"_45":276,"_161":64,"_43":277,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":278,"_32":279},{"_48":265,"_37":266,"_35":267,"_159":268,"_46":47,"_45":269,"_161":64,"_43":270,"_13":68,"_39":40,"_41":271,"_29":30,"_166":-5,"_227":272,"_32":273},{"_48":258,"_37":259,"_35":260,"_159":183,"_46":47,"_45":163,"_161":64,"_43":261,"_13":68,"_39":26,"_41":262,"_29":30,"_166":-5,"_227":263,"_32":264},{"_48":251,"_37":252,"_35":253,"_159":183,"_46":47,"_45":163,"_161":64,"_43":254,"_13":68,"_39":26,"_41":255,"_29":30,"_166":-5,"_227":256,"_32":257},{"_48":244,"_37":245,"_35":246,"_159":183,"_46":47,"_45":163,"_161":64,"_43":247,"_13":68,"_39":40,"_41":248,"_29":30,"_166":-5,"_227":249,"_32":250},{"_48":174,"_37":175,"_35":176,"_159":-5,"_46":47,"_45":177,"_161":64,"_43":241,"_13":68,"_39":179,"_41":-5,"_29":30,"_166":-5,"_227":242,"_32":243},{"_48":233,"_37":234,"_35":235,"_159":176,"_46":47,"_45":236,"_161":64,"_43":237,"_13":68,"_39":40,"_41":238,"_29":30,"_166":-5,"_227":239,"_32":240},{"_48":168,"_37":169,"_35":170,"_159":-5,"_46":47,"_45":163,"_161":64,"_43":230,"_13":68,"_39":26,"_41":172,"_29":30,"_166":-5,"_227":231,"_32":232},{"_48":157,"_37":158,"_35":62,"_159":-5,"_46":47,"_45":160,"_161":64,"_43":226,"_13":163,"_39":164,"_41":165,"_29":30,"_166":-5,"_227":228,"_32":229},["D",1779460190161],"children",[],[158],["D",1779459922585],[],[169],"4dad08e2-55ea-11f1-b10b-ee650bb23af1","types.ts","4dad09b4-55ea-11f1-b10b-ee650bb23af1",4,["D",1779460023898],"// Shared TypeScript types used by both frontend and backend.\n\nexport type Role = \"customer\" | \"seller\" | \"admin\";\n\nexport interface User {\n id: string;\n handle: string;\n display_name: string | null;\n avatar_url: string | null;\n role: Role;\n created_at: string;\n}\n\nexport interface Category {\n id: number;\n slug: string;\n name: string;\n icon: string | null;\n}\n\nexport interface Product {\n id: number;\n seller_id: string;\n category_id: number | null;\n name: string;\n slug: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n status: \"pending\" | \"approved\" | \"rejected\";\n avg_rating: number;\n review_count: number;\n created_at: string;\n // Joined fields (optional, populated by queries)\n category_name?: string;\n category_slug?: string;\n seller_handle?: string;\n seller_name?: string;\n}\n\nexport interface CartItem {\n id: number;\n user_id: string;\n product_id: number;\n quantity: number;\n // joined\n product?: Product;\n}\n\nexport interface WishlistItem {\n id: number;\n user_id: string;\n product_id: number;\n product?: Product;\n}\n\nexport interface Review {\n id: number;\n product_id: number;\n user_id: string;\n rating: number;\n title: string | null;\n body: string | null;\n created_at: string;\n user_handle?: string;\n user_name?: string;\n}\n\nexport interface Address {\n id: number;\n user_id: string;\n label: string | null;\n full_name: string;\n line1: string;\n line2: string | null;\n city: string;\n state: string | null;\n postal_code: string;\n country: string;\n phone: string | null;\n is_default: number;\n}\n\nexport interface OrderItem {\n id: number;\n order_id: number;\n product_id: number;\n seller_id: string;\n quantity: number;\n unit_price_cents: number;\n product_snapshot_json: string | null;\n product?: Product;\n}\n\nexport interface Order {\n id: number;\n user_id: string;\n total_cents: number;\n status: \"pending\" | \"paid\" | \"shipped\" | \"delivered\" | \"cancelled\";\n address_json: string;\n created_at: string;\n items?: OrderItem[];\n}\n\nexport interface SessionInfo {\n user: User | null;\n loggedIn: boolean;\n}\n\nexport interface AIRecommendation {\n productId: number;\n reason: string;\n}\n",[],[175,234],["D",1779460012519],[223],[175],"1159913a-55ea-11f1-9899-ee650bb23af1","index.tsx","019e5013-9af2-7410-b348-145eb1a119fb",["D",1779459922585],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { createRoot } from \"https://esm.sh/react-dom@18.2.0/client\";\nimport { App } from \"./components/App.tsx\";\n\nconst root = document.getElementById(\"root\");\nif (!root) {\n throw new Error(\"No root element found\");\n}\n\ncreateRoot(root).render();",[],[182,245],"11598ca8-55ea-11f1-9899-ee650bb23af1","index.html","019e5013-9af2-7410-b348-10ee0c72fc8c",["D",1779459922585],"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[],[182,252],"11598834-55ea-11f1-9899-ee650bb23af1","favicon.svg","019e5013-9af2-7410-b348-0d76706a1ef9",["D",1779459922585],"\n",[],[182,259],"c488c9e2-55ea-11f1-a4f1-ee650bb23af1","format.ts","c488cab4-55ea-11f1-a4f1-ee650bb23af1","ba17f064-55ea-11f1-8cff-ee650bb23af1",16,["D",1779460223300],"// Formatting helpers (price, dates, etc.).\n\nexport function formatPrice(cents: number): string {\n const rupees = cents / 100;\n return new Intl.NumberFormat(\"en-IN\", {\n style: \"currency\",\n currency: \"INR\",\n maximumFractionDigits: 0,\n }).format(rupees);\n}\n\nexport function formatDate(iso: string): string {\n try {\n return new Date(iso).toLocaleDateString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n year: \"numeric\",\n });\n } catch {\n return iso;\n }\n}\n\nexport function formatDateTime(iso: string): string {\n try {\n return new Date(iso).toLocaleString(\"en-US\", {\n month: \"short\",\n day: \"numeric\",\n hour: \"numeric\",\n minute: \"2-digit\",\n });\n } catch {\n return iso;\n }\n}\n\nexport function parseSpecs(json: string | null): Record {\n if (!json) return {};\n try {\n return JSON.parse(json);\n } catch {\n return {};\n }\n}\n",[],[182,274,266],"utils","ba17ef9c-55ea-11f1-8cff-ee650bb23af1",14,["D",1779460205795],[218],[182,274],"b827d526-55ea-11f1-a8d0-ee650bb23af1","pages","b827d5c6-55ea-11f1-a8d0-ee650bb23af1",9,["D",1779460202532],[],[182,281],"b9b7a6aa-55ea-11f1-8cff-ee650bb23af1","layouts","b9b7a768-55ea-11f1-8cff-ee650bb23af1",13,["D",1779460205163],[],[182,288],"b917a434-55ea-11f1-a4f1-ee650bb23af1","hooks","b917a4f2-55ea-11f1-a4f1-ee650bb23af1",11,["D",1779460204113],[],[182,295],"c9ddf52a-55ea-11f1-a4f1-ee650bb23af1","b877d198-55ea-11f1-a4f1-ee650bb23af1",["D",1779460232247],[],[182,306,38],"contexts","b877d09e-55ea-11f1-a4f1-ee650bb23af1",10,["D",1779460203060],[213],[182,306],"11597e0c-55ea-11f1-9899-ee650bb23af1","Counter.tsx","019e5013-9af2-7410-b348-0417e0c0ad1c","019e5013-9af2-7410-b348-081fa6ae7764",["D",1779459922585],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\n\nexport function Counter() {\n const [count, setCount] = useState(0);\n return (\n

\n Clicked\n setCount((c) => c + 1)}\n class=\"bg-blue-500 hover:bg-blue-600 text-white font-medium px-4 py-2 rounded-lg transition-colors cursor-pointer\"\n >\n {count}\n \n times\n

\n );\n}\n",[],[182,320,313],"components","11595e04-55ea-11f1-9899-ee650bb23af1","App.tsx","019e5013-9af2-7410-b348-01a6c13d4f00",["D",1779459922585],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { Counter } from \"./Counter.tsx\";\n\nexport function App() {\n return (\n

React + Hono Starter

\n \n

\n View source\n

\n );\n}\n",[],[182,320,322],"11598596-55ea-11f1-9899-ee650bb23af1",["D",1779459922585],[210,211],[182,320],"c1d73364-55ea-11f1-a8d0-ee650bb23af1","client.ts","c1d73422-55ea-11f1-a8d0-ee650bb23af1","b96dca9e-55ea-11f1-a8d0-ee650bb23af1",15,["D",1779460218789],"// Typed fetch wrapper for the API.\n\nasync function request(\n path: string,\n options: RequestInit = {},\n): Promise {\n const res = await fetch(path, {\n ...options,\n headers: {\n \"Content-Type\": \"application/json\",\n ...(options.headers ?? {}),\n },\n });\n const text = await res.text();\n let data: unknown = null;\n try {\n data = text ? JSON.parse(text) : null;\n } catch {\n data = text;\n }\n if (!res.ok) {\n const message = (data as { error?: string })?.error ?? `HTTP ${res.status}`;\n throw new ApiError(res.status, message);\n }\n return data as T;\n}\n\nexport class ApiError extends Error {\n constructor(public status: number, message: string) {\n super(message);\n }\n}\n\nexport const api = {\n get: (path: string) => request(path),\n post: (path: string, body?: unknown) =>\n request(path, { method: \"POST\", body: JSON.stringify(body ?? {}) }),\n patch: (path: string, body?: unknown) =>\n request(path, { method: \"PATCH\", body: JSON.stringify(body ?? {}) }),\n del: (path: string) => request(path, { method: \"DELETE\" }),\n};\n",[],[182,341,333],"api","b96dc9cc-55ea-11f1-a8d0-ee650bb23af1",12,["D",1779460204674],[208],[182,341],["D",1779459922585],[207,209,212,214,215,216,217,219,220,221],[182],"7c6c1290-55ea-11f1-972f-ee650bb23af1","db.ts","7c6c1358-55ea-11f1-972f-ee650bb23af1",5,["D",1779460102303],"// Project-scoped SQLite helpers. All queries go through here.\nimport { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport type {\n Address,\n CartItem,\n Category,\n Order,\n OrderItem,\n Product,\n Review,\n User,\n} from \"../shared/types.ts\";\n\ntype Row = Record;\n\n// --- Users ---\n\nexport async function getUser(id: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM users WHERE id = ?\",\n args: [id],\n });\n return (r.rows[0] as User | undefined) ?? null;\n}\n\nexport async function upsertUser(u: {\n id: string;\n handle: string;\n display_name?: string | null;\n avatar_url?: string | null;\n}): Promise {\n const existing = await getUser(u.id);\n if (existing) {\n await sqlite.execute({\n sql: \"UPDATE users SET handle = ?, display_name = ?, avatar_url = ? WHERE id = ?\",\n args: [u.handle, u.display_name ?? null, u.avatar_url ?? null, u.id],\n });\n return (await getUser(u.id))!;\n }\n await sqlite.execute({\n sql:\n \"INSERT INTO users (id, handle, display_name, avatar_url, role) VALUES (?, ?, ?, ?, 'customer')\",\n args: [u.id, u.handle, u.display_name ?? null, u.avatar_url ?? null],\n });\n return (await getUser(u.id))!;\n}\n\nexport async function setUserRole(\n id: string,\n role: \"customer\" | \"seller\" | \"admin\",\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE users SET role = ? WHERE id = ?\",\n args: [role, id],\n });\n}\n\nexport async function listUsers(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM users ORDER BY created_at DESC\",\n );\n return r.rows as unknown as User[];\n}\n\n// --- Categories ---\n\nexport async function listCategories(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM categories ORDER BY name ASC\",\n );\n return r.rows as unknown as Category[];\n}\n\n// --- Products ---\n\nconst PRODUCT_SELECT = `\n SELECT p.*,\n c.name AS category_name,\n c.slug AS category_slug,\n u.handle AS seller_handle,\n u.display_name AS seller_name\n FROM products p\n LEFT JOIN categories c ON c.id = p.category_id\n LEFT JOIN users u ON u.id = p.seller_id\n`;\n\nexport interface ProductQuery {\n search?: string;\n category?: string;\n minPrice?: number;\n maxPrice?: number;\n sort?: \"newest\" | \"price_asc\" | \"price_desc\" | \"rating\";\n status?: \"pending\" | \"approved\" | \"rejected\" | \"all\";\n sellerId?: string;\n limit?: number;\n offset?: number;\n}\n\nexport async function listProducts(q: ProductQuery = {}): Promise {\n const where: string[] = [];\n const args: unknown[] = [];\n if (q.status && q.status !== \"all\") {\n where.push(\"p.status = ?\");\n args.push(q.status);\n } else if (!q.status) {\n where.push(\"p.status = 'approved'\");\n }\n if (q.search) {\n where.push(\"(p.name LIKE ? OR p.brand LIKE ? OR p.description LIKE ?)\");\n const term = `%${q.search}%`;\n args.push(term, term, term);\n }\n if (q.category) {\n where.push(\"c.slug = ?\");\n args.push(q.category);\n }\n if (q.minPrice != null) {\n where.push(\"p.price_cents >= ?\");\n args.push(q.minPrice);\n }\n if (q.maxPrice != null) {\n where.push(\"p.price_cents <= ?\");\n args.push(q.maxPrice);\n }\n if (q.sellerId) {\n where.push(\"p.seller_id = ?\");\n args.push(q.sellerId);\n }\n\n let order = \"p.created_at DESC\";\n if (q.sort === \"price_asc\") order = \"p.price_cents ASC\";\n else if (q.sort === \"price_desc\") order = \"p.price_cents DESC\";\n else if (q.sort === \"rating\") order = \"p.avg_rating DESC, p.review_count DESC\";\n\n const limit = Math.min(q.limit ?? 100, 200);\n const offset = q.offset ?? 0;\n\n const sql = `${PRODUCT_SELECT} ${\n where.length ? \"WHERE \" + where.join(\" AND \") : \"\"\n } ORDER BY ${order} LIMIT ? OFFSET ?`;\n args.push(limit, offset);\n\n const r = await sqlite.execute({ sql, args });\n return r.rows as unknown as Product[];\n}\n\nexport async function getProduct(id: number): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT} WHERE p.id = ?`,\n args: [id],\n });\n return (r.rows[0] as Product | undefined) ?? null;\n}\n\nexport async function getProductBySlug(slug: string): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT} WHERE p.slug = ?`,\n args: [slug],\n });\n return (r.rows[0] as Product | undefined) ?? null;\n}\n\nexport async function createProduct(p: {\n seller_id: string;\n category_id: number;\n name: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n}): Promise {\n const slug = p.name\n .toLowerCase()\n .replace(/[^a-z0-9]+/g, \"-\")\n .replace(/^-+|-+$/g, \"\") +\n \"-\" +\n Math.random().toString(36).slice(2, 6);\n const r = await sqlite.execute({\n sql:\n \"INSERT INTO products (seller_id, category_id, name, slug, brand, description, price_cents, stock, image_url, specs_json, status) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'pending')\",\n args: [\n p.seller_id,\n p.category_id,\n p.name,\n slug,\n p.brand,\n p.description,\n p.price_cents,\n p.stock,\n p.image_url,\n p.specs_json,\n ],\n });\n return (await getProduct(Number(r.lastInsertRowid)))!;\n}\n\nexport async function updateProduct(\n id: number,\n sellerId: string | null,\n patch: Partial<{\n name: string;\n brand: string | null;\n description: string | null;\n price_cents: number;\n stock: number;\n image_url: string | null;\n specs_json: string | null;\n category_id: number;\n status: \"pending\" | \"approved\" | \"rejected\";\n }>,\n): Promise {\n const fields: string[] = [];\n const args: unknown[] = [];\n for (const [k, v] of Object.entries(patch)) {\n fields.push(`${k} = ?`);\n args.push(v);\n }\n if (!fields.length) return getProduct(id);\n let sql = `UPDATE products SET ${fields.join(\", \")} WHERE id = ?`;\n args.push(id);\n if (sellerId) {\n sql += \" AND seller_id = ?\";\n args.push(sellerId);\n }\n await sqlite.execute({ sql, args });\n return getProduct(id);\n}\n\nexport async function deleteProduct(\n id: number,\n sellerId: string | null,\n): Promise {\n if (sellerId) {\n await sqlite.execute({\n sql: \"DELETE FROM products WHERE id = ? AND seller_id = ?\",\n args: [id, sellerId],\n });\n } else {\n await sqlite.execute({\n sql: \"DELETE FROM products WHERE id = ?\",\n args: [id],\n });\n }\n}\n\n// --- Cart ---\n\nexport async function getCart(userId: string): Promise {\n const r = await sqlite.execute({\n sql: `SELECT ci.*, p.name AS p_name, p.slug AS p_slug, p.price_cents AS p_price_cents,\n p.image_url AS p_image_url, p.stock AS p_stock, p.brand AS p_brand\n FROM cart_items ci\n JOIN products p ON p.id = ci.product_id\n WHERE ci.user_id = ?\n ORDER BY ci.created_at DESC`,\n args: [userId],\n });\n return (r.rows as Row[]).map((row) => ({\n id: row.id as number,\n user_id: row.user_id as string,\n product_id: row.product_id as number,\n quantity: row.quantity as number,\n product: {\n id: row.product_id as number,\n name: row.p_name as string,\n slug: row.p_slug as string,\n price_cents: row.p_price_cents as number,\n image_url: (row.p_image_url as string) ?? null,\n stock: row.p_stock as number,\n brand: (row.p_brand as string) ?? null,\n } as Product,\n }));\n}\n\nexport async function addToCart(\n userId: string,\n productId: number,\n quantity: number,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO cart_items (user_id, product_id, quantity) VALUES (?, ?, ?)\n ON CONFLICT(user_id, product_id) DO UPDATE SET quantity = quantity + excluded.quantity`,\n args: [userId, productId, quantity],\n });\n}\n\nexport async function updateCartItem(\n userId: string,\n itemId: number,\n quantity: number,\n): Promise {\n if (quantity <= 0) {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE id = ? AND user_id = ?\",\n args: [itemId, userId],\n });\n } else {\n await sqlite.execute({\n sql: \"UPDATE cart_items SET quantity = ? WHERE id = ? AND user_id = ?\",\n args: [quantity, itemId, userId],\n });\n }\n}\n\nexport async function removeCartItem(\n userId: string,\n itemId: number,\n): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE id = ? AND user_id = ?\",\n args: [itemId, userId],\n });\n}\n\nexport async function clearCart(userId: string): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM cart_items WHERE user_id = ?\",\n args: [userId],\n });\n}\n\n// --- Wishlist ---\n\nexport async function getWishlist(userId: string) {\n const r = await sqlite.execute({\n sql: `SELECT w.id, w.user_id, w.product_id, p.*\n FROM wishlists w\n JOIN products p ON p.id = w.product_id\n WHERE w.user_id = ?\n ORDER BY w.created_at DESC`,\n args: [userId],\n });\n return r.rows as unknown as (Product & { user_id: string })[];\n}\n\nexport async function toggleWishlist(\n userId: string,\n productId: number,\n): Promise {\n const existing = await sqlite.execute({\n sql: \"SELECT id FROM wishlists WHERE user_id = ? AND product_id = ?\",\n args: [userId, productId],\n });\n if (existing.rows.length) {\n await sqlite.execute({\n sql: \"DELETE FROM wishlists WHERE user_id = ? AND product_id = ?\",\n args: [userId, productId],\n });\n return false;\n }\n await sqlite.execute({\n sql: \"INSERT INTO wishlists (user_id, product_id) VALUES (?, ?)\",\n args: [userId, productId],\n });\n return true;\n}\n\n// --- Reviews ---\n\nexport async function listReviews(productId: number): Promise {\n const r = await sqlite.execute({\n sql: `SELECT r.*, u.handle AS user_handle, u.display_name AS user_name\n FROM reviews r\n JOIN users u ON u.id = r.user_id\n WHERE r.product_id = ?\n ORDER BY r.created_at DESC`,\n args: [productId],\n });\n return r.rows as unknown as Review[];\n}\n\nexport async function upsertReview(r: {\n product_id: number;\n user_id: string;\n rating: number;\n title: string | null;\n body: string | null;\n}): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO reviews (product_id, user_id, rating, title, body) VALUES (?, ?, ?, ?, ?)\n ON CONFLICT(product_id, user_id) DO UPDATE SET rating=excluded.rating, title=excluded.title, body=excluded.body`,\n args: [r.product_id, r.user_id, r.rating, r.title, r.body],\n });\n await recomputeProductRating(r.product_id);\n}\n\nasync function recomputeProductRating(productId: number): Promise {\n const r = await sqlite.execute({\n sql:\n \"SELECT AVG(rating) AS avg, COUNT(*) AS cnt FROM reviews WHERE product_id = ?\",\n args: [productId],\n });\n const row = r.rows[0] as { avg: number | null; cnt: number };\n await sqlite.execute({\n sql:\n \"UPDATE products SET avg_rating = ?, review_count = ? WHERE id = ?\",\n args: [row.avg ?? 0, row.cnt ?? 0, productId],\n });\n}\n\n// --- Addresses ---\n\nexport async function listAddresses(userId: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM addresses WHERE user_id = ? ORDER BY is_default DESC, id DESC\",\n args: [userId],\n });\n return r.rows as unknown as Address[];\n}\n\nexport async function createAddress(\n userId: string,\n a: Omit,\n): Promise

{\n if (a.is_default) {\n await sqlite.execute({\n sql: \"UPDATE addresses SET is_default = 0 WHERE user_id = ?\",\n args: [userId],\n });\n }\n const r = await sqlite.execute({\n sql:\n \"INSERT INTO addresses (user_id, label, full_name, line1, line2, city, state, postal_code, country, phone, is_default) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)\",\n args: [\n userId,\n a.label,\n a.full_name,\n a.line1,\n a.line2,\n a.city,\n a.state,\n a.postal_code,\n a.country,\n a.phone,\n a.is_default ? 1 : 0,\n ],\n });\n const created = await sqlite.execute({\n sql: \"SELECT * FROM addresses WHERE id = ?\",\n args: [Number(r.lastInsertRowid)],\n });\n return created.rows[0] as unknown as Address;\n}\n\nexport async function deleteAddress(\n userId: string,\n addressId: number,\n): Promise {\n await sqlite.execute({\n sql: \"DELETE FROM addresses WHERE id = ? AND user_id = ?\",\n args: [addressId, userId],\n });\n}\n\n// --- Orders ---\n\nexport async function createOrder(\n userId: string,\n address: Record,\n): Promise {\n const cart = await getCart(userId);\n if (!cart.length) throw new Error(\"Cart is empty\");\n\n // Verify stock\n for (const item of cart) {\n if (!item.product || item.product.stock < item.quantity) {\n throw new Error(`Insufficient stock for ${item.product?.name}`);\n }\n }\n\n const total = cart.reduce(\n (sum, it) => sum + (it.product?.price_cents ?? 0) * it.quantity,\n 0,\n );\n\n const orderResult = await sqlite.execute({\n sql:\n \"INSERT INTO orders (user_id, total_cents, status, address_json) VALUES (?, ?, 'paid', ?)\",\n args: [userId, total, JSON.stringify(address)],\n });\n const orderId = Number(orderResult.lastInsertRowid);\n\n // Insert items + decrement stock\n for (const item of cart) {\n const p = item.product!;\n await sqlite.execute({\n sql:\n \"INSERT INTO order_items (order_id, product_id, seller_id, quantity, unit_price_cents, product_snapshot_json) VALUES (?, ?, (SELECT seller_id FROM products WHERE id = ?), ?, ?, ?)\",\n args: [\n orderId,\n p.id,\n p.id,\n item.quantity,\n p.price_cents,\n JSON.stringify(p),\n ],\n });\n await sqlite.execute({\n sql: \"UPDATE products SET stock = stock - ? WHERE id = ?\",\n args: [item.quantity, p.id],\n });\n }\n\n await clearCart(userId);\n return (await getOrder(orderId, userId))!;\n}\n\nexport async function getOrder(\n orderId: number,\n userId: string | null,\n): Promise {\n const sql = userId\n ? \"SELECT * FROM orders WHERE id = ? AND user_id = ?\"\n : \"SELECT * FROM orders WHERE id = ?\";\n const args = userId ? [orderId, userId] : [orderId];\n const r = await sqlite.execute({ sql, args });\n const order = r.rows[0] as Order | undefined;\n if (!order) return null;\n const items = await sqlite.execute({\n sql: \"SELECT * FROM order_items WHERE order_id = ?\",\n args: [orderId],\n });\n order.items = items.rows as unknown as OrderItem[];\n return order;\n}\n\nexport async function listUserOrders(userId: string): Promise {\n const r = await sqlite.execute({\n sql: \"SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC\",\n args: [userId],\n });\n return r.rows as unknown as Order[];\n}\n\nexport async function listSellerOrders(sellerId: string): Promise {\n const r = await sqlite.execute({\n sql: `SELECT DISTINCT o.* FROM orders o\n JOIN order_items oi ON oi.order_id = o.id\n WHERE oi.seller_id = ?\n ORDER BY o.created_at DESC`,\n args: [sellerId],\n });\n const orders = r.rows as unknown as Order[];\n for (const o of orders) {\n const items = await sqlite.execute({\n sql: \"SELECT * FROM order_items WHERE order_id = ? AND seller_id = ?\",\n args: [o.id, sellerId],\n });\n o.items = items.rows as unknown as OrderItem[];\n }\n return orders;\n}\n\nexport async function listAllOrders(): Promise {\n const r = await sqlite.execute(\n \"SELECT * FROM orders ORDER BY created_at DESC LIMIT 200\",\n );\n return r.rows as unknown as Order[];\n}\n\nexport async function updateOrderStatus(\n orderId: number,\n status: Order[\"status\"],\n): Promise {\n await sqlite.execute({\n sql: \"UPDATE orders SET status = ? WHERE id = ?\",\n args: [status, orderId],\n });\n}\n\n// --- Recently viewed ---\n\nexport async function trackView(\n userId: string,\n productId: number,\n): Promise {\n await sqlite.execute({\n sql:\n `INSERT INTO recently_viewed (user_id, product_id) VALUES (?, ?)\n ON CONFLICT(user_id, product_id) DO UPDATE SET viewed_at = CURRENT_TIMESTAMP`,\n args: [userId, productId],\n });\n}\n\nexport async function listRecentlyViewed(userId: string): Promise {\n const r = await sqlite.execute({\n sql: `${PRODUCT_SELECT}\n JOIN recently_viewed rv ON rv.product_id = p.id\n WHERE rv.user_id = ?\n ORDER BY rv.viewed_at DESC\n LIMIT 12`,\n args: [userId],\n });\n return r.rows as unknown as Product[];\n}\n\n// --- Analytics ---\n\nexport async function adminAnalytics() {\n const [users, products, orders, revenue, topProducts, recentOrders] =\n await Promise.all([\n sqlite.execute(\n \"SELECT role, COUNT(*) AS n FROM users GROUP BY role\",\n ),\n sqlite.execute(\n \"SELECT status, COUNT(*) AS n FROM products GROUP BY status\",\n ),\n sqlite.execute(\"SELECT COUNT(*) AS n FROM orders\"),\n sqlite.execute(\n \"SELECT COALESCE(SUM(total_cents),0) AS revenue FROM orders WHERE status != 'cancelled'\",\n ),\n sqlite.execute(\n `SELECT p.id, p.name, p.image_url, SUM(oi.quantity) AS units, SUM(oi.unit_price_cents * oi.quantity) AS revenue\n FROM order_items oi\n JOIN products p ON p.id = oi.product_id\n GROUP BY p.id\n ORDER BY units DESC\n LIMIT 5`,\n ),\n sqlite.execute(\n `SELECT DATE(created_at) AS day, COUNT(*) AS orders, SUM(total_cents) AS revenue\n FROM orders\n GROUP BY DATE(created_at)\n ORDER BY day DESC\n LIMIT 14`,\n ),\n ]);\n return {\n userCounts: users.rows,\n productCounts: products.rows,\n orderCount: (orders.rows[0] as { n: number }).n,\n revenueCents: (revenue.rows[0] as { revenue: number }).revenue,\n topProducts: topProducts.rows,\n dailyOrders: recentOrders.rows,\n };\n}\n\nexport async function sellerAnalytics(sellerId: string) {\n const [products, orders, revenue, top] = await Promise.all([\n sqlite.execute({\n sql: \"SELECT COUNT(*) AS n FROM products WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n \"SELECT COUNT(DISTINCT order_id) AS n FROM order_items WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n \"SELECT COALESCE(SUM(unit_price_cents * quantity),0) AS revenue FROM order_items WHERE seller_id = ?\",\n args: [sellerId],\n }),\n sqlite.execute({\n sql:\n `SELECT p.id, p.name, p.image_url, SUM(oi.quantity) AS units, SUM(oi.unit_price_cents * oi.quantity) AS revenue\n FROM order_items oi\n JOIN products p ON p.id = oi.product_id\n WHERE oi.seller_id = ?\n GROUP BY p.id\n ORDER BY units DESC\n LIMIT 5`,\n args: [sellerId],\n }),\n ]);\n return {\n productCount: (products.rows[0] as { n: number }).n,\n orderCount: (orders.rows[0] as { n: number }).n,\n revenueCents: (revenue.rows[0] as { revenue: number }).revenue,\n topProducts: top.rows,\n };\n}\n\n// --- AI Logs ---\n\nexport async function logAI(\n userId: string | null,\n kind: string,\n prompt: string,\n response: string,\n): Promise {\n await sqlite.execute({\n sql:\n \"INSERT INTO ai_logs (user_id, kind, prompt, response) VALUES (?, ?, ?, ?)\",\n args: [userId, kind, prompt, response],\n });\n}\n\nexport async function listUserAILogs(userId: string) {\n const r = await sqlite.execute({\n sql:\n \"SELECT id, kind, prompt, response, created_at FROM ai_logs WHERE user_id = ? ORDER BY id DESC LIMIT 30\",\n args: [userId],\n });\n return r.rows;\n}\n",[],[187,351],"915117fa-55ea-11f1-bdf4-ee650bb23af1","auth.ts","915118b8-55ea-11f1-bdf4-ee650bb23af1",7,["D",1779460137352],"// Auth helpers: read OAuth session, sync to local users table, enforce roles.\nimport { getOAuthUserData } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { getUser, upsertUser } from \"./db.ts\";\nimport type { User } from \"../shared/types.ts\";\n\nexport async function getCurrentUser(req: Request): Promise {\n const session = await getOAuthUserData(req);\n if (!session?.user) return null;\n const handle = session.user.username || `user-${session.user.id.slice(0, 6)}`;\n // Upsert into local users table so we have role + linkable data.\n const u = await upsertUser({\n id: session.user.id,\n handle,\n display_name: session.user.username,\n avatar_url: session.user.links?.profileImageUrl ?? null,\n });\n return u;\n}\n\nexport async function requireUser(req: Request): Promise {\n const u = await getCurrentUser(req);\n if (!u) throw new HttpError(401, \"Login required\");\n return u;\n}\n\nexport async function requireRole(\n req: Request,\n roles: (\"customer\" | \"seller\" | \"admin\")[],\n): Promise {\n const u = await requireUser(req);\n if (!roles.includes(u.role)) {\n throw new HttpError(403, `Requires role: ${roles.join(\" or \")}`);\n }\n return u;\n}\n\nexport class HttpError extends Error {\n constructor(public status: number, message: string) {\n super(message);\n }\n}\n\nexport { getUser };\n",[],[187,359],"8d071e10-55ea-11f1-b744-ee650bb23af1","ai.ts","8d071eec-55ea-11f1-b744-ee650bb23af1",6,["D",1779460130185],"// Gemini AI service — all calls happen server-side; the API key never leaves the server.\nimport type { Product } from \"../shared/types.ts\";\n\nconst MODEL = \"gemini-2.0-flash\";\nconst ENDPOINT =\n `https://generativelanguage.googleapis.com/v1beta/models/${MODEL}:generateContent`;\n\nfunction getKey(): string {\n const k = Deno.env.get(\"GEMINI_API_KEY\");\n if (!k || k === \"REPLACE_WITH_YOUR_GEMINI_API_KEY\") {\n throw new Error(\n \"GEMINI_API_KEY is not set. Add it in the val's Environment Variables.\",\n );\n }\n return k;\n}\n\nasync function callGemini(\n prompt: string,\n opts: { json?: boolean; system?: string } = {},\n): Promise {\n const key = getKey();\n const body: Record = {\n contents: [{ role: \"user\", parts: [{ text: prompt }] }],\n generationConfig: {\n temperature: 0.7,\n maxOutputTokens: 1024,\n ...(opts.json ? { responseMimeType: \"application/json\" } : {}),\n },\n };\n if (opts.system) {\n body.systemInstruction = { parts: [{ text: opts.system }] };\n }\n const res = await fetch(`${ENDPOINT}?key=${key}`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n });\n if (!res.ok) {\n const text = await res.text();\n throw new Error(`Gemini API error ${res.status}: ${text.slice(0, 200)}`);\n }\n const data = await res.json();\n const text = data?.candidates?.[0]?.content?.parts?.[0]?.text;\n if (typeof text !== \"string\") {\n throw new Error(\"Gemini returned no text\");\n }\n return text;\n}\n\nfunction productSummary(p: Product): string {\n return `#${p.id} ${p.brand ?? \"\"} ${p.name} — ₹${\n (p.price_cents / 100).toFixed(0)\n } — ${(p.description ?? \"\").slice(0, 140)}`;\n}\n\n// --- 1. Smart recommendations based on user interests + catalog ---\n\nexport async function recommendGadgets(\n interest: string,\n catalog: Product[],\n): Promise<{ productId: number; reason: string }[]> {\n const lines = catalog.slice(0, 40).map(productSummary).join(\"\\n\");\n const prompt = `User interest: \"${interest}\"\n\nCatalog:\n${lines}\n\nPick the 4 most relevant products and explain WHY each fits the user's interest.\nReturn ONLY JSON array with this exact shape:\n[{\"productId\": number, \"reason\": \"one sentence reason\"}]`;\n const text = await callGemini(prompt, { json: true });\n try {\n const parsed = JSON.parse(text);\n if (Array.isArray(parsed)) return parsed.slice(0, 4);\n } catch {\n // try to extract JSON from text\n const m = text.match(/\\[[\\s\\S]*\\]/);\n if (m) return JSON.parse(m[0]).slice(0, 4);\n }\n return [];\n}\n\n// --- 2. Product summary ---\n\nexport async function summarizeProduct(p: Product): Promise {\n const prompt =\n `Write a clear, friendly 3-sentence summary of this gadget for a shopper. Highlight what makes it special and who would love it. Avoid marketing fluff.\n\nProduct: ${p.brand} ${p.name}\nPrice: ₹${(p.price_cents / 100).toFixed(0)}\nDescription: ${p.description ?? \"\"}\nSpecs: ${p.specs_json ?? \"n/a\"}`;\n return await callGemini(prompt);\n}\n\n// --- 3. Smart comparison ---\n\nexport async function compareProducts(a: Product, b: Product): Promise {\n const prompt = `Compare these two gadgets honestly. Use markdown with:\n- A short verdict (which is better for whom)\n- A bullet list of key differences\n- One recommendation paragraph\n\nProduct A: ${a.brand} ${a.name} — ₹${(a.price_cents / 100).toFixed(0)}\n${a.description}\nSpecs: ${a.specs_json}\n\nProduct B: ${b.brand} ${b.name} — ₹${(b.price_cents / 100).toFixed(0)}\n${b.description}\nSpecs: ${b.specs_json}`;\n return await callGemini(prompt);\n}\n\n// --- 4. Shopping assistant chat ---\n\nexport async function shoppingAssistant(\n message: string,\n history: { role: \"user\" | \"assistant\"; content: string }[],\n catalog: Product[],\n): Promise {\n const ctx = catalog.slice(0, 20).map(productSummary).join(\"\\n\");\n const system =\n `You are GadgetGenie, a helpful AI shopping assistant for an online smart-gadgets store.\nYou can reference the catalog below to recommend specific products by name.\nKeep replies concise (2-4 sentences), friendly, and practical. If the user asks about something outside gadgets, gently steer back to shopping.\n\nCatalog:\n${ctx}`;\n const historyText = history.slice(-6).map((m) =>\n `${m.role === \"user\" ? \"User\" : \"Assistant\"}: ${m.content}`\n ).join(\"\\n\");\n const prompt = `${historyText}\\nUser: ${message}\\nAssistant:`;\n return await callGemini(prompt, { system });\n}\n\n// --- 5. Search suggestions ---\n\nexport async function searchSuggestions(query: string): Promise {\n if (!query.trim()) return [];\n const prompt = `A user is searching for smart gadgets and typed: \"${query}\"\nSuggest 5 short, useful related search queries (under 6 words each).\nReturn ONLY a JSON array of strings, no prose.`;\n const text = await callGemini(prompt, { json: true });\n try {\n const parsed = JSON.parse(text);\n if (Array.isArray(parsed)) return parsed.slice(0, 5).map(String);\n } catch {\n const m = text.match(/\\[[\\s\\S]*\\]/);\n if (m) return JSON.parse(m[0]).slice(0, 5).map(String);\n }\n return [];\n}\n",[],[187,367],["D",1779460012296],[203,204,205],[187],["D",1779459922585],["D",1789494036282],{"_109":108,"_116":112},{"_109":108,"_110":-5,"_111":112,"_19":60,"_113":114,"_115":30},{"_13":94,"_37":95,"_48":47,"_96":49,"_97":98,"_99":100,"_101":55,"_102":103,"_104":105,"_106":50,"_107":108},"ctx",{"_87":-5,"_138":415,"_416":417,"_418":419,"_420":30,"_421":30,"_422":30,"_423":64,"_424":-5,"_425":-7,"_426":-7,"_427":68,"_428":30,"_429":30,"_430":-5,"_431":30,"_432":30,"_433":30,"_434":-5},"ENV",{"_386":387,"_388":389,"_390":95,"_391":392,"_393":394,"_395":396,"_397":398,"_399":400,"_401":402,"_403":404,"_405":406,"_407":408,"_409":410,"_411":412,"_413":414},"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 · v17