src/Drivers/MySQL.php - master - jagepard/Rudra-Model

src/Drivers/MySQL.php
69 строк2 KB
Jagepard
Add DISTINCT to groupConcat (PG/SQLite untested)
29 июл 2026, 14:33
29 июл 2026, 14:33759d29c
<?php declare(strict_types=1);

/**
 * This Source Code Form is subject to the terms of the Mozilla Public
 * License, v. 2.0. If a copy of the MPL was not distributed with this
 * file, You can obtain one at https://mozilla.org/MPL/2.0/.
 *
 * @author  Korotkov Danila (Jagepard) <jagepard@yandex.ru>
 * @license https://mozilla.org/MPL/2.0/  MPL-2.0
 */

namespace Rudra\Model\Drivers;

use Rudra\Model\Interfaces\SqlDialectInterface;

class MySQL implements SqlDialectInterface
{
    #[\Override]
    public function groupConcat(string $fieldName, string $alias, ?string $orderBy, bool $distinct = true): string
    {
        $distinctStr = $distinct ? 'DISTINCT ' : '';
        return ", GROUP_CONCAT({$distinctStr}$fieldName ORDER BY $orderBy SEPARATOR ';') as $alias  ";  
    }

    #[\Override]
    public function close(): string
    {
        return ") ENGINE = InnoDB";
    }

    #[\Override]
    public function integer(string $field, string $default = "", bool $autoincrement = false, string $null = "NOT NULL"): string
    {
        if ($autoincrement) {
            return "`$field` INT $null AUTO_INCREMENT $default";
        }

        return ", `$field` INT $null $default";
    }

    #[\Override]
    public function string(string $field, string $default = "", string $null = "NOT NULL"): string
    {
        return ", `$field` VARCHAR(255) $null $default";
    }

    #[\Override]
    public function text(string $field, string $null = "NOT NULL"): string
    {
        return ", `$field` text $null";
    }

    #[\Override]
    public function createdAt(): string
    {
        return ", `created_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP";
    }

    #[\Override]
    public function updatedAt(): string
    {
        return ", `updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP";
    }

    public function primaryKey(string $field): string
    {
        return ", PRIMARY KEY (`$field`)";
    }
}