1 files changed, 24 insertions, 2 deletions
diff --git a/tools/mmd/MmdDb.py b/tools/mmd/MmdDb.py
index 6947c88..640a8ff 100644
--- a/tools/mmd/MmdDb.py
+++ b/tools/mmd/MmdDb.py
@@ -14,14 +14,36 @@ class Db:
     self.cursor.execute ('SELECT * FROM session WHERE id=?', (session_id,))
     return self.cursor.fetchone ()
 
-  def sessionInit (self, session_id, user):
-    self.cursor.execute ('INSERT INTO session VALUES (?,?)', (session_id, user,))
+  def sessionInit (self, session_id, email, expires):
+    self.cursor.execute ('INSERT INTO session (id, email, expires) VALUES (?,?,?)', (session_id, email, expires,))
     self.conn.commit ()
 
   def sessionDelete (self, session_id):
     self.cursor.execute ('DELETE FROM session WHERE id=?', (session_id,))
     self.conn.commit ()
 
+  def sessionUpdate (self, session_id, expires):
+    self.cursor.execute ('UPDATE session SET expires=? WHERE id=?', (expires, 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 ()
+
+  def sessionSetStatus (self, session_id, status):
+    self.cursor.execute ('UPDATE session SET status=? WHERE id=?', (status, session_id))
+    self.conn.commit ()
+
+  def sessionDeleteExpired (self, expires):  
+    self.cursor.execute ('DELETE FROM session WHERE expires<?', (expires,))
+    self.conn.commit ()
+    return self.cursor.rowcount
+
+  def userCreate (self, user_id, firstname, lastname, email, callsign, password):
+    self.cursor.execute ('INSERT INTO user (id, firstname, lastname, email, callsign, password) VALUES (?,?,?,?,?,?)',
+      (user_id, firstname, lastname, email, callsign, password))
+    self.conn.commit ()
+
   def close (self):
     self.cursor.close ()
     self.conn.close ()