EmailUserRepository

Complexity

Total Complexity

21

Size/Duplication

Total Lines	196
Duplicated Lines	100 %

Coupling/Cohesion

Components	1
Dependencies	7

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	4	4	1
A	fetchAll()	21	21	3
A	fetchOneBy()	23	23	4
A	fetchBy()	28	28	5
A	create()	17	17	2
A	update()	16	16	2
A	remove()	15	15	2
A	getDatabaseArrayFromEntity()	12	12	1
A	getEntityFromDatabaseArray()	13	13	1

<?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 EmailUserRepository

This class seems to be duplicated in your project.

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    const TABLE = 'email_user';

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

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

    /**
     * @return EmailUserEntity[]
     */
    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 EmailUserEntity
     */
    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 EmailUserEntity[]
     */
    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 EmailUserEntity $entity
     * @return EmailUserEntity
     */
    public function create(EmailUserEntity $entity)
    {
        if (!$entity->isNew()) {
            throw new RecordAlreadyExistsException('The entity does already exist.');
        }

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

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

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

        return $entity;
    }

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

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

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

        return $entity;
    }

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

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

        $entity->cacheId = null;

The property cacheId does not seem to exist in EmailUserEntity.

        return $entity;
    }

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

The doc-type [] could not be parsed: Unknown type name "" at position 0. [(view supported doc-types)

     */
    public function getDatabaseArrayFromEntity(EmailUserEntity $entity)
    {
        return [
        'id' => $entity->id,
        'date_created' => $entity->dateCreated,
        'ipaddress' => $entity->ipaddress,
        'from_user_id' => $entity->fromUserId,
        'from_email' => $entity->fromEmail,
        'to_user_id' => $entity->toUserId,
        'to_email' => $entity->toEmail,
        ];
    }

    /**
     * @param array $data
     * @return EmailUserEntity
     */
    public function getEntityFromDatabaseArray(array $data)
    {
        $entity = new EmailUserEntity();
        $entity->id = $data['id'];
        $entity->dateCreated = $data['date_created'];
        $entity->ipaddress = $data['ipaddress'];
        $entity->fromUserId = $data['from_user_id'];
        $entity->fromEmail = $data['from_email'];
        $entity->toUserId = $data['to_user_id'];
        $entity->toEmail = $data['to_email'];

        return $entity;
    }
}