[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_225":226,"_227":228},"routes/_app.x.$handle.$name",{"_104":103,"_37":49,"_113":94,"_32":114,"_13":14,"_115":-5,"_11":116,"_117":118,"_119":120,"_121":122,"_123":124,"_26":-5,"_125":-5,"_126":-5,"_127":30,"_128":129,"_130":63,"_131":-5,"_132":-5,"_133":134},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":18,"_19":-5},"project",{"_47":48,"_37":49,"_42":50,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":75,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":87,"_88":89,"_90":91,"_92":30},"version",26,"changes",[25],"aiChatInfo",{"_20":21,"_22":-5,"_23":-5,"_24":-5},"userId","aiChatMessageId","bfd7602d-f4c4-44cb-9631-ed553df4e9a7","aiChatThreadId","aiChatThreadUserId","aiChatThreadTitle",{"_26":27,"_28":-7,"_29":30,"_31":30,"_32":33,"_34":33},"file",{"_35":36,"_37":33,"_38":39,"_40":41,"_42":43,"_44":14,"_45":46,"_29":30},"previous","deleted",false,"deletedHere","path","restore.ts","latestPath","fileId","c4163e46-a251-11f1-9bb8-1607ee4eb77e","name","fileType","script","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\n// ─────────────────────────────────────────────────────────────────────────────\n// RESTORE — Treino App\n//\n// Restaura o banco a partir de um snapshot de backup feito pelo backup.ts.\n//\n// restoreFromBackup(key) -> repõe sessions e lasts no SQLite\n// listSnapshots() -> lista os snapshots disponíveis\n//\n// ⚠️ RESTORE SOBRESCREVE. Só rode quando tiver perdido dados de verdade.\n// Sessões que existam hoje e NÃO estejam no snapshot serão apagadas.\n// ─────────────────────────────────────────────────────────────────────────────\n\ntype Row = Record;\n\n/** Lista os snapshots disponíveis no blob (mais recentes primeiro). */\nexport async function listSnapshots(): Promise<\n { key: string; size: number; lastModified: string }[]\n> {\n const entries = await blob.list(\"backup/snapshot-\");\n return [...entries].sort((a, b) =>\n (b.key as string).localeCompare(a.key as string),\n );\n}\n\n/**\n * Restaura sessions + lasts de um snapshot, numa transação atômica.\n * Devolve um resumo do que foi restaurado.\n */\nexport async function restoreFromBackup(key: string) {\n const snap = await blob.getJSON(key);\n if (!snap || snap.format !== \"treino-app-backup\") {\n throw new Error(\"snapshot inválido ou em formato desconhecido: \" + key);\n }\n\n const sessions = Array.isArray(snap.sessions) ? snap.sessions : [];\n const lasts = Array.isArray(snap.lasts) ? snap.lasts : [];\n\n // Garante o schema (idempotente).\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions(\n key TEXT PRIMARY KEY, dia TEXT NOT NULL, data TEXT NOT NULL,\n timestamp TEXT NOT NULL, exercicios TEXT NOT NULL)`);\n await sqlite.execute(`CREATE TABLE IF NOT EXISTS lasts(\n exId TEXT PRIMARY KEY, kg TEXT NOT NULL, reps TEXT NOT NULL, data TEXT NOT NULL)`);\n\n // Replace completo numa transação atômica.\n const stmts: { sql: string; args: unknown[] }[] = [\n { sql: \"DELETE FROM sessions\", args: [] },\n { sql: \"DELETE FROM lasts\", args: [] },\n ];\n for (const s of sessions as Row[]) {\n stmts.push({\n sql: \"INSERT OR REPLACE INTO sessions(key, dia, data, timestamp, exercicios) VALUES (?,?,?,?,?)\",\n args: [\n String(s.key), String(s.dia), String(s.data), String(s.timestamp),\n JSON.stringify(s.exercicios ?? {}),\n ],\n });\n }\n for (const l of lasts as Row[]) {\n stmts.push({\n sql: \"INSERT OR REPLACE INTO lasts(exId, kg, reps, data) VALUES (?,?,?,?)\",\n args: [\n String(l.exId), String(l.kg ?? \"\"), String(l.reps ?? \"\"), String(l.data ?? \"\"),\n ],\n });\n }\n\n await sqlite.batch(stmts);\n console.log(`restaurado de ${key}: ${sessions.length} sessões, ${lasts.length} últimos`);\n return { sessions: sessions.length, lasts: lasts.length };\n}\n\n// ── Modo manual ──────────────────────────────────────────────────────────────\n// Sem ação automática. Para restaurar, descomente o bloco abaixo, aponte a KEY\n// (ou use snaps[0] para o mais recente) e rode o arquivo.\n// if (import.meta.main) {\n// const snaps = await listSnapshots();\n// if (!snaps.length) {\n// console.log(\"nenhum snapshot encontrado\");\n// } else {\n// console.log(\"snapshots disponíveis:\");\n// snaps.forEach((s, i) => console.log(` [${i}] ${s.key} (${s.size} bytes)`));\n// const KEY = snaps[0]?.key;\n// if (KEY) await restoreFromBackup(KEY);\n// }\n// }\n","createdAt",["D",1787860749093],"branchVersion","branchId","81c188c6-a711-4ce1-a9b3-f0f527b9418d","id","126d70d0-5c3e-481e-a052-003201b4ee6c","treino-app",["D",1787662269611],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Registro de treino com persistência em SQLite","imageUrl","2291e0ad-6d97-42d7-8b6a-d3c745f6a4a7","pinnedFileId","bea4cbbe-a083-11f1-a854-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","01a038ef-1877-710b-a1c3-38ad74a0f1da","tursoName","126d70d05c3e481ea052003201b4ee6c","tursoHostname","126d70d05c3e481ea052003201b4ee6c-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789571433983],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_104":103,"_112":108},"org",{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},"branch",{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"isOwned",28,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","georgesilva","handle","displayName","GEORGE SILVA","avatar","https://lh3.googleusercontent.com/a/ACg8ocIeEEVfRdLN2T6U-gLIUimrkgRtwJd4u6YQ9B4lD7CLOyYJ0SakDg=s96-c","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_47":48,"_37":49,"_42":220,"_51":-5,"_52":30,"_53":54,"_55":54,"_56":57,"_58":-5,"_19":59,"_60":61,"_62":63,"_64":-5,"_65":-5,"_66":67,"_68":69,"_70":71,"_72":73,"_74":221,"_76":-5,"_77":78,"_79":78,"_80":81,"_82":81,"_83":81,"_84":78,"_85":78,"_86":222,"_88":223,"_90":224,"_92":30},"tree",[195,196,197,198,199,200],"files",[195,196,197,198,199,200],"counts",{"_184":67,"_185":186,"_187":67,"_188":189,"_190":191},"contents",[135,136,137,138,139,140],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_47":177,"_37":178,"_35":179,"_142":-5,"_45":46,"_44":149,"_143":30,"_42":180,"_13":181,"_38":26,"_40":182,"_29":30,"_145":-5,"_32":183},{"_47":171,"_37":172,"_35":173,"_142":-5,"_45":46,"_44":149,"_143":63,"_42":174,"_13":67,"_38":26,"_40":175,"_29":30,"_145":-5,"_32":176},{"_47":164,"_37":165,"_35":166,"_142":-5,"_45":46,"_44":167,"_143":63,"_42":168,"_13":67,"_38":39,"_40":169,"_29":30,"_145":-5,"_32":170},{"_47":156,"_37":157,"_35":158,"_142":-5,"_45":46,"_44":159,"_143":63,"_42":160,"_13":161,"_38":26,"_40":162,"_29":30,"_145":-5,"_32":163},{"_47":147,"_37":148,"_35":61,"_142":-5,"_45":46,"_44":149,"_143":63,"_42":150,"_13":151,"_38":152,"_40":153,"_29":30,"_145":154,"_32":155},{"_47":141,"_37":33,"_35":36,"_142":-5,"_45":46,"_44":14,"_143":63,"_42":144,"_13":67,"_38":39,"_40":41,"_29":30,"_145":-5,"_32":146},"641c852b-99b8-4e30-a715-17093ce34037","parentId","latest",["D",1787860749093],"label",[33],"5ebe15bf-2fde-4acb-91cc-40067139f366","main.ts",22,["D",1787702669862],6,"http","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// ---- Esquema: sessões e \"último registro\" por exercício --------\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS sessions(\n key TEXT PRIMARY KEY,\n dia TEXT NOT NULL,\n data TEXT NOT NULL,\n timestamp TEXT NOT NULL,\n exercicios TEXT NOT NULL\n)`);\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS lasts(\n exId TEXT PRIMARY KEY,\n kg TEXT NOT NULL,\n reps TEXT NOT NULL,\n data TEXT NOT NULL\n)`);\n\ntype Row = Record;\n// std/sqlite já retorna cada linha como objeto, com as colunas como chaves.\nasync function queryRows(sql: string, args: unknown[] = []): Promise {\n const res = await sqlite.execute({ sql, args: args as never });\n return (res.rows ?? []) as unknown as Row[];\n}\n\nexport default async function handler(req: Request): Promise {\n const url = new URL(req.url);\n const path = url.pathname;\n try {\n // LISTAR sessões de um dia -> GET /api/sessions?day=A\n if (path === \"/api/sessions\" && req.method === \"GET\") {\n const day = url.searchParams.get(\"day\") ?? \"\";\n const rows = await queryRows(\n `SELECT key, data, timestamp, exercicios FROM sessions WHERE dia = ? ORDER BY timestamp`,\n [day]\n );\n const list = rows.map((r) => ({\n key: r.key,\n session: {\n dia: day,\n data: r.data,\n timestamp: r.timestamp,\n exercicios: JSON.parse(String(r.exercicios)),\n },\n }));\n return json(list);\n }\n\n // SALVAR sessão -> POST /api/sessions body: {dia, data, timestamp, exercicios}\n if (path === \"/api/sessions\" && req.method === \"POST\") {\n const body = await req.json();\n const key = \"sessao:\" + body.dia + \":\" + body.timestamp;\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO sessions(key, dia, data, timestamp, exercicios) VALUES (?,?,?,?,?)`,\n args: [key, body.dia, body.data, body.timestamp, JSON.stringify(body.exercicios ?? {})],\n });\n return json({ ok: true });\n }\n\n // SALVAR último registro de um exercício -> POST /api/last body:{exId,kg,reps,data}\n if (path === \"/api/last\" && req.method === \"POST\") {\n const body = await req.json();\n await sqlite.execute({\n sql: `INSERT OR REPLACE INTO lasts(exId, kg, reps, data) VALUES (?,?,?,?)`,\n args: [String(body.exId), String(body.kg ?? \"\"), String(body.reps ?? \"\"), String(body.data ?? \"\")],\n });\n return json({ ok: true });\n }\n\n // LER último registro -> GET /api/last/:exId\n const lastMatch = path.match(/^\\/api\\/last\\/(.+)$/);\n if (lastMatch && req.method === \"GET\") {\n const exId = decodeURIComponent(lastMatch[1]);\n const rows = await queryRows(`SELECT kg, reps, data FROM lasts WHERE exId = ?`, [exId]);\n if (rows.length === 0) return json(null);\n return json(rows[0]);\n }\n\n // Contagem para o painel técnico -> GET /api/status\n if (path === \"/api/status\") {\n const s = await queryRows(`SELECT COUNT(*) AS n FROM sessions`);\n const u = await queryRows(`SELECT COUNT(*) AS n FROM lasts`);\n return json({ sessao: s.length ? s[0].n : 0, ultimo: u.length ? u[0].n : 0 });\n }\n\n if (path.startsWith(\"/api/\")) return json({ error: \"not found\" }, 404);\n\n // Tudo o mais: serve o app (import.meta.url resolve o arquivo nesta val de\n // forma determinística, sem depender da env VALTOWN_ENTRYPOINT)\n const html = await readFile(\"frontend.html\", import.meta.url);\n return new Response(html, { headers: { \"Content-Type\": \"text/html; charset=utf-8\" } });\n } catch (err) {\n return json({ error: err instanceof Error ? err.message : String(err) }, 500);\n }\n}\n\nfunction json(data: unknown, status = 200) {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n","treino",[148],"07fe5793-2eec-41aa-ba93-584b6db43c92","frontend.html","e6b6f212-a083-11f1-b5f5-1607ee4eb77e",24,["D",1787703100592],13,"\n\n\n\n\nTreino — Registro\n\n\n\n

