ImageRepository::getFilenames() - Code Metrics - Inspection of "Favorize use of fragment for typing" - Ecodev/artisans - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( a8b983...5b3176 )

by Adrien

created 2020-08-25 07:27 UTC

ImageRepository::getFilenames() A

↳ Parent: ImageRepository

Complexity

Conditions	1
Paths	1

Size

Total Lines	9
Code Lines	6

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

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

<?php

declare(strict_types=1);

namespace Application\Repository;

use PDO;

class ImageRepository extends AbstractRepository
{
    /**
     * Returns all unique filename in DB
     *
     * @return string[]
     */
    public function getFilenames(): array
    {
        $filenames = $this->getEntityManager()->getConnection()->createQueryBuilder()
            ->from('image')
            ->select('DISTINCT CONCAT("data/images/", filename)')
            ->where('filename != ""')
            ->orderBy('filename')->execute()->fetchAll(PDO::FETCH_COLUMN);

        return $filenames;
    }

    /**
     * Returns all filename in DB and their id and sizes
     *
     * @return string[]
     */
    public function getFilenamesForDimensionUpdate(): array
    {
        $filenames = $this->getEntityManager()->getConnection()->createQueryBuilder()
            ->from('image')
            ->addSelect('id')
            ->addSelect('width')
            ->addSelect('height')
            ->addSelect('CONCAT("data/images/", filename) AS filename')
            ->where('filename != ""')
            ->orderBy('filename')->execute()->fetchAll();

        return $filenames;
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Application\Repository;
6
7			use PDO;
8
9			class ImageRepository extends AbstractRepository
10			{
11			/**
12			* Returns all unique filename in DB
13			*
14			* @return string[]
15			*/
16			public function getFilenames(): array
17			{
18			$filenames = $this->getEntityManager()->getConnection()->createQueryBuilder()
19			->from('image')
20			->select('DISTINCT CONCAT("data/images/", filename)')
21			->where('filename != ""')
22			->orderBy('filename')->execute()->fetchAll(PDO::FETCH_COLUMN);
23
24			return $filenames;
25			}
26
27			/**
28			* Returns all filename in DB and their id and sizes
29			*
30			* @return string[]
31			*/
32			public function getFilenamesForDimensionUpdate(): array
33			{
34			$filenames = $this->getEntityManager()->getConnection()->createQueryBuilder()
35			->from('image')
36			->addSelect('id')
37			->addSelect('width')
38			->addSelect('height')
39			->addSelect('CONCAT("data/images/", filename) AS filename')
40			->where('filename != ""')
41			->orderBy('filename')->execute()->fetchAll();
42
43			return $filenames;
44			}
45			}
46

Ecodev / artisans

Push — master ( a8b983...5b3176 )

ImageRepository::getFilenames() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like