Yiisoft\Db\Pgsql\Tests\QueryTest

Complexity

Total Complexity

1

Size/Duplication

Total Lines	37
Duplicated Lines	0 %

Importance

Changes

0

<?php
class QueryTest extends AbstractQueryTest
{
    protected ?string $driverName = 'pgsql';

    public function testBooleanValues(): void
    {
        $db = $this->getConnection();
        $command = $db->createCommand();

        $command->batchInsert(
            'bool_values',
            ['bool_col'],
            [
                [true],
                [false],
            ]
        )->execute();

        $this->assertEquals(1, (new Query($db))->from('bool_values')->where('bool_col = TRUE')->count('*', $db));
        $this->assertEquals(1, (new Query($db))->from('bool_values')->where('bool_col = FALSE')->count('*', $db));
        $this->assertEquals(
            2,
            (new Query($db))->from('bool_values')->where('bool_col IN (TRUE, FALSE)')->count('*', $db)
        );
        $this->assertEquals(1, (new Query($db))->from('bool_values')->where(['bool_col' => true])->count('*', $db));
        $this->assertEquals(1, (new Query($db))->from('bool_values')->where(['bool_col' => false])->count('*', $db));
        $this->assertEquals(
            2,
            (new Query($db))->from('bool_values')->where(['bool_col' => [true, false]])->count('*', $db)
        );
        $this->assertEquals(
            1,
            (new Query($db))->from('bool_values')->where('bool_col = :bool_col', ['bool_col' => true])->count('*', $db)
        );
        $this->assertEquals(
            1,
            (new Query($db))->from('bool_values')->where('bool_col = :bool_col', ['bool_col' => false])->count('*', $db)
        );