SysFileMetadataRepository::findByFileUid() - 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

SysFileMetadataRepository::findByFileUid() A

↳ Parent: SysFileMetadataRepository

Complexity

Conditions	2
Paths	2

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	13
rs	9.8333
c	0
b	0
f	0
nc	2
cc	2
nop	1

<?php

/**
 * SysFileMetadata
 *
 */

namespace HDNET\Focuspoint\Domain\Repository;

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

/**
 *  SysFileMetadata
 */
class SysFileMetadataRepository extends AbstractRawRepository
{

    /**
     * Get the tablename
     *
     * @return string
     */
    protected function getTableName(): string
    {
        return 'sys_file_metadata';
    }

    /**
     * Find by file
     *
     * @param int $fileUid
     * @return array|null
     */
    public function findByFileUid(int $fileUid)
    {
        $queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($this->getTableName());
        $rows = $queryBuilder->select('*')
            ->from($this->getTableName())
            ->where(
                $queryBuilder->expr()->eq('file', $fileUid)
            )
            ->execute()
            ->fetchAll();

        return isset($rows[0]) ? $rows[0] : null;
    }
}


1			<?php
2
3			/**
4			* SysFileMetadata
5			*
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			* SysFileMetadata
15			*/
16			class SysFileMetadataRepository extends AbstractRawRepository
17			{
18
19			/**
20			* Get the tablename
21			*
22			* @return string
23			*/
24			protected function getTableName(): string
25			{
26			return 'sys_file_metadata';
27			}
28
29			/**
30			* Find by file
31			*
32			* @param int $fileUid
33			* @return array\|null
34			*/
35			public function findByFileUid(int $fileUid)
36			{
37			$queryBuilder = GeneralUtility::makeInstance(ConnectionPool::class)->getQueryBuilderForTable($this->getTableName());
38			$rows = $queryBuilder->select('*')
39			->from($this->getTableName())
40			->where(
41			$queryBuilder->expr()->eq('file', $fileUid)
42			)
43			->execute()
44			->fetchAll();
45
46			return isset($rows[0]) ? $rows[0] : null;
47			}
48			}
49

lochmueller / focuspoint

Push — master ( b87c44...b5d8bc )

SysFileMetadataRepository::findByFileUid() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like