JobManager::updateBatchJob() - Code Metrics - Inspection of "workaround due to SensioLabs insight" - mmucklo/DtcQueueBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Branch — master (294ea0)

by Matthew

created 2017-11-16 06:55 UTC

JobManager::updateBatchJob() B

↳ Parent: JobManager

Complexity

Conditions	5
Paths	5

Size

Total Lines	29
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	18
CRAP Score	5.1502

Importance

Changes

Metric	Value
dl	0
loc	29
ccs	18
cts	22
cp	0.8182
rs	8.439
c	0
b	0
f	0
cc	5
eloc	20
nc	5
nop	3
crap	5.1502

<?php

namespace Dtc\QueueBundle\ORM;

use Doctrine\ORM\EntityManager;
use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\QueryBuilder;
use Dtc\QueueBundle\Doctrine\BaseJobManager;
use Dtc\QueueBundle\Entity\Job;
use Dtc\QueueBundle\Model\BaseJob;
use Dtc\QueueBundle\Model\RetryableJob;
use Symfony\Component\Process\Exception\LogicException;

class JobManager extends BaseJobManager
{
    use CommonTrait;
    protected static $saveInsertCalled = null;
    protected static $resetInsertCalled = null;

    public function countJobsByStatus($objectName, $status, $workerName = null, $method = null)
    {
        /** @var EntityManager $objectManager */
        $objectManager = $this->getObjectManager();

        $queryBuilder = $objectManager
            ->createQueryBuilder()
            ->select('count(a.id)')
            ->from($objectName, 'a')
            ->where('a.status = :status');

        if (null !== $workerName) {
            $queryBuilder->andWhere('a.workerName = :workerName')
                ->setParameter(':workerName', $workerName);
        }

        if (null !== $method) {
            $queryBuilder->andWhere('a.method = :method')
                ->setParameter(':method', $workerName);
        }

        $count = $queryBuilder->setParameter(':status', $status)
            ->getQuery()->getSingleScalarResult();

        if (!$count) {
            return 0;
        }

        return $count;
    }

    /**
     * @param string|null $workerName
     * @param string|null $method
     *
     * @return int Count of jobs pruned
     */
    public function pruneErroneousJobs($workerName = null, $method = null)
    {
        /** @var EntityManager $objectManager */
        $objectManager = $this->getObjectManager();
        $queryBuilder = $objectManager->createQueryBuilder()->delete($this->getArchiveObjectName(), 'j');
        $queryBuilder->where('j.status = :status')
            ->setParameter(':status', BaseJob::STATUS_ERROR);

        $this->addWorkerNameCriterion($queryBuilder, $workerName, $method);
        $query = $queryBuilder->getQuery();

        return intval($query->execute());
    }

    protected function resetSaveOk($function)
    {
        $objectManager = $this->getObjectManager();
        $splObjectHash = spl_object_hash($objectManager);

        if ('save' === $function) {
            $compare = static::$resetInsertCalled;
        } else {
            $compare = static::$saveInsertCalled;
        }

        if ($splObjectHash === $compare) {
            // Insert SQL is cached...
            $msg = "Can't call save and reset within the same process cycle (or using the same EntityManager)";
            throw new LogicException($msg);
        }

        if ('save' === $function) {
            static::$saveInsertCalled = spl_object_hash($objectManager);
        } else {
            static::$resetInsertCalled = spl_object_hash($objectManager);
        }
    }

    /**
     * @param string $workerName
     * @param string $method
     */
    protected function addWorkerNameCriterion(QueryBuilder $queryBuilder, $workerName = null, $method = null)
    {
        if (null !== $workerName) {
            $queryBuilder->andWhere('j.workerName = :workerName')->setParameter(':workerName', $workerName);
        }

        if (null !== $method) {
            $queryBuilder->andWhere('j.method = :method')->setParameter(':method', $method);
        }
    }

