"""upgrade_triggers_artist_team_user

Revision ID: 7b3e94e1aa5b
Revises: 9576c33caf0f
Create Date: 2023-01-25 20:52:54.588335

"""
from alembic import op
import sqlalchemy as sa
from migrations.fixtures.delphi_tables.v7.data_refresher import DelphiTablesDataRefresher as DelphiTablesDataRefresherV7
from migrations.fixtures.delphi_tables.v8.data_refresher import DelphiTablesDataRefresher as DelphiTablesDataRefresherV8
from migrations.fixtures.delphi_tables.views import DelphiViewsV7

# revision identifiers, used by Alembic.
revision = '7b3e94e1aa5b'
down_revision = '9576c33caf0f'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    delphi_views = DelphiViewsV7(bind)
    delphi_views.drop()

    delphi_refresherv7 = DelphiTablesDataRefresherV7()
    delphi_refresherv7.drop_triggers(bind)

    delphi_refresher = DelphiTablesDataRefresherV8()

    delphi_refresher.refresh(bind)


def downgrade():
    pass