"""rename_tables_from_campaign_to_project

Revision ID: 880cbfff9dce
Revises: 266cad6a2d92
Create Date: 2020-05-19 13:14:48.258606

"""
from alembic import op
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = '880cbfff9dce'
down_revision = '266cad6a2d92'
branch_labels = None
depends_on = None


def upgrade():
    # Rename Table
    # ALTER TABLE vendors RENAME TO suppliers;

    # Rename Foreign Key
    # ALTER TABLE name RENAME CONSTRAINT "error_test_id_fkey" TO "the_new_name_fkey";

    bind = op.get_bind()

    ## RENAME CAMPAIGN TO PROJECT
    bind.execute('''
        ALTER TABLE "Campaign_id_seq" RENAME TO "Project_id_seq";
        ALTER INDEX "pk_Campaign" RENAME TO "pk_Project";
        ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_currency_id_Currency" TO "fk_Project_currency_id_Currency";
        ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_label_id_Label" TO "fk_Project_label_id_Label";
        ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_owner_id_User" TO "fk_Project_owner_id_User";
        ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_create_user_id_User" TO "fk_Project_create_user_id_User";
        ALTER TABLE "Campaign" RENAME CONSTRAINT "fk_Campaign_edit_user_id_User" TO "fk_Project_edit_user_id_User";
    ''')
    bind.execute('''
        ALTER TABLE "Campaign" RENAME TO "Project";
    ''')
    bind.execute('''
        ALTER SEQUENCE public."Project_id_seq" OWNED BY public."Project".id;
    ''')

    # RENAME CampaignTargetItem to ProjectTargetItem
    bind.execute('''
            ALTER TABLE "CampaignTargetItem" RENAME COLUMN campaign_id TO project_id;
            ALTER INDEX "pk_CampaignArtist" RENAME TO "pk_ProjectTargetItem";
            ALTER TABLE "CampaignTargetItem" RENAME CONSTRAINT "fk_CampaignArtist_campaign_id_Campaign" TO "fk_ProjectTargetItem_project_id_Project";
            ALTER TABLE "CampaignTargetItem" RENAME CONSTRAINT "fk_CampaignArtist_target_item_id_Polymorphable" TO "fk_ProjectTargetItem_target_item_id_Polymorphable";

    ''')

    bind.execute('''
        ALTER TABLE "CampaignTargetItem" RENAME TO "ProjectTargetItem";
    ''')

    ## RENAME CampaignGenre TO ProjectGenre
    bind.execute('''
        ALTER TABLE "CampaignGenre" RENAME COLUMN campaign_id TO project_id;
        ALTER TABLE "CampaignGenre" RENAME CONSTRAINT "fk_CampaignGenre_campaign_id_Campaign" TO "fk_ProjectGenre_project_id_Project";
        ALTER TABLE "CampaignGenre" RENAME CONSTRAINT "fk_CampaignGenre_genre_id_Genre" TO "fk_ProjectGenre_genre_id_Genre";
        ALTER INDEX "pk_CampaignGenre" RENAME TO "pk_ProjectGenre";
    ''')

    bind.execute('''
        ALTER TABLE "CampaignGenre" RENAME TO "ProjectGenre";
    ''')

    # RENAME CampaignHistoryAction TO ProjectHistoryAction
    bind.execute('''
       ALTER TABLE "CampaignHistoryAction_id_seq" RENAME TO "ProjectHistoryAction_id_seq";
    ''')
    bind.execute('''
        ALTER TABLE "CampaignHistoryAction" RENAME TO "ProjectHistoryAction";
    ''')

    ## RENAME CampaignHistoryItem TO ProjectHistoryItem
    bind.execute('''
        ALTER TABLE "CampaignHistoryItem_id_seq" RENAME TO "ProjectHistoryItem_id_seq";
        ALTER TABLE "CampaignHistoryItem" RENAME COLUMN campaign_id TO project_id;
        ALTER INDEX "pk_CampaignHistoryItem" RENAME TO "pk_ProjectHistoryItem";
        ALTER TABLE "CampaignHistoryItem" RENAME CONSTRAINT "fk_CampaignHistoryItem_campaign_id_Campaign" TO "fk_ProjectHistoryItem_project_id_Project";
        ALTER TABLE "CampaignHistoryItem" RENAME CONSTRAINT "fk_CampaignHistoryItem_activity_id_Activity" TO "fk_ProjectHistoryItem_activity_id_Activity";
        ALTER TABLE "CampaignHistoryItem" RENAME CONSTRAINT "fk_CampaignHistoryItem_action_id_CampaignHistoryAction" TO "fk_ProjectHistoryItem_action_id_ProjectHistoryAction";
        ALTER TABLE "CampaignHistoryItem" RENAME CONSTRAINT "fk_CampaignHistoryItem_user_id_User" TO "fk_ProjectHistoryItem_user_id_User";
    ''')

    bind.execute('''
        ALTER TABLE "CampaignHistoryItem" RENAME TO "ProjectHistoryItem";
    ''')

    ## RENAME CampaignPhase TO ProjectPhase
    bind.execute('''
        ALTER TABLE "CampaignPhase_id_seq" RENAME TO "ProjectPhase_id_seq";
        ALTER INDEX "pk_CampaignPhase" RENAME TO "pk_ProjectPhase";
        ALTER TABLE "CampaignPhase" RENAME COLUMN campaign_id TO project_id;
        ALTER TABLE "CampaignPhase" RENAME CONSTRAINT "fk_CampaignPhase_campaign_id_Campaign" TO "fk_ProjectPhase_project_id_Project";
    ''')
    bind.execute('''
        ALTER TABLE "CampaignPhase" RENAME TO "ProjectPhase";
    ''')

    ## RENAME UserCampaign TO UserProject
    bind.execute('''
        ALTER TABLE "UserCampaign_id_seq" RENAME TO "UserProject_id_seq";
        ALTER INDEX "pk_UserCampaign" RENAME TO "pk_UserProject";
        ALTER TABLE "UserCampaign" RENAME COLUMN campaign_id TO project_id;
        ALTER TABLE "UserCampaign" RENAME CONSTRAINT "fk_UserCampaign_campaign_id_Campaign" TO "fk_UserProject_project_id_Project";
        ALTER TABLE "UserCampaign" RENAME CONSTRAINT "fk_UserCampaign_user_id_User" TO "fk_UserProject_user_id_User";
        ALTER TABLE "UserCampaign" RENAME CONSTRAINT "fk_UserCampaign_shared_by_User" TO "fk_UserProject_shared_by_User";
    ''')
    bind.execute('''
        ALTER TABLE "UserCampaign" RENAME TO "UserProject";
    ''')

    ## RENAME UserCampaignActivityTypeGroup TO UserProjectActivityTypeGroup
    bind.execute('''
        ALTER INDEX "pk_UserCampaignActivityTypeGroup" RENAME TO "pk_UserProjectActivityTypeGroup";
        ALTER TABLE "UserCampaignActivityTypeGroup" RENAME COLUMN user_campaign_id TO user_project_id;
        ALTER TABLE "UserCampaignActivityTypeGroup" RENAME CONSTRAINT "fk_UserCampaignActivityTypeGroup_activity_type_group_id_7f12" TO "fk_UserProjectActivityTypeGroup_activity_type_group_id_7f12";
        ALTER TABLE "UserCampaignActivityTypeGroup" RENAME CONSTRAINT "fk_UserCampaignActivityTypeGroup_user_campaign_id_UserCampaign" TO "fk_UserProjectActivityTypeGroup_user_project_id_UserProject";
    ''')
    bind.execute('''
        ALTER TABLE "UserCampaignActivityTypeGroup" RENAME TO "UserProjectActivityTypeGroup";
    ''')

    ## RENAME Activity campaign_id field
    bind.execute('''
         ALTER TABLE "Activity" RENAME COLUMN campaign_id TO project_id;
         ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_campaign_id_Campaign" TO "fk_Activity_project_id_Project";
    ''')


