From 555471200c10f0b208b658dc460068ef64d8dbe2 Mon Sep 17 00:00:00 2001
From: Adam Ierymenko <adam.ierymenko@gmail.com>
Date: Thu, 17 Oct 2013 05:40:04 -0400
Subject: Add DISTINCT to queue query.

---
 netconf-service/netconf.cpp | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/netconf-service/netconf.cpp b/netconf-service/netconf.cpp
index 7c8bcb6e..7e57562a 100644
--- a/netconf-service/netconf.cpp
+++ b/netconf-service/netconf.cpp
@@ -164,7 +164,7 @@ int main(int argc,char **argv)
 			Dictionary to;
 			{
 				Query q = dbCon->query();
-				q << "SELECT LOWER(HEX(Node_id)) AS Node_id,LOWER(HEX(Network_id)) AS Network_id FROM QNetworkConfigRefresh";
+				q << "SELECT DISTINCT LOWER(HEX(Node_id)) AS Node_id,LOWER(HEX(Network_id)) AS Network_id FROM QNetworkConfigRefresh";
 				StoreQueryResult rs = q.store();
 				for(unsigned long i=0;i<rs.num_rows();++i) {
 					std::string &nwids = to[rs[i]["Node_id"]];
-- 
cgit v1.2.3