Lior Vernia has uploaded a new change for review. Change subject: core: Add columns and stored procedures for HostNetworkQos ......................................................................
core: Add columns and stored procedures for HostNetworkQos Updated the qos table to hold the values relevant for host network QoS, and added CRUD operations for these entities. Change-Id: I8aedaef3484e5ceb5b17ab35cff6cfd65e225bd1 Signed-off-by: Lior Vernia <[email protected]> --- M packaging/dbscripts/network_sp.sql M packaging/dbscripts/qos_sp.sql A packaging/dbscripts/upgrade/03_06_0430_add_host_network_qos_columns.sql 3 files changed, 52 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/20/34120/1 diff --git a/packaging/dbscripts/network_sp.sql b/packaging/dbscripts/network_sp.sql index 9f9f5d7..c6ad01e 100644 --- a/packaging/dbscripts/network_sp.sql +++ b/packaging/dbscripts/network_sp.sql @@ -240,6 +240,20 @@ +Create or replace FUNCTION GetAllNetworksByQosId(v_id UUID) +RETURNS SETOF network STABLE +AS $procedure$ +BEGIN + RETURN QUERY + SELECT * + FROM network + WHERE qos_id = v_id; +END; $procedure$ +LANGUAGE plpgsql; + + + + Create or replace FUNCTION GetAllNetworksByNetworkProviderId(v_id UUID) RETURNS SETOF network STABLE AS $procedure$ diff --git a/packaging/dbscripts/qos_sp.sql b/packaging/dbscripts/qos_sp.sql index 01230bc..cd347db 100644 --- a/packaging/dbscripts/qos_sp.sql +++ b/packaging/dbscripts/qos_sp.sql @@ -54,6 +54,22 @@ END; $procedure$ LANGUAGE plpgsql; +Create or replace FUNCTION InsertHostNetworkQos(v_id uuid, + v_qos_type SMALLINT, + v_name VARCHAR(50), + v_description TEXT, + v_storage_pool_id uuid, + v_out_average_linkshare INTEGER, + v_out_average_upperlimit INTEGER, + v_out_average_realtime INTEGER) +RETURNS VOID + AS $procedure$ +BEGIN +INSERT INTO qos(id, qos_type, name, description, storage_pool_id, out_average_linkshare, out_average_upperlimit, out_average_realtime) + VALUES(v_id, v_qos_type, v_name, v_description, v_storage_pool_id, v_out_average_linkshare, v_out_average_upperlimit, v_out_average_realtime); +END; $procedure$ +LANGUAGE plpgsql; + Create or replace FUNCTION UpdateStorageQos(v_id uuid, v_qos_type SMALLINT, v_name VARCHAR(50), @@ -113,6 +129,25 @@ END; $procedure$ LANGUAGE plpgsql; +Create or replace FUNCTION UpdateHostNetworkQos(v_id uuid, + v_qos_type SMALLINT, + v_name VARCHAR(50), + v_description TEXT, + v_storage_pool_id uuid, + v_out_average_linkshare INTEGER, + v_out_average_upperlimit INTEGER, + v_out_average_realtime INTEGER) +RETURNS VOID + AS $procedure$ +BEGIN + UPDATE qos + SET qos_type = v_qos_type, name = v_name, description = v_description, storage_pool_id = v_storage_pool_id, + out_average_linkshare = v_out_average_linkshare, out_average_upperlimit = v_out_average_upperlimit, out_average_realtime = v_out_average_realtime, + _update_date = LOCALTIMESTAMP + WHERE id = v_id; +END; $procedure$ +LANGUAGE plpgsql; + Create or replace FUNCTION DeleteQos(v_id UUID) RETURNS VOID AS $procedure$ BEGIN diff --git a/packaging/dbscripts/upgrade/03_06_0430_add_host_network_qos_columns.sql b/packaging/dbscripts/upgrade/03_06_0430_add_host_network_qos_columns.sql new file mode 100644 index 0000000..9eada87 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0430_add_host_network_qos_columns.sql @@ -0,0 +1,3 @@ +SELECT fn_db_add_column('qos', 'out_average_linkshare', 'INTEGER DEFAULT NULL'); +SELECT fn_db_add_column('qos', 'out_average_upperlimit', 'INTEGER DEFAULT NULL'); +SELECT fn_db_add_column('qos', 'out_average_realtime', 'INTEGER DEFAULT NULL'); -- To view, visit http://gerrit.ovirt.org/34120 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I8aedaef3484e5ceb5b17ab35cff6cfd65e225bd1 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Lior Vernia <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
