[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8},"actionData","errors","root",{"_106":107,"_108":109},"routes/embed.x.$handle.$name.$",{"_9":10,"_11":12,"_13":14,"_15":16,"_17":18,"_19":20,"_21":-5},"handle","georgesilva","name","rota-cafezinho","path","main.ts","project",{"_22":46,"_11":12,"_33":47,"_48":-5,"_49":42,"_50":51,"_52":51,"_53":54,"_55":-5,"_56":57,"_58":25,"_59":32,"_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":42},"file",{"_22":23,"_11":14,"_24":25,"_26":-5,"_27":28,"_29":30,"_31":32,"_33":34,"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_13":45},"permalink","https://www.val.town/x/georgesilva/rota-cafezinho/code/main.ts","extension","id","3f255b8f-e2be-4788-80b8-d4597b947502","fileId","f2760b40-a08a-11f1-9ef4-1607ee4eb77e","parentId","branchId","648fea8f-fa1f-4be2-b29b-856fd24106c4","branchVersion",11,"latest",true,"createdAt",["D",1787878049098],"version",3,"fileType","http","content","import { sqlite } from \"https://esm.town/v/std/sqlite/main.ts\";\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { readFile } from \"https://esm.town/v/std/utils/index.ts\";\n\n// ROTA DO CAFEZINHO — persistência 100% no servidor (Val Town)\n//\n// Para nunca mais perder memória por sobrescrita, cada café visitado e cada\n// café custom é guardado numa LINHA PRÓPRIA do SQLite (nada de um blob JSON\n// único que um POST possa substituir inteiro):\n// - chave \"visit:\" → dados da visita daquele café (nota, data, fav...)\n// - chave \"custom:\" → um café custom por linha\n// - chave \"meta\" → contadores/lixo (ex.: lastBackupCount)\n//\n// Os POSTs fazem MERGE no servidor: o que já existe nunca é apagado por um\n// save vindo do cliente. Fotos continuam no blob storage (\"cafe:\").\n\nawait sqlite.execute(`CREATE TABLE IF NOT EXISTS kv(\n k TEXT PRIMARY KEY,\n v TEXT NOT NULL\n)`);\n\nasync function getState(): Promise<{ visited: Record; custom: unknown[] }> {\n const visited: Record = {};\n const custom: unknown[] = [];\n const res = await sqlite.execute({\n sql: \"SELECT k, v FROM kv WHERE k LIKE 'visit:%' OR k LIKE 'custom:%'\",\n });\n const rows = (res.rows ?? []) as unknown as Array<{ k: string; v: string }>;\n for (const r of rows) {\n if (r.k.startsWith(\"visit:\")) {\n visited[r.k.slice(\"visit:\".length)] = JSON.parse(r.v);\n } else if (r.k.startsWith(\"custom:\")) {\n custom[Number(r.k.slice(\"custom:\".length))] = JSON.parse(r.v);\n }\n }\n // custom foi gravado com índices; elimina buracos (nomes vazios não são cafés)\n return { visited, custom: custom.filter(Boolean) };\n}\n\nasync function getMeta(): Promise> {\n const res = await sqlite.execute({ sql: \"SELECT v FROM kv WHERE k = 'meta'\" });\n const rows = (res.rows ?? []) as unknown as Array<{ v: string }>;\n if (!rows.length) return {};\n try {\n return JSON.parse(rows[0].v) as Record;\n } catch {\n return {};\n }\n}\n\nasync function putMeta(m: Record) {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO kv(k, v) VALUES ('meta', ?)\",\n args: [JSON.stringify(m)],\n });\n}\n\nfunction json(data: unknown, status = 200): Response {\n return new Response(JSON.stringify(data), {\n status,\n headers: { \"Content-Type\": \"application/json; charset=utf-8\" },\n });\n}\n\nasync function storePhotoDataUrl(id: string, dataUrl: string): Promise {\n const key = \"cafe:\" + id;\n await blob.set(key, dataUrl);\n return key;\n}\n\nasync function readPhoto(key: string): Promise<{ mime: string; bytes: Uint8Array } | null> {\n let raw: unknown;\n try {\n // blob.get retorna um Response — precisamos de .text() para pegar o\n // dataURL (ou os bytes, se gravado em binário).\n const res = await blob.get(key);\n raw = await res.text();\n } catch {\n return null;\n }\n const dataUrl = raw;\n if (dataUrl === null || dataUrl === undefined) return null;\n const m = String(dataUrl).match(/^data:(image\\/[a-zA-Z0-9.+-]+);base64,(.+)$/);\n if (!m) {\n // se alguém gravou em formato binário inesperado, devolve como jpeg\n const bytes = typeof dataUrl === \"string\" ? new TextEncoder().encode(dataUrl) : dataUrl as Uint8Array;\n return { mime: \"image/jpeg\", bytes };\n }\n const b64 = m[2];\n const bin = atob(b64);\n const bytes = new Uint8Array(bin.length);\n for (let i = 0; i < bin.length; i++) bytes[i] = bin.charCodeAt(i);\n return { mime: m[1], bytes };\n}\n\n// Salva UMA visita numa linha própria (nunca toca nas outras).\nasync function upsertVisit(id: string, visit: Record) {\n await sqlite.execute({\n sql: \"INSERT OR REPLACE INTO kv(k, v) VALUES (?, ?)\",\n args: [\"visit:\" + id, JSON.stringify(visit)],\n });\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 // Estado completo (montado das linhas) -> GET /api/state\n if (path === \"/api/state\" && req.method === \"GET\") {\n const { visited, custom } = await getState();\n const meta = await getMeta();\n return json({\n visited,\n custom,\n lastBackupCount: meta.lastBackupCount || 0,\n });\n }\n\n // MERGE do estado (usado ao editar cafés custom) -> POST /api/state\n // Só adiciona/atualiza o que vier; NUNCA apaga visitas existentes.\n if (path === \"/api/state\" && req.method === \"POST\") {\n const body = await req.json();\n const incomingVisited = (body.visited && typeof body.visited === \"object\"\n ? body.visited : {}) as Record;\n const incomingCustom = Array.isArray(body.custom) ? body.custom : [];\n\n for (const [id, visit] of Object.entries(incomingVisited)) {\n if (!visit || typeof visit !== \"object\") continue;\n await upsertVisit(id, visit as Record);\n }\n\n // custom é o array inteiro reenviado; para evitar apagar, substituímos\n // cada índice. Como o frontend sempre envia o array completo que tem,\n // e o cache de custom é pequeno, gravamos cada item por linha.\n // (Se quiser tolerância total a \"array vazio vindo de outro aparelho\",\n // poderíamos fazer merge por nome — mas custom é raro de editar.)\n await sqlite.execute({ sql: \"DELETE FROM kv WHERE k LIKE 'custom:%'\" });\n incomingCustom.forEach((c, i) => {\n if (!c) return;\n sqlite.execute({\n sql: \"INSERT OR REPLACE INTO kv(k, v) VALUES (?, ?)\",\n args: [\"custom:\" + i, JSON.stringify(c)],\n });\n });\n\n const meta = await getMeta();\n if (body.lastBackupCount != null) meta.lastBackupCount = body.lastBackupCount;\n await putMeta(meta);\n\n const { visited, custom } = await getState();\n return json({\n visited,\n custom,\n lastBackupCount: meta.lastBackupCount || 0,\n });\n }\n\n // Upsert de UMA visita -> POST /api/visit body:{ id, visit }\n if (path === \"/api/visit\" && req.method === \"POST\") {\n const { id, visit } = await req.json();\n if (!id) return json({ error: \"missing id\" }, 400);\n const v = { ...(visit || {}) } as Record;\n let photoKey = String(v.photo_key || \"\");\n if (v.photo_base64) {\n photoKey = await storePhotoDataUrl(id, String(v.photo_base64));\n }\n delete v.photo_base64;\n v.photo_key = photoKey;\n await upsertVisit(id, v);\n return json({ ok: true, photo_key: photoKey });\n }\n\n // Foto salva no blob -> GET /api/photo/:key\n const photoMatch = path.match(/^\\/api\\/photo\\/(.+)$/);\n if (photoMatch && req.method === \"GET\") {\n const key = decodeURIComponent(photoMatch[1]);\n const photo = await readPhoto(key);\n if (!photo) return json({ error: \"not found\" }, 404);\n return new Response(photo.bytes, {\n headers: { \"Content-Type\": photo.mime },\n });\n }\n\n if (path.startsWith(\"/api/\")) return json({ error: \"not found\" }, 404);\n\n // Tudo o mais: serve o app\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","deleted",false,"label","cafezinho",[14],"da624f13-a5f1-404c-92db-414292fdbfcb",["D",1787665405811],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Roteiro de cafés Recife & RMR — SQLite + fotos no servidor","imageUrl","userId","2291e0ad-6d97-42d7-8b6a-d3c745f6a4a7","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","01a038ef-1877-710b-a1c3-38ad74a0f1da","tursoName","da624f13a5f1404c92db414292fdbfcb","tursoHostname","da624f13a5f1404c92db414292fdbfcb-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789485645684],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_9":10,"_105":101},"org",{"_9":10,"_98":99,"_100":101,"_56":57,"_102":103,"_104":42},"branch",{"_35":30,"_11":89,"_22":28,"_90":46,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":-5,"_96":12,"_97":10},"isOwned","main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","GEORGE SILVA","avatar","https://lh3.googleusercontent.com/a/ACg8ocIeEEVfRdLN2T6U-gLIUimrkgRtwJd4u6YQ9B4lD7CLOyYJ0SakDg=s96-c","tier","free","canRestrictVals","profileImageUrl","ctx",{"_82":-5,"_139":140,"_141":142,"_143":144,"_145":42,"_146":42,"_147":42,"_148":32,"_149":-5,"_150":-7,"_151":-7,"_152":63,"_153":42,"_154":42,"_155":-5,"_156":42,"_157":42,"_158":42,"_159":-5},"ENV",{"_110":111,"_112":113,"_114":89,"_115":116,"_117":118,"_119":120,"_121":122,"_123":124,"_125":126,"_127":128,"_129":130,"_131":132,"_133":134,"_135":136,"_137":138},"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","orgs",[],"preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesCloseBrackets","preferencesChatPanelState","preferencesDprint","preferencesDenofmt","notificationCount","flagDenols","isBusinessOrgMember","businessOrgHandle","isBusinessOrgAdmin","isHigherTownieTier","navCollapsed","currentOrgId"]