Find this useful? Enter your email to receive occasional updates for securing PHP code.

Signing you up...

Thank you for signing up!

PHP Decode

<?php namespace Phalcon\Tests\Integration\Mvc\Model; use IntegrationTester; use Phalcon\T..

Decoded Output download

<?php
 namespace Phalcon\Tests\Integration\Mvc\Model; use IntegrationTester; use Phalcon\Tests\Fixtures\Traits\DiTrait; class ModelsQueryExecuteCest { use DiTrait; public function _before(IntegrationTester $I) { $this->setNewFactoryDefault(); } public function _after(IntegrationTester $I) { $this->container["db"]->close(); } public function testExecuteMysql(IntegrationTester $I) { $this->setDiMysql(); $this->testSelectExecute($I); $this->testSelectRenamedExecute($I); $this->testInsertExecute($I); $this->testInsertRenamedExecute($I); $this->testUpdateExecute($I); $this->testUpdateRenamedExecute($I); $this->testDeleteExecute($I); $this->testDeleteRenamedExecute($I); } public function testExecutePostgresql(IntegrationTester $I) { $this->setDiPostgresql(); $this->testSelectExecute($I); $this->testSelectRenamedExecute($I); $this->testInsertExecute($I); $this->testInsertRenamedExecute($I); $this->testUpdateExecute($I); $this->testUpdateRenamedExecute($I); $this->testDeleteExecute($I); $this->testDeleteRenamedExecute($I); } public function testExecuteSqlite(IntegrationTester $I) { $this->setDiSqlite(); } private function testSelectExecute(IntegrationTester $I) { $I->skipTest("TODO - Check the numbers on this test"); $manager = $this->container->getShared("modelsManager"); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots ORDER BY 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots ORDER BY id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots ORDER BY Phalcon\Tests\Models\Robots.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.* FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("SELECT r.* FROM Phalcon\Tests\Models\Robots r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots AS r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robots AS r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $result = $manager->executeQuery("SELECT id, name FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.name FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT LENGTH(name) AS the_length FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals(8, $result[0]->the_length); $result = $manager->executeQuery("SELECT LENGTH(Phalcon\Tests\Models\Robots.name) AS the_length " . "FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals(8, $result[0]->the_length); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots WHERE id = 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots WHERE id = ?0", array(0 => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots WHERE id = :id:", array("id" => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots WHERE id = "1""); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT r.year FROM Phalcon\Tests\Models\Robots r WHERE TRIM(name) != "Robotina""); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots ORDER BY id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(3, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots ORDER BY id LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.id+1 AS nextId " . "FROM Phalcon\Tests\Models\Robots ORDER BY id DESC LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(4, $result[0]->nextId); $result = $manager->executeQuery("SELECT r.name FROM Phalcon\Tests\Models\Robots r ORDER BY r.name DESC LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->name)); $I->assertEquals($result[0]->name, "Terminator"); $result = $manager->executeQuery("SELECT name le_name FROM Phalcon\Tests\Models\Robots ORDER BY name ASC LIMIT 4"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("Astro Boy", $result[0]->le_name); $result = $manager->executeQuery("SELECT r.name le_name FROM Phalcon\Tests\Models\Robots r ORDER BY r.name ASC LIMIT 4"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("Astro Boy", $result[0]->le_name); $result = $manager->executeQuery("SELECT r.name le_name FROM Phalcon\Tests\Models\Robots r ORDER BY r.name ASC LIMIT 1,2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("Robotina", $result[0]->le_name); $result = $manager->executeQuery("SELECT r.name le_name " . "FROM Phalcon\Tests\Models\Robots r ORDER BY r.name ASC LIMIT 2 OFFSET 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("Robotina", $result[0]->le_name); $result = $manager->executeQuery("SELECT r.type, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robots r GROUP BY 1 ORDER BY r.type ASC"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(2, $result[1]->number); $result = $manager->executeQuery("SELECT r.type, SUM(r.year-1000) age " . "FROM Phalcon\Tests\Models\Robots r GROUP BY 1 ORDER BY 2 DESC"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(1924, $result[0]->age); $result = $manager->executeQuery("SELECT r.type, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robots r GROUP BY 1 HAVING COUNT(*) = 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(2, $result[0]->number); $result = $manager->executeQuery("SELECT r.type, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robots r GROUP BY 1 HAVING COUNT(*) < 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(1, $result); $I->assertEquals(1, $result[0]->number); $result = $manager->executeQuery("SELECT r.id, r.* FROM Phalcon\Tests\Models\Robots r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->id); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.*, Phalcon\Tests\Models\RobotsParts.* " . "FROM Phalcon\Tests\Models\Robots JOIN Phalcon\Tests\Models\RobotsParts " . "ORDER BY Phalcon\Tests\Models\Robots.id, Phalcon\Tests\Models\RobotsParts.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->robots)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->robots); $I->assertTrue(is_object($result[0]->robotsParts)); $I->assertInstanceOf(\RobotsParts::class, $result[0]->robotsParts); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->robots->id); $I->assertEquals(1, $result[0]->robotsParts->id); $I->assertEquals(1, $result[1]->robots->id); $I->assertEquals(2, $result[1]->robotsParts->id); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robots.*, Phalcon\Tests\Models\RobotsParts.* " . "FROM Phalcon\Tests\Models\Robots JOIN Phalcon\Tests\Models\RobotsParts " . "ON Phalcon\Tests\Models\Robots.id = Phalcon\Tests\Models\RobotsParts.robots_id " . "ORDER BY Phalcon\Tests\Models\Robots.id, Phalcon\Tests\Models\RobotsParts.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->robots)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->robots); $I->assertTrue(is_object($result[0]->robotsParts)); $I->assertInstanceOf("RobotsParts", $result[0]->robotsParts); $I->assertCount(3, $result); $I->assertEquals($result[0]->robots->id, 1); $I->assertEquals($result[0]->robotsParts->id, 1); $I->assertEquals($result[1]->robots->id, 1); $I->assertEquals($result[1]->robotsParts->id, 2); $result = $manager->executeQuery("SELECT r.*, p.* " . "FROM Phalcon\Tests\Models\Robots r " . "JOIN Phalcon\Tests\Models\RobotsParts p ON r.id = p.robots_id ORDER BY r.id, p.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\RobotsParts::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals($result[0]->r->id, 1); $I->assertEquals($result[0]->p->id, 1); $I->assertEquals($result[1]->r->id, 1); $I->assertEquals($result[1]->p->id, 2); $result = $manager->executeQuery("SELECT r.*, p.* " . "FROM Phalcon\Tests\Models\Some\Robots r " . "JOIN Phalcon\Tests\Models\Some\RobotsParts p ON r.id = p.robots_id " . "ORDER BY r.id, p.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Some\Robots::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\Some\RobotsParts::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->r->id); $I->assertEquals(1, $result[0]->p->id); $I->assertEquals(1, $result[1]->r->id); $I->assertEquals(2, $result[1]->p->id); $result = $manager->executeQuery("SELECT id, name FROM Phalcon\Tests\Models\Some\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT id, name FROM Phalcon\Tests\Models\Some\Robots ORDER BY name DESC LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT ALL estado FROM Phalcon\Tests\Models\Personas LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT DISTINCT estado FROM Phalcon\Tests\Models\Personas"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT count(DISTINCT estado) FROM Phalcon\Tests\Models\Personas"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT CASE 1 WHEN 1 THEN 2 END FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(2, $result[0]->{"0"}); $result = $manager->executeQuery("SELECT CASE 2 WHEN 1 THEN 2 WHEN 2 THEN 3 END FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(3, $result[0]->{"0"}); $result = $manager->executeQuery("SELECT CASE 2 WHEN 1 THEN 2 ELSE 3 END FROM Phalcon\Tests\Models\Robots"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(3, $result[0]->{"0"}); } private function testSelectRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters ORDER BY 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters ORDER BY code"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters ORDER BY Phalcon\Tests\Models\Robotters.code"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.* FROM Phalcon\Tests\Models\Robotters"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("SELECT r.* FROM Phalcon\Tests\Models\Robotters r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters AS r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("SELECT * FROM Phalcon\Tests\Models\Robotters AS r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.theName FROM Phalcon\Tests\Models\Robotters"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT LENGTH(Phalcon\Tests\Models\Robotters.theName) AS the_length " . "FROM Phalcon\Tests\Models\Robotters"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals($result[0]->the_length, 8); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters WHERE code = 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters WHERE code = ?0", array(0 => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters WHERE code = :code:", array("code" => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters WHERE code = "1""); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT r.theYear " . "FROM Phalcon\Tests\Models\Robotters r WHERE TRIM(theName) != "Robotina""); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters ORDER BY code"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(3, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters ORDER BY code LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("SELECT Phalcon\Tests\Models\Robotters.code+1 AS nextId " . "FROM Phalcon\Tests\Models\Robotters ORDER BY code DESC LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 4); $result = $manager->executeQuery("SELECT r.theName FROM Phalcon\Tests\Models\Robotters r ORDER BY r.theName DESC LIMIT 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->theName)); $I->assertEquals($result[0]->theName, "Terminator"); $result = $manager->executeQuery("SELECT r.theName le_theName " . "FROM Phalcon\Tests\Models\Robotters r ORDER BY r.theName ASC LIMIT 4"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "Astro Boy"); $result = $manager->executeQuery("SELECT r.theName le_theName " . "FROM Phalcon\Tests\Models\Robotters r ORDER BY r.theName ASC LIMIT 1,2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "Robotina"); $result = $manager->executeQuery("SELECT r.theName le_theName " . "FROM Phalcon\Tests\Models\Robotters r ORDER BY r.theName ASC LIMIT 2 OFFSET 1"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "Robotina"); $result = $manager->executeQuery("SELECT r.theType, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robotters r GROUP BY 1 ORDER BY r.theType ASC"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[1]->number, 2); $result = $manager->executeQuery("SELECT r.theType, SUM(r.theYear-1000) age " . "FROM Phalcon\Tests\Models\Robotters r GROUP BY 1 ORDER BY 2 DESC"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[0]->age, 1924); $result = $manager->executeQuery("SELECT r.theType, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robotters r GROUP BY 1 HAVING COUNT(*) = 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[0]->number, 2); $result = $manager->executeQuery("SELECT r.theType, COUNT(*) number " . "FROM Phalcon\Tests\Models\Robotters r GROUP BY 1 HAVING COUNT(*) < 2"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(1, $result); $I->assertEquals($result[0]->number, 1); $result = $manager->executeQuery("SELECT r.code, r.* FROM Phalcon\Tests\Models\Robotters r"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $result = $manager->executeQuery("SELECT r.*, p.* " . "FROM Phalcon\Tests\Models\Robotters r " . "JOIN Phalcon\Tests\Models\RobottersDeles p " . "ON r.code = p.robottersCode " . "ORDER BY r.code, p.code"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\RobottersDeles::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals($result[0]->r->code, 1); $I->assertEquals($result[0]->p->code, 1); $I->assertEquals($result[1]->r->code, 1); $I->assertEquals($result[1]->p->code, 2); $result = $manager->executeQuery("SELECT r.* " . "FROM Phalcon\Tests\Models\RobotsParts rp " . "LEFT JOIN Phalcon\Tests\Models\Robots2 r ON rp.robots_id=r.id"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertTrue(is_object($result[0])); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots2::class, $result[0]); $I->assertNotNull($result[0]->getName()); $result = $manager->executeQuery("SELECT r.* " . "FROM Phalcon\Tests\Models\Robots r " . "WHERE r.id NOT IN (SELECT p.id " . "FROM Phalcon\Tests\Models\Parts p WHERE r.id < p.id)"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $result = $manager->executeQuery("SELECT * " . "FROM Phalcon\Tests\Models\Robots r " . "JOIN Phalcon\Tests\Models\RobotsParts rp " . "WHERE rp.id IN (SELECT p.id " . "FROM Phalcon\Tests\Models\Parts p WHERE rp.parts_id = p.id)"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $result = $manager->executeQuery("SELECT * " . "FROM Phalcon\Tests\Models\Robots r " . "JOIN Phalcon\Tests\Models\RobotsParts rp " . "WHERE r.id IN (SELECT p.id " . "FROM Phalcon\Tests\Models\Parts p)"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); } private function testInsertExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $this->container->getShared("db")->delete("subscriptores"); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores " . "VALUES (NULL, "[email protected]", "2011-01-01 09:01:01", "P")"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals(null, $messages[0]->getType()); $I->assertEquals("Sorry Marina, but you are not allowed here", $messages[0]->getMessage()); $I->assertEquals(null, $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores " . "VALUES (NULL, "dtmail.com", "2011-01-01 09:01:01", "P")"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals("Email", $messages[0]->getType()); $I->assertEquals("Field email must be an email address", $messages[0]->getMessage()); $I->assertEquals("email", $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores " . "VALUES (NULL, "[email protected]", "2011-01-01 09:01:01", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores " . "VALUES (NULL, "[email protected]", "2010-01-01 13:21:00", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores (email, created_at, status) " . "VALUES ("[email protected]", "2010-01-01 13:21:00", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Subscriptores (email, created_at, status) " . "VALUES (:email:, :created_at:, :status:)", array("email" => "[email protected]", "created_at" => "2010-02-01 13:21:00", "status" => "P")); $I->assertTrue($status->success()); $I->assertGreaterThan(0, $status->getModel()->id); } private function testInsertRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $this->container->getShared("db")->delete("subscriptores"); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes " . "VALUES (NULL, "[email protected]", "2011-01-01 09:01:01", "P")"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals(null, $messages[0]->getType()); $I->assertEquals("D\303\251sol\303\xa9 Marina, mais vous n'\303\252tes pas autoris\xc3\xa9 ici", $messages[0]->getMessage()); $I->assertEquals(null, $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes " . "VALUES (NULL, "dtmail.com", "2011-01-01 09:01:01", "P")"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals("Email", $messages[0]->getType()); $I->assertEquals("Le courrier \303\xa9lectronique est invalide", $messages[0]->getMessage()); $I->assertEquals("courrierElectronique", $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes " . "VALUES (NULL, "[email protected]", "2011-01-01 09:01:01", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes " . "VALUES (NULL, "[email protected]", "2010-01-01 13:21:00", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes (courrierElectronique, creeA, statut) " . "VALUES ("[email protected]", "2010-01-01 13:21:00", "P")"); $I->assertTrue($status->success()); $status = $manager->executeQuery("INSERT INTO Phalcon\Tests\Models\Abonnes (courrierElectronique, creeA, statut) " . "VALUES (:courrierElectronique:, :creeA:, :statut:)", array("courrierElectronique" => "[email protected]", "creeA" => "2010-02-01 13:21:00", "statut" => "P")); $I->assertTrue($status->success()); $I->assertGreaterThan(0, $status->getModel()->code); } private function testUpdateExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $this->container->getShared("db")->execute("UPDATE personas SET ciudad_id = NULL WHERE direccion = 'COL'"); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\People SET direccion = 'COL' ' .
            'WHERE ciudad_id IS NULL LIMIT 25"); $I->assertTrue($status->success()); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\People SET direccion = :direccion: " . "WHERE ciudad_id IS NULL LIMIT 25", array("direccion" => "MXN")); $I->assertTrue($status->success()); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\Subscriptores SET status = :status: WHERE email = :email:", array("status" => "I", "email" => "[email protected]")); $I->assertTrue($status->success()); } private function testUpdateRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $this->container->getShared("db")->execute("UPDATE personas SET ciudad_id = NULL WHERE direccion = 'COL'"); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\Personers SET adresse = 'COL' ' .\xa            'WHERE fodebyId IS NULL LIMIT 25"); $I->assertTrue($status->success()); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\Personers SET adresse = :adresse: " . "WHERE fodebyId IS NULL LIMIT 25", array("adresse" => "MXN")); $I->assertTrue($status->success()); $status = $manager->executeQuery("UPDATE Phalcon\Tests\Models\Abonnes SET statut = :statut: " . "WHERE courrierElectronique = :courrierElectronique:", array("statut" => "I", "courrierElectronique" => "[email protected]")); $I->assertTrue($status->success()); } private function testDeleteExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $status = $manager->executeQuery("DELETE FROM Phalcon\Tests\Models\Subscriptores " . "WHERE email = "[email protected]""); $I->assertTrue($status->success()); $status = $manager->executeQuery("DELETE FROM Phalcon\Tests\Models\Subscriptores " . "WHERE status = :status: AND email <> :email:", array("status" => "P", "email" => "[email protected]")); $I->assertTrue($status->success()); } private function testDeleteRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("modelsManager"); $status = $manager->executeQuery("DELETE FROM Phalcon\Tests\Models\Abonnes " . "WHERE courrierElectronique = "[email protected]""); $I->assertTrue($status->success()); $status = $manager->executeQuery("DELETE FROM Phalcon\Tests\Models\Abonnes " . "WHERE statut = :statut: AND courrierElectronique <> :courrierElectronique:", array("statut" => "P", "courrierElectronique" => "[email protected]")); $I->assertTrue($status->success()); } } ?>

Did this file decode correctly?

Original Code

<?php
 namespace Phalcon\Tests\Integration\Mvc\Model; use IntegrationTester; use Phalcon\Tests\Fixtures\Traits\DiTrait; class ModelsQueryExecuteCest { use DiTrait; public function _before(IntegrationTester $I) { $this->setNewFactoryDefault(); } public function _after(IntegrationTester $I) { $this->container["\x64\142"]->close(); } public function testExecuteMysql(IntegrationTester $I) { $this->setDiMysql(); $this->testSelectExecute($I); $this->testSelectRenamedExecute($I); $this->testInsertExecute($I); $this->testInsertRenamedExecute($I); $this->testUpdateExecute($I); $this->testUpdateRenamedExecute($I); $this->testDeleteExecute($I); $this->testDeleteRenamedExecute($I); } public function testExecutePostgresql(IntegrationTester $I) { $this->setDiPostgresql(); $this->testSelectExecute($I); $this->testSelectRenamedExecute($I); $this->testInsertExecute($I); $this->testInsertRenamedExecute($I); $this->testUpdateExecute($I); $this->testUpdateRenamedExecute($I); $this->testDeleteExecute($I); $this->testDeleteRenamedExecute($I); } public function testExecuteSqlite(IntegrationTester $I) { $this->setDiSqlite(); } private function testSelectExecute(IntegrationTester $I) { $I->skipTest("\x54\x4f\x44\117\x20\55\x20\x43\150\x65\143\153\x20\x74\150\145\x20\156\165\155\x62\x65\162\x73\x20\157\x6e\40\164\150\151\163\40\164\x65\x73\164"); $manager = $this->container->getShared("\155\157\x64\x65\154\163\115\x61\x6e\x61\147\x65\162"); $robots = $manager->executeQuery("\123\x45\114\x45\103\124\40\x2a\40\106\x52\x4f\x4d\40\120\x68\141\x6c\x63\157\x6e\x5c\124\145\x73\164\x73\134\x4d\157\144\x65\154\163\x5c\x52\x6f\142\157\164\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $robots = $manager->executeQuery("\x53\x45\114\x45\x43\x54\40\x2a\40\x46\122\117\x4d\x20\x50\x68\x61\x6c\x63\x6f\x6e\134\x54\145\163\x74\163\134\x4d\157\144\145\154\163\x5c\122\x6f\142\x6f\x74\x73\x20\x4f\x52\x44\105\122\x20\102\131\x20\61"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("\x53\x45\114\x45\x43\124\x20\x2a\x20\x46\x52\117\115\40\x50\150\x61\x6c\143\x6f\x6e\x5c\x54\145\x73\x74\x73\x5c\x4d\157\144\x65\x6c\x73\x5c\x52\157\142\157\164\163\40\117\122\x44\105\122\x20\102\x59\40\x69\144"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("\x53\105\114\105\103\124\x20\52\x20\x46\x52\117\115\x20\120\x68\141\x6c\143\157\156\134\x54\145\163\x74\163\134\115\157\144\x65\154\x73\x5c\x52\157\142\x6f\x74\x73\x20\x4f\122\x44\x45\x52\40\102\131\40\x50\150\x61\154\x63\x6f\156\134\124\x65\x73\x74\x73\134\x4d\x6f\x64\x65\x6c\x73\x5c\x52\157\142\157\164\x73\x2e\x69\144"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertCount(3, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertEquals(1, $robots[0]->id); $robots = $manager->executeQuery("\x53\x45\114\x45\103\124\40\120\150\x61\x6c\143\x6f\x6e\x5c\x54\x65\x73\164\163\x5c\x4d\x6f\144\145\x6c\163\134\122\x6f\x62\x6f\164\x73\x2e\x2a\x20\x46\122\117\x4d\x20\120\x68\141\x6c\x63\157\156\x5c\x54\145\x73\164\163\134\115\x6f\x64\x65\154\163\134\122\x6f\x62\x6f\164\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("\x53\x45\x4c\105\x43\x54\x20\x72\x2e\52\40\106\122\117\115\x20\120\150\x61\154\143\157\156\x5c\x54\145\163\x74\x73\x5c\115\x6f\x64\145\x6c\x73\134\122\x6f\x62\157\x74\x73\40\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("\x53\105\x4c\105\x43\x54\x20\52\40\106\x52\x4f\115\40\120\150\141\154\x63\157\x6e\134\124\x65\x73\164\x73\x5c\x4d\x6f\x64\145\154\163\134\122\x6f\142\157\x74\x73\40\x72"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("\123\105\x4c\x45\103\124\x20\52\x20\x46\x52\117\x4d\x20\120\150\141\154\x63\157\x6e\x5c\124\x65\163\x74\x73\134\x4d\157\144\x65\154\x73\x5c\x52\157\142\x6f\x74\163\40\101\123\40\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $robots = $manager->executeQuery("\123\x45\x4c\x45\x43\x54\x20\52\40\x46\122\117\115\x20\120\150\x61\154\143\157\x6e\134\124\x65\163\x74\x73\134\x4d\x6f\144\145\154\x73\134\x52\x6f\142\x6f\x74\x73\x20\101\123\40\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robots); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $robots[0]); $I->assertCount(3, $robots); $result = $manager->executeQuery("\123\x45\x4c\105\x43\124\40\151\x64\54\x20\x6e\x61\x6d\x65\40\106\x52\117\115\x20\120\x68\x61\154\143\157\x6e\x5c\x54\145\163\x74\x73\x5c\x4d\x6f\x64\x65\154\x73\x5c\x52\x6f\142\157\164\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\x53\x45\x4c\105\103\124\40\120\x68\141\154\143\x6f\x6e\x5c\124\x65\x73\164\163\x5c\115\157\144\x65\x6c\x73\x5c\x52\157\142\x6f\x74\163\x2e\x6e\x61\155\145\40\106\122\x4f\115\x20\x50\x68\x61\154\143\157\x6e\x5c\x54\x65\163\164\x73\134\x4d\x6f\x64\x65\x6c\163\x5c\122\157\x62\157\x74\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\x45\x4c\105\103\x54\x20\x4c\105\x4e\107\x54\x48\x28\156\141\x6d\145\51\40\101\x53\x20\x74\150\145\x5f\154\145\x6e\x67\x74\x68\x20\106\x52\x4f\x4d\x20\x50\150\141\x6c\x63\x6f\x6e\x5c\x54\145\163\164\x73\x5c\115\x6f\x64\x65\x6c\x73\x5c\122\x6f\142\157\164\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals(8, $result[0]->the_length); $result = $manager->executeQuery("\123\x45\114\105\x43\124\x20\x4c\x45\x4e\107\124\110\50\x50\x68\x61\x6c\x63\x6f\x6e\x5c\x54\x65\x73\164\163\134\x4d\157\x64\x65\x6c\163\134\122\x6f\x62\x6f\164\x73\x2e\x6e\x61\x6d\145\x29\x20\101\x53\40\x74\x68\145\x5f\154\x65\156\x67\x74\150\x20" . "\x46\x52\117\x4d\40\120\150\x61\154\143\x6f\x6e\x5c\x54\x65\163\x74\163\x5c\115\x6f\144\x65\154\x73\134\x52\x6f\142\157\x74\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals(8, $result[0]->the_length); $result = $manager->executeQuery("\123\x45\x4c\105\x43\x54\x20\x50\150\x61\x6c\x63\157\x6e\134\124\145\163\164\x73\134\x4d\x6f\x64\x65\154\163\x5c\x52\157\x62\157\164\x73\56\x69\144\x2b\x31\40\x41\x53\x20\x6e\145\170\164\111\x64\40" . "\106\x52\x4f\x4d\40\x50\150\141\x6c\143\x6f\x6e\x5c\124\145\x73\164\163\x5c\x4d\x6f\x64\x65\154\x73\x5c\122\157\142\157\164\x73\40\x57\x48\105\122\x45\40\x69\144\x20\x3d\x20\x31"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\123\105\114\x45\103\124\40\120\x68\x61\154\143\157\x6e\x5c\124\145\163\164\163\x5c\x4d\x6f\144\x65\154\x73\x5c\x52\157\x62\157\x74\163\56\151\144\53\x31\x20\101\x53\40\156\145\x78\x74\111\x64\40" . "\x46\x52\117\x4d\40\120\150\x61\154\143\x6f\156\x5c\x54\145\x73\x74\163\x5c\x4d\x6f\144\145\x6c\163\x5c\122\157\x62\x6f\x74\x73\x20\127\x48\x45\x52\x45\x20\151\x64\40\75\40\77\x30", array(0 => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\x53\105\x4c\x45\103\x54\40\120\150\x61\154\143\157\x6e\134\124\x65\163\164\x73\134\x4d\x6f\144\x65\154\163\134\x52\157\142\157\164\163\x2e\151\x64\53\61\40\101\123\x20\156\145\x78\164\111\x64\x20" . "\106\x52\x4f\x4d\40\x50\x68\141\154\143\157\156\134\124\145\163\164\x73\x5c\x4d\x6f\x64\x65\154\163\x5c\122\157\142\x6f\x74\x73\x20\x57\110\x45\122\105\40\151\x64\x20\75\40\x3a\x69\144\72", array("\x69\144" => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\123\x45\114\105\103\124\x20\x50\x68\141\x6c\x63\157\x6e\x5c\x54\145\163\164\x73\x5c\x4d\x6f\144\145\154\x73\134\122\157\142\157\164\x73\56\151\x64\53\61\x20\101\x53\x20\156\145\x78\x74\x49\144\x20" . "\x46\x52\x4f\115\x20\120\150\x61\x6c\143\x6f\x6e\134\x54\x65\163\x74\163\x5c\x4d\157\x64\145\154\163\x5c\x52\157\142\157\x74\x73\40\127\x48\105\x52\105\40\x69\x64\40\x3d\x20\42\x31\x22"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\x53\105\x4c\x45\x43\124\x20\162\56\x79\145\141\x72\x20\106\122\x4f\115\x20\120\x68\141\x6c\143\x6f\156\134\x54\145\163\x74\x73\134\x4d\x6f\144\145\x6c\163\134\x52\x6f\x62\x6f\164\163\x20\x72\x20\127\x48\x45\x52\x45\x20\124\x52\x49\x4d\50\x6e\141\155\145\51\40\41\75\40\x22\122\x6f\142\157\x74\151\156\141\42"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\105\114\x45\103\124\x20\120\x68\141\154\x63\x6f\x6e\x5c\x54\x65\x73\164\163\x5c\115\157\144\145\x6c\x73\134\x52\157\142\x6f\x74\163\x2e\x69\x64\x2b\x31\40\x41\x53\40\156\x65\170\164\111\144\x20" . "\106\x52\x4f\x4d\40\x50\150\141\x6c\143\x6f\x6e\134\124\x65\x73\x74\163\x5c\x4d\x6f\x64\x65\154\163\x5c\x52\157\142\x6f\164\x73\40\x4f\x52\x44\105\122\x20\x42\x59\40\x69\x64"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(3, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\x53\105\x4c\x45\x43\x54\40\120\x68\x61\154\x63\x6f\156\x5c\124\145\163\x74\163\x5c\x4d\157\144\145\x6c\163\x5c\122\157\142\x6f\164\x73\x2e\x69\144\x2b\x31\x20\x41\x53\40\x6e\145\x78\164\111\144\40" . "\x46\122\x4f\115\x20\x50\150\x61\x6c\143\x6f\156\134\124\145\x73\x74\163\x5c\115\157\x64\145\154\x73\134\x52\157\142\157\x74\x73\40\x4f\x52\104\x45\x52\40\x42\x59\x20\151\x64\40\x4c\x49\x4d\111\x54\x20\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(2, $result[0]->nextId); $result = $manager->executeQuery("\123\105\x4c\x45\103\x54\40\120\150\x61\x6c\143\x6f\156\x5c\124\x65\x73\164\163\134\115\157\x64\145\154\x73\x5c\122\x6f\x62\157\x74\x73\x2e\151\144\x2b\x31\x20\101\x53\40\156\x65\170\x74\111\144\x20" . "\x46\x52\x4f\x4d\40\x50\x68\141\154\143\x6f\x6e\x5c\x54\145\163\x74\x73\x5c\115\157\x64\145\x6c\x73\134\x52\157\142\x6f\x74\x73\40\117\122\x44\x45\122\40\102\131\x20\x69\x64\40\104\105\x53\x43\40\114\111\x4d\x49\x54\40\62"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals(4, $result[0]->nextId); $result = $manager->executeQuery("\123\x45\114\105\x43\x54\x20\162\x2e\x6e\x61\155\x65\x20\106\122\117\115\x20\120\x68\141\x6c\143\x6f\x6e\x5c\124\145\163\164\x73\x5c\115\157\x64\x65\154\x73\x5c\122\x6f\x62\x6f\164\163\40\162\40\x4f\x52\104\x45\x52\40\x42\x59\x20\x72\x2e\x6e\141\155\x65\40\104\x45\123\103\x20\114\x49\x4d\111\x54\x20\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->name)); $I->assertEquals($result[0]->name, "\124\145\162\155\151\x6e\141\x74\157\x72"); $result = $manager->executeQuery("\123\105\114\105\103\124\40\x6e\x61\x6d\145\x20\x6c\145\x5f\156\x61\155\x65\x20\x46\x52\117\x4d\x20\120\x68\141\154\143\x6f\x6e\134\x54\145\x73\x74\163\x5c\115\x6f\x64\x65\154\163\x5c\122\157\142\157\164\x73\40\x4f\122\104\x45\122\x20\x42\131\40\x6e\141\x6d\x65\40\x41\x53\x43\x20\114\x49\115\x49\124\x20\x34"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("\101\163\164\x72\157\40\x42\x6f\x79", $result[0]->le_name); $result = $manager->executeQuery("\123\x45\114\105\103\x54\x20\x72\x2e\156\141\x6d\145\40\x6c\x65\x5f\x6e\141\x6d\x65\x20\106\x52\x4f\115\40\120\x68\141\x6c\143\x6f\x6e\x5c\x54\145\x73\x74\x73\x5c\115\x6f\x64\145\154\163\x5c\122\157\x62\157\164\x73\40\162\40\117\x52\104\x45\x52\40\x42\131\40\162\x2e\156\141\x6d\145\40\101\x53\103\x20\114\x49\115\x49\124\40\64"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("\101\x73\x74\x72\x6f\40\102\157\x79", $result[0]->le_name); $result = $manager->executeQuery("\123\105\114\105\103\124\40\x72\x2e\x6e\141\x6d\x65\40\x6c\145\137\x6e\x61\x6d\145\40\106\122\x4f\x4d\40\x50\150\x61\x6c\x63\x6f\x6e\134\x54\145\163\164\x73\x5c\x4d\x6f\144\145\x6c\163\134\x52\157\142\157\164\163\40\162\x20\x4f\x52\x44\x45\122\x20\x42\x59\40\x72\x2e\x6e\141\155\x65\x20\x41\x53\103\40\x4c\x49\115\x49\124\x20\x31\x2c\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("\122\x6f\142\x6f\x74\151\x6e\x61", $result[0]->le_name); $result = $manager->executeQuery("\x53\x45\x4c\105\103\124\x20\162\x2e\156\x61\155\x65\x20\x6c\x65\137\156\141\x6d\x65\x20" . "\106\x52\x4f\x4d\40\120\x68\141\x6c\x63\x6f\156\x5c\x54\x65\x73\164\x73\x5c\115\157\144\145\x6c\163\x5c\x52\157\x62\157\x74\x73\40\162\40\117\x52\x44\x45\x52\40\x42\131\40\162\x2e\156\141\155\x65\40\x41\123\103\40\x4c\111\x4d\111\x54\40\62\x20\x4f\106\x46\x53\x45\x54\x20\61"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_name)); $I->assertEquals("\x52\157\x62\x6f\164\151\156\141", $result[0]->le_name); $result = $manager->executeQuery("\123\x45\x4c\x45\x43\124\40\162\x2e\164\x79\x70\x65\x2c\40\x43\117\125\116\124\50\52\51\40\156\x75\x6d\142\x65\162\40" . "\106\122\x4f\x4d\x20\x50\x68\x61\154\143\157\156\x5c\x54\x65\x73\x74\x73\134\x4d\x6f\x64\145\154\163\134\122\x6f\x62\x6f\x74\163\x20\x72\40\107\122\x4f\x55\120\40\102\131\40\61\40\117\122\x44\105\122\40\x42\x59\x20\x72\56\x74\171\x70\x65\40\x41\x53\103"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(2, $result[1]->number); $result = $manager->executeQuery("\x53\x45\x4c\105\x43\x54\40\x72\56\164\171\x70\x65\54\x20\123\125\x4d\x28\162\56\x79\145\x61\x72\x2d\61\x30\60\60\51\x20\x61\x67\145\x20" . "\106\122\x4f\115\40\x50\x68\x61\x6c\143\x6f\x6e\x5c\124\x65\163\164\x73\x5c\115\x6f\144\x65\x6c\163\x5c\x52\157\142\157\164\x73\40\162\x20\107\x52\x4f\125\120\x20\x42\x59\x20\61\40\117\x52\104\105\122\40\102\x59\x20\62\40\x44\x45\123\103"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(1924, $result[0]->age); $result = $manager->executeQuery("\123\x45\114\105\103\x54\40\162\56\164\x79\x70\145\x2c\x20\103\x4f\x55\116\124\x28\52\x29\40\156\x75\155\142\145\x72\40" . "\106\122\x4f\115\x20\x50\x68\x61\x6c\x63\157\156\x5c\x54\145\x73\x74\x73\134\x4d\x6f\x64\x65\x6c\x73\x5c\x52\x6f\x62\157\164\163\40\162\x20\x47\122\117\125\120\40\x42\131\40\61\x20\110\101\126\x49\116\107\40\x43\x4f\x55\x4e\x54\50\x2a\x29\x20\x3d\x20\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals(2, $result[0]->number); $result = $manager->executeQuery("\x53\x45\114\105\103\x54\x20\x72\x2e\x74\171\x70\145\x2c\40\x43\x4f\x55\x4e\x54\50\52\x29\40\156\x75\x6d\142\x65\162\40" . "\106\122\x4f\115\40\120\150\x61\x6c\143\157\x6e\134\124\x65\x73\164\x73\x5c\x4d\x6f\x64\x65\154\163\134\122\157\x62\x6f\164\x73\40\x72\40\x47\x52\x4f\x55\x50\x20\102\131\40\61\x20\x48\x41\126\111\116\107\40\103\x4f\x55\x4e\x54\x28\x2a\x29\x20\74\40\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(1, $result); $I->assertEquals(1, $result[0]->number); $result = $manager->executeQuery("\123\x45\114\x45\103\124\40\162\x2e\x69\x64\54\40\162\x2e\x2a\40\x46\x52\117\x4d\x20\x50\150\141\x6c\x63\x6f\x6e\134\124\145\163\x74\163\x5c\x4d\x6f\144\145\154\163\134\x52\x6f\142\157\x74\x73\40\x72"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->id); $result = $manager->executeQuery("\x53\x45\x4c\105\103\x54\x20\120\150\141\x6c\x63\x6f\156\134\124\145\163\x74\163\134\115\x6f\144\145\x6c\163\134\x52\x6f\x62\x6f\x74\163\56\x2a\54\40\x50\150\141\154\x63\x6f\156\134\x54\x65\163\x74\163\134\x4d\157\x64\x65\x6c\x73\x5c\x52\x6f\142\x6f\164\163\120\x61\x72\x74\x73\x2e\x2a\40" . "\106\x52\x4f\x4d\40\120\x68\x61\154\143\x6f\156\x5c\x54\x65\163\164\163\134\115\x6f\x64\x65\154\x73\x5c\x52\x6f\x62\x6f\164\x73\x20\x4a\117\x49\116\40\120\150\141\x6c\143\x6f\x6e\134\x54\x65\x73\x74\x73\x5c\115\157\144\145\x6c\163\134\x52\157\x62\157\164\x73\x50\x61\x72\164\163\40" . "\x4f\x52\x44\105\x52\x20\x42\x59\40\120\150\141\x6c\143\x6f\x6e\134\x54\145\x73\x74\163\x5c\115\x6f\144\x65\x6c\163\x5c\122\157\142\x6f\164\x73\56\x69\144\x2c\x20\x50\150\141\154\143\157\156\x5c\x54\145\163\164\x73\134\115\157\x64\x65\154\x73\134\x52\x6f\142\157\164\x73\120\141\162\x74\163\x2e\x69\144"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->robots)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->robots); $I->assertTrue(is_object($result[0]->robotsParts)); $I->assertInstanceOf(\RobotsParts::class, $result[0]->robotsParts); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->robots->id); $I->assertEquals(1, $result[0]->robotsParts->id); $I->assertEquals(1, $result[1]->robots->id); $I->assertEquals(2, $result[1]->robotsParts->id); $result = $manager->executeQuery("\x53\x45\114\x45\x43\124\40\120\150\141\x6c\143\x6f\x6e\x5c\124\145\x73\164\x73\x5c\x4d\157\x64\145\154\163\134\x52\157\x62\x6f\164\x73\56\x2a\x2c\x20\120\150\x61\x6c\x63\157\x6e\x5c\x54\145\163\x74\163\134\x4d\157\144\x65\154\x73\x5c\x52\x6f\x62\157\x74\x73\x50\x61\x72\164\163\x2e\52\x20" . "\106\122\117\115\x20\x50\150\x61\154\x63\157\x6e\x5c\124\145\x73\164\163\x5c\115\x6f\x64\x65\154\163\134\x52\157\x62\x6f\164\163\40\x4a\x4f\111\x4e\40\x50\x68\141\154\143\157\x6e\134\x54\x65\x73\x74\x73\x5c\115\x6f\144\145\x6c\x73\134\122\x6f\142\x6f\164\x73\x50\x61\162\x74\x73\x20" . "\117\x4e\40\120\150\141\154\x63\x6f\x6e\134\x54\x65\163\x74\x73\x5c\x4d\x6f\x64\145\154\x73\134\x52\157\142\157\x74\163\x2e\x69\x64\40\75\40\120\x68\141\154\143\157\x6e\134\x54\x65\163\x74\x73\134\115\157\x64\x65\154\163\x5c\x52\x6f\142\157\x74\x73\x50\x61\x72\164\x73\x2e\162\157\142\x6f\x74\x73\x5f\x69\x64\x20" . "\117\122\x44\x45\122\x20\102\x59\40\120\150\x61\x6c\143\157\x6e\x5c\x54\x65\163\x74\x73\x5c\115\x6f\144\x65\154\163\134\x52\157\x62\157\164\x73\x2e\x69\x64\x2c\x20\x50\150\141\x6c\143\157\x6e\x5c\124\x65\163\164\x73\134\115\157\x64\x65\x6c\x73\x5c\122\157\142\157\x74\163\x50\141\x72\164\163\56\151\x64"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->robots)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->robots); $I->assertTrue(is_object($result[0]->robotsParts)); $I->assertInstanceOf("\x52\x6f\x62\157\164\163\120\x61\162\x74\x73", $result[0]->robotsParts); $I->assertCount(3, $result); $I->assertEquals($result[0]->robots->id, 1); $I->assertEquals($result[0]->robotsParts->id, 1); $I->assertEquals($result[1]->robots->id, 1); $I->assertEquals($result[1]->robotsParts->id, 2); $result = $manager->executeQuery("\123\105\x4c\x45\x43\124\x20\162\56\52\54\x20\x70\x2e\52\x20" . "\x46\122\x4f\x4d\x20\120\150\x61\x6c\x63\157\x6e\134\124\145\163\164\163\134\115\x6f\x64\145\154\x73\134\122\157\142\x6f\164\163\40\x72\x20" . "\112\x4f\111\x4e\40\120\150\x61\x6c\x63\157\156\134\124\145\x73\x74\163\x5c\x4d\x6f\144\145\154\163\x5c\122\157\x62\157\164\163\x50\x61\162\164\x73\40\x70\x20\117\x4e\x20\162\x2e\151\x64\40\75\40\x70\56\162\x6f\x62\x6f\164\x73\x5f\x69\144\x20\117\x52\104\x45\122\x20\102\x59\x20\162\x2e\x69\x64\x2c\40\160\56\151\x64"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\RobotsParts::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals($result[0]->r->id, 1); $I->assertEquals($result[0]->p->id, 1); $I->assertEquals($result[1]->r->id, 1); $I->assertEquals($result[1]->p->id, 2); $result = $manager->executeQuery("\x53\105\114\105\103\124\40\162\56\52\54\x20\160\x2e\52\x20" . "\106\122\x4f\115\x20\120\150\141\x6c\143\x6f\x6e\x5c\x54\x65\x73\x74\x73\x5c\115\x6f\144\x65\x6c\x73\134\x53\x6f\155\x65\x5c\x52\x6f\142\157\164\163\40\x72\x20" . "\x4a\x4f\x49\116\40\x50\x68\141\x6c\143\x6f\156\134\x54\x65\x73\x74\163\x5c\x4d\x6f\144\x65\x6c\x73\134\123\x6f\155\145\134\x52\x6f\142\x6f\164\163\x50\141\162\164\x73\40\160\40\x4f\x4e\40\162\x2e\151\144\x20\75\x20\160\56\x72\157\142\x6f\164\x73\137\x69\144\x20" . "\117\122\x44\105\x52\40\102\x59\40\162\x2e\151\144\x2c\x20\x70\x2e\151\144"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Some\Robots::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\Some\RobotsParts::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals(1, $result[0]->r->id); $I->assertEquals(1, $result[0]->p->id); $I->assertEquals(1, $result[1]->r->id); $I->assertEquals(2, $result[1]->p->id); $result = $manager->executeQuery("\123\x45\114\x45\x43\124\40\151\144\54\40\x6e\141\155\x65\40\x46\122\117\x4d\x20\120\150\x61\154\143\x6f\x6e\x5c\124\x65\163\164\x73\x5c\x4d\157\144\145\x6c\163\134\123\x6f\155\x65\x5c\x52\x6f\142\157\164\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\105\x4c\x45\x43\124\40\x69\x64\54\x20\156\141\x6d\x65\40\106\122\x4f\x4d\x20\x50\150\x61\x6c\x63\157\x6e\134\x54\145\x73\x74\x73\x5c\115\x6f\144\x65\x6c\x73\134\x53\157\x6d\145\134\122\x6f\142\x6f\164\x73\40\117\122\x44\105\x52\40\x42\x59\x20\156\x61\x6d\x65\x20\x44\105\x53\103\x20\x4c\111\x4d\111\x54\x20\62"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\x53\105\x4c\105\103\124\40\x41\x4c\114\x20\x65\163\x74\x61\x64\157\40\x46\x52\117\x4d\40\120\150\141\x6c\143\157\x6e\134\124\145\x73\x74\163\x5c\115\157\x64\x65\154\163\x5c\x50\x65\x72\x73\157\156\x61\x73\x20\114\x49\115\111\x54\40\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\x53\x45\x4c\105\103\124\40\x44\x49\123\x54\x49\x4e\103\x54\40\x65\163\x74\x61\x64\157\x20\106\x52\117\115\40\x50\150\x61\154\x63\x6f\156\134\124\145\163\164\163\x5c\x4d\x6f\144\145\x6c\163\x5c\x50\x65\x72\163\157\x6e\141\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\x45\114\x45\x43\124\40\143\157\165\156\164\50\104\x49\123\124\x49\x4e\103\124\40\145\x73\164\141\x64\x6f\51\40\x46\x52\117\x4d\40\120\x68\141\x6c\143\x6f\x6e\x5c\124\145\163\164\163\134\115\157\144\145\x6c\163\134\120\145\x72\163\x6f\x6e\141\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\105\114\x45\x43\124\x20\x43\x41\123\x45\40\61\x20\127\x48\x45\x4e\40\61\40\x54\110\x45\x4e\40\x32\40\x45\116\104\x20\106\x52\x4f\x4d\x20\120\x68\141\154\x63\157\156\134\124\145\163\x74\x73\x5c\x4d\x6f\x64\x65\x6c\x73\x5c\x52\x6f\142\x6f\164\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(2, $result[0]->{"\60"}); $result = $manager->executeQuery("\x53\105\x4c\105\103\124\40\x43\x41\123\105\x20\62\40\x57\110\x45\116\x20\x31\x20\124\110\x45\x4e\40\62\40\127\110\x45\116\40\62\x20\124\x48\105\116\40\63\x20\105\116\x44\x20\x46\x52\x4f\x4d\40\x50\x68\141\x6c\143\x6f\x6e\x5c\x54\x65\x73\164\x73\x5c\115\157\144\145\x6c\x73\134\122\x6f\x62\157\164\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(3, $result[0]->{"\x30"}); $result = $manager->executeQuery("\123\x45\x4c\x45\x43\124\40\x43\101\x53\105\40\x32\40\127\x48\105\x4e\x20\x31\x20\x54\x48\x45\x4e\x20\x32\x20\105\114\123\105\x20\x33\x20\x45\116\x44\x20\x46\x52\x4f\115\x20\x50\150\x61\x6c\x63\x6f\156\134\x54\x65\x73\164\x73\x5c\x4d\157\144\145\154\x73\x5c\122\x6f\142\x6f\164\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertEquals(3, $result[0]->{"\x30"}); } private function testSelectRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("\155\x6f\144\145\154\x73\115\141\156\141\x67\x65\162"); $robotters = $manager->executeQuery("\x53\x45\x4c\105\x43\124\x20\x2a\x20\x46\122\x4f\115\40\120\x68\x61\x6c\143\157\x6e\134\124\145\x73\x74\x73\134\x4d\x6f\144\145\x6c\x73\x5c\x52\157\x62\157\164\164\145\x72\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $robotters = $manager->executeQuery("\x53\x45\114\x45\x43\x54\40\52\x20\106\x52\x4f\x4d\40\x50\150\x61\154\143\157\156\x5c\124\145\163\x74\x73\134\115\x6f\x64\x65\x6c\163\134\122\157\142\157\164\x74\x65\162\x73\40\x4f\122\104\105\x52\x20\x42\x59\x20\61"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("\x53\x45\114\105\103\x54\x20\52\40\106\122\117\x4d\x20\x50\x68\141\154\x63\157\156\134\124\145\x73\x74\163\134\115\157\144\145\x6c\163\x5c\x52\157\142\x6f\x74\x74\145\x72\163\x20\x4f\x52\x44\105\x52\x20\102\x59\40\143\157\x64\x65"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("\123\105\114\x45\x43\124\x20\x2a\40\x46\x52\117\x4d\40\120\x68\x61\x6c\x63\x6f\156\x5c\124\x65\x73\164\163\x5c\x4d\x6f\144\x65\x6c\x73\134\x52\157\142\x6f\164\164\145\162\163\40\117\122\104\x45\122\x20\102\131\x20\x50\150\141\x6c\x63\x6f\x6e\134\x54\x65\163\x74\163\134\115\x6f\x64\145\154\163\x5c\122\x6f\142\157\x74\x74\145\x72\163\x2e\143\x6f\144\145"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertCount(3, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertEquals($robotters[0]->code, 1); $robotters = $manager->executeQuery("\x53\x45\x4c\105\103\x54\40\120\150\141\x6c\143\157\x6e\x5c\124\x65\163\164\163\134\x4d\x6f\x64\x65\x6c\x73\134\122\157\x62\x6f\x74\x74\145\162\163\56\52\40\x46\x52\117\x4d\x20\120\x68\x61\154\143\x6f\x6e\134\x54\x65\x73\x74\163\x5c\x4d\x6f\144\x65\x6c\163\x5c\x52\157\142\x6f\164\x74\145\162\x73"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("\123\105\114\105\x43\124\40\x72\56\52\x20\x46\122\117\x4d\40\120\150\141\154\x63\157\156\134\124\x65\163\x74\x73\134\x4d\x6f\x64\145\x6c\x73\134\x52\157\142\x6f\164\x74\145\162\x73\x20\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("\123\105\114\x45\103\x54\x20\52\40\x46\x52\x4f\x4d\x20\120\150\141\154\143\x6f\156\134\124\145\x73\164\163\134\x4d\x6f\x64\x65\x6c\163\x5c\x52\157\142\157\164\164\145\x72\x73\x20\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("\123\x45\114\x45\x43\124\x20\x2a\x20\106\x52\x4f\x4d\x20\120\x68\x61\154\143\x6f\x6e\134\x54\x65\163\x74\x73\134\115\x6f\x64\145\154\163\x5c\x52\157\142\x6f\x74\164\145\x72\163\40\x41\123\40\x72"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $robotters = $manager->executeQuery("\123\x45\x4c\x45\103\124\x20\52\40\106\122\117\x4d\x20\x50\x68\141\x6c\x63\x6f\x6e\134\124\145\163\x74\163\x5c\115\157\x64\x65\154\x73\134\122\x6f\x62\x6f\164\x74\145\162\163\x20\x41\x53\x20\x72"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $robotters); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $robotters[0]); $I->assertCount(3, $robotters); $result = $manager->executeQuery("\x53\x45\x4c\x45\x43\124\x20\120\x68\141\x6c\x63\157\156\134\124\145\x73\164\163\134\115\x6f\x64\145\154\x73\134\x52\x6f\x62\x6f\164\164\x65\162\x73\56\x74\x68\x65\116\x61\x6d\145\x20\106\122\117\115\x20\x50\x68\x61\x6c\143\x6f\x6e\x5c\x54\x65\x73\x74\163\x5c\115\157\x64\145\154\163\x5c\122\x6f\x62\x6f\164\164\145\162\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\x45\114\105\103\x54\x20\x4c\x45\116\107\124\110\x28\x50\150\x61\x6c\143\157\x6e\x5c\x54\145\163\164\163\x5c\115\157\x64\x65\x6c\163\134\x52\x6f\x62\x6f\x74\x74\x65\x72\163\56\164\150\145\x4e\141\155\x65\51\40\101\x53\x20\x74\150\145\x5f\x6c\x65\x6e\x67\164\150\x20" . "\106\122\x4f\115\40\x50\x68\141\154\x63\157\x6e\x5c\x54\x65\163\x74\x73\x5c\115\x6f\x64\145\x6c\x73\x5c\122\157\142\157\164\x74\145\x72\163"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->the_length)); $I->assertEquals($result[0]->the_length, 8); $result = $manager->executeQuery("\123\105\114\x45\x43\124\40\x50\150\141\x6c\143\x6f\x6e\134\124\145\x73\x74\163\x5c\115\x6f\144\145\154\x73\x5c\x52\x6f\142\x6f\164\x74\x65\162\x73\x2e\x63\157\x64\145\53\x31\40\101\x53\40\156\145\170\x74\111\x64\x20" . "\106\x52\x4f\x4d\x20\x50\x68\x61\154\x63\157\x6e\x5c\124\145\x73\164\x73\x5c\115\157\x64\x65\x6c\163\x5c\x52\157\x62\x6f\164\x74\x65\162\x73\x20\127\x48\105\122\x45\x20\x63\157\x64\145\40\x3d\40\x31"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\123\105\x4c\105\103\124\40\120\150\x61\154\143\x6f\156\134\124\x65\x73\x74\163\x5c\x4d\157\x64\145\x6c\x73\134\122\x6f\142\x6f\x74\164\145\x72\x73\x2e\x63\x6f\144\145\x2b\61\x20\101\123\x20\156\x65\x78\164\111\144\x20" . "\x46\122\117\115\40\x50\150\141\154\x63\x6f\x6e\134\124\145\x73\164\x73\134\115\157\x64\x65\x6c\x73\134\122\x6f\142\157\164\x74\145\x72\163\x20\127\110\105\x52\x45\40\x63\x6f\x64\x65\40\x3d\40\x3f\x30", array(0 => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\123\105\114\105\103\x54\x20\120\150\141\154\x63\x6f\x6e\134\124\145\163\x74\163\x5c\x4d\x6f\144\x65\154\163\134\122\x6f\142\157\164\164\x65\162\x73\x2e\143\157\144\x65\53\x31\40\x41\123\40\x6e\x65\170\164\111\x64\40" . "\106\122\x4f\115\x20\120\x68\141\x6c\x63\157\156\x5c\124\145\x73\x74\x73\134\115\157\x64\145\x6c\x73\x5c\x52\x6f\x62\x6f\164\164\x65\162\163\x20\127\110\105\x52\105\40\x63\x6f\x64\145\x20\x3d\40\x3a\x63\157\144\x65\x3a", array("\x63\x6f\144\x65" => 1)); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\x53\x45\114\x45\103\124\40\120\x68\141\154\x63\x6f\x6e\134\124\145\163\164\x73\134\x4d\157\144\145\154\x73\x5c\122\157\x62\x6f\164\x74\145\162\x73\56\x63\x6f\x64\145\53\x31\40\101\x53\40\156\145\170\x74\111\144\40" . "\106\x52\117\x4d\40\x50\150\x61\x6c\x63\x6f\156\x5c\124\x65\x73\164\x73\x5c\115\x6f\144\145\x6c\x73\134\x52\157\x62\x6f\x74\164\x65\x72\163\x20\x57\110\105\122\x45\40\143\157\144\x65\x20\x3d\40\x22\61\x22"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\x53\x45\114\x45\x43\124\x20\162\x2e\164\x68\145\131\x65\141\162\40" . "\x46\122\x4f\115\40\120\x68\141\x6c\143\x6f\156\134\124\145\x73\164\163\x5c\115\157\144\145\x6c\163\134\x52\157\x62\x6f\164\164\145\162\x73\40\x72\40\x57\x48\105\x52\x45\40\124\122\x49\115\x28\164\150\x65\x4e\x61\x6d\x65\51\x20\41\75\40\42\x52\157\142\x6f\164\x69\156\141\x22"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $result = $manager->executeQuery("\123\105\x4c\105\x43\x54\x20\x50\150\141\154\x63\x6f\x6e\134\124\145\x73\x74\163\134\x4d\157\144\145\x6c\163\x5c\122\157\142\x6f\x74\164\145\162\163\x2e\143\157\144\x65\x2b\61\x20\x41\123\40\x6e\145\170\x74\111\144\x20" . "\106\x52\117\115\40\120\150\141\x6c\x63\x6f\156\134\x54\145\163\164\x73\134\x4d\x6f\144\145\154\x73\x5c\122\157\142\157\164\164\145\x72\x73\x20\117\x52\104\x45\x52\40\102\131\x20\143\x6f\144\x65"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(3, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\x53\x45\x4c\105\103\124\40\x50\x68\141\154\x63\x6f\156\x5c\124\145\x73\x74\x73\x5c\x4d\157\144\145\154\163\x5c\122\157\142\157\x74\164\145\x72\163\x2e\x63\x6f\144\x65\x2b\61\40\101\x53\40\x6e\x65\x78\x74\111\144\40" . "\106\122\x4f\115\x20\120\x68\x61\154\x63\x6f\x6e\x5c\x54\x65\x73\164\163\x5c\115\157\x64\145\x6c\163\134\x52\x6f\142\157\x74\164\x65\162\163\40\x4f\122\x44\x45\x52\x20\x42\x59\40\x63\x6f\144\145\x20\x4c\x49\x4d\111\124\40\62"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 2); $result = $manager->executeQuery("\x53\105\114\105\x43\124\40\120\x68\141\154\x63\157\x6e\134\124\145\163\164\x73\x5c\x4d\x6f\x64\x65\154\163\134\122\x6f\x62\x6f\164\x74\145\162\x73\56\x63\x6f\x64\x65\53\61\x20\101\x53\40\156\x65\170\164\x49\144\40" . "\106\122\117\115\x20\x50\150\x61\x6c\x63\157\x6e\134\x54\145\x73\164\163\134\x4d\157\x64\x65\154\163\x5c\x52\x6f\142\157\x74\164\145\x72\163\x20\x4f\122\x44\105\x52\x20\102\x59\x20\143\157\144\x65\x20\x44\105\x53\x43\x20\114\x49\115\x49\124\40\62"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(2, $result); $I->assertTrue(isset($result[0]->nextId)); $I->assertEquals($result[0]->nextId, 4); $result = $manager->executeQuery("\x53\x45\x4c\105\103\x54\40\162\x2e\x74\150\x65\116\141\155\x65\40\x46\122\117\115\40\120\150\141\154\x63\157\156\x5c\x54\145\x73\164\163\134\x4d\x6f\144\145\x6c\163\x5c\122\x6f\x62\x6f\x74\x74\x65\x72\163\40\x72\x20\117\122\104\x45\122\40\x42\131\40\x72\x2e\164\x68\x65\x4e\x61\x6d\145\x20\104\x45\x53\103\x20\114\111\115\x49\x54\x20\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->theName)); $I->assertEquals($result[0]->theName, "\x54\x65\162\155\151\156\141\164\x6f\x72"); $result = $manager->executeQuery("\x53\105\x4c\x45\x43\124\40\162\56\164\150\145\116\x61\155\x65\x20\x6c\x65\x5f\x74\150\x65\x4e\x61\x6d\145\40" . "\x46\122\x4f\x4d\40\120\150\141\x6c\143\x6f\x6e\134\x54\145\x73\164\163\x5c\115\157\x64\145\x6c\163\x5c\x52\x6f\142\x6f\164\164\145\162\163\40\162\40\x4f\122\x44\x45\122\40\x42\131\x20\x72\x2e\x74\x68\145\116\141\155\x65\40\101\x53\103\x20\114\x49\115\111\x54\40\x34"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(3, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "\x41\x73\x74\162\157\x20\x42\157\171"); $result = $manager->executeQuery("\123\105\x4c\x45\x43\124\40\x72\x2e\164\x68\145\x4e\x61\x6d\145\40\x6c\145\x5f\x74\x68\x65\116\x61\x6d\x65\40" . "\106\122\117\115\40\120\x68\141\154\x63\157\x6e\134\124\x65\x73\x74\x73\134\x4d\157\x64\x65\154\x73\x5c\x52\157\x62\x6f\164\164\145\x72\163\x20\x72\40\x4f\x52\x44\105\122\40\x42\x59\40\x72\x2e\164\150\x65\116\141\x6d\145\40\101\123\103\40\114\x49\x4d\111\124\40\x31\54\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "\x52\x6f\x62\157\164\151\x6e\x61"); $result = $manager->executeQuery("\123\105\114\105\x43\x54\40\x72\x2e\164\150\x65\116\x61\x6d\x65\x20\154\x65\137\164\x68\x65\116\141\155\145\x20" . "\x46\x52\x4f\x4d\40\x50\150\x61\x6c\143\157\x6e\134\124\x65\x73\164\163\134\115\x6f\x64\145\x6c\x73\134\122\157\x62\x6f\x74\x74\145\162\x73\x20\x72\40\x4f\x52\104\x45\x52\x20\x42\131\x20\x72\x2e\164\x68\145\x4e\x61\x6d\x65\40\101\123\x43\40\x4c\x49\115\x49\x54\40\62\40\x4f\106\x46\x53\x45\x54\40\61"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertTrue(isset($result[0]->le_theName)); $I->assertEquals($result[0]->le_theName, "\x52\157\x62\x6f\164\x69\156\141"); $result = $manager->executeQuery("\x53\x45\x4c\105\103\124\x20\162\56\164\x68\145\x54\x79\x70\x65\x2c\x20\103\x4f\x55\116\x54\50\52\51\40\x6e\x75\155\x62\145\x72\40" . "\x46\122\x4f\115\x20\x50\150\141\x6c\x63\157\x6e\x5c\124\x65\x73\x74\x73\x5c\115\x6f\144\x65\154\163\x5c\x52\157\x62\157\x74\x74\x65\x72\x73\x20\x72\40\x47\122\117\125\x50\x20\102\131\x20\61\x20\x4f\122\x44\105\x52\40\102\131\40\x72\56\164\150\145\x54\171\160\145\40\x41\123\103"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[1]->number, 2); $result = $manager->executeQuery("\123\105\x4c\x45\103\x54\x20\162\x2e\x74\x68\x65\124\x79\160\145\x2c\40\x53\125\x4d\50\x72\56\164\x68\x65\x59\145\141\162\55\61\60\x30\60\51\x20\141\x67\145\40" . "\x46\x52\117\x4d\x20\x50\x68\141\154\x63\157\156\x5c\124\x65\163\x74\x73\134\x4d\x6f\144\145\154\163\x5c\x52\157\x62\157\164\164\x65\162\163\40\x72\40\107\122\117\125\120\x20\x42\131\40\61\40\117\122\104\105\x52\x20\102\x59\x20\62\40\x44\105\123\x43"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(2, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[0]->age, 1924); $result = $manager->executeQuery("\123\x45\x4c\105\x43\124\40\162\x2e\x74\x68\x65\124\171\x70\x65\x2c\x20\x43\x4f\125\116\124\50\52\x29\x20\x6e\165\x6d\142\145\x72\40" . "\x46\x52\117\x4d\x20\x50\x68\141\154\x63\157\156\x5c\x54\145\x73\x74\x73\x5c\115\157\144\145\154\x73\x5c\x52\157\x62\157\164\x74\145\162\163\x20\x72\40\107\122\x4f\x55\x50\x20\x42\x59\40\x31\40\110\x41\126\x49\116\x47\40\x43\x4f\x55\116\124\50\x2a\51\40\75\40\x32"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertCount(1, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertEquals($result[0]->number, 2); $result = $manager->executeQuery("\x53\105\x4c\105\103\x54\40\162\56\164\150\x65\124\171\160\145\54\40\103\x4f\125\x4e\124\x28\52\51\x20\156\x75\155\x62\145\162\x20" . "\106\122\117\x4d\x20\120\150\141\x6c\x63\157\156\x5c\124\x65\163\x74\x73\134\115\157\x64\145\154\x73\x5c\x52\157\x62\x6f\x74\x74\145\x72\163\x20\162\x20\x47\122\117\125\120\40\x42\131\40\x31\x20\x48\x41\126\x49\x4e\x47\x20\103\117\x55\x4e\124\x28\x2a\x29\40\74\x20\62"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertInstanceOf(\Phalcon\Mvc\Model\Row::class, $result[0]); $I->assertCount(1, $result); $I->assertEquals($result[0]->number, 1); $result = $manager->executeQuery("\123\105\114\x45\x43\124\x20\162\x2e\143\157\144\145\x2c\40\x72\56\x2a\40\x46\122\117\x4d\40\x50\x68\141\x6c\143\157\156\134\124\145\x73\164\x73\134\x4d\x6f\144\145\x6c\163\x5c\122\157\142\x6f\x74\164\145\162\163\x20\162"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $result = $manager->executeQuery("\123\105\x4c\105\x43\x54\40\x72\x2e\x2a\x2c\x20\160\x2e\52\40" . "\106\x52\117\115\x20\x50\150\x61\x6c\143\157\x6e\x5c\124\145\x73\164\x73\x5c\115\157\x64\145\154\163\x5c\122\157\142\157\164\164\x65\162\163\x20\162\x20" . "\x4a\117\x49\x4e\40\120\150\141\154\x63\157\x6e\x5c\x54\x65\x73\x74\163\x5c\115\157\x64\x65\154\x73\134\x52\157\142\157\x74\164\x65\x72\163\104\145\154\x65\163\x20\160\x20" . "\117\116\40\x72\x2e\143\x6f\x64\145\40\75\40\x70\56\162\157\142\x6f\x74\164\x65\162\x73\x43\x6f\x64\x65\x20" . "\x4f\x52\104\x45\x52\x20\102\131\x20\x72\x2e\x63\157\144\145\54\x20\160\56\143\x6f\144\x65"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $I->assertTrue(is_object($result[0]->r)); $I->assertInstanceOf(\Phalcon\Tests\Models\Robotters::class, $result[0]->r); $I->assertTrue(is_object($result[0]->p)); $I->assertInstanceOf(\Phalcon\Tests\Models\RobottersDeles::class, $result[0]->p); $I->assertCount(3, $result); $I->assertEquals($result[0]->r->code, 1); $I->assertEquals($result[0]->p->code, 1); $I->assertEquals($result[1]->r->code, 1); $I->assertEquals($result[1]->p->code, 2); $result = $manager->executeQuery("\x53\x45\114\105\103\124\40\162\56\x2a\40" . "\106\122\x4f\115\40\120\150\141\x6c\x63\x6f\156\134\124\145\x73\x74\x73\x5c\115\157\144\145\x6c\x73\134\x52\x6f\x62\x6f\x74\x73\120\x61\162\164\163\x20\x72\160\x20" . "\114\105\106\124\40\x4a\x4f\x49\116\x20\x50\150\141\x6c\x63\x6f\156\134\124\145\163\164\x73\x5c\115\157\144\x65\154\x73\x5c\x52\x6f\x62\x6f\x74\163\62\x20\162\40\117\x4e\x20\x72\x70\x2e\x72\x6f\142\x6f\x74\163\x5f\151\144\75\162\56\151\144"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $I->assertTrue(is_object($result[0])); $I->assertInstanceOf(\Phalcon\Tests\Models\Robots2::class, $result[0]); $I->assertNotNull($result[0]->getName()); $result = $manager->executeQuery("\123\x45\114\x45\103\x54\40\x72\x2e\x2a\x20" . "\106\x52\x4f\115\40\120\x68\141\154\x63\x6f\156\134\x54\x65\163\164\x73\134\x4d\157\144\x65\154\163\134\122\157\142\157\164\163\40\x72\x20" . "\x57\110\105\x52\x45\40\162\56\x69\144\40\x4e\x4f\x54\x20\x49\x4e\x20\x28\123\x45\x4c\105\103\x54\x20\x70\56\x69\144\40" . "\x46\x52\x4f\115\x20\x50\x68\x61\x6c\x63\157\x6e\x5c\124\x65\x73\x74\x73\134\115\157\144\145\x6c\163\134\x50\141\162\164\163\x20\x70\40\127\110\x45\x52\x45\40\x72\56\x69\x64\40\x3c\40\x70\56\x69\144\x29"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Simple::class, $result); $result = $manager->executeQuery("\123\x45\114\x45\103\124\x20\x2a\40" . "\106\x52\117\115\40\x50\150\x61\154\x63\157\x6e\x5c\x54\145\x73\164\x73\x5c\x4d\157\144\x65\154\163\x5c\122\x6f\142\157\164\x73\40\x72\x20" . "\x4a\117\x49\x4e\x20\x50\x68\141\x6c\x63\157\x6e\134\x54\145\x73\164\x73\134\115\x6f\144\x65\x6c\x73\134\122\157\142\157\x74\x73\120\141\162\x74\163\x20\162\160\40" . "\x57\x48\105\x52\x45\40\x72\x70\x2e\151\x64\x20\111\x4e\40\x28\123\x45\114\x45\103\x54\x20\x70\x2e\x69\144\x20" . "\106\x52\117\115\40\120\x68\141\154\x63\x6f\x6e\x5c\x54\145\x73\x74\163\x5c\115\157\144\145\x6c\x73\134\x50\x61\x72\164\163\x20\160\x20\127\x48\x45\122\105\x20\162\x70\x2e\x70\x61\162\164\163\x5f\151\144\x20\x3d\x20\160\x2e\x69\144\x29"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); $result = $manager->executeQuery("\x53\x45\114\x45\103\x54\x20\x2a\x20" . "\106\x52\117\x4d\40\120\150\x61\154\143\157\156\x5c\x54\145\163\x74\163\x5c\x4d\157\x64\x65\x6c\x73\x5c\122\157\x62\157\164\163\40\x72\x20" . "\x4a\117\x49\116\x20\x50\150\141\154\143\157\156\134\x54\145\163\164\163\x5c\x4d\157\144\145\x6c\163\134\122\157\x62\x6f\164\163\120\x61\162\x74\163\x20\162\x70\40" . "\x57\x48\105\x52\105\40\162\56\151\x64\40\111\116\40\x28\x53\105\114\x45\103\x54\x20\x70\x2e\151\x64\40" . "\106\122\x4f\115\40\120\x68\x61\x6c\143\157\x6e\x5c\x54\145\x73\x74\163\134\115\157\144\145\x6c\163\134\120\141\162\x74\x73\x20\x70\51"); $I->assertInstanceOf(\Phalcon\Mvc\Model\Resultset\Complex::class, $result); } private function testInsertExecute(IntegrationTester $I) { $manager = $this->container->getShared("\155\x6f\144\x65\x6c\163\x4d\141\156\x61\x67\145\x72"); $this->container->getShared("\144\x62")->delete("\x73\165\x62\163\143\162\x69\x70\x74\x6f\162\145\163"); $status = $manager->executeQuery("\111\116\x53\105\x52\124\x20\111\116\x54\x4f\40\120\150\141\x6c\x63\x6f\x6e\x5c\124\x65\163\164\163\134\x4d\x6f\x64\145\154\163\134\123\165\x62\x73\x63\x72\x69\160\164\x6f\162\145\163\x20" . "\x56\x41\x4c\x55\105\123\40\50\x4e\x55\114\x4c\54\x20\x22\x6d\x61\162\x69\156\141\100\150\x6f\x74\155\141\x69\154\56\143\157\155\x22\x2c\x20\x22\62\60\61\x31\x2d\x30\61\x2d\x30\61\x20\x30\71\x3a\60\x31\x3a\x30\61\42\x2c\x20\42\120\42\x29"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals(null, $messages[0]->getType()); $I->assertEquals("\123\157\x72\x72\x79\40\115\141\x72\151\156\141\54\x20\x62\x75\164\x20\x79\157\x75\40\141\x72\x65\40\x6e\157\x74\x20\x61\x6c\154\157\167\x65\144\x20\150\145\162\x65", $messages[0]->getMessage()); $I->assertEquals(null, $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("\x49\116\x53\x45\x52\x54\x20\x49\x4e\124\x4f\40\120\150\141\x6c\143\x6f\x6e\x5c\124\145\x73\164\163\x5c\x4d\157\x64\x65\154\163\134\123\165\142\163\x63\x72\x69\x70\x74\157\x72\x65\163\x20" . "\x56\101\x4c\x55\x45\x53\40\50\x4e\125\x4c\x4c\54\40\42\x64\x74\x6d\x61\151\x6c\56\143\157\155\42\x2c\40\42\62\x30\x31\x31\55\x30\61\55\x30\x31\40\60\x39\72\x30\x31\72\x30\61\42\x2c\40\x22\120\x22\51"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals("\105\155\141\151\154", $messages[0]->getType()); $I->assertEquals("\106\151\x65\x6c\144\40\x65\155\141\x69\154\40\x6d\x75\x73\x74\x20\142\x65\40\x61\x6e\x20\145\x6d\x61\x69\x6c\40\141\144\144\x72\145\163\x73", $messages[0]->getMessage()); $I->assertEquals("\145\155\x61\x69\154", $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("\x49\x4e\x53\105\x52\x54\x20\x49\x4e\x54\117\40\x50\150\141\x6c\x63\x6f\x6e\134\124\145\x73\x74\163\134\x4d\157\x64\145\x6c\x73\134\123\165\142\163\x63\162\x69\x70\164\157\x72\145\163\x20" . "\x56\101\x4c\x55\x45\123\x20\x28\x4e\x55\x4c\114\54\x20\42\154\145\x2d\155\x61\x72\151\156\141\x40\150\157\x74\155\141\151\154\x2e\143\157\155\x22\54\x20\x22\62\x30\x31\61\55\60\x31\55\x30\61\40\60\x39\x3a\x30\61\x3a\60\x31\42\54\x20\42\x50\42\x29"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x49\x4e\x53\x45\122\124\40\111\116\124\x4f\40\x50\150\x61\x6c\143\157\156\134\124\x65\x73\164\163\x5c\115\x6f\x64\145\x6c\x73\x5c\x53\x75\142\x73\x63\x72\x69\x70\164\157\x72\x65\163\x20" . "\126\x41\114\125\x45\123\x20\x28\x4e\x55\114\114\54\40\x22\x73\x6f\x6e\156\171\100\150\x6f\x74\155\141\x69\154\x2e\143\157\x6d\42\54\40\x22\62\60\x31\60\55\x30\61\x2d\x30\x31\x20\61\63\72\62\61\x3a\60\60\x22\x2c\40\x22\x50\42\x29"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\111\x4e\x53\x45\x52\x54\x20\x49\116\x54\117\x20\x50\x68\x61\x6c\143\157\x6e\x5c\124\145\163\164\x73\134\115\x6f\x64\145\x6c\x73\134\123\x75\142\163\143\x72\x69\x70\x74\x6f\162\x65\x73\40\x28\145\x6d\x61\x69\154\54\40\143\162\x65\141\164\x65\144\x5f\141\164\54\40\163\164\x61\164\165\163\51\40" . "\x56\101\x4c\125\105\x53\x20\x28\x22\x68\151\x64\145\141\167\x61\x79\100\x68\x6f\x74\x6d\x61\151\154\56\x63\x6f\155\42\x2c\40\x22\x32\60\x31\60\55\60\x31\55\60\61\40\61\x33\x3a\x32\61\x3a\x30\x30\x22\54\40\x22\120\x22\51"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x49\x4e\123\x45\122\x54\x20\111\x4e\124\x4f\40\120\x68\141\x6c\143\157\x6e\x5c\124\x65\x73\x74\163\x5c\115\x6f\144\145\x6c\163\134\123\165\142\x73\x63\162\x69\160\164\157\x72\x65\163\40\50\x65\155\141\x69\154\54\x20\143\162\x65\x61\x74\x65\x64\137\141\x74\x2c\x20\163\164\x61\164\165\163\51\40" . "\126\101\114\x55\105\123\x20\x28\x3a\x65\x6d\141\x69\x6c\x3a\54\x20\x3a\x63\x72\145\141\164\x65\144\x5f\x61\x74\x3a\x2c\40\72\163\x74\141\x74\x75\x73\x3a\x29", array("\145\155\x61\x69\x6c" => "\171\145\141\x68\171\145\141\150\x40\150\x6f\x74\155\x61\x69\x6c\56\x63\x6f\x6d", "\x63\x72\x65\141\164\x65\144\137\141\164" => "\x32\x30\x31\x30\55\x30\62\x2d\60\61\40\x31\63\x3a\62\x31\72\60\x30", "\163\164\141\x74\165\163" => "\x50")); $I->assertTrue($status->success()); $I->assertGreaterThan(0, $status->getModel()->id); } private function testInsertRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("\x6d\157\144\145\x6c\x73\x4d\141\156\141\x67\x65\x72"); $this->container->getShared("\144\142")->delete("\x73\165\142\x73\143\x72\151\x70\164\x6f\x72\145\163"); $status = $manager->executeQuery("\x49\116\x53\x45\122\124\40\111\116\x54\117\40\x50\150\141\154\143\157\x6e\134\x54\145\x73\164\x73\134\x4d\x6f\144\x65\x6c\x73\134\101\x62\157\x6e\x6e\x65\163\x20" . "\126\x41\x4c\125\105\x53\x20\x28\116\x55\x4c\114\x2c\x20\x22\x6d\x61\x72\x69\156\x61\x40\150\x6f\x74\x6d\141\151\154\56\x63\157\155\x22\x2c\x20\42\62\x30\61\61\55\x30\x31\x2d\x30\61\x20\60\x39\x3a\60\61\x3a\60\x31\42\54\x20\x22\x50\x22\x29"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals(null, $messages[0]->getType()); $I->assertEquals("\x44\303\251\x73\x6f\x6c\303\xa9\x20\115\141\162\x69\x6e\x61\x2c\40\155\141\x69\x73\x20\x76\157\x75\x73\40\156\47\303\252\x74\x65\163\40\x70\141\163\x20\x61\x75\164\157\162\x69\163\xc3\xa9\40\151\x63\151", $messages[0]->getMessage()); $I->assertEquals(null, $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("\111\x4e\x53\x45\122\x54\x20\111\116\124\117\x20\120\x68\x61\154\143\x6f\x6e\134\124\x65\163\x74\163\x5c\x4d\157\144\145\x6c\x73\134\x41\142\x6f\156\x6e\145\163\x20" . "\x56\x41\114\x55\105\123\40\x28\x4e\125\x4c\114\54\40\x22\144\x74\x6d\141\x69\x6c\56\x63\x6f\155\42\54\x20\42\62\x30\x31\x31\55\60\61\x2d\60\x31\x20\60\x39\72\60\61\x3a\x30\61\42\54\40\x22\x50\x22\x29"); $I->assertFalse($status->success()); $messages = $status->getMessages(); $I->assertEquals("\105\155\141\151\154", $messages[0]->getType()); $I->assertEquals("\114\145\x20\143\x6f\x75\x72\162\151\145\x72\x20\303\xa9\x6c\145\x63\x74\x72\157\x6e\151\x71\165\x65\40\x65\x73\x74\40\x69\x6e\166\x61\x6c\151\x64\x65", $messages[0]->getMessage()); $I->assertEquals("\143\x6f\165\x72\162\x69\145\162\x45\154\x65\x63\x74\x72\157\x6e\151\161\x75\x65", $messages[0]->getField()); $I->assertEquals(0, $messages[0]->getCode()); $I->assertEquals(array(), $messages[0]->getMetaData()); $status = $manager->executeQuery("\x49\x4e\x53\x45\x52\124\x20\x49\116\x54\x4f\40\120\x68\141\x6c\143\x6f\156\134\x54\x65\x73\x74\163\x5c\115\157\144\x65\154\x73\134\x41\142\x6f\x6e\156\x65\x73\x20" . "\x56\101\x4c\x55\x45\x53\40\50\116\125\x4c\114\54\40\42\154\x65\x2d\x6d\x61\162\151\156\141\100\x68\x6f\164\155\141\151\x6c\x2e\143\157\x6d\x22\x2c\x20\42\x32\60\61\x31\55\60\x31\x2d\60\61\40\x30\x39\x3a\x30\x31\x3a\x30\x31\x22\x2c\x20\42\120\42\x29"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x49\116\x53\105\122\x54\x20\111\116\124\x4f\x20\120\x68\x61\x6c\143\x6f\x6e\134\x54\x65\x73\164\x73\134\x4d\x6f\x64\x65\154\x73\134\101\x62\x6f\156\x6e\x65\163\40" . "\126\101\114\x55\x45\x53\x20\x28\116\x55\114\114\54\x20\42\x73\x6f\156\156\x79\x40\150\157\164\155\x61\151\154\x2e\143\157\x6d\42\x2c\40\x22\x32\60\61\x30\55\x30\x31\55\60\x31\x20\x31\x33\72\x32\61\x3a\60\60\x22\x2c\x20\42\120\42\51"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x49\x4e\x53\x45\122\x54\x20\111\116\124\x4f\x20\120\x68\x61\x6c\143\x6f\x6e\x5c\124\x65\163\x74\163\134\x4d\157\144\145\x6c\163\134\101\142\157\156\x6e\145\x73\40\x28\x63\x6f\x75\162\162\x69\145\162\x45\154\145\x63\x74\162\x6f\x6e\x69\161\x75\x65\x2c\x20\x63\x72\145\x65\x41\54\x20\x73\164\x61\164\x75\x74\x29\x20" . "\x56\x41\x4c\x55\x45\123\x20\x28\x22\x68\x69\x64\145\141\x77\x61\x79\x40\150\x6f\x74\155\x61\x69\154\x2e\143\157\x6d\x22\54\40\x22\62\60\x31\60\55\x30\x31\x2d\60\61\x20\61\x33\x3a\62\61\72\60\x30\42\54\x20\x22\x50\42\x29"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\111\x4e\123\x45\x52\124\40\x49\116\x54\117\x20\120\x68\141\x6c\x63\157\x6e\134\124\145\x73\164\x73\134\115\157\144\145\154\163\134\x41\142\157\x6e\x6e\x65\x73\40\50\143\157\x75\162\162\x69\x65\162\x45\154\x65\143\x74\162\157\156\x69\x71\165\145\x2c\40\143\x72\145\x65\101\54\x20\163\x74\x61\x74\165\x74\51\x20" . "\126\x41\x4c\125\x45\x53\40\x28\x3a\x63\157\165\162\162\151\x65\x72\105\154\145\x63\164\162\x6f\x6e\x69\x71\165\x65\72\x2c\x20\x3a\x63\x72\x65\x65\101\72\x2c\x20\72\x73\164\x61\x74\165\x74\x3a\x29", array("\143\157\x75\x72\x72\151\x65\162\105\154\145\x63\164\162\x6f\x6e\151\161\165\145" => "\171\x65\x61\x68\171\145\141\150\100\x68\157\x74\155\141\151\x6c\56\143\157\x6d", "\143\x72\145\x65\101" => "\x32\60\61\x30\55\60\x32\x2d\x30\61\x20\x31\x33\x3a\62\x31\x3a\60\60", "\163\164\141\164\x75\164" => "\120")); $I->assertTrue($status->success()); $I->assertGreaterThan(0, $status->getModel()->code); } private function testUpdateExecute(IntegrationTester $I) { $manager = $this->container->getShared("\x6d\157\x64\145\154\163\x4d\141\156\x61\x67\145\x72"); $this->container->getShared("\x64\x62")->execute("\x55\120\x44\x41\124\105\x20\x70\145\x72\x73\157\156\141\x73\x20\123\x45\124\x20\143\x69\165\x64\141\144\137\x69\x64\x20\75\x20\116\125\x4c\x4c\40\127\x48\x45\x52\x45\40\144\151\162\x65\143\x63\151\x6f\156\x20\75\x20\47\x43\x4f\114\47"); $status = $manager->executeQuery("\125\120\x44\x41\124\x45\x20\x50\150\141\x6c\x63\x6f\x6e\x5c\124\x65\x73\164\x73\134\115\157\144\145\154\x73\134\120\x65\x6f\x70\x6c\145\40\123\x45\x54\x20\x64\151\162\x65\x63\143\x69\157\156\40\75\x20\x27\x43\x4f\x4c\x27\40\x27\40\56\12\40\x20\x20\40\40\x20\x20\x20\40\40\x20\40\47\127\110\105\x52\x45\40\143\x69\x75\144\x61\144\137\x69\x64\x20\x49\x53\40\x4e\x55\x4c\114\x20\x4c\x49\115\x49\x54\x20\62\x35"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\125\120\104\101\124\x45\40\120\x68\x61\x6c\143\157\156\134\124\145\x73\x74\163\x5c\x4d\x6f\144\x65\154\163\134\x50\145\157\x70\154\x65\x20\123\105\x54\x20\144\x69\162\145\143\143\x69\157\x6e\40\75\x20\x3a\144\151\x72\x65\x63\143\x69\157\156\72\x20" . "\127\110\x45\x52\105\40\x63\x69\x75\x64\141\144\x5f\x69\144\x20\111\x53\40\116\x55\x4c\x4c\40\114\x49\115\x49\x54\x20\x32\x35", array("\x64\151\162\145\143\143\x69\157\x6e" => "\x4d\x58\x4e")); $I->assertTrue($status->success()); $status = $manager->executeQuery("\125\x50\104\x41\x54\x45\40\120\150\x61\154\143\x6f\x6e\134\124\x65\163\164\163\134\115\157\x64\145\154\163\134\x53\x75\142\163\x63\x72\x69\x70\x74\x6f\x72\x65\163\x20\x53\105\x54\x20\x73\164\141\164\x75\163\x20\75\40\72\163\164\141\164\x75\163\x3a\40\x57\x48\x45\122\105\40\145\x6d\x61\151\154\40\75\x20\x3a\x65\x6d\141\x69\154\72", array("\163\164\141\164\x75\163" => "\x49", "\145\x6d\x61\x69\x6c" => "\x6c\145\x2d\x6d\141\x72\151\x6e\141\x40\150\157\x74\x6d\x61\151\154\x2e\x63\x6f\155")); $I->assertTrue($status->success()); } private function testUpdateRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("\x6d\157\x64\145\154\x73\115\141\x6e\141\147\x65\162"); $this->container->getShared("\144\142")->execute("\125\x50\104\101\124\x45\x20\x70\145\x72\163\157\x6e\141\x73\x20\123\105\x54\40\x63\151\165\x64\x61\x64\x5f\x69\144\x20\75\40\x4e\x55\114\x4c\40\127\x48\x45\122\x45\40\144\151\x72\x65\x63\143\151\157\156\40\75\40\47\x43\117\x4c\x27"); $status = $manager->executeQuery("\125\120\x44\101\x54\105\40\120\150\x61\x6c\x63\157\156\x5c\124\145\x73\x74\163\x5c\115\157\144\x65\154\x73\x5c\120\x65\x72\163\157\x6e\145\162\163\40\x53\105\x54\40\x61\144\162\x65\x73\163\145\40\x3d\x20\47\x43\x4f\x4c\47\x20\47\x20\x2e\xa\x20\40\x20\x20\40\40\40\x20\x20\x20\40\x20\47\127\110\105\122\105\40\x66\157\144\x65\142\171\x49\144\40\111\x53\x20\116\x55\x4c\114\40\114\111\115\111\x54\x20\62\x35"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x55\x50\x44\x41\x54\x45\x20\x50\x68\141\154\x63\x6f\x6e\x5c\x54\145\163\x74\x73\134\x4d\157\x64\145\x6c\x73\134\120\x65\162\x73\157\156\x65\x72\163\x20\x53\x45\x54\40\x61\144\x72\145\163\163\145\40\75\40\x3a\x61\144\162\145\x73\x73\145\72\40" . "\x57\110\105\x52\x45\x20\x66\x6f\144\145\x62\171\111\x64\40\111\123\x20\x4e\x55\x4c\x4c\40\x4c\x49\x4d\111\124\x20\x32\x35", array("\x61\x64\x72\x65\x73\x73\x65" => "\x4d\130\x4e")); $I->assertTrue($status->success()); $status = $manager->executeQuery("\125\120\104\101\124\105\x20\120\x68\x61\x6c\143\157\156\134\124\x65\x73\164\163\134\115\x6f\144\x65\x6c\163\134\x41\x62\157\156\156\145\163\x20\123\105\x54\40\163\x74\x61\164\165\x74\40\75\40\x3a\x73\164\141\164\165\x74\72\x20" . "\x57\x48\105\x52\x45\40\x63\x6f\x75\162\x72\151\145\x72\105\154\145\143\x74\x72\x6f\156\151\x71\x75\x65\40\x3d\x20\x3a\x63\x6f\x75\x72\162\x69\x65\162\x45\x6c\x65\x63\x74\162\x6f\x6e\x69\x71\x75\x65\x3a", array("\x73\164\141\x74\x75\164" => "\x49", "\143\x6f\x75\162\162\151\x65\162\105\154\145\143\164\x72\x6f\156\x69\x71\x75\x65" => "\x6c\145\x2d\155\141\162\151\x6e\x61\x40\x68\x6f\x74\155\x61\x69\154\x2e\x63\x6f\155")); $I->assertTrue($status->success()); } private function testDeleteExecute(IntegrationTester $I) { $manager = $this->container->getShared("\155\x6f\144\x65\154\x73\115\x61\156\141\147\145\x72"); $status = $manager->executeQuery("\x44\105\x4c\105\x54\105\40\x46\122\117\115\x20\x50\150\x61\154\x63\157\156\x5c\124\145\x73\164\163\x5c\x4d\157\144\x65\154\x73\134\123\x75\x62\163\143\162\x69\x70\x74\157\162\x65\x73\40" . "\127\x48\105\x52\105\x20\145\155\x61\x69\154\x20\x3d\40\x22\155\x61\162\151\156\141\x40\x68\157\x74\155\141\151\x6c\x2e\x63\157\155\x22"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\104\105\x4c\105\x54\105\x20\106\122\117\115\x20\120\x68\141\x6c\x63\x6f\x6e\134\x54\145\x73\164\163\x5c\115\x6f\x64\145\x6c\163\134\x53\x75\x62\x73\x63\x72\151\x70\164\157\x72\145\x73\x20" . "\x57\x48\105\x52\105\40\x73\164\141\164\x75\163\40\75\40\x3a\163\x74\x61\164\165\x73\72\40\101\x4e\x44\40\x65\x6d\141\151\x6c\x20\74\x3e\x20\72\x65\155\x61\151\154\72", array("\163\x74\x61\164\x75\x73" => "\120", "\145\155\141\x69\154" => "\146\x75\145\x67\157\x40\150\x6f\x74\x6d\141\151\154\56\x63\x6f\x6d")); $I->assertTrue($status->success()); } private function testDeleteRenamedExecute(IntegrationTester $I) { $manager = $this->container->getShared("\x6d\157\144\x65\154\x73\115\x61\x6e\141\x67\145\x72"); $status = $manager->executeQuery("\x44\x45\114\x45\x54\x45\40\x46\122\117\115\40\x50\150\x61\154\143\157\156\134\x54\145\163\164\x73\x5c\115\157\144\145\x6c\x73\134\x41\142\157\156\x6e\x65\x73\40" . "\127\110\x45\x52\x45\x20\143\157\x75\162\x72\x69\145\x72\105\x6c\145\143\x74\162\x6f\x6e\x69\x71\165\145\40\75\40\x22\x6d\x61\x72\x69\156\x61\100\x68\x6f\164\x6d\141\151\154\56\143\157\x6d\x22"); $I->assertTrue($status->success()); $status = $manager->executeQuery("\x44\x45\x4c\105\x54\x45\40\x46\x52\117\115\40\x50\150\141\154\143\157\x6e\134\124\x65\x73\164\163\134\x4d\157\x64\x65\154\x73\134\101\142\x6f\156\x6e\145\x73\x20" . "\x57\x48\105\122\x45\x20\x73\164\x61\x74\x75\x74\x20\75\40\72\x73\x74\141\164\165\x74\72\40\101\116\104\40\x63\157\x75\x72\162\151\145\162\105\154\x65\143\x74\x72\x6f\156\x69\x71\165\x65\x20\74\76\40\72\143\157\165\x72\162\x69\x65\162\x45\154\145\x63\164\x72\157\x6e\x69\161\165\145\72", array("\163\x74\141\164\165\x74" => "\120", "\x63\157\165\162\162\x69\145\162\x45\x6c\145\143\164\x72\157\x6e\151\x71\165\145" => "\146\x75\145\147\157\x40\150\x6f\164\155\x61\x69\x6c\56\x63\x6f\x6d")); $I->assertTrue($status->success()); } }

Function Calls

None

Variables

None

Stats

MD5 81401f9f9a807ea53fa19732b8c51b9f
Eval Count 0
Decode Time 149 ms