gistfile1.php

$robots = $manager->executeQuery('SELECT * FROM Robots');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertEquals(count($robots), 3);
$this->assertInstanceOf('Robots', $robots[0]);

$robots = $manager->executeQuery('SELECT * FROM Robots ORDER BY 1');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertEquals(count($robots), 3);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals($robots[0]->id, 1);

$robots = $manager->executeQuery('SELECT * FROM Robots ORDER BY id');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertEquals(count($robots), 3);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals($robots[0]->id, 1);

$robots = $manager->executeQuery('SELECT * FROM Robots ORDER BY Robots.id');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertEquals(count($robots), 3);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals($robots[0]->id, 1);

$robots = $manager->executeQuery('SELECT Robots.* FROM Robots');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals(count($robots), 3);

$robots = $manager->executeQuery('SELECT r.* FROM Robots r');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals(count($robots), 3);

$robots = $manager->executeQuery('SELECT * FROM Robots r');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals(count($robots), 3);

$robots = $manager->executeQuery('SELECT * FROM Robots AS r');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals(count($robots), 3);

$robots = $manager->executeQuery('SELECT * FROM Robots AS r');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $robots);
$this->assertInstanceOf('Robots', $robots[0]);
$this->assertEquals(count($robots), 3);

$result = $manager->executeQuery('SELECT Robots.name FROM Robots');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $result);
$this->assertInstanceOf('Phalcon\Mvc\Model\Row', $result[0]);
$this->assertEquals(count($result), 3);

$result = $manager->executeQuery('SELECT CONCAT(Robots.id, Robots.name) AS new_name FROM Robots');
$this->assertInstanceOf('Phalcon\Mvc\Model\Resultset\Simple', $result);
$this->assertInstanceOf('Phalcon\Mvc\Model\Row', $result[0]);
$this->assertEquals(count($result), 3);
$this->assertTrue(isset($result[0]->new_name));
$this->assertEquals($result[0]->new_name, '1Robotina');