"""naming_convention_field

Revision ID: db379fcc05f8
Revises: 120b53873f01
Create Date: 2022-07-27 09:24:06.874972

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

# revision identifiers, used by Alembic.
revision = 'db379fcc05f8'
down_revision = '120b53873f01'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()

    bind.execute(
        '''
        ALTER TABLE "Campaign"
        RENAME COLUMN name_autogenerated to naming_convention_autogenerated
        '''
    )

    op.add_column('Campaign', sa.Column('naming_convention', sa.String(), nullable=True))

    bind.execute(
        f'''
            UPDATE "Campaign"
            SET naming_convention = name
            WHERE is_deleted is FALSE AND naming_convention_autogenerated is TRUE
            AND (source is NULL OR source = 'dec')
        ''')


def downgrade():
    bind = op.get_bind()

    bind.execute(
        '''
        ALTER TABLE "Campaign"
        RENAME COLUMN naming_convention_autogenerated to name_autogenerated
        '''
    )

    op.drop_column('Campaign', 'naming_convention')