diff options
-rw-r--r-- | tests/Builder/CallStatementTest.php | 19 | ||||
-rw-r--r-- | tests/Builder/TruncateStatementTest.php | 40 |
2 files changed, 59 insertions, 0 deletions
diff --git a/tests/Builder/CallStatementTest.php b/tests/Builder/CallStatementTest.php new file mode 100644 index 0000000..f11686e --- /dev/null +++ b/tests/Builder/CallStatementTest.php @@ -0,0 +1,19 @@ +<?php + +namespace PhpMyAdmin\SqlParser\Tests\Builder; + +use PhpMyAdmin\SqlParser\Parser; +use PhpMyAdmin\SqlParser\Tests\TestCase; + +class CallStatementTest extends TestCase +{ + public function testBuilder() + { + $query = 'CALL foo()'; + + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals($query, $stmt->build()); + } +} diff --git a/tests/Builder/TruncateStatementTest.php b/tests/Builder/TruncateStatementTest.php new file mode 100644 index 0000000..09cd01f --- /dev/null +++ b/tests/Builder/TruncateStatementTest.php @@ -0,0 +1,40 @@ +<?php + +namespace PhpMyAdmin\SqlParser\Tests\Builder; + +use PhpMyAdmin\SqlParser\Parser; +use PhpMyAdmin\SqlParser\Tests\TestCase; + +class TruncateStatementTest extends TestCase +{ + public function testBuilder() + { + $query = 'TRUNCATE TABLE mytable;'; + + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals($query, $stmt->build()); + } + + public function testBuilderDbtable() + { + $query = 'TRUNCATE TABLE mydb.mytable;'; + + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals($query, $stmt->build()); + } + + public function testBuilderDbtableBackQuotes() + { + $query = 'TRUNCATE TABLE `mydb`.`mytable`;'; + + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals($query, $stmt->build()); + } + +} |