SqlParser\Tests\Builder\DeleteStatementTest::testBuilderSingleTable PHP Method

    public function testBuilderSingleTable()
    {
        /* Assertion 1 */
        $query = 'DELETE IGNORE FROM t1';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
        /* Assertion 2 */
        $query = 'DELETE IGNORE FROM t1 WHERE 1=1';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
        /* Assertion 3 */
        $query = 'DELETE IGNORE FROM t1 WHERE 1=1 ORDER BY id ASC';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
        /* Assertion 4 */
        $query = 'DELETE IGNORE FROM t1 WHERE 1=1 ORDER BY id ASC LIMIT 0, 25';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
        /* Assertion 5 */
        $query = 'DELETE IGNORE FROM t1';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
        /* Assertion 6 */
        $query = 'DELETE LOW_PRIORITY FROM `test`.users ' . 'WHERE `id`<3 AND (username="Dan" OR username="Paul") ORDER BY id ASC';
        $parser = new Parser($query);
        $stmt = $parser->statements[0];
        $this->assertEquals($query, $stmt->build());
    }