"""Transacao Comercial

Revision ID: 03f34e0286e2
Revises: cef79ed4a795
Create Date: 2025-03-10 12:31:08.864786

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
import fastapi_users_db_sqlalchemy

# revision identifiers, used by Alembic.
revision: str = '03f34e0286e2'
down_revision: Union[str, None] = 'cef79ed4a795'
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None

# Defina o nome do tipo enum e os valores
enum_name = "comercialtransacaocomercialenum"
enum_values = ["PAGAMENTO", "RECEBIMENTO", "AMBOS"]


def upgrade() -> None:
    sa.Enum(*enum_values, name=enum_name).create(op.get_bind())
    # ### commands auto generated by Alembic - please adjust! ###
    op.add_column('comercial_relacoes_comercial', sa.Column('transacao_comercial',
                                                            sa.Enum('PAGAMENTO', 'RECEBIMENTO', 'AMBOS',
                                                                    name='comercialtransacaocomercialenum',
                                                                    inherit_schema=True), nullable=True))
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('comercial_relacoes_comercial', 'transacao_comercial')
    # ### end Alembic commands ###