"""Change territories names

Revision ID: 2c6f21dceb1c
Revises: 1dc57c110497
Create Date: 2019-06-05 15:57:13.883773

"""
from alembic import op
import sqlalchemy as sa

from models.territories import Territory


# revision identifiers, used by Alembic.
revision = '2c6f21dceb1c'
down_revision = '1dc57c110497'
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)

    territories = (
        {'id': 52, 'name': 'Croatia'},
        {'id': 68, 'name': 'Falkland Islands'},
        {'id': 73, 'name': 'France Metropolitan'},
        {'id': 102, 'name': 'Iran'},
        {'id': 115, 'name': 'North Korea'},
        {'id': 116, 'name': 'South Korea'},
        {'id': 120, 'name': 'Laos'},
        {'id': 125, 'name': 'Libya'},
        {'id': 143, 'name': 'Federated States of Micronesia'},
        {'id': 144, 'name': 'Moldova'},
        {'id': 216, 'name': 'Tanzania'}
    )

    session.bulk_update_mappings(Territory, territories)
    # ### end Alembic commands ###


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

    territories = (
        {'id': 52, 'name': 'Croatia (Hrvatska)'},
        {'id': 68, 'name': 'Falkland Islands (Malvinas)'},
        {'id': 73, 'name': 'France, Metropolitan'},
        {'id': 102, 'name': 'Iran (Islamic Republic of)'},
        {'id': 115, 'name': 'Korea, Democratic People''s Republic of'},
        {'id': 116, 'name': 'Korea, Republic of'},
        {'id': 120, 'name': 'Lao People''s Democratic Republic'},
        {'id': 125, 'name': 'Libyan Arab Jamahiriya'},
        {'id': 143, 'name': 'Micronesia, Federated States of'},
        {'id': 144, 'name': 'Moldova, Republic of'},
        {'id': 216, 'name': 'Tanzania, United Republic of'}
    )

    session.bulk_update_mappings(Territory, territories)
    # ### end Alembic commands ###