def run(self): while 1: instances = session.query(Instances).all() for ins in instances: if not checker_uuid(ins.uuid): session.query(Instances).filter(Instances.uuid==ins.uuid).delete() session.commit() time.sleep(300)
def run(self): while 1: item = self.queue.get(True) for ins in item: q = session.query(Instances).filter(Instances.uuid==ins['id']) if not q.all(): i = Instances(ip_address=simplejson.dumps(ins['ip_address']), name=ins['name'], \ uuid=ins['id'], state=ins['power_state'],physical_host=ins['physical_host']) session.add(i) session.commit() else: q.update({Instances.ip_address:simplejson.dumps(ins['ip_address']),Instances.name:ins['name'], \ Instances.uuid:ins['id'],Instances.state:ins['power_state'],Instances.physical_host:ins['physical_host'] }) session.commit()