import { manifestFor, object, put, updateManifest } from "./storage.js"; const defaultStorage = { object, put, updateManifest }; const iso = () => new Date().toISOString(); const sql = (env, q, ...args) => env.DB.prepare(q).bind(...args); export async function publish(env, date, storage = defaultStorage) { const row = await sql( env, "SELECT * FROM editions WHERE issue_date=?", date, ).first(); if (!row) return { outcome: "retry", details: "Подготовленный выпуск отсутствует." }; if (row.state === "published") return { outcome: "already-published", details: "Выпуск уже опубликован, копия не создана.", }; let content = JSON.parse(row.content); content.publishedAt = iso(); const key = "editions/" + date + ".json"; if ( !(await storage.put(env, key, JSON.stringify(content), undefined, { "If-None-Match": "*", })) ) { const previous = await storage.object(env, key); if (!previous?.body?.publishedAt) throw Error("Не удалось прочитать уже записанный выпуск."); content = previous.body; } await storage.updateManifest(env, (old) => manifestFor(old, date)); const batch = [ sql( env, "UPDATE editions SET state='published',published_at=?,content=? WHERE issue_date=?", content.publishedAt, JSON.stringify(content), date, ), ]; batch.push( sql( env, "INSERT OR IGNORE INTO stories(id,issue_date,section,url,story) SELECT json_extract(article.value,'$.id'),?,json_extract(sec.value,'$.id'),json_extract(article.value,'$.url'),article.value FROM json_each(?,'$.sections') sec JOIN json_each(sec.value,'$.stories') article", date, JSON.stringify(content), ), ); batch.push( sql( env, "INSERT INTO sources(id,success_at) SELECT key,value FROM json_each(?) WHERE true ON CONFLICT(id) DO UPDATE SET success_at=MAX(success_at,excluded.success_at)", row.checkpoints, ), ); await env.DB.batch(batch); return { outcome: "published", details: "Публикация " + content.publishedAt + ". Материалов: " + content.sections.reduce((n, s) => n + s.stories.length, 0) + ".", }; } export async function markUnavailable(env, date, storage = defaultStorage) { await storage.updateManifest(env, (old) => old.latest && old.latest < date ? { ...old, warning: "Данные обновить не удалось. Показан последний успешный выпуск.", warningDate: date, } : null, ); }