SqlParser\Tests\Builder\CreateStatementTest::testBuilderRoutine PHP Метод

    public function testBuilderRoutine()
    {
        $parser = new Parser('CREATE FUNCTION test (IN `i` INT) RETURNS VARCHAR ' . 'BEGIN ' . 'DECLARE name VARCHAR DEFAULT ""; ' . 'SELECT name INTO name FROM employees WHERE id = i; ' . 'RETURN name; ' . 'END');
        $stmt = $parser->statements[0];
        $this->assertEquals('CREATE FUNCTION test (IN `i` INT) RETURNS VARCHAR ' . 'BEGIN ' . 'DECLARE name VARCHAR DEFAULT ""; ' . 'SELECT name INTO name FROM employees WHERE id = i; ' . 'RETURN name; ' . 'END', $stmt->build());
    }