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); }