DB::groupConcat() - Code Metrics - Inspection of "Fix: #4683 - Database agnostic support for GROUP_C..." - fisharebest/webtrees - Measure and Improve Code Quality continuously with Scrutinizer

Passed

Push — main ( 194292...859d33 )

by Greg

created 2023-12-31 23:19 UTC

DB::groupConcat() A

↳ Parent: DB

Complexity

Conditions	5
Paths	5

Size

Total Lines	11
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	8
nc	5
nop	1
dl	0
loc	11
rs	9.6111
c	0
b	0
f	0

<?php

/**
 * webtrees: online genealogy
 * Copyright (C) 2023 webtrees development team
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 * This program is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
 * GNU General Public License for more details.
 * You should have received a copy of the GNU General Public License
 * along with this program. If not, see <https://www.gnu.org/licenses/>.
 */

declare(strict_types=1);

namespace Fisharebest\Webtrees;

use Illuminate\Database\Capsule\Manager;

/**
 * Database abstraction
 */
class DB extends Manager
{
    /**
     * @internal
     */
    public static function caseInsensitiveLikeOperator(): string
    {
        if (DB::connection()->getDriverName() === 'pgsql') {
            return 'ILIKE';
        }

        if (DB::connection()->getDriverName() === 'sqlsrv') {
            return 'COLLATE SQL_UTF8_General_CI_AI LIKE';
        }

        return 'LIKE';
    }

    /**
     * @internal
     */
    public static function groupConcat(string $column): string
    {
        switch (DB::connection()->getDriverName()) {
            case 'pgsql':
            case 'sqlsrv':
                return 'STRING_AGG(' . $column . ", ',')";

            case 'mysql':
            case 'sqlite':
            default:
                return 'GROUP_CONCAT(' . $column . ')';
        }
    }
}


1			<?php
2
3			/**
4			* webtrees: online genealogy
5			* Copyright (C) 2023 webtrees development team
6			* This program is free software: you can redistribute it and/or modify
7			* it under the terms of the GNU General Public License as published by
8			* the Free Software Foundation, either version 3 of the License, or
9			* (at your option) any later version.
10			* This program is distributed in the hope that it will be useful,
11			* but WITHOUT ANY WARRANTY; without even the implied warranty of
12			* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
13			* GNU General Public License for more details.
14			* You should have received a copy of the GNU General Public License
15			* along with this program. If not, see <https://www.gnu.org/licenses/>.
16			*/
17
18			declare(strict_types=1);
19
20			namespace Fisharebest\Webtrees;
21
22			use Illuminate\Database\Capsule\Manager;
23
24			/**
25			* Database abstraction
26			*/
27			class DB extends Manager
28			{
29			/**
30			* @internal
31			*/
32			public static function caseInsensitiveLikeOperator(): string
33			{
34			if (DB::connection()->getDriverName() === 'pgsql') {
35			return 'ILIKE';
36			}
37
38			if (DB::connection()->getDriverName() === 'sqlsrv') {
39			return 'COLLATE SQL_UTF8_General_CI_AI LIKE';
40			}
41
42			return 'LIKE';
43			}
44
45			/**
46			* @internal
47			*/
48			public static function groupConcat(string $column): string
49			{
50			switch (DB::connection()->getDriverName()) {
51			case 'pgsql':
52			case 'sqlsrv':
53			return 'STRING_AGG(' . $column . ", ',')";
54
55			case 'mysql':
56			case 'sqlite':
57			default:
58			return 'GROUP_CONCAT(' . $column . ')';
59			}
60			}
61			}
62

fisharebest / webtrees

Push — main ( 194292...859d33 )

DB::groupConcat() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like