diff options
-rw-r--r-- | tests/Builder/SelectStatementTest.php | 23 |
1 files changed, 23 insertions, 0 deletions
diff --git a/tests/Builder/SelectStatementTest.php b/tests/Builder/SelectStatementTest.php index 6f09888..a2dd5af 100644 --- a/tests/Builder/SelectStatementTest.php +++ b/tests/Builder/SelectStatementTest.php @@ -53,4 +53,27 @@ class SelectStatementTest extends TestCase $stmt->build() ); } + + public function testBuilderEndOptions() + { + /* Assertion 1 */ + $query = 'SELECT pid, name2 FROM tablename WHERE pid = 20 FOR UPDATE '; + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals( + $query, + $stmt->build() + ); + + /* Assertion 2 */ + $query = 'SELECT pid, name2 FROM tablename WHERE pid = 20 LOCK IN SHARE MODE '; + $parser = new Parser($query); + $stmt = $parser->statements[0]; + + $this->assertEquals( + $query, + $stmt->build() + ); + } } |