diff options
Diffstat (limited to 'tests/Fragments')
-rw-r--r-- | tests/Fragments/ArrayFragmentTest.php | 40 | ||||
-rw-r--r-- | tests/Fragments/CallKeywordTest.php | 24 | ||||
-rw-r--r-- | tests/Fragments/FieldFragmentTest.php | 40 | ||||
-rw-r--r-- | tests/Fragments/FragmentTest.php | 20 | ||||
-rw-r--r-- | tests/Fragments/IntoKeywordTest.php | 25 | ||||
-rw-r--r-- | tests/Fragments/LimitKeywordTest.php | 40 | ||||
-rw-r--r-- | tests/Fragments/OptionsFragmentTest.php | 65 | ||||
-rw-r--r-- | tests/Fragments/ReferencesKeyword.php | 25 | ||||
-rw-r--r-- | tests/Fragments/ValuesKeywordTest.php | 27 | ||||
-rw-r--r-- | tests/Fragments/WhereKeywordTest.php | 26 |
10 files changed, 0 insertions, 332 deletions
diff --git a/tests/Fragments/ArrayFragmentTest.php b/tests/Fragments/ArrayFragmentTest.php deleted file mode 100644 index 9242dbb..0000000 --- a/tests/Fragments/ArrayFragmentTest.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Fragments\ArrayFragment; - -use SqlParser\Tests\TestCase; - -class ArrayFragmentTest extends TestCase -{ - - public function testBuildRaw() - { - $fragment = new ArrayFragment(array('a', 'b'), array()); - $this->assertEquals('(a, b)', ArrayFragment::build($fragment)); - } - - public function testBuildValues() - { - $fragment = new ArrayFragment(array(), array('a', 'b')); - $this->assertEquals('(a, b)', ArrayFragment::build($fragment)); - } - - /** - * @dataProvider testParseProvider - */ - public function testParse($test) - { - $this->runParserTest($test); - } - - public function testParseProvider() - { - return array( - array('parseArrayErr1'), - array('parseArrayErr2'), - array('parseArrayErr3'), - ); - } -} diff --git a/tests/Fragments/CallKeywordTest.php b/tests/Fragments/CallKeywordTest.php deleted file mode 100644 index b7714af..0000000 --- a/tests/Fragments/CallKeywordTest.php +++ /dev/null @@ -1,24 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Fragments\ArrayFragment; -use SqlParser\Fragments\CallKeyword; - -use SqlParser\Tests\TestCase; - -class CallKeywordTest extends TestCase -{ - - public function testBuildArray() - { - $fragment = new CallKeyword('func', array('a', 'b')); - $this->assertEquals('func(a, b)', CallKeyword::build($fragment)); - } - - public function testBuildArrayFragment() - { - $fragment = new CallKeyword('func', new ArrayFragment(array('a', 'b'))); - $this->assertEquals('func(a, b)', CallKeyword::build($fragment)); - } -} diff --git a/tests/Fragments/FieldFragmentTest.php b/tests/Fragments/FieldFragmentTest.php deleted file mode 100644 index a86248b..0000000 --- a/tests/Fragments/FieldFragmentTest.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\FieldFragment; - -use SqlParser\Tests\TestCase; - -class FieldFragmentTest extends TestCase -{ - - public function testParse() - { - $fragment = FieldFragment::parse(new Parser(), $this->getTokensList('IF(film_id > 0, film_id, film_id)')); - $this->assertEquals($fragment->expr, 'IF(film_id > 0, film_id, film_id)'); - } - - public function testParseErr1() - { - $parser = new Parser(); - FieldFragment::parse($parser, $this->getTokensList('(1))')); - $errors = $this->getErrorsAsArray($parser); - $this->assertEquals($errors[0][0], 'Unexpected bracket.'); - } - - public function testParseErr2() - { - $parser = new Parser(); - FieldFragment::parse($parser, $this->getTokensList('tbl..col')); - $errors = $this->getErrorsAsArray($parser); - $this->assertEquals($errors[0][0], 'Unexpected dot.'); - } - - public function testBuild() - { - $fragment = new FieldFragment('1 + 2', 'three'); - $this->assertEquals(FieldFragment::build($fragment), '1 + 2 AS `three`'); - } -} diff --git a/tests/Fragments/FragmentTest.php b/tests/Fragments/FragmentTest.php deleted file mode 100644 index 638b84d..0000000 --- a/tests/Fragments/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/Fragments/IntoKeywordTest.php b/tests/Fragments/IntoKeywordTest.php deleted file mode 100644 index 351de13..0000000 --- a/tests/Fragments/IntoKeywordTest.php +++ /dev/null @@ -1,25 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\IntoKeyword; - -use SqlParser\Tests\TestCase; - -class IntoKeywordTest extends TestCase -{ - - public function testParse() - { - $fragment = IntoKeyword::parse(new Parser(), $this->getTokensList('OUTFILE "/tmp/outfile.txt"')); - $this->assertEquals($fragment->type, 'OUTFILE'); - $this->assertEquals($fragment->dest, '/tmp/outfile.txt'); - } - - public function testParseErr1() - { - $fragment = IntoKeyword::parse(new Parser(), $this->getTokensList('OUTFILE;')); - $this->assertEquals($fragment->type, 'OUTFILE'); - } -} diff --git a/tests/Fragments/LimitKeywordTest.php b/tests/Fragments/LimitKeywordTest.php deleted file mode 100644 index ff97cf0..0000000 --- a/tests/Fragments/LimitKeywordTest.php +++ /dev/null @@ -1,40 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\LimitKeyword; - -use SqlParser\Tests\TestCase; - -class LimitKeywordTest extends TestCase -{ - - public function testBuild() - { - $fragment = new LimitKeyword(1); - $this->assertEquals(LimitKeyword::build($fragment), '1'); - } - - public function testBuildWithOffset() - { - $fragment = new LimitKeyword(1, 2); - $this->assertEquals(LimitKeyword::build($fragment), '2, 1'); - } - - /** - * @dataProvider testParseProvider - */ - public function testParse($test) - { - $this->runParserTest($test); - } - - public function testParseProvider() - { - return array( - array('parseLimitErr1'), - array('parseLimitErr2'), - ); - } -} diff --git a/tests/Fragments/OptionsFragmentTest.php b/tests/Fragments/OptionsFragmentTest.php deleted file mode 100644 index 8fe596d..0000000 --- a/tests/Fragments/OptionsFragmentTest.php +++ /dev/null @@ -1,65 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\OptionsFragment; - -use SqlParser\Tests\TestCase; - -class OptionsFragmentTest extends TestCase -{ - - public function testParse() - { - $fragment = OptionsFragment::parse( - new Parser(), - $this->getTokensList('A B = (test) C'), - array( - 'A' => 1, - 'B' => array(2, 'var'), - 'C' => 3, - ) - ); - $this->assertEquals( - array( - 1 => 'A', - 2 => array( - 'name' => 'B', - 'value' => 'test', - 'value_' => 'test', - 'equal' => false, - ), - 3 => 'C', - ), - $fragment->options - ); - } - - public function testMerge() - { - $fragment = new OptionsFragment(array('a')); - $fragment->merge(array('b', 'c')); - $this->assertEquals($fragment->options, array('a', 'b', 'c')); - } - - public function testBuild() - { - $fragment = new OptionsFragment( - array( - 'ALL', - 'SQL_CALC_FOUND_ROWS', - array( - 'name' => 'MAX_STATEMENT_TIME', - 'value' => '42', - 'value_' => '42', - 'equal' => true, - ), - ) - ); - $this->assertEquals( - OptionsFragment::build($fragment), - 'ALL SQL_CALC_FOUND_ROWS MAX_STATEMENT_TIME=42' - ); - } -} diff --git a/tests/Fragments/ReferencesKeyword.php b/tests/Fragments/ReferencesKeyword.php deleted file mode 100644 index 9f874ec..0000000 --- a/tests/Fragments/ReferencesKeyword.php +++ /dev/null @@ -1,25 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\ReferencesKeyword; - -use SqlParser\Tests\TestCase; - -class ReferencesKeywordTest extends TestCase -{ - - public function testParse() - { - $fragment = ReferencesKeyword::parse(new Parser(), $this->getTokensList('tbl (id)')); - $this->assertEquals('tbl', $fragment->table); - $this->assertEquals(array('id'), $fragment->columns); - } - - public function testBuild() - { - $fragment = new ReferencesKeyword('tbl', array('id')); - $this->assertEquals('`tbl` (`id`)', ReferencesKeyword::build($fragment)); - } -} diff --git a/tests/Fragments/ValuesKeywordTest.php b/tests/Fragments/ValuesKeywordTest.php deleted file mode 100644 index 4507bcb..0000000 --- a/tests/Fragments/ValuesKeywordTest.php +++ /dev/null @@ -1,27 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\ValuesKeyword; - -use SqlParser\Tests\TestCase; - -class ValuesKeywordTest extends TestCase -{ - - public function testParseErr1() - { - $parser = new Parser(); - ValuesKeyword::parse($parser, $this->getTokensList('(1, 2 +')); - // TODO: Assert errors. - } - - public function testParseErr2() - { - $parser = new Parser(); - ValuesKeyword::parse($parser, $this->getTokensList('(1, 2 TABLE')); - // TODO: Assert errors. - } - -} diff --git a/tests/Fragments/WhereKeywordTest.php b/tests/Fragments/WhereKeywordTest.php deleted file mode 100644 index ded3a80..0000000 --- a/tests/Fragments/WhereKeywordTest.php +++ /dev/null @@ -1,26 +0,0 @@ -<?php - -namespace SqlParser\Tests\Fragments; - -use SqlParser\Parser; -use SqlParser\Fragments\WhereKeyword; - -use SqlParser\Tests\TestCase; - -class WhereKeywordTest extends TestCase -{ - - public function testParse() - { - $fragment = WhereKeyword::parse(new Parser(), $this->getTokensList('/* id = */ id = 10')); - $this->assertEquals($fragment[0]->expr, 'id = 10'); - } - - public function testParseBetween() - { - $fragment = WhereKeyword::parse(new Parser(), $this->getTokensList('(id BETWEEN 10 AND 20) OR (id BETWEEN 30 AND 40)')); - $this->assertEquals($fragment[0]->expr, '(id BETWEEN 10 AND 20)'); - $this->assertEquals($fragment[1]->expr, 'OR'); - $this->assertEquals($fragment[2]->expr, '(id BETWEEN 30 AND 40)'); - } -} |