FilterTest::testFilterWithDateMultipleAndLogic() - Code Metrics - Inspection of "Implement row functions with `and` & `or` logic op..." - tbolier/php-rethink-ql - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Push — master ( 139da0...112cee )

by Michel
created 2018-03-20 08:19 UTC
FilterTest::testFilterWithDateMultipleAndLogic() A

↳ Parent: FilterTest
Complexity

Conditions	1
Paths	1
Size

Total Lines	20
Code Lines	11
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
dl	0
loc	20
rs	9.4285
c	0
b	0
f	0
cc	1
eloc	11
nc	1
nop	0
<?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);
    }

    /**
     * @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);
    }

    /**
     * @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());
        $this->assertArraySubset(['number' => 77], /** @scrutinizer ignore-type */ $res->getData());
    }

    /**
     * @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());
        $this->assertArraySubset(['number' => 99], /** @scrutinizer ignore-type */ $res->getData());
    }

    /**
     * @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);
    }

    /**
     * @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);
    }

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

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

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

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

        $row = $this->r()->row('date')->ne($yesterday->format(\DateTime::ATOM));
        $cursor = $this->r()
            ->table('tabletest')
            ->filter($row)
            ->run();

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

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

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->eq($yesterday->format(\DateTime::ATOM))->and(
            $this->r()->row('date')->ne($tomorrow->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);
    }

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

        /** @var ResponseInterface $res */
        $row = $this->r()->row('date')->eq($yesterday->format(\DateTime::ATOM))->or(
            $this->r()->row('date')->eq($tomorrow->format(\DateTime::ATOM))->and(
                $this->r()->row('id')->gt(0)->or(
                    $this->r()->row('id')->lt(3)
                )
            )
        );

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

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

tbolier / php-rethink-ql

Push — master ( 139da0...112cee )

FilterTest::testFilterWithDateMultipleAndLogic() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
