xref: /webtrees/app/DB.php (revision 9badd096d9148e35d78c02b153425bd6a3c84022) 
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;
23
24/**
25 * Database abstraction
26 */
27class 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