diff options
Diffstat (limited to 'src/caas/migrations/0028_auto_20201212_1001.py')
| -rw-r--r-- | src/caas/migrations/0028_auto_20201212_1001.py | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/caas/migrations/0028_auto_20201212_1001.py b/src/caas/migrations/0028_auto_20201212_1001.py new file mode 100644 index 0000000..cf6c1d0 --- /dev/null +++ b/src/caas/migrations/0028_auto_20201212_1001.py @@ -0,0 +1,20 @@ +# Generated by Django 3.1.4 on 2020-12-12 17:01 + +from django.db import migrations +import django_db_views.migration_functions +import django_db_views.operations + + +class Migration(migrations.Migration): + + dependencies = [ + ('caas', '0027_auto_20201211_2103'), + ] + + operations = [ + django_db_views.operations.ViewRunPython( + code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n c.id as cluster_id,\n l.fuze_spm_site_id,\n cp.oam_vip_hostname as parent_oam_vip_hostname,\n cp.oam_vip_address as parent_oam_vip_address,\n cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n csrp.mgmt_subnet as parent_mgmt_subnet,\n s.pxe_mac_address,\n s.ilo_hostname,\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 c.mgmt_default_gateway,\n c.mgmt_subnet,\n vl.host_vlan,\n vl.oam_vlan,\n vl.mgmt_vlan,\n c.cluster_name,\n cp.cluster_name as parent_cluster_name,\n v.vendor_name,\n s.intel_nic_firmware_version,\n l.maint_window_p,\n n.id as namespace_id,\n n.namespace_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_cellsiterouter csrp\n on cp.csr_id = csrp.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\ninner join caas_namespace n\n on c.namespace_id = n.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 l.fuze_spm_site_id,\n cp.oam_vip_hostname as parent_oam_vip_hostname,\n cp.oam_vip_address as parent_oam_vip_address,\n cp.mgmt_address_range_start as parent_mgmt_address_range_start,\n cp.mgmt_address_range_end as parent_mgmt_address_range_end,\n csrp.mgmt_default_gateway as parent_mgmt_default_gateway,\n csrp.mgmt_subnet as parent_mgmt_subnet,\n s.pxe_mac_address,\n s.ilo_hostname,\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 cp.cluster_name as parent_cluster_name,\n v.vendor_name,\n s.intel_nic_firmware_version,\n l.maint_window_p,\n n.id as namespace_id,\n n.namespace_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_cellsiterouter csrp\n on cp.csr_id = csrp.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\ninner join caas_namespace n\n on c.namespace_id = n.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, + ), + ] |