/** * @covers ::offset * @covers ::getOffset * @covers ::setOffset * @covers ::clearOffset */ public function testOffset() { $query = new Query\Select(self::getDb()); $query->offset(20); $expected = new SQL\IntValue(20); $this->assertEquals($expected, $query->getOffset()); $query->clearOffset(); $this->assertEmpty($query->getOffset()); $query->setOffset($expected); $this->assertEquals($expected, $query->getOffset()); }
/** * @param Query\Select $query * @return array */ public static function parameters(Query\Select $query) { return Compiler::parameters(array($query->getColumns(), $query->getFrom(), $query->getJoin(), $query->getWhere(), $query->getGroup(), $query->getHaving(), $query->getOrder(), $query->getLimit(), $query->getOffset())); }