Gecko [ school.pilasatech.net ]

Name	Size	Permission	Date
ArrayParameters	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Cache	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Connection	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Connections	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Driver	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Exception	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Logging	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Platforms	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Portability	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Query	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
SQL	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Schema	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Tools	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
Types	[ DIR ]	drwxrwxrwx	2025-03-23 13:35
ArrayParameterType.php	900 B	-rw-rw-rw-	2025-03-07 07:29
ColumnCase.php	284 B	-rw-rw-rw-	2025-03-07 07:29
Configuration.php	3.84 KB	-rw-rw-rw-	2025-03-07 07:29
Connection.php	43.03 KB	-rw-rw-rw-	2025-03-07 07:29
ConnectionException.php	129 B	-rw-rw-rw-	2025-03-07 07:29
Driver.php	1.31 KB	-rw-rw-rw-	2025-03-07 07:29
DriverManager.php	5.75 KB	-rw-rw-rw-	2025-03-07 07:29
Exception.php	117 B	-rw-rw-rw-	2025-03-07 07:29
ExpandArrayParameters.php	3.25 KB	-rw-rw-rw-	2025-03-07 07:29
LockMode.php	214 B	-rw-rw-rw-	2025-03-07 07:29
ParameterType.php	694 B	-rw-rw-rw-	2025-03-07 07:29
Query.php	803 B	-rw-rw-rw-	2025-03-07 07:29
Result.php	7.59 KB	-rw-rw-rw-	2025-03-07 07:29
ServerVersionProvider.php	202 B	-rw-rw-rw-	2025-03-07 07:29
Statement.php	4.14 KB	-rw-rw-rw-	2025-03-07 07:29
TransactionIsolationLevel.php	195 B	-rw-rw-rw-	2025-03-07 07:29

Rename

<?php

declare(strict_types=1);

namespace Doctrine\DBAL;

use Doctrine\DBAL\ArrayParameters\Exception\MissingNamedParameter;
use Doctrine\DBAL\ArrayParameters\Exception\MissingPositionalParameter;
use Doctrine\DBAL\SQL\Parser\Visitor;
use Doctrine\DBAL\Types\Type;

use function array_fill;
use function array_key_exists;
use function count;
use function implode;
use function substr;

/** @phpstan-import-type WrapperParameterTypeArray from Connection */
final class ExpandArrayParameters implements Visitor
{
    private int $originalParameterIndex = 0;

/** @var list<string> */
    private array $convertedSQL = [];

/** @var list<mixed> */
    private array $convertedParameters = [];

/** @var array<int<0, max>,string|ParameterType|Type> */
    private array $convertedTypes = [];

/**
     * @param array<int, mixed>|array<string, mixed> $parameters
     * @phpstan-param WrapperParameterTypeArray $types
     */
    public function __construct(
        private readonly array $parameters,
        private readonly array $types,
    ) {
    }

public function acceptPositionalParameter(string $sql): void
    {
        $index = $this->originalParameterIndex;

if (! array_key_exists($index, $this->parameters)) {
            throw MissingPositionalParameter::new($index);
        }

$this->acceptParameter($index, $this->parameters[$index]);

$this->originalParameterIndex++;
    }

public function acceptNamedParameter(string $sql): void
    {
        $name = substr($sql, 1);

if (! array_key_exists($name, $this->parameters)) {
            throw MissingNamedParameter::new($name);
        }

$this->acceptParameter($name, $this->parameters[$name]);
    }

public function acceptOther(string $sql): void
    {
        $this->convertedSQL[] = $sql;
    }

public function getSQL(): string
    {
        return implode('', $this->convertedSQL);
    }

/** @return list<mixed> */
    public function getParameters(): array
    {
        return $this->convertedParameters;
    }

private function acceptParameter(int|string $key, mixed $value): void
    {
        if (! isset($this->types[$key])) {
            $this->convertedSQL[]        = '?';
            $this->convertedParameters[] = $value;

return;
        }

$type = $this->types[$key];

if (! $type instanceof ArrayParameterType) {
            $this->appendTypedParameter([$value], $type);

return;
        }

if (count($value) === 0) {
            $this->convertedSQL[] = 'NULL';

return;
        }

$this->appendTypedParameter($value, ArrayParameterType::toElementParameterType($type));
    }

/** @return array<int<0, max>,string|ParameterType|Type> */
    public function getTypes(): array
    {
        return $this->convertedTypes;
    }

/** @param list<mixed> $values */
    private function appendTypedParameter(array $values, string|ParameterType|Type $type): void
    {
        $this->convertedSQL[] = implode(', ', array_fill(0, count($values), '?'));

$index = count($this->convertedParameters);

foreach ($values as $value) {
            $this->convertedParameters[]  = $value;
            $this->convertedTypes[$index] = $type;

$index++;
        }
    }
}