Gecko [ v3.cesa.co.za ]

Name	Size	Permission	Date
ArrayParameters	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Cache	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Connections	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Driver	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Event	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Exception	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Id	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Logging	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Platforms	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Portability	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Query	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
SQL	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Schema	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Tools	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
Types	[ DIR ]	drwxrwxr-x	2026-08-17 03:12
.htaccess	237 B	-r-xr-xr-x	2026-08-17 03:12
ArrayParameterType.php	1.13 KB	-rwxrwxr-x	2026-02-24 08:03
ColumnCase.php	429 B	-rwxrwxr-x	2026-02-24 08:03
Configuration.php	7.7 KB	-rwxrwxr-x	2026-02-24 08:03
Connection.php	64.82 KB	-rwxrwxr-x	2026-02-24 08:03
ConnectionException.php	893 B	-rwxrwxr-x	2026-02-24 08:03
Driver.php	1.63 KB	-rwxrwxr-x	2026-02-24 08:03
DriverManager.php	9.16 KB	-rwxrwxr-x	2026-02-24 08:03
Events.php	1.58 KB	-rwxrwxr-x	2026-02-24 08:03
Exception.php	4.92 KB	-rwxrwxr-x	2026-02-24 08:03
ExpandArrayParameters.php	3.75 KB	-rwxrwxr-x	2026-02-24 08:03
FetchMode.php	422 B	-rwxrwxr-x	2026-02-24 08:03
LockMode.php	419 B	-rwxrwxr-x	2026-02-24 08:03
ParameterType.php	982 B	-rwxrwxr-x	2026-02-24 08:03
Query.php	1.09 KB	-rwxrwxr-x	2026-02-24 08:03
Result.php	8.58 KB	-rwxrwxr-x	2026-02-24 08:03
Statement.php	7.46 KB	-rwxrwxr-x	2026-02-24 08:03
TransactionIsolationLevel.php	601 B	-rwxrwxr-x	2026-02-24 08:03
VersionAwarePlatformDriver.php	1.02 KB	-rwxrwxr-x	2026-02-24 08:03

Rename

<?php

declare(strict_types=1);

namespace Doctrine\DBAL;

use Doctrine\DBAL\Driver\Exception as DriverException;
use Doctrine\DBAL\Driver\Result as DriverResult;
use Doctrine\DBAL\Exception\NoKeyValue;
use Doctrine\Deprecations\Deprecation;
use LogicException;
use Traversable;

use function array_shift;
use function func_num_args;

