# SPDX-FileCopyrightText: 2026 Dennis Fink # # SPDX-License-Identifier: BSD-3-Clause """Record source-document lifecycle history separately from deliveries. Revision ID: 4e6fbc9d207a Revises: c8fa49e1a203 """ import sqlalchemy as sa from alembic import op revision = "4e6fbc9d207a" down_revision = "c8fa49e1a203" branch_labels = None depends_on = None def upgrade() -> None: op.create_table( "source_document_events", sa.Column("id", sa.Integer(), primary_key=True, autoincrement=True), sa.Column("source_uuid", sa.Uuid(), nullable=False), sa.Column("action", sa.String(length=80), nullable=False), sa.Column("revision", sa.Integer(), nullable=False), sa.Column("occurred_at", sa.DateTime(timezone=True), nullable=False), sa.ForeignKeyConstraint( ["source_uuid"], ["source_documents.uuid"], ondelete="CASCADE" ), ) op.create_index( "ix_source_document_events_source_id", "source_document_events", ["source_uuid", "id"], ) # The old schema did not retain lifecycle transitions. Seed one honest # baseline snapshot per existing source; do not fabricate earlier events. op.execute( sa.text( """INSERT INTO source_document_events (source_uuid, action, revision, occurred_at) SELECT uuid, 'Existing source at upgrade', revision, CURRENT_TIMESTAMP FROM source_documents""" ) ) def downgrade() -> None: op.drop_index( "ix_source_document_events_source_id", table_name="source_document_events" ) op.drop_table("source_document_events")