Update::assemble() - Code Metrics - Inspection of "update to application interface" - bytic/database - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — master ( bab9dc...bf7b05 )

by Gabriel

created 2019-05-10 10:55 UTC

Update::assemble() A

↳ Parent: Update

Complexity

Conditions	1
Paths	1

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes

Metric	Value
dl	0
loc	9
ccs	0
cts	5
cp	0
rs	9.9666
c	0
b	0
f	0
cc	1
nc	1
nop	0
crap	2

<?php

namespace Nip\Database\Query;

/**
 * Class Update
 * @package Nip\Database\Query
 */
class Update extends AbstractQuery
{

    /**
     * @return string
     */
    public function assemble()
    {
        $query = "UPDATE {$this->protect($this->getTable())} SET {$this->parseUpdate()}";

        $query .= $this->assembleWhere();
        $query .= $this->assembleLimit();

        return $query;
    }

    /**
     * @return bool|string
     */
    public function parseUpdate()
    {
        if (!$this->parts['data']) {
            return false;
        }
        $fields = [];
        foreach ($this->parts['data'] as $data) {
            foreach ($data as $key => $values) {
                if (!is_array($values)) {
                    $values = [$values];
                }
                $value = $values[0];
                $quote = isset($values[1]) ? $values[1] : null;

                if (!is_numeric($value)) {
                    if (is_null($quote)) {
                        $quote = true;
                    }
                    if ($quote) {
                        $value = $this->getManager()->getAdapter()->quote($value);
                    }
                }

                $fields[] = "{$this->protect($key)} = $value";
            }
        }

        return implode(", ", $fields);
    }
}


1		<?php
2
3		namespace Nip\Database\Query;
4
5		/**
6		* Class Update
7		* @package Nip\Database\Query
8		*/
9		class Update extends AbstractQuery
10		{
11
12		/**
13		* @return string
14		*/
15		public function assemble()
16		{
17		$query = "UPDATE {$this->protect($this->getTable())} SET {$this->parseUpdate()}";
18
19		$query .= $this->assembleWhere();
20		$query .= $this->assembleLimit();
21
22		return $query;
23		}
24
25		/**
26		* @return bool\|string
27		*/
28	1	public function parseUpdate()
29		{
30	1	if (!$this->parts['data']) {
31		return false;
32		}
33	1	$fields = [];
34	1	foreach ($this->parts['data'] as $data) {
35	1	foreach ($data as $key => $values) {
36	1	if (!is_array($values)) {
37		$values = [$values];
38		}
39	1	$value = $values[0];
40	1	$quote = isset($values[1]) ? $values[1] : null;
41
42	1	if (!is_numeric($value)) {
43	1	if (is_null($quote)) {
44		$quote = true;
45		}
46	1	if ($quote) {
47		$value = $this->getManager()->getAdapter()->quote($value);
48		}
49		}
50
51	1	$fields[] = "{$this->protect($key)} = $value";
52		}
53		}
54
55	1	return implode(", ", $fields);
56		}
57		}
58

bytic / database

Push — master ( bab9dc...bf7b05 )

Update::assemble() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like