This is an automated email from the ASF dual-hosted git repository.
pearl11594 pushed a commit to branch fix-zone-view
in repository https://gitbox.apache.org/repos/asf/cloudstack.git
The following commit(s) were added to refs/heads/fix-zone-view by this push:
new 36531ebcd5f API: Fix listing zones and storage pools
36531ebcd5f is described below
commit 36531ebcd5fa546ef2dd4a30dba5aa135015a807
Author: Pearl Dsilva <[email protected]>
AuthorDate: Tue Dec 5 16:26:59 2023 -0500
API: Fix listing zones and storage pools
---
.../resources/META-INF/db/schema-41810to41900.sql | 54 +++++++++++++++++++++-
1 file changed, 52 insertions(+), 2 deletions(-)
diff --git
a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
index f93cc78c3f6..d8ab171ee80 100644
--- a/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
+++ b/engine/schema/src/main/resources/META-INF/db/schema-41810to41900.sql
@@ -350,9 +350,9 @@ SELECT
host_pod_ref.uuid pod_uuid,
host_pod_ref.name pod_name,
GROUP_CONCAT(DISTINCT(host_tags.tag)) AS tag,
- host_tags.is_tag_a_rule is_tag_a_rule
+ host_tags.is_tag_a_rule is_tag_a_rule,
guest_os_category.id guest_os_category_id,
- guest_os_category.uuid guest_os_category_uuid,
+ guest_os_category.uuid guest_os_category_uuid,
guest_os_category.name guest_os_category_name,
mem_caps.used_capacity memory_used_capacity,
mem_caps.reserved_capacity memory_reserved_capacity,
@@ -406,3 +406,53 @@ FROM
`cloud`.`user` ON `user`.`uuid` = `last_annotation_view`.`user_uuid`
GROUP BY
`host`.`id`;
+
+
+DROP VIEW IF EXISTS `cloud`.`storage_pool_view`;
+CREATE VIEW `cloud`.`storage_pool_view` AS
+SELECT
+ `storage_pool`.`id` AS `id`,
+ `storage_pool`.`uuid` AS `uuid`,
+ `storage_pool`.`name` AS `name`,
+ `storage_pool`.`status` AS `status`,
+ `storage_pool`.`path` AS `path`,
+ `storage_pool`.`pool_type` AS `pool_type`,
+ `storage_pool`.`host_address` AS `host_address`,
+ `storage_pool`.`created` AS `created`,
+ `storage_pool`.`removed` AS `removed`,
+ `storage_pool`.`capacity_bytes` AS `capacity_bytes`,
+ `storage_pool`.`capacity_iops` AS `capacity_iops`,
+ `storage_pool`.`scope` AS `scope`,
+ `storage_pool`.`hypervisor` AS `hypervisor`,
+ `storage_pool`.`storage_provider_name` AS `storage_provider_name`,
+ `storage_pool`.`parent` AS `parent`,
+ `cluster`.`id` AS `cluster_id`,
+ `cluster`.`uuid` AS `cluster_uuid`,
+ `cluster`.`name` AS `cluster_name`,
+ `cluster`.`cluster_type` AS `cluster_type`,
+ `data_center`.`id` AS `data_center_id`,
+ `data_center`.`uuid` AS `data_center_uuid`,
+ `data_center`.`name` AS `data_center_name`,
+ `data_center`.`networktype` AS `data_center_type`,
+ `host_pod_ref`.`id` AS `pod_id`,
+ `host_pod_ref`.`uuid` AS `pod_uuid`,
+ `host_pod_ref`.`name` AS `pod_name`,
+ `storage_pool_tags`.`tag` AS `tag`,
+ storage_pool_tags.is_tag_a_rule is_tag_a_rule,
+ `op_host_capacity`.`used_capacity` AS `disk_used_capacity`,
+ `op_host_capacity`.`reserved_capacity` AS `disk_reserved_capacity`,
+ `async_job`.`id` AS `job_id`,
+ `async_job`.`uuid` AS `job_uuid`,
+ `async_job`.`job_status` AS `job_status`,
+ `async_job`.`account_id` AS `job_account_id`
+FROM
+ ((((((`storage_pool`
+ LEFT JOIN `cluster` ON ((`storage_pool`.`cluster_id` =
`cluster`.`id`)))
+ LEFT JOIN `data_center` ON ((`storage_pool`.`data_center_id` =
`data_center`.`id`)))
+ LEFT JOIN `host_pod_ref` ON ((`storage_pool`.`pod_id` =
`host_pod_ref`.`id`)))
+ LEFT JOIN `storage_pool_tags` ON (((`storage_pool_tags`.`pool_id` =
`storage_pool`.`id`))))
+ LEFT JOIN `op_host_capacity` ON (((`storage_pool`.`id` =
`op_host_capacity`.`host_id`)
+ AND (`op_host_capacity`.`capacity_type` IN (3 , 9)))))
+ LEFT JOIN `async_job` ON (((`async_job`.`instance_id` =
`storage_pool`.`id`)
+ AND (`async_job`.`instance_type` = 'StoragePool')
+ AND (`async_job`.`job_status` = 0))));
