Crate\Test\DBAL\Functional\ConnectionTestCase

Complexity

Total Complexity

7

Size/Duplication

Total Lines	60
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	testStatement()	0	6	1
A	testGetDriver()	0	3	1
A	testGetConnection()	0	4	1
A	tearDown()	0	4	1
A	testBasicAuthConnection()	0	15	1
A	testConnect()	0	9	1
A	setUp()	0	4	1

<?php
/**
 * Licensed to CRATE Technology GmbH("Crate") under one or more contributor
 * license agreements.  See the NOTICE file distributed with this work for
 * additional information regarding copyright ownership.  Crate licenses
 * this file to you under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.  You may
 * obtain a copy of the License at
 *
 * http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.  See the
 * License for the specific language governing permissions and limitations
 * under the License.
 *
 * However, if you have executed another commercial license agreement
 * with Crate these terms will supersede the license and you may use the
 * software solely pursuant to the terms of the relevant commercial agreement.
 */
namespace Crate\Test\DBAL\Functional;

use Crate\Test\DBAL\DBALFunctionalTestCase;
use Crate\PDO\PDO;

class ConnectionTestCase extends DBALFunctionalTestCase
{
    public function setUp() : void
    {
        $this->resetSharedConn();
        parent::setUp();
    }

    public function tearDown() : void
    {
        parent::tearDown();
        $this->resetSharedConn();
    }

    public function testBasicAuthConnection()
    {
        $auth = ['crate', 'secret'];
        $params = array(
            'driverClass' => 'Crate\DBAL\Driver\PDOCrate\Driver',
            'host' => 'localhost',
            'port' => 4200,
            'user' => $auth[0],
            'password' => $auth[1],
        );
        $conn = \Doctrine\DBAL\DriverManager::getConnection($params);
        $this->assertEquals($auth[0], $conn->getUsername());

The function Doctrine\DBAL\Connection::getUsername() has been deprecated.

        $this->assertEquals($auth[1], $conn->getPassword());

The function Doctrine\DBAL\Connection::getPassword() has been deprecated.

        $auth_attr = $conn->getWrappedConnection()->getAttribute(PDO::CRATE_ATTR_HTTP_BASIC_AUTH);

The method getAttribute() does not exist on Doctrine\DBAL\Driver\Connection. It seems like you code against a sub-type of Doctrine\DBAL\Driver\Connection such as Doctrine\DBAL\Driver\PDOConnection.

        $this->assertEquals($auth_attr, $auth);
    }

    public function testGetConnection()
    {
      $this->assertInstanceOf('Doctrine\DBAL\Connection', $this->_conn);
      $this->assertInstanceOf('Crate\DBAL\Driver\PDOCrate\PDOConnection', $this->_conn->getWrappedConnection());
    }

    public function testGetDriver()
    {
        $this->assertInstanceOf('Crate\DBAL\Driver\PDOCrate\Driver', $this->_conn->getDriver());
    }

    public function testStatement()
    {
        $sql = 'SELECT * FROM sys.cluster';
        $stmt = $this->_conn->prepare($sql);
        $this->assertInstanceOf('Doctrine\DBAL\Statement', $stmt);
        $this->assertInstanceOf('Crate\PDO\PDOStatement', $stmt->getWrappedStatement());

    }

    public function testConnect()
    {
        $this->assertTrue($this->_conn->connect());

        $stmt = $this->_conn->query('select * from sys.cluster');
        $this->assertEquals(1, $stmt->rowCount());

        $row = $stmt->fetch();
        $this->assertEquals('crate', $row['name']);
    }

}