Map2ResultRepository::fetchBy() - Code Metrics - Inspection of "remove google maps type" - OpencachingDeutschland/oc-server3 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — next ( 01f675...c3ca23 )

by Thomas

created 2018-09-03 20:20 UTC

Map2ResultRepository::fetchBy() A

↳ Parent: Map2ResultRepository

Complexity

Conditions	5
Paths	6

Size

Total Lines

Duplication

Lines	28
Ratio	100 %

Importance

Changes

Metric	Value
cc	5
nc	6
nop	1
dl	28
loc	28
rs	9.1608
c	0
b	0
f	0

<?php

use Doctrine\DBAL\Connection;
use Oc\Repository\Exception\RecordAlreadyExistsException;
use Oc\Repository\Exception\RecordNotFoundException;
use Oc\Repository\Exception\RecordNotPersistedException;
use Oc\Repository\Exception\RecordsNotFoundException;

class Map2ResultRepository

{
    const TABLE = 'map2_result';

    /** @var Connection */
    private $connection;

    public function __construct(Connection $connection)
    {
        $this->connection = $connection;
    }

    /**
     * @return Map2ResultEntity[]
     */
    public function fetchAll()
    {
        $statement = $this->connection->createQueryBuilder()
            ->select('*')
            ->from(self::TABLE)
            ->execute();

        $result = $statement->fetchAll();

        if ($statement->rowCount() === 0) {
            throw new RecordsNotFoundException('No records found');
        }

        $records = [];

        foreach ($result as $item) {
            $records[] = $this->getEntityFromDatabaseArray($item);
        }

        return $records;
    }

    /**
     * @param array $where
     * @return Map2ResultEntity
     */
    public function fetchOneBy(array $where = [])
    {
        $queryBuilder = $this->connection->createQueryBuilder()
            ->select('*')
            ->from(self::TABLE)
            ->setMaxResults(1);

        if (count($where) > 0) {
            foreach ($where as $column => $value) {
                $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value));
            }
        }

        $statement = $queryBuilder->execute();

        $result = $statement->fetch();

        if ($statement->rowCount() === 0) {
            throw new RecordNotFoundException('Record with given where clause not found');
        }

        return $this->getEntityFromDatabaseArray($result);
    }

    /**
     * @param array $where
     * @return Map2ResultEntity[]
     */
    public function fetchBy(array $where = [])
    {
        $queryBuilder = $this->connection->createQueryBuilder()
            ->select('*')
            ->from(self::TABLE);

        if (count($where) > 0) {
            foreach ($where as $column => $value) {
                $queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value));
            }
        }

        $statement = $queryBuilder->execute();

        $result = $statement->fetchAll();

        if ($statement->rowCount() === 0) {
            throw new RecordsNotFoundException('No records with given where clause found');
        }

        $entities = [];

        foreach ($result as $item) {
            $entities[] = $this->getEntityFromDatabaseArray($item);
        }

        return $entities;
    }

    /**
     * @param Map2ResultEntity $entity
     * @return Map2ResultEntity
     */
    public function create(Map2ResultEntity $entity)
    {
        if (!$entity->isNew()) {
            throw new RecordAlreadyExistsException('The entity does already exist.');
        }

        $databaseArray = $this->getDatabaseArrayFromEntity($entity);

        $this->connection->insert(
            self::TABLE,
            $databaseArray
        );

        $entity->resultId = (int) $this->connection->lastInsertId();

        return $entity;
    }

    /**
     * @param Map2ResultEntity $entity
     * @return Map2ResultEntity
     */
    public function update(Map2ResultEntity $entity)
    {
        if ($entity->isNew()) {
            throw new RecordNotPersistedException('The entity does not exist.');
        }

        $databaseArray = $this->getDatabaseArrayFromEntity($entity);

        $this->connection->update(
            self::TABLE,
            $databaseArray,
            ['result_id' => $entity->resultId]
        );

        return $entity;
    }

    /**
     * @param Map2ResultEntity $entity
     * @return Map2ResultEntity
     */
    public function remove(Map2ResultEntity $entity)
    {
        if ($entity->isNew()) {
            throw new RecordNotPersistedException('The entity does not exist.');
        }

        $this->connection->delete(
            self::TABLE,
            ['result_id' => $entity->resultId]
        );

        $entity->cacheId = null;


        return $entity;
    }

    /**
     * @param Map2ResultEntity $entity
     * @return []

     */
    public function getDatabaseArrayFromEntity(Map2ResultEntity $entity)
    {
        return [
            'result_id' => $entity->resultId,
            'slave_id' => $entity->slaveId,
            'sqlchecksum' => $entity->sqlchecksum,
            'sqlquery' => $entity->sqlquery,
            'shared_counter' => $entity->sharedCounter,
            'request_counter' => $entity->requestCounter,
            'date_created' => $entity->dateCreated,
            'date_lastqueried' => $entity->dateLastqueried,
        ];
    }

    /**
     * @param array $data
     * @return Map2ResultEntity
     */
    public function getEntityFromDatabaseArray(array $data)
    {
        $entity = new Map2ResultEntity();
        $entity->resultId = (int) $data['result_id'];
        $entity->slaveId = (int) $data['slave_id'];
        $entity->sqlchecksum = (int) $data['sqlchecksum'];
        $entity->sqlquery = (string) $data['sqlquery'];
        $entity->sharedCounter = (int) $data['shared_counter'];
        $entity->requestCounter = (int) $data['request_counter'];
        $entity->dateCreated = new DateTime($data['date_created']);
        $entity->dateLastqueried = new DateTime($data['date_lastqueried']);

        return $entity;
    }
}


