TaskExecutionRepository::findByTask() - Code Metrics - Inspection of "Added locking mechanism (#39)" - php-task/TaskBundle - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 454108...fbd2bc )

by Alexander

created 2017-05-18 07:57 UTC

TaskExecutionRepository::findByTask() A

↳ Parent: TaskExecutionRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	4
Code Lines	2

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	2
CRAP Score	1

Importance

Changes	1
Bugs	0	Features	1

Metric	Value
c	1
b	0
f	1
dl	0
loc	4
ccs	2
cts	2
cp	1
rs	10
cc	1
eloc	2
nc	1
nop	1
crap	1

<?php

/*
 * This file is part of php-task library.
 *
 * (c) php-task
 *
 * This source file is subject to the MIT license that is bundled
 * with this source code in the file LICENSE.
 */

namespace Task\TaskBundle\Entity;

use Doctrine\ORM\EntityRepository;
use Doctrine\ORM\NoResultException;
use Task\Execution\TaskExecutionInterface;
use Task\Storage\TaskExecutionRepositoryInterface;
use Task\TaskInterface;
use Task\TaskStatus;

/**
 * Repository for task-execution.
 */
class TaskExecutionRepository extends EntityRepository implements TaskExecutionRepositoryInterface
{
    /**
     * {@inheritdoc}
     */
    public function create(TaskInterface $task, \DateTime $scheduleTime)
    {
        return new TaskExecution($task, $task->getHandlerClass(), $scheduleTime, $task->getWorkload());
    }

    /**
     * {@inheritdoc}
     */
    public function save(TaskExecutionInterface $execution)
    {
        $this->_em->persist($execution);
        $this->_em->flush($execution);

        return $this;
    }

    /**
     * {@inheritdoc}
     */
    public function remove(TaskExecutionInterface $execution)
    {
        $this->_em->remove($execution);
        $this->_em->flush($execution);

        return $this;
    }

    /**
     * {@inheritdoc}
     */
    public function findAll($page = 1, $pageSize = null)

    {
        $query = $this->createQueryBuilder('e')
            ->innerJoin('e.task', 't')
            ->getQuery();

        if ($pageSize) {
0   == false // true
0   == null  // true
123 == false // false
123 == null  // false

// It is often better to use strict comparison
0 === false // false
0 === null  // false
            $query->setMaxResults($pageSize);
            $query->setFirstResult(($page - 1) * $pageSize);
        }

        return $query->getResult();
    }

    /**
     * {@inheritdoc}
     */
    public function findPending(TaskInterface $task)
    {
        try {
            return $this->createQueryBuilder('e')
                ->innerJoin('e.task', 't')
                ->where('t.uuid = :uuid')
                ->andWhere('e.status in (:status)')
                ->setParameter('uuid', $task->getUuid())
                ->setParameter('status', [TaskStatus::PLANNED, TaskStatus::RUNNING])
                ->getQuery()
                ->getSingleResult();
        } catch (NoResultException $e) {
            return;
        }
    }

    /**
     * {@inheritdoc}
     */
    public function findByUuid($uuid)
    {
        try {
            return $this->createQueryBuilder('e')
                ->where('e.uuid = :uuid')
                ->setParameter('uuid', $uuid)
                ->getQuery()
                ->getSingleResult();
        } catch (NoResultException $e) {
            return;
        }
    }

    /**
     * {@inheritdoc}
     */
    public function findByTask(TaskInterface $task)
    {
        return $this->findByTaskUuid($task->getUuid());
    }

    /**
     * {@inheritdoc}
     */
    public function findByTaskUuid($taskUuid)
    {
        return $this->createQueryBuilder('e')
            ->innerJoin('e.task', 't')
            ->where('t.uuid = :uuid')
            ->setParameter('uuid', $taskUuid)
            ->getQuery()
            ->getResult();
    }

    /**
     * {@inheritdoc}
     */
    public function findNextScheduled(\DateTime $dateTime = null, array $skippedExecutions = [])
    {
        $queryBuilder = $this->createQueryBuilder('e')
            ->innerJoin('e.task', 't')
            ->where('e.status = :status')
            ->andWhere('e.scheduleTime < :date')
            ->setParameter('date', $dateTime ?: new \DateTime())
            ->setParameter('status', TaskStatus::PLANNED)
            ->setMaxResults(1);

        $expr = $queryBuilder->expr();
        if (!empty($skippedExecutions)) {
            $queryBuilder->andWhere($expr->not($expr->in('e.uuid', ':skipped')))
                ->setParameter('skipped', $skippedExecutions);
        }

        try {
            return $queryBuilder->getQuery()->getSingleResult();
        } catch (NoResultException $exception) {
            return null;
        }
    }
}


