\n \n \n \n\n",[122,112],"9b563335fe53db290e8d5ea92c5ea819f02c9bdb844ce80301f554cb1c7c207e","frontend","5c059140-3996-11f1-a04c-42b51c65c3df","5404b440-f52b-11ef-99f0-569c3dd06744","a59cbf44-f528-11ef-ae42-569c3dd06744",74,["D",1776345337676],8,"\n\n \n \n \n React Hono Val Town Starter\n \n \n \n \n

\n \n \n \n",[122,112],"1ea8b3da4e18d579298229ba24af91b14b14ae02565f57c996f9acaa1f8333bc","frontend/favicon.svg",{"_32":143,"_13":136,"_82":144,"_84":125,"_85":33,"_86":145,"_88":26,"_34":146,"_40":117,"_91":118,"_93":147,"_66":48,"_95":-5,"_96":-7,"_75":148,"_98":149},{"_32":135,"_13":136,"_82":137,"_84":114,"_85":58,"_86":138,"_88":26,"_34":139,"_40":117,"_91":118,"_93":140,"_66":48,"_95":-5,"_96":-7,"_75":141,"_98":142},"42f87b76-162c-4e7f-8007-67f70a2cb01a","favicon.svg","019f3530-a79e-72d4-b6fa-f7c02721a6e8",12,["D",1783304331722],"\n\n",[122,136],"fcc93374d34653635da41cf3e9e338d5bcbd481334b1689b515ce9b1e726c5c9","82a730d4-3261-11f0-aa46-569c3dd06744","6f196b86-3261-11f0-9a3d-569c3dd06744",45,["D",1747405483360],"\n",[122,136],"1b9cfa9bc87dc0db12471f908bb8438c469ac9b2a59379157b627909cb30fc53","frontend/components/App.tsx",{"_32":164,"_13":154,"_82":165,"_84":166,"_85":33,"_86":167,"_88":26,"_34":168,"_40":90,"_91":159,"_93":169,"_66":48,"_95":-5,"_96":-7,"_75":170,"_98":171},{"_32":153,"_13":154,"_82":155,"_84":156,"_85":58,"_86":157,"_88":26,"_34":158,"_40":22,"_91":159,"_93":160,"_66":48,"_95":-5,"_96":-7,"_75":161,"_98":162},"d93feeae-34aa-4c26-bfb3-6efb5c364f3a","App.tsx","019f3530-a79e-72d4-b6fa-eb9c37956012","019f3530-a79e-72d4-b6fa-f3b35a448671",16,["D",1785284590626],"script","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { GarageView } from \"./GarageView.tsx\";\nimport { CarDetail } from \"./CarDetail.tsx\";\n\nfunction useHashRoute() {\n const [hash, setHash] = useState(window.location.hash);\n useEffect(() => {\n const fn = () => setHash(window.location.hash);\n window.addEventListener(\"hashchange\", fn);\n return () => window.removeEventListener(\"hashchange\", fn);\n }, []);\n return hash;\n}\n\nexport function App() {\n const route = useHashRoute();\n const carMatch = route.match(/^#\\/car\\/(\\d+)/);\n\n return (\n

\n \n 🏁\n Garage\n \n

\n {carMatch ? : }\n

