Select::lateralJoinSubSelect() - Code Metrics - Inspection of "Add lateral joins" - auraphp/Aura.SqlQuery - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — 3.x (#184)

unknown

created 2021-05-02 10:23 UTC

Select::lateralJoinSubSelect() A

↳ Parent: Select

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	12
ccs	0
cts	8
cp	0
rs	9.8666
c	0
b	0
f	0
cc	1
nc	1
nop	5
crap	2

<?php
/**
 *
 * This file is part of Aura for PHP.
 *
 * @license http://opensource.org/licenses/mit-license.php MIT
 *
 */
namespace Aura\SqlQuery\Pgsql;

use Aura\SqlQuery\Common;

/**
 *
 * An object for PgSQL SELECT queries.
 *
 * @package Aura.SqlQuery
 *
 */
class Select extends Common\Select
{
    /**
     *
     * Adds a LATERAL JOIN to an aliased subselect and columns to the query.
     *
     * @param string $join The join type: inner, left, natural, etc.
     *
     * @param string|Select $spec If a Select
     * object, use as the sub-select; if a string, the sub-select
     * command string.
     *
     * @param string $name The alias name for the sub-select.
     *
     * @param string $cond Join on this condition.
     *
     * @param array $bind Values to bind to ?-placeholders in the condition.
     *
     * @return $this
     *
     * @throws Exception
     *
     */
    public function lateralJoinSubSelect($join, $spec, $name, $cond = null, array $bind = array())
    {
        $join = strtoupper(ltrim("$join JOIN LATERAL"));
        $this->addTableRef("$join (SELECT ...) AS", $name);

        $spec = $this->subSelect($spec, '            ');
        $name = $this->quoter->quoteName($name);
        $cond = $this->fixJoinCondition($cond, $bind);

        $text = rtrim("$join ($spec        ) $name $cond");
        return $this->addJoin('        ' . $text);
    }
}


1			<?php
2			/**
3			*
4			* This file is part of Aura for PHP.
5			*
6			* @license http://opensource.org/licenses/mit-license.php MIT
7			*
8			*/
9			namespace Aura\SqlQuery\Pgsql;
10
11			use Aura\SqlQuery\Common;
12
13			/**
14			*
15			* An object for PgSQL SELECT queries.
16			*
17			* @package Aura.SqlQuery
18			*
19			*/
20			class Select extends Common\Select
21			{
22			/**
23			*
24			* Adds a LATERAL JOIN to an aliased subselect and columns to the query.
25			*
26			* @param string $join The join type: inner, left, natural, etc.
27			*
28			* @param string\|Select $spec If a Select
29			* object, use as the sub-select; if a string, the sub-select
30			* command string.
31			*
32			* @param string $name The alias name for the sub-select.
33			*
34			* @param string $cond Join on this condition.
35			*
36			* @param array $bind Values to bind to ?-placeholders in the condition.
37			*
38			* @return $this
39			*
40			* @throws Exception
41			*
42			*/
43			public function lateralJoinSubSelect($join, $spec, $name, $cond = null, array $bind = array())
44			{
45			$join = strtoupper(ltrim("$join JOIN LATERAL"));
46			$this->addTableRef("$join (SELECT ...) AS", $name);
47
48			$spec = $this->subSelect($spec, ' ');
49			$name = $this->quoter->quoteName($name);
50			$cond = $this->fixJoinCondition($cond, $bind);
51
52			$text = rtrim("$join ($spec ) $name $cond");
53			return $this->addJoin(' ' . $text);
54			}
55			}
56

auraphp / Aura.SqlQuery

Pull Request — 3.x (#184)

Select::lateralJoinSubSelect() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like