protected function _executeTestsNormal($di)
{
$personas = Personas::query()->where("estado=?1")->bind(array(1 => "A"))->order("nombres")->limit(100, 10)->execute();
return;
$people = People::find(array("estado=?1", "bind" => array(1 => "A"), "order" => "nombres", "limit" => array('number' => 100, 'offset' => 10)));
$this->assertEquals(count($personas), count($people));
return;
$personas = Personas::query()->where("estado='I'")->execute();
$people = People::find("estado='I'");
$this->assertEquals(count($personas), count($people));
$personas = Personas::query()->conditions("estado='I'")->execute();
$people = People::find("estado='I'");
$this->assertEquals(count($personas), count($people));
$personas = Personas::query()->where("estado='A'")->order("nombres")->execute();
$people = People::find(array("estado='A'", "order" => "nombres"));
$this->assertEquals(count($personas), count($people));
$somePersona = $personas->getFirst();
$somePeople = $people->getFirst();
$this->assertEquals($somePersona->cedula, $somePeople->cedula);
//Order + limit
$personas = Personas::query()->where("estado='A'")->order("nombres")->limit(100)->execute();
$people = People::find(array("estado='A'", "order" => "nombres", "limit" => 100));
$this->assertEquals(count($personas), count($people));
$somePersona = $personas->getFirst();
$somePeople = $people->getFirst();
$this->assertEquals($somePersona->cedula, $somePeople->cedula);
//Bind params + Limit
$personas = Personas::query()->where("estado=?1")->bind(array(1 => "A"))->order("nombres")->limit(100)->execute();
$people = People::find(array("estado=?1", "bind" => array(1 => "A"), "order" => "nombres", "limit" => 100));
$this->assertEquals(count($personas), count($people));
$somePersona = $personas->getFirst();
$somePeople = $people->getFirst();
$this->assertEquals($somePersona->cedula, $somePeople->cedula);
//Limit + Offset
$personas = Personas::query()->where("estado=?1")->bind(array(1 => "A"))->order("nombres")->limit(100, 10)->execute();
$people = People::find(array("estado=?1", "bind" => array(1 => "A"), "order" => "nombres", "limit" => array('number' => 100, 'offset' => 10)));
$this->assertEquals(count($personas), count($people));
$somePersona = $personas->getFirst();
$somePeople = $people->getFirst();
$this->assertEquals($somePersona->cedula, $somePeople->cedula);
$personas = Personas::query()->where("estado=:estado:")->bind(array("estado" => "A"))->order("nombres")->limit(100)->execute();
$people = People::find(array("estado=:estado:", "bind" => array("estado" => "A"), "order" => "nombres", "limit" => 100));
$this->assertEquals(count($personas), count($people));
$somePersona = $personas->getFirst();
$somePeople = $people->getFirst();
$this->assertEquals($somePersona->cedula, $somePeople->cedula);
}
public function _executeTestIssues2131($di)
{
$di->set('modelsCache', function () {
$frontCache = new Phalcon\Cache\Frontend\Data();
$modelsCache = new Phalcon\Cache\Backend\File($frontCache, array('cacheDir' => 'unit-tests/cache/'));
$modelsCache->delete("cache-2131");
return $modelsCache;
}, true);
$personas = Personas::query()->where("estado='I'")->cache(array("key" => "cache-2131"))->execute();
$this->assertTrue($personas->isFresh());
$personas = Personas::query()->where("estado='I'")->cache(array("key" => "cache-2131"))->execute();
$this->assertFalse($personas->isFresh());
}
public function _executeTestRawSQL($di)
{
$personas = Personas::query()->where("estado='X'")->execute();
$this->assertTrue(count($personas) == 0);
$ret = Personas::query()->update(array("estado" => "X"))->where("estado='I'")->execute(TRUE);
$personas = Personas::query()->where("estado='X'")->execute();
$this->assertTrue(count($personas) > 0);
$ret = Personas::query()->update(array("estado" => "I"))->where("estado='X'")->execute(TRUE);
$personas = Personas::query()->where("estado='X'")->execute();
$this->assertTrue(count($personas) == 0);
}
