public function testShouldProduceSelectStatementWithLimit() { $table = "test"; $sql = Query::getInstance()->select()->from($table)->limit(Limit::limit(1, 100))->build(); $expectedSql = "SELECT * FROM {$table} LIMIT 1 OFFSET 100"; $this->assertThat($sql, $this->equalTo($expectedSql)); }
/** * Add a limit, offset clause to query * * @param Limit $limit * @return Query */ public function limit(Limit $limit) { $this->limit = $limit->toSql(); return $this; }