[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_157":158,"_159":160},"routes/_app.x.$handle.$name",{"_11":12,"_13":14,"_15":16,"_18":19,"_17":-7,"_118":-5,"_20":119,"_22":120,"_121":122,"_123":124,"_25":125,"_24":-5,"_126":-5,"_127":-5,"_128":53,"_129":130,"_131":53,"_132":-5,"_133":-5,"_134":135},"routes/_app.x.$handle.$name.branch.$branch.code.$",{"_11":12,"_13":14,"_15":16,"_17":-7,"_18":19,"_20":21,"_22":23,"_24":-7,"_25":26,"_27":-5,"_28":-5,"_29":-5,"_30":-5,"_31":-5},"handle","matheus","name","matheus306","branchName","main","version","path","","project",{"_33":61,"_13":14,"_45":62,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":85,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":97,"_98":99,"_100":101,"_102":53},"tree",[56],"file","contents",[32],"upstream","pull","ahead","behind","envVars",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":55},"id","26902e74-0e41-45d9-be47-7faa53f2ce1b","main.ts","fileId","154f39ca-667a-11f1-bdcd-1607ee4eb77e","parentId","branchId","8ac61cc5-b883-456d-b6ca-99b709a6b8f5","branchVersion",35,"latest",true,"createdAt",["D",1789142089891],34,"fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\n// ── CONFIGURAÇÕES ─────────────────────────────────────────────────────────────\nconst API_URL =\n `https://www.tesourodireto.com.br/o/historico-rentabilidade/187?days=30`;\n\nconst MARKET_OPEN = { hour: 9, minute: 30 };\nconst MARKET_CLOSE = { hour: 18, minute: 0 };\n\nconst RECIPIENTS = [\n \"matheus306@gmail.com\",\n \"marioljunior84@gmail.com\",\n \"lucasmendes2105@gmail.com\",\n \"marquedson@gmail.com\",\n];\n\n// O e-mail de envio deve ser o mesmo e-mail que você usará para criar a conta no Brevo (ex: seu e-mail pessoal)\nconst EMAIL_SENDER = \"matheus306@gmail.com\";\n// ──────────────────────────────────────────────────────────────────────────────\n\nexport default async function (interval: Interval) {\n // 1. Validar Fuso Horário de Brasília (BRT)\n const now = new Date();\n const brtString = now.toLocaleString(\"en-US\", {\n timeZone: \"America/Sao_Paulo\",\n });\n const brtDate = new Date(brtString);\n\n const day = brtDate.getDay(); // 0 = Domingo, 6 = Sábado\n const hour = brtDate.getHours();\n const minute = brtDate.getMinutes();\n\n if (day === 0 || day === 6) {\n console.log(\"Fim de semana. Nenhuma ação.\");\n return;\n }\n\n const currentMinutes = hour * 60 + minute;\n const openMinutes = MARKET_OPEN.hour * 60 + MARKET_OPEN.minute;\n const closeMinutes = MARKET_CLOSE.hour * 60 + MARKET_CLOSE.minute;\n\n if (currentMinutes < openMinutes || currentMinutes >= closeMinutes) {\n console.log(\n `Fora do horário de mercado (${hour.toString().padStart(2, \"0\")}:${\n minute.toString().padStart(2, \"0\")\n } BRT). Nenhuma ação.`,\n );\n return;\n }\n\n // Formatar a data de hoje no padrão DD/MM/YYYY\n const dd = String(brtDate.getDate()).padStart(2, \"0\");\n const mm = String(brtDate.getMonth() + 1).padStart(2, \"0\");\n const yyyy = brtDate.getFullYear();\n const todayLabel = `${dd}/${mm}/${yyyy}`;\n const todayStr = `${yyyy}-${mm}-${dd}`;\n\n // 2. Buscar dados da API com mecanismo de Retentativa (Fallback)\n //\n // A tesourodireto.com.br está atrás de um Managed Challenge da Cloudflare\n // (confirmado 02/09/2026: header cf-mitigated=challenge, corpo \"Just a\n // moment...\" em toda tentativa) — nenhum fetch direto passa por isso.\n // Trocado de ScraperAPI pro FlareSolverr self-hosted em 11/09/2026 (a\n // conta gratuita do ScraperAPI estourou o crédito mensal, compartilhada\n // com outro projeto) — FlareSolverr roda num container Docker próprio,\n // resolve o challenge com Chromium de verdade sem custo por chamada, e\n // devolve o HTML/JSON puro dentro de solution.response (embrulhado em\n //

