# Generated by Django 3.0.8 on 2020-07-11 17:27

from django.db import migrations
import django_db_views.migration_functions
import django_db_views.operations


class Migration(migrations.Migration):

    dependencies = [
        ('caas', '0007_auto_20200711_1126'),
    ]

    operations = [
        django_db_views.operations.ViewRunPython(
            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  s.intel_nic_firmware_version,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  c.id as cluster_id,\n  cp.oam_vip_hostname as parent_oam_vip_hostname,\n  cp.oam_vip_address as parent_oam_vip_address,\n  s.pxe_mac_address,\n  s.ilo_host_address,\n  s.oam_hostname,\n  s.oam_host_address,\n  c.oam_vip_address,\n  csr.oam_default_gateway,\n  c.mgmt_address_range_start,\n  c.mgmt_address_range_end,\n  csr.mgmt_default_gateway,\n  csr.mgmt_subnet,\n  vl.host_vlan,\n  vl.oam_vlan,\n  vl.mgmt_vlan,\n  c.cluster_name,\n  v.vendor_name,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\nleft outer join caas_cluster cp\n  on c.parent_cluster_id = cp.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_vlan vl\n  on c.vlan_id = vl.id\nleft outer join caas_blade b\n  on s.blade_id = b.id\nleft outer join caas_vendor v\n  on b.vendor_id = v.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_wrbatch'),
            atomic=False,
        ),
    ]