Statement.php

<?php

namespace ModernPDO;

/**
 * Wrapper over PDOStatement.
 *
 * Use ModerPDO objects to get this class object.
 */
class Statement
{
    /**
     * Statement constructor.
     */
    public function __construct(
        private ?\PDOStatement $statement,
    ) {
    }

    /**
     * Returns statement status.
     */
    public function status(): bool
    {
        return $this->statement !== null;
    }

    /**
     * Returns the number of rows affected by the last SQL statement.
     *
     * @see https://www.php.net/manual/en/pdostatement.rowcount.php
     */
    public function rowCount(): int
    {
        try {
            $count = $this->statement?->rowCount() ?? 0;
        } catch (\Throwable $th) {
            $count = 0;
        }

        return $count;
    }

    /**
     * Returns the number of columns in the result set.
     *
     * @see https://www.php.net/manual/ru/pdostatement.columncount.php
     */
    public function columnCount(): int
    {
        try {
            $count = $this->statement?->columnCount() ?? 0;
        } catch (\Throwable $th) {
            $count = 0;
        }

        return $count;
    }

    /**
     * Returns a single column from the next row of a result set.
     *
     * @return mixed If successful, a value, otherwise false
     *
     * @see https://www.php.net/manual/en/pdostatement.fetchall.php
     */
    public function fetchColumn(int $column = 0): mixed
    {
        try {
            /** @var mixed Comment for PSalm and CSFixer */
            $result = $this->statement?->fetchColumn($column) ?? false;
        } catch (\Throwable $th) {
            $result = false;
        }

        return $result;
    }

    /**
     * Fetches the next row and returns it as an object.
     *
     * @return object|false If successful, an object, otherwise false
     *
     * @see https://www.php.net/manual/en/pdostatement.fetchobject.php
     */
    public function fetchObject(): object|false
    {
        try {
            $object = $this->statement?->fetchObject() ?? false;
        } catch (\Throwable $th) {
            $object = false;
        }

        return $object;
    }

    /**
     * Fetches the next row from a result set.
     *
     * @return array<string, mixed> If successful, an array of data, otherwise an empty array
     *
     * @see https://www.php.net/manual/en/pdostatement.fetch.php
     */
    public function fetch(): array
    {
        try {
            /** @var array<string, mixed>|false */
            $row = $this->statement?->fetch(\PDO::FETCH_ASSOC) ?? false;
        } catch (\Throwable $th) {
            $row = false;
        }

        return $row !== false ? $row : [];
    }

    /**
     * Fetches the remaining rows from a result set.
     *
     * @return list<array<string, mixed>> If successful, an array of arrays, otherwise an empty array
     *
     * @see https://www.php.net/manual/en/pdostatement.fetchall.php
     */
    public function fetchAll(): array
    {
        try {
            /** @var list<array<string, mixed>>|false */
            $rows = $this->statement?->fetchAll(\PDO::FETCH_ASSOC) ?? false;
        } catch (\Throwable $th) {
            $rows = false;
        }

        return $rows !== false ? $rows : [];
    }
}