AbstractRawRepository::findByUid() - Code Metrics - Inspection of "Fix #65 - Migration of the DB abstraction layer" - lochmueller/focuspoint - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( b87c44...b5d8bc )

by Tim

created 2019-02-03 16:02 UTC

AbstractRawRepository::findByUid() A

↳ Parent: AbstractRawRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	12
rs	9.8666
c	0
b	0
f	0
nc	2
cc	2
nop	1

<?php
/**
 * Abstract raw repository
 *
 * @author  Tim Lochmüller
 */

namespace HDNET\Focuspoint\Domain\Repository;

use TYPO3\CMS\Core\Database\ConnectionPool;
use TYPO3\CMS\Core\Utility\GeneralUtility;

/**
 * Abstract raw repository
 */
abstract class AbstractRawRepository
{

    /**
     * Get the tablename
     *
     * @return string
     */
    abstract protected function getTableName(): string;

    /**
     * Find by uid
     *
     * @param int $uid
     * @return array|null
     */
    public function findByUid(int $uid)
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($this->getTableName());
        $rows = $queryBuilder->select('*')
            ->from($this->getTableName())
            ->where(
                $queryBuilder->expr()->eq('uid', $uid)
            )
            ->execute()
            ->fetchAll();
        return isset($rows[0]) ? $rows[0] : null;
    }

    /**
     * Update by uid
     *
     * @param int $uid
     * @param array $values
     */
    public function updateByUid(int $uid, array $values)
    {
        $connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable($this->getTableName());
        $connection->update(
            $this->getTableName(),
            $values,
            ['uid' => (int) $uid]
        );
    }

}


1			<?php
2			/**
3			* Abstract raw repository
4			*
5			* @author Tim Lochmüller
6			*/
7
8			namespace HDNET\Focuspoint\Domain\Repository;
9
10			use TYPO3\CMS\Core\Database\ConnectionPool;
11			use TYPO3\CMS\Core\Utility\GeneralUtility;
12
13			/**
14			* Abstract raw repository
15			*/
16			abstract class AbstractRawRepository
17			{
18
19			/**
20			* Get the tablename
21			*
22			* @return string
23			*/
24			abstract protected function getTableName(): string;
25
26			/**
27			* Find by uid
28			*
29			* @param int $uid
30			* @return array\|null
31			*/
32			public function findByUid(int $uid)
33			{
34			$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($this->getTableName());
35			$rows = $queryBuilder->select('*')
36			->from($this->getTableName())
37			->where(
38			$queryBuilder->expr()->eq('uid', $uid)
39			)
40			->execute()
41			->fetchAll();
42			return isset($rows[0]) ? $rows[0] : null;
43			}
44
45			/**
46			* Update by uid
47			*
48			* @param int $uid
49			* @param array $values
50			*/
51			public function updateByUid(int $uid, array $values)
52			{
53			$connection = GeneralUtility::makeInstance(ConnectionPool::class)->getConnectionForTable($this->getTableName());
54			$connection->update(
55			$this->getTableName(),
56			$values,
57			['uid' => (int) $uid]
58			);
59			}
60
61			}
62

lochmueller / focuspoint

Push — master ( b87c44...b5d8bc )

AbstractRawRepository::findByUid() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like