Doctrine\DBAL\Driver\AbstractMySQLDriver

Complexity

Total Complexity

69

Size/Duplication

Total Lines	185
Duplicated Lines	5.41 %

Coupling/Cohesion

Components	0
Dependencies	20

Test Coverage

Coverage

97.12%

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
D	convertException()	0	78	53
A	getDatabase()	10	10	2
A	getDatabasePlatform()	0	4	1
A	getSchemaManager()	0	4	1
C	createDatabasePlatformForVersion()	0	62	12

<?php
/*
 * THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS
 * "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT
 * LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR
 * A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT
 * OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL,
 * SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT
 * LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE,
 * DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY
 * THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT
 * (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
 * OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * This software consists of voluntary contributions made by many individuals
 * and is licensed under the MIT license. For more information, see
 * <http://www.doctrine-project.org>.
 */

namespace Doctrine\DBAL\Driver;

use Doctrine\DBAL\DBALException;
use Doctrine\DBAL\Driver;
use Doctrine\DBAL\Exception;
use Doctrine\DBAL\Platforms\MariaDb102Platform;
use Doctrine\DBAL\Platforms\MySQL57Platform;
use Doctrine\DBAL\Platforms\MySqlPlatform;
use Doctrine\DBAL\Schema\MySqlSchemaManager;
use Doctrine\DBAL\VersionAwarePlatformDriver;

/**
 * Abstract base implementation of the {@link Doctrine\DBAL\Driver} interface for MySQL based drivers.
 *
 * @author Steve Müller <st.mueller@dzh-online.de>
 * @link   www.doctrine-project.org
 * @since  2.5
 */
abstract class AbstractMySQLDriver implements Driver, ExceptionConverterDriver, VersionAwarePlatformDriver
{
    /**
     * {@inheritdoc}
     *
     * @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-client.html
     * @link http://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html
     */
    public function convertException($message, DriverException $exception)
    {
        switch ($exception->getErrorCode()) {
            case '1213':
                return new Exception\DeadlockException($message, $exception);
            case '1205':
                return new Exception\LockWaitTimeoutException($message, $exception);
            case '1050':
                return new Exception\TableExistsException($message, $exception);

            case '1051':
            case '1146':
                return new Exception\TableNotFoundException($message, $exception);

            case '1216':
            case '1217':
            case '1451':
            case '1452':
            case '1701':
                return new Exception\ForeignKeyConstraintViolationException($message, $exception);

            case '1062':
            case '1557':
            case '1569':
            case '1586':
                return new Exception\UniqueConstraintViolationException($message, $exception);

            case '1054':
            case '1166':
            case '1611':
                return new Exception\InvalidFieldNameException($message, $exception);

            case '1052':
            case '1060':
            case '1110':
                return new Exception\NonUniqueFieldNameException($message, $exception);

            case '1064':
            case '1149':
            case '1287':
            case '1341':
            case '1342':
            case '1343':
            case '1344':
            case '1382':
            case '1479':
            case '1541':
            case '1554':
            case '1626':
                return new Exception\SyntaxErrorException($message, $exception);

            case '1044':
            case '1045':
            case '1046':
            case '1049':
            case '1095':
            case '1142':
            case '1143':
            case '1227':
            case '1370':
            case '1429':
            case '2002':
            case '2005':
                return new Exception\ConnectionException($message, $exception);

            case '1048':
            case '1121':
            case '1138':
            case '1171':
            case '1252':
            case '1263':
            case '1364':
            case '1566':
                return new Exception\NotNullConstraintViolationException($message, $exception);
        }

        return new Exception\DriverException($message, $exception);
    }


    /**
     * {@inheritdoc}
     */
    public function createDatabasePlatformForVersion($version)
    {
        // Detect vendor and version
        $lowerCaseVersion = strtolower($version);

        if (false !== strpos($lowerCaseVersion, 'mariadb')) {
            // MariaDB does not follow one rule for versions.
            // - will catch things like '10.2.8-MariaDB-1~lenny-log'
            preg_match('/(?P<major>\d{1,2})\.(?P<minor>\d{1,2})\.(?P<patch>\d+)/', $lowerCaseVersion, $firstMatch);
            // - will catch things like '5.5.5-10.2.8-MariaDB-10.2.8+maria~xenial-log'
            preg_match('/\-(?P<major>1\d)\.(?P<minor>\d{1,2})\.(?P<patch>\d+)/', $lowerCaseVersion, $secondMatch);

            if (empty($firstMatch) && empty($secondMatch)
            ) {
                throw DBALException::invalidPlatformVersionSpecified(
                    $version,
                    'MariaDB-<major_version>.<minor_version>.<patch_version>' .
                                 'or <major_version>.<minor_version>.<patch_version>-MariaDB'
                );
            }

            $versionParts = array_merge($firstMatch, $secondMatch);

            $majorVersion = $versionParts['major'];
            $minorVersion = $versionParts['minor'];
            $patchVersion = $versionParts['patch'];

            $version = $majorVersion . '.' . $minorVersion . '.' . $patchVersion;
            if (version_compare($version, '10.2.7', '>=')) {
                return new MariaDb102Platform();
            }

        } else {
            // Oracle MySQL

            if (!preg_match('/^(?P<major>\d+)(?:\.(?P<minor>\d+)(?:\.(?P<patch>\d+))?)?/', $version, $versionParts)) {
                throw DBALException::invalidPlatformVersionSpecified(
                    $version,
                    '<major_version>.<minor_version>.<patch_version>'
                );
            }
            $majorVersion = $versionParts['major'];
            $minorVersion = isset($versionParts['minor']) ? $versionParts['minor'] : 0;
            $patchVersion = isset($versionParts['patch']) ? $versionParts['patch'] : null;

            if ('5' === $majorVersion && '7' === $minorVersion && null === $patchVersion) {
                $patchVersion = '9';
            }

            $version = $majorVersion . '.' . $minorVersion . '.' . $patchVersion;

            if (version_compare($version, '5.7.9', '>=')) {
                return new MySQL57Platform();
            }
        }




        return $this->getDatabasePlatform();

    }


    /**
     * {@inheritdoc}
     */
    public function getDatabase(\Doctrine\DBAL\Connection $conn)

This method seems to be duplicated in your project.

    {
        $params = $conn->getParams();

        if (isset($params['dbname'])) {
            return $params['dbname'];
        }

        return $conn->query('SELECT DATABASE()')->fetchColumn();

The expression $conn->query('SELECT DATABASE()')->fetchColumn(); of type string|boolean adds the type boolean to the return on line 204 which is incompatible with the return type declared by the interface Doctrine\DBAL\Driver::getDatabase of type string.

    }

    /**
     * {@inheritdoc}
     */
    public function getDatabasePlatform()
    {
        return new MySqlPlatform();
    }

    /**
     * {@inheritdoc}
     */
    public function getSchemaManager(\Doctrine\DBAL\Connection $conn)
    {
        return new MySqlSchemaManager($conn);
    }
}