InsertQuery::build() - Code Metrics - Inspection of "moved PDO operations into Operations namespace wit..." - jaredtking/jaqb - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( d8c240...9dd0a9 )

by Jared

created 2015-12-05 18:05 UTC

InsertQuery::build() A

↳ Parent: InsertQuery

Complexity

Conditions	1
Paths	1

Size

Total Lines	12
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	3
Bugs	0	Features	0

Metric	Value
c	3
b	0
f	0
dl	0
loc	12
rs	9.4286
cc	1
eloc	7
nc	1
nop	0

<?php

/**
 * @author Jared King <[email protected]>
 *
 * @link http://jaredtking.com
 *
 * @copyright 2015 Jared King
 * @license MIT
 */
namespace JAQB\Query;

use JAQB\Operations\Executable;
use JAQB\Statement\FromStatement;
use JAQB\Statement\ValuesStatement;

class InsertQuery extends Query
{
    use Executable;

    /**
     * @var FromStatement
     */
    protected $table;

    /**
     * @var ValuesStatement
     */
    protected $insertValues;

    /**
     * @var array
     */
    protected $values = [];

    public function __construct()
    {
        $this->table = new FromStatement(false);
        $this->insertValues = new ValuesStatement();
    }

    /**
     * Sets the table for the query.
     *
     * @param string $table table name
     *
     * @return self
     */
    public function into($table)
    {
        $this->table->addTable($table);

        return $this;
    }

    /**
     * Sets the values for the query.
     *
     * @param array $values
     *
     * @return self
     */
    public function values(array $values)
    {
        $this->insertValues->addValues($values);

        return $this;
    }

    /**
     * Gets the table for the query.
     *
     * @return string
     */
    public function getInto()
    {
        return $this->table;
    }

    /**
     * Gets the insert values for the query.
     *
     * @return InsertStatement
     */
    public function getInsertValues()
    {
        return $this->insertValues;
    }

    /**
     * Generates the raw SQL string for the query.
     *
     * @return string
     */
    public function build()
    {
        $sql = [
            'INSERT INTO',
            $this->table->build(),
            $this->insertValues->build(),
        ];

        $this->values = array_values($this->insertValues->getValues());

        return implode(' ', array_filter($sql));
    }
}


1			<?php
2
3			/**
4			* @author Jared King <[email protected]>
5			*
6			* @link http://jaredtking.com
7			*
8			* @copyright 2015 Jared King
9			* @license MIT
10			*/
11			namespace JAQB\Query;
12
13			use JAQB\Operations\Executable;
14			use JAQB\Statement\FromStatement;
15			use JAQB\Statement\ValuesStatement;
16
17			class InsertQuery extends Query
18			{
19			use Executable;
20
21			/**
22			* @var FromStatement
23			*/
24			protected $table;
25
26			/**
27			* @var ValuesStatement
28			*/
29			protected $insertValues;
30
31			/**
32			* @var array
33			*/
34			protected $values = [];
35
36			public function __construct()
37			{
38			$this->table = new FromStatement(false);
39			$this->insertValues = new ValuesStatement();
40			}
41
42			/**
43			* Sets the table for the query.
44			*
45			* @param string $table table name
46			*
47			* @return self
48			*/
49			public function into($table)
50			{
51			$this->table->addTable($table);
52
53			return $this;
54			}
55
56			/**
57			* Sets the values for the query.
58			*
59			* @param array $values
60			*
61			* @return self
62			*/
63			public function values(array $values)
64			{
65			$this->insertValues->addValues($values);
66
67			return $this;
68			}
69
70			/**
71			* Gets the table for the query.
72			*
73			* @return string
74			*/
75			public function getInto()
76			{
77			return $this->table;
78			}
79
80			/**
81			* Gets the insert values for the query.
82			*
83			* @return InsertStatement
84			*/
85			public function getInsertValues()
86			{
87			return $this->insertValues;
88			}
89
90			/**
91			* Generates the raw SQL string for the query.
92			*
93			* @return string
94			*/
95			public function build()
96			{
97			$sql = [
98			'INSERT INTO',
99			$this->table->build(),
100			$this->insertValues->build(),
101			];
102
103			$this->values = array_values($this->insertValues->getValues());
104
105			return implode(' ', array_filter($sql));
106			}
107			}
108

jaredtking / jaqb

Push — master ( d8c240...9dd0a9 )

InsertQuery::build() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like