Doctrine\Tests\DBAL\Driver\PDOSqlsrv\DriverTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	45
Duplicated Lines	0 %

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	testConnectionOptions()	0	11	1
A	testReturnsName()	0	3	1
A	createDriver()	0	3	1
A	testDriverOptions()	0	9	1
A	getConnection()	0	9	1

<?php


namespace Doctrine\Tests\DBAL\Driver\PDOSqlsrv;


use Doctrine\DBAL\Driver\PDOSqlsrv\Driver;

use Doctrine\Tests\DBAL\Driver\AbstractSQLServerDriverTest;

use PDO;


class DriverTest extends AbstractSQLServerDriverTest

{

    public function testReturnsName()

    {

        self::assertSame('pdo_sqlsrv', $this->driver->getName());

    }


    protected function createDriver()

    {

        return new Driver();

    }


    public function testConnectionOptions()

    {

        $connection = $this->getConnection([

            'APP' => 'APP_NAME',

            'WSID' => 'WSID_NAME',

        ]);


        $result = $connection->query("select APP_NAME() as app,  HOST_NAME() as host")->fetch();


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

        self::assertSame('WSID_NAME', $result['host']);

    }


    public function testDriverOptions()

    {

        $connection = $this->getConnection([

            PDO::ATTR_CASE => PDO::CASE_UPPER,

            PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC,

        ]);


        self::assertSame(PDO::CASE_UPPER, $connection->getAttribute(PDO::ATTR_CASE));

        self::assertSame(PDO::FETCH_ASSOC, $connection->getAttribute(PDO::ATTR_DEFAULT_FETCH_MODE));

    }


    private function getConnection($driverOptions) {

        return $this->createDriver()->connect(

            array(

                'host' => $GLOBALS['db_host'],

                'port' => $GLOBALS['db_port']

            ),

            $GLOBALS['db_username'],

            $GLOBALS['db_password'],

            $driverOptions

        );

    }

}