bytic / database

tests/Query/Condition/ConditionTest.php

<?php

namespace Nip\Database\Tests\Query\Condition;

use Mockery as m;
use Nip\Database\Connections\Connection;
use Nip\Database\Query\Select as SelectQuery;
use Nip\Database\Tests\AbstractTest;

/**
 * Class ConditionTest
 * @package Nip\Database\Tests\Query\Condition
 */
class ConditionTest extends AbstractTest
{
    /**
     * @var SelectQuery
     */
    protected $query;

    public function setUp(): void
    {
        parent::setUp();

        $adapterMock = m::mock('Nip\Database\Adapters\MySQLi')->shouldDeferMissing();

The function Mockery\LegacyMockInterface::shouldDeferMissing() has been deprecated: 2.0.0 Please use makePartial() instead

        $adapterMock->shouldReceive('cleanData')->andReturnUsing(function ($data) {
            return $data;
        });

        $connection = new Connection(false);

false of type false is incompatible with the type Closure|PDO expected by parameter $pdo of Nip\Database\Connections\Connection::__construct().

        $connection->setAdapter($adapterMock);
        $this->query = $connection->newQuery();
    }

    public function testParseString()
    {
        $condition = $this->query->getCondition('name = value');
        static::assertEquals('name = value', $condition->getString());

        $condition = $this->query->getCondition('id = ?', 5);

5 of type integer is incompatible with the type array expected by parameter $values of Nip\Database\Query\AbstractQuery::getCondition().

        static::assertEquals('id = 5', $condition->getString());

        $condition = $this->query->getCondition('MATCH title AGAINST (?)', 'lorem ipsum');

'lorem ipsum' of type string is incompatible with the type array expected by parameter $values of Nip\Database\Query\AbstractQuery::getCondition().

        static::assertEquals("MATCH title AGAINST ('lorem ipsum')", $condition->getString());

        $condition = $this->query->getCondition('pos BETWEEN ? AND ?', [1, 10]);
        static::assertEquals('pos BETWEEN 1 AND 10', $condition->getString());
    }

    public function testAndConditions()
    {
        $condition = $this->query->getCondition("name LIKE '%lorem%'");
        $condition = $condition->and_($this->query->getCondition("date > NOW()"));

        static::assertEquals("name LIKE '%lorem%' AND date > NOW()", $condition->getString());
    }

    public function testOrConditions()
    {
        $condition = $this->query->getCondition("name LIKE '%lorem%'")->or_($this->query->getCondition('date > NOW()'));
        static::assertEquals("name LIKE '%lorem%' OR date > NOW()", $condition->getString());
    }

    public function testAndOrConditions()
    {
        $condition1 = $this->query
            ->getCondition("name LIKE '%lorem%'")
            ->and_($this->query->getCondition("date > NOW()"));
        $condition2 = $this->query
            ->getCondition("name LIKE '%ipsum%'")
            ->and_($this->query->getCondition("date < NOW()"));
        $condition3 = $condition1->or_($condition2);

        static::assertEquals(
            "(name LIKE '%lorem%' AND date > NOW()) OR (name LIKE '%ipsum%' AND date < NOW())",
            $condition3->getString()
        );
    }

    public function testNestedConditions()
    {
        $condition2 = $this->query
            ->getCondition("date > NOW()")->
            or_($this->query->getCondition("date < '24.10.2008'"));
        $condition = $this->query
            ->getCondition("name LIKE '%lorem%'")
            ->and_($condition2);

        static::assertEquals("name LIKE '%lorem%' AND (date > NOW() OR date < '24.10.2008')", $condition->getString());
    }

    public function testWhereIn()
    {
        $condition = $this->query->getCondition("id in ?", [1, 2, 3]);
        static::assertEquals("id in (1, 2, 3)", $condition->getString());
    }
}