OpenStack Study: 1149d7de0cfa_port_security.py

**** CubicPower OpenStack Study ****

def upgrade(active_plugins=None, options=None):

    if not migration.should_run(active_plugins, migration_for_plugins):

        return

    ### commands auto generated by Alembic - please adjust! ###

    op.create_table('networksecuritybindings',

                    sa.Column('network_id', sa.String(length=36),

                              nullable=False),

                    sa.Column('port_security_enabled', sa.Boolean(),

                              nullable=False),

                    sa.ForeignKeyConstraint(['network_id'], ['networks.id'],

                                            ondelete='CASCADE'),

                    sa.PrimaryKeyConstraint('network_id'))

    op.create_table('portsecuritybindings',

                    sa.Column('port_id', sa.String(length=36),

                              nullable=False),

                    sa.Column('port_security_enabled', sa.Boolean(),

                              nullable=False),

                    sa.ForeignKeyConstraint(['port_id'], ['ports.id'],

                                            ondelete='CASCADE'),

                    sa.PrimaryKeyConstraint('port_id'))

    ### end Alembic commands ###

    # Copy network and port ids over to network|port(securitybindings) table

    # and set port_security_enabled to false as ip address pairs were not

    # configured in NVP/NSX originally.

    op.execute("INSERT INTO networksecuritybindings SELECT id as "

               "network_id, False as port_security_enabled from networks")

    op.execute("INSERT INTO portsecuritybindings SELECT id as port_id, "

               "False as port_security_enabled from ports")

**** CubicPower OpenStack Study ****

def downgrade(active_plugins=None, options=None):

    if not migration.should_run(active_plugins, migration_for_plugins):

        return

    ### commands auto generated by Alembic - please adjust! ###

    op.drop_table('portsecuritybindings')

    op.drop_table('networksecuritybindings')

    ### end Alembic commands ###