Merge pull request #210 from devenbansod/fix/204

Fix building of RenameStatement

1 files changed, 42 insertions, 0 deletions

diff --git a/tests/Builder/RenameStatementTest.php b/tests/Builder/RenameStatementTest.php
new file mode 100644
index 0000000..97852ab
--- /dev/null
+++ b/tests/Builder/RenameStatementTest.php
@@ -0,0 +1,42 @@
+<?php
+
+namespace PhpMyAdmin\SqlParser\Tests\Builder;
+
+use PhpMyAdmin\SqlParser\Parser;
+use PhpMyAdmin\SqlParser\Tests\TestCase;
+
+class RenameStatementTest extends TestCase
+{
+    public function testBuilder()
+    {
+        $query = 'RENAME TABLE old_table TO new_table';
+        $parser = new Parser(
+            $query
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            $query,
+            $stmt->build()
+        );
+
+        $query = 'RENAME TABLE current_db.tbl_name TO other_db.tbl_name';
+        $parser = new Parser(
+            $query
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            $query,
+            $stmt->build()
+        );
+
+        $query = 'RENAME TABLE old_table1 TO new_table1, old_table2 TO new_table2, old_table3 TO new_table3';
+        $parser = new Parser(
+            $query
+        );
+        $stmt = $parser->statements[0];
+        $this->assertEquals(
+            $query,
+            $stmt->build()
+        );
+    }
+}