Linna\Storage\ExtendedPDO

Complexity

Total Complexity

6

Size/Duplication

Total Lines	63
Duplicated Lines	0 %

Test Coverage

Coverage

100%

Importance

Changes	7
Bugs	3	Features	3

3 Methods

Rating	Name	Duplication	Size	Complexity
A	checkValue()	0	8	3
A	queryWithParam()	0	18	2
A	getLastOperationStatus()	0	3	1

<?php

/**
 * Linna Framework.
 *
 * @author Sebastian Rapetti <sebastian.rapetti@alice.it>
 * @copyright (c) 2018, Sebastian Rapetti
 * @license http://opensource.org/licenses/MIT MIT License
 */
declare(strict_types=1);

namespace Linna\Storage;

use PDO;
use PDOStatement;
use InvalidArgumentException;

/**
 * Extended PDO
 */
class ExtendedPDO extends PDO
{
    /**
     * @var bool Status for last operation.
     */
    private bool $lastOperationStatus = false;

    /**
     * Executes an SQL statement with parameters,
     * returning a result set as a PDOStatement object
     *
     * @param string       $query SQL statement
     * @param array<mixed> $param Parameter as array as PDOStatement::bindParam
     *
     * @return PDOStatement<mixed>
     */
    public function queryWithParam(string $query, array $param): PDOStatement
    {
        $statement = $this->prepare($query);

        foreach ($param as $value) {
            $this->checkValue($value);

            //reassign as reference
            //because bindParam need it as reference
            $ref = $value;
            $ref[1] = &$value[1];

            \call_user_func_array([$statement, "bindParam"], $ref);
        }

        $this->lastOperationStatus = $statement->execute();

        return $statement;
    }

    /**
     * Return the last opration status.
     *
     * @return bool
     */
    public function getLastOperationStatus(): bool
    {
        return $this->lastOperationStatus;
    }

    /**
     * Check values passed to queryWithParam.
     *
     * @param array<mixed> $value
     *
     * @return void
     *
     * @throws InvalidArgumentException
     */
    private function checkValue(array &$value): void
    {
        if (\count($value) < 2) {
            throw new InvalidArgumentException('Parameters array must contain at least two elements with this form: [\':name\', \'value\'].');
        }

        if (\strpos($value[0], ':') !== 0) {
            throw new InvalidArgumentException('Parameter name will be in the form :name.');
        }
    }
}