\n );\n}\n",[122,163,154],"0dc8945f87aa73ec30fca9a4c64649729739461905d3f284eb329baa43b30b34","components","5d7e5e30-3996-11f1-bbdd-42b51c65c3df","6e585892-f52b-11ef-a8e1-569c3dd06744","69ed66bc-f52b-11ef-9dac-569c3dd06744",75,["D",1776345339930],"/** @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",[122,163,154],"de0a7e5fc76c6fd6135aff964af1a5835e04e2758b23f3d0c7d9fabffe514df7","README.md",{"_32":181,"_13":172,"_82":182,"_84":-5,"_85":33,"_86":60,"_88":48,"_34":183,"_40":87,"_91":118,"_93":184,"_66":48,"_95":-5,"_96":-7,"_75":185,"_98":186},{"_32":175,"_13":172,"_82":176,"_84":-5,"_85":58,"_86":104,"_88":26,"_34":177,"_40":117,"_91":118,"_93":178,"_66":48,"_95":-5,"_96":-7,"_75":179,"_98":180},"5c97674b-d308-4ab5-b7a8-eb55bf0adc5c","019f3530-a79e-72d4-b6fb-0794aaee1ad7",["D",1783304390278],"# 🏁 Garage\n\nA personal car-history tracker. Log every car you own or have owned, and keep its full story in one place: purchase details, mileage, average MPG, photos, documents, and a timeline of services, mods, and repairs.\n\n## Features\n\n- **Garage view** — cars split into *Currently own* and *Previously owned*\n- **Car detail page** — purchase date/price/mileage, current mileage (+ miles driven while owned), avg MPG, ownership duration, sold date/price, notes\n- **History timeline** — log services, mods, repairs, inspections with date, mileage, and cost. Purchase and sale appear automatically. Logging a higher mileage rolls the odometer forward.\n- **Photos** — upload multiple, click to view, set a cover photo. Images are resized client-side (~1600px JPEG) to save storage.\n- **Documents** — titles, receipts, window stickers, insurance… view, download, delete.\n\n## Architecture\n\n- `index.ts` — Hono server: serves the frontend + REST API (`/api/cars`, `/api/events`, `/api/files`)\n- `backend/db.ts` — SQLite schema (`cars`, `events`, `files`)\n- Uploads live in the val's blob storage; metadata in SQLite\n- `frontend/` — React 18 + Twind, hash routing (`#/car/:id`)\n- `scripts/smoke.ts` — in-process API smoke test (run it with `run_file`)\n\n## Notes\n\n- Blob storage is shared account-wide: 10 MB on Val Town free, 1 GB on Pro.\n- There's no auth — anyone with the URL can view/edit. Keep the URL private or make the val unlisted/private (Pro).\n",[172],"bbc60d40b08ecdee2eb9f39fb6fbc4fd1d7a58768d3796c2a8b906386ec1dc62","b9c749c0-59e1-11f1-bb5f-ee650bb23af1","a50c3760-f53e-11ef-bd6d-569c3dd06744",["D",1779896144390],"# 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## Picking a starter\n\n| Starter | When to pick it |\n| --- | --- |\n| [`basic-html-starter`](https://www.val.town/x/templates/basic-html-starter) | Static HTML pages. Sprinkle of vanilla JS. No server-side rendering. |\n| [`hono-jsx-starter`](https://www.val.town/x/templates/hono-jsx-starter) | Dynamic server-rendered HTML with JSX. API routes. No React, no SPA. |\n| **[`react-hono-starter`](https://www.val.town/x/templates/react-hono-starter)** *(you're here)* | Client-side React SPA with a Hono API backend. |\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\n",[172],"aaa4f5cc8e5bd01528335cdd2066e164bf95353ce2fe37c616b3e6406f49331e",{"_75":188,"_77":189,"_79":-7},"frontend/components/Counter.tsx",{"_32":190,"_13":191,"_82":192,"_84":166,"_85":33,"_86":193,"_88":26,"_34":194,"_40":195,"_91":159,"_93":196,"_66":48,"_95":-5,"_96":-7,"_75":197,"_98":198},"57a8cc52-3996-11f1-8db6-42b51c65c3df","Counter.tsx","57a8cd2e-3996-11f1-8db6-42b51c65c3df",73,["D",1776345330366],0,"/** @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",[122,163,191],"10ce4fbd7e41af337e504c3877201698031249b437d941845f0f7cdc52a79e66",{"_75":297,"_77":-7,"_79":298},{"_75":286,"_77":-7,"_79":287},{"_75":276,"_77":-7,"_79":277},{"_75":266,"_77":-7,"_79":267},{"_75":256,"_77":-7,"_79":257},{"_75":246,"_77":-7,"_79":247},{"_75":237,"_77":-7,"_79":238},{"_75":227,"_77":-7,"_79":228},{"_75":220,"_77":-7,"_79":221},{"_75":209,"_77":-7,"_79":210},"scripts/smoke.ts",{"_32":211,"_13":212,"_82":213,"_84":214,"_85":58,"_86":215,"_88":26,"_34":216,"_40":117,"_91":159,"_93":217,"_66":48,"_95":-5,"_96":-7,"_75":218,"_98":219},"5b32baae-bbd7-42db-8ed9-4e4a4ace6620","smoke.ts","135e6ef0-78e1-11f1-b8c7-1607ee4eb77e","afce3da8-5a38-487c-bc33-9ab1acd96636",28,["D",1785284695224],"// In-process smoke test: exercises every API route through the Hono app, then cleans up.\nimport handler from \"../index.ts\";\n\nconst base = \"http://garage.test\";\n\nasync function call(method: string, path: string, body?: BodyInit, headers?: HeadersInit) {\n const res = await (handler as any)(new Request(base + path, { method, body, headers }));\n const text = await res.text();\n let json: any = null;\n try {\n json = JSON.parse(text);\n } catch { /* not json */ }\n return { status: res.status, json, text: json ? undefined : text.slice(0, 120) };\n}\n\nconst json = { \"content-type\": \"application/json\" };\nconst results: any[] = [];\nconst ok = (name: string, pass: boolean, extra?: any) => results.push({ name, pass, extra });\n\n// 1. Create car\nconst created = await call(\n \"POST\",\n \"/api/cars\",\n JSON.stringify({\n make: \"Smoke\",\n model: \"Test\",\n year: 2020,\n status: \"current\",\n purchase_date: \"2020-05-01\",\n purchase_mileage: 10,\n current_mileage: 100,\n avg_mpg: 30,\n target_price: 25000,\n listing_url: \"https://example.com/listing\",\n }),\n json,\n);\nconst carId = created.json?.car?.id;\nok(\n \"create car (+ wishlist cols)\",\n created.status === 201 && !!carId && created.json?.car?.target_price === 25000,\n carId,\n);\n\n// 2. List\nconst list = await call(\"GET\", \"/api/cars\");\nok(\"list cars\", list.status === 200 && Array.isArray(list.json?.cars));\n\n// 3. Event (mileage 5000 should roll odometer forward from 100)\nconst ev = await call(\n \"POST\",\n `/api/cars/${carId}/events`,\n JSON.stringify({ type: \"service\", title: \"Oil change\", date: \"2021-01-01\", mileage: 5000, cost: 59.99 }),\n json,\n);\nconst evId = ev.json?.event?.id;\nok(\"create event\", ev.status === 201 && !!evId);\n\n// 4. Detail — check mileage bump + event present\nconst det = await call(\"GET\", `/api/cars/${carId}`);\nok(\n \"detail + odometer bump\",\n det.status === 200 && det.json?.car?.current_mileage === 5000 && det.json?.events?.length === 1,\n det.json?.car?.current_mileage,\n);\n\n// 5. Update event\nconst evUp = await call(\"PUT\", `/api/events/${evId}`, JSON.stringify({ cost: 65 }), json);\nok(\"update event\", evUp.status === 200 && evUp.json?.event?.cost === 65);\n\n// 6. Upload a document\nconst fd = new FormData();\nfd.append(\"kind\", \"document\");\nfd.append(\"file\", new File([\"hello garage\"], \"note.txt\", { type: \"text/plain\" }));\nconst up = await call(\"POST\", `/api/cars/${carId}/files`, fd);\nconst fileId = up.json?.file?.id;\nok(\"upload file\", up.status === 201 && !!fileId, up.json?.file?.blob_key);\n\n// 7. Read it back\nconst raw = await call(\"GET\", `/api/files/${fileId}/raw`);\nok(\"read file raw\", raw.status === 200 && raw.text === \"hello garage\", raw.text);\n\n// 8. Update car\nconst carUp = await call(\n \"PUT\",\n `/api/cars/${carId}`,\n JSON.stringify({ status: \"previous\", sold_date: \"2024-01-01\", sold_price: 9000 }),\n json,\n);\nok(\"update car\", carUp.status === 200 && carUp.json?.car?.status === \"previous\");\n\n// 9. Delete file, event, car (car delete also removes blobs + rows)\nok(\"delete file\", (await call(\"DELETE\", `/api/files/${fileId}`)).status === 200);\nok(\"delete event\", (await call(\"DELETE\", `/api/events/${evId}`)).status === 200);\nok(\"delete car\", (await call(\"DELETE\", `/api/cars/${carId}`)).status === 200);\n\n// 10. Confirm gone\nconst gone = await call(\"GET\", `/api/cars/${carId}`);\nok(\"car gone\", gone.status === 404);\n\nconst failed = results.filter((r) => !r.pass);\nconsole.log(JSON.stringify({ passed: results.length - failed.length, failed: failed.length, results }, null, 2));\n",[220,212],"7524c7dd257e476647d9efb5c84664a4a9abc14570aecedb6e03a697eff3168d","scripts",{"_32":222,"_13":220,"_82":214,"_84":-5,"_85":58,"_86":223,"_88":26,"_34":224,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":-7,"_75":226,"_98":-5},"01849e93-10c1-4961-a30a-ab2f101d6b38",13,["D",1783304351298],"directory",[220],"frontend/helpers.ts",{"_32":229,"_13":230,"_82":231,"_84":114,"_85":58,"_86":232,"_88":26,"_34":233,"_40":117,"_91":159,"_93":234,"_66":48,"_95":-5,"_96":-7,"_75":235,"_98":236},"422a8e08-864c-46f1-bd81-1582feb2e36c","helpers.ts","9ffcae7c-78e0-11f1-896f-1607ee4eb77e",32,["D",1786630240383],"// Shared formatting + API helpers for the Garage frontend\n\nexport const EVENT_TYPES: Record = {\n service: { label: \"Service\", icon: \"🔧\", badge: \"text-sky-400 bg-sky-400/10 border-sky-400/20\", dot: \"bg-sky-400\" },\n mod: { label: \"Mod\", icon: \"⚡\", badge: \"text-purple-400 bg-purple-400/10 border-purple-400/20\", dot: \"bg-purple-400\" },\n repair: { label: \"Repair\", icon: \"🛠️\", badge: \"text-orange-400 bg-orange-400/10 border-orange-400/20\", dot: \"bg-orange-400\" },\n inspection: { label: \"Inspection\", icon: \"📋\", badge: \"text-emerald-400 bg-emerald-400/10 border-emerald-400/20\", dot: \"bg-emerald-400\" },\n purchase: { label: \"Purchased\", icon: \"🔑\", badge: \"text-amber-400 bg-amber-400/10 border-amber-400/20\", dot: \"bg-amber-400\" },\n sale: { label: \"Sold\", icon: \"🤝\", badge: \"text-rose-400 bg-rose-400/10 border-rose-400/20\", dot: \"bg-rose-400\" },\n other: { label: \"Other\", icon: \"📌\", badge: \"text-neutral-300 bg-neutral-400/10 border-neutral-500/30\", dot: \"bg-neutral-400\" },\n};\n\nexport function eventType(t: string) {\n return EVENT_TYPES[t] || EVENT_TYPES.other;\n}\n\nexport function carTitle(car: any) {\n return car.nickname || [car.year, car.make, car.model].filter(Boolean).join(\" \");\n}\n\nexport function carSubtitle(car: any) {\n const full = [car.year, car.make, car.model, car.trim].filter(Boolean).join(\" \");\n return car.nickname ? full : (car.trim || \"\");\n}\n\nexport function fmtDate(d?: string | null) {\n if (!d) return null;\n const [y, m, day] = String(d).split(\"-\").map(Number);\n if (!y || !m || !day) return String(d);\n return new Date(y, m - 1, day).toLocaleDateString(undefined, {\n year: \"numeric\",\n month: \"short\",\n day: \"numeric\",\n });\n}\n\nexport function fmtNum(n?: number | null) {\n return n == null ? null : Number(n).toLocaleString();\n}\n\nexport function fmtMoney(n?: number | null) {\n if (n == null) return null;\n const v = Number(n);\n return \"$\" + (Number.isInteger(v)\n ? v.toLocaleString()\n : v.toLocaleString(undefined, { minimumFractionDigits: 2, maximumFractionDigits: 2 }));\n}\n\nexport function fmtBytes(n?: number | null) {\n if (n == null) return \"\";\n if (n < 1024) return n + \" B\";\n if (n < 1048576) return (n / 1024).toFixed(0) + \" KB\";\n return (n / 1048576).toFixed(1) + \" MB\";\n}\n\nexport function ownedFor(from?: string | null, to?: string | null) {\n if (!from) return null;\n const start = new Date(from);\n const end = to ? new Date(to) : new Date();\n let months = (end.getFullYear() - start.getFullYear()) * 12 + (end.getMonth() - start.getMonth());\n if (isNaN(months) || months < 0) return null;\n const y = Math.floor(months / 12);\n const m = months % 12;\n if (y && m) return `${y} yr ${m} mo`;\n if (y) return `${y} yr`;\n return m ? `${m} mo` : \"< 1 mo\";\n}\n\nexport async function api(path: string, opts: any = {}) {\n const headers: Record = { ...(opts.headers || {}) };\n if (opts.body && typeof opts.body === \"string\") headers[\"Content-Type\"] = \"application/json\";\n const res = await fetch(path, { ...opts, headers });\n if (!res.ok) {\n let msg = `Request failed (${res.status})`;\n try {\n const j = await res.json();\n if (j.error) msg = j.error;\n } catch { /* not json */ }\n throw new Error(msg);\n }\n return res.json();\n}\n\n// Downscale + JPEG-compress photos client-side before upload to save blob storage\nexport async function compressImage(file: File, maxDim = 1600, quality = 0.82): Promise {\n if (!file.type.startsWith(\"image/\")) return file;\n try {\n const bmp = await createImageBitmap(file);\n const scale = Math.min(1, maxDim / Math.max(bmp.width, bmp.height));\n const w = Math.round(bmp.width * scale);\n const h = Math.round(bmp.height * scale);\n const canvas = document.createElement(\"canvas\");\n canvas.width = w;\n canvas.height = h;\n canvas.getContext(\"2d\")!.drawImage(bmp, 0, 0, w, h);\n const out: Blob | null = await new Promise((r) => canvas.toBlob(r, \"image/jpeg\", quality));\n return out && out.size < file.size ? out : file;\n } catch {\n return file;\n }\n}\n\n// Upload a file to a car, optionally linked to a specific event.\n// Images are compressed and treated as photos; everything else is a document.\nexport async function uploadCarFile(\n carId: number,\n file: File,\n opts: { kind?: \"photo\" | \"document\"; eventId?: number | null } = {},\n) {\n const kind = opts.kind || (file.type.startsWith(\"image/\") ? \"photo\" : \"document\");\n let payload: Blob = file;\n let name = file.name;\n if (kind === \"photo\") {\n payload = await compressImage(file);\n if (payload !== file) name = file.name.replace(/\\.[^.]+$/, \"\") + \".jpg\";\n }\n const fd = new FormData();\n fd.append(\"file\", payload, name);\n fd.append(\"kind\", kind);\n if (opts.eventId != null) fd.append(\"event_id\", String(opts.eventId));\n return api(`/api/cars/${carId}/files`, { method: \"POST\", body: fd });\n}\n",[122,230],"ce1d2f8e58a01086524f1ea150c10766e839a23d5a32d95b280b15d3966329dd","frontend/components/Timeline.tsx",{"_32":239,"_13":240,"_82":241,"_84":156,"_85":58,"_86":20,"_88":26,"_34":242,"_40":90,"_91":159,"_93":243,"_66":48,"_95":-5,"_96":-7,"_75":244,"_98":245},"2b9d9b81-f3a6-4649-95e2-755459b0f021","Timeline.tsx","ec757f86-78e0-11f1-af42-1607ee4eb77e",["D",1786630282551],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, EVENT_TYPES, eventType, fmtBytes, fmtDate, fmtMoney, fmtNum, uploadCarFile } from \"../helpers.ts\";\n\nconst inputCls =\n \"w-full bg-neutral-800 border border-neutral-700 rounded-lg px-3 py-2 text-sm text-neutral-100 placeholder-neutral-500 focus:outline-none focus:border-amber-500/70\";\n\nexport function Timeline({ car, events, files = [], onChange }: any) {\n const [adding, setAdding] = useState(false);\n const [editing, setEditing] = useState(null);\n const [lightbox, setLightbox] = useState(null);\n const [attaching, setAttaching] = useState(null);\n const attachInput = useRef(null);\n const attachTarget = useRef(null);\n\n const items = buildTimeline(car, events);\n const attachmentsFor = (id: number) => files.filter((f: any) => f.event_id === id);\n\n async function remove(ev: any) {\n if (!confirm(`Delete \"${ev.title}\"?`)) return;\n await api(`/api/events/${ev.id}`, { method: \"DELETE\" });\n onChange();\n }\n\n function pickAttachment(eventId: number) {\n attachTarget.current = eventId;\n attachInput.current?.click();\n }\n\n async function onAttachPicked(e: any) {\n const picked: File[] = Array.from(e.target.files || []);\n e.target.value = \"\";\n const eventId = attachTarget.current;\n if (!picked.length || eventId == null) return;\n setAttaching(eventId);\n let err = \"\";\n for (const f of picked) {\n try {\n await uploadCarFile(car.id, f, { eventId });\n } catch (e2: any) {\n err = e2.message;\n }\n }\n setAttaching(null);\n if (err) alert(\"Some attachments failed: \" + err);\n onChange();\n }\n\n async function removeAttachment(f: any) {\n if (!confirm(`Remove ${f.filename} from this event?`)) return;\n await api(`/api/files/${f.id}`, { method: \"DELETE\" });\n onChange();\n }\n\n return (\n

\n {!adding && (\n {\n setAdding(true);\n setEditing(null);\n }}\n className=\"mb-4 bg-amber-500 hover:bg-amber-400 text-neutral-950 font-semibold px-4 py-2 rounded-xl text-sm\"\n >\n + Log event\n \n )}\n {(adding || editing) && (\n {\n setAdding(false);\n setEditing(null);\n }}\n onSaved={() => {\n setAdding(false);\n setEditing(null);\n onChange();\n }}\n />\n )}\n\n {items.length === 0 && (\n

\n {car.status === \"wishlist\"\n ? \"Nothing logged yet. Track test drives, listings you're watching, or price drops.\"\n : \"No history yet. Log services, mods, repairs — anything that happens to this car.\"}\n

\n )}\n\n

\n {items.map((ev: any, i: number) => {\n const t = eventType(ev.type);\n const meta = [fmtDate(ev.date), ev.mileage != null ? `${fmtNum(ev.mileage)} mi` : null, fmtMoney(ev.cost)]\n .filter(Boolean);\n return (\n \n \n

\n \n {t.icon} {t.label}\n \n

{ev.title}

\n {meta.length > 0 &&

{meta.join(\" · \")}

}\n {ev.description && (\n

{ev.description}

\n )}\n

\n {!ev.synthetic && (\n

\n pickAttachment(ev.id)}\n disabled={attaching === ev.id}\n title=\"Attach photo or invoice\"\n className=\"text-neutral-500 hover:text-amber-400 px-1.5 disabled:opacity-50\"\n >\n {attaching === ev.id ? \"…\" : \"📎\"}\n \n {\n setEditing(ev);\n setAdding(false);\n }}\n title=\"Edit\"\n className=\"text-neutral-500 hover:text-neutral-200 px-1.5\"\n >\n ✎\n \n \n

\n )}\n

\n {!ev.synthetic && (() => {\n const atts = attachmentsFor(ev.id);\n if (!atts.length) return null;\n const pics = atts.filter((f: any) => f.kind === \"photo\");\n const docs = atts.filter((f: any) => f.kind !== \"photo\");\n return (\n

\n {pics.length > 0 && (\n

\n {pics.map((f: any) => (\n

\n setLightbox(f)}\n className=\"h-20 w-20 object-cover rounded-lg border border-neutral-700 cursor-pointer\"\n />\n removeAttachment(f)}\n title=\"Remove\"\n className=\"absolute -top-1.5 -right-1.5 w-5 h-5 rounded-full bg-neutral-950/90 border border-neutral-600 text-neutral-300 hover:text-rose-400 text-xs leading-none opacity-0 group-hover/att:opacity-100 transition-opacity\"\n >\n ✕\n \n

\n ))}\n

\n )}\n {docs.map((f: any) => (\n

\n \n 📄\n {f.filename}\n {fmtBytes(f.size)}\n \n removeAttachment(f)}\n title=\"Remove\"\n className=\"text-neutral-500 hover:text-rose-400 px-1\"\n >\n ✕\n \n

\n ))}\n

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

\n );\n })}\n

\n\n \n\n {lightbox && (\n setLightbox(null)}\n >\n e.stopPropagation()}\n />\n

{lightbox.filename}

\n \n \n )}\n \n );\n}\n\n// Merge real events with synthetic purchase/sale entries derived from the car itself\nfunction buildTimeline(car: any, events: any[]) {\n const items: any[] = events.map((e) => ({ ...e }));\n if (car.purchase_date || car.purchase_price != null || car.purchase_mileage != null) {\n items.push({\n id: \"purchase\",\n synthetic: true,\n type: \"purchase\",\n title: \"Purchased\",\n date: car.purchase_date,\n mileage: car.purchase_mileage,\n cost: car.purchase_price,\n });\n }\n if (car.status === \"previous\" && (car.sold_date || car.sold_price != null)) {\n items.push({\n id: \"sale\",\n synthetic: true,\n type: \"sale\",\n title: \"Sold\",\n date: car.sold_date,\n cost: car.sold_price,\n });\n }\n return items.sort((a, b) =>\n String(b.date || \"9999-12-31\").localeCompare(String(a.date || \"9999-12-31\")) ||\n (Number(b.id) || Infinity) - (Number(a.id) || Infinity)\n );\n}\n\nfunction EventForm({ carId, initial, onClose, onSaved }: any) {\n const [form, setForm] = useState({\n type: initial?.type || \"service\",\n title: initial?.title || \"\",\n date: initial?.date || \"\",\n mileage: initial?.mileage ?? \"\",\n cost: initial?.cost ?? \"\",\n description: initial?.description || \"\",\n });\n const [saving, setSaving] = useState(false);\n const [error, setError] = useState(\"\");\n const set = (k: string) => (e: any) => setForm((f: any) => ({ ...f, [k]: e.target.value }));\n\n async function submit(e: any) {\n e.preventDefault();\n if (!form.title.trim()) {\n setError(\"Give the event a title\");\n return;\n }\n setSaving(true);\n setError(\"\");\n const payload = {\n type: form.type,\n title: form.title.trim(),\n date: form.date || null,\n mileage: form.mileage === \"\" ? null : Number(form.mileage),\n cost: form.cost === \"\" ? null : Number(form.cost),\n description: form.description.trim() || null,\n };\n try {\n if (initial) {\n await api(`/api/events/${initial.id}`, { method: \"PUT\", body: JSON.stringify(payload) });\n } else {\n await api(`/api/cars/${carId}/events`, { method: \"POST\", body: JSON.stringify(payload) });\n }\n onSaved();\n } catch (err: any) {\n setError(err.message);\n setSaving(false);\n }\n }\n\n return (\n \n );\n}\n",[122,163,240],"5d2164e8d0e4e0ede3495f727082c1d2c4febd7cdc334b54e4b9e94a5be76db9","frontend/components/MediaSections.tsx",{"_32":248,"_13":249,"_82":250,"_84":156,"_85":58,"_86":251,"_88":26,"_34":252,"_40":195,"_91":159,"_93":253,"_66":48,"_95":-5,"_96":-7,"_75":254,"_98":255},"b9d65a74-1133-40d1-acfb-4296adf677bd","MediaSections.tsx","fe9e6d12-78e0-11f1-9c8f-1607ee4eb77e",10,["D",1783304316490],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useRef, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, compressImage, fmtBytes, fmtDate } from \"../helpers.ts\";\n\nfunction useUploader(carId: number, kind: \"photo\" | \"document\", onChange: () => void) {\n const inputRef = useRef(null);\n const [busy, setBusy] = useState<{ done: number; total: number } | null>(null);\n\n async function onPick(e: any) {\n const files: File[] = Array.from(e.target.files || []);\n e.target.value = \"\";\n if (!files.length) return;\n setBusy({ done: 0, total: files.length });\n let err = \"\";\n for (let i = 0; i < files.length; i++) {\n try {\n const f = files[i];\n let payload: Blob = f;\n let name = f.name;\n if (kind === \"photo\") {\n payload = await compressImage(f);\n if (payload !== f) name = f.name.replace(/\\.[^.]+$/, \"\") + \".jpg\";\n }\n const fd = new FormData();\n fd.append(\"file\", payload, name);\n fd.append(\"kind\", kind);\n await api(`/api/cars/${carId}/files`, { method: \"POST\", body: fd });\n } catch (e2: any) {\n err = e2.message;\n }\n setBusy({ done: i + 1, total: files.length });\n }\n setBusy(null);\n if (err) alert(\"Some uploads failed: \" + err);\n onChange();\n }\n\n return { inputRef, busy, onPick, open: () => inputRef.current?.click() };\n}\n\nexport function PhotosSection({ carId, photos, coverId, onChange }: any) {\n const up = useUploader(carId, \"photo\", onChange);\n const [lightbox, setLightbox] = useState(null);\n\n async function setCover(f: any) {\n await api(`/api/cars/${carId}`, { method: \"PUT\", body: JSON.stringify({ cover_file_id: f.id }) });\n onChange();\n }\n async function remove(f: any) {\n if (!confirm(`Delete ${f.filename}?`)) return;\n await api(`/api/files/${f.id}`, { method: \"DELETE\" });\n onChange();\n }\n\n return (\n

\n \n \n {up.busy ? `Uploading ${up.busy.done}/${up.busy.total}…` : \"+ Upload photos\"}\n \n\n {photos.length === 0 && !up.busy && (\n

No photos yet. Uploads are resized automatically to save space.

\n )}\n\n

