[{"_1":2,"_3":-5,"_4":-5},"loaderData",{"_5":6,"_7":8,"_9":10},"actionData","errors","root",{"_265":266,"_267":268},"routes/_app.x.$handle.$name",{"_98":97,"_31":43,"_106":88,"_26":100,"_13":14,"_107":-5,"_11":108,"_109":110,"_111":112,"_113":114,"_115":116,"_20":-5,"_117":-5,"_118":-5,"_119":24,"_120":121,"_122":57,"_123":-5,"_124":-5,"_125":126},"routes/_app.x.$handle.$name.branch.$branch.version.$version.diff",{"_11":12,"_13":14,"_15":16,"_17":-5,"_18":-5},"project",{"_41":42,"_31":43,"_36":44,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_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":24},"version",14,"changes",[19],"aiChatInfo","userId",{"_20":21,"_22":-7,"_23":24,"_25":24,"_26":27,"_28":27},"file",{"_29":30,"_31":27,"_32":33,"_34":35,"_36":37,"_38":14,"_39":40,"_23":24},"previous","deleted",false,"deletedHere","path","token.ts","latestPath","fileId","eacb6b86-8a70-11f1-bdcf-1607ee4eb77e","name","fileType","script","content","// Gestión del token de Meta. El token renovado vive en blob storage porque\n// un val no puede modificar sus propias env vars; META_ACCESS_TOKEN es la semilla.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nconst KEY = \"meta/access_token.json\";\n\nexport async function getToken(): Promise {\n try {\n const j = await blob.getJSON(KEY) as { token?: string } | undefined;\n if (j?.token) return j.token;\n } catch {\n // sin blob todavía: cae a la env var\n }\n return Deno.env.get(\"META_ACCESS_TOKEN\") ?? null;\n}\n\nexport async function saveToken(token: string): Promise {\n await blob.setJSON(KEY, { token, guardado: new Date().toISOString() });\n}\n","createdAt",["D",1785235300474],"branchVersion","branchId","d66cfc4d-a355-43ce-a1b2-7255690ecf45","id","aff7e71b-a886-4acb-9c3c-ed0dba233db8","trucos-de-ia",["D",1785163109209],"deletedAt","legacyEnvVars","privacy","public","httpPrivacy","description","Automatización del canal @trucos.de.ia: webhook Telegram + cron","imageUrl","7466c9e5-2d6f-472c-ae9e-1a257c0b2e02","pinnedFileId","11f6b8e4-89c9-11f1-ab7d-1607ee4eb77e","pinPreview",true,"pinMigrated","screenshotVersion","likeCount",0,"orgId","019fa400-6d33-70ee-9f1b-d2bfe1a8dd3d","tursoName","aff7e71ba8864acb9c3ced0dba233db8","tursoHostname","aff7e71ba8864acb9c3ced0dba233db8-val-town.aws-us-east-2.turso.io","tursoMeasuredAt",["D",1789484509295],"pinned","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm","user",{"_98":97,"_105":100},"org",{"_98":97,"_99":100,"_101":100,"_18":53,"_102":103,"_104":24},"branch",{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"isOwned",176,"main","projectId","forkedBranchId","forkedBranchVersion","forkedProjectPrivacy","forkedProjectId","forkedProjectOrgId","projectName","userHandle","iaparatodosig","handle","displayName","","avatar","tier","free","canRestrictVals","profileImageUrl","branchName","adoptOrgId",{"_41":42,"_31":43,"_36":260,"_45":-5,"_46":24,"_47":48,"_49":48,"_50":51,"_52":-5,"_18":53,"_54":55,"_56":57,"_58":-5,"_59":-5,"_60":61,"_62":63,"_64":65,"_66":67,"_68":261,"_70":-5,"_71":72,"_73":72,"_74":75,"_76":75,"_77":75,"_78":72,"_79":72,"_80":262,"_82":263,"_84":264,"_86":24},"tree",[219,220,221,222,223,224,225,226,227,228],"files",[219,220,221,222,223,224,225,226,227,228],"counts",{"_208":61,"_209":199,"_210":61,"_211":212,"_213":214},"contents",[127,128,129,130,131,132,133,134,135,136],"upstreamProject","upstreamBranch","emptyEnvVars","flags",[],"hasHttpFiles","grants","orgs","customDomains",{},{"_41":202,"_31":203,"_29":204,"_138":-5,"_39":40,"_38":199,"_139":57,"_36":205,"_13":61,"_32":20,"_34":206,"_23":24,"_141":-5,"_26":207},{"_41":194,"_31":195,"_29":196,"_138":-5,"_39":40,"_38":197,"_139":24,"_36":198,"_13":199,"_32":33,"_34":200,"_23":24,"_141":-5,"_26":201},{"_41":187,"_31":188,"_29":189,"_138":-5,"_39":40,"_38":190,"_139":24,"_36":191,"_13":61,"_32":170,"_34":192,"_23":24,"_141":-5,"_26":193},{"_41":180,"_31":181,"_29":182,"_138":-5,"_39":40,"_38":183,"_139":24,"_36":184,"_13":61,"_32":155,"_34":185,"_23":24,"_141":-5,"_26":186},{"_41":173,"_31":174,"_29":55,"_138":-5,"_39":40,"_38":175,"_139":24,"_36":176,"_13":177,"_32":155,"_34":178,"_23":24,"_141":-5,"_26":179},{"_41":165,"_31":166,"_29":167,"_138":-5,"_39":40,"_38":168,"_139":24,"_36":169,"_13":61,"_32":170,"_34":171,"_23":24,"_141":-5,"_26":172},{"_41":158,"_31":159,"_29":160,"_138":-5,"_39":40,"_38":161,"_139":24,"_36":162,"_13":61,"_32":33,"_34":163,"_23":24,"_141":-5,"_26":164},{"_41":150,"_31":151,"_29":152,"_138":-5,"_39":40,"_38":153,"_139":24,"_36":154,"_13":61,"_32":155,"_34":156,"_23":24,"_141":-5,"_26":157},{"_41":143,"_31":144,"_29":145,"_138":-5,"_39":40,"_38":146,"_139":24,"_36":147,"_13":61,"_32":33,"_34":148,"_23":24,"_141":-5,"_26":149},{"_41":137,"_31":27,"_29":30,"_138":-5,"_39":40,"_38":14,"_139":57,"_36":140,"_13":61,"_32":33,"_34":35,"_23":24,"_141":-5,"_26":142},"a8cdb1dd-cd8d-4720-8b5c-4790f1a0ae16","parentId","latest",["D",1785235300474],"label",[27],"b0b0e2dc-1093-4d74-83e8-9cc08ecb5e71","telegram.ts","20c8c53e-89cd-11f1-ba02-1607ee4eb77e",4,["D",1785164953579],"// Envío de mensajes al chat de Carlos (fuera del contexto del webhook).\nexport async function enviarTelegram(texto: string): Promise {\n const token = Deno.env.get(\"TELEGRAM_TOKEN\");\n const chat = Deno.env.get(\"TELEGRAM_CHAT_ID\");\n if (!token || !chat) throw new Error(\"Faltan TELEGRAM_TOKEN / TELEGRAM_CHAT_ID\");\n const res = await fetch(`https://api.telegram.org/bot${token}/sendMessage`, {\n method: \"POST\",\n headers: { \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ chat_id: chat, text: texto, disable_web_page_preview: true }),\n });\n if (!res.ok) throw new Error(`Telegram ${res.status}: ${await res.text()}`);\n}\n",[144],"06da3936-b28c-403e-8a14-943aefe32bfe","subir.ts","25e5712a-89cd-11f1-98d2-1607ee4eb77e",6,["D",1785164962220],"http","// Recibe los PNG renderizados en local y los guarda en blob storage.\n// Uso: curl -X PUT \"?key=posts//slide-01.png\" \\\n// -H \"Authorization: Bearer $UPLOAD_SECRET\" --data-binary @slide-01.png\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise {\n const auth = req.headers.get(\"Authorization\") ?? \"\";\n const secreto = Deno.env.get(\"UPLOAD_SECRET\");\n if (!secreto || auth !== `Bearer ${secreto}`) {\n return new Response(\"No autorizado\", { status: 401 });\n }\n if (req.method !== \"PUT\" && req.method !== \"POST\") {\n return new Response(\"Usa PUT con el binario en el cuerpo\", { status: 405 });\n }\n const key = new URL(req.url).searchParams.get(\"key\");\n if (!key || !key.startsWith(\"posts/\")) {\n return new Response(\"Falta ?key=posts//\", { status: 400 });\n }\n const datos = new Uint8Array(await req.arrayBuffer());\n if (datos.length === 0) return new Response(\"Cuerpo vacío\", { status: 400 });\n await blob.set(key, datos);\n return Response.json({ ok: true, key, bytes: datos.length });\n}\n",[151],"8e6c54a1-e4fe-48a9-94d3-77a977c04961","publicar.ts","4e5dc7ba-89cd-11f1-92c9-1607ee4eb77e",8,["D",1785165030104],"// Publica un carrusel aprobado en Instagram (API de Meta con Instagram Login).\n// Necesita las env vars META_ACCESS_TOKEN e IG_USER_ID.\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\nimport { marcarPublicado, postCompleto } from \"./airtable.ts\";\n\nconst GRAPH = \"https://graph.instagram.com/v23.0\";\nconst IMG_BASE = \"https://iaparatodosig--22cc5aee89cd11f18c731607ee4eb77e.web.val.run\";\n\nexport function metaConfigurado(): boolean {\n return Boolean(Deno.env.get(\"META_ACCESS_TOKEN\") && Deno.env.get(\"IG_USER_ID\"));\n}\n\nfunction credenciales() {\n const token = Deno.env.get(\"META_ACCESS_TOKEN\");\n const igId = Deno.env.get(\"IG_USER_ID\");\n if (!token || !igId) throw new Error(\"Faltan META_ACCESS_TOKEN / IG_USER_ID\");\n return { token, igId };\n}\n\nasync function graphPost(path: string, params: Record, token: string) {\n const res = await fetch(`${GRAPH}/${path}`, {\n method: \"POST\",\n body: new URLSearchParams({ ...params, access_token: token }),\n });\n const data = await res.json();\n if (!res.ok || data.error) throw new Error(`Meta ${res.status}: ${JSON.stringify(data.error ?? data)}`);\n return data;\n}\n\n// Los contenedores de media se procesan en segundo plano; hay que esperar a FINISHED.\nasync function esperarFinished(id: string, token: string): Promise {\n for (let i = 0; i < 20; i++) {\n const res = await fetch(`${GRAPH}/${id}?fields=status_code&access_token=${token}`);\n const data = await res.json();\n if (data.status_code === \"FINISHED\") return;\n if (data.status_code === \"ERROR\") throw new Error(`Contenedor ${id} en ERROR: ${JSON.stringify(data)}`);\n await new Promise((r) => setTimeout(r, 3000));\n }\n throw new Error(`Contenedor ${id} no terminó de procesarse a tiempo`);\n}\n\n// Devuelve el id del post ya publicado en Instagram.\nexport async function publicarEnInstagram(postId: string): Promise {\n const { token, igId } = credenciales();\n const post = await postCompleto(postId);\n if (!post.slug) throw new Error(\"El post no tiene slug\");\n const slides = (await blob.list(`posts/${post.slug}/`)).map((b) => b.key).sort();\n if (slides.length < 2) throw new Error(`Solo hay ${slides.length} slides en blob para ${post.slug}`);\n const hijos: string[] = [];\n for (const key of slides) {\n const r = await graphPost(`${igId}/media`, {\n image_url: `${IMG_BASE}/${key}`,\n is_carousel_item: \"true\",\n }, token);\n hijos.push(r.id);\n }\n for (const h of hijos) await esperarFinished(h, token);\n const carrusel = await graphPost(`${igId}/media`, {\n media_type: \"CAROUSEL\",\n children: hijos.join(\",\"),\n caption: post.caption,\n }, token);\n await esperarFinished(carrusel.id, token);\n const pub = await graphPost(`${igId}/media_publish`, { creation_id: carrusel.id }, token);\n await marcarPublicado(postId);\n return pub.id;\n}\n",[159],"46f48488-bb6a-48e1-9deb-964e011e4ebb","noticias.ts","53bb1ab4-89cd-11f1-b95f-1607ee4eb77e",9,["D",1785165039111],"interval","// Cron matinal: busca noticias de IA de las últimas 24h con Serper,\n// descarta las ya vistas y crea candidatas en Airtable como \"Idea\".\n// La redacción del carrusel sigue siendo humana+Claude en la sesión diaria.\nimport { crearIdeas, Idea, urlsFuente } from \"./airtable.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\ninterface Noticia {\n title: string;\n link: string;\n snippet?: string;\n date?: string;\n source?: string;\n}\n\nconst MAX_POR_CONSULTA = 3;\n\nasync function serperNews(q: string, gl: string, hl: string): Promise {\n const key = Deno.env.get(\"SERPER_API_KEY\");\n if (!key) throw new Error(\"Falta SERPER_API_KEY\");\n const res = await fetch(\"https://google.serper.dev/news\", {\n method: \"POST\",\n headers: { \"X-API-KEY\": key, \"Content-Type\": \"application/json\" },\n body: JSON.stringify({ q, gl, hl, tbs: \"qdr:d\", num: 10 }),\n });\n if (!res.ok) throw new Error(`Serper ${res.status}: ${await res.text()}`);\n return (await res.json()).news ?? [];\n}\n\nexport default async function () {\n const vistas = await urlsFuente();\n const consultas = [\n { q: \"inteligencia artificial\", gl: \"es\", hl: \"es\" },\n { q: \"artificial intelligence\", gl: \"us\", hl: \"en\" },\n ];\n const nuevas: Idea[] = [];\n for (const c of consultas) {\n let cogidas = 0;\n for (const n of await serperNews(c.q, c.gl, c.hl)) {\n if (cogidas >= MAX_POR_CONSULTA) break;\n if (!n.link || vistas.has(n.link)) continue;\n vistas.add(n.link);\n nuevas.push({\n titulo: n.title.slice(0, 120),\n fuente: `${n.source ?? \"?\"} — ${n.date ?? \"últimas 24h\"}`,\n url: n.link,\n resumen: n.snippet ?? \"\",\n });\n cogidas++;\n }\n }\n await crearIdeas(nuevas);\n if (nuevas.length) {\n await enviarTelegram(\n \"📰 Candidatas de hoy (guardadas como Idea en Airtable):\\n\\n\" +\n nuevas.map((n, i) => `${i + 1}. ${n.titulo}\\n ${n.fuente}\\n ${n.url}`).join(\"\\n\\n\"),\n );\n }\n return { creadas: nuevas.length };\n}\n",[166],"2809a3e2-be46-4fc1-8393-44ff7995e2a0","index.ts",13,["D",1785165061641],3,"// Webhook del bot @Trucosdeia_bot: convierte respuestas de Telegram en acciones\n// sobre el pipeline editorial de Airtable.\n//\n// Comandos: \"estado\" · \"ok [slug]\" · \"no [slug]\" · \"nota [slug] \"\nimport { Bot, webhookCallback } from \"https://deno.land/x/grammy@v1.35.0/mod.ts\";\nimport { addNota, Post, postsPorEstado, resumenPipeline, setEstado } from \"./airtable.ts\";\n\nconst TOKEN = Deno.env.get(\"TELEGRAM_TOKEN\");\nif (!TOKEN) throw new Error(\"TELEGRAM_TOKEN no está definido\");\nconst CHAT_ID = Deno.env.get(\"TELEGRAM_CHAT_ID\") ?? \"\";\n\nconst bot = new Bot(TOKEN);\n\n// Solo atiende al chat autorizado.\nbot.use(async (ctx, next) => {\n if (String(ctx.chat?.id ?? \"\") !== CHAT_ID) return;\n await next();\n});\n\nconst AYUDA = [\n \"Comandos que entiendo:\",\n \"· estado — resumen del pipeline\",\n \"· ok — aprueba el post en revisión (ok si hay varios)\",\n \"· no — rechaza el post en revisión (no si hay varios)\",\n \"· nota — apunta feedback en el post en revisión\",\n \"· publica — publica ya el post aprobado (publica si hay varios)\",\n].join(\"\\n\");\n\nbot.command(\"start\", (ctx) => ctx.reply(\"Bot de Trucos de IA listo.\\n\\n\" + AYUDA));\n\n// Resuelve a qué post (del estado dado) se refiere la orden; si hay varios exige slug.\nasync function objetivo(\n arg: string,\n ctx: { reply: (t: string) => Promise },\n estado = \"En revisión\",\n): Promise {\n const pendientes = await postsPorEstado(estado);\n if (pendientes.length === 0) {\n await ctx.reply(`No hay ningún post en estado \"${estado}\" ahora mismo.`);\n return null;\n }\n if (!arg) {\n if (pendientes.length === 1) return pendientes[0];\n await ctx.reply(\"Hay varios en revisión, dime cuál:\\n\" + pendientes.map((p) => `· ${p.slug}`).join(\"\\n\"));\n return null;\n }\n const filtro = arg.toLowerCase();\n const m = pendientes.filter((p) =>\n p.slug.toLowerCase().includes(filtro) || p.titulo.toLowerCase().includes(filtro)\n );\n if (m.length === 1) return m[0];\n await ctx.reply(\n m.length === 0\n ? `No encuentro ningún post en revisión que encaje con \"${arg}\".`\n : \"Encaja con varios:\\n\" + m.map((p) => `· ${p.slug}`).join(\"\\n\"),\n );\n return null;\n}\n\nbot.on(\"message:text\", async (ctx) => {\n const [orden, ...resto] = ctx.message.text.trim().split(/\\s+/);\n const arg = resto.join(\" \");\n try {\n switch (orden.toLowerCase()) {\n case \"estado\": {\n const resumen = await resumenPipeline();\n const FASES = [\"Idea\", \"Borrador\", \"En revisión\", \"Aprobado\", \"Programado\", \"Publicado\", \"Rechazado\"];\n const lineas = FASES.filter((e) => resumen.has(e)).map((e) => `· ${e}: ${resumen.get(e)}`);\n const pendientes = await postsPorEstado(\"En revisión\");\n if (pendientes.length) {\n lineas.push(\"\", \"En revisión:\", ...pendientes.map((p) => `· ${p.slug} — ${p.titulo}`));\n }\n await ctx.reply(\"Pipeline:\\n\" + lineas.join(\"\\n\"));\n break;\n }\n case \"ok\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Aprobado\");\n await ctx.reply(`✅ Aprobado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"no\": {\n const post = await objetivo(arg, ctx);\n if (!post) return;\n await setEstado(post.id, \"Rechazado\");\n await ctx.reply(`❌ Rechazado: ${post.titulo} (${post.slug})`);\n break;\n }\n case \"nota\": {\n const pendientes = await postsPorEstado(\"En revisión\");\n let post: Post | undefined;\n let textoNota = arg;\n if (pendientes.length > 1 && resto.length > 1) {\n const filtro = resto[0].toLowerCase();\n post = pendientes.find((p) => p.slug.toLowerCase().includes(filtro));\n if (post) textoNota = resto.slice(1).join(\" \");\n }\n if (!post && pendientes.length === 1) post = pendientes[0];\n if (!post || !textoNota) {\n await ctx.reply(\n pendientes.length === 0 ? \"No hay posts en revisión.\" : \"Dime a cuál: nota \",\n );\n return;\n }\n await addNota(post.id, textoNota);\n await ctx.reply(`📝 Anotado en ${post.slug}: ${textoNota}`);\n break;\n }\n case \"publica\": {\n // No publica aquí (tardaría más de lo que Telegram espera): encola como\n // \"Programado\" y el cron de cada 15 min lo saca al momento.\n const post = await objetivo(arg, ctx, \"Aprobado\");\n if (!post) return;\n await setEstado(post.id, \"Programado\");\n await ctx.reply(`⏳ En cola: ${post.titulo} (${post.slug}). Saldrá en menos de 15 minutos.`);\n break;\n }\n default:\n await ctx.reply(AYUDA);\n }\n } catch (e) {\n await ctx.reply(\"⚠️ Error: \" + (e instanceof Error ? e.message : String(e)));\n }\n});\n\n// Parte del propio token sirve de secreto para autorizar las llamadas del webhook.\nconst SECRET = TOKEN.split(\":\")[1];\nconst handleUpdate = webhookCallback(bot, \"std/http\", undefined, undefined, SECRET);\n\nlet webhookRegistrado = false;\n\nexport default async (req: Request): Promise => {\n if (!webhookRegistrado) {\n await bot.api.setWebhook(req.url, { secret_token: SECRET });\n webhookRegistrado = true;\n }\n if (req.method === \"POST\") return await handleUpdate(req);\n return new Response(\"Webhook de @Trucosdeia_bot operativo.\", { status: 200 });\n};\n",[174],"6e262461-564a-453b-8a7f-7b053049f1ef","img.ts","22cc5aee-89cd-11f1-8c73-1607ee4eb77e",5,["D",1785164957010],"// Sirve las imágenes de los carruseles desde blob storage.\n// La API de Meta necesita una URL pública por slide: /posts//slide-01.png\nimport { blob } from \"https://esm.town/v/std/blob/main.ts\";\n\nexport default async function (req: Request): Promise {\n const key = decodeURIComponent(new URL(req.url).pathname.replace(/^\\//, \"\"));\n if (!key.startsWith(\"posts/\")) return new Response(\"No encontrado\", { status: 404 });\n try {\n const res = await blob.get(key);\n return new Response(res.body, {\n headers: {\n \"Content-Type\": \"image/png\",\n \"Cache-Control\": \"public, max-age=31536000\",\n },\n });\n } catch {\n return new Response(\"No encontrado\", { status: 404 });\n }\n}\n",[181],"906b4ec7-3f51-44d1-856c-619b31fd31a8","autopublicar.ts","57506774-89cd-11f1-9aab-1607ee4eb77e",10,["D",1785165045121],"// Cron cada 15 min:\n// - publica al momento los posts en \"Programado\" (cola del comando \"publica\" del bot)\n// - en el hueco diario publica el aprobado más antiguo → cadencia de 1 post/día\nimport { postsPorEstado } from \"./airtable.ts\";\nimport { metaConfigurado, publicarEnInstagram } from \"./publicar.ts\";\nimport { enviarTelegram } from \"./telegram.ts\";\n\n// 12:30 Madrid en horario de verano; en invierno cambiar hora a 11.\nconst SLOT_UTC = { hora: 10, minuto: 30 };\n\nexport default async function () {\n if (!metaConfigurado()) return { saltado: \"Meta sin configurar\" };\n const ahora = new Date();\n const enSlot = ahora.getUTCHours() === SLOT_UTC.hora &&\n ahora.getUTCMinutes() >= SLOT_UTC.minuto && ahora.getUTCMinutes() < SLOT_UTC.minuto + 15;\n const cola = await postsPorEstado(\"Programado\");\n if (enSlot && cola.length === 0) {\n const aprobados = await postsPorEstado(\"Aprobado\");\n if (aprobados.length) cola.push(aprobados[0]);\n }\n const resultados: Array> = [];\n for (const post of cola) {\n try {\n const mediaId = await publicarEnInstagram(post.id);\n await enviarTelegram(`🚀 Publicado en Instagram: ${post.titulo} (${post.slug})`);\n resultados.push({ slug: post.slug, mediaId });\n } catch (e) {\n const msg = e instanceof Error ? e.message : String(e);\n await enviarTelegram(`⚠️ Error publicando ${post.slug}: ${msg}`);\n resultados.push({ slug: post.slug, error: msg });\n }\n }\n return { publicados: resultados };\n}\n",[188],"d9a2bf6b-0b34-410c-9b91-a764071b05bf","airtable.ts","049a08b8-89c9-11f1-876e-1607ee4eb77e",7,["D",1785164988671],1,"// Cliente mínimo de la API REST de Airtable para la base \"Trucos de IA\".\nconst API = \"https://api.airtable.com/v0\";\nconst TABLA_POSTS = \"tbl3v4kWgqgJ8auxf\";\n\nexport interface Post {\n id: string;\n titulo: string;\n slug: string;\n pilar: string;\n estado: string;\n}\n\nfunction config() {\n const token = Deno.env.get(\"AIRTABLE_TOKEN\");\n const base = Deno.env.get(\"AIRTABLE_BASE_ID\");\n if (!token) throw new Error(\"Falta AIRTABLE_TOKEN (créalo en airtable.com/create/tokens)\");\n if (!base) throw new Error(\"Falta AIRTABLE_BASE_ID\");\n return { token, base };\n}\n\nasync function at(path: string, init: RequestInit = {}) {\n const { token, base } = config();\n const res = await fetch(`${API}/${base}/${path}`, {\n ...init,\n headers: {\n Authorization: `Bearer ${token}`,\n \"Content-Type\": \"application/json\",\n ...(init.headers ?? {}),\n },\n });\n if (!res.ok) throw new Error(`Airtable ${res.status}: ${await res.text()}`);\n return res.json();\n}\n\nfunction toPost(r: { id: string; fields: Record }): Post {\n return {\n id: r.id,\n titulo: r.fields[\"Título\"] ?? \"(sin título)\",\n slug: r.fields[\"Slug\"] ?? \"\",\n pilar: r.fields[\"Pilar\"] ?? \"\",\n estado: r.fields[\"Estado\"] ?? \"\",\n };\n}\n\nexport async function postsPorEstado(estado: string): Promise {\n const params = new URLSearchParams({ filterByFormula: `{Estado} = '${estado}'` });\n for (const f of [\"Título\", \"Slug\", \"Pilar\", \"Estado\"]) params.append(\"fields[]\", f);\n const data = await at(`${TABLA_POSTS}?${params}`);\n return data.records.map(toPost);\n}\n\nexport async function resumenPipeline(): Promise> {\n const counts = new Map();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"Estado\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n const e = r.fields[\"Estado\"] ?? \"Sin estado\";\n counts.set(e, (counts.get(e) ?? 0) + 1);\n }\n offset = data.offset;\n } while (offset);\n return counts;\n}\n\nexport async function setEstado(id: string, estado: string): Promise {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Estado: estado } }),\n });\n}\n\nexport async function addNota(id: string, texto: string): Promise {\n const rec = await at(`${TABLA_POSTS}/${id}`);\n const previa = rec.fields[\"Notas\"] ?? \"\";\n const fecha = new Date().toISOString().slice(0, 10);\n const nueva = previa ? `${previa}\\n[${fecha}] ${texto}` : `[${fecha}] ${texto}`;\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({ fields: { Notas: nueva } }),\n });\n}\n\nexport interface PostCompleto extends Post {\n caption: string;\n}\n\nexport async function postCompleto(id: string): Promise {\n const r = await at(`${TABLA_POSTS}/${id}`);\n return { ...toPost(r), caption: r.fields[\"Caption\"] ?? \"\" };\n}\n\n// URLs de noticias ya vistas (campo \"URL fuente\") para no proponerlas dos veces.\nexport async function urlsFuente(): Promise> {\n const urls = new Set();\n let offset: string | undefined;\n do {\n const params = new URLSearchParams();\n params.append(\"fields[]\", \"URL fuente\");\n if (offset) params.set(\"offset\", offset);\n const data = await at(`${TABLA_POSTS}?${params}`);\n for (const r of data.records) {\n if (r.fields[\"URL fuente\"]) urls.add(r.fields[\"URL fuente\"]);\n }\n offset = data.offset;\n } while (offset);\n return urls;\n}\n\nexport interface Idea {\n titulo: string;\n fuente: string;\n url: string;\n resumen: string;\n}\n\nexport async function crearIdeas(ideas: Idea[]): Promise {\n if (!ideas.length) return;\n await at(TABLA_POSTS, {\n method: \"POST\",\n body: JSON.stringify({\n records: ideas.map((i) => ({\n fields: {\n \"Título\": i.titulo,\n Estado: \"Idea\",\n Pilar: \"Actualidad\",\n Fuente: i.fuente,\n \"URL fuente\": i.url,\n Notas: i.resumen,\n },\n })),\n }),\n });\n}\n\nexport async function marcarPublicado(id: string): Promise {\n await at(`${TABLA_POSTS}/${id}`, {\n method: \"PATCH\",\n body: JSON.stringify({\n fields: { Estado: \"Publicado\", \"Fecha publicada\": new Date().toISOString().slice(0, 10) },\n }),\n });\n}\n",[195],"934e6f3d-903d-4b31-b035-3e208ab83ddc","README.md","d577bc7e-89c8-11f1-97fc-1607ee4eb77e",["D",1785163109277],"# Trucos de IA — automatización\n\nWebhook de Telegram (aprobación editorial) + cron de noticias del canal @trucos.de.ia.\n",[203],"pulls","branches","forks","envVars",{"_215":217,"_218":61},"connections",{"_215":61,"_216":61},"count","unfilledCount",12,"emptyCount",{"_41":202,"_31":203,"_29":204,"_138":-5,"_39":40,"_38":199,"_139":57,"_36":257,"_13":61,"_32":20,"_34":206,"_23":24,"_141":-5,"_230":258,"_26":259},{"_41":194,"_31":195,"_29":196,"_138":-5,"_39":40,"_38":197,"_139":24,"_36":254,"_13":199,"_32":33,"_34":200,"_23":24,"_141":-5,"_230":255,"_26":256},{"_41":187,"_31":188,"_29":189,"_138":-5,"_39":40,"_38":190,"_139":24,"_36":251,"_13":61,"_32":170,"_34":192,"_23":24,"_141":-5,"_230":252,"_26":253},{"_41":180,"_31":181,"_29":182,"_138":-5,"_39":40,"_38":183,"_139":24,"_36":248,"_13":61,"_32":155,"_34":185,"_23":24,"_141":-5,"_230":249,"_26":250},{"_41":173,"_31":174,"_29":55,"_138":-5,"_39":40,"_38":175,"_139":24,"_36":245,"_13":177,"_32":155,"_34":178,"_23":24,"_141":-5,"_230":246,"_26":247},{"_41":165,"_31":166,"_29":167,"_138":-5,"_39":40,"_38":168,"_139":24,"_36":242,"_13":61,"_32":170,"_34":171,"_23":24,"_141":-5,"_230":243,"_26":244},{"_41":158,"_31":159,"_29":160,"_138":-5,"_39":40,"_38":161,"_139":24,"_36":239,"_13":61,"_32":33,"_34":163,"_23":24,"_141":-5,"_230":240,"_26":241},{"_41":150,"_31":151,"_29":152,"_138":-5,"_39":40,"_38":153,"_139":24,"_36":236,"_13":61,"_32":155,"_34":156,"_23":24,"_141":-5,"_230":237,"_26":238},{"_41":143,"_31":144,"_29":145,"_138":-5,"_39":40,"_38":146,"_139":24,"_36":233,"_13":61,"_32":33,"_34":148,"_23":24,"_141":-5,"_230":234,"_26":235},{"_41":137,"_31":27,"_29":30,"_138":-5,"_39":40,"_38":14,"_139":57,"_36":229,"_13":61,"_32":33,"_34":35,"_23":24,"_141":-5,"_230":231,"_26":232},["D",1785235300474],"children",[],[27],["D",1785164953579],[],[144],["D",1785164962220],[],[151],["D",1785165030104],[],[159],["D",1785165039111],[],[166],["D",1785165061641],[],[174],["D",1785164957010],[],[181],["D",1785165045121],[],[188],["D",1785164988671],[],[195],["D",1785163109277],[],[203],["D",1785163109209],["D",1789484509295],{"_98":97,"_105":100},{"_98":97,"_99":100,"_101":100,"_18":53,"_102":103,"_104":24},{"_13":87,"_31":88,"_41":40,"_89":42,"_90":-5,"_91":-5,"_92":-5,"_93":-5,"_94":-5,"_95":43,"_96":97},"ctx",{"_80":-5,"_124":298,"_299":300,"_301":302,"_303":24,"_304":24,"_305":24,"_306":57,"_307":-5,"_308":-7,"_309":-7,"_310":61,"_311":24,"_312":24,"_313":-5,"_314":24,"_315":24,"_316":24,"_317":-5},"ENV",{"_269":270,"_271":272,"_273":88,"_274":275,"_276":277,"_278":279,"_280":281,"_282":283,"_284":285,"_286":287,"_288":289,"_290":291,"_292":293,"_294":295,"_296":297},"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 · v14