Yevgeny Zaspitsky has uploaded a new change for review. Change subject: engine: move GetAllVm_poolsByUser_id_with_groups_and_UserRoles ......................................................................
engine: move GetAllVm_poolsByUser_id_with_groups_and_UserRoles Move GetAllVm_poolsByUser_id_with_groups_and_UserRoles to its native location in vm_pools_sp.sql file. Change-Id: Ib8dcbca872a5ae9bd31b60f533cbddcc23a410bf Signed-off-by: Yevgeny Zaspitsky <[email protected]> --- M packaging/dbscripts/bookmarks_sp.sql M packaging/dbscripts/vm_pools_sp.sql 2 files changed, 9 insertions(+), 10 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/61/40061/1 diff --git a/packaging/dbscripts/bookmarks_sp.sql b/packaging/dbscripts/bookmarks_sp.sql index 072c4ec..d14f4bc 100644 --- a/packaging/dbscripts/bookmarks_sp.sql +++ b/packaging/dbscripts/bookmarks_sp.sql @@ -90,13 +90,3 @@ END; $procedure$ LANGUAGE plpgsql; -Create or replace FUNCTION GetAllVm_poolsByUser_id_with_groups_and_UserRoles(v_user_id UUID) -RETURNS SETOF vm_pools_view STABLE - AS $procedure$ -BEGIN - RETURN QUERY SELECT DISTINCT pools.* - FROM vm_pools_view pools - INNER JOIN user_vm_pool_permissions_view ON user_id = v_user_id AND entity_id = pools.vm_pool_id; -END; $procedure$ -LANGUAGE plpgsql; - diff --git a/packaging/dbscripts/vm_pools_sp.sql b/packaging/dbscripts/vm_pools_sp.sql index c59ae00..b6cb4ed 100644 --- a/packaging/dbscripts/vm_pools_sp.sql +++ b/packaging/dbscripts/vm_pools_sp.sql @@ -261,3 +261,12 @@ END; $procedure$ LANGUAGE plpgsql; +Create or replace FUNCTION GetAllVm_poolsByUser_id_with_groups_and_UserRoles(v_user_id UUID) +RETURNS SETOF vm_pools_view STABLE + AS $procedure$ +BEGIN + RETURN QUERY SELECT DISTINCT pools.* + FROM vm_pools_view pools + INNER JOIN user_vm_pool_permissions_view ON user_id = v_user_id AND entity_id = pools.vm_pool_id; +END; $procedure$ +LANGUAGE plpgsql; -- To view, visit https://gerrit.ovirt.org/40061 To unsubscribe, visit https://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ib8dcbca872a5ae9bd31b60f533cbddcc23a410bf Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Yevgeny Zaspitsky <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
