TBolier\RethinkQL\IntegrationTest\Query\FilterTest

Complexity

Total Complexity

16

Size/Duplication

Total Lines	308
Duplicated Lines	0 %

Importance

Changes

0

16 Methods

Rating	Name	Duplication	Size	Complexity
A	testFilter()	0	15	1
A	testFilterOnMultipleDocuments()	0	15	1
A	testFilterAndMin()	0	13	1
A	testFilterAndCount()	0	13	1
A	testFilterAndAvg()	0	13	1
A	testFilterAndMax()	0	13	1
A	testFilterAndIsEmpty()	0	13	1
A	testFilterAndOrderBy()	0	13	1
A	testFilterAndLimit()	0	13	1
A	testFilterAndSum()	0	13	1
A	testFilterAndSkip()	0	13	1
A	testFilterWithDateLowerThanLogic()	0	13	1
A	testFilterWithDateMultipleLogic()	0	20	1
A	testFilterWithDateNotEqualLogic()	0	13	1
A	testFilterWithDateEqualLogic()	0	13	1
A	testFilterWithDateGreaterThanLogic()	0	13	1

<?php
declare(strict_types=1);

namespace TBolier\RethinkQL\IntegrationTest\Query;

use TBolier\RethinkQL\Response\Cursor;
use TBolier\RethinkQL\Response\ResponseInterface;

class FilterTest extends AbstractTableTest
{
    /**
     * @throws \Exception
     */
    public function testFilter()
    {
        $this->insertDocument(1);

        /** @var Cursor $cursor */
        $cursor = $this->r()
            ->table('tabletest')
            ->filter(['title' => 'Test document 1'])
            ->run();

        /** @var array $array */
        $array = $cursor->current();

        $this->assertInstanceOf(\Iterator::class, $cursor);
        $this->assertArraySubset(['title' => 'Test document 1'], $array);
    }

    /**
     * @throws \Exception
     */
    public function testFilterOnMultipleDocuments()
    {
        $this->insertDocument(1);
        $this->insertDocument(2);
        $this->insertDocument(3);
        $this->insertDocument(4);
        $this->insertDocument(5);

        /** @var Cursor $cursor */
        $cursor = $this->r()
            ->table('tabletest')
            ->filter(['title' => 'Test document 1'])
            ->run();

        $this->assertCount(1, $cursor);
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndIsEmpty(): void
    {
        $this->insertDocument(1);
        $this->insertDocument('stringId');

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['id' => 1])
            ->isEmpty()
            ->run();

        $this->assertFalse($res->getData());
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndCount(): void
    {
        $this->insertDocument(1);
        $this->insertDocument('stringId');

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->count()
            ->run();

        $this->assertEquals(2, $res->getData());
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndAvg(): void
    {
        $this->insertDocumentWithNumber(1, 50);
        $this->insertDocumentWithNumber(2, 100);

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->avg('number')
            ->run();

        $this->assertEquals(75, $res->getData());
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndSum(): void
    {
        $this->insertDocumentWithNumber(1, 50);
        $this->insertDocumentWithNumber(2, 100);

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->sum('number')
            ->run();

        $this->assertEquals(150, $res->getData());
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndLimit(): void
    {
        $this->insertDocument(1);
        $this->insertDocument('stringId');

        /** @var ResponseInterface $res */
        $cursor = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->limit(1)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndSkip(): void
    {
        $this->insertDocument(1);
        $this->insertDocument('stringId');

        /** @var ResponseInterface $res */
        $cursor = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->skip(1)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndOrderBy(): void
    {
        $this->insertDocument(1);
        $this->insertDocument('stringId');

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->orderBy($this->r()->desc('id'))
            ->run();

        $this->assertArraySubset(['id' => 'stringId'], $res->getData()[0]);
    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndMin(): void
    {
        $this->insertDocumentWithNumber(1, 77);
        $this->insertDocumentWithNumber(2, 99);

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->min('number')
            ->run();

        $this->assertArraySubset(['number' => 77], $res->getData());

It seems like $res->getData() can also be of type string; however, parameter $array of PHPUnit\Framework\Assert::assertArraySubset() does only seem to accept ArrayAccess|array, maybe add an additional type check?

    }

    /**
     * @return void
     * @throws \Exception
     */
    public function testFilterAndMax(): void
    {
        $this->insertDocumentWithNumber(1, 77);
        $this->insertDocumentWithNumber(2, 99);

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->filter(['description' => 'A document description.'])
            ->max('number')
            ->run();

        $this->assertArraySubset(['number' => 99], $res->getData());

It seems like $res->getData() can also be of type string; however, parameter $array of PHPUnit\Framework\Assert::assertArraySubset() does only seem to accept ArrayAccess|array, maybe add an additional type check?

    }

    /**
     * @throws \Exception
     */
    public function testFilterWithDateGreaterThanLogic(): void
    {
        $this->insertDocumentWithDate(1, new \DateTime('-1 days'));
        $this->insertDocumentWithDate(2, new \DateTime('+1 days'));

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->gt((new \DateTime('now'))->format(\DateTime::ATOM));
        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @throws \Exception
     */
    public function testFilterWithDateLowerThanLogic(): void
    {
        $this->insertDocumentWithDate(1, new \DateTime('-1 days'));
        $this->insertDocumentWithDate(2, new \DateTime('+1 days'));

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->lt((new \DateTime('now'))->format(\DateTime::ATOM));
        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @throws \Exception
     */
    public function testFilterWithDateEqualLogic(): void
    {
        $this->insertDocumentWithDate(1, $equalDateTime = new \DateTime('-1 days'));
        $this->insertDocumentWithDate(2, new \DateTime('+1 days'));

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->eq($equalDateTime->format(\DateTime::ATOM));
        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @throws \Exception
     */
    public function testFilterWithDateNotEqualLogic(): void
    {
        $this->insertDocumentWithDate(1, $notEqualDateTime = new \DateTime('-1 days'));
        $this->insertDocumentWithDate(2, new \DateTime('+1 days'));

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->ne($notEqualDateTime->format(\DateTime::ATOM));
        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }

    /**
     * @throws \Exception
     */
    public function testFilterWithDateMultipleLogic(): void
    {
        $this->insertDocumentWithDate(1, $notEqualDateTime = new \DateTime('-1 days'));
        $this->insertDocumentWithDate(2, $lowerThanDateTime = new \DateTime('+1 days'));

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->eq($notEqualDateTime->format(\DateTime::ATOM))->and(
            $this->r()->row('date')->ne($lowerThanDateTime->format(\DateTime::ATOM))->and(
                $this->r()->row('id')->eq(1)->and(
                    $this->r()->row('id')->ne(2)
                )
            )
        );

        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

        $this->assertCount(1, $cursor);

It seems like $cursor can also be of type TBolier\RethinkQL\Response\ResponseInterface; however, parameter $haystack of PHPUnit\Framework\Assert::assertCount() does only seem to accept Countable|iterable, maybe add an additional type check?

    }
}