Refactored field to something more appropriate depending on the context in which it is used.

1 files changed, 67 insertions, 0 deletions

diff --git a/tests/Components/CreateDefinitionTest.php b/tests/Components/CreateDefinitionTest.php
new file mode 100644
index 0000000..81c8ba8
--- /dev/null
+++ b/tests/Components/CreateDefinitionTest.php
@@ -0,0 +1,67 @@
+<?php
+
+namespace SqlParser\Tests\Components;
+
+use SqlParser\Parser;
+use SqlParser\Components\CreateDefinition;
+
+use SqlParser\Tests\TestCase;
+
+class CreateDefinitionTest extends TestCase
+{
+
+    public function testParse()
+    {
+        $component = CreateDefinition::parse(
+            new Parser(),
+            $this->getTokensList('(str TEXT, FULLTEXT INDEX indx (str))')
+        );
+        $this->assertEquals('str', $component[0]->name);
+        $this->assertEquals('FULLTEXT INDEX', $component[1]->key->type);
+        $this->assertEquals('indx', $component[1]->key->name);
+        $this->assertEquals('FULLTEXT INDEX `indx` (`str`)', $component[1]);
+    }
+
+    public function testParseErr1()
+    {
+        $parser = new Parser();
+        $component = CreateDefinition::parse(
+            $parser,
+            $this->getTokensList('(str TEXT, FULLTEXT INDEX indx (str)')
+        );
+
+        $this->assertEquals(
+            'A closing bracket was expected.',
+            $parser->errors[0]->getMessage()
+        );
+    }
+
+    public function testParseErr2()
+    {
+        $parser = new Parser();
+        $component = CreateDefinition::parse(
+            $parser,
+            $this->getTokensList(')')
+        );
+
+        $this->assertEquals(
+            'An opening bracket was expected.',
+            $parser->errors[0]->getMessage()
+        );
+    }
+
+    public function testBuild()
+    {
+        $parser = new Parser(
+            'CREATE TABLE `payment` (' .
+            '-- snippet' . "\n" .
+            '`customer_id` smallint(5) unsigned NOT NULL,' .
+            'CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE' .
+            ') ENGINE=InnoDB"'
+        );
+        $this->assertEquals(
+            'CONSTRAINT `fk_payment_customer` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`customer_id`) ON UPDATE CASCADE',
+            CreateDefinition::build($parser->statements[0]->fields[1])
+        );
+    }
+}