[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_337":338,"_339":340},"routes/_app.x.$handle.$name",{"_101":100,"_32":46,"_109":91,"_27":110,"_13":14,"_111":-5,"_11":112,"_113":114,"_115":116,"_117":118,"_119":120,"_20":-5,"_121":-5,"_122":-5,"_123":25,"_124":125,"_126":60,"_127":-5,"_128":-5,"_129":130},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_32":46,"_39":47,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":72,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":84,"_85":86,"_87":88,"_89":25},"version",26,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":33,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":25},"previous",{"_30":31,"_32":33,"_34":35,"_36":37},"deleted",false,"deletedHere","path","frontend/components/Views.tsx","latestPath","fileId","0a2aa3a6-9e72-11f1-bba5-1607ee4eb77e","name","Views.tsx","fileType","script","content","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n ArrowRight, CalendarCheck, CheckCircle2, ChevronDown, ChevronRight, CircleDashed, Clock3,\n Database, Dumbbell, Flame, Footprints, Gauge, HeartPulse, Play, Repeat2,\n Sparkles, TimerReset, TrendingUp, Weight,\n} from \"https://esm.sh/lucide-react@0.468.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Bootstrap, Session, Template } from \"../types.ts\";\nimport { durationLabel, fullDate, pace, shortDate, typeLabel } from \"../utils.ts\";\nimport { Brand } from \"./Nav.tsx\";\nimport { ExerciseList } from \"./ExerciseList.tsx\";\n\nconst surface = \"rounded-[26px] border border-[#17211b]/10 bg-white shadow-[0_10px_30px_rgba(23,33,27,.06)]\";\n\nexport function Header({ eyebrow, title }: { eyebrow?: string; title?: string }) {\n return (\n

\n {title ?

{eyebrow}

{title}

: }\n \n