def downgrade():
    bind = op.get_bind()
    bind.execute('''
        ALTER TABLE "Project_id_seq" RENAME TO "Campaign_id_seq";
        ALTER INDEX "pk_Project" RENAME TO "pk_Campaign";
        ALTER TABLE "Project" RENAME CONSTRAINT "fk_Project_currency_id_Currency" TO "fk_Campaign_currency_id_Currency";
        ALTER TABLE "Project" RENAME CONSTRAINT "fk_Project_label_id_Label" TO "fk_Campaign_label_id_Label";
        ALTER TABLE "Project" RENAME CONSTRAINT "fk_Project_owner_id_User" TO "fk_Campaign_owner_id_User";
        ALTER TABLE "Project" RENAME CONSTRAINT "fk_Project_create_user_id_User" TO "fk_Campaign_create_user_id_User";
        ALTER TABLE "Project" RENAME CONSTRAINT "fk_Project_edit_user_id_User" TO "fk_Campaign_edit_user_id_User";
    ''')
    bind.execute('''
        ALTER TABLE "Project" RENAME TO "Campaign";
    ''')

    bind.execute('''
        ALTER SEQUENCE public."Campaign_id_seq" OWNED BY public."Campaign".id;
    ''')

    # RENAME CampaignTargetItem to ProjectTargetItem
    bind.execute('''
            ALTER TABLE "ProjectTargetItem" RENAME COLUMN project_id TO campaign_id;
            ALTER INDEX "pk_ProjectTargetItem" RENAME TO "pk_CampaignArtist";
            ALTER TABLE "ProjectTargetItem" RENAME CONSTRAINT "fk_ProjectTargetItem_project_id_Project" TO "fk_CampaignArtist_campaign_id_Campaign";
            ALTER TABLE "ProjectTargetItem" RENAME CONSTRAINT "fk_ProjectTargetItem_target_item_id_Polymorphable" TO "fk_CampaignArtist_target_item_id_Polymorphable";

    ''')

    bind.execute('''
        ALTER TABLE "ProjectTargetItem" RENAME TO "CampaignTargetItem";
    ''')

    bind.execute('''
        ALTER TABLE "ProjectGenre" RENAME COLUMN project_id TO campaign_id;
        ALTER TABLE "ProjectGenre" RENAME CONSTRAINT "fk_ProjectGenre_project_id_Project" TO "fk_CampaignGenre_campaign_id_Campaign";
        ALTER TABLE "ProjectGenre" RENAME CONSTRAINT "fk_ProjectGenre_genre_id_Genre" TO "fk_CampaignGenre_genre_id_Genre";
        ALTER INDEX "pk_ProjectGenre" RENAME TO "pk_CampaignGenre";
    ''')

    bind.execute('''
        ALTER TABLE "ProjectGenre" RENAME TO "CampaignGenre";
    ''')

    bind.execute('''
       ALTER TABLE "ProjectHistoryAction_id_seq" RENAME TO "CampaignHistoryAction_id_seq";
    ''')
    bind.execute('''
        ALTER TABLE "ProjectHistoryAction" RENAME TO "CampaignHistoryAction";
    ''')

    ## RENAME ProjectHistoryItem TO CampaignHistoryItem
    bind.execute('''
        ALTER TABLE "ProjectHistoryItem_id_seq" RENAME TO "CampaignHistoryItem_id_seq";
        ALTER TABLE "ProjectHistoryItem" RENAME COLUMN project_id TO campaign_id;
        ALTER INDEX "pk_ProjectHistoryItem" RENAME TO "pk_CampaignHistoryItem";
        ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_project_id_Project" TO "fk_CampaignHistoryItem_campaign_id_Campaign";
        ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_activity_id_Activity" TO "fk_CampaignHistoryItem_activity_id_Activity";
        ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_action_id_ProjectHistoryAction" TO "fk_CampaignHistoryItem_action_id_CampaignHistoryAction";
        ALTER TABLE "ProjectHistoryItem" RENAME CONSTRAINT "fk_ProjectHistoryItem_user_id_User" TO "fk_CampaignHistoryItem_user_id_User";
    ''')

    bind.execute('''
        ALTER TABLE "ProjectHistoryItem" RENAME TO "CampaignHistoryItem";
    ''')


    ## RENAME ProjectPhase TO CampaignPhase
    bind.execute('''
        ALTER TABLE "ProjectPhase_id_seq" RENAME TO "CampaignPhase_id_seq";
        ALTER INDEX "pk_ProjectPhase" RENAME TO "pk_CampaignPhase";
        ALTER TABLE "ProjectPhase" RENAME COLUMN project_id TO campaign_id;
        ALTER TABLE "ProjectPhase" RENAME CONSTRAINT "fk_ProjectPhase_project_id_Project" TO "fk_CampaignPhase_campaign_id_Campaign";
    ''')
    bind.execute('''
        ALTER TABLE "ProjectPhase" RENAME TO "CampaignPhase";
    ''')

    ## RENAME UserProject TO UserCampaign
    bind.execute('''
        ALTER TABLE "UserProject_id_seq" RENAME TO "UserCampaign_id_seq";
        ALTER INDEX "pk_UserProject" RENAME TO "pk_UserCampaign";
        ALTER TABLE "UserProject" RENAME COLUMN project_id TO campaign_id;
        ALTER TABLE "UserProject" RENAME CONSTRAINT "fk_UserProject_project_id_Project" TO "fk_UserCampaign_campaign_id_Campaign";
        ALTER TABLE "UserProject" RENAME CONSTRAINT "fk_UserProject_user_id_User" TO "fk_UserCampaign_user_id_User";
        ALTER TABLE "UserProject" RENAME CONSTRAINT "fk_UserProject_shared_by_User" TO "fk_UserCampaign_shared_by_User";
    ''')
    bind.execute('''
        ALTER TABLE "UserProject" RENAME TO "UserCampaign";
    ''')

    ## RENAME UserProjectActivityTypeGroup TO UserCampaignActivityTypeGroup
    bind.execute('''
        ALTER INDEX "pk_UserProjectActivityTypeGroup" RENAME TO "pk_UserCampaignActivityTypeGroup";
        ALTER TABLE "UserProjectActivityTypeGroup" RENAME COLUMN user_project_id TO user_campaign_id;
        ALTER TABLE "UserProjectActivityTypeGroup" RENAME CONSTRAINT "fk_UserProjectActivityTypeGroup_activity_type_group_id_7f12" TO "fk_UserCampaignActivityTypeGroup_activity_type_group_id_7f12";
        ALTER TABLE "UserProjectActivityTypeGroup" RENAME CONSTRAINT "fk_UserProjectActivityTypeGroup_user_project_id_UserProject" TO "fk_UserCampaignActivityTypeGroup_user_campaign_id_UserCampaign";
    ''')
    bind.execute('''
        ALTER TABLE "UserProjectActivityTypeGroup" RENAME TO "UserCampaignActivityTypeGroup";
    ''')

    ## RENAME Activity campaign_id field
    bind.execute('''
         ALTER TABLE "Activity" RENAME COLUMN project_id TO campaign_id;
         ALTER TABLE "Activity" RENAME CONSTRAINT "fk_Activity_project_id_Project" TO "fk_Activity_campaign_id_Campaign";
    ''')