cambios en store.py

1 files changed, 11 insertions, 10 deletions

diff --git a/store.py b/store.py
index e5ef897..9d1c959 100644
--- a/store.py
+++ b/store.py
@@ -79,16 +79,17 @@ class Db:
             order = "ASC"
         else:
             order = "DESC"
-        mappedValue = "type"
-        if value == "Tipo":
-            mappedValue = "type"
-        elif value == "Prioridad":
-            mappedValue = "priority"
-        elif value == "Lanzamiento":
-            mappedValue = "launched"
-        elif value == u"Expiración":
-            mappedValue = "expires"
-        query = "select distinct " + mappedValue + " from notifications order by type " + order
+        value = value.lower()
+        mapped_value = "type"
+        if value == "tipo":
+            mapped_value = "type"
+        elif value == "prioridad":
+            mapped_value = "priority"
+        elif value == "lanzamiento":
+            mapped_value = "launched"
+        elif value == u"expiración":
+            mapped_value = "expires"
+        query = "select distinct %s from notifications order by %s %s " %(mapped_value, mapped_value, order)
         return map(lambda x:x[mappedValue],self.run_query(query))
 
     def set_fav(self, id_msg, fav=True):