DBALWebsiteLookupService::lookup() - Code Metrics - Inspection of "Merge pull request #345 from cultuurnet/feature/II..." - cultuurnet/udb3-php - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 32b89d...812d0e )

by Luc

created 2018-03-20 12:38 UTC

DBALWebsiteLookupService::lookup() A

↳ Parent: DBALWebsiteLookupService

Complexity

Conditions	2
Paths	2

Size

Total Lines	14
Code Lines	10

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	14
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	10
nc	2
nop	1

<?php

namespace CultuurNet\UDB3\Organizer;

use CultuurNet\UDB3\EventSourcing\DBAL\UniqueDBALEventStoreDecorator;
use Doctrine\DBAL\Connection;
use ValueObjects\Web\Url;

class DBALWebsiteLookupService implements WebsiteLookupServiceInterface
{
    /**
     * @var Connection
     */
    private $connection;

    /**
     * @var string
     */
    private $tableName;

    /**
     * @param Connection $connection
     * @param string $tableName
     */
    public function __construct(
        Connection $connection,
        $tableName
    ) {
        $this->connection = $connection;
        $this->tableName = (string) $tableName;
    }

    /**
     * @inheritdoc
     */
    public function lookup(Url $url)
    {
        $expr = $this->connection->getExpressionBuilder();

        $results = $this->connection->createQueryBuilder()
            ->select(UniqueDBALEventStoreDecorator::UUID_COLUMN)
            ->from($this->tableName)
            ->where($expr->eq(UniqueDBALEventStoreDecorator::UNIQUE_COLUMN, ':url'))
            ->setParameter(':url', (string) $url)
            ->execute();

        $uuid = $results->fetchColumn();
        return $uuid ? $uuid : null;
    }
}


1			<?php
2
3			namespace CultuurNet\UDB3\Organizer;
4
5			use CultuurNet\UDB3\EventSourcing\DBAL\UniqueDBALEventStoreDecorator;
6			use Doctrine\DBAL\Connection;
7			use ValueObjects\Web\Url;
8
9			class DBALWebsiteLookupService implements WebsiteLookupServiceInterface
10			{
11			/**
12			* @var Connection
13			*/
14			private $connection;
15
16			/**
17			* @var string
18			*/
19			private $tableName;
20
21			/**
22			* @param Connection $connection
23			* @param string $tableName
24			*/
25			public function __construct(
26			Connection $connection,
27			$tableName
28			) {
29			$this->connection = $connection;
30			$this->tableName = (string) $tableName;
31			}
32
33			/**
34			* @inheritdoc
35			*/
36			public function lookup(Url $url)
37			{
38			$expr = $this->connection->getExpressionBuilder();
39
40			$results = $this->connection->createQueryBuilder()
41			->select(UniqueDBALEventStoreDecorator::UUID_COLUMN)
42			->from($this->tableName)
43			->where($expr->eq(UniqueDBALEventStoreDecorator::UNIQUE_COLUMN, ':url'))
44			->setParameter(':url', (string) $url)
45			->execute();
46
47			$uuid = $results->fetchColumn();
48			return $uuid ? $uuid : null;
49			}
50			}
51

cultuurnet / udb3-php

Push — master ( 32b89d...812d0e )

DBALWebsiteLookupService::lookup() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like