1			<?php
2
3			/*
4			* This file is part of php-task library.
5			*
6			* (c) php-task
7			*
8			* This source file is subject to the MIT license that is bundled
9			* with this source code in the file LICENSE.
10			*/
11
12			namespace Task\TaskBundle\Entity;
13
14			use Doctrine\ORM\EntityRepository;
15			use Doctrine\ORM\NoResultException;
16			use Task\Execution\TaskExecutionInterface;
17			use Task\Storage\TaskExecutionRepositoryInterface;
18			use Task\TaskInterface;
19			use Task\TaskStatus;
20
21			/**
22			* Repository for task-execution.
23			*/
24			class TaskExecutionRepository extends EntityRepository implements TaskExecutionRepositoryInterface
25			{
26			/**
27			* {@inheritdoc}
28			*/
29	10		public function create(TaskInterface $task, \DateTime $scheduleTime)
30			{
31	10		return new TaskExecution($task, $task->getHandlerClass(), $scheduleTime, $task->getWorkload());
32			}
33
34			/**
35			* {@inheritdoc}
36			*/
37	21		public function save(TaskExecutionInterface $execution)
38			{
39	21		$this->_em->persist($execution);
40	21		$this->_em->flush($execution);
41
42	21		return $this;
43			}
44
45			/**
46			* {@inheritdoc}
47			*/
48	1		public function remove(TaskExecutionInterface $execution)
49			{
50	1		$this->_em->remove($execution);
51	1		$this->_em->flush($execution);
52
53	1		return $this;
54			}
55
56			/**
57			* {@inheritdoc}
58			*/
59	8	View Code Duplication	public function findAll($page = 1, $pageSize = null)
			0 ignored issues – show Duplication introduced 2016-10-09 08:47 UTC by Report Bug Copy Issue Report This method seems to be duplicated in your project. Duplicated code is one of the most pungent code smells. If you need to duplicate the same code in three or more different places, we strongly encourage you to look into extracting the code into a single class or operation. You can also find more detailed suggestions in the “Code” section of your repository. Loading history...
60			{
61	8		$query = $this->createQueryBuilder('e')
62	8		->innerJoin('e.task', 't')
63	8		->getQuery();
64
65	8		if ($pageSize) {
			0 ignored issues – show Bug Best Practice introduced 2016-10-10 18:11 UTC by Report Bug Copy Issue Report The expression `$pageSize` of type `integer\|null` is loosely compared to `true`; this is ambiguous if the integer can be zero. You might want to explicitly use `!== null` instead. In PHP, under loose comparison (like `==`, or `!=`, or `switch` conditions), values of different types might be equal. For `integer` values, zero is a special case, in particular the following results might be unexpected: 0 == false // true 0 == null // true 123 == false // false 123 == null // false // It is often better to use strict comparison 0 === false // false 0 === null // false Loading history...
66	4		$query->setMaxResults($pageSize);
67	4		$query->setFirstResult(($page - 1) * $pageSize);
68	4		}
69
70	8		return $query->getResult();
71			}
72
73			/**
74			* {@inheritdoc}
75			*/
76	9		public function findPending(TaskInterface $task)
77			{
78			try {
79	9		return $this->createQueryBuilder('e')
80	9		->innerJoin('e.task', 't')
81	9		->where('t.uuid = :uuid')
82	9		->andWhere('e.status in (:status)')
83	9		->setParameter('uuid', $task->getUuid())
84	9		->setParameter('status', [TaskStatus::PLANNED, TaskStatus::RUNNING])
85	9		->getQuery()
86	9		->getSingleResult();
87	9		} catch (NoResultException $e) {
88	9		return;
89			}
90			}
91
92			/**
93			* {@inheritdoc}
94			*/
95	5		public function findByUuid($uuid)
96			{
97			try {
98	5		return $this->createQueryBuilder('e')
99	5		->where('e.uuid = :uuid')
100	5		->setParameter('uuid', $uuid)
101	5		->getQuery()
102	5		->getSingleResult();
103	1		} catch (NoResultException $e) {
104	1		return;
105			}
106			}
107
108			/**
109			* {@inheritdoc}
110			*/
111	4		public function findByTask(TaskInterface $task)
112			{
113	4		return $this->findByTaskUuid($task->getUuid());
114			}
115
116			/**
117			* {@inheritdoc}
118			*/
119	5		public function findByTaskUuid($taskUuid)
120			{
121	5		return $this->createQueryBuilder('e')
122	5		->innerJoin('e.task', 't')
123	5		->where('t.uuid = :uuid')
124	5		->setParameter('uuid', $taskUuid)
125	5		->getQuery()
126	5		->getResult();
127			}
128
129			/**
130			* {@inheritdoc}
131			*/
132	5		public function findNextScheduled(\DateTime $dateTime = null, array $skippedExecutions = [])
133			{
134	5		$queryBuilder = $this->createQueryBuilder('e')
135	5		->innerJoin('e.task', 't')
136	5		->where('e.status = :status')
137	5		->andWhere('e.scheduleTime < :date')
138	5		->setParameter('date', $dateTime ?: new \DateTime())
139	5		->setParameter('status', TaskStatus::PLANNED)
140	5		->setMaxResults(1);
141
142	5		$expr = $queryBuilder->expr();
143	5		if (!empty($skippedExecutions)) {
144			$queryBuilder->andWhere($expr->not($expr->in('e.uuid', ':skipped')))
145			->setParameter('skipped', $skippedExecutions);
146			}
147
148			try {
149	5		return $queryBuilder->getQuery()->getSingleResult();
150	4		} catch (NoResultException $exception) {
151	4		return null;
152			}
153			}
154			}
155

php-task / TaskBundle

Push — master ( 454108...fbd2bc )

TaskExecutionRepository::findByTask() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like