Willry\QueryBuilder\Create

Complexity

Total Complexity

4

Size/Duplication

Total Lines	40
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	6	1
A	create()	0	7	1

<?php

namespace Willry\QueryBuilder;

use Exception;
use PDOStatement;
use stdClass;

class Create extends Base
{
    protected function mountQuery(): void
    {
        $columns = implode(", ", array_keys($this->fields));
        $values = implode(',', array_fill(0, count($this->fields), '?'));

        $this->query = "INSERT INTO {$this->entity} ({$columns}) VALUES ({$values})";
    }

    /**
     * @param array $data
     * @return Create
     */
    public function create(array $data): static
    {
        $this->setBindings(array_values($data), 'create');
        
        $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 $this->db->lastInsertId();

The expression return $this->db->lastInsertId() returns the type string which is incompatible with the type-hinted return integer|null.

        } catch (\PDOException $exception) {
            $this->handleError($exception);
        }
    }
}