"""add reversal fields to stock_history

Revision ID: 84aa6d72a6b7
Revises: a1b2c3d4e5f6
Create Date: 2026-07-08 15:03:45.248289

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa

from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision: str = '84aa6d72a6b7'
down_revision: Union[str, None] = 'a1b2c3d4e5f6'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


# def upgrade() -> None:
#     # ### commands auto generated by Alembic - please adjust! ###
#     op.add_column('stock_history', sa.Column('is_reversal', sa.Boolean(), nullable=False))
#     op.add_column('stock_history', sa.Column('is_reversed', sa.Boolean(), nullable=False))
#     op.add_column('stock_history', sa.Column('reversed_entry_id', sa.UUID(), nullable=True))
#     op.create_foreign_key(None, 'stock_history', 'stock_history', ['reversed_entry_id'], ['id'], ondelete='SET NULL')
#     # ### end Alembic commands ###



# def downgrade() -> None:
#     # ### commands auto generated by Alembic - please adjust! ###
#     op.drop_constraint(None, 'stock_history', type_='foreignkey')
#     op.drop_column('stock_history', 'reversed_entry_id')
#     op.drop_column('stock_history', 'is_reversed')
#     op.drop_column('stock_history', 'is_reversal')
#     # ### end Alembic commands ###





# v2
def upgrade():
    op.add_column(
        'stock_history',
        sa.Column('is_reversal', sa.Boolean(), nullable=False, server_default=sa.false())
    )
    op.add_column(
        'stock_history',
        sa.Column('is_reversed', sa.Boolean(), nullable=False, server_default=sa.false())
    )
    op.add_column(
        'stock_history',
        sa.Column('reversed_entry_id', postgresql.UUID(as_uuid=True), nullable=True)
    )
    op.create_foreign_key(
        None, 'stock_history', 'stock_history', ['reversed_entry_id'], ['id'], ondelete='SET NULL'
    )

    
def downgrade():
    op.drop_constraint(None, 'stock_history', type_='foreignkey')
    op.drop_column('stock_history', 'reversed_entry_id')
    op.drop_column('stock_history', 'is_reversed')
    op.drop_column('stock_history', 'is_reversal')