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; 24 25/** 26 * Database abstraction 27 */ 28class DB extends Manager 29{ 30 /** 31 * @internal 32 */ 33 public static function caseInsensitiveLikeOperator(): string 34 { 35 if (DB::connection()->getDriverName() === 'pgsql') { 36 return 'ILIKE'; 37 } 38 39 if (DB::connection()->getDriverName() === 'sqlsrv') { 40 return 'COLLATE SQL_UTF8_General_CI_AI LIKE'; 41 } 42 43 return 'LIKE'; 44 } 45 46 /** 47 * @internal 48 */ 49 public static function groupConcat(string $column): string 50 { 51 switch (DB::connection()->getDriverName()) { 52 case 'pgsql': 53 case 'sqlsrv': 54 return 'STRING_AGG(' . $column . ", ',')"; 55 56 case 'mysql': 57 case 'sqlite': 58 default: 59 return 'GROUP_CONCAT(' . $column . ')'; 60 } 61 } 62 63 /** 64 * PHPSTAN can't detect the magic methods in the parent class. 65 */ 66 public static function query(): Builder 67 { 68 return self::connection()->query(); 69 } 70} 71