\n {photos.map((f: any) => (\n

\n setLightbox(f)}\n />\n {coverId === f.id && (\n \n ★ Cover\n \n )}\n

\n {coverId !== f.id && (\n setCover(f)}\n className=\"text-[11px] px-2 py-1 rounded-lg bg-black/70 border border-neutral-600 hover:border-amber-500/60\"\n >\n ★ Set cover\n \n )}\n remove(f)}\n className=\"text-[11px] px-2 py-1 rounded-lg bg-black/70 border border-neutral-600 text-rose-400 hover:border-rose-500/60\"\n >\n ✕\n \n

\n ))}\n

\n\n {lightbox && (\n setLightbox(null)}\n >\n e.stopPropagation()}\n />\n

{lightbox.filename} · {fmtDate(String(lightbox.created_at).slice(0, 10))}

\n \n

\n )}\n \n );\n}\n\nexport function DocsSection({ carId, docs, onChange }: any) {\n const up = useUploader(carId, \"document\", onChange);\n\n async function remove(f: any) {\n if (!confirm(`Delete ${f.filename}?`)) return;\n await api(`/api/files/${f.id}`, { method: \"DELETE\" });\n onChange();\n }\n\n function icon(f: any) {\n const m = String(f.mime_type || \"\");\n if (m.includes(\"pdf\")) return \"📕\";\n if (m.startsWith(\"image/\")) return \"🖼️\";\n if (m.includes(\"sheet\") || m.includes(\"csv\") || m.includes(\"excel\")) return \"📊\";\n return \"📄\";\n }\n\n return (\n

\n \n \n {up.busy ? `Uploading ${up.busy.done}/${up.busy.total}…` : \"+ Upload documents\"}\n \n\n {docs.length === 0 && !up.busy && (\n

\n No documents yet. Keep titles, receipts, window stickers, insurance docs — anything tied to this car.\n

\n )}\n\n

\n {docs.map((f: any) => (\n

\n {icon(f)}\n

{f.filename}

\n {fmtBytes(f.size)} · {fmtDate(String(f.created_at).slice(0, 10))}\n

\n \n Open\n \n \n ↓\n \n remove(f)}\n className=\"px-2.5 py-1.5 rounded-lg border border-neutral-700 text-rose-400 hover:bg-rose-950/50\"\n >\n ✕\n \n

\n ))}\n

