<?php

/*
 * This file is part of the Maestro Project.
 * Copyright (C) Compos Juliot
 */

namespace App\Infrastructure\Repository\Authorization;

use App\Domain\Adapter\ProfileRepositoryInterface;
use App\Domain\Entity\UserProject;
use Doctrine\ORM\EntityManagerInterface;
use Psr\Container\ContainerInterface;

class ProfileRepository implements ProfileRepositoryInterface
{
    /** @var ContainerInterface */
    private $container;

    /** @var EntityManagerInterface */
    private $entityManager;

    public function __construct(ContainerInterface $container, EntityManagerInterface $entityManager)
    {
        $this->container = $container;
        $this->entityManager = $entityManager;
    }

    /**
     * @return mixed
     */
    private function connection()
    {
        return $this->container->get('doctrine.dbal.user_connection');
    }

    /**
     * @return mixed
     */
    public function findById(int $id)
    {
        return $this->entityManager
            ->createQueryBuilder()
            ->select('u')
            ->from(UserProject::class, 'u')
            ->where('u.userId = :id')
            ->setParameter('id', $id)
            ->getQuery()
            ->getOneOrNullResult()
            ;
    }
}