Eli Mesika has posted comments on this change.

Change subject: core: Mark management network as display and migration
......................................................................


Patch Set 6:

(2 comments)

http://gerrit.ovirt.org/#/c/22382/6/packaging/dbscripts/upgrade/03_04_0510_set_display_migration_cluster_network.sql
File 
packaging/dbscripts/upgrade/03_04_0510_set_display_migration_cluster_network.sql:

Line 13:                   FROM network
Line 14:                   WHERE network.id = nc1.network_id AND name = 
mgmt_name)
Line 15:         AND NOT EXISTS (SELECT 1
Line 16:                         FROM network_cluster nc2
Line 17:                         WHERE nc2.cluster_id = nc1.cluster_id AND 
nc2.is_display = true);
WHERE nc2.cluster_id = nc1.cluster_id AND nc2.is_display
Line 18: 
Line 19:     UPDATE network_cluster nc1
Line 20:     SET migration = true
Line 21:     WHERE EXISTS (SELECT 1


Line 22:                   FROM network
Line 23:                   WHERE network.id = nc1.network_id AND name = 
mgmt_name)
Line 24:         AND NOT EXISTS (SELECT 1
Line 25:                         FROM network_cluster nc2
Line 26:                         WHERE nc2.cluster_id = nc1.cluster_id AND 
nc2.migration = true);
WHERE nc2.cluster_id = nc1.cluster_id AND nc2.migration
Line 27: END;
Line 28: $$ LANGUAGE plpgsql;
Line 29: 
Line 30: SELECT __temp_set_display_migration();


-- 
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: 6
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Lior Vernia <lver...@redhat.com>
Gerrit-Reviewer: Eli Mesika <emes...@redhat.com>
Gerrit-Reviewer: Lior Vernia <lver...@redhat.com>
Gerrit-Reviewer: Mike Kolesnik <mkole...@redhat.com>
Gerrit-Reviewer: Moti Asayag <masa...@redhat.com>
Gerrit-Reviewer: oVirt Jenkins CI Server
Gerrit-HasComments: Yes
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to