Update::toString() - Code Metrics - Inspection of "feat: add query parts" - puzzle-org/query-builder - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — master (#1)

by Romain

created 2017-07-03 16:12 UTC

Update::toString() A

↳ Parent: Update

Complexity

Conditions	3
Paths	3

Size

Total Lines	18
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	3

Importance

Changes

Metric	Value
dl	0
loc	18
c	0
b	0
f	0
ccs	8
cts	8
cp	1
rs	9.4285
cc	3
eloc	8
nc	3
nop	0
crap	3

<?php

declare(strict_types = 1);

namespace Puzzle\QueryBuilder\Queries\Snippets;

use Puzzle\QueryBuilder\Snippet;

class Update implements Snippet, NeedTableAware
{
    private
        $tables;

    public function __construct($table = null, ?string $alias = null)
    {
        $this->tables = array();

        if(! empty($table))
        {
            $this->addTable($table, $alias);
        }
    }

    public function addTable($table, ?string $alias = null): self
    {
        if(! $table instanceof TableName)
        {
            $table = new TableName($table, $alias);
        }

        $this->tables[] = $table;

        return $this;
    }

    public function toString(): string
    {
        if(empty($this->tables))
        {
            return '';
        }

        $tables = array();

        foreach($this->tables as $table)
        {
            $tables[] = $table->toString();
        }

        $tablesString = implode(', ', array_filter($tables));

        return sprintf('UPDATE %s', $tablesString);
    }

    public function hasNeededTable(string $tableName): bool
    {
        foreach($this->tables as $table)
        {
            if($table->getName() === $tableName || $table->getAlias() === $tableName)
            {
                return true;
            }
        }

        return false;
    }
}


1		<?php
2
3		declare(strict_types = 1);
4
5		namespace Puzzle\QueryBuilder\Queries\Snippets;
6
7		use Puzzle\QueryBuilder\Snippet;
8
9		class Update implements Snippet, NeedTableAware
10		{
11		private
12		$tables;
13
14	20	public function __construct($table = null, ?string $alias = null)
15		{
16	20	$this->tables = array();
17
18	20	if(! empty($table))
19		{
20	7	$this->addTable($table, $alias);
21		}
22	20	}
23
24	17	public function addTable($table, ?string $alias = null): self
25		{
26	17	if(! $table instanceof TableName)
27		{
28	16	$table = new TableName($table, $alias);
29		}
30
31	15	$this->tables[] = $table;
32
33	15	return $this;
34		}
35
36	17	public function toString(): string
37		{
38	17	if(empty($this->tables))
39		{
40	3	return '';
41		}
42
43	14	$tables = array();
44
45	14	foreach($this->tables as $table)
46		{
47	14	$tables[] = $table->toString();
48		}
49
50	14	$tablesString = implode(', ', array_filter($tables));
51
52	14	return sprintf('UPDATE %s', $tablesString);
53		}
54
55	2	public function hasNeededTable(string $tableName): bool
56		{
57	2	foreach($this->tables as $table)
58		{
59	2	if($table->getName() === $tableName \|\| $table->getAlias() === $tableName)
60		{
61	1	return true;
62		}
63		}
64
65	1	return false;
66		}
67		}
68

puzzle-org / query-builder

Pull Request — master (#1)

Update::toString() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like