    protected function updateExpired($workerName = null, $method = null)
    {
        /** @var EntityManager $objectManager */
        $objectManager = $this->getObjectManager();
        $queryBuilder = $objectManager->createQueryBuilder()->update($this->getObjectName(), 'j');
        $queryBuilder->set('j.status', ':newStatus');
        $queryBuilder->where('j.expiresAt <= :expiresAt')
            ->setParameter(':expiresAt', new \DateTime());
        $queryBuilder->andWhere('j.status = :status')
            ->setParameter(':status', BaseJob::STATUS_NEW)
            ->setParameter(':newStatus', Job::STATUS_EXPIRED);

        $this->addWorkerNameCriterion($queryBuilder, $workerName, $method);
        $query = $queryBuilder->getQuery();

        return intval($query->execute());
    }

    /**
     * Removes archived jobs older than $olderThan.
     *
     * @param \DateTime $olderThan
     */
    public function pruneArchivedJobs(\DateTime $olderThan)
    {
        return $this->removeOlderThan($this->getArchiveObjectName(),
                'updatedAt',
                $olderThan);
    }

    public function getJobCount($workerName = null, $method = null)
    {
        /** @var EntityManager $objectManager */
        $objectManager = $this->getObjectManager();
        $queryBuilder = $objectManager->createQueryBuilder();

        $queryBuilder = $queryBuilder->select('count(j)')->from($this->getObjectName(), 'j');

        $where = 'where';
        if (null !== $workerName) {
            if (null !== $method) {
                $queryBuilder->where($queryBuilder->expr()->andX(
                    $queryBuilder->expr()->eq('j.workerName', ':workerName'),
                                                $queryBuilder->expr()->eq('j.method', ':method')
                ))
                    ->setParameter(':method', $method);
            } else {
                $queryBuilder->where('j.workerName = :workerName');
            }
            $queryBuilder->setParameter(':workerName', $workerName);
            $where = 'andWhere';
        } elseif (null !== $method) {
            $queryBuilder->where('j.method = :method')->setParameter(':method', $method);
            $where = 'andWhere';
        }

        $dateTime = new \DateTime();
        // Filter
        $queryBuilder
            ->$where($queryBuilder->expr()->orX(
                $queryBuilder->expr()->isNull('j.whenAt'),
                                        $queryBuilder->expr()->lte('j.whenAt', ':whenAt')
            ))
            ->andWhere($queryBuilder->expr()->orX(
                $queryBuilder->expr()->isNull('j.expiresAt'),
                $queryBuilder->expr()->gt('j.expiresAt', ':expiresAt')
            ))
            ->andWhere('j.locked is NULL')
            ->setParameter(':whenAt', $dateTime)
            ->setParameter(':expiresAt', $dateTime);

        $query = $queryBuilder->getQuery();

        return $query->getSingleScalarResult();
    }

    /**
     * Get Jobs statuses.
     */
    public function getStatus()
    {
        $result = [];
        $this->getStatusByEntityName($this->getObjectName(), $result);
        $this->getStatusByEntityName($this->getArchiveObjectName(), $result);

        $finalResult = [];
        foreach ($result as $key => $item) {
            ksort($item);
            foreach ($item as $status => $count) {
                if (isset($finalResult[$key][$status])) {
                    $finalResult[$key][$status] += $count;
                } else {
                    $finalResult[$key][$status] = $count;
                }
            }
        }

        return $finalResult;
    }

    /**
     * @param string $entityName
     */
    protected function getStatusByEntityName($entityName, array &$result)
    {
        /** @var EntityManager $objectManager */
        $objectManager = $this->getObjectManager();
        $result1 = $objectManager->getRepository($entityName)->createQueryBuilder('j')->select('j.workerName, j.method, j.status, count(j) as c')
            ->groupBy('j.workerName, j.method, j.status')->getQuery()->getArrayResult();

        foreach ($result1 as $item) {
            $method = $item['workerName'].'->'.$item['method'].'()';
            if (!isset($result[$method])) {
                $result[$method] = [BaseJob::STATUS_NEW => 0,
                    BaseJob::STATUS_RUNNING => 0,
                    RetryableJob::STATUS_EXPIRED => 0,
                    RetryableJob::STATUS_MAX_ERROR => 0,
                    RetryableJob::STATUS_MAX_STALLED => 0,
                    RetryableJob::STATUS_MAX_RETRIES => 0,
                    BaseJob::STATUS_SUCCESS => 0,
                    BaseJob::STATUS_ERROR => 0, ];
            }
            $result[$method][$item['status']] += intval($item['c']);
        }
    }

