def run(self): while 1: try: item = gl.CREATEDQUE.get(timeout=1) p = self.ini.get_plate(item['path']) if item['fresh']: t = time.mktime(time.strptime(p['datetime'], '%Y-%m-%d %H:%M:%S')) query = Upload.insert(timestamp=int(t), uploadflag=True, path=item['path'], plateinfo=json.dumps(p)) query.execute() else: query = Upload.update(uploadflag=True).where(Upload.id == item['id']) query.execute() print datetime.datetime.now(), self.t_name, item['path'] time.sleep(1) except Queue.Empty: pass except Exception as e: print e time.sleep(1) finally: if self.is_quit: break
def update_test(): query = Upload.update(uploadflag=True).where(Upload.id == 100115) query.execute()