Insert::preSet() - Code Metrics - Compolomus/SQLQueryBuilder - Measure and Improve Code Quality continuously with Scrutinizer

Insert::preSet() A
last analyzed 2018-05-09 04:13 UTC

↳ Parent: Project

Complexity

Conditions	2
Paths	2

Size

Total Lines	10
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	6

Importance

Changes

Metric	Value
dl	0
loc	10
ccs	0
cts	7
cp	0
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	7
nc	2
nop	2
crap	6

<?php

namespace Compolomus\LSQLQueryBuilder\Parts;

use Compolomus\LSQLQueryBuilder\System\Traits\{
    Helper,
    Caller,
    Placeholders
};

/**
 * @method string table()
 * @method void addPlaceholders($placeholders)
 */
class Insert
{
    use Caller, Placeholders, Helper;

    protected $fields = [];

    protected $values = [];

    public function __construct(array $args = [])
    {
        if (\count($args) > 0) {
            if (\is_string(key($args))) {
                $this->fields(array_keys($args));
            }
            $this->values(array_values($args));
        }
    }

    public function fields(array $fields): Insert
    {
        $this->fields = $fields;
        return $this;
    }

    public function values(array $values): Insert
    {
        $this->values[] = $this->set($values);
        return $this;
    }

    protected function preSet(array $values, string $flag): array
    {
        $result = [];
        foreach ($values as $value) {
            $key = $this->uid($flag);
            $result[] = ':' . $key;
            $this->placeholders()->set($key, $value);
        }
        return $result;
    }

    protected function set(array $values): string
    {
        return '(' . $this->concat($this->preSet($values, 'i')) . ')';
    }

    protected function get(): string
    {
        $this->addPlaceholders($this->placeholders()->get());
        return 'INSERT INTO ' . $this->table() . ' '
            . '(' . $this->concat($this->escapeField($this->fields)) . ')'

            . ' VALUES '
            . (\count($this->values)
                ? $this->concat($this->values)
                : '(' . $this->concat(array_fill(0, \count($this->fields), '?')) . ')'
            );
    }
}


1			<?php
2
3			namespace Compolomus\LSQLQueryBuilder\Parts;
4
5			use Compolomus\LSQLQueryBuilder\System\Traits\{
6			Helper,
7			Caller,
8			Placeholders
9			};
10
11			/**
12			* @method string table()
13			* @method void addPlaceholders($placeholders)
14			*/
15			class Insert
16			{
17			use Caller, Placeholders, Helper;
18
19			protected $fields = [];
20
21			protected $values = [];
22
23			public function __construct(array $args = [])
24			{
25			if (\count($args) > 0) {
26			if (\is_string(key($args))) {
27			$this->fields(array_keys($args));
28			}
29			$this->values(array_values($args));
30			}
31			}
32
33			public function fields(array $fields): Insert
34			{
35			$this->fields = $fields;
36			return $this;
37			}
38
39			public function values(array $values): Insert
40			{
41			$this->values[] = $this->set($values);
42			return $this;
43			}
44
45			protected function preSet(array $values, string $flag): array
46			{
47			$result = [];
48			foreach ($values as $value) {
49			$key = $this->uid($flag);
50			$result[] = ':' . $key;
51			$this->placeholders()->set($key, $value);
52			}
53			return $result;
54			}
55
56			protected function set(array $values): string
57			{
58			return '(' . $this->concat($this->preSet($values, 'i')) . ')';
59			}
60
61			protected function get(): string
62			{
63			$this->addPlaceholders($this->placeholders()->get());
64			return 'INSERT INTO ' . $this->table() . ' '
65			. '(' . $this->concat($this->escapeField($this->fields)) . ')'
			0 ignored issues – show Bug introduced 2018-01-24 21:10 UTC by Report Bug Copy Issue Report It seems like `$this->escapeField($this->fields)` targeting `Compolomus\LSQLQueryBuil...s\Helper::escapeField()` can also be of type `string`; however, `Compolomus\LSQLQueryBuil...Traits\Helper::concat()` does only seem to accept `array`, maybe add an additional type check? This check looks at variables that are passed out again to other methods. If the outgoing method call has stricter type requirements than the method itself, an issue is raised. An additional type check may prevent trouble. Loading history...
66			. ' VALUES '
67			. (\count($this->values)
68			? $this->concat($this->values)
69			: '(' . $this->concat(array_fill(0, \count($this->fields), '?')) . ')'
70			);
71			}
72			}
73

Compolomus / SQLQueryBuilder

Insert::preSet() A last analyzed 2018-05-09 04:13 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Insert::preSet() A
last analyzed 2018-05-09 04:13 UTC