"LIMIT <count>"
/** * @covers StatementBuilder::ToStatement * @covers StatementBuilder::IncreaseOffsetBy */ public function testToStatementIncreaseOffsetWithInitialOffset() { $expectedQueryBefore = 'WHERE a = b ORDER BY a LIMIT 500 OFFSET 10'; $expectedQueryAfter = 'WHERE a = b ORDER BY a LIMIT 500 OFFSET 40'; $statementBuilder = new StatementBuilder(); $statementBuilder->Limit(500)->Offset(10)->Where('a = b')->OrderBy('a'); $this->assertEquals($expectedQueryBefore, $statementBuilder->ToStatement()->query); $statementBuilder->IncreaseOffsetBy(30); $this->assertEquals($expectedQueryAfter, $statementBuilder->ToStatement()->query); }
/** * @covers StatementBuilder::ToStatement * @covers StatementBuilder::RemoveLimitAndOffset */ public function testToStatementRemoveLimitAndOffset() { $expectedQueryBefore = 'WHERE a = b ORDER BY a LIMIT 500 OFFSET 0'; $expectedQueryAfter = 'WHERE a = b ORDER BY a'; $statementBuilder = new StatementBuilder(); $statementBuilder->Limit(500)->Offset(0)->Where('a = b')->OrderBy('a'); $this->assertEquals($expectedQueryBefore, $statementBuilder->ToStatement()->query); $statementBuilder->RemoveLimitAndOffset(); $this->assertEquals($expectedQueryAfter, $statementBuilder->ToStatement()->query); }