Correcciones en consultas para devolución de registro completo y agregado de campo fav en treview.

1 files changed, 2 insertions, 2 deletions

diff --git a/store.py b/store.py
index 2c905c2..9a2368a 100644
--- a/store.py
+++ b/store.py
@@ -48,7 +48,7 @@ CREATE TABLE IF NOT EXISTS notifications (id INTEGER PRIMARY KEY,title VARCHAR(3
         c = con.cursor()
         c.execute('BEGIN TRANSACTION')
         try:
-            c.execute('insert into notifications(%s,%s,%s,%s,%s,%s,%s)  values (?,?,?,?,?,?,?)' %tuple(keys), values)
+            c.execute('insert into notifications(%s,%s,%s,%s,%s,%s,%s,%s)  values (?,?,?,?,?,?,?,?)' %tuple(keys), values)
         except sqlite3.IntegrityError,e:
             print "Error al insertar datos: %s" %str(e)
         c.execute('END TRANSACTION')
@@ -110,7 +110,7 @@ CREATE TABLE IF NOT EXISTS notifications (id INTEGER PRIMARY KEY,title VARCHAR(3
                 filters+=' and ' if args else ''
         c = con.cursor()
         c.execute('BEGIN TRANSACTION')
-        c.execute('SELECT title, text, type, launched, expires FROM notifications %s order by priority desc;' %filters)
+        c.execute('SELECT id, priority, title, text, launched, expires, type, fav  FROM notifications %s order by priority desc;' %filters)
         output = c.fetchall()
         c.execute('END TRANSACTION')
         self._close_connection(con)