Exemplos de alter_column_if_exists em Python

Exemplo n.º 1

Arquivo: 5446f2a45467_set_server_default.py Projeto: match/neutron

def set_default_brocade(default):
    if default:
        default = ''
    migration.alter_column_if_exists(
        'brocadeports', 'port_id',
        server_default=default,
        existing_type=sa.String(36))

Exemplo n.º 2

def set_default_agents():
    default = sqlalchemy.sql.true()
    migration.alter_column_if_exists('agents',
                                     'admin_state_up',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)

Exemplo n.º 3

def set_default_brocade(default):
    if default:
        default = ''
    migration.alter_column_if_exists(
        'brocadeports', 'port_id',
        server_default=default,
        existing_type=sa.String(36))

Exemplo n.º 4

Arquivo: 5446f2a45467_set_server_default.py Projeto: Akanksha08/neutron

def set_default_agents():
    default = sqlalchemy.sql.true()
    migration.alter_column_if_exists(
        'agents', 'admin_state_up',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 5

def upgrade():
    queues = sa.sql.table('eayun_qosqueues', sa.sql.column('prio'))
    op.execute(queues.update().where(queues.c.prio == None).values(prio=0))
    migration.alter_column_if_exists('eayun_qosqueues',
                                     'prio',
                                     type_=sa.types.Integer,
                                     nullable=False)

Exemplo n.º 6

Arquivo: 5446f2a45467_set_server_default.py Projeto: match/neutron

def set_default_mlnx(default):
    if default:
        default = sqlalchemy.sql.false()
    migration.alter_column_if_exists(
        'segmentation_id_allocation', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 7

def set_default_mlnx(default):
    if default:
        default = sqlalchemy.sql.false()
    migration.alter_column_if_exists(
        'segmentation_id_allocation', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 8

Arquivo: 50b192f357d5_qos_queue_ceil_not_null.py Projeto: eayunstack/neutron-qos

def upgrade():
    queues = sa.sql.table(
        'eayun_qosqueues', sa.sql.column('rate'), sa.sql.column('ceil'))
    op.execute(
        queues.update().where(queues.c.ceil==None).values(ceil=queues.c.rate))
    migration.alter_column_if_exists(
        'eayun_qosqueues', 'ceil',
        type_=sa.types.BigInteger,
        nullable=False)

Exemplo n.º 9

Arquivo: 50b192f357d5_qos_queue_ceil_not_null.py Projeto: huntxu/neutron-qos

def upgrade():
    queues = sa.sql.table('eayun_qosqueues', sa.sql.column('rate'),
                          sa.sql.column('ceil'))
    op.execute(queues.update().where(queues.c.ceil == None).values(
        ceil=queues.c.rate))
    migration.alter_column_if_exists('eayun_qosqueues',
                                     'ceil',
                                     type_=sa.types.BigInteger,
                                     nullable=False)

Exemplo n.º 10

def set_default_ml2():
    migration.alter_column_if_exists('ml2_gre_allocations',
                                     'allocated',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)
    migration.alter_column_if_exists('ml2_vxlan_allocations',
                                     'allocated',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)

Exemplo n.º 11

Arquivo: 5446f2a45467_set_server_default.py Projeto: Akanksha08/neutron

def set_default_ml2():
    migration.alter_column_if_exists(
        'ml2_gre_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)
    migration.alter_column_if_exists(
        'ml2_vxlan_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 12

Arquivo: 5446f2a45467_set_server_default.py Projeto: match/neutron

def set_default_ml2(default=None):
    if default:
        default = sqlalchemy.sql.false()
    migration.alter_column_if_exists(
        'ml2_gre_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)
    migration.alter_column_if_exists(
        'ml2_vxlan_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 13

def set_default_ml2(default=None):
    if default:
        default = sqlalchemy.sql.false()
    migration.alter_column_if_exists(
        'ml2_gre_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)
    migration.alter_column_if_exists(
        'ml2_vxlan_allocations', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 14

def upgrade():
    tc_filters = sa.sql.table('eayun_qosfilters', sa.sql.column('src_addr'),
                              sa.sql.column('dst_addr'))
    op.execute(tc_filters.update().where(tc_filters.c.src_addr == None).values(
        src_addr='0.0.0.0/0'))
    migration.alter_column_if_exists('eayun_qosfilters',
                                     'src_addr',
                                     type_=sa.types.String(255),
                                     nullable=False)
    op.execute(tc_filters.update().where(tc_filters.c.dst_addr == None).values(
        dst_addr='0.0.0.0/0'))
    migration.alter_column_if_exists('eayun_qosfilters',
                                     'dst_addr',
                                     type_=sa.types.String(255),
                                     nullable=False)

Exemplo n.º 15

Arquivo: 2a853fe8a8b1_qos_filter_addr_not_null.py Projeto: eayunstack/neutron-qos

def upgrade():
    tc_filters = sa.sql.table(
        'eayun_qosfilters',
        sa.sql.column('src_addr'), sa.sql.column('dst_addr'))
    op.execute(
        tc_filters.update().where(tc_filters.c.src_addr==None).values(
            src_addr='0.0.0.0/0'))
    migration.alter_column_if_exists(
        'eayun_qosfilters', 'src_addr',
        type_=sa.types.String(255),
        nullable=False)
    op.execute(
        tc_filters.update().where(tc_filters.c.dst_addr==None).values(
            dst_addr='0.0.0.0/0'))
    migration.alter_column_if_exists(
        'eayun_qosfilters', 'dst_addr',
        type_=sa.types.String(255),
        nullable=False)

Exemplo n.º 16

def downgrade():
    migration.alter_column_if_exists('poolstatisticss',
                                     'bytes_in',
                                     nullable=True,
                                     existing_type=sa.BigInteger())
    migration.alter_column_if_exists('poolstatisticss',
                                     'bytes_out',
                                     nullable=True,
                                     existing_type=sa.BigInteger())
    migration.alter_column_if_exists('poolstatisticss',
                                     'active_connections',
                                     nullable=True,
                                     existing_type=sa.BigInteger())
    migration.alter_column_if_exists('poolstatisticss',
                                     'total_connections',
                                     nullable=True,
                                     existing_type=sa.BigInteger())

Exemplo n.º 17

Arquivo: 1e5dd1d09b22_set_not_null_fields_lb_stats.py Projeto: match/neutron

def downgrade(active_plugins=None, options=None):
    migration.alter_column_if_exists(
        'poolstatisticss', 'bytes_in',
        nullable=True,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'bytes_out',
        nullable=True,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'active_connections',
        nullable=True,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'total_connections',
        nullable=True,
        existing_type=sa.BigInteger())

Exemplo n.º 18

Arquivo: 1e5dd1d09b22_set_not_null_fields_lb_stats.py Projeto: Akanksha08/neutron

def upgrade():
    migration.alter_column_if_exists(
        'poolstatisticss', 'bytes_in',
        nullable=False,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'bytes_out',
        nullable=False,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'active_connections',
        nullable=False,
        existing_type=sa.BigInteger())
    migration.alter_column_if_exists(
        'poolstatisticss', 'total_connections',
        nullable=False,
        existing_type=sa.BigInteger())

Exemplo n.º 19

Arquivo: 5446f2a45467_set_server_default.py Projeto: Akanksha08/neutron

def set_default_vmware():
    migration.alter_column_if_exists(
        'nsxrouterextattributess', 'service_router',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)
    migration.alter_column_if_exists(
        'nsxrouterextattributess', 'distributed',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)
    migration.alter_column_if_exists(
        'qosqueues', 'default',
        server_default=default,
        existing_type=sa.Boolean)

Exemplo n.º 20

def set_default_vmware():
    migration.alter_column_if_exists('nsxrouterextattributess',
                                     'service_router',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)
    migration.alter_column_if_exists('nsxrouterextattributess',
                                     'distributed',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)
    migration.alter_column_if_exists('qosqueues',
                                     'default',
                                     server_default=default,
                                     existing_type=sa.Boolean)

Exemplo n.º 21

def set_default_cisco():
    profile_binding_default = cisco_constants.TENANT_ID_NOT_SET
    profile_default = '0'
    migration.alter_column_if_exists('cisco_n1kv_profile_bindings',
                                     'tenant_id',
                                     existing_type=sa.String(length=36),
                                     server_default=profile_binding_default,
                                     existing_nullable=False)
    migration.alter_column_if_exists('cisco_network_profiles',
                                     'multicast_ip_index',
                                     server_default=profile_default,
                                     existing_type=sa.Integer)
    migration.alter_column_if_exists('cisco_n1kv_vlan_allocations',
                                     'allocated',
                                     existing_type=sa.Boolean,
                                     server_default=default,
                                     existing_nullable=False)

Exemplo n.º 22

Arquivo: 5446f2a45467_set_server_default.py Projeto: Akanksha08/neutron

def set_default_cisco():
    profile_binding_default = cisco_constants.TENANT_ID_NOT_SET
    profile_default = '0'
    migration.alter_column_if_exists(
        'cisco_n1kv_profile_bindings', 'tenant_id',
        existing_type=sa.String(length=36),
        server_default=profile_binding_default,
        existing_nullable=False)
    migration.alter_column_if_exists(
        'cisco_network_profiles', 'multicast_ip_index',
        server_default=profile_default,
        existing_type=sa.Integer)
    migration.alter_column_if_exists(
        'cisco_n1kv_vlan_allocations', 'allocated',
        existing_type=sa.Boolean,
        server_default=default,
        existing_nullable=False)

Exemplo n.º 23

Arquivo: 6be312499f9_set_not_null_vlan_id_cisco.py Projeto: CiscoSystems/neutron

def downgrade():
    migration.alter_column_if_exists(
        'cisco_nexusport_bindings', 'vlan_id',
        nullable=True,
        existing_type=sa.Integer)

Exemplo n.º 24

Arquivo: 54f7549a0e5f_set_not_null_peer_address.py Projeto: match/neutron

def downgrade(active_plugins=None, options=None):
    migration.alter_column_if_exists(
        'ipsec_site_connections', 'peer_address',
        nullable=True,
        existing_type=sa.String(255))

Exemplo n.º 25

def set_default_mlnx():
    migration.alter_column_if_exists('segmentation_id_allocation',
                                     'allocated',
                                     server_default=default,
                                     existing_nullable=False,
                                     existing_type=sa.Boolean)

Exemplo n.º 26

Arquivo: 54f7549a0e5f_set_not_null_peer_address.py Projeto: jxf211/nspdhcpagent

def upgrade():
    migration.alter_column_if_exists('ipsec_site_connections',
                                     'peer_address',
                                     existing_type=sa.String(255),
                                     nullable=False)

Exemplo n.º 27

def downgrade():
    migration.alter_column_if_exists('ipsec_site_connections',
                                     'peer_address',
                                     nullable=True,
                                     existing_type=sa.String(255))

Exemplo n.º 28

Arquivo: 6be312499f9_set_not_null_vlan_id_cisco.py Projeto: paulphoenix01/neutron2

def downgrade():
    migration.alter_column_if_exists('cisco_nexusport_bindings',
                                     'vlan_id',
                                     nullable=True,
                                     existing_type=sa.Integer)

Exemplo n.º 29

Arquivo: 2aa179c7fd81_update_vpnservice_des_length.py Projeto: nash-x/hws

def upgrade():
    migration.alter_column_if_exists("vpnservices", "description", type_=sa.String(LEN), nullable=True)

Exemplo n.º 30

Arquivo: 6be312499f9_set_not_null_vlan_id_cisco.py Projeto: match/neutron

def downgrade(active_plugins=None, options=None):
    migration.alter_column_if_exists(
        'cisco_nexusport_bindings', 'vlan_id',
        nullable=True,
        existing_type=sa.Integer)

Exemplo n.º 31

Arquivo: b65aa907aec_set_length_of_protocol_field.py Projeto: Akanksha08/neutron

def upgrade():
    migration.alter_column_if_exists(
        'firewall_rules', 'protocol',
        type_=sa.String(40),
        existing_nullable=True)

Exemplo n.º 32

Arquivo: 2aa179c7fd81_update_vpnservice_des_length.py Projeto: nkapotoxin/fs_spc111t_plus_hc

def downgrade():
     migration.alter_column_if_exists(
        'vpnservices', 'description',
        type_=sa.String(255),
        nullable=True)

Exemplo n.º 33

Arquivo: 2aa179c7fd81_update_vpnservice_des_length.py Projeto: HybridCloud-dew/hws

def downgrade():
    migration.alter_column_if_exists('vpnservices',
                                     'description',
                                     type_=sa.String(255),
                                     nullable=True)

Exemplo n.º 34

Arquivo: 54f7549a0e5f_set_not_null_peer_address.py Projeto: CiscoSystems/neutron

def upgrade():
    migration.alter_column_if_exists(
        'ipsec_site_connections', 'peer_address',
        existing_type=sa.String(255),
        nullable=False)

Exemplo n.º 35

Arquivo: 5446f2a45467_set_server_default.py Projeto: Akanksha08/neutron

def set_default_mlnx():
    migration.alter_column_if_exists(
        'segmentation_id_allocation', 'allocated',
        server_default=default,
        existing_nullable=False,
        existing_type=sa.Boolean)

Exemplo n.º 36

def downgrade():
    migration.alter_column_if_exists('ml2_brocadeports',
                                     'admin_state_up',
                                     nullable=True,
                                     existing_type=sa.Boolean)

Exemplo n.º 37

Arquivo: b65aa907aec_set_length_of_protocol_field.py Projeto: jxf211/nspdhcpagent

def upgrade():
    migration.alter_column_if_exists('firewall_rules',
                                     'protocol',
                                     type_=sa.String(40),
                                     existing_nullable=True)

Exemplo n.º 38

Arquivo: d06e871c0d5_set_admin_state_up_not_null_ml2.py Projeto: CiscoSystems/neutron

def downgrade():
    migration.alter_column_if_exists(
        'ml2_brocadeports', 'admin_state_up',
        nullable=True,
        existing_type=sa.Boolean)

Exemplo n.º 39

Arquivo: b65aa907aec_set_length_of_protocol_field.py Projeto: match/neutron

def upgrade(active_plugins=None, options=None):
    migration.alter_column_if_exists(
        'firewall_rules', 'protocol',
        type_=sa.String(40),
        existing_nullable=True)

Exemplo n.º 40

Arquivo: d06e871c0d5_set_admin_state_up_not_null_ml2.py Projeto: balagopalraj/clearlinux

def upgrade():
    migration.alter_column_if_exists("ml2_brocadeports", "admin_state_up", nullable=False, existing_type=sa.Boolean)