TBolier\RethinkQL\IntegrationTest\Aggregation\OrderByTest

Complexity

Total Complexity

3

Size/Duplication

Total Lines	64
Duplicated Lines	0 %

Importance

Changes

0

3 Methods

Rating	Name	Duplication	Size	Complexity
A	testOrderByDesc()	0	15	1
A	testOrderByAsc()	0	15	1
A	testFilterAndOrderByAsc()	0	16	1

<?php
declare(strict_types = 1);

namespace TBolier\RethinkQL\IntegrationTest\Aggregation;

use TBolier\RethinkQL\IntegrationTest\Query\AbstractTableTest;
use TBolier\RethinkQL\Response\ResponseInterface;

class OrderByTest extends AbstractTableTest
{
    /**
     * @return void
     * @throws \Exception
     */
    public function testOrderByDesc(): void
    {
        $this->insertDocument(5);
        $this->insertDocument(4);
        $this->insertDocument(3);
        $this->insertDocument(2);
        $this->insertDocument(1);

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->orderBy($this->r()->desc('id'))
            ->run();

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

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

        /** @var ResponseInterface $res */
        $res = $this->r()
            ->table('tabletest')
            ->orderBy($this->r()->asc('id'))
            ->run();

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

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

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

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