protected function _executeTestsRenamed($di)
{
$robot = new Robotters();
$success = $robot->save(array('theType' => 'mechanical', 'theYear' => 2018));
$this->assertEquals($success, false);
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals($robot->theYear, 2018);
$robot = new Robotters();
$robot->assign(array('theType' => 'mechanical', 'theYear' => 2018));
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals($robot->theYear, 2018);
}
protected function _executeTestsRenamed($di)
{
$robot = Robotters::findFirstByCode(1);
$this->assertEquals(get_class($robot), 'Robotters');
$this->assertEquals($robot->code, 1);
$robot = Robotters::findFirstByCode(2);
$this->assertEquals(get_class($robot), 'Robotters');
$this->assertEquals($robot->code, 2);
$robots = Robotters::findByTheType('mechanical');
$this->assertEquals(count($robots), 2);
$this->assertEquals($robots[0]->code, 1);
$number = Robotters::countByTheType('mechanical');
$this->assertEquals($number, 2);
}
public function _executeTestsRenamed($di)
{
$manager = $di->getShared('modelsManager');
$success = $manager->existsBelongsTo('RobottersDeles', 'Robotters');
$this->assertTrue($success);
$success = $manager->existsBelongsTo('RobottersDeles', 'Deles');
$this->assertTrue($success);
$success = $manager->existsHasMany('Robotters', 'RobottersDeles');
$this->assertTrue($success);
$success = $manager->existsHasMany('Deles', 'RobottersDeles');
$this->assertTrue($success);
$robotter = Robotters::findFirst();
$this->assertNotEquals($robotter, false);
$robottersDeles = $robotter->getRobottersDeles();
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 3);
/** Passing parameters to magic methods **/
$robottersDeles = $robotter->getRobottersDeles("delesCode = 1");
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 1);
$robottersDeles = $robotter->getRobottersDeles(array("delesCode > :delesCode:", "bind" => array("delesCode" => 1)));
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 2);
$this->assertEquals($robottersDeles->getFirst()->delesCode, 2);
$robottersDeles = $robotter->getRobottersDeles(array("delesCode > :delesCode:", "bind" => array("delesCode" => 1), "order" => "delesCode DESC"));
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 2);
$this->assertEquals($robottersDeles->getFirst()->delesCode, 3);
/** Magic counting */
$number = $robotter->countRobottersDeles();
$this->assertEquals($number, 3);
$dele = Deles::findFirst();
$this->assertNotEquals($dele, false);
$robottersDeles = $dele->getRobottersDeles();
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 1);
$number = $dele->countRobottersDeles();
$this->assertEquals($number, 1);
$robotterDele = RobottersDeles::findFirst();
$this->assertNotEquals($robotterDele, false);
$robotter = $robotterDele->getRobotters();
$this->assertEquals(get_class($robotter), 'Robotters');
$dele = $robotterDele->getDeles();
$this->assertEquals(get_class($dele), 'Deles');
/** Relations in namespaced models */
$robotter = Some\Robotters::findFirst();
$this->assertNotEquals($robotter, false);
$robottersDeles = $robotter->getRobottersDeles();
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 3);
$robottersDeles = $robotter->getRobottersDeles("delesCode = 1");
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 1);
$robottersDeles = $robotter->getRobottersDeles(array("delesCode > :delesCode:", "bind" => array("delesCode" => 1), "order" => "delesCode DESC"));
$this->assertEquals(get_class($robottersDeles), 'Phalcon\\Mvc\\Model\\Resultset\\Simple');
$this->assertEquals(count($robottersDeles), 2);
$this->assertEquals($robottersDeles->getFirst()->delesCode, 3);
}
protected function _executeTestsRenamed($di)
{
$this->_prepareDb($di->getShared('db'));
$params = array();
$this->assertTrue(Personers::count($params) > 0);
$params = array("status = 'I'");
$this->assertTrue(Personers::count($params) > 0);
$params = "status='I'";
$this->assertTrue(Personers::count($params) > 0);
$params = array("conditions" => "status='I'");
$this->assertTrue(Personers::count($params) > 0);
//Find first
$personer = Personers::findFirst();
$this->assertTrue(is_object($personer));
$this->assertEquals(get_class($personer), 'Personers');
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$personer = Personers::findFirst("status = 'I'");
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$personer = Personers::findFirst(array("status='I'"));
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$params = array("conditions" => "status='I'");
$personer = Personers::findFirst($params);
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$params = array("conditions" => "status='A'", "order" => "navnes");
$personer = Personers::findFirst($params);
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$params = array("status='A'", "order" => "navnes DESC", "limit" => 30);
$personer = Personers::findFirst($params);
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$params = array("status=?1", "bind" => array(1 => 'A'), "order" => "navnes DESC", "limit" => 30);
$personer = Personers::findFirst($params);
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$params = array("status=:status:", "bind" => array("status" => 'A'), "order" => "navnes DESC", "limit" => 30);
$personer = Personers::findFirst($params);
$this->assertTrue(is_object($personer));
$this->assertTrue(isset($personer->navnes));
$this->assertTrue(isset($personer->status));
$robotter = Robotters::findFirst(1);
$this->assertEquals(get_class($robotter), 'Robotters');
//Find tests
$personers = Personers::find();
$this->assertTrue(count($personers) > 0);
$personers = Personers::find("status='I'");
$this->assertTrue(count($personers) > 0);
$personers = Personers::find(array("status='I'"));
$this->assertTrue(count($personers) > 0);
$personers = Personers::find(array("status='I'", "order" => "navnes"));
$this->assertTrue(count($personers) > 0);
$params = array("status='I'", "order" => "navnes", "limit" => 100);
$personers = Personers::find($params);
$this->assertTrue(count($personers) > 0);
$params = array("status=?1", "bind" => array(1 => "A"), "order" => "navnes", "limit" => 100);
$personers = Personers::find($params);
$this->assertTrue(count($personers) > 0);
$params = array("status=:status:", "bind" => array('status' => "A"), "order" => "navnes", "limit" => 100);
$personers = Personers::find($params);
$this->assertTrue(count($personers) > 0);
//Traverse the cursor
$number = 0;
$personers = Personers::find(array("conditions" => "status='A'", "order" => "navnes", "limit" => 20));
foreach ($personers as $personer) {
$number++;
}
$this->assertEquals($number, 20);
$personer = new Personers($di);
$personer->borgerId = 'CELL' . mt_rand(0, 999999);
$this->assertFalse($personer->save());
//Messages
$this->assertEquals(count($personer->getMessages()), 4);
$messages = array(0 => ModelMessage::__set_state(array('_type' => 'PresenceOf', '_message' => 'slagBorgerId is required', '_field' => 'slagBorgerId')), 1 => ModelMessage::__set_state(array('_type' => 'PresenceOf', '_message' => 'navnes is required', '_field' => 'navnes')), 2 => ModelMessage::__set_state(array('_type' => 'PresenceOf', '_message' => 'kredit is required', '_field' => 'kredit')), 3 => ModelMessage::__set_state(array('_type' => 'PresenceOf', '_message' => 'status is required', '_field' => 'status')));
$this->assertEquals($personer->getMessages(), $messages);
//Save
$personer = new Personers($di);
$personer->borgerId = 'CELL' . mt_rand(0, 999999);
$personer->slagBorgerId = 1;
$personer->navnes = 'LOST';
$personer->telefon = '1';
$personer->kredit = 20000;
$personer->status = 'A';
$this->assertTrue($personer->save());
$personer = new Personers($di);
$personer->borgerId = 'CELL' . mt_rand(0, 999999);
$personer->slagBorgerId = 1;
$personer->navnes = 'LOST LOST';
$personer->telefon = '2';
$personer->kredit = 0;
$personer->status = 'X';
$this->assertTrue($personer->save());
//Check correct save
$personer = Personers::findFirst(array("status='X'"));
$this->assertNotEquals($personer, false);
$this->assertEquals($personer->navnes, 'LOST LOST');
$this->assertEquals($personer->status, 'X');
//Update
$personer->kredit = 150000;
$personer->telefon = '123';
$this->assertTrue($personer->update());
//Checking correct update
$personer = Personers::findFirst(array("status='X'"));
$this->assertNotEquals($personer, false);
$this->assertEquals($personer->kredit, 150000);
$this->assertEquals($personer->telefon, '123');
//Update
$this->assertTrue($personer->update(array('navnes' => 'LOST UPDATE', 'telefon' => '2121')));
//Checking correct update
$personer = Personers::findFirst(array("status='X'"));
$this->assertNotEquals($personer, false);
$this->assertEquals($personer->navnes, 'LOST UPDATE');
$this->assertEquals($personer->telefon, '2121');
//Create
$personer = new Personers($di);
$personer->borgerId = 'CELL' . mt_rand(0, 999999);
$personer->slagBorgerId = 1;
$personer->navnes = 'LOST CREATE';
$personer->telefon = '2';
$personer->kredit = 21000;
$personer->status = 'A';
$this->assertTrue($personer->save());
$personer = new Personers($di);
$this->assertTrue($personer->create(array('borgerId' => 'CELL' . mt_rand(0, 999999), 'slagBorgerId' => 1, 'navnes' => 'LOST CREATE', 'telefon' => '1', 'kredit' => 21000, 'status' => 'A')));
//Deleting
$before = Personers::count();
$this->assertTrue($personer->delete());
$this->assertEquals($before - 1, Personers::count());
//Assign
$personer = new Personers();
$personer->assign(array('slagBorgerId' => 1, 'navnes' => 'LOST CREATE', 'telefon' => '1', 'kredit' => 21000, 'status' => 'A'));
$expected = array('borgerId' => NULL, 'slagBorgerId' => 1, 'navnes' => 'LOST CREATE', 'telefon' => '1', 'adresse' => NULL, 'elektroniskPost' => NULL, 'fodtDato' => NULL, 'fodebyId' => NULL, 'skabtPa' => NULL, 'kredit' => 21000, 'status' => 'A');
$this->assertEquals($personer->toArray(), $expected);
//Refresh
$personer = Personers::findFirst();
$personerData = $personer->toArray();
$personer->assign(array('slagBorgerId' => 1, 'navnes' => 'LOST CREATE', 'telefon' => '1', 'kredit' => 21000, 'status' => 'A'));
$personer->refresh();
$this->assertEquals($personerData, $personer->toArray());
}
protected function _executeTestsRenamed($di)
{
$number = 0;
$robots = Robotters::find();
foreach ($robots as $robot) {
$this->assertTrue(is_object($robot));
$this->assertEquals(get_class($robot), 'Robotters');
$number++;
}
$robots->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_RECORDS);
foreach ($robots as $robot) {
$this->assertTrue(is_object($robot));
$this->assertEquals(get_class($robot), 'Robotters');
$number++;
}
$robots->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_ARRAYS);
foreach ($robots as $robot) {
$this->assertTrue(is_array($robot));
$this->assertEquals(count($robot), 4);
$number++;
}
$robots->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_OBJECTS);
foreach ($robots as $robot) {
$this->assertTrue(is_object($robot));
$this->assertEquals(get_class($robot), 'stdClass');
$number++;
}
$this->assertEquals($number, 12);
$number = 0;
$people = Personers::find(array('limit' => 33));
foreach ($people as $person) {
$this->assertTrue(is_object($person));
$this->assertEquals(get_class($person), 'Personers');
$number++;
}
$people->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_RECORDS);
foreach ($people as $person) {
$this->assertTrue(is_object($person));
$this->assertEquals(get_class($person), 'Personers');
$number++;
}
$people->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_ARRAYS);
foreach ($people as $person) {
$this->assertTrue(is_array($person));
$this->assertTrue(isset($person['navnes']));
$number++;
}
$people->setHydrateMode(Phalcon\Mvc\Model\Resultset::HYDRATE_OBJECTS);
foreach ($people as $person) {
$this->assertTrue(is_object($person));
$this->assertEquals(get_class($person), 'stdClass');
$this->assertTrue(isset($person->navnes));
$number++;
}
$this->assertEquals($number, 33 * 4);
}
public function _executeTestsRenamed($di)
{
//Normal foreign keys with column renaming
$robottersDeles = new RobottersDeles();
$robottersDeles->robottersCode = 1;
$robottersDeles->delesCode = 100;
$this->assertFalse($robottersDeles->save());
$messages = array(0 => Phalcon\Mvc\Model\Message::__set_state(array('_type' => 'ConstraintViolation', '_message' => 'Value of field "delesCode" does not exist on referenced table', '_field' => 'delesCode')));
$this->assertEquals($robottersDeles->getMessages(), $messages);
$robottersDeles->robottersCode = 100;
$robottersDeles->delesCode = 1;
$this->assertFalse($robottersDeles->save());
$messages = array(0 => Phalcon\Mvc\Model\Message::__set_state(array('_type' => 'ConstraintViolation', '_message' => 'The robotters code does not exist', '_field' => 'robottersCode')));
$this->assertEquals($robottersDeles->getMessages(), $messages);
//Reverse foreign keys with renaming
$robotter = Robotters::findFirst();
$this->assertNotEquals($robotter, false);
$this->assertFalse($robotter->delete());
$messages = array(0 => Phalcon\Mvc\Model\Message::__set_state(array('_type' => 'ConstraintViolation', '_message' => 'Record is referenced by model RobottersDeles', '_field' => 'code')));
$this->assertEquals($robotter->getMessages(), $messages);
$dele = Deles::findFirst();
$this->assertNotEquals($dele, false);
$this->assertFalse($dele->delete());
$messages = array(0 => Phalcon\Mvc\Model\Message::__set_state(array('_type' => 'ConstraintViolation', '_message' => 'Deles cannot be deleted because is referenced by a Robotter', '_field' => 'code')));
$this->assertEquals($dele->getMessages(), $messages);
}
protected function _executeTestsRenamed($di)
{
$robot = new Robotters();
$success = $robot->save(array('theType' => 'mechanical', 'theYear' => 2018));
$this->assertEquals($success, false);
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals($robot->theYear, 2018);
//assign uses column renaming
$robot = new Robotters();
$robot->assign(array('theType' => 'mechanical', 'theYear' => 2018));
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals($robot->theYear, 2018);
//not assigns nonexistent fields
$robot = new Robotters();
$robot->assign(array('field1' => 'mechanical', 'field2' => 2018));
$this->assertEquals(empty($robot->field1), true);
$this->assertEquals(empty($robot->field2), true);
//white list
$robot = new Robotters();
$robot->assign(array('theType' => 'mechanical', 'theYear' => 2018), null, array('theType'));
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals(empty($robot->theYear), true);
//white list & custom mapping
$robot = new Robotters();
$robot->assign(array('theTypeFromClient' => 'mechanical', 'theYearFromClient' => 2018), array('theTypeFromClient' => 'theType', 'theYearFromClient' => 'theYear'), array('theType'));
$this->assertEquals($robot->theType, 'mechanical');
$this->assertEquals(empty($robot->theYear), true);
}
