OpenStack Study: f44ab9871cd6_bsn_security_groups.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(

        'securitygroups',

        sa.Column('tenant_id', sa.String(length=255), nullable=True),

        sa.Column('id', sa.String(length=36), nullable=False),

        sa.Column('name', sa.String(length=255), nullable=True),

        sa.Column('description', sa.String(length=255), nullable=True),

        sa.PrimaryKeyConstraint('id')

    )

    op.create_table(

        'securitygrouprules',

        sa.Column('tenant_id', sa.String(length=255), nullable=True),

        sa.Column('id', sa.String(length=36), nullable=False),

        sa.Column('security_group_id', sa.String(length=36), nullable=False),

        sa.Column('remote_group_id', sa.String(length=36), nullable=True),

        sa.Column('direction',

                  sa.Enum('ingress', 'egress',

                          name='securitygrouprules_direction'),

                  nullable=True),

        sa.Column('ethertype', sa.String(length=40), nullable=True),

        sa.Column('protocol', sa.String(length=40), nullable=True),

        sa.Column('port_range_min', sa.Integer(), nullable=True),

        sa.Column('port_range_max', sa.Integer(), nullable=True),

        sa.Column('remote_ip_prefix', sa.String(length=255), nullable=True),

        sa.ForeignKeyConstraint(['security_group_id'], ['securitygroups.id'],

                                ondelete='CASCADE'),

        sa.ForeignKeyConstraint(['remote_group_id'], ['securitygroups.id'],

                                ondelete='CASCADE'),

        sa.PrimaryKeyConstraint('id')

    )

    op.create_table(

        'securitygroupportbindings',

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

        sa.Column('security_group_id', sa.String(length=36), nullable=False),

        sa.ForeignKeyConstraint(['port_id'], ['ports.id'], ondelete='CASCADE'),

        sa.ForeignKeyConstraint(['security_group_id'], ['securitygroups.id']),

        sa.PrimaryKeyConstraint('port_id', 'security_group_id')

    )

    ### end Alembic commands ###

**** 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('securitygroupportbindings')

    op.drop_table('securitygrouprules')

    op.drop_table('securitygroups')

    ### end Alembic commands ###