FilterTest::testFilterWithDateGreaterThanLogic() - Code Metrics - Inspection of "Implement row functions with equal, not equal, gre..." - tbolier/php-rethink-ql - Measure and Improve Code Quality continuously with Scrutinizer

Passed
Pull Request — master (#36)

by Timon
created 2018-03-18 10:12 UTC
FilterTest::testFilterWithDateGreaterThanLogic() A

↳ Parent: FilterTest
Complexity

Conditions	1
Paths	1
Size

Total Lines	13
Code Lines	8
Duplication

Lines	0
Ratio	0 %
Importance

Changes
Metric	Value
dl	0
loc	13
c	0
b	0
f	0
rs	9.4285
cc	1
eloc	8
nc	1
nop	0
<?php
declare(strict_types=1);

namespace TBolier\RethinkQL\IntegrationTest\Query;

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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $cursor);
    }

    /**
     * @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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $cursor);
    }

    /**
     * @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);
        $this->assertCount(1, /** @scrutinizer ignore-type */ $cursor);
    }
}

tbolier / php-rethink-ql

Pull Request — master (#36)

FilterTest::testFilterWithDateGreaterThanLogic() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like