\n );\n}\n",[122,163,249],"10166828e47e1281ce4e0307b65dd61d3c5056325725327526e10a1822083e56","frontend/components/GarageView.tsx",{"_32":258,"_13":259,"_82":260,"_84":156,"_85":58,"_86":261,"_88":26,"_34":262,"_40":117,"_91":159,"_93":263,"_66":48,"_95":-5,"_96":-7,"_75":264,"_98":265},"0eb8d795-178a-41bb-80a3-431c9155235a","GarageView.tsx","b4aa603a-78e0-11f1-8076-1607ee4eb77e",21,["D",1785284654528],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, carSubtitle, carTitle, fmtDate, fmtMoney, fmtNum } from \"../helpers.ts\";\nimport { CarForm } from \"./CarForm.tsx\";\n\nexport function GarageView() {\n const [cars, setCars] = useState(null);\n const [error, setError] = useState(\"\");\n const [showForm, setShowForm] = useState(false);\n\n async function load() {\n try {\n const data = await api(\"/api/cars\");\n setCars(data.cars);\n } catch (e: any) {\n setError(e.message);\n }\n }\n useEffect(() => {\n load();\n }, []);\n\n if (error) return

Couldn't load the garage: {error}

;\n if (!cars) return

Opening the garage…

;\n\n const current = cars.filter((c) => c.status === \"current\");\n const wishlist = cars.filter((c) => c.status === \"wishlist\");\n const previous = cars.filter((c) => c.status === \"previous\");\n\n const summary = [`${current.length} in the garage`];\n if (wishlist.length) summary.push(`${wishlist.length} on the wishlist`);\n if (previous.length) summary.push(`${previous.length} previously owned`);\n\n return (\n

My Garage

{summary.join(\" · \")}

\n setShowForm(true)}\n className=\"bg-amber-500 hover:bg-amber-400 text-neutral-950 font-semibold px-4 py-2 rounded-xl text-sm transition-colors\"\n >\n + Add car\n \n

\n\n {cars.length === 0 && (\n

🚗

The garage is empty

\n Add your first car — one you own, used to own, or dream about.\n

\n setShowForm(true)}\n className=\"bg-amber-500 hover:bg-amber-400 text-neutral-950 font-semibold px-4 py-2 rounded-xl text-sm\"\n >\n + Add your first car\n \n

\n )}\n\n {current.length > 0 && (\n

\n {current.map((car) => )}\n

\n )}\n {wishlist.length > 0 && (\n

\n {wishlist.map((car) => )}\n

\n )}\n {previous.length > 0 && (\n

\n {previous.map((car) => )}\n

\n )}\n\n {showForm && (\n setShowForm(false)}\n onSaved={(car: any) => {\n setShowForm(false);\n window.location.hash = `#/car/${car.id}`;\n }}\n />\n )}\n

