fossasia/open-event-orga-server

"""empty message

Revision ID: 89a5b836b406
Revises: c517c6be040d
Create Date: 2019-06-06 13:08:53.755940

"""

from alembic import op
import sqlalchemy as sa
import sqlalchemy_utils


# revision identifiers, used by Alembic.
revision = '89a5b836b406'
down_revision = 'c517c6be040d'


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.execute(
        """DELETE FROM role_invites R1
        USING role_invites R2
        WHERE R1.id > R2.id
        AND R1.email = R2.email
        AND R1.role_id = R2.role_id
        AND R1.event_id = R2.event_id
        """
    )
    op.create_unique_constraint('email_role_event_uc', 'role_invites', ['email', 'role_id', 'event_id'])
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_constraint('email_role_event_uc', 'role_invites', type_='unique')
    # ### end Alembic commands ###