MultiResultSetTest

Complexity

Total Complexity

16

Size/Duplication

Total Lines	173
Duplicated Lines	0 %

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	createSphinxQL()	0	3	1
A	testIsMultiResultSet()	0	6	1
A	testStore()	0	11	1
A	refill()	0	14	2
A	setUpBeforeClass()	0	7	1
A	testGetNextSetFalse()	0	8	1
A	testGetNextSet()	0	18	1
A	testInvalidStore()	0	13	2
A	testIteratorStored()	0	23	3
A	testIterator()	0	12	2
A	testArrayAccess()	0	7	1

<?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
{
    /**
     * @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(): void
    {
        $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());
    }


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

        $res = self::$conn->multiQuery(array('SELECT COUNT(*) FROM rt', 'SHOW META'));
        $res->getNext();
        $res->getNext();
        $this->assertFalse($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(*)']);
    }

    public function testInvalidStore()
    {
        $this->expectException(Foolz\SphinxQL\Exception\DatabaseException::class);
        $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]));
    }
}