PHP Oops_Sql_Selector::select примеры использования

Пример #1

Файл: Oops_Sql_SelectorTest.php Проект: laiello/oops-project

 /**
  * Tests Oops_Sql_Selector->limit()
  */
 public function testLimit()
 {
     $this->Oops_Sql_Selector->resetAll();
     $this->Oops_Sql_Selector->limit(10);
     $this->assertEquals("SELECT `testPrimaryKey`, `testField1`, `testField2`, `testField3` FROM `testDatabase`.`testTable` LIMIT 0, 10", $this->Oops_Sql_Selector->select(true));
     $this->Oops_Sql_Selector->limit(50, 10);
     $this->assertEquals("SELECT `testPrimaryKey`, `testField1`, `testField2`, `testField3` FROM `testDatabase`.`testTable` LIMIT 10, 50", $this->Oops_Sql_Selector->select(true));
     $this->Oops_Sql_Selector->limit(0);
     $this->assertEquals("SELECT `testPrimaryKey`, `testField1`, `testField2`, `testField3` FROM `testDatabase`.`testTable`", $this->Oops_Sql_Selector->select(true));
 }