MultiResultSetTest::testInvalidStore() - 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
MultiResultSetTest::testInvalidStore() A

↳ Parent: MultiResultSetTest
Complexity

Conditions	2
Paths	2
Size

Total Lines	12
Code Lines	8
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
cc	2
eloc	8
nc	2
nop	0
dl	0
loc	12
rs	9.4285
c	0
b	0
f	0
<?php

use Foolz\SphinxQL\Drivers\MultiResultSetInterface;
use Foolz\SphinxQL\Drivers\Mysqli\Connection as MysqliConnection;
use Foolz\SphinxQL\Drivers\Pdo\Connection as PdoConnection;
use Foolz\Sphinxql\Drivers\ResultSetInterface;
use Foolz\SphinxQL\Exception\DatabaseException;
use Foolz\SphinxQL\SphinxQL;
use Foolz\SphinxQL\Tests\TestUtil;

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

class YourClass { }
{
    /**
     * @var MysqliConnection|PdoConnection
     */
    public static $conn = null;

    public static $data = array(
        0 => array('id' => '10', 'gid' => '9003',
            'title' => 'modifying the same line again', 'content' => 'because i am that lazy'),
        1 => array('id' => '11', 'gid' => '201',
            'title' => 'replacing value by value', 'content' => 'i have no idea who would use this directly'),
        2 => array('id' => '12', 'gid' => '200',
            'title' => 'simple logic', 'content' => 'inside the box there was the content'),
        3 => array('id' => '13', 'gid' => '304',
            'title' => 'i am getting bored', 'content' => 'with all this CONTENT'),
        4 => array('id' => '14', 'gid' => '304',
            'title' => 'i want a vacation', 'content' => 'the code is going to break sometime'),
        5 => array('id' => '15', 'gid' => '304',
            'title' => 'there\'s no hope in this class', 'content' => 'just give up'),
        6 => array('id' => '16', 'gid' => '500',
            'title' => 'we need to test', 'content' => 'selecting the best result in groups'),
        7 => array('id' => '17', 'gid' => '500',
            'title' => 'what is there to do', 'content' => 'we need to create dummy data for tests'),
    );

    public static function setUpBeforeClass()
    {
        $conn = TestUtil::getConnectionDriver();
        $conn->setParam('port', 9307);
        self::$conn = $conn;

        (new SphinxQL(self::$conn))->getConnection()->query('TRUNCATE RTINDEX rt');
    }

    /**
     * @return SphinxQL
     */
    protected function createSphinxQL()
    {
        return new SphinxQL(self::$conn);
    }

    public function refill()
    {
        $this->createSphinxQL()->getConnection()->query('TRUNCATE RTINDEX rt');

        $sq = $this->createSphinxQL()
            ->insert()
            ->into('rt')
            ->columns('id', 'gid', 'title', 'content');

        foreach (static::$data as $row) {
            $sq->values($row['id'], $row['gid'], $row['title'], $row['content']);
        }

        $sq->execute();
    }

    public function testIsMultiResultSet()
    {
        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $this->assertInstanceOf(MultiResultSetInterface::class, $res);
        $res->getNext();
        $res->getNext();
    }

    public function testGetNextSet()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));

        $set = $res->getNext();
        $this->assertInstanceOf(ResultSetInterface::class, $set);
        $set = $res->getNext();
        $this->assertInstanceOf(ResultSetInterface::class, $set);

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->store();
        $set = $res->getNext();
        $this->assertInstanceOf(ResultSetInterface::class, $set);
        $set = $res->getNext();
        $this->assertInstanceOf(ResultSetInterface::class, $set);
        $this->assertFalse($res->getNext());
        $this->assertFalse(/** @scrutinizer ignore-type */ $res->getNext());
    }


    public function testGetNextSetFalse()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->getNext();
        $res->getNext();
        $this->assertFalse($res->getNext());
        $this->assertFalse(/** @scrutinizer ignore-type */ $res->getNext());
    }

    public function testStore()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->store();
        $stored = $res->getStored();
        $this->assertCount(2, $stored);
        $this->assertInstanceOf(ResultSetInterface::class, $stored[0]);
        $all = $stored[0]->fetchAllAssoc();
        $this->assertEquals(8, $all[0]['count(*)']);
    }

    /**
     * @expectedException Foolz\SphinxQL\Exception\DatabaseException
     */
    public function testInvalidStore()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->getNext();
        try {
            $res->store();
        } catch (DatabaseException $e) {
            // we need to clean up
            self::setUpBeforeClass();
            throw $e;
        }
    }

    public function testArrayAccess()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));

        $this->assertEquals(8, $res[0][0]['count(*)']);
    }

    public function testIterator()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));

        $array = array();
        foreach($res as $key => $value) {
            $array[$key] = $value;
        }

        $this->assertCount(2, $array);
    }

    public function testIteratorStored()
    {
        $this->refill();

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->store();
        $array = array();
        foreach($res as $key => $value) {
            $array[$key] = $value;
        }

        $this->assertCount(2, $array);

        foreach($res as $key => $value) {
            $array[$key] = $value;
        }

        $this->assertCount(2, $array);

        $this->assertCount(2, $res);
        $this->assertTrue(isset($res[0]));
        $this->assertFalse(isset($res[-1]));
        $this->assertFalse(isset($res[2]));
    }
}

FoolCode / SphinxQL-Query-Builder

Branch — master (51e64f)

MultiResultSetTest::testInvalidStore() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