\n );\n}\n\nfunction Section({ title, count, children }: any) {\n return (\n

\n {title} · {count}\n

{children}

\n );\n}\n\nfunction CarCard({ car }: any) {\n return (\n \n

\n {car.cover_file_id\n ? (\n \n )\n : (\n

\n {car.status === \"wishlist\" ? \"💭\" : \"🚗\"}\n

\n )}\n {car.status === \"previous\" && (\n \n Sold{car.sold_date ? ` · ${fmtDate(car.sold_date)}` : \"\"}\n \n )}\n

{carTitle(car)}

\n {carSubtitle(car) &&

{carSubtitle(car)}

}\n

\n {car.status === \"wishlist\" && car.target_price != null && 🎯 {fmtMoney(car.target_price)}}\n {car.current_mileage != null && 🛞 {fmtNum(car.current_mileage)} mi}\n {car.avg_mpg != null && ⛽ {car.avg_mpg} mpg}\n 📖 {car.event_count} {car.event_count === 1 ? \"event\" : \"events\"}\n {car.photo_count > 0 && 📷 {car.photo_count}}\n

\n \n );\n}\n",[122,163,259],"0b39dec83391fe19aa98f7a844c8a8b353b632e18d2af3714ff7c6ee5bebc3cf","frontend/components/CarForm.tsx",{"_32":268,"_13":269,"_82":270,"_84":156,"_85":58,"_86":271,"_88":26,"_34":272,"_40":117,"_91":159,"_93":273,"_66":48,"_95":-5,"_96":-7,"_75":274,"_98":275},"6195f193-fa16-442e-b341-07ab51e79dd1","CarForm.tsx","c5fae364-78e0-11f1-aba5-1607ee4eb77e",20,["D",1785284634074],"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useState } from \"https://esm.sh/react@18.2.0\";\nimport { api } from \"../helpers.ts\";\n\nconst EMPTY: Record = {\n nickname: \"\",\n year: \"\",\n make: \"\",\n model: \"\",\n trim: \"\",\n color: \"\",\n vin: \"\",\n status: \"current\",\n purchase_date: \"\",\n purchase_price: \"\",\n purchase_mileage: \"\",\n current_mileage: \"\",\n avg_mpg: \"\",\n sold_date: \"\",\n sold_price: \"\",\n target_price: \"\",\n listing_url: \"\",\n notes: \"\",\n};\n\nconst inputCls =\n \"w-full bg-neutral-800 border border-neutral-700 rounded-lg px-3 py-2 text-sm text-neutral-100 placeholder-neutral-500 focus:outline-none focus:border-amber-500/70\";\n\nexport function CarForm({ initial, onClose, onSaved }: any) {\n const [form, setForm] = useState(() => {\n const f = { ...EMPTY };\n if (initial) for (const k of Object.keys(EMPTY)) f[k] = initial[k] ?? \"\";\n return f;\n });\n const [saving, setSaving] = useState(false);\n const [error, setError] = useState(\"\");\n\n const set = (k: string) => (e: any) => setForm((f: any) => ({ ...f, [k]: e.target.value }));\n const num = (v: any) => (v === \"\" || v == null ? null : Number(v));\n const str = (v: any) => (v === \"\" || v == null ? null : String(v).trim() || null);\n\n const isWish = form.status === \"wishlist\";\n\n async function submit(e: any) {\n e.preventDefault();\n if (!form.make.trim() || !form.model.trim()) {\n setError(\"Make and model are required\");\n return;\n }\n setSaving(true);\n setError(\"\");\n const payload = {\n nickname: str(form.nickname),\n year: num(form.year),\n make: form.make.trim(),\n model: form.model.trim(),\n trim: str(form.trim),\n color: str(form.color),\n vin: str(form.vin),\n status: form.status,\n purchase_date: str(form.purchase_date),\n purchase_price: num(form.purchase_price),\n purchase_mileage: num(form.purchase_mileage),\n current_mileage: num(form.current_mileage),\n avg_mpg: num(form.avg_mpg),\n sold_date: form.status === \"previous\" ? str(form.sold_date) : null,\n sold_price: form.status === \"previous\" ? num(form.sold_price) : null,\n target_price: num(form.target_price),\n listing_url: str(form.listing_url),\n notes: str(form.notes),\n };\n try {\n const data = initial?.id\n ? await api(`/api/cars/${initial.id}`, { method: \"PUT\", body: JSON.stringify(payload) })\n : await api(\"/api/cars\", { method: \"POST\", body: JSON.stringify(payload) });\n onSaved(data.car);\n } catch (err: any) {\n setError(err.message);\n setSaving(false);\n }\n }\n\n return (\n \n e.stopPropagation()}\n onSubmit={submit}\n className=\"w-full max-w-xl bg-neutral-900 border border-neutral-800 rounded-2xl p-5 my-8\"\n >\n

{initial?.id ? \"Edit car\" : \"Add a car\"}

\n \n

\n\n

\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n {!isWish && (\n \n \n \n )}\n \n \n \n {isWish\n ? (\n \n \n \n )\n : (\n \n \n \n )}\n {isWish && (\n \n \n \n )}\n {!isWish && (\n \n \n \n )}\n {!isWish && (\n \n \n \n )}\n {!isWish && (\n \n \n \n )}\n {!isWish && (\n \n \n \n )}\n {form.status === \"previous\" && (\n \n \n \n )}\n {form.status === \"previous\" && (\n \n \n \n )}\n \n \n \n

\n\n {error &&

{error}

}\n\n

\n \n Cancel\n \n \n {saving ? \"Saving…\" : initial?.id ? \"Save changes\" : \"Add car\"}\n \n

\n \n \n );\n}\n\nfunction Field({ label, children, span }: any) {\n return (\n \n {label}\n {children}\n \n );\n}\n",[122,163,269],"635a8c067c76365667da2617d70d499aefee0c3d7b7445802d89398e35cca4ed","frontend/components/CarDetail.tsx",{"_32":278,"_13":279,"_82":280,"_84":156,"_85":58,"_86":57,"_88":26,"_34":281,"_40":282,"_91":159,"_93":283,"_66":48,"_95":-5,"_96":-7,"_75":284,"_98":285},"60186706-4333-4d27-8464-cf481861c6e3","CarDetail.tsx","d7dd0b70-78e0-11f1-af42-1607ee4eb77e",["D",1786630287524],6,"/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useEffect, useState } from \"https://esm.sh/react@18.2.0\";\nimport { api, carSubtitle, carTitle, fmtDate, fmtMoney, fmtNum, ownedFor } from \"../helpers.ts\";\nimport { CarForm } from \"./CarForm.tsx\";\nimport { Timeline } from \"./Timeline.tsx\";\nimport { DocsSection, PhotosSection } from \"./MediaSections.tsx\";\n\nexport function CarDetail({ carId }: { carId: number }) {\n const [data, setData] = useState(null);\n const [error, setError] = useState(\"\");\n const [tab, setTab] = useState(\"timeline\");\n const [editing, setEditing] = useState(null);\n\n async function load() {\n try {\n const d = await api(`/api/cars/${carId}`);\n setData(d);\n } catch (e: any) {\n setError(e.message);\n }\n }\n useEffect(() => {\n load();\n }, [carId]);\n\n if (error) return

Couldn't load this car: {error}

;\n if (!data) return

Pulling it out of the garage…

;\n\n const { car, events, files } = data;\n const photos = files.filter((f: any) => f.kind === \"photo\");\n const docs = files.filter((f: any) => f.kind === \"document\");\n const cover = car.cover_file_id ? photos.find((p: any) => p.id === car.cover_file_id) : null;\n const milesDriven = car.current_mileage != null && car.purchase_mileage != null\n ? car.current_mileage - car.purchase_mileage\n : null;\n const owned = ownedFor(car.purchase_date, car.status === \"previous\" ? car.sold_date : null);\n\n async function deleteCar() {\n if (!confirm(`Delete ${carTitle(car)} and all its events, photos, and documents? This can't be undone.`)) return;\n await api(`/api/cars/${car.id}`, { method: \"DELETE\" });\n window.location.hash = \"#/\";\n }\n\n const tabs = [\n { id: \"timeline\", label: `History · ${events.length}` },\n { id: \"photos\", label: `Photos · ${photos.length}` },\n { id: \"docs\", label: `Documents · ${docs.length}` },\n ];\n\n return (\n

\n \n ← Back to garage\n \n\n {/* Hero */}\n

\n {cover\n ?

\n : (\n

\n 🚗\n

\n )}\n

{carTitle(car)}

\n {car.status === \"previous\" && (\n \n Previously owned\n \n )}\n {car.status === \"wishlist\" && (\n \n 💭 Wishlist\n \n )}\n

\n {carSubtitle(car) &&

{carSubtitle(car)}

}\n

\n {car.color && {car.color}}\n {car.vin && VIN {car.vin}}\n {car.listing_url && (\n \n Listing ↗\n \n )}\n

\n {car.status === \"wishlist\" && (\n setEditing({ ...car, status: \"current\" })}\n className=\"px-3 py-1.5 rounded-lg text-sm font-semibold bg-amber-500 hover:bg-amber-400 text-neutral-950\"\n >\n 🎉 I bought it\n \n )}\n setEditing(car)}\n className=\"px-3 py-1.5 rounded-lg text-sm bg-neutral-800/90 border border-neutral-700 hover:bg-neutral-700\"\n >\n ✎ Edit\n \n \n Delete\n \n

\n\n {/* Stats */}\n

\n {car.current_mileage != null && (\n = 0 ? `+${fmtNum(milesDriven)} while owned` : undefined}\n />\n )}\n {car.avg_mpg != null && }\n {(car.purchase_date || car.purchase_price != null) && (\n \n )}\n {car.status === \"previous\" && (car.sold_date || car.sold_price != null) && (\n \n )}\n {owned && }\n {car.status === \"wishlist\" && car.target_price != null && (\n \n )}\n

\n\n {car.notes && (\n

\n {car.notes}\n

\n )}\n\n {/* Tabs */}\n

\n {tabs.map((t) => (\n setTab(t.id)}\n className={`px-3 py-1.5 rounded-lg text-sm border transition-colors ${\n tab === t.id\n ? \"bg-amber-500/10 text-amber-400 border-amber-500/40\"\n : \"border-neutral-800 text-neutral-400 hover:text-neutral-200 hover:border-neutral-600\"\n }`}\n >\n {t.label}\n \n ))}\n

\n\n {tab === \"timeline\" && }\n {tab === \"photos\" && }\n {tab === \"docs\" && }\n\n {editing && (\n setEditing(null)}\n onSaved={() => {\n setEditing(null);\n load();\n }}\n />\n )}\n

\n );\n}\n\nfunction Stat({ label, value, sub }: any) {\n return (\n

{label}

{value}

\n {sub &&

{sub}

}\n

\n );\n}\n",[122,163,279],"05944f8d17aa3f6926763c21faa64184b4ab1645d62400bbda3049d03cd0eb6b","backend/db.ts",{"_32":288,"_13":289,"_82":290,"_84":291,"_85":58,"_86":292,"_88":26,"_34":293,"_40":22,"_91":159,"_93":294,"_66":48,"_95":-5,"_96":-7,"_75":295,"_98":296},"7d30f0fe-534d-4c09-baaa-a10281a25bc6","db.ts","7b886d06-78e0-11f1-afce-1607ee4eb77e","82c14309-152d-495d-9f2a-8b8f5e901108",29,["D",1786630211604],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport { sqlite };\n\nexport async function initDb() {\n await sqlite.batch([\n {\n sql: `CREATE TABLE IF NOT EXISTS cars (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n nickname TEXT,\n year INTEGER,\n make TEXT NOT NULL,\n model TEXT NOT NULL,\n trim TEXT,\n color TEXT,\n vin TEXT,\n status TEXT NOT NULL DEFAULT 'current',\n purchase_date TEXT,\n purchase_price REAL,\n purchase_mileage INTEGER,\n current_mileage INTEGER,\n avg_mpg REAL,\n sold_date TEXT,\n sold_price REAL,\n notes TEXT,\n cover_file_id INTEGER,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS events (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n car_id INTEGER NOT NULL,\n type TEXT NOT NULL DEFAULT 'service',\n title TEXT NOT NULL,\n description TEXT,\n date TEXT,\n mileage INTEGER,\n cost REAL,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n {\n sql: `CREATE TABLE IF NOT EXISTS files (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n car_id INTEGER NOT NULL,\n kind TEXT NOT NULL,\n filename TEXT NOT NULL,\n mime_type TEXT,\n size INTEGER,\n blob_key TEXT NOT NULL,\n caption TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now'))\n )`,\n },\n ]);\n\n // Lightweight migrations — ignore \"duplicate column\" errors on re-run\n for (const sql of [\n \"ALTER TABLE cars ADD COLUMN target_price REAL\",\n \"ALTER TABLE cars ADD COLUMN listing_url TEXT\",\n \"ALTER TABLE files ADD COLUMN event_id INTEGER\",\n ]) {\n try {\n await sqlite.execute(sql);\n } catch { /* column already exists */ }\n }\n}\n",[297,289],"508c5c5d7982599861f658e31692aec743bed32256cdd7bc260c959cc504ebb0","backend",{"_32":299,"_13":297,"_82":291,"_84":-5,"_85":58,"_86":22,"_88":26,"_34":300,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":-7,"_75":301,"_98":-5},"2c81f632-1519-4353-b465-5b0146de628b",["D",1783304096563],[297],["D",1783303808467],"legacyEnvVars","httpPrivacy","description","Track cars you own & owned: mileage, MPG, docs, photos, history","imageUrl","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/64dc00cc-94d9-47dd-81b1-dde02610d900/square512?exp=1789577999&sig=2ab81189fced4fb576e9436da67acbaf730951eef80212e8dc3c2bf0f6be2f57","userId","019c452d-eb8d-7124-ac84-fd3eee7429af","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount","019c452d-eb8d-7124-ac85-003287cdb181","tursoName","86ecd64990834db7beddf9cb29edf0e9","tursoHostname","86ecd64990834db7beddf9cb29edf0e9-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789524079207],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_345":341},"org",{"_11":12,"_338":339,"_340":341,"_309":310,"_342":343,"_344":48},"branch","displayName","Billy","avatar","https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/189d5be3-0aea-450f-0b6c-366cb482cb00/square512?exp=1789577999&sig=dc8cef623590927d984fde958bcca710f144544d0bd89c85d05fc537013fc795","tier","pro","canRestrictVals","profileImageUrl","","adoptOrgId",{"_32":59,"_13":14,"_34":462,"_46":-5,"_303":48,"_49":50,"_304":50,"_305":306,"_307":308,"_309":310,"_311":83,"_312":26,"_313":-5,"_314":-5,"_315":195,"_53":316,"_317":318,"_319":320,"_321":463,"_323":-5,"_324":325,"_326":325,"_327":328,"_329":328,"_330":328,"_331":325,"_332":325,"_333":464,"_335":465,"_337":466,"_47":48},"tree",[400,402,414,416,417],"files",[400,401,402,403,404,405,406,407,408,409,410,411,412,413,414,415,416,417],"counts",{"_390":195,"_391":117,"_392":195,"_393":394,"_395":396},"contents",[374,375,376,377,378],"upstreamProject",{"_32":39,"_13":56,"_305":371,"_307":308,"_49":50,"_333":372},"upstreamBranch",{"_32":33,"_34":369,"_36":370,"_13":16,"_38":39,"_40":41,"_42":-5,"_43":-5,"_44":45,"_46":-5,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56},"emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},["D",1740674013689],["D",1785420707976],"Starter template with client-side React & Hono server",{"_11":52,"_345":373},"https://imagedelivery.net/iHX6Ovru0O7AjmyT5yZRoA/129cab32-3bd7-4c3e-f39b-f12900c76100/square512?exp=1789577999&sig=aa7aec25480c67f41f9650e8445afc21cf1a6c5fd3969752b90fbd3f6a604c46",{"_32":299,"_13":297,"_82":291,"_84":-5,"_85":58,"_86":22,"_88":26,"_34":388,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_75":389},{"_32":385,"_13":122,"_82":114,"_84":-5,"_85":58,"_86":117,"_88":26,"_34":386,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_75":387},{"_32":222,"_13":220,"_82":214,"_84":-5,"_85":58,"_86":223,"_88":26,"_34":383,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_75":384},{"_32":175,"_13":172,"_82":176,"_84":-5,"_85":58,"_86":104,"_88":26,"_34":381,"_40":117,"_91":118,"_93":178,"_66":48,"_95":-5,"_75":382},{"_32":81,"_13":76,"_82":83,"_84":-5,"_85":58,"_86":87,"_88":26,"_34":379,"_40":90,"_91":92,"_93":94,"_66":48,"_95":-5,"_75":380},["D",1786630228230],[76],["D",1783304390278],[172],["D",1783304351298],[220],"6aadff12-1aae-4b3c-8714-b52f9fbe42a1",["D",1783303808467],[122],["D",1783304096563],[297],"pulls","branches","forks","envVars",{"_397":195,"_399":195},"connections",{"_397":195,"_398":195},"count","unfilledCount","emptyCount",{"_32":299,"_13":297,"_82":291,"_84":-5,"_85":58,"_86":22,"_88":26,"_34":300,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":460,"_75":461},{"_32":288,"_13":289,"_82":290,"_84":291,"_85":58,"_86":292,"_88":26,"_34":293,"_40":22,"_91":159,"_93":294,"_66":48,"_95":-5,"_96":458,"_75":459},{"_32":385,"_13":122,"_82":114,"_84":-5,"_85":58,"_86":117,"_88":26,"_34":455,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":456,"_75":457},{"_32":451,"_13":163,"_82":156,"_84":114,"_85":58,"_86":117,"_88":26,"_34":452,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":453,"_75":454},{"_32":153,"_13":154,"_82":155,"_84":156,"_85":58,"_86":157,"_88":26,"_34":158,"_40":22,"_91":159,"_93":160,"_66":48,"_95":-5,"_96":449,"_75":450},{"_32":278,"_13":279,"_82":280,"_84":156,"_85":58,"_86":57,"_88":26,"_34":281,"_40":282,"_91":159,"_93":283,"_66":48,"_95":-5,"_96":447,"_75":448},{"_32":268,"_13":269,"_82":270,"_84":156,"_85":58,"_86":271,"_88":26,"_34":272,"_40":117,"_91":159,"_93":273,"_66":48,"_95":-5,"_96":445,"_75":446},{"_32":258,"_13":259,"_82":260,"_84":156,"_85":58,"_86":261,"_88":26,"_34":262,"_40":117,"_91":159,"_93":263,"_66":48,"_95":-5,"_96":443,"_75":444},{"_32":248,"_13":249,"_82":250,"_84":156,"_85":58,"_86":251,"_88":26,"_34":252,"_40":195,"_91":159,"_93":253,"_66":48,"_95":-5,"_96":441,"_75":442},{"_32":239,"_13":240,"_82":241,"_84":156,"_85":58,"_86":20,"_88":26,"_34":242,"_40":90,"_91":159,"_93":243,"_66":48,"_95":-5,"_96":439,"_75":440},{"_32":135,"_13":136,"_82":137,"_84":114,"_85":58,"_86":138,"_88":26,"_34":139,"_40":117,"_91":118,"_93":140,"_66":48,"_95":-5,"_96":437,"_75":438},{"_32":229,"_13":230,"_82":231,"_84":114,"_85":58,"_86":232,"_88":26,"_34":233,"_40":117,"_91":159,"_93":234,"_66":48,"_95":-5,"_96":435,"_75":436},{"_32":111,"_13":112,"_82":113,"_84":114,"_85":58,"_86":115,"_88":26,"_34":116,"_40":117,"_91":118,"_93":119,"_66":48,"_95":-5,"_96":433,"_75":434},{"_32":426,"_13":427,"_82":428,"_84":114,"_85":58,"_86":117,"_88":26,"_34":429,"_40":195,"_91":159,"_93":430,"_66":48,"_95":-5,"_96":431,"_75":432},{"_32":222,"_13":220,"_82":214,"_84":-5,"_85":58,"_86":223,"_88":26,"_34":224,"_40":195,"_91":225,"_93":-5,"_66":48,"_95":-5,"_96":424,"_75":425},{"_32":211,"_13":212,"_82":213,"_84":214,"_85":58,"_86":215,"_88":26,"_34":216,"_40":117,"_91":159,"_93":217,"_66":48,"_95":-5,"_96":422,"_75":423},{"_32":175,"_13":172,"_82":176,"_84":-5,"_85":58,"_86":104,"_88":26,"_34":177,"_40":117,"_91":118,"_93":178,"_66":48,"_95":-5,"_96":420,"_75":421},{"_32":81,"_13":76,"_82":83,"_84":-5,"_85":58,"_86":87,"_88":26,"_34":89,"_40":90,"_91":92,"_93":94,"_66":48,"_95":-5,"_96":418,"_75":419},[],[76],[],[172],[],[220,212],[415],[220],"9241087d-c63a-41ae-93de-1d445a625876","index.tsx","019f3530-a79e-72d4-b6fa-fffe2266ad02",["D",1783303808467],"/** @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();",[],[122,427],[],[122,112],[],[122,230],[],[122,136],[],[122,163,240],[],[122,163,249],[],[122,163,259],[],[122,163,269],[],[122,163,279],[],[122,163,154],"8530d7fc-e53c-48e0-9d35-5e1c489f4208",["D",1783303808467],[404,405,406,407,408,409],[122,163],["D",1783303808467],[403,410,411,412,413],[122],[],[297,289],[401],[297],["D",1783303808467],["D",1789524079207],{"_11":12,"_345":341},{"_11":12,"_338":339,"_340":341,"_309":310,"_342":343,"_344":48},{"_40":57,"_13":16,"_32":58,"_38":59,"_42":33,"_43":60,"_61":50,"_62":39,"_63":54,"_55":14,"_51":12},"ctx",{"_333":-5,"_366":500,"_501":502,"_503":504,"_505":48,"_506":48,"_507":48,"_508":26,"_509":-5,"_510":-7,"_511":-7,"_512":195,"_513":48,"_514":48,"_515":-5,"_516":48,"_517":48,"_518":48,"_519":-5},"ENV",{"_471":472,"_473":474,"_475":16,"_476":477,"_478":479,"_480":481,"_482":483,"_484":485,"_486":487,"_488":489,"_490":491,"_492":493,"_494":495,"_496":497,"_498":499},"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"]

Compare

Mergewohara010/mainintotemplates/main

README.md+16-55

frontend/components/App.tsx+28-7

frontend/favicon.svg+3-3

frontend/index.html+6-7

Hindex.ts+209-10

backend

backend/db.ts+68-0

frontend/components/CarDetail.tsx+193-0

frontend/components/CarForm.tsx+217-0

frontend/components/GarageView.tsx+145-0

frontend/components/MediaSections.tsx+194-0

frontend/components/Timeline.tsx+347-0

frontend/helpers.ts+122-0

scripts

scripts/smoke.ts+102-0

frontend/components/Counter.tsx+0-18