Create::mountQuery() - Code Metrics - Inspection of "Ajustes de formatação" - WillRy/querybuilder - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 87c1e5...f29b76 )

by William

created 2023-08-26 23:05 UTC

Create::mountQuery() A

↳ Parent: Create

Complexity

Conditions	1
Paths	1

Size

Total Lines	6
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
cc	1
eloc	3
c	1
b	0
f	0
nc	1
nop	0
dl	0
loc	6
rs	10

<?php

namespace Willry\QueryBuilder;


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();

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


1			<?php
2
3			namespace Willry\QueryBuilder;
4
5
6			class Create extends Base
7			{
8			protected function mountQuery(): void
9			{
10			$columns = implode(", ", array_keys($this->fields));
11			$values = implode(',', array_fill(0, count($this->fields), '?'));
12
13			$this->query = "INSERT INTO {$this->entity} ({$columns}) VALUES ({$values})";
14			}
15
16			/**
17			* @param array $data
18			* @return Create
19			*/
20			public function create(array $data): static
21			{
22			$this->setBindings(array_values($data), 'create');
23
24			$this->fields = $data;
25
26			return $this;
27			}
28
29			/**
30			* @param array $data
31			*/
32			public function exec(): ?int
33			{
34			try {
35			$this->mountQuery();
36
37			$stmt = $this->db->prepare($this->query);
38
39			QueryHelpers::bind($stmt, $this->flatBindings());
40
41			$stmt->execute();
42
43			return $this->db->lastInsertId();
			0 ignored issues – show Bug Best Practice introduced 2023-08-26 20:56 UTC by Report Bug Copy Issue Report The expression `return $this->db->lastInsertId()` returns the type `string` which is incompatible with the type-hinted return `integer\|null`. Loading history...
44			} catch (\PDOException $exception) {
45			$this->handleError($exception);
46			}
47			}
48			}
49

WillRy / querybuilder

Push — main ( 87c1e5...f29b76 )

Create::mountQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like