QB\MySQL\Statement\UpdateTest::testUpdateSimple()

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 testToStringComplex()
    {
        $sql = (string)$this->getSut('foo')
            ->addModifier(Update::LOW_PRIORITY)
            ->setValues(['id' => '1234', 'bar_id' => '2345'])
            ->addWhere('foo.bar = "foo-bar"', new Expr('bar.foo = ?', ['bar-foo']))
            ->setLimit(10);

        $parts   = [];
        $parts[] = 'UPDATE LOW_PRIORITY foo';
        $parts[] = 'SET id = ?, bar_id = ?';
        $parts[] = 'WHERE foo.bar = "foo-bar" AND bar.foo = ?';
        $parts[] = 'LIMIT 10';

        $expectedSql = implode(PHP_EOL, $parts);

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