diff options
Diffstat (limited to 'tools/mmd/MmdDb.py')
-rw-r--r-- | tools/mmd/MmdDb.py | 16 |
1 files changed, 15 insertions, 1 deletions
diff --git a/tools/mmd/MmdDb.py b/tools/mmd/MmdDb.py index 18a4df8..1065bb6 100644 --- a/tools/mmd/MmdDb.py +++ b/tools/mmd/MmdDb.py @@ -1,3 +1,4 @@ +# -*- encoding: utf-8 -*- """ sqlite3 database module for MURSAT1 Mission Dashboard """ @@ -8,6 +9,7 @@ class Db: def __init__ (self): self.conn = sqlite3.connect ('/usr/local/mmd/db/mmd.db') + self.conn.text_factory = str self.cursor = self.conn.cursor () def sessionFind (self, session_id): @@ -47,6 +49,14 @@ class Db: (user_id, firstname, lastname, email, callsign, password, confreg)) self.conn.commit () + def userDelete (self, user_id): + self.cursor.execute ('DELETE FROM user WHERE id=?', (user_id,)) + self.conn.commit () + + def userFindId (self, user_id): + self.cursor.execute ('SELECT * FROM user WHERE id=?', (user_id,)) + return self.cursor.fetchone () + def close (self): self.cursor.close () self.conn.close () @@ -54,11 +64,15 @@ class Db: if __name__ == "__main__": db = Db () print db.sessionFind ('1234567890') - db.sessionInit ('1234567890') + db.sessionInit ('1234567890', 'jogi@mur.at', '1') data = db.sessionFind ('1234567890') print data[0], data[1] db.sessionDelete ('1234567890') print db.sessionFind ('1234567890') + print db.userFindId ('1') + db.userCreate ('1', 'Jogi', 'Hofmüller', 'jogi@mur.at', '', '', '') + print db.userFindId ('1') + db.userDelete ('1') # vim: tw=0 ts=2 expandtab |