Esempi in PHP per Wasp\Database\Query\Projection Limit::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));
 }