`, 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",{"_339":340,"_341":342},"routes/_app.x.$handle.$name",{"_100":99,"_32":45,"_108":90,"_27":109,"_13":14,"_110":-5,"_11":111,"_112":113,"_114":115,"_116":117,"_118":119,"_20":-5,"_120":-5,"_121":-5,"_122":25,"_123":124,"_125":59,"_126":-5,"_127":-5,"_128":129},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_43":44,"_32":45,"_38":46,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":71,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":83,"_84":85,"_86":87,"_88":25},"version",39,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":25,"_27":28,"_29":28},"file",{"_30":31,"_32":28,"_33":34,"_35":37,"_38":39,"_40":14,"_41":42,"_24":25},"previous",{"_30":31,"_32":28,"_33":34,"_35":36},"deleted",false,"deletedHere","path","db.ts","latestPath","fileId","fde5ebb4-9e71-11f1-9141-1607ee4eb77e","name","fileType","script","content","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 coach_state (\n key TEXT PRIMARY KEY, value_json TEXT NOT NULL,\n updated_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 ('training_primary_source', 'val_town')\" },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('recommendation_owner', 'chatgpt_project_chat')\" },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('legacy_sheet_ids', ?)\", args: [\"1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU,1_QBlXws3llrLcIfdwR0CC33gSF_HMqFM5Pf8Kqf9PoA\"] },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('legacy_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 [sessionResult, recommendation, coachStateResult] = await Promise.all([\n 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 sqlite.execute(\"SELECT * FROM daily_recommendations ORDER BY for_date DESC LIMIT 1\"),\n sqlite.execute(\"SELECT value_json, updated_at FROM coach_state WHERE key = 'current' LIMIT 1\"),\n ]);\n const coachStateRow = (coachStateResult.rows as Array>)[0];\n return {\n generated_at: new Date().toISOString(),\n primary_source: \"val_town\",\n legacy_history: { mode: \"read_only_import\" },\n new_sessions: sessionResult.rows,\n coach_state: coachStateRow ? {\n ...json(String(coachStateRow.value_json || \"\"), {}),\n updated_at: coachStateRow.updated_at,\n } : null,\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","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 coach_state (\n key TEXT PRIMARY KEY, value_json TEXT NOT NULL,\n updated_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 ('training_primary_source', 'val_town')\" },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('recommendation_owner', 'chatgpt_project_chat')\" },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('legacy_sheet_ids', ?)\", args: [\"1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU,1_QBlXws3llrLcIfdwR0CC33gSF_HMqFM5Pf8Kqf9PoA\"] },\n { sql: \"INSERT OR IGNORE INTO sync_state(key, value) VALUES ('legacy_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 [sessionResult, recommendation, coachStateResult] = await Promise.all([\n 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 sqlite.execute(\"SELECT * FROM daily_recommendations ORDER BY for_date DESC LIMIT 1\"),\n sqlite.execute(\"SELECT value_json, updated_at FROM coach_state WHERE key = 'current' LIMIT 1\"),\n ]);\n const coachStateRow = (coachStateResult.rows as Array>)[0];\n return {\n generated_at: new Date().toISOString(),\n primary_source: \"val_town\",\n legacy_history: { mode: \"read_only_import\" },\n new_sessions: sessionResult.rows,\n coach_state: coachStateRow ? {\n ...json(String(coachStateRow.value_json || \"\"), {}),\n updated_at: coachStateRow.updated_at,\n } : null,\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 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","createdAt",["D",1787437870810],"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",{"_100":99,"_107":103},"org",{"_100":99,"_101":-5,"_102":103,"_18":55,"_104":105,"_106":25},"branch",{"_13":89,"_32":90,"_43":42,"_91":44,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":-5,"_97":45,"_98":99},"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",{"_43":44,"_32":45,"_38":334,"_47":-5,"_48":25,"_49":50,"_51":50,"_52":53,"_54":-5,"_18":55,"_56":57,"_58":59,"_60":-5,"_61":-5,"_62":63,"_64":65,"_66":67,"_68":69,"_70":335,"_72":-5,"_73":74,"_75":74,"_76":77,"_78":77,"_79":77,"_80":74,"_81":74,"_82":336,"_84":337,"_86":338,"_88":25},"tree",[199,212,213,214,215,216,217],"files",[199,200,201,202,203,204,205,206,207,208,209,210,211,212,213,214,215,216,217],"counts",{"_188":63,"_189":144,"_190":63,"_191":192,"_193":194},"contents",[130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_43":182,"_32":183,"_30":184,"_140":-5,"_41":42,"_40":144,"_142":59,"_38":185,"_13":63,"_33":186,"_35":-5,"_24":25,"_146":-5,"_27":187},{"_43":176,"_32":177,"_30":178,"_140":-5,"_41":42,"_40":144,"_142":25,"_38":179,"_13":63,"_33":20,"_35":180,"_24":25,"_146":-5,"_27":181},{"_43":168,"_32":169,"_30":170,"_140":-5,"_41":42,"_40":171,"_142":25,"_38":172,"_13":173,"_33":20,"_35":174,"_24":25,"_146":-5,"_27":175},{"_43":161,"_32":162,"_30":163,"_140":-5,"_41":42,"_40":164,"_142":25,"_38":165,"_13":144,"_33":34,"_35":166,"_24":25,"_146":-5,"_27":167},{"_43":157,"_32":28,"_30":31,"_140":-5,"_41":42,"_40":14,"_142":59,"_38":158,"_13":159,"_33":34,"_35":37,"_24":25,"_146":-5,"_27":160},{"_43":148,"_32":149,"_30":57,"_140":-5,"_41":42,"_40":150,"_142":59,"_38":151,"_13":152,"_33":153,"_35":154,"_24":25,"_146":155,"_27":156},{"_43":137,"_32":138,"_30":139,"_140":-5,"_41":42,"_40":141,"_142":59,"_38":143,"_13":144,"_33":34,"_35":145,"_24":25,"_146":-5,"_27":147},"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",[138],"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",[149],"7ef95792-9656-447b-9daa-2fff1d85865f",["D",1787437870810],4,[28],"ba5504f5-efab-4e66-bd59-6d855e962de7","daily.ts","010cf9ea-9e72-11f1-af07-1607ee4eb77e",31,["D",1787436168773],"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",[162],"df2e4fa2-381a-4f4b-9597-ef90b3f7d8eb","README.md","01a02b61-7568-77b9-9da3-bab9ae8201fe",35,["D",1787436209523],5,"# Jonas träning\n\nMobil-first personlig träningsapp i Val Town. React-frontenden, Hono-API:t, SQLite-databasen och koden för den dagliga rekommendationen ligger i samma val.\n\n## V1\n\n- Home med övningar och reps direkt för förstaval och alternativ, utfällbar motivering och info per övning.\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 kommer från Google Sheets `1fg2vYWJwAx3NY9Tv2usMpCO-KoeDZnsca7_XtSngJbU` och träningsloggen i `1_QBlXws3llrLcIfdwR0CC33gSF_HMqFM5Pf8Kqf9PoA`. Femton unika pass från juni–augusti 2026 är importerade som `official`. Val Town behandlar arken 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` är färdig för en daglig Val Town interval-trigger. Den använder `interval.lastRunAt`, läser de 14 senaste sessionerna och skriver en strukturerad rad i `daily_recommendations` via Val Towns OpenAI-proxy.\n\nFilen är tillfälligt satt till `script` och körs därför inte automatiskt. Innan den återaktiveras behöver ägaren uttryckligen godkänna att träningshistorik skickas från Val Town till OpenAI för att skapa rekommendationen. Det planerade UTC-schemat är `15 5 * * *`.\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",[169],"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 · v39