Python alter_enum Examples

Example #1

def upgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return

    op.create_table(
        'cisco_n1kv_trunk_segments',
        sa.Column('trunk_segment_id', sa.String(length=36), nullable=False),
        sa.Column('segment_id', sa.String(length=36), nullable=False),
        sa.Column('dot1qtag', sa.String(length=36), nullable=False),
        sa.ForeignKeyConstraint(['trunk_segment_id'], ['networks.id'],
                                ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('trunk_segment_id', 'segment_id', 'dot1qtag')
    )
    op.create_table(
        'cisco_n1kv_multi_segments',
        sa.Column('multi_segment_id', sa.String(length=36), nullable=False),
        sa.Column('segment1_id', sa.String(length=36), nullable=False),
        sa.Column('segment2_id', sa.String(length=36), nullable=False),
        sa.Column('encap_profile_name', sa.String(length=36), nullable=True),
        sa.ForeignKeyConstraint(['multi_segment_id'], ['networks.id'],
                                ondelete='CASCADE'),
        sa.PrimaryKeyConstraint('multi_segment_id', 'segment1_id',
                                'segment2_id')
    )
    migration.alter_enum('cisco_network_profiles', 'segment_type', new_type,
                         nullable=False)
    op.add_column('cisco_network_profiles',
                  sa.Column('sub_type', sa.String(length=255), nullable=True))

Example #2

File: lbaasv2_tls.py Project: Vikash082/neutron-lbaas

def downgrade():
    migration.alter_enum('lbaas_listeners',
                         'protocol',
                         old_listener_protocols,
                         nullable=False)
    op.drop_table('lbaas_sni')
    op.drop_column('lbaas_listeners', 'default_tls_container_id')

Example #3

def downgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return

    op.drop_table('cisco_n1kv_trunk_segments')
    op.drop_table('cisco_n1kv_multi_segments')
    migration.alter_enum('cisco_network_profiles', 'segment_type', old_type,
                         nullable=False)
    op.drop_column('cisco_network_profiles', 'sub_type')

Example #4

File: 1341ed32cc1e_nvp_netbinding_update.py Project: AsherBond/quantum

def downgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return
    op.alter_column('nvp_network_bindings', 'phy_uuid',
                    name='tz_uuid',
                    existing_type=sa.String(36),
                    existing_nullable=True)
    migration.alter_enum('nvp_network_bindings', 'binding_type', old_type,
                         nullable=False)

Example #5

def downgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return
    op.alter_column('nvp_network_bindings', 'phy_uuid',
                    name='tz_uuid',
                    existing_type=sa.String(36),
                    existing_nullable=True)
    migration.alter_enum('nvp_network_bindings', 'binding_type', old_type,
                         nullable=False)

Example #6

File: 4b47ea298795_add_reject_rule.py Project: openstack/neutron-fwaas

def upgrade():
    # NOTE: postgresql have a builtin ENUM type, so just altering the
    # column won't works
    # https://bitbucket.org/zzzeek/alembic/issues/270/altering-enum-type
    # alter_enum that was already invented for such case in neutron
    # https://github.com/openstack/neutron/blob/master/neutron/db/migration/__init__.py

    migration.alter_enum(
        'firewall_rules', 'action', enum_type=new_action, nullable=True)

Example #7

def upgrade():
    # NOTE: postgresql have a builtin ENUM type, so just altering the
    # column won't works
    # https://bitbucket.org/zzzeek/alembic/issues/270/altering-enum-type
    # alter_enum that was already invented for such case in neutron
    # https://github.com/openstack/neutron/blob/master/neutron/db/migration/__init__.py

    migration.alter_enum('firewall_rules',
                         'action',
                         enum_type=new_action,
                         nullable=True)

Example #8

def upgrade():
    migration.alter_enum('ikepolicies',
                         'auth_algorithm',
                         new_auth,
                         nullable=False,
                         do_drop=False)
    migration.alter_enum('ipsecpolicies',
                         'auth_algorithm',
                         new_auth,
                         nullable=False,
                         do_rename=False,
                         do_create=False)

Example #9

File: lbaasv2_tls.py Project: F5Networks/neutron-lbaas

def upgrade():
    migration.alter_enum('lbaas_listeners', 'protocol', new_listener_protocols,
                         nullable=False)
    op.create_table(
        u'lbaas_sni',
        sa.Column(u'listener_id', sa.String(36), nullable=False),
        sa.Column(u'tls_container_id', sa.String(128), nullable=False),
        sa.Column(u'position', sa.Integer),
        sa.ForeignKeyConstraint(['listener_id'], [u'lbaas_listeners.id'], ),
        sa.PrimaryKeyConstraint(u'listener_id', u'tls_container_id')
    )

    op.add_column('lbaas_listeners',
                  sa.Column(u'default_tls_container_id', sa.String(128),
                            nullable=True))

Example #10

File: lbaasv2_tls.py Project: tomas-ronec/neutron-lbaas

def upgrade():
    migration.alter_enum('lbaas_listeners',
                         'protocol',
                         new_listener_protocols,
                         nullable=False)
    op.create_table(
        u'lbaas_sni', sa.Column(u'listener_id', sa.String(36), nullable=False),
        sa.Column(u'tls_container_id', sa.String(128), nullable=False),
        sa.Column(u'position', sa.Integer),
        sa.ForeignKeyConstraint(
            ['listener_id'],
            [u'lbaas_listeners.id'],
        ), sa.PrimaryKeyConstraint(u'listener_id', u'tls_container_id'))

    op.add_column(
        'lbaas_listeners',
        sa.Column(u'default_tls_container_id', sa.String(128), nullable=True))

Example #11

File: fe637dc3f042_support_sha256.py Project: JinJingLin/neutron-vpnaas

def upgrade():
    migration.alter_enum('ikepolicies', 'auth_algorithm', new_auth,
                nullable=False, do_drop=False)
    migration.alter_enum('ipsecpolicies', 'auth_algorithm', new_auth,
                nullable=False, do_rename=False, do_create=False)

Example #12

File: lbaasv2_tls.py Project: Vikash082/neutron-lbaas

def downgrade():
    migration.alter_enum('lbaas_listeners', 'protocol', old_listener_protocols,
                         nullable=False)
    op.drop_table('lbaas_sni')
    op.drop_column('lbaas_listeners', 'default_tls_container_id')

Example #13

File: 38fc1f6789f8_cisco_n1kv_overlay.py Project: AsherBond/quantum

def downgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return

    migration.alter_enum('cisco_network_profiles', 'segment_type', old_type,
                         nullable=False)

Example #14

File: 38fc1f6789f8_cisco_n1kv_overlay.py Project: vijayendrabvs/neutron

def downgrade(active_plugins=None, options=None):
    if not migration.should_run(active_plugins, migration_for_plugins):
        return

    migration.alter_enum('cisco_network_profiles', 'segment_type', old_type,
                         nullable=False)