RedUNIT\Base\Database::testSelects PHP Метод

testSelects() публичный Метод

Test selecting.
public testSelects ( ) : void
Результат void
    public function testSelects()
    {
        $rooms = R::dispense('room', 2);
        $rooms[0]->kind = 'suite';
        $rooms[1]->kind = 'classic';
        $rooms[0]->number = 6;
        $rooms[1]->number = 7;
        R::store($rooms[0]);
        R::store($rooms[1]);
        $rooms = R::getAssoc('SELECT * FROM room WHERE id < -999');
        asrt(is_array($rooms), TRUE);
        asrt(count($rooms), 0);
        $rooms = R::getAssoc('SELECT ' . R::getWriter()->esc('number') . ', kind FROM room ORDER BY kind ASC');
        foreach ($rooms as $key => $room) {
            asrt($key === 6 || $key === 7, TRUE);
            asrt($room == 'classic' || $room == 'suite', TRUE);
        }
        $rooms = R::getDatabaseAdapter()->getAssoc('SELECT kind FROM room');
        foreach ($rooms as $key => $room) {
            asrt($room == 'classic' || $room == 'suite', TRUE);
            asrt($room, $key);
        }
        $rooms = R::getAssoc('SELECT `number`, kind FROM rooms2 ORDER BY kind ASC');
        asrt(count($rooms), 0);
        asrt(is_array($rooms), TRUE);
        // GetCell should return NULL in case of exception
        asrt(NULL, R::getCell('SELECT dream FROM fantasy'));
    }