"""remove_artist_team_owner

Revision ID: 298f2a90b66b
Revises: bd8852a6cf9a
Create Date: 2022-12-20 14:31:27.222999

"""
from alembic import op
import sqlalchemy as sa
from migrations.utils import get_table

# revision identifiers, used by Alembic.
revision = '298f2a90b66b'
down_revision = '370afb5971ae'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    artist_team_user_table = get_table(bind, "ArtistTeamUser")
    op.execute(artist_team_user_table.update().where(artist_team_user_table.c.role == 1).values(role=2))
    bind.execute('''
        update "ArtistTeamUser"
        set role = role - 1 where role >= 1;
    ''')
    bind.execute('''
        update "UserProject"
        set role = role - 1 where role >= 1;
    ''')


def downgrade():
    pass