`, 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

[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_261":262,"_263":264},"routes/_app.x.$handle.$name",{"_98":97,"_32":44,"_106":88,"_27":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":26,"_121":122,"_123":24,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_42":43,"_32":44,"_37":45,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":26},"version",3,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":26,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":36,"_37":38,"_39":14,"_40":41,"_23":26},"previous","deleted",true,"deletedHere",false,"path","daily.ts","latestPath","fileId","010cf9ea-9e72-11f1-af07-1607ee4eb77e","name","fileType","interval","content","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","createdAt",["D",1787434790613],"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","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",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":54,"_102":103,"_104":26},"branch",{"_13":87,"_32":88,"_42":41,"_89":43,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":44,"_96":97},"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",{"_42":43,"_32":44,"_37":256,"_46":-5,"_47":26,"_48":49,"_50":49,"_51":52,"_53":-5,"_18":54,"_55":56,"_57":24,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":257,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":258,"_82":259,"_84":260,"_86":26},"tree",[184,191,192,193,194,195],"files",[184,185,186,187,188,189,190,191,192,193,194,195],"counts",{"_174":61,"_175":137,"_176":61,"_177":178,"_179":180},"contents",[128,129,130,131,132,133],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_42":168,"_32":169,"_30":170,"_136":-5,"_40":41,"_39":137,"_138":24,"_37":171,"_13":61,"_33":172,"_35":-5,"_23":26,"_142":-5,"_27":173},{"_42":162,"_32":163,"_30":164,"_136":-5,"_40":41,"_39":137,"_138":26,"_37":165,"_13":61,"_33":20,"_35":166,"_23":26,"_142":-5,"_27":167},{"_42":156,"_32":157,"_30":158,"_136":-5,"_40":41,"_39":137,"_138":26,"_37":159,"_13":61,"_33":20,"_35":160,"_23":26,"_142":-5,"_27":161},{"_42":153,"_32":28,"_30":31,"_136":-5,"_40":41,"_39":14,"_138":26,"_37":154,"_13":61,"_33":34,"_35":36,"_23":26,"_142":-5,"_27":155},{"_42":145,"_32":146,"_30":147,"_136":-5,"_40":41,"_39":148,"_138":26,"_37":149,"_13":61,"_33":150,"_35":151,"_23":26,"_142":-5,"_27":152},{"_42":134,"_32":135,"_30":56,"_136":-5,"_40":41,"_39":137,"_138":26,"_37":139,"_13":61,"_33":140,"_35":141,"_23":26,"_142":143,"_27":144},"a3009b78-4c38-4233-b0b2-0bfb3e879612","index.ts","parentId",1,"latest",["D",1787434202328],"http","import { parseVal, serveImmutableFile } from \"https://esm.town/v/std/utils/index.ts\";\nimport { Hono } from \"npm:hono\";\nimport { Root } from \"./frontend/root.tsx\";\n\nconst app = new Hono();\n\n// Serve the (never-cached) HTML shell at the root /\napp.get(\"/\", (c) => c.html(Root()));\n\n// Serve frontend files at the version-addressed URLs Root() stamps, cached immutably\napp.get(\"/__immutable/*\", (c) => serveImmutableFile(c.req.path));\n\n// View source redirect\napp.get(\"/source\", (c) => c.redirect(parseVal().links.self.val));\n\n// Add your API routes here\n// app.get(\"/api/data\", c => c.json({ hello: \"world\" }));\n\n// Unwrap and rethrow Hono errors as the original error\n// If you delete this, all errors will be \"Internal Server Error\"\napp.onError((err) => Promise.reject(err));\n\n// HTTP vals expect an exported \"fetch handler\"\n// This is how you \"run the server\" in Val Town with Hono\nexport default app.fetch;\n","label","jonas-training",[135],"fd92a765-e4ed-403d-8427-4d57bcb5c1fc","db.ts","fde5ebb4-9e71-11f1-9141-1607ee4eb77e",2,["D",1787434785320],"script","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",[146],"05fc53f1-c769-48ae-a055-b36bb01d9c83",["D",1787434790613],[28],"31dd3017-5223-465e-b5eb-ed8d51f2bda4","README.md","01a02b61-7568-77b9-9da3-bab9ae8201fe",["D",1787434202328],"# 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[\"root.tsx\"]\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 root.tsx ← HTML shell (stamps immutable asset URLs)\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/root.tsx`** is the HTML shell — it loads Twind and stamps\n immutable asset URLs for the favicon and 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\nTemplate updates and upgrade paths for existing remixes: [CHANGELOG.md](/CHANGELOG.md)\n",[157],"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 · v3