more filesHEADmaster

1 files changed, 72 insertions, 0 deletions

diff --git a/sql/caas/adhoc/mtce-nominal.sql b/sql/caas/adhoc/mtce-nominal.sql
new file mode 100644
index 0000000..d1d2137
--- /dev/null
+++ b/sql/caas/adhoc/mtce-nominal.sql
@@ -0,0 +1,72 @@
+do $$
+declare
+  csr_name_central character varying := 'WELKTXEF-ROUTER-000004';
+  cluster_name_central character varying := 'welktxef-c000004-001';
+  ilo_hostname_central character varying := 'welktxef-000004-rh-p30e910-001';
+  oam_vip_hostname_central character varying := 'welktxef-000004-nh-pe1e910-001';
+  ilo_gateway_address_central character varying := '2607:f160:10:9051:ce:23::';
+  ilo_subnet_central character varying := '2607:f160:10:9051::';
+  oam_subnet_central character varying := '2607:f160:10:9051::';
+  oam_gateway_address_central character varying := ilo_gateway_address_central;
+  oam_floating_address_central character varying := '2607:f160:10:9051:ce:290:0:1000';
+  mgmt_start_address_central character varying := '2607:f160:10:9050:ce:290::';
+  mgmt_end_address_central character varying := '2607:f160:10:9050:ce:290:0:f';
+  mgmt_subnet_central character varying := '2607:f160:10:9050::';
+  mgmt_gateway_address_central character varying := '2607:f160:10:9050:ce:23::';
+
+  oam_hostname_central character varying := 'welktxef-000004-nh-pe2e910-001';
+  ilo_host_address_central character varying := '2607:f160:10:9221:ce:fe0:0:800b';
+  oam_host_address_central character varying := '2607:f160:10:9051:ce:290:0:1001';
+begin
+  update caas_cellsiterouter
+  set ilo_subnet = ilo_subnet_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cellsiterouter
+  set ilo_default_gateway = ilo_gateway_address_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cellsiterouter
+  set oam_subnet = oam_subnet_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cellsiterouter
+  set oam_default_gateway = oam_gateway_address_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cellsiterouter
+  set mgmt_subnet = mgmt_subnet_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cellsiterouter
+  set mgmt_default_gateway = mgmt_gateway_address_central
+  where csr_hostname = csr_name_central;
+
+  update caas_cluster
+  set oam_vip_hostname = oam_vip_hostname_central
+  where cluster_name = cluster_name_central;
+
+  update caas_cluster
+  set oam_vip_address = oam_floating_address_central
+  where cluster_name = cluster_name_central;
+
+  update caas_cluster
+  set mgmt_address_range_start = mgmt_start_address_central
+  where cluster_name = cluster_name_central;
+
+  update caas_cluster
+  set mgmt_address_range_end = mgmt_end_address_central
+  where cluster_name = cluster_name_central;
+
+  update caas_server
+  set oam_hostname = oam_hostname_central
+  where ilo_hostname = ilo_hostname_central;
+
+  update caas_server
+  set oam_host_address = oam_host_address_central
+  where ilo_hostname = ilo_hostname_central;
+
+  update caas_server
+  set ilo_host_address = ilo_host_address_central
+  where ilo_hostname = ilo_hostname_central;
+end $$;