"""set_campaigns_uuid

Revision ID: 9c12a0013d75
Revises: 1e9bcb5c2f0d
Create Date: 2022-07-21 11:07:32.112319

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

# revision identifiers, used by Alembic.
revision = '9c12a0013d75'
down_revision = 'db379fcc05f8'
branch_labels = None
depends_on = None


def upgrade():
    op.drop_column('Campaign', 'uuid')
    bind = op.get_bind()
    bind.execute('CREATE EXTENSION IF NOT EXISTS "uuid-ossp"')
    op.add_column('Campaign', sa.Column('uuid', postgresql.UUID(as_uuid=True),
                                        nullable=False,
                                        server_default=sa.text('uuid_generate_v4()')))
    op.create_unique_constraint('uq_Campaign_uuid', 'Campaign', ['uuid'])


def downgrade():
    op.drop_column('Campaign', 'uuid')
    op.add_column('Campaign', sa.Column('uuid', sa.String(), nullable=True))