Lior Vernia has posted comments on this change. Change subject: core: Mark management network as display and migration ......................................................................
Patch Set 1: Verified+1 (1 comment) .................................................... File packaging/dbscripts/upgrade/03_04_0240_set_display_migration_cluster_network.sql Line 5: id UUID; Line 6: BEGIN Line 7: SELECT option_value FROM vdc_options WHERE option_name='ManagementNetwork' INTO mgmt_name; Line 8: FOR id IN (SELECT DISTINCT cluster_id FROM network_cluster) LOOP Line 9: SELECT network_id FROM network_cluster_view WHERE cluster_id=id AND network_name=mgmt_name INTO mgmt_id; I wasn't sure whether the views exist when upgrade scripts are run, but the Jenkins upgrade script test seems to approve. Line 10: IF NOT EXISTS (SELECT 1 FROM network_cluster WHERE cluster_id=id AND is_display=true) THEN Line 11: UPDATE network_cluster SET is_display=true WHERE cluster_id=id AND network_id=mgmt_id; Line 12: END IF; Line 13: IF NOT EXISTS (SELECT network_id FROM network_cluster WHERE cluster_id=id AND migration=true) THEN -- To view, visit http://gerrit.ovirt.org/22382 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: comment Gerrit-Change-Id: I73bf3c583ae28bf32d7c602ec9f4b0fb5c7f391d Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Lior Vernia <[email protected]> Gerrit-Reviewer: Eli Mesika <[email protected]> Gerrit-Reviewer: Lior Vernia <[email protected]> Gerrit-Reviewer: Mike Kolesnik <[email protected]> Gerrit-Reviewer: Moti Asayag <[email protected]> Gerrit-Reviewer: oVirt Jenkins CI Server Gerrit-HasComments: Yes _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
