"""remove_artist_teams_from_unknown_artists

Revision ID: 62d7062564e7
Revises: ee119f189985
Create Date: 2021-08-27 15:08:59.152964

"""
from alembic import op


# revision identifiers, used by Alembic.
revision = '62d7062564e7'
down_revision = 'ee119f189985'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    bind.execute(f'''
        delete from "ArtistTeamUser" artist_team_user
        using "ArtistTeam" artist_team, "Artist" artist
        where artist_team_user.artist_team_id = artist_team.id
        and artist_team.artist_id = artist.id
        and artist.is_unknown is true;
    ''')

    bind.execute(f'''
        delete from "ArtistTeam" artist_team
        using "Artist" artist
        where artist_team.artist_id = artist.id
        and artist.is_unknown is true;
    ''')