--- export const prerender = false; import { isAuthenticated, ADMIN_COOKIE } from '@admin/lib/admin-auth'; interface Env { DB: D1Database } const runtime = Astro.locals.runtime as { env: Env } | undefined; const db = runtime?.env?.DB; if (!db || !await isAuthenticated(Astro.cookies.get(ADMIN_COOKIE)?.value, db)) { return Astro.redirect('/admin/login', 302); } interface ScraperRun { id: number; chain_id: string; city_id: string; started_at: string; finished_at: string | null; status: string; movies_found: number; showtimes_found: number; error_message: string | null; } let runs: ScraperRun[] = []; let dbError: string | null = null; const page = Number(Astro.url.searchParams.get('page') ?? '1'); const limit = 100; const offset = (page - 1) * limit; if (db) { try { const result = await db.prepare('SELECT * FROM scraper_runs ORDER BY id DESC LIMIT ? OFFSET ?').bind(limit, offset).all(); runs = result.results as ScraperRun[]; } catch (e) { dbError = String(e); } } else { dbError = 'D1 database binding not available.'; } function duration(started: string, finished: string | null): string { if (!finished) return '—'; const ms = new Date(finished).getTime() - new Date(started).getTime(); if (ms < 0) return '—'; const s = Math.round(ms / 1000); return s < 60 ? `${s}s` : `${Math.floor(s / 60)}m ${s % 60}s`; } function relativeTime(dt: string | null): string { if (!dt) return '—'; const m = Math.floor((Date.now() - new Date(dt).getTime()) / 60000); if (m < 1) return 'just now'; if (m < 60) return `${m}m ago`; const h = Math.floor(m / 60); if (h < 24) return `${h}h ago`; return `${Math.floor(h / 24)}d ago`; } --- All Runs — CultRoll Admin

All Scraper Runs

page {page}
{dbError &&
⚠ DB error: {dbError}
}
{runs.length === 0 && ( )} {runs.map(run => ( ))}
# Chain City Status Started Duration Movies Showtimes Error
No runs found.
#{run.id} {run.chain_id} {run.city_id ?? '—'} {run.status} {relativeTime(run.started_at)} {duration(run.started_at, run.finished_at)} {run.movies_found ?? 0} {run.showtimes_found ?? 0} {run.error_message ?? ''}