xref: /webtrees/app/DB.php (revision 211018ab9ab6a5da13d161c40032525dfebcd13f) 
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
18declare(strict_types=1);
19
20namespace Fisharebest\Webtrees;
21
22use Illuminate\Database\Capsule\Manager;
23use Illuminate\Database\Query\Builder;
24use PDO;
25
26/**
27 * Database abstraction
28 */
29class DB extends Manager
30{
31    public static function driverName(): string
32    {
33        return parent::connection()->getPdo()->getAttribute(PDO::ATTR_DRIVER_NAME);
34    }
35
36    public static function prefix(string $identifier = ''): string
37    {
38        return parent::connection()->getTablePrefix() . $identifier;
39    }
40
41    /**
42     * @internal
43     */
44    public static function caseInsensitiveLikeOperator(): string
45    {
46        if (self::driverName() === 'pgsql') {
47            return 'ILIKE';
48        }
49
50        if (self::driverName() === 'sqlsrv') {
51            return 'COLLATE SQL_UTF8_General_CI_AI LIKE';
52        }
53
54        return 'LIKE';
55    }
56
57    /**
58     * @internal
59     */
60    public static function groupConcat(string $column): string
61    {
62        switch (self::driverName()) {
63            case 'pgsql':
64            case 'sqlsrv':
65                return 'STRING_AGG(' . $column . ", ',')";
66
67            case 'mysql':
68            case 'sqlite':
69            default:
70                return 'GROUP_CONCAT(' . $column . ')';
71        }
72    }
73
74    /**
75     * PHPSTAN can't detect the magic methods in the parent class.
76     */
77    public static function query(): Builder
78    {
79        return parent::connection()->query();
80    }
81}
82