def execute(self, query): try: db = DB.connect(host=DBInfo.db_host, user = DBInfo.db_user, passwd = DBInfo.db_pwd, db=DBInfo.db_name) curr = db.cursor() except Exception, e: logger.error('in SQLWorker.execute %s' % (e.message,))
def CreateSession(note): """Creates new session in db 'bolt' table 'sessions' Changes note.session_id""" try: sql = SQLWorker() sql.execute(new_session_query % (note.id, note.start_time)) last_session = GetLastSessionInfo(note) note.session_id = last_session['id'] SaveSessionInfo(note) except Exception, e: logger.error("Can't create session info to note %s: %s" % (note.name, e.message))
def GetLastSessionInfo(note): """Creates new session in db 'bolt' table 'sessions' Changes note.session_id""" res = {} try: sql = SQLWorker() q_res = sql.execute(get_last_session_query % (note.id,)) if (len(q_res) != 0 ): q_res= q_res[0] res['id'] = q_res[0] res['comp_id'] = q_res[1] res['start'] = q_res[2] res['stop'] = q_res[3] except Exception, e: logger.error("Can't load last session info to note %s: %s" % (note.name, e.message))
def SaveSessionInfo(note): """Save session info for note in use Changes current opened session in db 'bolt' table 'sessions' Attention! Session must be created explicitly!""" # End time to unlimited session unlim_time = 0 # if (not note.inuse): # logger.error('Note %s (%s) not in use to save session info' % (note.id,note.name)) # return # FIXME: workaround for new note if (not note.session_id): print "no note session id " return try: sql = SQLWorker() if (note.has_timer): sql.execute(save_session_query % ((note.start_time + note.timer_val), note.session_id)) else: sql.execute(save_session_query % (unlim_time, note.session_id)) except Exception, e: logger.error("Can't save session info to note %s: %s" % (note.name, e.message))
def __init__(self, filename=''): try: self.worker=SQLWorker.SQLWorker() except Exception, e: logger.error('Init LogParser. %s' % (e.message,))