SqliteCompiler::_buildUnionPart() - Code Metrics - lampager/lampager-cakephp - Measure and Improve Code Quality continuously with Scrutinizer

SqliteCompiler::_buildUnionPart() A
last analyzed 2025-01-08 18:05 UTC

↳ Parent: SqliteCompiler

Complexity

Conditions	3
Paths	1

Size

Total Lines	10
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

<?php

declare(strict_types=1);

namespace Lampager\Cake\Database;

use Cake\Database\Query;
use Cake\Database\QueryCompiler;
use Cake\Database\ValueBinder;

class SqliteCompiler extends QueryCompiler
{
    /**
     * {@inheritdoc}
     */
    protected function _buildSelectPart(array $parts, Query $query, ValueBinder $generator): string
    {
        if (!$query->clause('union')) {
            return parent::_buildSelectPart($parts, $query, $generator);
        }

        return sprintf('SELECT * FROM (%s', parent::_buildSelectPart($parts, $query, $generator));
    }

    /**
     * {@inheritdoc}
     */
    protected function _buildUnionPart(array $parts, Query $query, ValueBinder $generator): string
    {
        $parts = array_map(function ($p) use ($generator) {
            $p['query'] = $p['query']->sql($generator);
            $p['query'] = $p['query'][0] === '(' ? trim($p['query'], '()') : $p['query'];
            $prefix = $p['all'] ? 'ALL ' : '';
            return sprintf('%sSELECT * FROM (%s)', $prefix, $p['query']);
        }, $parts);

        return sprintf(")\nUNION %s", implode("\nUNION ", $parts));
    }
}


1			<?php
2
3			declare(strict_types=1);
4
5			namespace Lampager\Cake\Database;
6
7			use Cake\Database\Query;
8			use Cake\Database\QueryCompiler;
9			use Cake\Database\ValueBinder;
10
11			class SqliteCompiler extends QueryCompiler
12			{
13			/**
14			* {@inheritdoc}
15			*/
16			protected function _buildSelectPart(array $parts, Query $query, ValueBinder $generator): string
17			{
18			if (!$query->clause('union')) {
19			return parent::_buildSelectPart($parts, $query, $generator);
20			}
21
22			return sprintf('SELECT * FROM (%s', parent::_buildSelectPart($parts, $query, $generator));
23			}
24
25			/**
26			* {@inheritdoc}
27			*/
28			protected function _buildUnionPart(array $parts, Query $query, ValueBinder $generator): string
29			{
30			$parts = array_map(function ($p) use ($generator) {
31			$p['query'] = $p['query']->sql($generator);
32			$p['query'] = $p['query'][0] === '(' ? trim($p['query'], '()') : $p['query'];
33			$prefix = $p['all'] ? 'ALL ' : '';
34			return sprintf('%sSELECT * FROM (%s)', $prefix, $p['query']);
35			}, $parts);
36
37			return sprintf(")\nUNION %s", implode("\nUNION ", $parts));
38			}
39			}
40

lampager / lampager-cakephp

SqliteCompiler::_buildUnionPart() A last analyzed 2025-01-08 18:05 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

SqliteCompiler::_buildUnionPart() A
last analyzed 2025-01-08 18:05 UTC