more filesHEADmaster

1 files changed, 30 insertions, 0 deletions

diff --git a/src/caas/migrations/0018_auto_20200925_1855.py b/src/caas/migrations/0018_auto_20200925_1855.py
new file mode 100644
index 0000000..e8bc107
--- /dev/null
+++ b/src/caas/migrations/0018_auto_20200925_1855.py
@@ -0,0 +1,30 @@
+# Generated by Django 3.0.8 on 2020-09-25 18:55
+
+from django.db import migrations
+import django_db_views.migration_functions
+import django_db_views.operations
+
+
+class Migration(migrations.Migration):
+
+    dependencies = [
+        ('caas', '0017_cluster_is_central_controller'),
+    ]
+
+    operations = [
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select l.id as id,\n  csr.csr_hostname as csr_hostname,\n  csr.oam_default_gateway as oam_default_gateway\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.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.is_central_controller=0\ngroup by l.id,\n  csr.csr_hostname,\n  csr.oam_default_gateway', 'caas_icingarouter'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select location_id as id,\n  csr_hostname,\n  oam_default_gateway\nfrom caas_icingabmc\ngroup by location_id,\n  csr_hostname,\n  oam_default_gateway', 'caas_icingarouter'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.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.is_central_controller=0', 'caas_icingabmc'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  l.id as location_id,\n  csr.oam_default_gateway,\n  l.latitude,\n  l.longitude,\n  csr.csr_hostname,\n  b.serial_number,\n  v.vendor_name,\n  cr.bmc_password_admin_default,\n  cr.bmc_password_admin,\n  cr.bmc_username,\n  cr.bmc_password\nfrom caas_server s\ninner join caas_cluster c\n  on s.cluster_id = c.id\ninner join caas_location l\n  on c.location_id = l.id\ninner join caas_cellsiterouter csr\n  on c.csr_id = csr.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_icingabmc'),
+            atomic=False,
+        ),
+        django_db_views.operations.ViewRunPython(
+            code=django_db_views.migration_functions.ForwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.intel_nic_firmware_version,\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_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.is_central_controller=0', 'caas_firmwarebatch'),
+            reverse_code=django_db_views.migration_functions.BackwardViewMigration('select s.id,\n  s.ilo_hostname,\n  s.ilo_host_address,\n  s.intel_nic_firmware_version,\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_blade b\n  on s.blade_id = b.id\nleft outer join caas_credential cr\n  on b.credential_id = cr.id\nwhere c.parent_cluster_id is not null', 'caas_firmwarebatch'),
+            atomic=False,
+        ),
+    ]