QB\Generic\Statement\DeleteTest::testDeleteSimple()

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	8

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	DeleteTest::testToStringThrowsAnExceptionIfNotInitialized()	0	5	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);
    }
}