public function testFetchNew() { $this->initConnection(); $bookstore = $this->dbDiffer('bookstore'); $bookstore->snapshot(); $entity = Authors::fetchNew(); $entity->set("first_name", "Kowalski"); $id = $entity->save(); $bookstore->snapshot(); $this->assertEquals($id, 4); $this->assertEquals($bookstore->numOfCreated(), 1); $this->assertEquals($bookstore->numOfChanged(), 1); }
}); }); $array = $select->fetchAll(); $array = $select->fetchOne(); $array = $select->fetchCol(); $array = $select->fetchRow(); $entity = $select->first(); $collection = $select->all(); // operations on entity $author1 = Authors::select()->equal('author_id', 1)->first(); $author1->set('first_name', 'John'); // UPDATE $author1->save(); // DELETE // $author1->delete(); $authorNew = Authors::fetchNew(); $authorNew->set('first_name', 'John'); $authorNew->set('last_name', 'Matthew'); // INSERT $authorNew->save(); // Collection $authors = Authors::select()->order('authors.author_id', 'DESC')->all(); foreach ($authors as $author) { $authorNew->set('first_name', 'John'); $authors->save(); } // or short $authors->set('first_name', 'John')->save(); // or delete all authors // $authors->delete(); // joins