"""Teste Campo Ativo

Revision ID: aabed61bf4b6
Revises: 03f34e0286e2
Create Date: 2025-03-17 08:06:24.204853

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
import fastapi_users_db_sqlalchemy
from sqlalchemy.dialects import postgresql

# revision identifiers, used by Alembic.
revision: str = 'aabed61bf4b6'
down_revision: Union[str, None] = '03f34e0286e2'
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.alter_column('comercial_relacoes_comercial', 'transacao_comercial',
               existing_type=postgresql.ENUM('PAGAMENTO', 'RECEBIMENTO', 'AMBOS', name='comercialtransacaocomercialenum'),
               nullable=False)
    op.add_column('comercial_tipos_endereco', sa.Column('ativo', sa.Boolean(), server_default=sa.text('true'), nullable=False))
    op.add_column('comercial_tipos_endereco', sa.Column('data_ativacao', sa.DateTime(), server_default=sa.text("TIMEZONE('utc', CURRENT_TIMESTAMP)"), nullable=False))
    op.add_column('comercial_tipos_endereco', sa.Column('data_desativacao', sa.DateTime(), server_default=sa.text("TIMEZONE('utc', CURRENT_TIMESTAMP)"), nullable=True))
    # ### end Alembic commands ###


def downgrade() -> None:
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_column('comercial_tipos_endereco', 'data_desativacao')
    op.drop_column('comercial_tipos_endereco', 'data_ativacao')
    op.drop_column('comercial_tipos_endereco', 'ativo')
    op.alter_column('comercial_relacoes_comercial', 'transacao_comercial',
               existing_type=postgresql.ENUM('PAGAMENTO', 'RECEBIMENTO', 'AMBOS', name='comercialtransacaocomercialenum'),
               nullable=True)
    # ### end Alembic commands ###