Acme\App\Core\Component\User\Application\Repository\DQL\UserRepository

Complexity

Total Complexity

15

Size/Duplication

Total Lines	137
Duplicated Lines	62.04 %

Coupling/Cohesion

Components	2
Dependencies	4

Importance

Changes

0

9 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	9	1
A	add()	0	4	1
A	remove()	0	4	1
A	findAll()	14	14	3
A	findOneByUsername()	9	9	1
A	findOneByEmail()	9	9	1
A	findOneById()	9	9	1
A	findAllByCommentId()	22	22	3
A	findAllByPostId()	22	22	3

<?php

declare(strict_types=1);

/*
 * This file is part of the Explicit Architecture POC,
 * which is created on top of the Symfony Demo application.
 *
 * (c) Herberto Graça <herberto.graca@gmail.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

namespace Acme\App\Core\Component\User\Application\Repository\DQL;

use Acme\App\Core\Component\Blog\Domain\Post\Comment\Comment;
use Acme\App\Core\Component\Blog\Domain\Post\Post;
use Acme\App\Core\Component\Blog\Domain\Post\PostId;
use Acme\App\Core\Component\User\Application\Repository\UserRepositoryInterface;
use Acme\App\Core\Component\User\Domain\User\User;
use Acme\App\Core\Port\Persistence\DQL\DqlQueryBuilderInterface;
use Acme\App\Core\Port\Persistence\PersistenceServiceInterface;
use Acme\App\Core\Port\Persistence\QueryServiceRouterInterface;
use Acme\App\Core\Port\Persistence\ResultCollectionInterface;
use Acme\App\Core\SharedKernel\Component\Blog\Domain\Post\Comment\CommentId;
use Acme\App\Core\SharedKernel\Component\User\Domain\User\UserId;
use Doctrine\ORM\Query\Expr\Join;

/**
 * This custom Doctrine repository is empty because so far we don't need any custom
 * method to query for application user information. But it's always a good practice
 * to define a custom repository that will be used when the application grows.
 *
 * See https://symfony.com/doc/current/doctrine/repository.html
 *
 * @author Ryan Weaver <weaverryan@gmail.com>
 * @author Javier Eguiluz <javier.eguiluz@gmail.com>
 * @author Herberto Graca <herberto.graca@gmail.com>
 */
class UserRepository implements UserRepositoryInterface
{
    /**
     * @var DqlQueryBuilderInterface
     */
    private $dqlQueryBuilder;

    /**
     * @var QueryServiceRouterInterface
     */
    private $queryService;

    /**
     * @var PersistenceServiceInterface
     */
    private $persistenceService;

    public function __construct(
        DqlQueryBuilderInterface $dqlQueryBuilder,
        QueryServiceRouterInterface $queryService,
        PersistenceServiceInterface $persistenceService
    ) {
        $this->dqlQueryBuilder = $dqlQueryBuilder;
        $this->queryService = $queryService;
        $this->persistenceService = $persistenceService;
    }

    public function add(User $user): void
    {
        $this->persistenceService->upsert($user);
    }

    public function remove(User $user): void
    {
        $this->persistenceService->delete($user);
    }

    /**
     * @return User[]
     */
    public function findAll(array $orderByList = ['id' => 'DESC'], int $maxResults = null): ResultCollectionInterface

This method seems to be duplicated in your project.

    {
        $this->dqlQueryBuilder->create(User::class);

        foreach ($orderByList as $property => $direction) {
            $this->dqlQueryBuilder->orderBy('User.' . $property, $direction);
        }

        if ($maxResults) {

The expression $maxResults of type null|integer is loosely compared to true; this is ambiguous if the integer can be zero. You might want to explicitly use !== null instead.

            $this->dqlQueryBuilder->setMaxResults($maxResults);
        }

        return $this->queryService->query($this->dqlQueryBuilder->build());
    }

    public function findOneByUsername(string $username): User

This method seems to be duplicated in your project.

    {
        $dqlQuery = $this->dqlQueryBuilder->create(User::class)
            ->where('User.username = :username')
            ->setParameter('username', $username)
            ->build();

        return $this->queryService->query($dqlQuery)->getSingleResult();
    }

    public function findOneByEmail(string $email): User

This method seems to be duplicated in your project.

    {
        $dqlQuery = $this->dqlQueryBuilder->create(User::class)
            ->where('User.email = :email')
            ->setParameter('email', $email)
            ->build();

        return $this->queryService->query($dqlQuery)->getSingleResult();
    }

    public function findOneById(UserId $id): User

This method seems to be duplicated in your project.

    {
        $dqlQuery = $this->dqlQueryBuilder->create(User::class)
            ->where('User.id = :id')
            ->setParameter('id', $id)
            ->build();

        return $this->queryService->query($dqlQuery)->getSingleResult();
    }

    /**
     * @return User[]
     */
    public function findAllByCommentId(

This method seems to be duplicated in your project.

        CommentId $commentId,
        array $orderByList = ['id' => 'DESC'],
        int $maxResults = null
    ): ResultCollectionInterface {

        $this->dqlQueryBuilder->create(User::class);

        $this->dqlQueryBuilder->innerJoin(Comment::class, 'Comment', Join::WITH, 'Comment.authorId = User.id')
            ->where('Comment.id = :comment')
            ->setParameter('comment', $commentId);

        foreach ($orderByList as $property => $direction) {
            $this->dqlQueryBuilder->orderBy('User.' . $property, $direction);
        }

        if ($maxResults) {

The expression $maxResults of type null|integer is loosely compared to true; this is ambiguous if the integer can be zero. You might want to explicitly use !== null instead.

            $this->dqlQueryBuilder->setMaxResults($maxResults);
        }

        return $this->queryService->query($this->dqlQueryBuilder->build());
    }

    /**
     * @return User[]
     */
    public function findAllByPostId(

This method seems to be duplicated in your project.

        PostId $postId,
        array $orderByList = ['id' => 'DESC'],
        int $maxResults = null
    ): ResultCollectionInterface {

        $this->dqlQueryBuilder->create(User::class);

        $this->dqlQueryBuilder->innerJoin(Post::class, 'Post', Join::WITH, 'Post.authorId = User.id')
            ->where('Post.id = :post')
            ->setParameter('post', $postId);

        foreach ($orderByList as $property => $direction) {
            $this->dqlQueryBuilder->orderBy('User.' . $property, $direction);
        }

        if ($maxResults) {

The expression $maxResults of type null|integer is loosely compared to true; this is ambiguous if the integer can be zero. You might want to explicitly use !== null instead.

            $this->dqlQueryBuilder->setMaxResults($maxResults);
        }

        return $this->queryService->query($this->dqlQueryBuilder->build());
    }
}