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:09 UTC

InsertBuilder::buildValuesForBulkInsert() A

↳ Parent: InsertBuilder

Complexity

Conditions	2
Paths	2

Size

Total Lines	11
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	11
rs	9.4285
c	0
b	0
f	0
cc	2
eloc	8
nc	2
nop	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			public function buildInto($into)
15			{
16			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			public function buildValuesForInsert($col_values)
28			{
29			return ' ('
30			. $this->indentCsv(array_keys($col_values))
31			. PHP_EOL . ') VALUES ('
32			. $this->indentCsv(array_values($col_values))
33			. PHP_EOL . ')';
34			}
35
36			/**
37			*
38			* Builds the bulk-inserted columns and values of the statement.
39			*
40			* @return string
41			*
42			*/
43			public function buildValuesForBulkInsert($col_order, $col_values_bulk)
44			{
45			$cols = " (" . implode(', ', $col_order) . ")";
46			$vals = array();
47			foreach ($col_values_bulk as $row_values) {
48			$vals[] = " (" . implode(', ', $row_values) . ")";
49			}
50			return PHP_EOL . $cols . PHP_EOL
51			. "VALUES" . PHP_EOL
52			. implode("," . PHP_EOL, $vals);
53			}
54			}
55

auraphp / Aura.SqlQuery

Pull Request — 3.x (#131)

InsertBuilder::buildValuesForBulkInsert() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like