    /**
     * Get the next job to run (can be filtered by workername and method name).
     *
     * @param string $workerName
     * @param string $methodName
     * @param bool   $prioritize
     *
     * @return Job|null
     */
    public function getJob($workerName = null, $methodName = null, $prioritize = true, $runId = null)
    {
        /** @var EntityRepository $repository */
        $repository = $this->getRepository();
        $queryBuilder = $repository->createQueryBuilder('j');
        $dateTime = new \DateTime();
        $queryBuilder
            ->select('j.id')
            ->where('j.status = :status')->setParameter(':status', BaseJob::STATUS_NEW)
            ->andWhere('j.locked is NULL')
            ->andWhere($queryBuilder->expr()->orX(
                $queryBuilder->expr()->isNull('j.whenAt'),
                        $queryBuilder->expr()->lte('j.whenAt', ':whenAt')
            ))
            ->andWhere($queryBuilder->expr()->orX(
                $queryBuilder->expr()->isNull('j.expiresAt'),
                        $queryBuilder->expr()->gt('j.expiresAt', ':expiresAt')
            ))
            ->setParameter(':whenAt', $dateTime)
            ->setParameter(':expiresAt', $dateTime);

        $this->addWorkerNameCriterion($queryBuilder, $workerName, $methodName);

        if ($prioritize) {
            $queryBuilder->addOrderBy('j.priority', 'DESC');
            $queryBuilder->addOrderBy('j.whenAt', 'ASC');
        } else {
            $queryBuilder->orderBy('j.whenAt', 'ASC');
        }
        $queryBuilder->setMaxResults(1);

        /** @var QueryBuilder $queryBuilder */
        $query = $queryBuilder->getQuery();
        $jobs = $query->getResult();

        return $this->takeJob($jobs, $runId);
    }

    protected function takeJob($jobs, $runId = null)
    {
        if (isset($jobs[0]['id'])) {
            /** @var EntityRepository $repository */
            $repository = $this->getRepository();
            /** @var QueryBuilder $queryBuilder */
            $queryBuilder = $repository->createQueryBuilder('j');
            $queryBuilder
                ->update()
                ->set('j.locked', ':locked')
                ->setParameter(':locked', true)
                ->set('j.lockedAt', ':lockedAt')
                ->setParameter(':lockedAt', new \DateTime())
                ->set('j.status', ':status')
                ->setParameter(':status', BaseJob::STATUS_RUNNING);
            if (null !== $runId) {
                $queryBuilder
                    ->set('j.runId', ':runId')
                    ->setParameter(':runId', $runId);
            }
            $queryBuilder->where('j.id = :id');
            $queryBuilder->andWhere('j.locked is NULL');
            $queryBuilder->setParameter(':id', $jobs[0]['id']);
            $resultCount = $queryBuilder->getQuery()->execute();

            if (1 === $resultCount) {
                return $repository->find($jobs[0]['id']);
            }
        }

        return null;
    }

    /**
     * Tries to update the nearest job as a batch.
     *
     * @param \Dtc\QueueBundle\Model\Job $job
     *
     * @return mixed|null
     */
    public function updateNearestBatch(\Dtc\QueueBundle\Model\Job $job)
    {
        /** @var QueryBuilder $queryBuilder */
        $queryBuilder = $this->getRepository()->createQueryBuilder('j');
        $queryBuilder->select()
            ->where('j.crcHash = :crcHash')
            ->andWhere('j.status = :status')
            ->setParameter(':status', BaseJob::STATUS_NEW)
            ->setParameter(':crcHash', $job->getCrcHash())
            ->orderBy('j.whenAt', 'ASC')
            ->setMaxResults(1);
        $existingJobs = $queryBuilder->getQuery()->execute();

        if (empty($existingJobs)) {
            return null;
        }
        /** @var Job $existingJob */
        $existingJob = $existingJobs[0];

        $newPriority = max($job->getPriority(), $existingJob->getPriority());
        $newWhenAt = min($job->getWhenAt(), $existingJob->getWhenAt());

        $this->updateBatchJob($existingJob, $newPriority, $newWhenAt);

        return $existingJob;
    }

