The context depends on the SQL mode.

Implemented a few more builders.
Improved some fragments and statement types.
Fixed the noAlias option in FieldFragment.
Reordered CREATE statements's options.
Updated contexts definitions.
Fixed typos. Improved tests.

6 files changed, 55 insertions, 76 deletions

diff --git a/tests/Parser/AlterStatementTest.php b/tests/Parser/AlterStatementTest.php
new file mode 100644
index 0000000..4b315f1
--- /dev/null
+++ b/tests/Parser/AlterStatementTest.php
@@ -0,0 +1,24 @@
+<?php
+
+namespace SqlParser\Tests\Parser;
+
+use SqlParser\Tests\TestCase;
+
+class AlterStatementTest extends TestCase
+{
+
+    /**
+     * @dataProvider testAlterProvider
+     */
+    public function testAlter($test)
+    {
+        $this->runParserTest($test);
+    }
+
+    public function testAlterProvider()
+    {
+        return array(
+            array('parseAlter'),
+        );
+    }
+}
diff --git a/tests/Parser/ArrayFragmentTest.php b/tests/Parser/ArrayFragmentTest.php
deleted file mode 100644
index a31bf2a..0000000
--- a/tests/Parser/ArrayFragmentTest.php
+++ /dev/null
@@ -1,26 +0,0 @@
-<?php
-
-namespace SqlParser\Tests\Parser;
-
-use SqlParser\Tests\TestCase;
-
-class ArrayFragmentTest extends TestCase
-{
-
-    /**
-     * @dataProvider testArrayProvider
-     */
-    public function testArray($test)
-    {
-        $this->runParserTest($test);
-    }
-
-    public function testArrayProvider()
-    {
-        return array(
-            array('parseArrayErr1'),
-            array('parseArrayErr2'),
-            array('parseArrayErr3'),
-        );
-    }
-}
diff --git a/tests/Parser/CreateStatementTest.php b/tests/Parser/CreateStatementTest.php
index 8f8c43a..11bfc5e 100644
--- a/tests/Parser/CreateStatementTest.php
+++ b/tests/Parser/CreateStatementTest.php
@@ -18,15 +18,17 @@ class CreateStatementTest extends TestCase
     public function testCreateProvider()
     {
         return array(
-            array('parseCreateTable'),
-            array('parseCreateTable2'),
-            array('parseCreateTableErr1'),
-            array('parseCreateProcedure'),
-            array('parseCreateProcedure2'),
             array('parseCreateFunction'),
             array('parseCreateFunctionErr1'),
             array('parseCreateFunctionErr2'),
+            array('parseCreateProcedure'),
+            array('parseCreateProcedure2'),
+            array('parseCreateTable'),
+            array('parseCreateTable2'),
+            array('parseCreateTableErr1'),
             array('parseCreateUser'),
+            array('parseCreateView'),
+            array('parseCreateView2'),
         );
     }
 }
diff --git a/tests/Parser/ExplainStatement.php b/tests/Parser/ExplainStatement.php
new file mode 100644
index 0000000..3e1aaf9
--- /dev/null
+++ b/tests/Parser/ExplainStatement.php
@@ -0,0 +1,24 @@
+<?php
+
+namespace SqlParser\Tests\Parser;
+
+use SqlParser\Tests\TestCase;
+
+class ExplainStatementTest extends TestCase
+{
+
+    /**
+     * @dataProvider testExplainProvider
+     */
+    public function testExplain($test)
+    {
+        $this->runParserTest($test);
+    }
+
+    public function testExplainProvider()
+    {
+        return array(
+            array('parseExplain'),
+        );
+    }
+}
diff --git a/tests/Parser/FragmentTest.php b/tests/Parser/FragmentTest.php
deleted file mode 100644
index 638b84d..0000000
--- a/tests/Parser/FragmentTest.php
+++ /dev/null
@@ -1,20 +0,0 @@
-<?php
-
-namespace SqlParser\Tests\Parser;
-
-use SqlParser\Fragment;
-use SqlParser\Parser;
-use SqlParser\TokensList;
-use SqlParser\Fragments\ArrayFragment;
-
-use SqlParser\Tests\TestCase;
-
-class FragmentTest extends TestCase
-{
-
-    public function testDummy()
-    {
-        $this->assertEquals(null, Fragment::parse(new Parser(), new TokensList()));
-        $this->assertEquals(null, Fragment::build(new ArrayFragment()));
-    }
-}
diff --git a/tests/Parser/LimitKeywordTest.php b/tests/Parser/LimitKeywordTest.php
deleted file mode 100644
index 2e7831d..0000000
--- a/tests/Parser/LimitKeywordTest.php
+++ /dev/null
@@ -1,25 +0,0 @@
-<?php
-
-namespace SqlParser\Tests\Parser;
-
-use SqlParser\Tests\TestCase;
-
-class LimitKeywordTest extends TestCase
-{
-
-    /**
-     * @dataProvider testCallProvider
-     */
-    public function testCall($test)
-    {
-        $this->runParserTest($test);
-    }
-
-    public function testCallProvider()
-    {
-        return array(
-            array('parseLimitErr1'),
-            array('parseLimitErr2'),
-        );
-    }
-}