blob: 6947c88b532482372a49de8ff718c74f5bcf6621 (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
|
"""
sqlite3 database module for MURSAT1 Mission Dashboard
"""
import sqlite3
class Db:
def __init__ (self):
self.conn = sqlite3.connect ('/usr/local/mmd/db/mmd.db')
self.cursor = self.conn.cursor ()
def sessionFind (self, session_id):
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,))
self.conn.commit ()
def sessionDelete (self, session_id):
self.cursor.execute ('DELETE FROM session WHERE id=?', (session_id,))
self.conn.commit ()
def close (self):
self.cursor.close ()
self.conn.close ()
if __name__ == "__main__":
db = Db ()
print db.sessionFind ('1234567890')
db.sessionInit ('1234567890')
data = db.sessionFind ('1234567890')
print data[0], data[1]
db.sessionDelete ('1234567890')
print db.sessionFind ('1234567890')
# vim: tw=0 ts=2 expandtab
# EOF
|