QB\MySQL\Statement\DeleteTest::testDeleteComplex()

Complexity

Conditions	1
Paths	1

Size

Total Lines	17
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    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);
    }