\n );\n}\n\nfunction Meta({ template }: { template: Template }) {\n return (\n

\n {typeLabel(template.type)}\n {durationLabel(template.duration_seconds, template.type)}\n {template.default_weight_kg ? {template.default_weight_kg} kg : null}\n

\n );\n}\n\nexport function HomeView({ data, onStart, onNavigate }: { data: Bootstrap; onStart: (template: Template) => void; onNavigate: (page: \"workouts\" | \"history\" | \"progress\") => void }) {\n const first = data.templates.find((template) => template.id === data.recommendation.first_choice.template_id) || data.templates[0];\n const recent = data.sessions[0];\n const today = new Intl.DateTimeFormat(\"sv-SE\", { weekday: \"long\" }).format(new Date());\n return (\n <>\n

{today} · dagens plan

Vad känns rimligt idag?

\n\n

Förstavaluppdaterat idag

{data.recommendation.first_choice.title}

{data.recommendation.first_choice.detail}

{data.recommendation.rationale}

\n \n

\n\n

Alternativ

\n {data.recommendation.alternatives.map((alternative) => {\n const template = data.templates.find((item) => item.id === alternative.template_id);\n return (\n \n );\n })}\n

\n\n

\n \n \n

\n\n {recent ?

Senaste pass

: null}\n \n );\n}\n\nexport function WorkoutsView({ templates, onStart }: { templates: Template[]; onStart: (template: Template) => void }) {\n const [filter, setFilter] = useState(\"Alla\");\n const filters = [\"Alla\", \"Standard\", \"AMRAP\", \"EMOM\", \"Löpning\", \"Core\"];\n const shown = templates.filter((template) => {\n if (filter === \"Alla\") return true;\n if (filter === \"Standard\") return template.is_standard;\n if (filter === \"AMRAP\" || filter === \"EMOM\") return template.type === filter.toLowerCase();\n return template.tags.includes(filter);\n });\n return (\n <>\n

\n {filters.map((item) => )}\n

\n {shown.map((template) => (\n

\n \n

\n ))}\n

\n \n );\n}\n\nfunction SessionRow({ session }: { session: Session }) {\n const isRun = Number(session.distance_km || 0) > 0;\n return (\n

\n {isRun ? : }\n

{session.name}

{session.sync_status === \"pending_sync\" ? \"väntar\" : \"officiell\"}

{shortDate(session.completed_at)} · {Math.round(session.duration_seconds / 60)} min{session.weight_kg ? ` · ${session.weight_kg} kg` : \"\"}{session.distance_km ? ` · ${Number(session.distance_km).toFixed(1)} km` : \"\"}

{isRun ? pace(session.avg_pace_sec_km) : session.rounds ? `${session.rounds} varv` : `RPE ${session.effort || \"–\"}`}

{isRun ? \"tempo\" : session.rounds ? \"resultat\" : \"ansträngning\"}

\n );\n}\n\nexport function HistoryView({ sessions }: { sessions: Session[] }) {\n const [filter, setFilter] = useState<\"all\" | \"official\" | \"pending\">(\"all\");\n const shown = sessions.filter((session) => filter === \"all\" || (filter === \"official\" ? session.sync_status !== \"pending_sync\" : session.sync_status === \"pending_sync\"));\n const grouped = useMemo(() => {\n const groups = new Map();\n shown.forEach((session) => { const month = new Intl.DateTimeFormat(\"sv-SE\", { month: \"long\", year: \"numeric\" }).format(new Date(session.completed_at)); groups.set(month, [...(groups.get(month) || []), session]); });\n return [...groups.entries()];\n }, [shown]);\n return (\n <>\n

\n {([['all','Alla'],['official','Officiella'],['pending','Väntar']] as const).map(([value,label]) => )}\n

Hybridläge är aktivt

Google Sheet är officiell historik. Nya pass stannar som väntande i Val Town tills coachflödet har synkat dem.

\n {grouped.map(([month, monthSessions]) =>

{month}

{monthSessions.map((session) => )}

)}\n

\n \n );\n}\n\nfunction Bars({ values }: { values: Array<{ label: string; value: number }> }) {\n const max = Math.max(4, ...values.map((item) => item.value));\n return (\n

\n {values.map((item) =>

{item.value || \"\"}= 3 ? \"bg-[#17211b]\" : \"bg-[#bfc7bf]\"}`} style={{ height: `${Math.max(4, item.value / max * 76)}px` }} />{item.label.slice(-2)}

)}\n

\n );\n}\n\nexport function ProgressView({ data }: { data: Bootstrap }) {\n const frequency = data.progress.frequency_by_week.slice(-8).map((item) => ({ label: item.week, value: Number(item.sessions) }));\n while (frequency.length < 8) frequency.unshift({ label: `–${8 - frequency.length}`, value: 0 });\n const latestWeight = data.progress.kb_load_by_month.at(-1)?.max_weight || 20;\n const pullups = data.progress.skills.find((item) => item.metric_key === \"pull_ups\");\n const ttb = data.progress.skills.find((item) => item.metric_key === \"toes_to_bar\");\n return (\n <>\n

{data.progress.sessions_last_28_days}

pass senaste 28 dagarna

{data.progress.active_weeks_last_8} / 8

aktiva veckor

\n\n

Frekvens

Pass per vecka

mål 3

\n\n

Belastning

Kettlebell

{latestWeight}kg

högsta loggade arbetsvikt

20 kg standard

\n\n

Jämförbart över tid

Standardpass

{data.progress.standard_progress.map((item) => { const latest = item.sessions[0]; return

{item.name}

{item.sessions.length ? `${item.sessions.length} loggade försök` : \"Inget loggat försök än\"}

{latest?.rounds ? `${latest.rounds} varv` : latest?.distance_km ? `${Number(latest.distance_km).toFixed(1)} km` : \"–\"}

senast

; })}

\n\n

Löpning

Fart vid låg ansträngning

{data.progress.recent_runs.length ?

{data.progress.recent_runs.slice(0,3).map((run) =>

{Number(run.distance_km).toFixed(1)} km

{fullDate(run.completed_at)} · RPE {run.effort || \"–\"}

{pace(run.avg_pace_sec_km)}

)}

Första löppasset i appen blir baslinjen.

}

\n\n

Senare

Skills

{pullups ? pullups.value : \"–\"}

Pull-ups

{pullups ? \"senast loggat\" : \"ingen baslinje än\"}

{ttb ? ttb.value : \"–\"}

Toes-to-bar

{ttb ? \"senast loggat\" : \"ingen baslinje än\"}

\n \n );\n}\n","/** @jsxImportSource https://esm.sh/react@18.2.0 */\nimport { useMemo, useState } from \"https://esm.sh/react@18.2.0\";\nimport {\n ArrowRight, CalendarCheck, CheckCircle2, ChevronDown, ChevronRight, CircleDashed, Clock3,\n Database, Dumbbell, Flame, Footprints, Gauge, HeartPulse, Play, Repeat2,\n Sparkles, TimerReset, TrendingUp, Weight,\n} from \"https://esm.sh/lucide-react@0.468.0?deps=react@18.2.0,react-dom@18.2.0\";\nimport type { Bootstrap, Session, Template } from \"../types.ts\";\nimport { durationLabel, fullDate, pace, shortDate, typeLabel } from \"../utils.ts\";\nimport { Brand } from \"./Nav.tsx\";\nimport { ExerciseList } from \"./ExerciseList.tsx\";\n\nconst surface = \"rounded-[26px] border border-[#17211b]/10 bg-white shadow-[0_10px_30px_rgba(23,33,27,.06)]\";\n\nexport function Header({ eyebrow, title }: { eyebrow?: string; title?: string }) {\n return (\n

\n {title ?

{eyebrow}

{title}

: }\n \n

\n );\n}\n\nfunction Meta({ template }: { template: Template }) {\n return (\n

\n {typeLabel(template.type)}\n {durationLabel(template.duration_seconds, template.type)}\n {template.default_weight_kg ? {template.default_weight_kg} kg : null}\n

{today} · dagens plan

Vad känns rimligt idag?

\n\n {first ? (\n

\n Förstaval\n uppdaterat idag\n

{data.recommendation.first_choice.title}

\n {typeLabel(first.type)}\n {durationLabel(first.duration_seconds, first.type)}\n {first.default_weight_kg ? {first.default_weight_kg} kg : null}\n

Ett varv

\n \n

\n Varför det här passet?\n \n

{data.recommendation.rationale}

\n \n

\n ) : null}\n\n

Alternativ

\n {data.recommendation.alternatives.map((alternative) => {\n const template = data.templates.find((item) => item.id === alternative.template_id);\n if (!template) return null;\n return (\n

\n {template.type === \"open\" ? : }\n

{alternative.title}

Upplägg

\n \n

\n Mer om alternativet\n \n

{alternative.detail}

\n \n

\n );\n })}\n

\n\n

\n \n \n

\n\n {recent ?

Senaste pass

\n {filters.map((item) => )}\n

\n {shown.map((template) => (\n

\n \n

\n ))}\n

\n \n );\n}\n\nfunction SessionRow({ session }: { session: Session }) {\n const isRun = Number(session.distance_km || 0) > 0;\n return (\n

\n {isRun ? : }\n

{session.name}

{session.sync_status === \"pending_sync\" ? \"väntar\" : \"officiell\"}

{isRun ? pace(session.avg_pace_sec_km) : session.rounds ? `${session.rounds} varv` : `RPE ${session.effort || \"–\"}`}

{isRun ? \"tempo\" : session.rounds ? \"resultat\" : \"ansträngning\"}

\n {([['all','Alla'],['official','Officiella'],['pending','Väntar']] as const).map(([value,label]) => )}\n

Hybridläge är aktivt

Google Sheet är officiell historik. Nya pass stannar som väntande i Val Town tills coachflödet har synkat dem.

\n {grouped.map(([month, monthSessions]) =>

{month}

{monthSessions.map((session) => )}

)}\n

\n \n );\n}\n\nfunction Bars({ values }: { values: Array<{ label: string; value: number }> }) {\n const max = Math.max(4, ...values.map((item) => item.value));\n return (\n

\n {values.map((item) =>

{item.value || \"\"}= 3 ? \"bg-[#17211b]\" : \"bg-[#bfc7bf]\"}`} style={{ height: `${Math.max(4, item.value / max * 76)}px` }} />{item.label.slice(-2)}

)}\n

{data.progress.sessions_last_28_days}

pass senaste 28 dagarna

{data.progress.active_weeks_last_8} / 8

aktiva veckor

\n\n

Frekvens

Pass per vecka

mål 3

\n\n

Belastning

Kettlebell

{latestWeight}kg

högsta loggade arbetsvikt

20 kg standard

\n\n

Jämförbart över tid

Standardpass

{data.progress.standard_progress.map((item) => { const latest = item.sessions[0]; return

{item.name}

{item.sessions.length ? `${item.sessions.length} loggade försök` : \"Inget loggat försök än\"}

{latest?.rounds ? `${latest.rounds} varv` : latest?.distance_km ? `${Number(latest.distance_km).toFixed(1)} km` : \"–\"}

senast

; })}

\n\n

Löpning

Fart vid låg ansträngning

{data.progress.recent_runs.length ?

{data.progress.recent_runs.slice(0,3).map((run) =>

{Number(run.distance_km).toFixed(1)} km

{fullDate(run.completed_at)} · RPE {run.effort || \"–\"}

{pace(run.avg_pace_sec_km)}

)}

Första löppasset i appen blir baslinjen.

}

\n\n

Senare

Skills

{pullups ? pullups.value : \"–\"}

Pull-ups

{pullups ? \"senast loggat\" : \"ingen baslinje än\"}

{ttb ? ttb.value : \"–\"}

Toes-to-bar

{ttb ? \"senast loggat\" : \"ingen baslinje än\"}

\n \n );\n}\n","createdAt",["D",1787435992462],"branchVersion","branchId","60471d74-2b50-43e0-a779-1eff6bc1aaa3","id","c8a7d222-24de-4235-bc2b-adf159d616ed","training-coach",["D",1787434202328],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Mobil träningsapp med logg, timer och dagliga förslag","imageUrl","019c0a19-6135-710e-ad14-690e8d52c7bc","pinnedFileId","01a02b61-7568-77b9-9da3-bedb8e6ed0b5","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019c0a19-6135-710e-ad14-6cc836b76307","tursoName","c8a7d22224de4235bc2badf159d616ed","tursoHostname","c8a7d22224de4235bc2badf159d616ed-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789521640046],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_101":100,"_108":104},"org",{"_101":100,"_102":-5,"_103":104,"_18":56,"_105":106,"_107":25},"branch",{"_13":90,"_32":91,"_44":43,"_92":45,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":-5,"_98":46,"_99":100},"isOwned",60,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","jonasolof","handle","displayName","avatar","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zOHcxaWpkTDhVV1pzZ0NETm1KVDdjWUVnNnQifQ","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_32":46,"_39":332,"_48":-5,"_49":25,"_50":51,"_52":51,"_53":54,"_55":-5,"_18":56,"_57":58,"_59":60,"_61":-5,"_62":-5,"_63":64,"_65":66,"_67":68,"_69":70,"_71":333,"_73":-5,"_74":75,"_76":75,"_77":78,"_79":78,"_80":78,"_81":75,"_82":75,"_83":334,"_85":335,"_87":336,"_89":25},"tree",[201,214,215,216,217,218,219],"files",[201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217,218,219],"counts",{"_191":64,"_192":145,"_193":64,"_194":195,"_196":197},"contents",[131,132,133,134,135,136,137],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":185,"_32":186,"_30":187,"_141":-5,"_42":43,"_41":145,"_143":60,"_39":188,"_13":64,"_34":189,"_36":-5,"_24":25,"_147":-5,"_27":190},{"_44":179,"_32":180,"_30":181,"_141":-5,"_42":43,"_41":145,"_143":25,"_39":182,"_13":64,"_34":20,"_36":183,"_24":25,"_147":-5,"_27":184},{"_44":172,"_32":173,"_30":174,"_141":-5,"_42":43,"_41":175,"_143":25,"_39":176,"_13":145,"_34":20,"_36":177,"_24":25,"_147":-5,"_27":178},{"_44":165,"_32":166,"_30":167,"_141":-5,"_42":43,"_41":153,"_143":25,"_39":168,"_13":64,"_34":169,"_36":170,"_24":25,"_147":-5,"_27":171},{"_44":158,"_32":159,"_30":160,"_141":-5,"_42":43,"_41":161,"_143":25,"_39":162,"_13":64,"_34":35,"_36":163,"_24":25,"_147":-5,"_27":164},{"_44":149,"_32":150,"_30":58,"_141":-5,"_42":43,"_41":151,"_143":60,"_39":152,"_13":153,"_34":154,"_36":155,"_24":25,"_147":156,"_27":157},{"_44":138,"_32":139,"_30":140,"_141":-5,"_42":43,"_41":142,"_143":60,"_39":144,"_13":145,"_34":35,"_36":146,"_24":25,"_147":-5,"_27":148},"d30e846d-4677-44f0-9d7a-a14acb06a14e","smoke.ts","7f6e32a4-9e72-11f1-9f94-1607ee4eb77e","parentId",19,"latest",["D",1787435016118],1,"import { getBootstrapData } from \"./db.ts\";\n\nconst data = await getBootstrapData();\nconst result = {\n templates: data.templates.length,\n sessions: data.sessions.length,\n recommendationModel: data.recommendation.model,\n pendingSync: data.progress.pending_sync,\n hasFrequency: Array.isArray(data.progress.frequency_by_week),\n};\nif (result.templates < 8 || result.sessions < 1) throw new Error(\"Seed data missing\");\nconsole.log(result);\nexport default result;","label",[139],"993edeb7-9108-4a6a-a581-3b19386bf19f","index.ts",16,["D",1787434890404],3,"http","import { Hono } from \"npm:hono@4\";\nimport { getOAuthUserData, oauthMiddleware } from \"https://esm.town/v/std/oauth/middleware.ts\";\nimport { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { acknowledgeCoachSessions, createSession, ensureSchema, getBootstrapData, getCoachContext } from \"./db.ts\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\nconst OWNER = \"jonasolof\";\n\nasync function viewer(req: Request) {\n const session = await getOAuthUserData(req);\n return session?.user?.username === OWNER ? session.user : null;\n}\n\napp.get(\"/health\", (c) => c.json({ ok: true, app: \"training-coach\", database: \"val-scoped-sqlite\" }));\n\napp.get(\"/\", async (c) => {\n const session = await getOAuthUserData(c.req.raw);\n if (!session?.user) return c.redirect(\"/auth/login\");\n if (session.user.username !== OWNER) return c.text(\"Den här träningsappen är personlig.\", 403);\n await ensureSchema();\n return c.html(Root());\n});\n\napp.get(\"/manifest.webmanifest\", (c) => c.json({\n name: \"Jonas träning\",\n short_name: \"Träning\",\n start_url: \"/\",\n display: \"standalone\",\n background_color: \"#f3f1eb\",\n theme_color: \"#17211b\",\n icons: [{ src: \"/frontend/favicon.svg\", sizes: \"any\", type: \"image/svg+xml\" }],\n}));\n\napp.use(\"/api/*\", async (c, next) => {\n if (!(await viewer(c.req.raw))) return c.json({ error: \"Logga in med rätt Val Town-konto\" }, 401);\n await next();\n});\n\napp.get(\"/api/bootstrap\", async (c) => c.json(await getBootstrapData()));\n\napp.post(\"/api/sessions\", async (c) => {\n try {\n const session = await createSession(await c.req.json());\n return c.json(session, 201);\n } catch (error) {\n return c.json({ error: error instanceof Error ? error.message : \"Passet kunde inte sparas\" }, 400);\n }\n});\n\napp.get(\"/api/coach/context\", async (c) => c.json(await getCoachContext(c.req.query(\"since\"))));\n\napp.post(\"/api/coach/ack\", async (c) => {\n const body = await c.req.json<{ ids?: string[] }>();\n return c.json(await acknowledgeCoachSessions(Array.isArray(body.ids) ? body.ids : []));\n});\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\napp.notFound((c) => c.redirect(\"/\"));\napp.onError((err) => Promise.reject(err));\n\nexport default oauthMiddleware(app.fetch);\n","jonas-training",[150],"fd92a765-e4ed-403d-8427-4d57bcb5c1fc","db.ts","fde5ebb4-9e71-11f1-9141-1607ee4eb77e",2,["D",1787434785320],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\n\nexport type SessionInput = {\n client_id?: string;\n template_id?: string | null;\n name: string;\n type: \"amrap\" | \"emom\" | \"for_time\" | \"open\";\n started_at: string;\n completed_at?: string;\n duration_seconds: number;\n rounds?: number | null;\n partial_reps?: number | null;\n effort?: number | null;\n feeling?: number | null;\n notes?: string;\n weight_kg?: number | null;\n distance_km?: number | null;\n avg_pace_sec_km?: number | null;\n avg_hr?: number | null;\n cadence_spm?: number | null;\n laps?: Array<{ elapsed_seconds: number; reps?: number | null; note?: string }>;\n performance?: Array<{ metric_key: string; value: number; unit?: string }>;\n};\n\nconst templates = [\n {\n id: \"kb-standard-20\",\n name: \"Standardpass KB 20\",\n type: \"amrap\",\n duration: 1200,\n rounds: null,\n weight: 20,\n description: \"Ett enkelt helkroppspass med puls – samma kettlebell hela vägen.\",\n tags: [\"Kettlebell\", \"Puls\", \"Standard\"],\n isStandard: 1,\n exercises: [\n { name: \"Pop squats\", reps: \"15\" },\n { name: \"Armhävningar\", reps: \"10\" },\n { name: \"Reverse lunges\", reps: \"8 / sida\" },\n { name: \"Swings\", reps: \"15\" },\n { name: \"Floor press\", reps: \"5 / sida\" },\n ],\n },\n {\n id: \"emom-pulse-press\",\n name: \"EMOM Puls + press\",\n type: \"emom\",\n duration: 1200,\n rounds: 4,\n weight: 20,\n description: \"Fem tydliga minuter som upprepas fyra gånger. Press är den avsiktliga svaga länken.\",\n tags: [\"EMOM\", \"Kettlebell\", \"Press\"],\n isStandard: 1,\n exercises: [\n { name: \"Swings\", reps: \"15\" },\n { name: \"Armhävningar\", reps: \"12\" },\n { name: \"Pop squats\", reps: \"12\" },\n { name: \"Reverse lunges\", reps: \"10 / sida\" },\n { name: \"Floor press\", reps: \"5 / sida\" },\n ],\n },\n {\n id: \"core-stability\",\n name: \"Core & stabilitet\",\n type: \"amrap\",\n duration: 900,\n rounds: null,\n weight: 16,\n description: \"Bål, axelstabilitet och kontroll på 15 minuter.\",\n tags: [\"Core\", \"Stabilitet\"],\n isStandard: 0,\n exercises: [\n { name: \"Forearm plank\", reps: \"Till failure\" },\n { name: \"Around the worlds\", reps: \"10 / håll\" },\n { name: \"Horizontal swings\", reps: \"10\" },\n { name: \"Overhead marches\", reps: \"10 / sida\" },\n { name: \"Kneeling wood chops\", reps: \"6 / sida\" },\n { name: \"Plank pull-through + push-up\", reps: \"10\" },\n ],\n },\n {\n id: \"kb-complex\",\n name: \"Kettlebell-komplex\",\n type: \"amrap\",\n duration: 1200,\n rounds: null,\n weight: 20,\n description: \"Det ursprungliga Pass 2 från träningsloggen – kort, funktionellt och pulshöjande.\",\n tags: [\"Kettlebell\", \"Puls\"],\n isStandard: 0,\n exercises: [\n { name: \"Halos + goblet squats\", reps: \"6 + 2\" },\n { name: \"Alternating single-arm swings\", reps: \"20\" },\n { name: \"Reverse lunges + forearm curl\", reps: \"10\" },\n { name: \"Burpees over the bell\", reps: \"10\" },\n ],\n },\n {\n id: \"functional-pulse\",\n name: \"Funktionell styrka & puls\",\n type: \"for_time\",\n duration: 0,\n rounds: 6,\n weight: 16,\n description: \"Sex varv på tid med 1–2 minuters vila mellan varven.\",\n tags: [\"Kettlebell\", \"Puls\", \"På tid\"],\n isStandard: 0,\n exercises: [\n { name: \"KB jump hops\", reps: \"20\" },\n { name: \"Alternating offset push-ups\", reps: \"12\" },\n { name: \"Squat + pullovers\", reps: \"12\" },\n { name: \"Single-arm front rack lunges\", reps: \"6 / sida\" },\n { name: \"Rotational KB uppercuts\", reps: \"6 / sida\" },\n ],\n },\n {\n id: \"clean-press-squat\",\n name: \"Clean, press & squat\",\n type: \"amrap\",\n duration: 900,\n rounds: null,\n weight: 16,\n description: \"Teknik och presskapacitet. Byt clean om handleden protesterar.\",\n tags: [\"Kettlebell\", \"Press\", \"Teknik\"],\n isStandard: 0,\n exercises: [\n { name: \"Cleans\", reps: \"5\" },\n { name: \"Presses\", reps: \"5\" },\n { name: \"Goblet squats\", reps: \"5\" },\n ],\n },\n {\n id: \"run-zone-2\",\n name: \"Lugn löpning\",\n type: \"open\",\n duration: 1800,\n rounds: null,\n weight: null,\n description: \"30 minuter i zon 2. Jämn känsla före fart.\",\n tags: [\"Löpning\", \"Zon 2\"],\n isStandard: 1,\n exercises: [{ name: \"Löpning zon 2\", reps: \"30 min\" }],\n },\n {\n id: \"ttb-prep\",\n name: \"Toes-to-bar prep\",\n type: \"amrap\",\n duration: 900,\n rounds: null,\n weight: null,\n description: \"Axlar och bål inför längdskidor och framtida toes-to-bar progression.\",\n tags: [\"Core\", \"Skills\", \"Toes-to-bar\"],\n isStandard: 0,\n exercises: [\n { name: \"Toes-to-bar / hanging leg raises\", reps: \"6–8\" },\n { name: \"Dead hang\", reps: \"30 sek\" },\n { name: \"Sit-ups\", reps: \"12\" },\n { name: \"Plank pull-through\", reps: \"8 / sida\" },\n ],\n },\n];\n\nlet schemaReady: Promise | null = null;\n\nexport function ensureSchema() {\n if (!schemaReady) schemaReady = setupSchema();\n return schemaReady;\n}\n\nasync function setupSchema() {\n await sqlite.batch([\n { sql: `CREATE TABLE IF NOT EXISTS workout_templates (\n id TEXT PRIMARY KEY, name TEXT NOT NULL, type TEXT NOT NULL,\n duration_seconds INTEGER NOT NULL DEFAULT 0, rounds_target INTEGER,\n default_weight_kg REAL, description TEXT NOT NULL DEFAULT '',\n tags_json TEXT NOT NULL DEFAULT '[]', exercises_json TEXT NOT NULL DEFAULT '[]',\n is_standard INTEGER NOT NULL DEFAULT 0, active INTEGER NOT NULL DEFAULT 1,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS sessions (\n id TEXT PRIMARY KEY, client_id TEXT UNIQUE, template_id TEXT,\n name TEXT NOT NULL, type TEXT NOT NULL, started_at TEXT NOT NULL,\n completed_at TEXT NOT NULL, duration_seconds INTEGER NOT NULL DEFAULT 0,\n rounds INTEGER, partial_reps INTEGER, effort INTEGER, feeling INTEGER,\n notes TEXT NOT NULL DEFAULT '', weight_kg REAL, distance_km REAL,\n avg_pace_sec_km INTEGER, avg_hr INTEGER, cadence_spm REAL,\n source TEXT NOT NULL DEFAULT 'val_town', source_external_id TEXT UNIQUE,\n sync_status TEXT NOT NULL DEFAULT 'pending_sync', processed_at TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(template_id) REFERENCES workout_templates(id)\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS laps (\n id TEXT PRIMARY KEY, session_id TEXT NOT NULL, lap_number INTEGER NOT NULL,\n elapsed_seconds INTEGER NOT NULL, reps INTEGER, note TEXT NOT NULL DEFAULT '',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(session_id) REFERENCES sessions(id) ON DELETE CASCADE\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS performance_entries (\n id TEXT PRIMARY KEY, session_id TEXT NOT NULL, metric_key TEXT NOT NULL,\n value REAL NOT NULL, unit TEXT NOT NULL DEFAULT 'reps',\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n FOREIGN KEY(session_id) REFERENCES sessions(id) ON DELETE CASCADE\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS daily_recommendations (\n id TEXT PRIMARY KEY, for_date TEXT NOT NULL UNIQUE,\n first_choice_json TEXT NOT NULL, alternatives_json TEXT NOT NULL,\n rationale TEXT NOT NULL, based_on_session_id TEXT, model TEXT NOT NULL,\n generated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )` },\n { sql: `CREATE TABLE IF NOT EXISTS sync_state (\n key TEXT PRIMARY KEY, value TEXT NOT NULL, updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )` },\n { sql: \"CREATE INDEX IF NOT EXISTS idx_sessions_started ON sessions(started_at DESC)\" },\n { sql: \"CREATE INDEX IF NOT EXISTS idx_sessions_sync ON sessions(sync_status, completed_at DESC)\" },\n { sql: \"CREATE INDEX IF NOT EXISTS idx_performance_metric ON performance_entries(metric_key, created_at DESC)\" },\n ]);\n\n await sqlite.batch(templates.map((template) => ({\n sql: `INSERT OR IGNORE INTO workout_templates\n (id, name, type, duration_seconds, rounds_target, default_weight_kg, description, tags_json, exercises_json, is_standard)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [template.id, template.name, template.type, template.duration, template.rounds, template.weight,\n template.description, JSON.stringify(template.tags), JSON.stringify(template.exercises), template.isStandard],\n })));\n\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO sessions\n (id, client_id, template_id, name, type, started_at, completed_at, duration_seconds,\n rounds, effort, feeling, notes, weight_kg, source, source_external_id, sync_status, processed_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)`,\n args: [\"sheet-2026-06-14-pass-2\", \"sheet-2026-06-14-pass-2\", \"kb-complex\", \"Pass 2: KB\", \"amrap\",\n \"2026-06-14T10:00:00.000Z\", \"2026-06-14T10:20:00.000Z\", 1200, 7, 7, 4,\n \"Körde en blandning av 16 kg och 20 kg.\", 20, \"google_sheet\", \"sheet:2026-06-14:Pass 2: KB\", \"official\", \"2026-06-14T10:20:00.000Z\"],\n });\n\n await sqlite.batch([\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('official_sheet_id', ?)\", args: [\"1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU\"] },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('official_sheet_tab', ?)\", args: [\"Träningsdagbok - Kettlebell & Core V5\"] },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('official_sheet_mode', 'read_only')\" },\n ]);\n}\n\nfunction json(value: string | null | undefined, fallback: T): T {\n try { return value ? JSON.parse(value) : fallback; } catch { return fallback; }\n}\n\nfunction templateRow(row: Record) {\n return {\n ...row,\n tags: json(String(row.tags_json || \"\"), []),\n exercises: json(String(row.exercises_json || \"\"), []),\n is_standard: Boolean(row.is_standard),\n active: Boolean(row.active),\n };\n}\n\nfunction recommendationRow(row: Record | undefined) {\n if (!row) return null;\n return {\n ...row,\n date: row.for_date,\n first_choice: json(String(row.first_choice_json || \"\"), {}),\n alternatives: json(String(row.alternatives_json || \"\"), []),\n };\n}\n\nexport async function getBootstrapData() {\n await ensureSchema();\n const [templateResult, sessionResult, recommendationResult, frequencyResult, loadResult, skillResult] = await Promise.all([\n sqlite.execute(\"SELECT * FROM workout_templates WHERE active = 1 ORDER BY is_standard DESC, name\"),\n sqlite.execute(\"SELECT * FROM sessions ORDER BY started_at DESC LIMIT 100\"),\n sqlite.execute(\"SELECT * FROM daily_recommendations ORDER BY for_date DESC LIMIT 1\"),\n sqlite.execute(`SELECT strftime('%Y-%W', started_at) AS week, COUNT(*) AS sessions\n FROM sessions WHERE completed_at >= datetime('now', '-56 days') GROUP BY week ORDER BY week`),\n sqlite.execute(`SELECT substr(started_at, 1, 7) AS month, MAX(weight_kg) AS max_weight, COUNT(*) AS sessions\n FROM sessions WHERE weight_kg IS NOT NULL GROUP BY month ORDER BY month DESC LIMIT 6`),\n sqlite.execute(`SELECT metric_key, value, unit, created_at FROM performance_entries\n WHERE metric_key IN ('pull_ups', 'toes_to_bar') ORDER BY created_at DESC LIMIT 20`),\n ]);\n\n const sessions = sessionResult.rows as Array>;\n const frequency = frequencyResult.rows as Array>;\n const recentRuns = sessions.filter((session) => Number(session.distance_km || 0) > 0).slice(0, 8);\n const standardProgress = (templateResult.rows as Array>)\n .filter((row) => Boolean(row.is_standard))\n .map((row) => {\n const matching = sessions.filter((session) => session.template_id === row.id).slice(0, 6);\n return { template_id: row.id, name: row.name, sessions: matching };\n });\n const now = new Date();\n const currentWeek = `${now.getUTCFullYear()}-${String(Math.ceil((((now.getTime() - Date.UTC(now.getUTCFullYear(), 0, 1)) / 86400000) + new Date(Date.UTC(now.getUTCFullYear(), 0, 1)).getUTCDay() + 1) / 7)).padStart(2, \"0\")}`;\n const currentWeekSessions = Number(frequency.find((row) => row.week === currentWeek)?.sessions || 0);\n\n return {\n templates: (templateResult.rows as Array>).map(templateRow),\n sessions,\n recommendation: recommendationRow((recommendationResult.rows as Array>)[0]) || fallbackRecommendation(),\n progress: {\n sessions_this_week: currentWeekSessions,\n sessions_last_28_days: sessions.filter((session) => new Date(String(session.completed_at)).getTime() > Date.now() - 28 * 86400000).length,\n active_weeks_last_8: frequency.length,\n pending_sync: sessions.filter((session) => session.sync_status === \"pending_sync\").length,\n frequency_by_week: frequency,\n kb_load_by_month: (loadResult.rows as Array>).reverse(),\n recent_runs: recentRuns,\n standard_progress: standardProgress,\n skills: skillResult.rows,\n },\n };\n}\n\nexport async function createSession(input: SessionInput) {\n await ensureSchema();\n if (!input.name?.trim()) throw new Error(\"Passnamn saknas\");\n if (!Number.isFinite(input.duration_seconds) || input.duration_seconds < 0) throw new Error(\"Ogiltig passtid\");\n const id = crypto.randomUUID();\n const completedAt = input.completed_at || new Date().toISOString();\n const clientId = input.client_id || id;\n const statements: Array<{ sql: string; args: Array }> = [{\n sql: `INSERT INTO sessions\n (id, client_id, template_id, name, type, started_at, completed_at, duration_seconds,\n rounds, partial_reps, effort, feeling, notes, weight_kg, distance_km,\n avg_pace_sec_km, avg_hr, cadence_spm, source, sync_status)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, 'val_town', 'pending_sync')`,\n args: [id, clientId, input.template_id || null, input.name.trim(), input.type, input.started_at, completedAt,\n Math.round(input.duration_seconds), input.rounds ?? null, input.partial_reps ?? null,\n input.effort ?? null, input.feeling ?? null, input.notes?.trim() || \"\", input.weight_kg ?? null,\n input.distance_km ?? null, input.avg_pace_sec_km ?? null, input.avg_hr ?? null, input.cadence_spm ?? null],\n }];\n (input.laps || []).forEach((lap, index) => statements.push({\n sql: \"INSERT INTO laps(id, session_id, lap_number, elapsed_seconds, reps, note) VALUES (?, ?, ?, ?, ?, ?)\",\n args: [crypto.randomUUID(), id, index + 1, Math.round(lap.elapsed_seconds), lap.reps ?? null, lap.note?.trim() || \"\"],\n }));\n (input.performance || []).forEach((entry) => statements.push({\n sql: \"INSERT INTO performance_entries(id, session_id, metric_key, value, unit) VALUES (?, ?, ?, ?, ?)\",\n args: [crypto.randomUUID(), id, entry.metric_key, entry.value, entry.unit || \"reps\"],\n }));\n await sqlite.batch(statements);\n const result = await sqlite.execute({ sql: \"SELECT * FROM sessions WHERE id = ?\", args: [id] });\n return result.rows[0];\n}\n\nexport async function getCoachContext(since?: string) {\n await ensureSchema();\n const result = await sqlite.execute({\n sql: `SELECT * FROM sessions\n WHERE (? IS NULL AND processed_at IS NULL) OR completed_at > ?\n ORDER BY completed_at ASC LIMIT 100`,\n args: [since || null, since || null],\n });\n const recommendation = await sqlite.execute(\"SELECT * FROM daily_recommendations ORDER BY for_date DESC LIMIT 1\");\n return {\n generated_at: new Date().toISOString(),\n official_history: { sheet_id: \"1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU\", mode: \"read_only\" },\n new_sessions: result.rows,\n latest_recommendation: recommendationRow((recommendation.rows as Array>)[0]),\n };\n}\n\nexport async function acknowledgeCoachSessions(ids: string[]) {\n await ensureSchema();\n if (!ids.length) return { updated: 0 };\n const now = new Date().toISOString();\n const results = await sqlite.batch(ids.map((id) => ({\n sql: \"UPDATE sessions SET processed_at = ? WHERE id = ?\",\n args: [now, id],\n })));\n return { updated: results.reduce((sum, result) => sum + Number(result.rowsAffected || 0), 0), processed_at: now };\n}\n\nexport async function recommendationContext() {\n await ensureSchema();\n const [sessions, templateRows] = await Promise.all([\n sqlite.execute(\"SELECT * FROM sessions ORDER BY completed_at DESC LIMIT 14\"),\n sqlite.execute(\"SELECT id, name, type, duration_seconds, default_weight_kg, tags_json FROM workout_templates WHERE active = 1\"),\n ]);\n return { sessions: sessions.rows, templates: templateRows.rows };\n}\n\nexport async function saveRecommendation(value: {\n date: string;\n first_choice: Record;\n alternatives: Array>;\n rationale: string;\n based_on_session_id?: string | null;\n model: string;\n}) {\n await ensureSchema();\n await sqlite.execute({\n sql: `INSERT INTO daily_recommendations\n (id, for_date, first_choice_json, alternatives_json, rationale, based_on_session_id, model, generated_at)\n VALUES (?, ?, ?, ?, ?, ?, ?, ?)\n ON CONFLICT(for_date) DO UPDATE SET first_choice_json = excluded.first_choice_json,\n alternatives_json = excluded.alternatives_json, rationale = excluded.rationale,\n based_on_session_id = excluded.based_on_session_id, model = excluded.model,\n generated_at = excluded.generated_at`,\n args: [crypto.randomUUID(), value.date, JSON.stringify(value.first_choice), JSON.stringify(value.alternatives),\n value.rationale, value.based_on_session_id || null, value.model, new Date().toISOString()],\n });\n return value;\n}\n\nexport function fallbackRecommendation() {\n return {\n date: new Date().toISOString().slice(0, 10),\n first_choice: { template_id: \"kb-standard-20\", title: \"Standardpass KB 20\", detail: \"20 min AMRAP · 20 kg\", intent: \"Puls och funktionell helkroppsstyrka utan viktplock.\" },\n alternatives: [\n { template_id: \"run-zone-2\", title: \"Lugn löpning\", detail: \"30 min · zon 2\" },\n { template_id: \"core-stability\", title: \"Core & stabilitet\", detail: \"15 min AMRAP\" },\n ],\n rationale: \"Ett enkelt förstaval som matchar preferensen för korta, tydliga pass. Välj zon 2 om kroppen känns sliten.\",\n model: \"fallback\",\n };\n}\n",[159],"05fc53f1-c769-48ae-a055-b36bb01d9c83","daily.ts","010cf9ea-9e72-11f1-af07-1607ee4eb77e",["D",1787434790613],"interval","import { ValTownOpenAI } from \"https://esm.town/v/std/openai/main.ts\";\nimport { fallbackRecommendation, recommendationContext, saveRecommendation } from \"./db.ts\";\n\ntype Interval = { lastRunAt?: Date };\n\nexport default async function dailyRecommendation(interval: Interval) {\n const context = await recommendationContext();\n const since = interval.lastRunAt || new Date(Date.now() - 24 * 60 * 60 * 1000);\n const newSessions = (context.sessions as Array>)\n .filter((session) => new Date(String(session.completed_at)).getTime() > since.getTime());\n console.log(`Generating recommendation; ${newSessions.length} new session(s) since ${since.toISOString()}`);\n\n const allowedIds = new Set((context.templates as Array>).map((template) => String(template.id)));\n try {\n const openai = new ValTownOpenAI({});\n const response = await openai.responses.create({\n model: \"gpt-5.4-nano\",\n instructions: `Du är Jonas personliga träningscoach. Svara på svenska och välj bara pass från listan.\nJonas föredrar korta tydliga pass på 15–20 minuter, AMRAP/EMOM, en kettlebell (oftast 20 kg), funktionell styrka och puls.\nPress är en svag länk. Undvik clean-rack om handleden gör ont och thruster/press om nedre högra ryggen nyper.\nAlla pass ska inte vara högintensiva; ge ett lugnt alternativ när återhämtning är rimlig.\nDet här är en rekommendation, inte en AI-chatt. Motiveringen ska vara konkret och högst två meningar.`,\n input: JSON.stringify({\n today: new Date().toISOString().slice(0, 10),\n new_sessions_since_last_run: newSessions,\n recent_sessions: context.sessions,\n available_templates: context.templates,\n }),\n text: {\n format: {\n type: \"json_schema\",\n name: \"daily_recommendation\",\n strict: true,\n schema: {\n type: \"object\",\n additionalProperties: false,\n required: [\"first_choice\", \"alternatives\", \"rationale\"],\n properties: {\n first_choice: {\n type: \"object\",\n additionalProperties: false,\n required: [\"template_id\", \"title\", \"detail\", \"intent\"],\n properties: {\n template_id: { type: \"string\" },\n title: { type: \"string\" },\n detail: { type: \"string\" },\n intent: { type: \"string\" },\n },\n },\n alternatives: {\n type: \"array\",\n minItems: 2,\n maxItems: 2,\n items: {\n type: \"object\",\n additionalProperties: false,\n required: [\"template_id\", \"title\", \"detail\"],\n properties: {\n template_id: { type: \"string\" },\n title: { type: \"string\" },\n detail: { type: \"string\" },\n },\n },\n },\n rationale: { type: \"string\" },\n },\n },\n },\n },\n });\n const parsed = JSON.parse(response.output_text || \"{}\");\n const ids = [parsed.first_choice?.template_id, ...(parsed.alternatives || []).map((item: Record) => item.template_id)];\n if (!ids.every((id) => allowedIds.has(String(id)))) throw new Error(\"Model selected an unknown workout template\");\n return await saveRecommendation({\n date: new Date().toISOString().slice(0, 10),\n first_choice: parsed.first_choice,\n alternatives: parsed.alternatives,\n rationale: parsed.rationale,\n based_on_session_id: newSessions.at(-1)?.id ? String(newSessions.at(-1)?.id) : null,\n model: \"gpt-5.4-nano\",\n });\n } catch (error) {\n console.error(\"Recommendation generation failed; saving deterministic fallback\", error);\n const fallback = fallbackRecommendation();\n return await saveRecommendation({\n date: fallback.date,\n first_choice: fallback.first_choice,\n alternatives: fallback.alternatives,\n rationale: fallback.rationale,\n based_on_session_id: newSessions.at(-1)?.id ? String(newSessions.at(-1)?.id) : null,\n model: \"fallback\",\n });\n }\n}\n",[166],"94507e90-1e5e-45fd-9331-3b5f8d8f0898","README.md","01a02b61-7568-77b9-9da3-bab9ae8201fe",13,["D",1787434833122],"# Jonas träning\n\nMobil-first personlig träningsapp i Val Town. React-frontenden, Hono-API:t, SQLite-databasen och den dagliga rekommendations-cronen ligger i samma val.\n\n## V1\n\n- Home med dagens förstaval, två alternativ och kort motivering.\n- Workouts med träningsbibliotek från den befintliga träningsloggen.\n- Workout mode för AMRAP, EMOM, på tid och öppna pass, med timer och varv/laps.\n- History som blandar officiell Google Sheet-historik och nya `pending_sync`-pass.\n- Progress för frekvens, kettlebellbelastning, löpning, standardpass samt framtida pull-ups/toes-to-bar.\n- Val Town-inloggning och ägarkontroll för `jonasolof`.\n\n## Hybrid med Google Sheet\n\nOfficiell historik är fortsatt Google Sheet `1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU`. Val Town behandlar arket som read-only. Nya app-pass sparas i `sessions` med `source = 'val_town'` och `sync_status = 'pending_sync'`.\n\nChatGPT kan läsa nya pass direkt via Val Town-integrationen:\n\n```sql\nSELECT * FROM sessions\nWHERE processed_at IS NULL\nORDER BY completed_at ASC;\n```\n\nEfter coaching/synk kan samma integration sätta `processed_at` och vid Sheet-synk även `sync_status = 'synced'`.\n\n## Daglig rekommendation\n\n`daily.ts` körs varje dag via en Val Town interval-trigger. Den använder `interval.lastRunAt` för att identifiera nya pass, läser de 14 senaste sessionerna och skriver en strukturerad rad i `daily_recommendations`. Den använder Val Towns OpenAI-proxy med `gpt-5.4-nano` och faller tillbaka till en deterministisk rekommendation om LLM-anropet misslyckas.\n\nCron kör i UTC. Schemat är `15 5 * * *`, ungefär 07:15 svensk sommartid och 06:15 vintertid.\n\n## Datamodell\n\n- `workout_templates` – passupplägg och standardpass.\n- `sessions` – genomförda pass, källa, syncstatus och meningsfulla resultat.\n- `laps` – varv/minuter med elapsed time.\n- `performance_entries` – utbyggbart för exempelvis pull-ups och toes-to-bar.\n- `daily_recommendations` – förstaval, alternativ, motivering och modell.\n- `sync_state` – Google Sheet-id och hybridinställningar.\n",[173],"3d10ffed-dc9a-417d-98cc-0a26154033e0","CHANGELOG.md","01a02b61-7568-77b9-9da3-b61964261763",["D",1787434202328],"# Changelog\n\n## 2026-07-30 — Immutable asset caching\n\nFrontend files are now served at version-addressed URLs\n(`/__immutable/45/frontend/index.tsx`) with\n`Cache-Control: public, max-age=31536000, immutable`, so repeat visits load the\nwhole client graph from the browser cache — roughly 3× faster (~665ms → ~157ms\nmeasured). Publishing your val bumps its version, which changes every URL, so\ncaches invalidate automatically. Old-version URLs return 404 after a publish\n(like Next.js build assets); a reload picks up the new version.\n\nWhat changed in the template:\n\n- `frontend/index.html` → [`frontend/root.tsx`](/frontend/root.tsx): the HTML\n shell is now JSX and stamps asset URLs with `immutableFileUrl()`\n- [`index.ts`](/index.ts): serves `Root()` at `/`, and one\n `app.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path))` route\n serves all frontend files\n\n### Upgrading an existing remix\n\nYour copy of this template doesn't update automatically. Two options:\n\n**Minimal (most of the benefit):** point both routes at `serveImmutableFile` —\nyour existing bare URLs redirect into versioned space, the new route serves\nthem, and the whole module graph gets cached (costs one redirect per page view):\n\n```ts\nimport { serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\n\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\napp.get(\"/frontend/**/*\", (c) => serveImmutableFile(c.req.path)); // was serveFile\n```\n\n**Full upgrade (also removes the redirect):** three self-contained steps —\nno other files needed. Adjust the ``, favicon, and body of `Root()` to\nmatch your app's existing `index.html`, and stamp anything else your shell\nreferences directly (images, css) with `immutableFileUrl()`.\n\n1. Create `frontend/root.tsx`:\n\n```tsx\n/** @jsxImportSource npm:hono@4/jsx */\nimport { raw } from \"npm:hono@4/html\";\nimport { immutableFileUrl } from \"https://esm.town/v/std/utils/index.ts\";\n\n// The HTML shell for the app. It is never cached, so immutableFileUrl can stamp\n// the current val version into each asset URL — the browser caches those\n// immutably, and publishing the val changes the URLs, refetching exactly once.\nexport function Root() {\n return (\n <>\n {raw(\"<!DOCTYPE html>\")}\n <html lang=\"en\">\n <head>\n <meta charSet=\"UTF-8\" />\n <meta name=\"viewport\" content=\"width=device-width, initial-scale=1.0\" />\n <title>React Hono Val Town Starter\n

Diff · v26