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,))
