Arik Hadas has uploaded a new change for review. Change subject: core: add managed virtio-serial devices on upgrade ......................................................................
core: add managed virtio-serial devices on upgrade The upgrade scripts do the following things: - Change every existing virtio-serial device to be managed - Then is adds managed virtio-serial device to VMs that don't have it Change-Id: I5b99dd3fa0d43307788a685c0115b32691757454 Signed-off-by: Arik Hadas <[email protected]> --- A packaging/dbscripts/upgrade/03_05_0760_change_virtio_serial_to_managed_device.sql 1 file changed, 21 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/40/29840/1 diff --git a/packaging/dbscripts/upgrade/03_05_0760_change_virtio_serial_to_managed_device.sql b/packaging/dbscripts/upgrade/03_05_0760_change_virtio_serial_to_managed_device.sql new file mode 100644 index 0000000..2dec670 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_05_0760_change_virtio_serial_to_managed_device.sql @@ -0,0 +1,21 @@ +-- change existing unmanaged virtio-serial devices to be managed +update vm_device set is_managed=true where device='virtio-serial'; + +-- add managed virtio-serial device to each vm that does not have it +Create or replace FUNCTION __temp_add_missing_virio_serial_devices() +RETURNS VOID + AS $procedure$ + DECLARE + v_vm_guid UUID; +BEGIN + FOR v_vm_guid in (select vm_guid from vm_static where vm_guid not in (select vm_id from vm_device where device='virtio-serial')) LOOP + INSERT INTO vm_device (device_id, vm_id, type, device, address, spec_params, is_managed, is_plugged, custom_properties, snapshot_id) + VALUES ((SELECT uuid_generate_v1()), v_vm_guid, 'controller', 'virtio-serial', '', '', true, true, '', NULL); + END LOOP; + +RETURN; +END; $procedure$ +LANGUAGE plpgsql; + +SELECT __temp_add_missing_virio_serial_devices(); +DROP function __temp_add_missing_virio_serial_devices(); -- To view, visit http://gerrit.ovirt.org/29840 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I5b99dd3fa0d43307788a685c0115b32691757454 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Arik Hadas <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
