- added renewal for session id (every ten minutes)

- changed session timeout from ten minutes to two days


git-svn-id: https://svn.spreadspace.org/mur.sat@93 7de4ea59-55d0-425e-a1af-a3118ea81d4c

1 files changed, 6 insertions, 2 deletions

diff --git a/tools/mmd/MmdDb.py b/tools/mmd/MmdDb.py
index 2ef5824..1db8f17 100644
--- a/tools/mmd/MmdDb.py
+++ b/tools/mmd/MmdDb.py
@@ -19,9 +19,9 @@ class Db:
     self.cursor.execute ('SELECT * FROM session WHERE id=?', (session_id,))
     return self.cursor.fetchone ()
 
-  def sessionInit (self, session_id, email, expires, status):
+  def sessionInit (self, session_id, email, expires, renewal, status):
     try:
-      self.cursor.execute ('INSERT INTO session (id, email, expires, status) VALUES (?,?,?,?)', (session_id, email, expires, status,))
+      self.cursor.execute ('INSERT INTO session (id, email, expires, renewal, status) VALUES (?,?,?,?,?)', (session_id, email, expires, renewal, status,))
       self.conn.commit ()
       return True
     except sqlite3.IntegrityError:
@@ -35,6 +35,10 @@ class Db:
     self.cursor.execute ('UPDATE session SET expires=? WHERE id=?', (expires, session_id,))
     self.conn.commit ()
 
+  def sessionRenew (self, session_id, expires, renewal, token):
+    self.cursor.execute ('UPDATE session SET expires=?,renewal=?,id=? WHERE id=?', (expires, renewal, token, session_id,))
+    self.conn.commit ()
+
   def sessionSetEmail (self, session_id, email):
     self.cursor.execute ('UPDATE session SET email=? WHERE id=?', (email, session_id))
     self.conn.commit ()