diff options
author | Jogi Hofmüller <jogi@mur.at> | 2011-07-31 15:52:59 +0000 |
---|---|---|
committer | Jogi Hofmüller <jogi@mur.at> | 2011-07-31 15:52:59 +0000 |
commit | f852eea73acb6d04d7b9213949fc521b92636a96 (patch) | |
tree | 38cedb0c6c4fba3f99767594845dbe64237533b7 /tools/mmd/MmdDb.py | |
parent | 1wire for DS1821 works now (diff) |
- new module MmdUser.py
- registration works basically
git-svn-id: https://svn.spreadspace.org/mur.sat@85 7de4ea59-55d0-425e-a1af-a3118ea81d4c
Diffstat (limited to 'tools/mmd/MmdDb.py')
-rw-r--r-- | tools/mmd/MmdDb.py | 26 |
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 () |