/** * Lock job queue for working on current job * Helper funcion * @access private * @param JobQueueObj $job * @return TRUE|FALSE */ private function lockJob(JobQueueObj $job) { if (!is_numeric($job->id)) { throw JobQueueException("Job id is not numeric!"); } $qb = new QueryBuilder(); $qb->update(TBL::get('TBL_JOB_QUEUE'))->set(new Field('status'), self::JOB_STATUS_IN_PROCESS)->set(new Field('start_date'), new Func('NOW'))->where($qb->expr()->equal(new Field('id'), $job->id)); return $this->query->exec($qb->getSQL())->affected(); }
/** * delete all required authorization users * @return Ambigous <boolean, number> */ public function deleteAuthorizationUsers() { $qb = new QueryBuilder(); $qb->delete(TBL::get('TBL_AUTH_USERS', 'YubikeyUserAuthorization')); return $this->query->exec($qb->getSQL())->affected(); }