"""
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