public function testSelectParsing()
{
$di = $this->_getDI();
// $di->get('db')->execute('select 1');
/*
$robots = Robots::query()->forUpdate(true)->execute();
return;
$robots = Robots::query()
->where("type = :type:")
->andWhere("year < 2000")
->sharedLock(true)
->bind(array("type" => "mechanical"))
->order("name")
->execute();
*/
$personnes = Personnes::find(array("conditions" => "cedula >=:d1:", "bind" => array("d1" => '1'), "shared_lock" => true, "for_update" => true));
/*
$builder = $di['modelsManager']->createBuilder()
->columns('cedula, nombres')
->from('Personnes')
->orderBy('cedula');
//->limit(500, 0);
$paginator = new Phalcon\Paginator\Adapter\QueryBuilder(array(
"builder" => $builder,
"limit"=> 10,
"page" => 2
));
$page = $paginator->getPaginate();
*/
}
public function estIssue826()
{
$this->_loadDI();
$personnes = Personnes::find();
$paginator = new Phalcon\Paginator\Adapter\Model(array('data' => $personnes, 'limit' => 1, 'page' => 1));
$paginator->setCurrentPage(2179);
$page = $paginator->getPaginate();
$this->assertEquals(count($page->items), 1);
$this->assertEquals($page->before, 2178);
$this->assertEquals($page->next, 2180);
$this->assertEquals($page->last, 2180);
$this->assertEquals($page->current, 2179);
$this->assertEquals($page->total_pages, 2180);
}
public function testModelPaginatorBind()
{
require 'unit-tests/config.db.php';
if (empty($configMysql)) {
$this->markTestSkipped('Test skipped');
return;
}
$this->_loadDI();
$personnes = Personnes::find(array("conditions" => "cedula >=:d1: AND cedula>=:d2: ", "bind" => array("d1" => '1', "d2" => "5"), "order" => "cedula, nombres", "limit" => "33"));
$paginator = new Phalcon\Paginator\Adapter\Model(array('data' => $personnes, 'limit' => 10, 'page' => 1));
//First Page
$page = $paginator->getPaginate();
$this->assertEquals(get_class($page), 'stdClass');
$this->assertEquals(count($page->items), 10);
$this->assertEquals($page->before, 1);
$this->assertEquals($page->next, 2);
$this->assertEquals($page->last, 4);
$this->assertEquals($page->limit, 10);
$this->assertEquals($page->current, 1);
$this->assertEquals($page->total_pages, 4);
}
public function testIssue2301()
{
require 'unit-tests/config.db.php';
if (empty($configMysql)) {
$this->markTestSkipped('Test skipped');
return;
}
$this->_loadDI();
$personnes = Personnes::find(array('limit' => 11));
$paginator = new Phalcon\Paginator\Adapter\Model(array('data' => $personnes, 'limit' => 10, 'page' => 1));
//First Page
$page = $paginator->getPaginate();
$this->assertEquals(get_class($page), 'stdClass');
$this->assertEquals(count($page->items), 10);
$this->assertEquals($page->before, 1);
$this->assertEquals($page->next, 2);
$this->assertEquals($page->last, 2);
$this->assertEquals($page->current, 1);
$this->assertEquals($page->total_pages, 2);
}
