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

Complexity

Conditions	1
Paths	1

Size

Total Lines	17
Code Lines	12

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function testDeleteComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->addModifier(Delete::LOW_PRIORITY, Delete::QUICK, Delete::IGNORE)
            ->addWhere('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']))
            ->addOrderBy('bar.baz', 'DESC')
            ->setLimit(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);
    }