[cloudstack] branch main updated: Set network state to implemented when no services (#6838)

[dahn]

This is an automated email from the ASF dual-hosted git repository.

dahn pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/cloudstack.git


The following commit(s) were added to refs/heads/main by this push:
     new 13d22c2f54 Set network state to implemented when no services (#6838)
13d22c2f54 is described below

commit 13d22c2f542b3570b190bf2eb2acfffae99ef528
Author: dahn <d...@onecht.net>
AuthorDate: Mon Oct 24 08:59:17 2022 +0200

    Set network state to implemented when no services (#6838)
    
    Co-authored-by: Nicolas Vazquez <nicovazque...@gmail.com>
    Co-authored-by: Wei Zhou <weiz...@apache.org>
---
 .../src/main/resources/META-INF/db/schema-41710to41800.sql    | 11 +++++++++++
 1 file changed, 11 insertions(+)

diff --git 
a/engine/schema/src/main/resources/META-INF/db/schema-41710to41800.sql 
b/engine/schema/src/main/resources/META-INF/db/schema-41710to41800.sql
index 89e1cb41a5..8be5cb31b3 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41710to41800.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41710to41800.sql
@@ -586,3 +586,14 @@ UPDATE  cloud.configuration
 SET     description = "Use SSL method used to encrypt copy traffic between 
zones. Also ensures that the certificate assigned to the zone is used when
 generating links for external access."
 WHERE   name = 'secstorage.encrypt.copy';
+
+-- allow isolated networks without services to be used as is.
+UPDATE `cloud`.`networks` ntwk
+  SET ntwk.state = 'Implemented'
+  WHERE ntwk.network_offering_id in
+    (SELECT id FROM `cloud`.`network_offerings` ntwkoff
+      WHERE (SELECT count(*) FROM `cloud`.`ntwk_offering_service_map` 
ntwksrvcmp WHERE ntwksrvcmp.network_offering_id = ntwkoff.id) = 0
+        AND ntwkoff.is_persistent = 1) AND
+    ntwk.state = 'Setup' AND
+    ntwk.removed is NULL AND
+    ntwk.guest_type = 'Isolated';