diff options
Diffstat (limited to 'src/caas/migrations/0023_auto_20201019_1631.py')
| -rw-r--r-- | src/caas/migrations/0023_auto_20201019_1631.py | 20 |
1 files changed, 20 insertions, 0 deletions
diff --git a/src/caas/migrations/0023_auto_20201019_1631.py b/src/caas/migrations/0023_auto_20201019_1631.py new file mode 100644 index 0000000..557884b --- /dev/null +++ b/src/caas/migrations/0023_auto_20201019_1631.py @@ -0,0 +1,20 @@ +# Generated by Django 3.1.2 on 2020-10-19 22:31 + +from django.db import migrations +import django_db_views.migration_functions +import django_db_views.operations + + +class Migration(migrations.Migration): + + dependencies = [ + ('caas', '0022_auto_20201001_1232'), + ] + + operations = [ + 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,\n ws.date_completed\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\nleft outer join caas_wrinstallschedule ws\n on c.id = ws.cluster_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.is_central_controller=0', 'caas_icingabmc'), + atomic=False, + ), + ] |