QB\MySQL\Statement\DeleteTest

Complexity

Total Complexity

2

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	getSut()	0	3	1
A	testDeleteComplex()	0	17	1

<?php

declare(strict_types=1);

namespace QB\MySQL\Statement;

use QB\Generic\Expr\Expr;
use QB\Generic\Statement\DeleteTest as GenericDeleteTest;

class DeleteTest extends GenericDeleteTest
{
    public function testDeleteComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->modifier(Delete::LOW_PRIORITY, Delete::QUICK, Delete::IGNORE)
            ->where('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']))
            ->orderBy('bar.baz', 'DESC')
            ->limit(10);

        $parts   = [];
        $parts[] = 'DELETE LOW_PRIORITY QUICK IGNORE FROM foo';
        $parts[] = 'WHERE foo.bar = "foo-bar" AND bar.foo = ?';
        $parts[] = 'ORDER BY bar.baz DESC';
        $parts[] = 'LIMIT 10';

        $expectedSql = implode(PHP_EOL, $parts);

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

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