← Back to branch summary

~niedbalski/ubuntu/vivid/neutron/fixes-1447803

« back to all changes in this revision

Viewing changes to neutron/db/migration/alembic_migrations/versions/1149d7de0cfa_port_security.py

  • Committer: Package Import Robot
  • Author(s): James Page
  • Date: 2014-10-03 18:45:23 UTC
  • mfrom: (1.1.15)
  • Revision ID: package-import@ubuntu.com-20141003184523-4mt6dy1q3j8n30c9
Tags: 1:2014.2~rc1-0ubuntu1
https://launchpad.net/bugs/1323729
* New upstream release candidate:
  - d/p/*: Refreshed.
  - d/control: Add python-requests-mock to BD's.
  - d/control: Align versioned requirements with upstream.
* Transition linuxbridge and openvswitch plugin users to modular
  layer 2 plugin (LP: #1323729):
  - d/control: Mark removed plugin packages as transitional, depend
    on neutron-plugin-ml2, mark oldlibs/extra.
  - d/neutron-plugin-{linuxbridge,openvswitch}.install: Drop.
  - d/control: Depend on neutron-plugin-ml2 for linuxbridge
    agent package.
  - d/neutron-plugin-linuxbridge-agent.upstart: Use ml2 plugin
    configuration files.

Show diffs side-by-side

added added

removed removed

Lines of Context:
neutron/db/migration/alembic_migrations/versions/1149d7de0cfa_port_security.py
1
 
# Copyright 2013 OpenStack Foundation
2
 
#
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
6
 
#
7
 
#         http://www.apache.org/licenses/LICENSE-2.0
8
 
#
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
13
 
#    under the License.
14
 
#
15
 
 
16
 
"""initial port security
17
 
 
18
 
Revision ID: 1149d7de0cfa
19
 
Revises: 1b693c095aa3
20
 
Create Date: 2013-01-22 14:05:20.696502
21
 
 
22
 
"""
23
 
 
24
 
# revision identifiers, used by Alembic.
25
 
revision = '1149d7de0cfa'
26
 
down_revision = '1b693c095aa3'
27
 
 
28
 
# Change to ['*'] if this migration applies to all plugins
29
 
 
30
 
migration_for_plugins = [
31
 
    'neutron.plugins.nicira.NeutronPlugin.NvpPluginV2',
32
 
    'neutron.plugins.nicira.NeutronServicePlugin.NvpAdvancedPlugin',
33
 
    'neutron.plugins.vmware.plugin.NsxPlugin',
34
 
    'neutron.plugins.vmware.plugin.NsxServicePlugin'
35
 
]
36
 
 
37
 
from alembic import op
38
 
import sqlalchemy as sa
39
 
 
40
 
from neutron.db import migration
41
 
 
42
 
 
43
 
def upgrade(active_plugins=None, options=None):
44
 
    if not migration.should_run(active_plugins, migration_for_plugins):
45
 
        return
46
 
 
47
 
    ### commands auto generated by Alembic - please adjust! ###
48
 
    op.create_table('networksecuritybindings',
49
 
                    sa.Column('network_id', sa.String(length=36),
50
 
                              nullable=False),
51
 
                    sa.Column('port_security_enabled', sa.Boolean(),
52
 
                              nullable=False),
53
 
                    sa.ForeignKeyConstraint(['network_id'], ['networks.id'],
54
 
                                            ondelete='CASCADE'),
55
 
                    sa.PrimaryKeyConstraint('network_id'))
56
 
    op.create_table('portsecuritybindings',
57
 
                    sa.Column('port_id', sa.String(length=36),
58
 
                              nullable=False),
59
 
                    sa.Column('port_security_enabled', sa.Boolean(),
60
 
                              nullable=False),
61
 
                    sa.ForeignKeyConstraint(['port_id'], ['ports.id'],
62
 
                                            ondelete='CASCADE'),
63
 
                    sa.PrimaryKeyConstraint('port_id'))
64
 
    ### end Alembic commands ###
65
 
 
66
 
    # Copy network and port ids over to network|port(securitybindings) table
67
 
    # and set port_security_enabled to false as ip address pairs were not
68
 
    # configured in NVP/NSX originally.
69
 
    op.execute("INSERT INTO networksecuritybindings SELECT id as "
70
 
               "network_id, False as port_security_enabled from networks")
71
 
    op.execute("INSERT INTO portsecuritybindings SELECT id as port_id, "
72
 
               "False as port_security_enabled from ports")
73
 
 
74
 
 
75
 
def downgrade(active_plugins=None, options=None):
76
 
    if not migration.should_run(active_plugins, migration_for_plugins):
77
 
        return
78
 
 
79
 
    ### commands auto generated by Alembic - please adjust! ###
80
 
    op.drop_table('portsecuritybindings')
81
 
    op.drop_table('networksecuritybindings')
82
 
    ### end Alembic commands ###