Yaniv Dary has uploaded a new change for review. Change subject: history: removed unused reports views ......................................................................
history: removed unused reports views Change-Id: I31679e73b1a0105870b001cea88776f58c52db36 Signed-off-by: Yaniv Dary <[email protected]> --- D packaging/dbscripts/create_reports_views.sql M packaging/dbscripts/dbcustomfunctions.sh 2 files changed, 0 insertions(+), 34 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-dwh refs/changes/63/24063/1 diff --git a/packaging/dbscripts/create_reports_views.sql b/packaging/dbscripts/create_reports_views.sql deleted file mode 100644 index 36331f9..0000000 --- a/packaging/dbscripts/create_reports_views.sql +++ /dev/null @@ -1,32 +0,0 @@ -/************************************** - INTERNAL VIEWS FOR REPORTS -**************************************/ - -/*Views to create input controls for reports, since union is not possible in HQL currently*/ - -CREATE OR REPLACE VIEW rhev_reports_input_control_cluster - AS -SELECT - history_id as history_id, - cluster_id as cluster_id, - CASE - WHEN delete_date IS NULL THEN cluster_name - ELSE cluster_name || ' (Removed on ' || cast(delete_date as varchar) || ')' - END as cluster_name_ic, - datacenter_id as datacenter_id, - delete_date as delete_date, - 0 as sort -FROM cluster_configuration -WHERE history_id in (SELECT max(a.history_id) FROM cluster_configuration as a GROUP BY a.cluster_id) -UNION ALL -SELECT -1, '11111111-1111-1111-1111-111111111111','All', '11111111-1111-1111-1111-111111111111', null, 1; - -CREATE OR REPLACE VIEW rhev_reports_input_control_enum - AS -SELECT value, - enum_key, - enum_type, - 0 as sort -FROM v3_1_enum_translator_view -UNION ALL -SELECT 'All', -1, null, 1; diff --git a/packaging/dbscripts/dbcustomfunctions.sh b/packaging/dbscripts/dbcustomfunctions.sh index 0e2ce96..657d912 100755 --- a/packaging/dbscripts/dbcustomfunctions.sh +++ b/packaging/dbscripts/dbcustomfunctions.sh @@ -48,8 +48,6 @@ execute_file "create_views_3_3.sql" ${DATABASE} ${SERVERNAME} ${PORT} > /dev/null printf "Creating views API 3.4...\n" execute_file "create_views_3_4.sql" ${DATABASE} ${SERVERNAME} ${PORT} > /dev/null - printf "Creating ovirt engine reports views...\n" - execute_file "create_reports_views.sql" ${DATABASE} ${SERVERNAME} ${PORT} > /dev/null } fn_db_set_dbobjects_ownership() { -- To view, visit http://gerrit.ovirt.org/24063 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I31679e73b1a0105870b001cea88776f58c52db36 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-dwh Gerrit-Branch: master Gerrit-Owner: Yaniv Dary <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
