Yiisoft\Db\Command\CommandPdoTrait

Complexity

Total Complexity

8

Size/Duplication

Total Lines	53
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

4 Methods

Rating	Name	Duplication	Size	Complexity
A	getPdoStatement()	0	3	1
A	bindPendingParams()	0	4	2
A	cancel()	0	3	1
A	bindParam()	0	22	4

<?php

declare(strict_types=1);

namespace Yiisoft\Db\Command;

use PDOStatement;

trait CommandPdoTrait
{
    /**
     * @psalm-var ParamInterface[]
     */
    protected array $params = [];

    protected ?PDOStatement $pdoStatement = null;

    public function getPdoStatement(): ?PDOStatement
    {
        return $this->pdoStatement;
    }

    public function cancel(): void
    {
        $this->pdoStatement = null;
    }

    /**
     * Binds pending parameters that were registered via {@see bindValue()} and {@see bindValues()}.
     *
     * Note that this method requires an active {@see pdoStatement}.
     */
    protected function bindPendingParams(): void
    {
        foreach ($this->params as $name => $value) {
            $this->pdoStatement?->bindValue($name, $value->getValue(), $value->getType());
        }
    }

    public function bindParam(
        int|string $name,
        mixed &$value,
        ?int $dataType = null,
        ?int $length = null,
        mixed $driverOptions = null
    ): static {
        $this->prepare();

It seems like prepare() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        if ($dataType === null) {
            $dataType = $this->queryBuilder()->schema()->getPdoType($value);

It seems like queryBuilder() must be provided by classes using this trait. How about adding it as abstract method to this trait?

        }

        if ($length === null) {
            $this->pdoStatement?->bindParam($name, $value, $dataType);
        } elseif ($driverOptions === null) {
            $this->pdoStatement?->bindParam($name, $value, $dataType, $length);
        } else {
            $this->pdoStatement?->bindParam($name, $value, $dataType, $length, $driverOptions);
        }

        return $this;
    }
}