"""update_ccp_projects_title

Revision ID: cecc9dfc497c
Revises: 3ed255c14cd0
Create Date: 2022-02-17 12:12:31.714916

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = 'cecc9dfc497c'
down_revision = '3ed255c14cd0'
branch_labels = None
depends_on = None


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

    bind.execute(
        f'''
        UPDATE "Project" SET name = RCCP.description
        FROM "RawCCPProjects" RCCP
        WHERE RCCP.title = "Project".name AND "Project".owner_id IS NOT NULL
        '''
    )


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

    bind.execute(
        f'''
        UPDATE "Project" SET name = RCCP.title
        FROM "RawCCPProjects" RCCP
        WHERE RCCP.title = "Project".description AND "Project".owner_id IS NOT NULL
        '''
    )