From 640ff61422bc0ee3966941b93d9889ddbbd38d77 Mon Sep 17 00:00:00 2001
From: ckonstanski <kostcarl@isu.edu>
Date: Thu, 30 Jul 2026 18:17:14 -0600
Subject: more files

---
 sql/caas/adhoc/migrate-mgmt-network-fields.sql | 40 ++++++++++++++++++++++++++
 1 file changed, 40 insertions(+)
 create mode 100644 sql/caas/adhoc/migrate-mgmt-network-fields.sql

(limited to 'sql/caas/adhoc/migrate-mgmt-network-fields.sql')

diff --git a/sql/caas/adhoc/migrate-mgmt-network-fields.sql b/sql/caas/adhoc/migrate-mgmt-network-fields.sql
new file mode 100644
index 0000000..f2559a9
--- /dev/null
+++ b/sql/caas/adhoc/migrate-mgmt-network-fields.sql
@@ -0,0 +1,40 @@
+do $$
+declare
+    rec caas_cluster%rowtype;
+    l_mgmt_subnet character varying;
+    l_mgmt_default_gateway character varying;
+begin
+    for rec in
+        select id,
+            cluster_name,
+            oam_vip_hostname,
+            oam_vip_address,
+            mgmt_address_range_start,
+            mgmt_address_range_end,
+            csr_id,
+            location_id,
+            namespace_id,
+            parent_cluster_id,
+            sap_clli_id,
+            vlan_id,
+            is_central_controller,
+            mgmt_default_gateway,
+            mgmt_subnet
+        from caas_cluster
+        where is_central_controller = 0
+    loop
+        select mgmt_subnet into l_mgmt_subnet
+        from caas_cellsiterouter
+        where id = rec.csr_id;
+
+        select mgmt_default_gateway into l_mgmt_default_gateway
+        from caas_cellsiterouter
+        where id = rec.csr_id;
+
+        update caas_cluster
+        set mgmt_subnet = l_mgmt_subnet,
+            mgmt_default_gateway = l_mgmt_default_gateway
+        where id = rec.id;
+    end loop;
+end;
+$$ language plpgsql;
-- 
cgit v1.3