App\Game\Infrastructure\Dao\Doctrine\HistoryDao

Complexity

Total Complexity

2

Size/Duplication

Total Lines	30
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	3	1
A	ratingHistory()	0	21	1

<?php

declare(strict_types=1);

namespace App\Game\Infrastructure\Dao\Doctrine;

use App\Game\Features\History\HistoryDaoInterface;
use App\Game\Features\History\HistoryRatingDto;
use Doctrine\DBAL\Connection;

The type Doctrine\DBAL\Connection was not found. Maybe you did not declare it correctly or list all dependencies?

final class HistoryDao implements HistoryDaoInterface
{
    private Connection $connection;

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

    public function ratingHistory(int $limit = self::LIMIT): array
    {
        $records = $this->connection->createQueryBuilder()
            ->addSelect('p.nickname')
            ->addSelect('h.level')
            ->addSelect('(strftime("%s", max(h.createdAt)) - strftime("%s", min(H.createdAt))) as date')
            ->from('history', 'h')
            ->innerJoin('h', 'player', 'p', 'h.player = p.id')
            ->addOrderBy('date', 'ASC')
            ->addOrderBy('h.level', 'DESC')
            ->addGroupBy('p.nickname')
            ->setMaxResults($limit)
            ->execute()
            ->fetchAllAssociative();

        return array_map(
            static fn (array $record): HistoryRatingDto => new HistoryRatingDto(
                $record['nickname'],
                (int) $record['level']
            ),
            $records
        );
    }
}