QB\Generic\Statement\UpdateTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	64
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	testToStringThrowsAnExceptionIfNotInitialized()	0	5	1
A	getSut()	0	3	1
A	testGetParams()	0	9	1
A	testToStringSimple()	0	14	1
A	testToStringComplex()	0	15	1

<?php

declare(strict_types=1);

namespace QB\Generic\Statement;

use PDO;
use PHPUnit\Framework\TestCase;
use QB\Generic\Expr\Expr;

class UpdateTest extends TestCase
{
    /**
     * @suppress PhanNoopCast
     */
    public function testToStringThrowsAnExceptionIfNotInitialized()
    {
        $this->expectException(\RuntimeException::class);

        (string)$this->getSut();
    }

    public function testToStringSimple()
    {
        $sql = (string)$this->getSut('foo')
            ->setValues(['id' => '1234', 'bar_id' => '2345'])
            ->addWhere('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']));

        $parts   = [];
        $parts[] = 'UPDATE foo';
        $parts[] = 'SET id = ?, bar_id = ?';
        $parts[] = 'WHERE foo.bar = "foo-bar" AND bar.foo = ?';

        $expectedSql = implode(PHP_EOL, $parts);

        $this->assertSame($expectedSql, $sql);
    }

    public function testToStringComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->addModifier('BAR')
            ->setValues(['id' => '1234', 'bar_id' => '2345'])
            ->addWhere('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']));

        $parts   = [];
        $parts[] = 'UPDATE BAR foo';
        $parts[] = 'SET id = ?, bar_id = ?';
        $parts[] = 'WHERE foo.bar = "foo-bar" AND bar.foo = ?';

        $expectedSql = implode(PHP_EOL, $parts);

        $this->assertSame($expectedSql, $sql);
    }

    public function testGetParams()
    {
        $expectedParams = [['bar-foo', PDO::PARAM_STR]];
        $query = $this->getSut('foo')
            ->addWhere('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']));

        $params = $query->getParams();

        $this->assertSame($expectedParams, $params);
    }

    /**
     * @param string ...$tables
     *
     * @return IUpdate
     */
    protected function getSut(string ...$tables): IUpdate
    {
        return (new Update())->addFrom(...$tables);
    }
}