Eli Mesika has uploaded a new change for review. Change subject: core: fix external events injection ......................................................................
core: fix external events injection This patch fixes a regression that cause external events injection to fail MLA validation. The problem was in the DB squashing of 3.2 done in commit 11bc072021a28560261dc2601f8fd106c9c322e6 Change-Id: I8703aa99b8f630e99110de8fc523a55c63fd10c1 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=1173947 Signed-off-by: emesika <[email protected]> --- A packaging/dbscripts/upgrade/03_06_1190_fix_external_events_role_groups.sql 1 file changed, 13 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/54/36154/1 diff --git a/packaging/dbscripts/upgrade/03_06_1190_fix_external_events_role_groups.sql b/packaging/dbscripts/upgrade/03_06_1190_fix_external_events_role_groups.sql new file mode 100644 index 0000000..8b8defd --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_1190_fix_external_events_role_groups.sql @@ -0,0 +1,13 @@ +CREATE OR REPLACE FUNCTION __temp_fix_external_events_role_groups() RETURNS VOID AS $$ +BEGIN + UPDATE roles_groups set action_group_id = 1400 + where role_id = 'def0000c-0000-0000-0000-def000000000' and action_group_id = 1500; + IF not exists (select 1 from roles_groups where role_id = '00000000-0000-0000-0000-000000000001' and action_group_id = 1400) THEN + insert into roles_groups(role_id, action_group_id) values ('00000000-0000-0000-0000-000000000001', 1400) ; + END IF; +END; +$$ LANGUAGE plpgsql; + +SELECT __temp_fix_external_events_role_groups(); +DROP FUNCTION __temp_fix_external_events_role_groups(); + -- To view, visit http://gerrit.ovirt.org/36154 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I8703aa99b8f630e99110de8fc523a55c63fd10c1 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.5 Gerrit-Owner: Eli Mesika <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