Registro de Treino

Sessão de hoje

\n \n

detalhes técnicos

carregando…

\n \n

\n Data da sessão:\n \n

\n \n

\n\n\n\n\n",[157],"e4f6e4d2-a807-4dd3-8841-b44c28b6264b","backup.ts","bf8630fc-a251-11f1-b78c-1607ee4eb77e",25,["D",1787860741433],"import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\n// ─────────────────────────────────────────────────────────────────────────────\n// BACKUP — Treino App\n//\n// Tira um instantâneo completo do banco (tabelas `sessions` e `lasts`) e grava\n// como um único documento JSON versionado no blob do projeto:\n//\n// backup/snapshot-.json\n//\n// Uso:\n// runBackup() -> tira e grava um snapshot (com retenção)\n//\n// Retenção: mantém os N snapshots mais recentes (padrão 30) e apaga os mais\n// antigos, para não estourar os 10 MB do plano free.\n// ─────────────────────────────────────────────────────────────────────────────\n\nconst BACKUP_PREFIX = \"backup/snapshot-\";\nconst DEFAULT_KEEP = 30;\n\ntype Row = Record;\n\n/** Lê todas as sessões, com o JSON de exercícios já deserializado. */\nasync function readSessions(): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT key, dia, data, timestamp, exercicios FROM sessions ORDER BY timestamp\",\n });\n const rows = (res.rows ?? []) as unknown as Row[];\n return rows.map((r) => ({\n key: r.key,\n dia: r.dia,\n data: r.data,\n timestamp: r.timestamp,\n exercicios: JSON.parse(String(r.exercicios)),\n }));\n}\n\n/** Lê todos os \"últimos registros\" por exercício. */\nasync function readLasts(): Promise {\n const res = await sqlite.execute({\n sql: \"SELECT exId, kg, reps, data FROM lasts ORDER BY exId\",\n });\n return (res.rows ?? []) as unknown as Row[];\n}\n\nfunction isoStamp(d = new Date()): string {\n return d.toISOString().replace(/[:]/g, \"-\").replace(/\\.\\d{3}Z$/, \"Z\");\n}\n\n/** Apaga os snapshots mais antigos, mantendo os K mais recentes. */\nasync function enforceRetention(keep: number) {\n const entries = await blob.list(BACKUP_PREFIX);\n if (entries.length <= keep) return 0;\n const sorted = [...entries].sort((a, b) =>\n (b.key as string).localeCompare(a.key as string)\n );\n let removed = 0;\n for (const e of sorted.slice(keep)) {\n await blob.delete(e.key as string);\n removed++;\n }\n return removed;\n}\n\n/** Cria e grava um snapshot; devolve a chave criada. */\nexport async function runBackup(keep = DEFAULT_KEEP): Promise {\n const sessions = await readSessions();\n const lasts = await readLasts();\n\n const snapshot = {\n format: \"treino-app-backup\",\n version: 1,\n createdAt: new Date().toISOString(),\n sessions,\n lasts,\n };\n\n const key = BACKUP_PREFIX + isoStamp() + \".json\";\n await blob.setJSON(key, snapshot);\n const removed = await enforceRetention(keep);\n console.log(`backup gravado: ${key} (${sessions.length} sessões, ${lasts.length} últimos); ${removed} antigos removidos`);\n return key;\n}\n\n// Permite rodar manualmente via `run_file`.\nif (import.meta.main) {\n await runBackup();\n}\n",[165],"b9c74496-d53f-458b-ab27-c5b8f38cd2e0","app.html","b58760f6-a0e1-11f1-ad3a-1607ee4eb77e",["D",1787702669862],"placeholder",[172],"ecd795e2-4455-42d1-8ae4-8ea2df53dbef","README.md","eb7ca6a2-a083-11f1-b41a-1607ee4eb77e",["D",1787702669862],2,"# Treino — Registro (Val Town)\n\nRegistro de treino de página única, com persistência em **SQLite no servidor** (Val Town), em vez de `localStorage`.\n\n## Arquivos\n- `main.ts` — endpoint HTTP: serve o app e expõe as APIs REST do banco.\n- `frontend.html` — interface (HTML/JS), idêntica ao app original.\n\n## APIs\n| Método | Rota | Descrição |\n|--------|------|-----------|\n| POST | `/api/sessions` | Salva uma sessão `{dia, data, timestamp, exercicios}` |\n| GET | `/api/sessions?day=A` | Lista as sessões de um dia |\n| POST | `/api/last` | Salva o último registro de um exercício `{exId, kg, reps, data}` |\n| GET | `/api/last/:exId` | Lê o último registro de um exercício |\n| GET | `/api/status` | Contagem de sessões e \"últimos\" (painel técnico) |\n\nAs chaves `sessao:DIA:timestamp` e `ultimo:exId` que antes viviam no `localStorage` agora são persistidas nas tabelas `sessions` e `lasts` do SQLite. O frontend chama esses endpoints via `fetch`. O visual, os cinco dias (A–E), o foco muscular, a edição de sessões, a data editável e a exportação/importação de texto (reserva manual) foram mantidos exatamente como no original.\n",[178],"pulls","branches",1,"forks","envVars",{"_192":67,"_194":67},"connections",{"_192":67,"_193":67},"count","unfilledCount","emptyCount",{"_47":177,"_37":178,"_35":179,"_142":-5,"_45":46,"_44":149,"_143":30,"_42":217,"_13":181,"_38":26,"_40":182,"_29":30,"_145":-5,"_202":218,"_32":219},{"_47":171,"_37":172,"_35":173,"_142":-5,"_45":46,"_44":149,"_143":63,"_42":214,"_13":67,"_38":26,"_40":175,"_29":30,"_145":-5,"_202":215,"_32":216},{"_47":164,"_37":165,"_35":166,"_142":-5,"_45":46,"_44":167,"_143":63,"_42":211,"_13":67,"_38":39,"_40":169,"_29":30,"_145":-5,"_202":212,"_32":213},{"_47":156,"_37":157,"_35":158,"_142":-5,"_45":46,"_44":159,"_143":63,"_42":208,"_13":161,"_38":26,"_40":162,"_29":30,"_145":-5,"_202":209,"_32":210},{"_47":147,"_37":148,"_35":61,"_142":-5,"_45":46,"_44":149,"_143":63,"_42":205,"_13":151,"_38":152,"_40":153,"_29":30,"_145":154,"_202":206,"_32":207},{"_47":141,"_37":33,"_35":36,"_142":-5,"_45":46,"_44":14,"_143":63,"_42":201,"_13":67,"_38":39,"_40":41,"_29":30,"_145":-5,"_202":203,"_32":204},["D",1787860749093],"children",[],[33],["D",1787702669862],[],[148],["D",1787703100592],[],[157],["D",1787860741433],[],[165],["D",1787702669862],[],[172],["D",1787702669862],[],[178],["D",1787662269611],["D",1789571433983],{"_104":103,"_112":108},{"_104":103,"_105":106,"_107":108,"_19":59,"_109":110,"_111":30},{"_13":93,"_37":94,"_47":46,"_95":48,"_96":-5,"_97":-5,"_98":-5,"_99":-5,"_100":-5,"_101":49,"_102":103},"ctx",{"_86":-5,"_132":258,"_259":260,"_261":262,"_263":30,"_264":30,"_265":30,"_266":63,"_267":-5,"_268":-7,"_269":-7,"_270":67,"_271":30,"_272":30,"_273":-5,"_274":30,"_275":30,"_276":30,"_277":-5},"ENV",{"_229":230,"_231":232,"_233":94,"_234":235,"_236":237,"_238":239,"_240":241,"_242":243,"_244":245,"_246":247,"_248":249,"_250":251,"_252":253,"_254":255,"_256":257},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","RENDER_GIT_COMMIT","e87eb04e707cf64e7e532c8e8ec395f209e17f15","RENDER_GIT_BRANCH","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","CLOUDFLARE_TURNSTILE_SITE_KEY","0x4AAAAAACtaIZJH7s9rBMZ6","GOOGLE_CLIENT_ID","875989696899-jtsqkhlbdv5jrlsk8631p7ipjg3c6o62.apps.googleusercontent.com","STRIPE_PUBLISHABLE_KEY","pk_live_51N2zvWEpZTTLipIkVEwXrUG9AT0yeOOEYxszarZT1jpsZV58Ly6wlg3SltZpHN26CUalOBmUSY7adQRQiSkCZz2500qSXNkf8Y","API_URL","https://api.val.town",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]

Diff · v26