Willry\QueryBuilder\Update

Complexity

Total Complexity

5

Size/Duplication

Total Lines	44
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	exec()	0	14	2
A	mountQuery()	0	10	2
A	update()	0	8	1

<?php

namespace Willry\QueryBuilder;

use Exception;
use PDOStatement;
use stdClass;

class Update extends Base
{
    protected function mountQuery(): void
    {

        $dateSet = [];
        foreach ($this->fields as $bind => $value) {
            $dateSet[] = "{$bind} = ?";
        }
        $dateSet = implode(", ", $dateSet);

        $this->query = "UPDATE {$this->entity} {$this->joins} SET {$dateSet} {$this->where}";
    }

    /**
     * @param array $data
     */
    public function update(array $data): static
    {
        $this->type = self::TYPE_UPDATE;

        $this->setBindings(array_values($data), 'update');
        $this->fields = $data;

        return $this;
    }

    /**
     * @param array $data
     */
    public function exec(): ?int
    {
        try {
            $this->mountQuery();

            $stmt = $this->db->prepare($this->query);

            QueryHelpers::bind($stmt, $this->flatBindings());

            $stmt->execute();

            return $stmt->rowCount() ?? 1;
        } catch (\PDOException $exception) {
            $this->handleError($exception);
        }
    }
}