Statement::update() - Code Metrics - Inspection of "Updated to new version" - EdsonOnildoJR/activerecord.php - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( 670622...a5ffbc )

by Edson

created 2018-04-07 01:52 UTC

Statement::update() A

↳ Parent: Statement

Complexity

Conditions	3
Paths	3

Size

Total Lines	17
Code Lines	9

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	3

Importance

Changes

Metric	Value
cc	3
eloc	9
nc	3
nop	2
dl	0
loc	17
ccs	10
cts	10
cp	1
crap	3
rs	9.4285
c	0
b	0
f	0

<?php

namespace Keep;

trait Statement
{
    private $statement;
    private $attributes = [];

    public function create(string $table, array $attributes): self
    {
        $this->attributes = $attributes;
        $this->statement  = 'INSERT INTO `' . $table . '` (`';
        $this->statement .= Tool::getAttributesKey($attributes);
        $this->statement .= '`) VALUES (:';
        $this->statement .= Tool::getAttributesValue($attributes) . ')';
        return $this;
    }

    public function all(string $table): self
    {
        $this->statement = "SELECT * FROM `{$table}`";
        return $this;
    }

    public function select(string $table, array $columns): self
    {
        $this->statement = 'SELECT `' . Tool::columns($columns) . "` FROM `{$table}`";
        return $this;
    }

    public function update(string $table, array $attributes): self
    {
        $this->attributes = $attributes;

        $set = '';
        $key = array_keys($attributes);
        $pop = array_pop($key);

        foreach ($attributes as $key => $value) {
            $set .= ($key == $pop) ? '' : "`{$key}` = :{$key}, ";
        }

        $set .= "`{$pop}` = :{$pop}";

        $this->statement = "UPDATE `{$table}` SET {$set}";

        return $this;
    }

    public function delete(string $table): self
    {
        $this->statement = "DELETE FROM `{$table}`";
        return $this;
    }
}


1		<?php
2
3		namespace Keep;
4
5		trait Statement
6		{
7		private $statement;
8		private $attributes = [];
9
10	2	public function create(string $table, array $attributes): self
11		{
12	2	$this->attributes = $attributes;
13	2	$this->statement = 'INSERT INTO `' . $table . '` (`';
14	2	$this->statement .= Tool::getAttributesKey($attributes);
15	2	$this->statement .= '`) VALUES (:';
16	2	$this->statement .= Tool::getAttributesValue($attributes) . ')';
17	2	return $this;
18		}
19
20	2	public function all(string $table): self
21		{
22	2	$this->statement = "SELECT * FROM `{$table}`";
23	2	return $this;
24		}
25
26	2	public function select(string $table, array $columns): self
27		{
28	2	$this->statement = 'SELECT `' . Tool::columns($columns) . "` FROM `{$table}`";
29	2	return $this;
30		}
31
32	2	public function update(string $table, array $attributes): self
33		{
34	2	$this->attributes = $attributes;
35
36	2	$set = '';
37	2	$key = array_keys($attributes);
38	2	$pop = array_pop($key);
39
40	2	foreach ($attributes as $key => $value) {
41	2	$set .= ($key == $pop) ? '' : "`{$key}` = :{$key}, ";
42		}
43
44	2	$set .= "`{$pop}` = :{$pop}";
45
46	2	$this->statement = "UPDATE `{$table}` SET {$set}";
47
48	2	return $this;
49		}
50
51	2	public function delete(string $table): self
52		{
53	2	$this->statement = "DELETE FROM `{$table}`";
54	2	return $this;
55		}
56		}
57

EdsonOnildoJR / activerecord.php

Push — master ( 670622...a5ffbc )

Statement::update() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like