InsertBuilder::buildValuesForBulkInsert() - Code Metrics - Inspection of "Extract builder logic to separate classes" - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 3.x (#131)

by Paul

created 2017-03-18 15:17 UTC

InsertBuilder::buildValuesForBulkInsert() A

↳ Parent: InsertBuilder

Complexity

Conditions	2
Paths	2

Size

Total Lines	11
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	8
CRAP Score	2

Importance

Changes

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

<?php
namespace Aura\SqlQuery\Common;

class InsertBuilder extends AbstractBuilder
{

    /**
     *
     * Builds the INTO clause.
     *
     * @return string
     *
     */
    public function buildInto($into)
    {
        return " INTO {$into}";
    }


    /**
     *
     * Builds the inserted columns and values of the statement.
     *
     * @return string
     *
     */
    public function buildValuesForInsert($col_values)
    {
        return ' ('
            . $this->indentCsv(array_keys($col_values))
            . PHP_EOL . ') VALUES ('
            . $this->indentCsv(array_values($col_values))
            . PHP_EOL . ')';
    }

    /**
     *
     * Builds the bulk-inserted columns and values of the statement.
     *
     * @return string
     *
     */
    public function buildValuesForBulkInsert($col_order, $col_values_bulk)
    {
        $cols = "    (" . implode(', ', $col_order) . ")";
        $vals = array();
        foreach ($col_values_bulk as $row_values) {
            $vals[] = "    (" . implode(', ', $row_values) . ")";
        }
        return PHP_EOL . $cols . PHP_EOL
            . "VALUES" . PHP_EOL
            . implode("," . PHP_EOL, $vals);
    }
}


1		<?php
2		namespace Aura\SqlQuery\Common;
3
4		class InsertBuilder extends AbstractBuilder
5		{
6
7		/**
8		*
9		* Builds the INTO clause.
10		*
11		* @return string
12		*
13		*/
14	42	public function buildInto($into)
15		{
16	42	return " INTO {$into}";
17		}
18
19
20		/**
21		*
22		* Builds the inserted columns and values of the statement.
23		*
24		* @return string
25		*
26		*/
27	22	public function buildValuesForInsert($col_values)
28		{
29		return ' ('
30	22	. $this->indentCsv(array_keys($col_values))
31	22	. PHP_EOL . ') VALUES ('
32	22	. $this->indentCsv(array_values($col_values))
33	22	. PHP_EOL . ')';
34		}
35
36		/**
37		*
38		* Builds the bulk-inserted columns and values of the statement.
39		*
40		* @return string
41		*
42		*/
43	20	public function buildValuesForBulkInsert($col_order, $col_values_bulk)
44		{
45	20	$cols = " (" . implode(', ', $col_order) . ")";
46	20	$vals = array();
47	20	foreach ($col_values_bulk as $row_values) {
48	20	$vals[] = " (" . implode(', ', $row_values) . ")";
49		}
50	20	return PHP_EOL . $cols . PHP_EOL
51	20	. "VALUES" . PHP_EOL
52	20	. implode("," . PHP_EOL, $vals);
53		}
54		}
55

auraphp / Aura.SqlQuery

Pull Request — 3.x (#131)

InsertBuilder::buildValuesForBulkInsert() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like