AlterDatabaseQuery.php

<?php

/**
 * Copyright (C) GrizzIT, Inc. All rights reserved.
 * See LICENSE for license details.
 */

namespace Ulrack\Dbal\Sql\Component\Query\Database;

use Ulrack\Dbal\Common\QueryInterface;

class AlterDatabaseQuery implements QueryInterface
{
    /**
     * The database which is being altered.
     *
     * @var string
     */
    private $database;

    /**
     * Contains the charset which is used to alter the database.
     *
     * @var string
     */
    private $charset;

    /**
     * Contains the collation which is used to alter the database.
     *
     * @var string
     */
    private $collate;

    /**
     * Constructor
     *
     * @param string $database
     * @param string $charset
     * @param string $collate
     */
    public function __construct(
        string $database,
        string $charset = 'utf8mb4',
        string $collate = 'utf8mb4_unicode_ci'
    ) {
        $this->database = $database;
        $this->charset  = $charset;
        $this->collate  = $collate;
    }

    /**
     * Builds the query and returns it.
     *
     * @return string
     */
    public function getQuery(): string
    {
        return sprintf(
            'ALTER DATABASE %s CHARACTER SET %s COLLATE %s;',
            $this->database,
            $this->charset,
            $this->collate
        );
    }
}