PHP SQLQuery::canSortBy 예제들

예제 #1

파일: SQLQueryTest.php 프로젝트: jakedaleweb/AtomCodeChallenge

 public function testCanSortBy()
 {
     $query = new SQLQuery();
     $query->setSelect("Name", "Meta")->setFrom("MyTable")->setWhere("Name = 'Name'")->addWhere("Meta = 'Test'");
     $this->assertTrue($query->canSortBy('Name ASC'));
     $this->assertTrue($query->canSortBy('Name'));
 }

예제 #2

 function testCanSortBy()
 {
     $query = new SQLQuery();
     $query->select("Name", "Meta")->from("MyTable")->where("Name", "Name")->where("Meta", "Test");
     $this->assertTrue($query->canSortBy('Name ASC'));
     $this->assertTrue($query->canSortBy('Name'));
 }