    protected function updateBatchJob(Job $existingJob, $newPriority, $newWhenAt)
    {
        $existingPriority = $existingJob->getPriority();
        $existingWhenAt = $existingJob->getWhenAt();

        if ($newPriority !== $existingPriority || $newWhenAt !== $existingWhenAt) {
            /** @var EntityRepository $repository */
            $repository = $this->getRepository();
            /** @var QueryBuilder $queryBuilder */
            $queryBuilder = $repository->createQueryBuilder('j');
            $queryBuilder->update();
            if ($newPriority !== $existingPriority) {
                $existingJob->setPriority($newPriority);
                $queryBuilder->set('j.priority', ':priority')
                    ->setParameter(':priority', $newPriority);
            }
            if ($newWhenAt !== $existingWhenAt) {
                $existingJob->setWhenAt($newWhenAt);
                $queryBuilder->set('j.whenAt', ':whenAt')
                    ->setParameter(':whenAt', $newWhenAt);
            }
            $queryBuilder->where('j.id = :id');
            $queryBuilder->andWhere('j.locked is NULL');
            $queryBuilder->setParameter(':id', $existingJob->getId());
            $queryBuilder->getQuery()->execute();
        }

        return $existingJob;
    }
}


1		<?php
2
3		namespace Dtc\QueueBundle\ORM;
4
5		use Doctrine\ORM\EntityManager;
6		use Doctrine\ORM\EntityRepository;
7		use Doctrine\ORM\QueryBuilder;
8		use Dtc\QueueBundle\Doctrine\BaseJobManager;
9		use Dtc\QueueBundle\Entity\Job;
10		use Dtc\QueueBundle\Model\BaseJob;
11		use Dtc\QueueBundle\Model\RetryableJob;
12		use Symfony\Component\Process\Exception\LogicException;
13
14		class JobManager extends BaseJobManager
15		{
16		use CommonTrait;
17		protected static $saveInsertCalled = null;
18		protected static $resetInsertCalled = null;
19
20	3	public function countJobsByStatus($objectName, $status, $workerName = null, $method = null)
21		{
22		/** @var EntityManager $objectManager */
23	3	$objectManager = $this->getObjectManager();
24
25		$queryBuilder = $objectManager
26	3	->createQueryBuilder()
27	3	->select('count(a.id)')
28	3	->from($objectName, 'a')
29	3	->where('a.status = :status');
30
31	3	if (null !== $workerName) {
32	1	$queryBuilder->andWhere('a.workerName = :workerName')
33	1	->setParameter(':workerName', $workerName);
34		}
35
36	3	if (null !== $method) {
37	1	$queryBuilder->andWhere('a.method = :method')
38	1	->setParameter(':method', $workerName);
39		}
40
41	3	$count = $queryBuilder->setParameter(':status', $status)
42	3	->getQuery()->getSingleScalarResult();
43
44	3	if (!$count) {
45	1	return 0;
46		}
47
48	3	return $count;
49		}
50
51		/**
52		* @param string\|null $workerName
53		* @param string\|null $method
54		*
55		* @return int Count of jobs pruned
56		*/
57	1	public function pruneErroneousJobs($workerName = null, $method = null)
58		{
59		/** @var EntityManager $objectManager */
60	1	$objectManager = $this->getObjectManager();
61	1	$queryBuilder = $objectManager->createQueryBuilder()->delete($this->getArchiveObjectName(), 'j');
62	1	$queryBuilder->where('j.status = :status')
63	1	->setParameter(':status', BaseJob::STATUS_ERROR);
64
65	1	$this->addWorkerNameCriterion($queryBuilder, $workerName, $method);
66	1	$query = $queryBuilder->getQuery();
67
68	1	return intval($query->execute());
69		}
70
71	14	protected function resetSaveOk($function)
72		{
73	14	$objectManager = $this->getObjectManager();
74	14	$splObjectHash = spl_object_hash($objectManager);
75
76	14	if ('save' === $function) {
77		$compare = static::$resetInsertCalled;
78		} else {
79	14	$compare = static::$saveInsertCalled;
80		}
81
82	14	if ($splObjectHash === $compare) {
83		// Insert SQL is cached...
84		$msg = "Can't call save and reset within the same process cycle (or using the same EntityManager)";
85		throw new LogicException($msg);
86		}
87
88	14	if ('save' === $function) {
89		static::$saveInsertCalled = spl_object_hash($objectManager);
90		} else {
91	14	static::$resetInsertCalled = spl_object_hash($objectManager);
92		}
93	14	}
94
95		/**
96		* @param string $workerName
97		* @param string $method
98		*/
99	8	protected function addWorkerNameCriterion(QueryBuilder $queryBuilder, $workerName = null, $method = null)
100		{
101	8	if (null !== $workerName) {
102	3	$queryBuilder->andWhere('j.workerName = :workerName')->setParameter(':workerName', $workerName);
103		}
104
105	8	if (null !== $method) {
106	2	$queryBuilder->andWhere('j.method = :method')->setParameter(':method', $method);
107		}
108	8	}
109
110	1	protected function updateExpired($workerName = null, $method = null)
111		{
112		/** @var EntityManager $objectManager */
113	1	$objectManager = $this->getObjectManager();
114	1	$queryBuilder = $objectManager->createQueryBuilder()->update($this->getObjectName(), 'j');
115	1	$queryBuilder->set('j.status', ':newStatus');
116	1	$queryBuilder->where('j.expiresAt <= :expiresAt')
117	1	->setParameter(':expiresAt', new \DateTime());
118	1	$queryBuilder->andWhere('j.status = :status')
119	1	->setParameter(':status', BaseJob::STATUS_NEW)
120	1	->setParameter(':newStatus', Job::STATUS_EXPIRED);
121
122	1	$this->addWorkerNameCriterion($queryBuilder, $workerName, $method);
123	1	$query = $queryBuilder->getQuery();
124
125	1	return intval($query->execute());
126		}
127
128		/**
129		* Removes archived jobs older than $olderThan.
130		*
131		* @param \DateTime $olderThan
132		*/
133	1	public function pruneArchivedJobs(\DateTime $olderThan)
134		{
135	1	return $this->removeOlderThan($this->getArchiveObjectName(),
136	1	'updatedAt',
137	1	$olderThan);
138		}
139
140	2	public function getJobCount($workerName = null, $method = null)
141		{
142		/** @var EntityManager $objectManager */
143	2	$objectManager = $this->getObjectManager();
144	2	$queryBuilder = $objectManager->createQueryBuilder();
145
146	2	$queryBuilder = $queryBuilder->select('count(j)')->from($this->getObjectName(), 'j');
147
148	2	$where = 'where';
149	2	if (null !== $workerName) {
150		if (null !== $method) {
151		$queryBuilder->where($queryBuilder->expr()->andX(
152		$queryBuilder->expr()->eq('j.workerName', ':workerName'),
153		$queryBuilder->expr()->eq('j.method', ':method')
154		))
155		->setParameter(':method', $method);
156		} else {
157		$queryBuilder->where('j.workerName = :workerName');
158		}
159		$queryBuilder->setParameter(':workerName', $workerName);
160		$where = 'andWhere';
161	2	} elseif (null !== $method) {
162		$queryBuilder->where('j.method = :method')->setParameter(':method', $method);
163		$where = 'andWhere';
164		}
165
166	2	$dateTime = new \DateTime();
167		// Filter
168		$queryBuilder
169	2	->$where($queryBuilder->expr()->orX(
170	2	$queryBuilder->expr()->isNull('j.whenAt'),
171	2	$queryBuilder->expr()->lte('j.whenAt', ':whenAt')
172		))
173	2	->andWhere($queryBuilder->expr()->orX(
174	2	$queryBuilder->expr()->isNull('j.expiresAt'),
175	2	$queryBuilder->expr()->gt('j.expiresAt', ':expiresAt')
176		))
177	2	->andWhere('j.locked is NULL')
178	2	->setParameter(':whenAt', $dateTime)
179	2	->setParameter(':expiresAt', $dateTime);
180
181	2	$query = $queryBuilder->getQuery();
182
183	2	return $query->getSingleScalarResult();
184		}
185
186		/**
187		* Get Jobs statuses.
188		*/
189		public function getStatus()
190		{
191		$result = [];
192		$this->getStatusByEntityName($this->getObjectName(), $result);
193		$this->getStatusByEntityName($this->getArchiveObjectName(), $result);
194	1
195		$finalResult = [];
196		foreach ($result as $key => $item) {
197	1	ksort($item);
198		foreach ($item as $status => $count) {
199	1	if (isset($finalResult[$key][$status])) {
200	1	$finalResult[$key][$status] += $count;
201	1	} else {
202		$finalResult[$key][$status] = $count;
203		}
204		}
205		}
206
207		return $finalResult;
208	1	}
209
210		/**
211		* @param string $entityName
212		*/
213	2	protected function getStatusByEntityName($entityName, array &$result)
214		{
215	2	/** @var EntityManager $objectManager */
216	2	$objectManager = $this->getObjectManager();
217	2	$result1 = $objectManager->getRepository($entityName)->createQueryBuilder('j')->select('j.workerName, j.method, j.status, count(j) as c')
218		->groupBy('j.workerName, j.method, j.status')->getQuery()->getArrayResult();
219	2
220	2	foreach ($result1 as $item) {
221	1	$method = $item['workerName'].'->'.$item['method'].'()';
222	1	if (!isset($result[$method])) {
223	1	$result[$method] = [BaseJob::STATUS_NEW => 0,
224		BaseJob::STATUS_RUNNING => 0,
225		RetryableJob::STATUS_EXPIRED => 0,
226	1	RetryableJob::STATUS_MAX_ERROR => 0,
227		RetryableJob::STATUS_MAX_STALLED => 0,
228		RetryableJob::STATUS_MAX_RETRIES => 0,
229		BaseJob::STATUS_SUCCESS => 0,
230		BaseJob::STATUS_ERROR => 0, ];
231	2	}
232		$result[$method][$item['status']] += intval($item['c']);
233		}
234		}
235
236		/**
237	2	* Get the next job to run (can be filtered by workername and method name).
238		*
239		* @param string $workerName
240	2	* @param string $methodName
241	2	* @param bool $prioritize
242	2	*
243		* @return Job\|null
244	2	*/
245	1	public function getJob($workerName = null, $methodName = null, $prioritize = true, $runId = null)
246	1	{
247	1	/** @var EntityRepository $repository */
248		$repository = $this->getRepository();
249		$queryBuilder = $repository->createQueryBuilder('j');
250		$dateTime = new \DateTime();
251		$queryBuilder
252		->select('j.id')
253		->where('j.status = :status')->setParameter(':status', BaseJob::STATUS_NEW)
254		->andWhere('j.locked is NULL')
255		->andWhere($queryBuilder->expr()->orX(
256	1	$queryBuilder->expr()->isNull('j.whenAt'),
257		$queryBuilder->expr()->lte('j.whenAt', ':whenAt')
258	2	))
259		->andWhere($queryBuilder->expr()->orX(
260		$queryBuilder->expr()->isNull('j.expiresAt'),
261		$queryBuilder->expr()->gt('j.expiresAt', ':expiresAt')
262		))
263		->setParameter(':whenAt', $dateTime)
264		->setParameter(':expiresAt', $dateTime);
265
266		$this->addWorkerNameCriterion($queryBuilder, $workerName, $methodName);
267
268		if ($prioritize) {
269	6	$queryBuilder->addOrderBy('j.priority', 'DESC');
270		$queryBuilder->addOrderBy('j.whenAt', 'ASC');
271		} else {
272	6	$queryBuilder->orderBy('j.whenAt', 'ASC');
273	6	}
274	6	$queryBuilder->setMaxResults(1);
275
276	6	/** @var QueryBuilder $queryBuilder */
277	6	$query = $queryBuilder->getQuery();
278	6	$jobs = $query->getResult();
279	6
280	6	return $this->takeJob($jobs, $runId);
281	6	}
282
283	6	protected function takeJob($jobs, $runId = null)
284	6	{
285	6	if (isset($jobs[0]['id'])) {
286		/** @var EntityRepository $repository */
287	6	$repository = $this->getRepository();
288	6	/** @var QueryBuilder $queryBuilder */
289		$queryBuilder = $repository->createQueryBuilder('j');
290	6	$queryBuilder
291		->update()
292	6	->set('j.locked', ':locked')
293	6	->setParameter(':locked', true)
294		->set('j.lockedAt', ':lockedAt')
295		->setParameter(':lockedAt', new \DateTime())
296		->set('j.status', ':status')
297	6	->setParameter(':status', BaseJob::STATUS_RUNNING);
298		if (null !== $runId) {
299		$queryBuilder
300	6	->set('j.runId', ':runId')
301	6	->setParameter(':runId', $runId);
302		}
303	6	$queryBuilder->where('j.id = :id');
304		$queryBuilder->andWhere('j.locked is NULL');
305		$queryBuilder->setParameter(':id', $jobs[0]['id']);
306	6	$resultCount = $queryBuilder->getQuery()->execute();
307
308	6	if (1 === $resultCount) {
309	5	return $repository->find($jobs[0]['id']);
310	5	}
311		}
312	5
313	5	return null;
314	5	}
315	5
316	5	/**
317	5	* Tries to update the nearest job as a batch.
318	5	*
319	5	* @param \Dtc\QueueBundle\Model\Job $job
320		*
321		* @return mixed\|null
322		*/
323		public function updateNearestBatch(\Dtc\QueueBundle\Model\Job $job)
324	5	{
325	5	/** @var QueryBuilder $queryBuilder */
326	5	$queryBuilder = $this->getRepository()->createQueryBuilder('j');
327	5	$queryBuilder->select()
328		->where('j.crcHash = :crcHash')
329	5	->andWhere('j.status = :status')
330	5	->setParameter(':status', BaseJob::STATUS_NEW)
331		->setParameter(':crcHash', $job->getCrcHash())
332		->orderBy('j.whenAt', 'ASC')
333		->setMaxResults(1);
334	3	$existingJobs = $queryBuilder->getQuery()->execute();
335
336		if (empty($existingJobs)) {
337		return null;
338		}
339		/** @var Job $existingJob */
340		$existingJob = $existingJobs[0];
341
342		$newPriority = max($job->getPriority(), $existingJob->getPriority());
343		$newWhenAt = min($job->getWhenAt(), $existingJob->getWhenAt());
344	1
345		$this->updateBatchJob($existingJob, $newPriority, $newWhenAt);
346	1
347	1	return $existingJob;
348		}
349
350		protected function updateBatchJob(Job $existingJob, $newPriority, $newWhenAt)
351	1	{
352	1	$existingPriority = $existingJob->getPriority();
353		$existingWhenAt = $existingJob->getWhenAt();
354
355	1	if ($newPriority !== $existingPriority \|\| $newWhenAt !== $existingWhenAt) {
356	1	/** @var EntityRepository $repository */
357	1	$repository = $this->getRepository();
358	1	/** @var QueryBuilder $queryBuilder */
359	1	$queryBuilder = $repository->createQueryBuilder('j');
360	1	$queryBuilder->update();
361	1	if ($newPriority !== $existingPriority) {
362	1	$existingJob->setPriority($newPriority);
363	1	$queryBuilder->set('j.priority', ':priority')
364		->setParameter(':priority', $newPriority);
365	1	}
366		if ($newWhenAt !== $existingWhenAt) {
367		$existingJob->setWhenAt($newWhenAt);
368	1	$queryBuilder->set('j.whenAt', ':whenAt')
369		->setParameter(':whenAt', $newWhenAt);
370	1	}
371	1	$queryBuilder->where('j.id = :id');
372		$queryBuilder->andWhere('j.locked is NULL');
373	1	$queryBuilder->setParameter(':id', $existingJob->getId());
374	1	$queryBuilder->getQuery()->execute();
375	1	}
376
377		return $existingJob;
378		}
379		}
380

mmucklo / DtcQueueBundle

Branch — master (294ea0)

JobManager::updateBatchJob() B

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like