"""update latin label

Revision ID: db1b657b7edd
Revises: d5eb748142a3
Create Date: 2019-09-06 11:16:29.752973

"""
from alembic import op
from models.labels import Label
import sqlalchemy as sa


# revision identifiers, used by Alembic.
revision = "db1b657b7edd"
down_revision = "d5eb748142a3"
branch_labels = None
depends_on = None


def upgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    bind = op.get_bind()
    session = sa.orm.Session(bind=bind)

    session.query(Label).filter(Label.name == "Latin Regional").update(
        {Label.name: "Latin Iberia"}, synchronize_session=False
    )

    session.commit()
    session.close()
    # ### end Alembic commands ###


def downgrade():
    # ### commands auto generated by Alembic - please adjust! ###
    bind = op.get_bind()
    session = sa.orm.Session(bind=bind)

    session.query(Label).filter(Label.name == "Latin Iberia").update(
        {Label.name: "Latin Regional"}, synchronize_session=False
    )

    session.commit()
    session.close()
    # ### end Alembic commands ###