DatabasePostRepository::byCategory() - Code Metrics - Inspection of "More initial things" - Albert221/blog - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( eaa10a...12d04d )

by Albert

created 2016-05-22 15:36 UTC

DatabasePostRepository::byCategory() A

↳ Parent: DatabasePostRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	15
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

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

<?php

namespace Albert221\Blog\Repository;

use Doctrine\ORM\EntityRepository;

class DatabasePostRepository extends EntityRepository implements PostRepositoryInterface
{
    public function count()
    {
        $query = $this->createQueryBuilder('p')
            ->select('count(p.id)')
            ->getQuery();

        return $query->getSingleScalarResult();
    }
    
    public function paginated($page, $perPage)
    {
        $first = ($page - 1) * $perPage;

        $query = $this->createQueryBuilder('p')
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        return $query->getResult();
    }

    public function bySlug($slug)
    {
        return $this->findOneBy(['slug' => $slug]);
    }

    public function byCategory($category, $page, $perPage)
    {
        $first = ($page - 1) * $perPage;
        
        $qb = $this->createQueryBuilder('p');

        $query = $qb->join('p.category', 'c')
            ->where($qb->expr()->eq('c.slug', ':category'))
            ->setParameter(':category', $category)
            ->setFirstResult($first)
            ->setMaxResults($perPage)
            ->getQuery();

        return $query->getResult();
    }
}


1			<?php
2
3			namespace Albert221\Blog\Repository;
4
5			use Doctrine\ORM\EntityRepository;
6
7			class DatabasePostRepository extends EntityRepository implements PostRepositoryInterface
8			{
9			public function count()
10			{
11			$query = $this->createQueryBuilder('p')
12			->select('count(p.id)')
13			->getQuery();
14
15			return $query->getSingleScalarResult();
16			}
17
18			public function paginated($page, $perPage)
19			{
20			$first = ($page - 1) * $perPage;
21
22			$query = $this->createQueryBuilder('p')
23			->setFirstResult($first)
24			->setMaxResults($perPage)
25			->getQuery();
26
27			return $query->getResult();
28			}
29
30			public function bySlug($slug)
31			{
32			return $this->findOneBy(['slug' => $slug]);
33			}
34
35			public function byCategory($category, $page, $perPage)
36			{
37			$first = ($page - 1) * $perPage;
38
39			$qb = $this->createQueryBuilder('p');
40
41			$query = $qb->join('p.category', 'c')
42			->where($qb->expr()->eq('c.slug', ':category'))
43			->setParameter(':category', $category)
44			->setFirstResult($first)
45			->setMaxResults($perPage)
46			->getQuery();
47
48			return $query->getResult();
49			}
50			}
51

Albert221 / blog

Push — master ( eaa10a...12d04d )

DatabasePostRepository::byCategory() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like