Yaniv Dary has uploaded a new change for review. Change subject: history: added storage calculated status to dwh views (#846272) ......................................................................
history: added storage calculated status to dwh views (#846272) Now using database function to calculate shared status. Removed status from datacenter to storage domain map. Bug-Url: https://bugzilla.redhat.com/846272 Change-Id: Idc620c81b360b4f74e9701026fcca1c92d5b2b3f Signed-off-by: Yaniv Dary <[email protected]> --- M backend/manager/dbscripts/create_dwh_views.sql 1 file changed, 11 insertions(+), 8 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/64/10564/1 diff --git a/backend/manager/dbscripts/create_dwh_views.sql b/backend/manager/dbscripts/create_dwh_views.sql index d63e73c..5ca2659 100644 --- a/backend/manager/dbscripts/create_dwh_views.sql +++ b/backend/manager/dbscripts/create_dwh_views.sql @@ -53,18 +53,21 @@ CREATE OR REPLACE VIEW dwh_datacenter_storage_map_history_view AS -SELECT storage_pool_id AS datacenter_id, - storage_id AS storage_domain_id, - status as storage_domain_status +SELECT DISTINCT storage_pool_id AS datacenter_id, + storage_id AS storage_domain_id FROM storage_pool_iso_map; CREATE OR REPLACE VIEW dwh_storage_domain_history_view AS -SELECT - id as storage_domain_id, - available_disk_size as available_disk_size_gb, - used_disk_size as used_disk_size_gb -FROM storage_domain_dynamic; +SELECT storage_domain_dynamic.id as storage_domain_id, + fn_get_storage_domain_shared_status_by_domain_id(storage_domain_static.id, status_table.status, storage_domain_static.storage_type) AS storage_domain_status, + storage_domain_dynamic.available_disk_size as available_disk_size_gb, + storage_domain_dynamic.used_disk_size as used_disk_size_gb +FROM storage_domain_dynamic + INNER JOIN storage_domain_static ON (storage_domain_dynamic.id = storage_domain_static.id) + LEFT OUTER JOIN (SELECT storage_id, max(status) AS status + FROM storage_pool_iso_map + GROUP BY storage_id) AS status_table ON storage_domain_static.id=status_table.storage_id; CREATE OR REPLACE VIEW dwh_cluster_configuration_history_view AS -- To view, visit http://gerrit.ovirt.org/10564 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Idc620c81b360b4f74e9701026fcca1c92d5b2b3f Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
