Insert::getSql() - Code Metrics - Inspection of "Merge pull request #474 from bluzphp/develop" - bluzphp/framework - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( e47c19...3aaaf2 )

by Anton

created 2021-07-05 13:03 UTC

Insert::getSql() A

↳ Parent: Insert

Complexity

Conditions	1
Paths	1

Size

Total Lines	5
Code Lines	3

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	3
CRAP Score	1

Importance

Changes

Metric	Value
cc	1
eloc	3
nc	1
nop	0
dl	0
loc	5
ccs	3
cts	3
cp	1
crap	1
rs	10
c	0
b	0
f	0

<?php

/**
 * Bluz Framework Component
 *
 * @copyright Bluz PHP Team
 * @link      https://github.com/bluzphp/framework
 */

declare(strict_types=1);

namespace Bluz\Db\Query;

use Bluz\Proxy\Db;

/**
 * Builder of INSERT queries
 *
 * @package Bluz\Db\Query
 */
class Insert extends AbstractBuilder
{
    use Traits\Set;

    /**
     * @var string Table name
     */
    protected $table;

    /**
     * {@inheritdoc}
     *
     * @param  null $sequence

     *
     * @return integer|string|array
     */
    public function execute($sequence = null)
    {
        $result = Db::query($this->getSql(), $this->params, $this->types);
        if ($result) {
            return Db::handler()->lastInsertId($sequence);
        }
        return $result;
    }

    /**
     * {@inheritdoc}
     *
     * @return string
     */
    public function getSql(): string
    {
        return 'INSERT INTO '
            . Db::quoteIdentifier($this->table)
            . $this->prepareSet();
    }

    /**
     * Turns the query being built into an insert query that inserts into
     * a certain table
     *
     * Example
     * <code>
     *     $ib = new InsertBuilder();
     *     $ib
     *         ->insert('users')
     *         ->set('name', 'username')
     *         ->set('password', md5('password'));
     * </code>
     *
     * @param  string $table The table into which the rows should be inserted
     *
     * @return Insert instance
     */
    public function insert($table): Insert
    {
        $this->table = $table;
        return $this;
    }
}


1		<?php
2
3		/**
4		* Bluz Framework Component
5		*
6		* @copyright Bluz PHP Team
7		* @link https://github.com/bluzphp/framework
8		*/
9
10		declare(strict_types=1);
11
12		namespace Bluz\Db\Query;
13
14		use Bluz\Proxy\Db;
15
16		/**
17		* Builder of INSERT queries
18		*
19		* @package Bluz\Db\Query
20		*/
21		class Insert extends AbstractBuilder
22		{
23		use Traits\Set;
24
25		/**
26		* @var string Table name
27		*/
28		protected $table;
29
30		/**
31		* {@inheritdoc}
32		*
33		* @param null $sequence
		0 ignored issues – show Documentation Bug introduced 2019-02-08 10:45 UTC by Report Bug Copy Issue Report Are you sure the doc-type for parameter `$sequence` is correct as it would always require `null` to be passed? Loading history...
34		*
35		* @return integer\|string\|array
36		*/
37	1	public function execute($sequence = null)
38		{
39	1	$result = Db::query($this->getSql(), $this->params, $this->types);
40	1	if ($result) {
41	1	return Db::handler()->lastInsertId($sequence);
42		}
43		return $result;
44		}
45
46		/**
47		* {@inheritdoc}
48		*
49		* @return string
50		*/
51	1	public function getSql(): string
52		{
53		return 'INSERT INTO '
54	1	. Db::quoteIdentifier($this->table)
55	1	. $this->prepareSet();
56		}
57
58		/**
59		* Turns the query being built into an insert query that inserts into
60		* a certain table
61		*
62		* Example
63		* <code>
64		* $ib = new InsertBuilder();
65		* $ib
66		* ->insert('users')
67		* ->set('name', 'username')
68		* ->set('password', md5('password'));
69		* </code>
70		*
71		* @param string $table The table into which the rows should be inserted
72		*
73		* @return Insert instance
74		*/
75	2	public function insert($table): Insert
76		{
77	2	$this->table = $table;
78	2	return $this;
79		}
80		}
81

bluzphp / framework

Push — master ( e47c19...3aaaf2 )

Insert::getSql() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like