LIN3S\SharedKernel\Infrastructure\Persistence\Sql\Pdo::update()

Complexity

Conditions	4
Paths	5

Size

Total Lines	20
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	Pdo::executeAtomically()	0	16	3

<?php

/*
 * This file is part of the Shared Kernel library.
 *
 * Copyright (c) 2016-present LIN3S <info@lin3s.com>
 *
 * For the full copyright and license information, please view the LICENSE
 * file that was distributed with this source code.
 */

declare(strict_types=1);

namespace LIN3S\SharedKernel\Infrastructure\Persistence\Sql;

/**
 * @author Beñat Espiña <benatespina@gmail.com>
 */
final class Pdo
{
    public const DATE_FORMAT = 'Y-m-d H:i:s';

    private $pdo;

    public function __construct(\PDO $pdo)
    {
        $this->pdo = $pdo;
        $this->pdo->setAttribute($this->pdo::ATTR_ERRMODE, $this->pdo::ERRMODE_EXCEPTION);
    }

    public function query(string $sql, array $parameters = []) : array
    {
        return $this->execute($sql, $parameters)->fetchAll(\PDO::FETCH_ASSOC);
    }

    public function insert(string $table, array $parameters) : void
    {
        if (!is_array($parameters[0])) {
            $parameters = [$parameters];
        }

        $values = [];
        foreach ($parameters as $parameter) {
            $values = array_merge($values, array_values($parameter));
        }
        $numberOfInsertions = count($parameters);
        $columns = array_keys($parameters[0]);
        $rowPlaces = '(' . implode(', ', array_fill(0, count($columns), '?')) . ')';
        $allPlaces = implode(', ', array_fill(0, $numberOfInsertions, $rowPlaces));

        $sql = 'INSERT INTO ' . $table . ' (' . implode(', ', $columns) . ') VALUES ' . $allPlaces;

        $this->execute($sql, $values);
    }

    public function executeAtomically(callable $function)
    {
        $this->pdo->beginTransaction();

        try {
            $return = call_user_func($function, $this);

            $this->pdo->commit();

            return $return ?: true;
        } catch (\Exception | \Throwable $exception) {
            $this->pdo->rollback();

            throw $exception;
        }
    }

    public function execute(string $sql, array $parameters) : \PDOStatement
    {
        $statement = $this->pdo->prepare($sql);
        $statement->execute($parameters);

        return $statement;
    }
}