Muli Salem has uploaded a new change for review.

Change subject: engine: Add Network Search for Cluster Name
......................................................................

engine: Add Network Search for Cluster Name

This patch adds the cluster name column to network_cluster_view.
It also joins the network and network_cluster tables.

Change-Id: I77bc293ac47b7cc94a1d4355da2fec11649c4b47
Signed-off-by: Muli Salem <msa...@redhat.com>
---
M backend/manager/dbscripts/create_views.sql
M 
backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkClusterConditionFieldAutoCompleter.java
A 
backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkCrossRefAutoCompleter.java
M 
backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SearchObjectAutoCompleter.java
4 files changed, 25 insertions(+), 4 deletions(-)


  git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/55/9155/1

diff --git a/backend/manager/dbscripts/create_views.sql 
b/backend/manager/dbscripts/create_views.sql
index 4561008..af73e5b 100644
--- a/backend/manager/dbscripts/create_views.sql
+++ b/backend/manager/dbscripts/create_views.sql
@@ -1041,9 +1041,11 @@
 CREATE OR REPLACE VIEW network_cluster_view
 AS
 SELECT network_cluster.cluster_id AS cluster_id, network_cluster.network_id AS 
network_id, network.name as network_name,
-       network_cluster.status as status, network_cluster.required as required, 
network_cluster.is_display as is_display
+       network_cluster.status as status, network_cluster.required as required, 
network_cluster.is_display as is_display,
+       vds_groups.name as cluster_name
 FROM network_cluster
-INNER JOIN network ON network_cluster.network_id = network.id;
+INNER JOIN network ON network_cluster.network_id = network.id
+INNER JOIN vds_groups ON network_cluster.cluster_id = vds_groups.vds_group_id;
 
 CREATE OR REPLACE VIEW network_view
 AS
diff --git 
a/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkClusterConditionFieldAutoCompleter.java
 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkClusterConditionFieldAutoCompleter.java
index 9112f68..f3c21f4 100644
--- 
a/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkClusterConditionFieldAutoCompleter.java
+++ 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkClusterConditionFieldAutoCompleter.java
@@ -3,19 +3,23 @@
 
 public class NetworkClusterConditionFieldAutoCompleter extends 
BaseConditionFieldAutoCompleter {
     private static final String NETWORK_NAME = "NETWORK_NAME";
+    private static final String CLUSTER_NAME = "CLUSTER_NAME";
 
     public NetworkClusterConditionFieldAutoCompleter() {
         // Building the basic verbs dict.
         mVerbs.put(NETWORK_NAME, NETWORK_NAME);
+        mVerbs.put(CLUSTER_NAME, CLUSTER_NAME);
 
         // Building the autoCompletion dict.
         buildCompletions();
 
         // Building the types dict.
         getTypeDictionary().put(NETWORK_NAME, String.class);
+        getTypeDictionary().put(CLUSTER_NAME, String.class);
 
         // building the ColumnName dict.
         mColumnNameDict.put(NETWORK_NAME, "network_name");
+        mColumnNameDict.put(CLUSTER_NAME, "cluster_name");
 
         // Building the validation dict.
         buildBasicValidationTable();
diff --git 
a/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkCrossRefAutoCompleter.java
 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkCrossRefAutoCompleter.java
new file mode 100644
index 0000000..dda0f57
--- /dev/null
+++ 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/NetworkCrossRefAutoCompleter.java
@@ -0,0 +1,8 @@
+package org.ovirt.engine.core.searchbackend;
+
+public class NetworkCrossRefAutoCompleter extends 
SearchObjectsBaseAutoCompleter {
+    public NetworkCrossRefAutoCompleter() {
+        mVerbs.put(SearchObjects.NETWORK_CLUSTER_OBJ_NAME, 
SearchObjects.NETWORK_CLUSTER_OBJ_NAME);
+        buildCompletions();
+    }
+}
diff --git 
a/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SearchObjectAutoCompleter.java
 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SearchObjectAutoCompleter.java
index 0ab91da..6556216 100644
--- 
a/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SearchObjectAutoCompleter.java
+++ 
b/backend/manager/modules/searchbackend/src/main/java/org/ovirt/engine/core/searchbackend/SearchObjectAutoCompleter.java
@@ -112,6 +112,12 @@
                 SearchObjects.NETWORK_CLUSTER_OBJ_NAME,
                 "cluster_id");
 
+        // network - cluster
+        addJoin(SearchObjects.NETWORK_OBJ_NAME,
+                "id",
+                SearchObjects.NETWORK_CLUSTER_OBJ_NAME,
+                "network_id");
+
         // audit - gluster volume
         addJoin(SearchObjects.GLUSTER_VOLUME_OBJ_NAME, "id", 
SearchObjects.AUDIT_OBJ_NAME, "gluster_volume_id");
 
@@ -236,7 +242,7 @@
                             "vm_pools_full_view",
                             "vm_pool_id",
                             "vm_pool_name ASC "));
-                    put(SearchObjects.NETWORK_OBJ_NAME, new 
EntitySearchInfo(null,
+                    put(SearchObjects.NETWORK_OBJ_NAME, new 
EntitySearchInfo(new NetworkCrossRefAutoCompleter(),
                             new NetworkConditionFieldAutoCompleter(),
                             "network_view",
                             "network_view",
@@ -254,7 +260,8 @@
                             "vm_interface",
                             "name",
                             "vm_id ASC"));
-                    put(SearchObjects.NETWORK_CLUSTER_OBJ_NAME, new 
EntitySearchInfo(null,
+                    put(SearchObjects.NETWORK_CLUSTER_OBJ_NAME,
+                            new EntitySearchInfo(null,
                             new NetworkClusterConditionFieldAutoCompleter(),
                             "network_cluster_view",
                             "network_cluster_view",


--
To view, visit http://gerrit.ovirt.org/9155
To unsubscribe, visit http://gerrit.ovirt.org/settings

Gerrit-MessageType: newchange
Gerrit-Change-Id: I77bc293ac47b7cc94a1d4355da2fec11649c4b47
Gerrit-PatchSet: 1
Gerrit-Project: ovirt-engine
Gerrit-Branch: master
Gerrit-Owner: Muli Salem <msa...@redhat.com>
_______________________________________________
Engine-patches mailing list
Engine-patches@ovirt.org
http://lists.ovirt.org/mailman/listinfo/engine-patches

Reply via email to