Oc\Page\BlockRepository

Complexity

Total Complexity

12

Size/Duplication

Total Lines	129
Duplicated Lines	28.68 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
B	fetchBy()	5	28	5
A	create()	0	13	2
A	update()	16	16	2
A	remove()	16	16	2

<?php

namespace Oc\Page;

use Doctrine\DBAL\Connection;
use InvalidArgumentException;

/**
 * Class BlockRepository
 *
 * @package Oc\Page
 * @author Nick Lubisch <oc@nicklubisch.de>
 */
class BlockRepository
{
    /**
     * Database table name that this repository maintains.
     *
     * @var string
     */
    const TABLE = 'page_block';

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

    /**
     * BlockRepository constructor.
     *
     * @param Connection $connection
     */
    public function __construct(Connection $connection)
    {
        $this->connection = $connection;
    }

    /**
     * Fetches all blocks of a page.
     *
     * @param array $where
     *
     * @return BlockEntity[]
     */
    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 ($result === false) {
            return [];
        }

        $blocks = [];

        foreach ($result as $item) {
            $blocks[] = (new BlockEntity())->fromDatabaseArray($item);
        }

        return $blocks;
    }

    /**
     * Creates a block in the database.
     *
     * @param BlockEntity $entity
     *
     * @return BlockEntity
     */
    public function create(BlockEntity $entity)
    {
        if (!$entity->isNew()) {
            throw new InvalidArgumentException('The entity does already exist.');
        }

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

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

    /**
     * Update a page in the database.
     *
     * @param BlockEntity $entity
     *
     * @return BlockEntity
     */
    public function update(BlockEntity $entity)

This method seems to be duplicated in your project.

    {
        if ($entity->isNew()) {
            throw new \InvalidArgumentException('The entity does not exist.');
        }

        $this->connection->update(
            self::TABLE,
            $entity->toDatabaseArray(),
            ['id' => $entity->id]
        );

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

        return $entity;
    }

    /**
     * Removes a page from the database.
     *
     * @param BlockEntity $entity
     *
     * @return BlockEntity
     */
    public function remove(BlockEntity $entity)

This method seems to be duplicated in your project.

    {
        if ($entity->isNew()) {
            throw new \InvalidArgumentException('The entity does not exist.');
        }

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

        $entity->id = null;

        return $entity;
    }
}