Oc\Repository\CachesRepository

Complexity

Total Complexity

4

Size/Duplication

Total Lines	72
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	5	1
A	fetchOneById()	0	20	2
A	getEntityFromDatabaseArray()	0	12	1

<?php

namespace Oc\Repository;

use Doctrine\DBAL\Connection;
use Oc\Entity\CachesEntity;
use Oc\Repository\Exception\RecordAlreadyExistsException;
use Oc\Repository\Exception\RecordNotFoundException;
use Oc\Repository\Exception\RecordNotPersistedException;
use Oc\Repository\Exception\RecordsNotFoundException;

class CachesRepository
{
    /**
     * Database table name that this repository maintains.
     *
     * @var string
     */
    public const TABLE = 'caches';

    /**
     * @var Connection
     */
    private $connection;
    /**
     * @var SecurityRolesRepository
     */
    private $securityRolesRepository; //??

    public function __construct(Connection $connection, SecurityRolesRepository  $securityRolesRepository) //??
    {
        $this->connection = $connection;
        $this->securityRolesRepository = $securityRolesRepository;
    }

    /**
     * Fetches all caches.
     *
     * @throws RecordsNotFoundException Thrown when no records are found
     * @return UserEntity[]
     */
    /**
     * Fetches a cache by its id.
     *
     * @throws RecordNotFoundException Thrown when the request record is not found
     */
    public function fetchOneById(int $id): UserEntity
    {
        $statement = $this->connection->createQueryBuilder()
            ->select('*')
            ->from(self::TABLE)
            ->where('cache_id = :id')
            ->setParameter(':id', $id)
            ->execute();

        $result = $statement->fetch();

        if ($statement->rowCount() === 0) {
            throw new RecordNotFoundException(sprintf(
                'Record with id #%s not found',
                $id
            ));
        }

        return $this->getEntityFromDatabaseArray($result);
    }

    /**
     * Prepares database array from properties.
     */
    public function getEntityFromDatabaseArray(array $data): CachesEntity
    {
        $entity = new CachesEntity();
        $entity->id = (int) $data['cache_id'];
        $entity->name = $data['name'];
        $entity->wp_gc = $data['wp_gc'];
        $entity->wp_oc = $data['wp_oc'];
        $entity->latitude = (double) $data['latitude'];
        $entity->longitude = (double) $data['longitude'];

        return $entity;
    }
}