
# revision identifiers, used by Alembic.
revision = '0165_another_letter_org'
down_revision = '0164_add_organisation_to_service'

from alembic import op


NEW_ORGANISATIONS = [
    ('502', 'Welsh Revenue Authority'),
]


def upgrade():
    for numeric_id, name in NEW_ORGANISATIONS:
        op.execute("""
            INSERT
                INTO dvla_organisation
                VALUES ('{}', '{}')
        """.format(numeric_id, name))


def downgrade():
    for numeric_id, _ in NEW_ORGANISATIONS:
        op.execute("""
            DELETE
                FROM dvla_organisation
                WHERE id = '{}'
        """.format(numeric_id))


# revision identifiers, used by Alembic.
revision = '0165_another_letter_org'
down_revision = '0164_add_organisation_to_service'

from alembic import op


NEW_ORGANISATIONS = [
    ('502', 'Welsh Revenue Authority'),
    ('503', 'East Riding of Yorkshire Council'),
]


def upgrade():
    for numeric_id, name in NEW_ORGANISATIONS:
        op.execute("""
            INSERT
                INTO dvla_organisation
                VALUES ('{}', '{}')
        """.format(numeric_id, name))


def downgrade():
    for numeric_id, _ in NEW_ORGANISATIONS:
        op.execute("""
            DELETE
                FROM dvla_organisation
                WHERE id = '{}'
        """.format(numeric_id))

Add East Riding of Yorkshire Council to migration
Add East Riding of Yorkshire Council to migration

  
  # revision identifiers, used by Alembic.
  revision = '0165_another_letter_org'
  down_revision = '0164_add_organisation_to_service'
  
  from alembic import op
  
  
  NEW_ORGANISATIONS = [
      ('502', 'Welsh Revenue Authority'),
+     ('503', 'East Riding of Yorkshire Council'),
  ]
  
  
  def upgrade():
      for numeric_id, name in NEW_ORGANISATIONS:
          op.execute("""
              INSERT
                  INTO dvla_organisation
                  VALUES ('{}', '{}')
          """.format(numeric_id, name))
  
  
  def downgrade():
      for numeric_id, _ in NEW_ORGANISATIONS:
          op.execute("""
              DELETE
                  FROM dvla_organisation
                  WHERE id = '{}'
          """.format(numeric_id))
  
Add East Riding of Yorkshire Council to migration
## Code Before:

# revision identifiers, used by Alembic.
revision = '0165_another_letter_org'
down_revision = '0164_add_organisation_to_service'

from alembic import op


NEW_ORGANISATIONS = [
    ('502', 'Welsh Revenue Authority'),
]


def upgrade():
    for numeric_id, name in NEW_ORGANISATIONS:
        op.execute("""
            INSERT
                INTO dvla_organisation
                VALUES ('{}', '{}')
        """.format(numeric_id, name))


def downgrade():
    for numeric_id, _ in NEW_ORGANISATIONS:
        op.execute("""
            DELETE
                FROM dvla_organisation
                WHERE id = '{}'
        """.format(numeric_id))

## Instruction:
Add East Riding of Yorkshire Council to migration
## Code After:

# revision identifiers, used by Alembic.
revision = '0165_another_letter_org'
down_revision = '0164_add_organisation_to_service'

from alembic import op


NEW_ORGANISATIONS = [
    ('502', 'Welsh Revenue Authority'),
    ('503', 'East Riding of Yorkshire Council'),
]


def upgrade():
    for numeric_id, name in NEW_ORGANISATIONS:
        op.execute("""
            INSERT
                INTO dvla_organisation
                VALUES ('{}', '{}')
        """.format(numeric_id, name))


def downgrade():
    for numeric_id, _ in NEW_ORGANISATIONS:
        op.execute("""
            DELETE
                FROM dvla_organisation
                WHERE id = '{}'
        """.format(numeric_id))
