X-Git-Url: https://osm.etsi.org/gitweb/?a=blobdiff_plain;f=vim_db.py;h=a458a8ec95a4f51812ad124cf7fafa5efba51023;hb=8eeb7a6cd7316c2d0b3766df9dfe78411b2c7e13;hp=11a7aa12e417f73dccc5dbfb5efbeb551f9e7aa9;hpb=69a5739aef6bdc5e0ebc12ebfe6a4775e8211304;p=osm%2Fopenvim.git

diff --git a/vim_db.py b/vim_db.py
index 11a7aa1..a458a8e 100644
--- a/vim_db.py
+++ b/vim_db.py
@@ -218,10 +218,14 @@ class vim_db():
             'WHERE_OR': dict of key:values, translated to key=value OR ... (Optional)
             'WHERE_AND_OR: str 'AND' or 'OR'(by default) mark the priority to 'WHERE AND (WHERE_OR)' or (WHERE) OR WHERE_OR' (Optional)
             'LIMIT': limit of number of rows (Optional)
+            'DISTINCT': make a select distinct to remove repeated elements
         Return: a list with dictionarys at each row
         '''
         #print sql_dict
-        select_= "SELECT " + ("*" if 'SELECT' not in sql_dict else ",".join(map(str,sql_dict['SELECT'])) )
+        select_ = "SELECT "
+        if sql_dict.get("DISTINCT"):
+            select_ += "DISTINCT "
+        select_ += ("*" if 'SELECT' not in sql_dict else ",".join(map(str,sql_dict['SELECT'])) )
         #print 'select_', select_
         from_  = "FROM " + str(sql_dict['FROM'])
         #print 'from_', from_