class Result
{
    private DriverResult $result;
    private Connection $connection;

/** @internal The result can be only instantiated by {@see Connection} or {@see Statement}. */
    public function __construct(DriverResult $result, Connection $connection)
    {
        $this->result     = $result;
        $this->connection = $connection;
    }

/**
     * Returns the next row of the result as a numeric array or FALSE if there are no more rows.
     *
     * @return list<mixed>|false
     *
     * @throws Exception
     */
    public function fetchNumeric()
    {
        try {
            return $this->result->fetchNumeric();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * Returns the next row of the result as an associative array or FALSE if there are no more rows.
     *
     * @return array<string,mixed>|false
     *
     * @throws Exception
     */
    public function fetchAssociative()
    {
        try {
            return $this->result->fetchAssociative();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * Returns the first value of the next row of the result or FALSE if there are no more rows.
     *
     * @return mixed|false
     *
     * @throws Exception
     */
    public function fetchOne()
    {
        try {
            return $this->result->fetchOne();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * Returns an array containing all of the result rows represented as numeric arrays.
     *
     * @return list<list<mixed>>
     *
     * @throws Exception
     */
    public function fetchAllNumeric(): array
    {
        try {
            return $this->result->fetchAllNumeric();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * Returns an array containing all of the result rows represented as associative arrays.
     *
     * @return list<array<string,mixed>>
     *
     * @throws Exception
     */
    public function fetchAllAssociative(): array
    {
        try {
            return $this->result->fetchAllAssociative();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * Returns an array containing the values of the first column of the result.
     *
     * @return array<mixed,mixed>
     *
     * @throws Exception
     */
    public function fetchAllKeyValue(): array
    {
        $this->ensureHasKeyValue();

$data = [];

foreach ($this->fetchAllNumeric() as [$key, $value]) {
            $data[$key] = $value;
        }

return $data;
    }

/**
     * Returns an associative array with the keys mapped to the first column and the values being
     * an associative array representing the rest of the columns and their values.
     *
     * @return array<mixed,array<string,mixed>>
     *
     * @throws Exception
     */
    public function fetchAllAssociativeIndexed(): array
    {
        $data = [];

foreach ($this->fetchAllAssociative() as $row) {
            $data[array_shift($row)] = $row;
        }

return $data;
    }

/**
     * @return list<mixed>
     *
     * @throws Exception
     */
    public function fetchFirstColumn(): array
    {
        try {
            return $this->result->fetchFirstColumn();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/**
     * @return Traversable<int,list<mixed>>
     *
     * @throws Exception
     */
    public function iterateNumeric(): Traversable
    {
        while (($row = $this->fetchNumeric()) !== false) {
            yield $row;
        }
    }

/**
     * @return Traversable<int,array<string,mixed>>
     *
     * @throws Exception
     */
    public function iterateAssociative(): Traversable
    {
        while (($row = $this->fetchAssociative()) !== false) {
            yield $row;
        }
    }

/**
     * @return Traversable<mixed, mixed>
     *
     * @throws Exception
     */
    public function iterateKeyValue(): Traversable
    {
        $this->ensureHasKeyValue();

foreach ($this->iterateNumeric() as [$key, $value]) {
            yield $key => $value;
        }
    }

/**
     * Returns an iterator over the result set with the keys mapped to the first column and the values being
     * an associative array representing the rest of the columns and their values.
     *
     * @return Traversable<mixed,array<string,mixed>>
     *
     * @throws Exception
     */
    public function iterateAssociativeIndexed(): Traversable
    {
        foreach ($this->iterateAssociative() as $row) {
            yield array_shift($row) => $row;
        }
    }

/**
     * @return Traversable<int,mixed>
     *
     * @throws Exception
     */
    public function iterateColumn(): Traversable
    {
        while (($value = $this->fetchOne()) !== false) {
            yield $value;
        }
    }

/** @throws Exception */
    public function rowCount(): int
    {
        try {
            return $this->result->rowCount();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

/** @throws Exception */
    public function columnCount(): int
    {
        try {
            return $this->result->columnCount();
        } catch (DriverException $e) {
            throw $this->connection->convertException($e);
        }
    }

public function free(): void
    {
        $this->result->free();
    }

/** @throws Exception */
    private function ensureHasKeyValue(): void
    {
        $columnCount = $this->columnCount();

if ($columnCount < 2) {
            throw NoKeyValue::fromColumnCount($columnCount);
        }
    }

/**
     * BC layer for a wide-spread use-case of old DBAL APIs
     *
     * @deprecated Use {@see fetchNumeric()}, {@see fetchAssociative()} or {@see fetchOne()} instead.
     *
     * @phpstan-param FetchMode::* $mode
     *
     * @return mixed
     *
     * @throws Exception
     */
    public function fetch(int $mode = FetchMode::ASSOCIATIVE)
    {
        Deprecation::trigger(
            'doctrine/dbal',
            'https://github.com/doctrine/dbal/pull/4007',
            '%s is deprecated, please use fetchNumeric(), fetchAssociative() or fetchOne() instead.',
            __METHOD__,
        );

if (func_num_args() > 1) {
            throw new LogicException('Only invocations with one argument are still supported by this legacy API.');
        }

if ($mode === FetchMode::ASSOCIATIVE) {
            return $this->fetchAssociative();
        }

if ($mode === FetchMode::NUMERIC) {
            return $this->fetchNumeric();
        }

if ($mode === FetchMode::COLUMN) {
            return $this->fetchOne();
        }

throw new LogicException('Only fetch modes declared on Doctrine\DBAL\FetchMode are supported by legacy API.');
    }

/**
     * BC layer for a wide-spread use-case of old DBAL APIs
     *
     * @deprecated Use {@see fetchAllNumeric()}, {@see fetchAllAssociative()} or {@see fetchFirstColumn()} instead.
     *
     * @phpstan-param FetchMode::* $mode
     *
     * @return list<mixed>
     *
     * @throws Exception
     */
    public function fetchAll(int $mode = FetchMode::ASSOCIATIVE): array
    {
        Deprecation::trigger(
            'doctrine/dbal',
            'https://github.com/doctrine/dbal/pull/4007',
            '%s is deprecated, please use fetchAllNumeric(), fetchAllAssociative() or fetchFirstColumn() instead.',
            __METHOD__,
        );

if (func_num_args() > 1) {
            throw new LogicException('Only invocations with one argument are still supported by this legacy API.');
        }

if ($mode === FetchMode::ASSOCIATIVE) {
            return $this->fetchAllAssociative();
        }

if ($mode === FetchMode::NUMERIC) {
            return $this->fetchAllNumeric();
        }

if ($mode === FetchMode::COLUMN) {
            return $this->fetchFirstColumn();
        }

throw new LogicException('Only fetch modes declared on Doctrine\DBAL\FetchMode are supported by legacy API.');
    }
}