# SPDX-FileCopyrightText: 2026 Dennis Fink # # SPDX-License-Identifier: BSD-3-Clause """Track the last successful source scan. Revision ID: 2b4c6e8a0d12 Revises: ef8a9b6c2d41 """ import sqlalchemy as sa from alembic import op revision = "2b4c6e8a0d12" down_revision = "ef8a9b6c2d41" branch_labels = None depends_on = None def upgrade(): op.create_table( "scan_state", sa.Column("id", sa.Integer(), primary_key=True), sa.Column("last_completed_at", sa.DateTime(timezone=True), nullable=False), ) # Seed a best-effort historical completion time from previously scanned # sources. The next completed scan will update the authoritative value. op.execute( sa.text( "INSERT INTO scan_state (id, last_completed_at) " "SELECT 1, MAX(last_seen_at) FROM source_documents " "HAVING COUNT(*) > 0" ) ) def downgrade(): op.drop_table("scan_state")