PHP StatementBuilder::Limit 예제들

Limit() 공개 메소드

Sets the statement LIMIT clause in the form of

"LIMIT <count>"

e.g. 1000.

public Limit ( integer $count ) : StatementBuilder
$count	integer	the statement limit
리턴	StatementBuilder	a reference to this object

예제 #1

파일: StatementBuilderTest.php 프로젝트: googleads/googleads-php-lib

 /**
  * @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);
 }

예제 #2

파일: StatementBuilderTest.php 프로젝트: peak-dev/google-api-adwords-php

 /**
  * @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);
 }