, ver extractJsonFromFlareSolverr abaixo). Precisa das env vars\n  // \"flaresolverr_url\", \"flaresolverr_user\" e \"flaresolverr_password\"\n  // configuradas no Val Town (mesmo padrão da env var \"brevo\" já usada\n  // abaixo).\n  const flaresolverrUrl = Deno.env.get(\"flaresolverr_url\");\n  const flaresolverrUser = Deno.env.get(\"flaresolverr_user\");\n  const flaresolverrPassword = Deno.env.get(\"flaresolverr_password\");\n  if (!flaresolverrUrl) {\n    console.error(\n      \"Variável de ambiente 'flaresolverr_url' não está configurada no Val Town.\",\n    );\n    return;\n  }\n\n  function extractJsonFromFlareSolverr(html: string): any {\n    const match = /]*>([\\s\\S]*?)<\\/pre>/i.exec(html || \"\");\n    return JSON.parse(match ? match[1] : html);\n  }\n\n  let data: any = null;\n  let idx = -1;\n  const maxRetries = 2;\n  const retryDelayMs = 3000;\n\n  for (let attempt = 1; attempt <= maxRetries; attempt++) {\n    console.log(\n      `Tentativa ${attempt} de buscar dados da API via FlareSolverr...`,\n    );\n    try {\n      const authHeader = flaresolverrUser\n        ? {\n          Authorization: \"Basic \" +\n            btoa(`${flaresolverrUser}:${flaresolverrPassword}`),\n        }\n        : {};\n      const response = await fetch(flaresolverrUrl, {\n        method: \"POST\",\n        headers: { \"Content-Type\": \"application/json\", ...authHeader },\n        body: JSON.stringify({\n          cmd: \"request.get\",\n          url: API_URL,\n          maxTimeout: 30000,\n        }),\n      });\n\n      if (!response.ok) {\n        const errorBody = await response.text().catch(() =>\n          \"\"\n        );\n        console.warn(\n          `Tentativa ${attempt} falhou com status HTTP ${response.status}.\\nCorpo (primeiros 2000 chars):\\n${\n            errorBody.slice(0, 2000)\n          }`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n          continue;\n        }\n        throw new Error(`Erro HTTP: ${response.status}`);\n      }\n\n      const outer = await response.json();\n      if (outer.status !== \"ok\") {\n        console.warn(\n          `Tentativa ${attempt}: FlareSolverr retornou status \"${outer.status}\": ${outer.message}`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n          continue;\n        }\n        throw new Error(`FlareSolverr falhou: ${outer.message}`);\n      }\n\n      data = extractJsonFromFlareSolverr(outer.solution?.response);\n      const labels = data?.TrsrBd?.label || [];\n      idx = labels.indexOf(todayLabel);\n\n      if (idx !== -1) {\n        console.log(`Dados encontrados!`);\n        break;\n      } else {\n        console.warn(\n          `Tentativa ${attempt}: Dados de hoje (${todayLabel}) ainda não constavam no JSON recebido.`,\n        );\n        if (attempt < maxRetries) {\n          await new Promise((r) => setTimeout(r, retryDelayMs));\n        }\n      }\n    } catch (err: any) {\n      console.warn(\n        `Tentativa ${attempt} falhou devido ao erro: ${err.message}`,\n      );\n      if (attempt === maxRetries) {\n        throw err;\n      }\n      await new Promise((r) => setTimeout(r, retryDelayMs));\n    }\n  }\n\n  if (idx === -1) {\n    console.log(\n      `Dados de hoje (${todayLabel}) indisponíveis na API após ${maxRetries} tentativas.`,\n    );\n    return;\n  }\n\n  const bond = data.TrsrBd;\n  const currentRate = bond.anulInvstmtRate[idx];\n  const currentRedRate = bond.anulRedRate[idx];\n  const untrInvstmtVal = bond.untrInvstmtVal[idx];\n  const untrRedVal = bond.untrRedVal[idx];\n  const bondName = bond.nm;\n\n  const timeStr = `${hour.toString().padStart(2, \"0\")}:${\n    minute.toString().padStart(2, \"0\")\n  }`;\n  console.log(`Taxa atual (${todayLabel} ${timeStr}): ${currentRate}% a.a.`);\n\n  // 3. Inicializar Tabela do SQLite (se não existir)\n  await sqlite.execute(`\n    CREATE TABLE IF NOT EXISTS tesouro_alert_state (\n      key TEXT PRIMARY KEY,\n      value TEXT\n    )\n  `);\n\n  const getVal = async (key: string): Promise => {\n    const res = await sqlite.execute({\n      sql: \"SELECT value FROM tesouro_alert_state WHERE key = :key\",\n      args: { key },\n    });\n    return res.rows[0]?.[0] ?? null;\n  };\n\n  const setVal = async (key: string, value: string) => {\n    await sqlite.execute({\n      sql:\n        \"INSERT OR REPLACE INTO tesouro_alert_state (key, value) VALUES (:key, :value)\",\n      args: { key, value },\n    });\n  };\n\n  // 4. Ler estado anterior\n  const lastRateRaw = await getVal(\"last-known-rate\");\n  const lastRedRateRaw = await getVal(\"last-known-red-rate\");\n  const lastInvValRaw = await getVal(\"last-known-inv-val\");\n  const lastRedValRaw = await getVal(\"last-known-red-val\");\n  const lastRunDate = await getVal(\"last-run-date\");\n\n  const lastRate = lastRateRaw ? parseFloat(lastRateRaw) : null;\n  const lastRedRate = lastRedRateRaw\n    ? parseFloat(lastRedRateRaw)\n    : currentRedRate;\n  const lastInvVal = lastInvValRaw ? parseFloat(lastInvValRaw) : untrInvstmtVal;\n  const lastRedVal = lastRedValRaw ? parseFloat(lastRedValRaw) : untrRedVal;\n\n  // ── Função auxiliar para enviar o e-mail via Brevo ────────────────────────\n  async function sendAlert(\n    isFirstRun: boolean,\n    prevRate: number,\n    prevRedRate: number,\n    prevInvVal: number,\n    prevRedVal: number,\n  ) {\n    const delta = currentRate - prevRate;\n    const taxaCaiu = delta < 0;\n\n    const typeLabel = isFirstRun ? \"Abertura\" : (taxaCaiu ? \"Caiu\" : \"Subiu\");\n    const subLabel = isFirstRun\n      ? \"snapshot de abertura do mercado\"\n      : (taxaCaiu\n        ? \"preço subiu — título mais valorizado\"\n        : \"preço caiu — momento mais atrativo para comprar\");\n    const color = isFirstRun ? \"#2d5fa6\" : (taxaCaiu ? \"#1a6b3c\" : \"#b20f03\");\n    const icon = isFirstRun ? \"📊\" : (taxaCaiu ? \"📉\" : \"📈\");\n\n    const brevoApiKey = Deno.env.get(\"brevo\");\n    if (!brevoApiKey) {\n      console.error(\n        \"Variável de ambiente 'brevo' não está configurada no Val Town.\",\n      );\n      return false;\n    }\n\n    const formatDiff = (\n      now: number,\n      prev: number,\n      isPercent = false,\n    ): string => {\n      if (isFirstRun) return \"—\";\n      const diff = now - prev;\n      if (diff === 0) return \"—\";\n      const sign = diff > 0 ? \"+\" : \"\";\n      const suffix = isPercent ? \"%\" : \"\";\n      const diffColor = diff < 0 ? \"#1a6b3c\" : \"#b20f03\";\n      return `${sign}${\n        diff.toFixed(2)\n      }${suffix}`;\n    };\n\n    // Lucro/Prejuízo = PU Compra - PU Venda\n    const spreadAtual = untrInvstmtVal - untrRedVal;\n    const spreadAnterior = prevInvVal - prevRedVal;\n    const spreadColor = spreadAtual >= 0 ? \"#b20f03\" : \"#1a6b3c\";\n    const spreadLabel = spreadAtual >= 0\n      ? `R$ +${spreadAtual.toFixed(2)} (custo ao comprar agora)`\n      : `R$ ${spreadAtual.toFixed(2)} (ganho ao resgatar agora)`;\n\n    const htmlBody = `\n      \n        \n          ${icon} Tesouro Direto — Taxa ${typeLabel}!
\n          ${subLabel}
\n          ${todayLabel} às ${timeStr} (Horário de Brasília)
\n        
\n        \n          ${bondName}
\n          \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n              \n              \n            \n            \n              \n              \n            \n          Métrica Anterior Agora Variação
Taxa de Compra ${\n      prevRate.toFixed(2)\n    }% ${\n      currentRate.toFixed(2)\n    }% ${\n      formatDiff(currentRate, prevRate, true)\n    }
Preço Unitário (Compra) R$ ${\n      prevInvVal.toFixed(2)\n    } R$ ${\n      untrInvstmtVal.toFixed(2)\n    } ${\n      formatDiff(untrInvstmtVal, prevInvVal)\n    }
Taxa de Venda (Resgate) ${\n      prevRedRate.toFixed(2)\n    }% ${\n      currentRedRate.toFixed(2)\n    }% ${\n      formatDiff(currentRedRate, prevRedRate, true)\n    }
Preço Unitário (Venda) R$ ${\n      prevRedVal.toFixed(2)\n    } R$ ${\n      untrRedVal.toFixed(2)\n    } ${\n      formatDiff(untrRedVal, prevRedVal)\n    }
Compra − Venda (PU atual) ${spreadLabel}
\n          \n            \n              Ir para o Tesouro Direto\n            \n          
\n        
\n      \n    `;\n\n    const formattedRecipients = RECIPIENTS.map((email) => ({ email }));\n    const emailResponse = await fetch(\"https://api.brevo.com/v3/smtp/email\", {\n      method: \"POST\",\n      headers: {\n        \"accept\": \"application/json\",\n        \"api-key\": brevoApiKey,\n        \"content-type\": \"application/json\",\n      },\n      body: JSON.stringify({\n        sender: { name: \"Tesouro Alerta\", email: EMAIL_SENDER },\n        to: formattedRecipients,\n        subject:\n          `${icon} Tesouro Direto — Taxa ${typeLabel.toLowerCase()} para ${\n            currentRate.toFixed(2)\n          }% a.a.`,\n        htmlContent: htmlBody,\n      }),\n    });\n\n    if (emailResponse.ok) {\n      console.log(\"E-mails enviados com sucesso via Brevo!\");\n      return true;\n    } else {\n      const errText = await emailResponse.text();\n      console.error(`Falha ao enviar e-mail pelo Brevo: ${errText}`);\n      return false;\n    }\n  }\n  // ──────────────────────────────────────────────────────────────────────────\n\n  // 5. Primeira execução do dia: envia snapshot de abertura e salva estado\n  if (lastRate === null || lastRunDate !== todayStr) {\n    console.log(\n      `Primeira execução do dia (${todayLabel}). Enviando snapshot de abertura...`,\n    );\n    const sent = await sendAlert(\n      true,\n      currentRate,\n      currentRedRate,\n      untrInvstmtVal,\n      untrRedVal,\n    );\n    if (sent) {\n      await setVal(\"last-known-rate\", currentRate.toString());\n      await setVal(\"last-known-red-rate\", currentRedRate.toString());\n      await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n      await setVal(\"last-known-red-val\", untrRedVal.toString());\n      await setVal(\"last-run-date\", todayStr);\n    }\n    return;\n  }\n\n  // 6. Execuções seguintes: alerta somente se a taxa mudou\n  if (currentRate !== lastRate) {\n    console.log(\n      `A taxa mudou! Anterior: ${lastRate}% -> Atual: ${currentRate}%. Enviando e-mail...`,\n    );\n    const sent = await sendAlert(\n      false,\n      lastRate,\n      lastRedRate,\n      lastInvVal,\n      lastRedVal,\n    );\n    if (sent) {\n      await setVal(\"last-known-rate\", currentRate.toString());\n      await setVal(\"last-known-red-rate\", currentRedRate.toString());\n      await setVal(\"last-known-inv-val\", untrInvstmtVal.toString());\n      await setVal(\"last-known-red-val\", untrRedVal.toString());\n    }\n  } else {\n    console.log(`Taxa não se alterou (${currentRate}%). Nenhuma ação.`);\n  }\n}","deleted",false,"label",[35],{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":59,"_18":60},["D",1789142089891],"children",[],[35],"cfd06c6d-7087-4b23-8f3e-8975c3515363",["D",1781280995443],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","userId","395d9fa1-9e1f-4dc3-99e9-fa260dd69c60","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019ebc9e-34d3-7039-9ae4-95e6bbae3263","tursoName","cfd06c6d70874b238f3e8975c3515363","tursoHostname","cfd06c6d70874b238f3e8975c3515363-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789499469860],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_11":12,"_117":113},"org",{"_11":12,"_111":12,"_112":113,"_70":71,"_114":115,"_116":53},"branch",{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"isOwned","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","displayName","avatar","https://lh3.googleusercontent.com/a/ACg8ocLif3-AgExKQic8AY_2q-kZkwvvvNk7e7PHvPyN61xChmotnPebYA=s96-c","tier","free","canRestrictVals","profileImageUrl","adoptOrgId",{"_33":61,"_13":14,"_45":152,"_63":-5,"_64":53,"_65":66,"_67":66,"_68":19,"_69":-5,"_70":71,"_72":-5,"_73":53,"_74":-5,"_75":-5,"_76":77,"_78":79,"_80":81,"_82":83,"_84":153,"_86":-5,"_87":88,"_89":88,"_90":91,"_92":91,"_93":91,"_94":88,"_95":88,"_96":154,"_98":155,"_100":156,"_102":53},[149],"files",[149],"counts",{"_138":77,"_139":140,"_141":77,"_31":142,"_143":144},[136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":46,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_18":137},[35],"pulls","branches",1,"forks",{"_145":147,"_148":77},"connections",{"_145":77,"_146":77},"count","unfilledCount",6,"emptyCount",{"_33":34,"_13":35,"_36":37,"_38":-5,"_39":40,"_41":42,"_43":44,"_45":57,"_17":47,"_48":49,"_50":51,"_52":53,"_54":-5,"_58":150,"_18":151},[],[35],["D",1781280995443],["D",1789499469860],{"_11":12,"_117":113},{"_11":12,"_111":12,"_112":113,"_70":71,"_114":115,"_116":53},{"_17":42,"_13":16,"_33":40,"_103":61,"_104":-5,"_105":-5,"_106":-5,"_107":-5,"_108":-5,"_109":14,"_110":12},"ctx",{"_96":-5,"_133":190,"_191":192,"_193":194,"_195":53,"_196":53,"_197":53,"_198":44,"_199":-5,"_200":-7,"_201":-7,"_202":77,"_203":53,"_204":53,"_205":-5,"_206":53,"_207":53,"_208":53,"_209":-5},"ENV",{"_161":162,"_163":164,"_165":16,"_166":167,"_168":169,"_170":171,"_172":173,"_174":175,"_176":177,"_178":179,"_180":181,"_182":183,"_184":185,"_186":187,"_188":189},"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"]

Métrica	Anterior	Agora	Variação
Taxa de Compra	${\n prevRate.toFixed(2)\n }%	${\n currentRate.toFixed(2)\n }%	${\n formatDiff(currentRate, prevRate, true)\n }
Preço Unitário (Compra)	R$ ${\n prevInvVal.toFixed(2)\n }	R$ ${\n untrInvstmtVal.toFixed(2)\n }	${\n formatDiff(untrInvstmtVal, prevInvVal)\n }
Taxa de Venda (Resgate)	${\n prevRedRate.toFixed(2)\n }%	${\n currentRedRate.toFixed(2)\n }%	${\n formatDiff(currentRedRate, prevRedRate, true)\n }
Preço Unitário (Venda)	R$ ${\n prevRedVal.toFixed(2)\n }	R$ ${\n untrRedVal.toFixed(2)\n }	${\n formatDiff(untrRedVal, prevRedVal)\n }
Compra − Venda (PU atual)	${spreadLabel}

Code