AbstractSQLServerDriverTest::testDriverOptions() - Code Metrics - Inspection of "Added support for available DSN parameters for the..." - doctrine/dbal - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Pull Request — master (#3033)

by Aleksey

created 2018-05-23 12:08 UTC

AbstractSQLServerDriverTest::testDriverOptions() A

↳ Parent: AbstractSQLServerDriverTest

Complexity

Conditions	1
Paths	1

Size

Total Lines	7
Code Lines	4

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
dl	0
loc	7
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	4
nc	1
nop	0

<?php

namespace Doctrine\Tests\DBAL\Driver;

use Doctrine\DBAL\Connection;
use Doctrine\DBAL\Driver\AbstractSQLServerDriver;
use Doctrine\DBAL\Driver\Connection as DriverConnection;
use Doctrine\DBAL\Driver\PDOSqlsrv\Driver as PDOSqlsrvDriver;
use Doctrine\DBAL\Driver\SQLSrv\Driver as SQLSrvDriver;
use Doctrine\DBAL\Platforms\SQLServer2008Platform;
use Doctrine\DBAL\Schema\SQLServerSchemaManager;
use PDO;

class AbstractSQLServerDriverTest extends AbstractDriverTest
{
    protected function createDriver()
    {
        return $this->getMockForAbstractClass('Doctrine\DBAL\Driver\AbstractSQLServerDriver');
interface HasName {
    /** @return string */
    public function getName();
}

class Name {
    public $name;
}

class User implements HasName {
    /** @return string|Name */
    public function getName() {
        return new Name('foo'); // This is a violation of the ``HasName`` interface
                                // which only allows a string value to be returned.
    }
}
    }

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

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

    protected function getDatabasePlatformsForVersions()
    {
        return array(
            array('9', 'Doctrine\DBAL\Platforms\SQLServerPlatform'),
            array('9.00', 'Doctrine\DBAL\Platforms\SQLServerPlatform'),
            array('9.00.0', 'Doctrine\DBAL\Platforms\SQLServerPlatform'),
            array('9.00.1398', 'Doctrine\DBAL\Platforms\SQLServerPlatform'),
            array('9.00.1398.99', 'Doctrine\DBAL\Platforms\SQLServerPlatform'),
            array('9.00.1399', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('9.00.1399.0', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('9.00.1399.99', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('9.00.1400', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('9.10', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('9.10.9999', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('10.00.1599', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('10.00.1599.99', 'Doctrine\DBAL\Platforms\SQLServer2005Platform'),
            array('10.00.1600', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('10.00.1600.0', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('10.00.1600.99', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('10.00.1601', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('10.10', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('10.10.9999', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('11.00.2099', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('11.00.2099.99', 'Doctrine\DBAL\Platforms\SQLServer2008Platform'),
            array('11.00.2100', 'Doctrine\DBAL\Platforms\SQLServer2012Platform'),
            array('11.00.2100.0', 'Doctrine\DBAL\Platforms\SQLServer2012Platform'),
            array('11.00.2100.99', 'Doctrine\DBAL\Platforms\SQLServer2012Platform'),
            array('11.00.2101', 'Doctrine\DBAL\Platforms\SQLServer2012Platform'),
            array('12', 'Doctrine\DBAL\Platforms\SQLServer2012Platform'),
        );
    }

    protected function getDriver() : AbstractSQLServerDriver
    {
        return static::createDriver();
        return static::/** @scrutinizer ignore-call */ createDriver();
    }

    protected function checkForSkippingTest(AbstractSQLServerDriver $driver) : void
    {
        if (extension_loaded('sqlsrv') && $driver instanceof SQLSrvDriver

            || extension_loaded('pdo_sqlsrv') && $driver instanceof PDOSqlsrvDriver) {
            return;
        }

        $this->markTestSkipped('The test is only for the sqlsrv and the pdo_sqlsrv drivers');
    }

    protected function getConnection(AbstractSQLServerDriver $driver, array $driverOptions) : DriverConnection
    {
        return $driver->connect(
            [
                'host' => $GLOBALS['db_host'],
                'port' => $GLOBALS['db_port'],
            ],
            $GLOBALS['db_username'],
            $GLOBALS['db_password'],
            $driverOptions
        );
    }

    public function testConnectionOptions() : void
    {
        $driver = $this->getDriver();
        $this->checkForSkippingTest($driver);
        $connection = $this->getConnection($driver, ['APP' => 'APP_NAME']);
        $result     = $connection->query('select APP_NAME() as app')->fetch();
        $result     = $connection->/** @scrutinizer ignore-call */ query('select APP_NAME() as app')->fetch();

        self::assertSame('APP_NAME', $result['app']);
    }

    public function testDriverOptions() : void
    {
        $driver = $this->getDriver();
        $this->checkForSkippingTest($driver);
        $connection = $this->getConnection($driver, [PDO::ATTR_CASE => PDO::CASE_UPPER]);

        self::assertSame(PDO::CASE_UPPER, $connection->getAttribute(PDO::ATTR_CASE));
        self::assertSame(PDO::CASE_UPPER, $connection->/** @scrutinizer ignore-call */ getAttribute(PDO::ATTR_CASE));
    }
}


doctrine / dbal

Pull Request — master (#3033)

AbstractSQLServerDriverTest::testDriverOptions() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like