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)