QB\Generic\Statement\DeleteTest

Complexity

Total Complexity

5

Size/Duplication

Total Lines	57
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

5 Methods

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

<?php

declare(strict_types=1);

namespace QB\Generic\Statement;

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

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

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

    public function testToStringSimple()
    {
        $sql = (string)$this->getSut('foo');

        $parts   = [];
        $parts[] = 'DELETE FROM foo';

        $expectedSql = implode(PHP_EOL, $parts);

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

    public function testToStringComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->addWhere('foo.bar = "foo-bar"', 'bar.foo = 17');

        $parts   = [];
        $parts[] = 'DELETE FROM foo';
        $parts[] = 'WHERE foo.bar = "foo-bar" AND bar.foo = 17';

        $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 IDelete
     */
    protected function getSut(string ...$tables): IDelete
    {
        return (new Delete())->addFrom(...$tables);
    }
}