diff options
Diffstat (limited to 'tests/Builder/TruncateStatementTest.php')
-rw-r--r-- | tests/Builder/TruncateStatementTest.php | 39 |
1 files changed, 39 insertions, 0 deletions
diff --git a/tests/Builder/TruncateStatementTest.php b/tests/Builder/TruncateStatementTest.php new file mode 100644 index 0000000..1abee17 --- /dev/null +++ b/tests/Builder/TruncateStatementTest.php @@ -0,0 +1,39 @@ +<?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()); + } +} |