Eli Mesika has uploaded a new change for review. Change subject: Adding SP to update management network name ......................................................................
Adding SP to update management network name Adding a new SP RenameManagementNetwork(v_name varchar(50) that updates the management network name in both vdc_options & network tables. Change-Id: I29b73e8fa1986610c931abdd2fea5b3536a3037d Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=1059430 Signed-off-by: Eli Mesika <emes...@redhat.com> --- M packaging/dbscripts/network_sp.sql 1 file changed, 14 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/94/23894/1 diff --git a/packaging/dbscripts/network_sp.sql b/packaging/dbscripts/network_sp.sql index 47b67a1..02acfc5 100644 --- a/packaging/dbscripts/network_sp.sql +++ b/packaging/dbscripts/network_sp.sql @@ -1273,3 +1273,17 @@ vds_interface_view.vds_id = v_host_id; END; $procedure$ LANGUAGE plpgsql; + +Create or replace FUNCTION RenameManagementNetwork(v_name varchar(50)) RETURNS VOID + AS $procedure$ +DECLARE + v_management_network_id UUID; + v_old_name varchar(4000); +BEGIN + select option_value into v_old_name from vdc_options where option_name = 'ManagementNetwork' and version = 'general'; + select id into v_management_network_id from network where name = v_old_name; + perform fn_db_update_config_value('ManagementNetwork', v_name, 'general'); + update network set name = v_name where id = v_management_network_id; +END; $procedure$ +LANGUAGE plpgsql; + -- To view, visit http://gerrit.ovirt.org/23894 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I29b73e8fa1986610c931abdd2fea5b3536a3037d Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Eli Mesika <emes...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
