1 # Copyright 2014 OpenStack Foundation
3 # Licensed under the Apache License, Version 2.0 (the "License"); you may
4 # not use this file except in compliance with the License. You may obtain
5 # a copy of the License at
7 # http://www.apache.org/licenses/LICENSE-2.0
9 # Unless required by applicable law or agreed to in writing, software
10 # distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
11 # WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
12 # License for the specific language governing permissions and limitations
16 """NEC Rename quantum_id to neutron_id
18 Revision ID: 538732fa21e1
20 Create Date: 2014-03-04 05:43:33.660601
24 # revision identifiers, used by Alembic.
25 revision = '538732fa21e1'
26 down_revision = '2447ad0e9585'
28 # Change to ['*'] if this migration applies to all plugins
30 migration_for_plugins = [
31 'neutron.plugins.nec.nec_plugin.NECPluginV2'
34 from alembic import op
35 import sqlalchemy as sa
37 from neutron.db import migration
40 def upgrade(active_plugins=None, options=None):
41 if not migration.should_run(active_plugins, migration_for_plugins):
44 for table in ['ofctenantmappings', 'ofcnetworkmappings',
45 'ofcportmappings', 'ofcfiltermappings',
48 op.alter_column(table, 'quantum_id',
49 new_column_name='neutron_id',
50 existing_type=sa.String(length=36),
51 existing_nullable=False)
54 def downgrade(active_plugins=None, options=None):
55 if not migration.should_run(active_plugins, migration_for_plugins):
58 for table in ['ofctenantmappings', 'ofcnetworkmappings',
59 'ofcportmappings', 'ofcfiltermappings',
62 op.alter_column(table, 'neutron_id',
63 new_column_name='quantum_id',
64 existing_type=sa.String(length=36),
65 existing_nullable=False)