Esempi in PHP per Wasp\Database\Query\Projection Limit

Esempio n. 1

File: QueryTest.php Progetto: waspframework/waspframework

 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));
 }

Esempio n. 2

File: Query.php Progetto: waspframework/waspframework

 /**
  * Add a limit, offset clause to query
  *
  * @param Limit $limit
  * @return Query
  */
 public function limit(Limit $limit)
 {
     $this->limit = $limit->toSql();
     return $this;
 }