[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_170":171,"_172":173},"routes/_app.x.$handle.$name",{"_98":97,"_33":46,"_106":88,"_28":107,"_13":14,"_108":-5,"_11":109,"_110":111,"_112":113,"_114":115,"_116":117,"_20":-5,"_118":-5,"_119":-5,"_120":27,"_121":122,"_123":27,"_124":-5,"_125":-5,"_126":127},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_44":45,"_33":46,"_39":47,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":69,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":81,"_82":83,"_84":85,"_86":27},"version",25,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":23,"_24":25,"_26":27,"_28":29,"_30":29},"file",{"_31":32,"_33":29,"_34":35,"_36":38,"_39":40,"_41":14,"_42":43,"_24":27},"previous",{"_31":32,"_33":29,"_34":35,"_36":37},"deleted",true,"deletedHere",false,"path","oriPRsPoller.ts","latestPath","fileId","0e2f8b7e-43b9-11f1-8c1b-42b51c65c3df","name","fileType","interval","content","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst NOTION_TOKEN = \"ntn_K8817788878GQIQJ1z420EcHsLEVJEbaWPtDXZAUr6e0zo\";\nconst TELEGRAM_TOKEN = \"8638076247:AAF-IW7FRjUEhzMHOXtdZYQqLokLx6o2Yu4\";\nconst TELEGRAM_CHAT = -1003710958252;\nconst TELEGRAM_THREAD = 2473;\n\nconst PR_PAGES = [\n { id: \"35120d94-c7ce-8024-9ef9-f3887118c179\", label: \"Vane\" },\n { id: \"35120d94-c7ce-80de-8644-c42abfe07882\", label: \"Alpani\" },\n { id: \"35120d94-c7ce-8078-be53-ef166aba58aa\", label: \"DevDigest\" },\n];\n\nasync function notionGet(url: string) {\n const r = await fetch(url, {\n headers: {\n \"Authorization\": `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": \"2022-06-28\",\n },\n });\n return r.json();\n}\n\nfunction escHtml(s: string): string {\n return s.replace(/&/g, \"&\").replace(//g, \">\");\n}\n\nfunction richToHtml(richText: any[]): string {\n return (richText ?? []).map((r: any) => {\n let s = escHtml(r.plain_text);\n if (r.annotations?.bold) s = `${s}`;\n if (r.annotations?.italic) s = `${s}`;\n if (r.annotations?.code) s = `${s}`;\n return s;\n }).join(\"\");\n}\n\nfunction extractHtml(blocks: any[]): string {\n const parts: string[] = [];\n let lastWasContent = false;\n\n for (const b of blocks) {\n const t = b.type;\n\n if (t === \"divider\") {\n parts.push(\"\");\n parts.push(\"━━━━━━━━━━━━━━━━━━━━\");\n parts.push(\"\");\n lastWasContent = false;\n continue;\n }\n\n const richText = b[t]?.rich_text ?? [];\n const text = richToHtml(richText);\n if (!text) continue;\n\n if (t.startsWith(\"heading_\")) {\n if (lastWasContent && t !== \"heading_1\" && t !== \"heading_2\") {\n parts.push(\"\");\n parts.push(\"━━━━━━━━━━━━━━━━━━━━\");\n parts.push(\"\");\n } else if (lastWasContent) {\n parts.push(\"\");\n }\n parts.push(`${text}`);\n lastWasContent = false;\n } else if (t === \"bulleted_list_item\") {\n parts.push(` • ${text}`);\n lastWasContent = true;\n } else {\n parts.push(text);\n lastWasContent = true;\n }\n }\n\n return parts.join(\"\\n\").trim();\n}\n\nfunction chunkText(text: string, max = 4000): string[] {\n const chunks: string[] = [];\n let cur = \"\";\n for (const line of text.split(\"\\n\")) {\n if ((cur + \"\\n\" + line).length > max) {\n if (cur) chunks.push(cur.trim());\n cur = line;\n } else {\n cur = cur ? cur + \"\\n\" + line : line;\n }\n }\n if (cur.trim()) chunks.push(cur.trim());\n return chunks;\n}\n\nasync function tgSend(text: string) {\n const chunks = chunkText(text);\n for (const chunk of chunks) {\n const res = await fetch(\n `https://api.telegram.org/bot${TELEGRAM_TOKEN}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: TELEGRAM_CHAT,\n message_thread_id: TELEGRAM_THREAD,\n text: chunk,\n parse_mode: \"HTML\",\n }),\n },\n );\n const j = await res.json();\n if (!j.ok) console.log(\"TG error:\", j.description);\n }\n}\n\nexport default async function () {\n // BORRAR ESTA LÍNEA DESPUÉS DE EJECUTAR UNA VEZ:\n await sqlite.execute(`DROP TABLE IF EXISTS sent_prs`);\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS sent_prs (page_id TEXT PRIMARY KEY, sent_at INTEGER NOT NULL)`,\n );\n\n for (const { id: parentId, label } of PR_PAGES) {\n const search = await notionGet(\n `https://api.notion.com/v1/blocks/${parentId}/children?page_size=20`,\n );\n const subPages = (search.results ?? []).filter((b: any) =>\n b.type === \"child_page\"\n );\n\n for (const page of subPages) {\n const pageId = page.id;\n\n const exists = await sqlite.execute({\n sql: `SELECT 1 FROM sent_prs WHERE page_id = ?`,\n args: [pageId],\n });\n if (exists.rows.length > 0) {\n console.log(`SKIP ${label} ${pageId}`);\n continue;\n }\n\n const title = page.child_page?.title ?? \"Sin título\";\n const blocks = await notionGet(\n `https://api.notion.com/v1/blocks/${pageId}/children?page_size=100`,\n );\n const body = extractHtml(blocks.results ?? []);\n const header = `📋 [${label}] ${escHtml(title)}`;\n const fullMsg = body ? `${header}\\n\\n${body}` : header;\n\n console.log(`SEND ${label} \"${title}\"`);\n await tgSend(fullMsg);\n\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO sent_prs (page_id, sent_at) VALUES (?, ?)`,\n args: [pageId, Date.now()],\n });\n }\n }\n}","import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst NOTION_TOKEN = \"ntn_K8817788878GQIQJ1z420EcHsLEVJEbaWPtDXZAUr6e0zo\";\nconst TELEGRAM_TOKEN = \"8638076247:AAF-IW7FRjUEhzMHOXtdZYQqLokLx6o2Yu4\";\nconst TELEGRAM_CHAT = -1003926989489;\n\nconst PR_PAGES = [\n { id: \"35120d94-c7ce-8024-9ef9-f3887118c179\", label: \"Vane\" },\n { id: \"35120d94-c7ce-80de-8644-c42abfe07882\", label: \"Alpani\" },\n { id: \"35120d94-c7ce-8078-be53-ef166aba58aa\", label: \"DevDigest\" },\n];\n\nasync function notionGet(url: string) {\n const r = await fetch(url, {\n headers: {\n \"Authorization\": `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": \"2022-06-28\",\n },\n });\n return r.json();\n}\n\nfunction escHtml(s: string): string {\n return s.replace(/&/g, \"&\").replace(//g, \">\");\n}\n\nfunction richToHtml(richText: any[]): string {\n return (richText ?? []).map((r: any) => {\n let s = escHtml(r.plain_text);\n if (r.annotations?.bold) s = `${s}`;\n if (r.annotations?.italic) s = `${s}`;\n if (r.annotations?.code) s = `${s}`;\n return s;\n }).join(\"\");\n}\n\nfunction extractHtml(blocks: any[]): string {\n const parts: string[] = [];\n let lastWasContent = false;\n\n for (const b of blocks) {\n const t = b.type;\n\n if (t === \"divider\") {\n parts.push(\"\");\n parts.push(\"━━━━━━━━━━━━━━━━━━━━\");\n parts.push(\"\");\n lastWasContent = false;\n continue;\n }\n\n const richText = b[t]?.rich_text ?? [];\n const text = richToHtml(richText);\n if (!text) continue;\n\n if (t.startsWith(\"heading_\")) {\n if (lastWasContent && t !== \"heading_1\" && t !== \"heading_2\") {\n parts.push(\"\");\n parts.push(\"━━━━━━━━━━━━━━━━━━━━\");\n parts.push(\"\");\n } else if (lastWasContent) {\n parts.push(\"\");\n }\n parts.push(`${text}`);\n lastWasContent = false;\n } else if (t === \"bulleted_list_item\") {\n parts.push(` • ${text}`);\n lastWasContent = true;\n } else {\n parts.push(text);\n lastWasContent = true;\n }\n }\n\n return parts.join(\"\\n\").trim();\n}\n\nfunction chunkText(text: string, max = 4000): string[] {\n const chunks: string[] = [];\n let cur = \"\";\n for (const line of text.split(\"\\n\")) {\n if ((cur + \"\\n\" + line).length > max) {\n if (cur) chunks.push(cur.trim());\n cur = line;\n } else {\n cur = cur ? cur + \"\\n\" + line : line;\n }\n }\n if (cur.trim()) chunks.push(cur.trim());\n return chunks;\n}\n\nasync function tgSend(text: string) {\n const chunks = chunkText(text);\n for (const chunk of chunks) {\n const res = await fetch(\n `https://api.telegram.org/bot${TELEGRAM_TOKEN}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({\n chat_id: TELEGRAM_CHAT,\n text: chunk,\n parse_mode: \"HTML\",\n }),\n },\n );\n const j = await res.json();\n if (!j.ok) console.log(\"TG error:\", j.description);\n }\n}\n\nexport default async function () {\n // BORRAR ESTA LÍNEA DESPUÉS DE EJECUTAR UNA VEZ:\n await sqlite.execute(`DROP TABLE IF EXISTS sent_prs`);\n\n await sqlite.execute(\n `CREATE TABLE IF NOT EXISTS sent_prs (page_id TEXT PRIMARY KEY, sent_at INTEGER NOT NULL)`,\n );\n\n for (const { id: parentId, label } of PR_PAGES) {\n const search = await notionGet(\n `https://api.notion.com/v1/blocks/${parentId}/children?page_size=20`,\n );\n const subPages = (search.results ?? []).filter((b: any) =>\n b.type === \"child_page\"\n );\n\n for (const page of subPages) {\n const pageId = page.id;\n\n const exists = await sqlite.execute({\n sql: `SELECT 1 FROM sent_prs WHERE page_id = ?`,\n args: [pageId],\n });\n if (exists.rows.length > 0) {\n console.log(`SKIP ${label} ${pageId}`);\n continue;\n }\n\n const title = page.child_page?.title ?? \"Sin título\";\n const blocks = await notionGet(\n `https://api.notion.com/v1/blocks/${pageId}/children?page_size=100`,\n );\n const body = extractHtml(blocks.results ?? []);\n const header = `📋 [${label}] ${escHtml(title)}`;\n const fullMsg = body ? `${header}\\n\\n${body}` : header;\n\n console.log(`SEND ${label} \"${title}\"`);\n await tgSend(fullMsg);\n\n await sqlite.execute({\n sql: `INSERT OR IGNORE INTO sent_prs (page_id, sent_at) VALUES (?, ?)`,\n args: [pageId, Date.now()],\n });\n }\n }\n}","createdAt",["D",1777469530884],"branchVersion","branchId","1e91d134-4265-11f1-b038-42b51c65c3df","id","1e913a58-4265-11f1-b038-42b51c65c3df","untitled-7175",["D",1777313749715],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","imageUrl","587ed208-2901-4207-a021-16f80add47ff","pinnedFileId","pinPreview","pinMigrated","screenshotVersion","likeCount",0,"orgId","019dcf24-6f2d-7025-8fe1-852993cd16d9","tursoName","1e913a58426511f1b03842b51c65c3df","tursoHostname","1e913a58426511f1b03842b51c65c3df-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789498239291],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":101},"org",{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":27},"branch",{"_13":87,"_33":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"isOwned",38,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","vmbb13","handle","displayName","avatar","https://avatars.githubusercontent.com/u/242785645?v=4","tier","free","canRestrictVals","profileImageUrl","branchName","","adoptOrgId",{"_44":45,"_33":46,"_39":165,"_48":-5,"_49":27,"_50":51,"_52":51,"_53":-5,"_54":-5,"_18":55,"_56":-5,"_57":27,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":166,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":167,"_82":168,"_84":169,"_86":27},"tree",[156,157],"files",[156,157],"counts",{"_145":61,"_146":147,"_148":61,"_149":150,"_151":152},"contents",[128,129],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_44":141,"_33":29,"_31":32,"_133":-5,"_42":43,"_41":14,"_135":27,"_39":142,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_28":144},{"_44":130,"_33":131,"_31":132,"_133":-5,"_42":43,"_41":134,"_135":27,"_39":136,"_13":137,"_34":35,"_36":138,"_24":27,"_139":-5,"_28":140},"8709d82c-430c-11f1-bd0b-42b51c65c3df","oriTelegramPoller.ts","1e93e4b0-4265-11f1-b038-42b51c65c3df","parentId",8,"latest",["D",1777385650899],7,"import { sqlite } from \"https://esm.town/v/std/sqlite\";\n\nconst NOTION_TOKEN = \"ntn_K8817788878GQIQJ1z420EcHsLEVJEbaWPtDXZAUr6e0zo\";\nconst NOTION_PARENT_PAGE = \"35020d94-c7ce-8039-af8f-c872594b393f\";\nconst TELEGRAM_TOKEN = \"8638076247:AAF-IW7FRjUEhzMHOXtdZYQqLokLx6o2Yu4\";\nconst TELEGRAM_CHAT = -1003920831696;\n\nawait sqlite.execute(`\n CREATE TABLE IF NOT EXISTS sent_notion (\n page_id TEXT PRIMARY KEY,\n sent_at INTEGER NOT NULL\n )\n `);\n\nasync function notionGet(path: string) {\n const res = await fetch(`https://api.notion.com/v1${path}`, {\n headers: {\n \"Authorization\": `Bearer ${NOTION_TOKEN}`,\n \"Notion-Version\": \"2022-06-28\",\n },\n });\n if (!res.ok) {\n throw new Error(`Notion ${path} → ${res.status}: ${await res.text()}`);\n }\n return res.json();\n}\n\nfunction escHtml(s: string) {\n return s.replace(/&/g, \"&\").replace(//g, \">\");\n}\n\nfunction extractHtml(block: any): string {\n const rich = (arr: any[]) =>\n (arr || []).map((r: any) => escHtml(r.plain_text || \"\")).join(\"\");\n switch (block.type) {\n case \"heading_1\":\n return `\\n${rich(block.heading_1.rich_text)}\\n`;\n case \"heading_2\":\n return `\\n${rich(block.heading_2.rich_text)}\\n`;\n case \"heading_3\":\n return `${rich(block.heading_3.rich_text)}\\n`;\n case \"paragraph\":\n return rich(block.paragraph.rich_text)\n ? rich(block.paragraph.rich_text) + \"\\n\"\n : \"\\n\";\n case \"bulleted_list_item\":\n return `• ${rich(block.bulleted_list_item.rich_text)}\\n`;\n case \"numbered_list_item\":\n return `• ${rich(block.numbered_list_item.rich_text)}\\n`;\n case \"callout\":\n return `💡 ${rich(block.callout.rich_text)}\\n`;\n case \"to_do\":\n return `${block.to_do.checked ? \"☑\" : \"☐\"} ${\n rich(block.to_do.rich_text)\n }\\n`;\n case \"divider\":\n return \"────────────────────\\n\";\n case \"quote\":\n return `${rich(block.quote.rich_text)}\\n`;\n default:\n return \"\";\n }\n}\n\nasync function tgSend(text: string, replyTo?: number): Promise {\n const body: any = {\n chat_id: TELEGRAM_CHAT,\n text,\n parse_mode: \"HTML\",\n disable_web_page_preview: true,\n };\n if (replyTo) body.reply_to_message_id = replyTo;\n const r = await fetch(\n `https://api.telegram.org/bot${TELEGRAM_TOKEN}/sendMessage`,\n {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify(body),\n },\n );\n const j = await r.json();\n if (!j.ok) throw new Error(`Telegram error: ${JSON.stringify(j)}`);\n return j.result.message_id;\n}\n\nfunction chunkText(text: string, maxLen = 4000): string[] {\n const chunks: string[] = [];\n let remaining = text;\n while (remaining.length > 0) {\n if (remaining.length <= maxLen) {\n chunks.push(remaining);\n break;\n }\n const cut = remaining.lastIndexOf(\"\\n\", maxLen);\n const pos = cut > 0 ? cut : maxLen;\n chunks.push(remaining.slice(0, pos));\n remaining = remaining.slice(pos).trimStart();\n }\n return chunks;\n}\n\nconst childrenData = await notionGet(\n `/blocks/${NOTION_PARENT_PAGE}/children?page_size=50`,\n);\nconst childPages = (childrenData.results || []).filter((b: any) =>\n b.type === \"child_page\"\n);\n\nfor (const page of childPages) {\n const pageId = page.id;\n const title = page.child_page?.title || \"Sin título\";\n const already = await sqlite.execute(\n \"SELECT 1 FROM sent_notion WHERE page_id = ?\",\n [pageId],\n );\n if (already.rows.length > 0) continue;\n\n try {\n const data = await notionGet(`/blocks/${pageId}/children?page_size=100`);\n const content = data.results.map(extractHtml).join(\"\").trim();\n if (!content) continue;\n\n const threadId = await tgSend(`📰 ${escHtml(title)}`);\n for (const chunk of chunkText(content)) {\n await tgSend(chunk, threadId);\n await new Promise((r) => setTimeout(r, 500));\n }\n\n await sqlite.execute(\n \"INSERT OR IGNORE INTO sent_notion (page_id, sent_at) VALUES (?, ?)\",\n [pageId, Date.now()],\n );\n console.log(`✅ Sent: ${title}`);\n } catch (err) {\n console.error(`❌ Error on ${pageId}: ${err}`);\n }\n}","label",[131],"d367c5ee-43cf-11f1-b461-42b51c65c3df",["D",1777469530884],12,[29],"pulls","branches",1,"forks","envVars",{"_153":61,"_155":61},"connections",{"_153":61,"_154":61},"count","unfilledCount","emptyCount",{"_44":141,"_33":29,"_31":32,"_133":-5,"_42":43,"_41":14,"_135":27,"_39":162,"_13":143,"_34":35,"_36":38,"_24":27,"_139":-5,"_159":163,"_28":164},{"_44":130,"_33":131,"_31":132,"_133":-5,"_42":43,"_41":134,"_135":27,"_39":158,"_13":137,"_34":35,"_36":138,"_24":27,"_139":-5,"_159":160,"_28":161},["D",1777385650899],"children",[],[131],["D",1777469530884],[],[29],["D",1777313749715],["D",1789498239291],{"_98":97,"_105":101},{"_98":97,"_99":-5,"_100":101,"_18":55,"_102":103,"_104":27},{"_13":87,"_33":88,"_44":43,"_89":45,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":46,"_96":97},"ctx",{"_80":-5,"_125":203,"_204":205,"_206":207,"_208":27,"_209":27,"_210":27,"_211":25,"_212":-5,"_213":-7,"_214":-7,"_215":61,"_216":27,"_217":27,"_218":-5,"_219":27,"_220":27,"_221":27,"_222":-5},"ENV",{"_174":175,"_176":177,"_178":88,"_179":180,"_181":182,"_183":184,"_185":186,"_187":188,"_189":190,"_191":192,"_193":194,"_195":196,"_197":198,"_199":200,"_201":202},"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 · v25