1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
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,
),
]
|
