def set_default_brocade(default): if default: default = '' migration.alter_column_if_exists( 'brocadeports', 'port_id', server_default=default, existing_type=sa.String(36))
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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)
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())
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())
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())
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)
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)
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)
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)
def downgrade(): migration.alter_column_if_exists( 'cisco_nexusport_bindings', 'vlan_id', nullable=True, existing_type=sa.Integer)
def downgrade(active_plugins=None, options=None): migration.alter_column_if_exists( 'ipsec_site_connections', 'peer_address', nullable=True, existing_type=sa.String(255))
def set_default_mlnx(): migration.alter_column_if_exists('segmentation_id_allocation', 'allocated', server_default=default, existing_nullable=False, existing_type=sa.Boolean)
def upgrade(): migration.alter_column_if_exists('ipsec_site_connections', 'peer_address', existing_type=sa.String(255), nullable=False)
def downgrade(): migration.alter_column_if_exists('ipsec_site_connections', 'peer_address', nullable=True, existing_type=sa.String(255))
def downgrade(): migration.alter_column_if_exists('cisco_nexusport_bindings', 'vlan_id', nullable=True, existing_type=sa.Integer)
def upgrade(): migration.alter_column_if_exists("vpnservices", "description", type_=sa.String(LEN), nullable=True)
def downgrade(active_plugins=None, options=None): migration.alter_column_if_exists( 'cisco_nexusport_bindings', 'vlan_id', nullable=True, existing_type=sa.Integer)
def upgrade(): migration.alter_column_if_exists( 'firewall_rules', 'protocol', type_=sa.String(40), existing_nullable=True)
def downgrade(): migration.alter_column_if_exists( 'vpnservices', 'description', type_=sa.String(255), nullable=True)
def downgrade(): migration.alter_column_if_exists('vpnservices', 'description', type_=sa.String(255), nullable=True)
def upgrade(): migration.alter_column_if_exists( 'ipsec_site_connections', 'peer_address', existing_type=sa.String(255), nullable=False)
def set_default_mlnx(): migration.alter_column_if_exists( 'segmentation_id_allocation', 'allocated', server_default=default, existing_nullable=False, existing_type=sa.Boolean)
def downgrade(): migration.alter_column_if_exists('ml2_brocadeports', 'admin_state_up', nullable=True, existing_type=sa.Boolean)
def upgrade(): migration.alter_column_if_exists('firewall_rules', 'protocol', type_=sa.String(40), existing_nullable=True)
def downgrade(): migration.alter_column_if_exists( 'ml2_brocadeports', 'admin_state_up', nullable=True, existing_type=sa.Boolean)
def upgrade(active_plugins=None, options=None): migration.alter_column_if_exists( 'firewall_rules', 'protocol', type_=sa.String(40), existing_nullable=True)
def upgrade(): migration.alter_column_if_exists("ml2_brocadeports", "admin_state_up", nullable=False, existing_type=sa.Boolean)