"""fix_phase_triggers

Revision ID: 8804ac239c9d
Revises: 51438879ba31
Create Date: 2021-05-14 12:20:29.423143

"""
from alembic import op

from migrations.fixtures.delphi_tables.v1.tables import DelphiTables
from migrations.fixtures.delphi_tables.v1.data_migrator import DataMigrator

from migrations.fixtures.delphi_tables.v1.trigger_migrator import TriggerMigrator
from migrations.fixtures.delphi_tables.v1.triggers.project_phase_trigger import ProjectPhaseTrigger

# revision identifiers, used by Alembic.
revision = '8804ac239c9d'
down_revision = '51438879ba31'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    delphi_tables = DelphiTables(bind)
    data_migrator = DataMigrator(bind)
    delphi_tables.drop()
    delphi_tables.create()
    data_migrator.execute()
    delphi_tables.reindex()
    TriggerMigrator(bind, ProjectPhaseTrigger()).rollback()
    TriggerMigrator(bind, ProjectPhaseTrigger()).upgrade()