Is it possible GetCurrent Page Results() returned an array of DTO objects ?

[nickicool]

In DBAL 3 will dropped support fetching objects with custom class like:

$stmt->setFetchMode(FetchMode::CUSTOM_OBJECT, ArticleDTO::class);

Therefore, now in the array $articles there will be a regular associative array, instead of `ArticleDTO[]'. Is it possible to substitute the output of the getCurrentPageResults() method?

function getArticles()
{
    $queryBuilder = $connection->createQueryBuilder();
    $queryBuilder
        ->select('id, title, content, authorName')
        ->from('articles');

    $countQueryBuilderModifier = static function (QueryBuilder $queryBuilder): void {
        $queryBuilder->select('COUNT(DISTINCT id) AS total_results')
            ->setMaxResults(1);
    };

    $paginator = new Pagerfanta(new QueryAdapter($queryBuilder, $countQueryBuilderModifier));
    $paginator->setMaxPerPage(10);
    $paginator->setCurrentPage(1);

    return $paginator;
}

$paginator = getArticles();
$articles = $paginator->getCurrentPageResults();

Or maybe there is another solution so that GetCurrentPageResults() returns an array of ArticleDTO objects?

[mbabker]

You'd need some kind of adapter/decorator to hydrate the array into a DTO if you wanted it to be handled when $pagerfanta->getCurrentPageResults() is called (or manually deal with it after that call). Pagerfanta on its own doesn't deal with any type of data mapping or conversion.

final class DTOAdapter implements AdapterInterface
{
    public function __construct(
        private readonly AdapterInterface $decoratedAdapter,
    ) {}

    public function getNbResults(): int
    {
        return $this->decoratedAdapter->getNbResults();
    }

    public function getSlice(int $offset, int $length): iterable
    {
        $rawData = $this->decoratedAdapter->getSlice($offset, $length);

        $dtos = [];

        foreach ($rawData as $row) {
            // Replace with the actual logic to convert the array to your DTO
            $item = new Foo();

            $dtos[] = $item;
        }

        return $dtos;
    }
}

[nickicool]

@mbabker thank you for help! Yes, this solution work for me!!!

[nickicool]

And I found another way for this issue, uses TransformingAdapter ("out of the box" without create own adapters):

    $adapter = new TransformingAdapter(
        new QueryAdapter($queryBuilder, $countQueryBuilderModifier),
        static fn($item, $key) => ArticleDTO::fromArray($item)
    );