Update::exec() - Code Metrics - Inspection of "Refatoração de classes" - WillRy/querybuilder - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Branch — refatoracao (7827b3)

by William

created 2023-08-26 20:54 UTC

Update::exec() A

↳ Parent: Update

Complexity

Conditions	2
Paths	6

Size

Total Lines	14
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?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);
        }
    }
}


1			<?php
2
3			namespace Willry\QueryBuilder;
4
5			use Exception;
6			use PDOStatement;
7			use stdClass;
8
9			class Update extends Base
10			{
11			protected function mountQuery(): void
12			{
13
14			$dateSet = [];
15			foreach ($this->fields as $bind => $value) {
16			$dateSet[] = "{$bind} = ?";
17			}
18			$dateSet = implode(", ", $dateSet);
19
20			$this->query = "UPDATE {$this->entity} {$this->joins} SET {$dateSet} {$this->where}";
21			}
22
23			/**
24			* @param array $data
25			*/
26			public function update(array $data): static
27			{
28			$this->type = self::TYPE_UPDATE;
29
30			$this->setBindings(array_values($data), 'update');
31			$this->fields = $data;
32
33			return $this;
34			}
35
36			/**
37			* @param array $data
38			*/
39			public function exec(): ?int
40			{
41			try {
42			$this->mountQuery();
43
44			$stmt = $this->db->prepare($this->query);
45
46			QueryHelpers::bind($stmt, $this->flatBindings());
47
48			$stmt->execute();
49
50			return $stmt->rowCount() ?? 1;
51			} catch (\PDOException $exception) {
52			$this->handleError($exception);
53			}
54			}
55			}
56

WillRy / querybuilder

Branch — refatoracao (7827b3)

Update::exec() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like