ConnectionTest::testEscapeThrowsException() - Code Metrics - Inspection of "51e64fbe0bb898e2cc073ad7614f94e313a0859f" - FoolCode/SphinxQL-Query-Builder - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Branch — master (51e64f)

by Hung
created 2018-04-21 22:02 UTC
ConnectionTest::testEscapeThrowsException() A

↳ Parent: ConnectionTest
Complexity

Conditions	1
Paths	1
Size

Total Lines	6
Code Lines	3
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	1
eloc	3
nc	1
nop	0
dl	0
loc	6
rs	9.4285
c	0
b	0
f	0
<?php

use Foolz\SphinxQL\Drivers\ConnectionInterface;
use Foolz\SphinxQL\Expression;
use Foolz\SphinxQL\Tests\TestUtil;

class ConnectionTest extends \PHPUnit\Framework\TestCase
namespace YourVendor;

class YourClass { }
{
    /**
     * @var ConnectionInterface
     */
    private $connection = null;

    public function setUp()
    {
        $this->connection = TestUtil::getConnectionDriver();
        $this->connection->setParams(array('host' => '127.0.0.1', 'port' => 9307));
    }

    public function tearDown()
    {
        $this->connection = null;
    }

    public function test()
    {
        TestUtil::getConnectionDriver();
    }

    public function testGetParams()
    {
        $this->assertSame(
            array('host' => '127.0.0.1', 'port' => 9307, 'socket' => null),
            $this->connection->getParams()
                               getParams()
        );

        // create a new connection and get info
        $this->connection->setParams(array('host' => '127.0.0.2'));
                           setParams(array('host' => '127.0.0.2'));
        $this->connection->setParam('port', 9308);
                           setParam('port', 9308);
        $this->assertSame(
            array('host' => '127.0.0.2', 'port' => 9308, 'socket' => null),
            $this->connection->getParams()
        );

        $this->connection->setParam('host', 'localhost');
        $this->assertSame(
            array('host' => '127.0.0.1', 'port' => 9308, 'socket' => null),
            $this->connection->getParams()
        );

        // create a unix socket connection with host param
        $this->connection->setParam('host', 'unix:/var/run/sphinx.sock');
        $this->assertSame(
            array('host' => null, 'port' => 9308, 'socket' => '/var/run/sphinx.sock'),
            $this->connection->getParams()
        );

        // create unix socket connection with socket param
        $this->connection->setParam('host', '127.0.0.1');
        $this->connection->setParam('socket', '/var/run/sphinx.sock');
        $this->assertSame(
            array('host' => null, 'port' => 9308, 'socket' => '/var/run/sphinx.sock'),
            $this->connection->getParams()
        );
    }

    public function testGetConnectionParams()
    {
        // verify that (deprecated) getConnectionParams continues to work
        $this->assertSame(array('host' => '127.0.0.1', 'port' => 9307, 'socket' => null), $this->connection->getParams());

        // create a new connection and get info
        $this->connection->setParams(array('host' => '127.0.0.1', 'port' => 9308));
        $this->assertSame(array('host' => '127.0.0.1', 'port' => 9308, 'socket' => null), $this->connection->getParams());
    }

    public function testGetConnection()
    {
        $this->connection->connect();
                           connect();
        $this->assertNotNull($this->connection->getConnection());
        $this->assertNotNull($this->connection->/** @scrutinizer ignore-call */ getConnection());
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\ConnectionException
     */
    public function testGetConnectionThrowsException()
    {
        $this->connection->getConnection();
    }

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

        $this->connection->setParam('options', array(MYSQLI_OPT_CONNECT_TIMEOUT => 1));
        $this->connection->connect();
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\ConnectionException
     */
    public function testConnectThrowsException()
    {
        $this->connection->setParam('port', 9308);
        $this->connection->connect();
    }

    public function testPing()
    {
        $this->connection->connect();
        $this->assertTrue($this->connection->ping());
        $this->assertTrue($this->connection->/** @scrutinizer ignore-call */ ping());
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\ConnectionException
     */
    public function testClose()
    {
        $encoding = mb_internal_encoding();
        $this->connection->connect();
        if (method_exists($this->connection, 'getInternalEncoding')) {
		    $this->assertEquals($encoding, $this->connection->getInternalEncoding());
		    $this->assertEquals('UTF-8', mb_internal_encoding());
        }
        $this->connection->close();
                           close();
        $this->assertEquals($encoding, mb_internal_encoding());
        $this->connection->getConnection();
    }

    public function testQuery()
    {
        $this->connection->connect();
        $this->assertSame(array(
            array('Variable_name' => 'total', 'Value' => '0'),
            array('Variable_name' => 'total_found', 'Value' => '0'),
            array('Variable_name' => 'time', 'Value' => '0.000'),
        ), $this->connection->query('SHOW META')->getStored());
        ), /** @scrutinizer ignore-deprecated */ $this->connection->query('SHOW META')->getStored());
    }

    public function testMultiQuery()
    {
        $this->connection->connect();
        $query = $this->connection->multiQuery(array('SHOW META'));
        $this->assertSame(array(
            array('Variable_name' => 'total', 'Value' => '0'),
            array('Variable_name' => 'total_found', 'Value' => '0'),
            array('Variable_name' => 'time', 'Value' => '0.000'),
        ), $query->getNext()->fetchAllAssoc());
    }

    /**
     * @expectedException        Foolz\SphinxQL\Exception\SphinxQLException
     * @expectedExceptionMessage The Queue is empty.
     */
    public function testEmptyMultiQuery()
    {
        $this->connection->connect();
        $this->connection->multiQuery(array());
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\DatabaseException
     */
    public function testMultiQueryThrowsException()
    {
        $this->connection->multiQuery(array('SHOW METAL'));
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\DatabaseException
     */
    public function testQueryThrowsException()
    {
        $this->connection->query('SHOW METAL');
    }

    public function testEscape()
    {
        $result = $this->connection->escape('\' "" \'\' ');
        $this->assertEquals('\'\\\' \\"\\" \\\'\\\' \'', $result);
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\ConnectionException
     */
    public function testEscapeThrowsException()
    {
        // or we get the wrong error popping up
        $this->connection->setParam('port', 9308);
        $this->connection->connect();
        $this->connection->escape('\' "" \'\' ');
    }

    public function testQuote()
    {
        $this->connection->connect();
        $this->assertEquals('null', $this->connection->quote(null));
        $this->assertEquals(1, $this->connection->quote(true));
        $this->assertEquals(0, $this->connection->quote(false));
        $this->assertEquals("fo'o'bar", $this->connection->quote(new Expression("fo'o'bar")));
        $this->assertEquals(123, $this->connection->quote(123));
        $this->assertEquals("12.3", $this->connection->quote(12.3));
        $this->assertEquals("'12.3'", $this->connection->quote('12.3'));
        $this->assertEquals("'12'", $this->connection->quote('12'));
    }

    public function testQuoteArr()
    {
        $this->connection->connect();
        $this->assertEquals(
            array('null', 1, 0, "fo'o'bar", 123, "12.3", "'12.3'", "'12'"),
            $this->connection->quoteArr(array(null, true, false, new Expression("fo'o'bar"), 123, 12.3, '12.3', '12'))
        );
    }

}

FoolCode / SphinxQL-Query-Builder

Branch — master (51e64f)

ConnectionTest::testEscapeThrowsException() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