1		<?php
2
3		use Doctrine\DBAL\Connection;
4		use Oc\Repository\Exception\RecordAlreadyExistsException;
5		use Oc\Repository\Exception\RecordNotFoundException;
6		use Oc\Repository\Exception\RecordNotPersistedException;
7		use Oc\Repository\Exception\RecordsNotFoundException;
8
9	View Code Duplication	class Map2ResultRepository
		0 ignored issues – show Duplication introduced 2018-08-10 14:46 UTC by Report Bug Copy Issue Report This class 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...
10		{
11		const TABLE = 'map2_result';
12
13		/** @var Connection */
14		private $connection;
15
16		public function __construct(Connection $connection)
17		{
18		$this->connection = $connection;
19		}
20
21		/**
22		* @return Map2ResultEntity[]
23		*/
24		public function fetchAll()
25		{
26		$statement = $this->connection->createQueryBuilder()
27		->select('*')
28		->from(self::TABLE)
29		->execute();
30
31		$result = $statement->fetchAll();
32
33		if ($statement->rowCount() === 0) {
34		throw new RecordsNotFoundException('No records found');
35		}
36
37		$records = [];
38
39		foreach ($result as $item) {
40		$records[] = $this->getEntityFromDatabaseArray($item);
41		}
42
43		return $records;
44		}
45
46		/**
47		* @param array $where
48		* @return Map2ResultEntity
49		*/
50		public function fetchOneBy(array $where = [])
51		{
52		$queryBuilder = $this->connection->createQueryBuilder()
53		->select('*')
54		->from(self::TABLE)
55		->setMaxResults(1);
56
57		if (count($where) > 0) {
58		foreach ($where as $column => $value) {
59		$queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value));
60		}
61		}
62
63		$statement = $queryBuilder->execute();
64
65		$result = $statement->fetch();
66
67		if ($statement->rowCount() === 0) {
68		throw new RecordNotFoundException('Record with given where clause not found');
69		}
70
71		return $this->getEntityFromDatabaseArray($result);
72		}
73
74		/**
75		* @param array $where
76		* @return Map2ResultEntity[]
77		*/
78		public function fetchBy(array $where = [])
79		{
80		$queryBuilder = $this->connection->createQueryBuilder()
81		->select('*')
82		->from(self::TABLE);
83
84		if (count($where) > 0) {
85		foreach ($where as $column => $value) {
86		$queryBuilder->andWhere($column . ' = ' . $queryBuilder->createNamedParameter($value));
87		}
88		}
89
90		$statement = $queryBuilder->execute();
91
92		$result = $statement->fetchAll();
93
94		if ($statement->rowCount() === 0) {
95		throw new RecordsNotFoundException('No records with given where clause found');
96		}
97
98		$entities = [];
99
100		foreach ($result as $item) {
101		$entities[] = $this->getEntityFromDatabaseArray($item);
102		}
103
104		return $entities;
105		}
106
107		/**
108		* @param Map2ResultEntity $entity
109		* @return Map2ResultEntity
110		*/
111		public function create(Map2ResultEntity $entity)
112		{
113		if (!$entity->isNew()) {
114		throw new RecordAlreadyExistsException('The entity does already exist.');
115		}
116
117		$databaseArray = $this->getDatabaseArrayFromEntity($entity);
118
119		$this->connection->insert(
120		self::TABLE,
121		$databaseArray
122		);
123
124		$entity->resultId = (int) $this->connection->lastInsertId();
125
126		return $entity;
127		}
128
129		/**
130		* @param Map2ResultEntity $entity
131		* @return Map2ResultEntity
132		*/
133		public function update(Map2ResultEntity $entity)
134		{
135		if ($entity->isNew()) {
136		throw new RecordNotPersistedException('The entity does not exist.');
137		}
138
139		$databaseArray = $this->getDatabaseArrayFromEntity($entity);
140
141		$this->connection->update(
142		self::TABLE,
143		$databaseArray,
144		['result_id' => $entity->resultId]
145		);
146
147		return $entity;
148		}
149
150		/**
151		* @param Map2ResultEntity $entity
152		* @return Map2ResultEntity
153		*/
154		public function remove(Map2ResultEntity $entity)
155		{
156		if ($entity->isNew()) {
157		throw new RecordNotPersistedException('The entity does not exist.');
158		}
159
160		$this->connection->delete(
161		self::TABLE,
162		['result_id' => $entity->resultId]
163		);
164
165		$entity->cacheId = null;
		0 ignored issues – show Bug introduced 2018-08-10 14:46 UTC by Report Bug Copy Issue Report The property `cacheId` does not seem to exist in `Map2ResultEntity`. An attempt at access to an undefined property has been detected. This may either be a typographical error or the property has been renamed but there are still references to its old name. If you really want to allow access to undefined properties, you can define magic methods to allow access. See the php core documentation on Overloading. Loading history...
166
167		return $entity;
168		}
169
170		/**
171		* @param Map2ResultEntity $entity
172		* @return []
		0 ignored issues – show Documentation introduced 2018-08-10 14:46 UTC by Report Bug Copy Issue Report The doc-type `[]` could not be parsed: Unknown type name "" at position 0. [(view supported doc-types) This check marks PHPDoc comments that could not be parsed by our parser. To see which comment annotations we can parse, please refer to our documentation on supported doc-types. Loading history...
173		*/
174		public function getDatabaseArrayFromEntity(Map2ResultEntity $entity)
175		{
176		return [
177		'result_id' => $entity->resultId,
178		'slave_id' => $entity->slaveId,
179		'sqlchecksum' => $entity->sqlchecksum,
180		'sqlquery' => $entity->sqlquery,
181		'shared_counter' => $entity->sharedCounter,
182		'request_counter' => $entity->requestCounter,
183		'date_created' => $entity->dateCreated,
184		'date_lastqueried' => $entity->dateLastqueried,
185		];
186		}
187
188		/**
189		* @param array $data
190		* @return Map2ResultEntity
191		*/
192		public function getEntityFromDatabaseArray(array $data)
193		{
194		$entity = new Map2ResultEntity();
195		$entity->resultId = (int) $data['result_id'];
196		$entity->slaveId = (int) $data['slave_id'];
197		$entity->sqlchecksum = (int) $data['sqlchecksum'];
198		$entity->sqlquery = (string) $data['sqlquery'];
199		$entity->sharedCounter = (int) $data['shared_counter'];
200		$entity->requestCounter = (int) $data['request_counter'];
201		$entity->dateCreated = new DateTime($data['date_created']);
202		$entity->dateLastqueried = new DateTime($data['date_lastqueried']);
203
204		return $entity;
205		}
206		}
207

OpencachingDeutschland / oc-server3

Push — next ( 01f675...c3ca23 )

Map2ResultRepository::fetchBy() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like