"""fix_duplicates_in_user_project

Revision ID: ee119f189985
Revises: 1d5d002695dc
Create Date: 2021-08-26 12:18:17.324975

"""
from alembic import op


# revision identifiers, used by Alembic.
revision = 'ee119f189985'
down_revision = '1d5d002695dc'
branch_labels = None
depends_on = None


def upgrade():
    bind = op.get_bind()
    bind.execute(f'''
        delete from "UserProject" a
        using "UserProject" b
        where a.id > b.id
        and a.user_id = b.user_id
        and a.project_id = b.project_id;
    ''')