<?php

namespace Doctrine\Tests\DBAL\Driver;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Driver\AbstractMySQLDriver;
use Doctrine\DBAL\Platforms\MariaDb1027Platform;
use Doctrine\DBAL\Platforms\MySQL57Platform;
use Doctrine\DBAL\Platforms\MySQL80Platform;
use Doctrine\DBAL\Platforms\MySqlPlatform;
use Doctrine\DBAL\Schema\MySqlSchemaManager;
use Doctrine\Tests\Mocks\DriverResultStatementMock;

class AbstractMySQLDriverTest extends AbstractDriverTest
{
    public function testReturnsDatabaseName()
    {
        parent::testReturnsDatabaseName();

        $database = 'bloo';
        $params   = [
            'user'     => 'foo',
            'password' => 'bar',
        ];

        $statement = $this->createMock(DriverResultStatementMock::class);

        $statement->expects($this->once())
            ->method('fetchColumn')
            ->will($this->returnValue($database));

        $connection = $this->getConnectionMock();

        $connection->expects($this->once())
            ->method('getParams')
            ->will($this->returnValue($params));

        $connection->expects($this->once())
            ->method('query')
            ->will($this->returnValue($statement));

        self::assertSame($database, $this->driver->getDatabase($connection));
    }

    protected function createDriver()
    {
        return $this->getMockForAbstractClass(AbstractMySQLDriver::class);
    }

    protected function createPlatform()
    {
        return new MySqlPlatform();
    }

    protected function createSchemaManager(Connection $connection)
    {
        return new MySqlSchemaManager($connection);
    }

    /**
     * @return mixed[][]
     */
    protected function getDatabasePlatformsForVersions() : array
    {
        return [
            ['5.6.9', MySqlPlatform::class],
            ['5.7', MySQL57Platform::class],
            ['5.7.0', MySqlPlatform::class],
            ['5.7.8', MySqlPlatform::class],
            ['5.7.9', MySQL57Platform::class],
            ['5.7.10', MySQL57Platform::class],
            ['8', MySQL80Platform::class],
            ['8.0', MySQL80Platform::class],
            ['8.0.11', MySQL80Platform::class],
            ['6', MySQL57Platform::class],
            ['10.0.15-MariaDB-1~wheezy', MySqlPlatform::class],
            ['5.5.5-10.1.25-MariaDB', MySqlPlatform::class],
            ['10.1.2a-MariaDB-a1~lenny-log', MySqlPlatform::class],
            ['5.5.40-MariaDB-1~wheezy', MySqlPlatform::class],
            ['5.5.5-MariaDB-10.2.8+maria~xenial-log', MariaDb1027Platform::class],
            ['10.2.8-MariaDB-10.2.8+maria~xenial-log', MariaDb1027Platform::class],
            ['10.2.8-MariaDB-1~lenny-log', MariaDb1027Platform::class],
        ];
    }

    protected function getExceptionConversionData()
    {
        return [
            self::EXCEPTION_CONNECTION => [
                ['1044', null, null],
                ['1045', null, null],
                ['1046', null, null],
                ['1049', null, null],
                ['1095', null, null],
                ['1142', null, null],
                ['1143', null, null],
                ['1227', null, null],
                ['1370', null, null],
                ['2002', null, null],
                ['2005', null, null],
            ],
            self::EXCEPTION_FOREIGN_KEY_CONSTRAINT_VIOLATION => [
                ['1216', null, null],
                ['1217', null, null],
                ['1451', null, null],
                ['1452', null, null],
            ],
            self::EXCEPTION_INVALID_FIELD_NAME => [
                ['1054', null, null],
                ['1166', null, null],
                ['1611', null, null],
            ],
            self::EXCEPTION_NON_UNIQUE_FIELD_NAME => [
                ['1052', null, null],
                ['1060', null, null],
                ['1110', null, null],
            ],
            self::EXCEPTION_NOT_NULL_CONSTRAINT_VIOLATION => [
                ['1048', null, null],
                ['1121', null, null],
                ['1138', null, null],
                ['1171', null, null],
                ['1252', null, null],
                ['1263', null, null],
                ['1364', null, null],
                ['1566', null, null],
            ],
            self::EXCEPTION_SYNTAX_ERROR => [
                ['1064', null, null],
                ['1149', null, null],
                ['1287', null, null],
                ['1341', null, null],
                ['1342', null, null],
                ['1343', null, null],
                ['1344', null, null],
                ['1382', null, null],
                ['1479', null, null],
                ['1541', null, null],
                ['1554', null, null],
                ['1626', null, null],
            ],
            self::EXCEPTION_TABLE_EXISTS => [
                ['1050', null, null],
            ],
            self::EXCEPTION_TABLE_NOT_FOUND => [
                ['1051', null, null],
                ['1146', null, null],
            ],
            self::EXCEPTION_UNIQUE_CONSTRAINT_VIOLATION => [
                ['1062', null, null],
                ['1557', null, null],
                ['1569', null, null],
                ['1586', null, null],
            ],
            self::EXCEPTION_DEADLOCK => [
                ['1213', null, null],
            ],
            self::EXCEPTION_LOCK_WAIT_TIMEOUT => [
                ['1205', null, null],
            ],
        ];
    }
}