def BillNote(note):
sql = SQLWorker()
if (note.time > min_time):
sql.execute(bill_query % (note.id, note.time, note.money, int(time.time())))
if (note.inuse == True):
note.SetUse(False)
note.time = 0
note.printing = False
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 PrintCheckForNote(note):
note.printing = True
sql = SQLWorker()
sql.execute(billQuery % (note.id, note.time, note.money, int(time.time())))
s = "Работа c ноутбуком %s завершена. %s" % (ReprName(note.name, use_markup=False), ReprMoney(note.money))
msg = gtk.MessageDialog(flags=gtk.DIALOG_MODAL, buttons=gtk.BUTTONS_CLOSE, message_format=s)
msg.run()
msg.destroy()
note.printing = False
note.time = 0
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 __init__(self, name, billing, log):
self.name = name
self.log = log
# default values
# is note on flag
self.works = True
# is note in use flag
self.inuse = False
# time meter
self.oldtime = 0
self.time = 0
# money meter
self.money = 0
self.billing = billing
# battery meter
self.batt = 100
self.ip = ''
try:
self.worker = SQLWorker()
except:
pass
self.broken = False
self.turnedOn = True
self.get = False
self.ignoreTurnOff = False
self.ignore_ping = datetime.now()
self.first_time = True
self.printing = False
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))
#!/usr/bin/env python
from time import sleep
from random import randint
#from ConfigParser import ConfigParser
''' Read test input and change some data '''
from SQLWorker import SQLWorker
worker = SQLWorker()
while (1):
#parser = ConfigParser()
#parser.read('test.ini')
#notes = parser.sections()
#for note in notes:
# parser.set(note, "last_ping", int(time()))
#with open('test.ini', 'w') as f:
# parser.write(f)
life = randint(10, 100)
worker.execute('update computers SET lifepercent=%d' % (life,))
sleep(15)
