diff options
Diffstat (limited to 'store.py')
-rw-r--r-- | store.py | 21 |
1 files changed, 11 insertions, 10 deletions
@@ -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): |