public function testManyToManyRelationFetch() { $author = new Author(); $author->create(array('name' => 'Z', 'email' => 'z@z', 'identity' => 'z')); // XXX: in different database engine, it's different. // sometimes it's string, sometimes it's integer // ok( is_string( $author->getValue('id') ) ); ok(is_integer($author->get('id'))); $book = $author->books->create(array('title' => 'Book Test')); ok($book); ok($book->id, 'book is created'); $ret = $book->delete(); ok($ret->success); $ab = new \AuthorBooks\Model\AuthorBook(); $book = new \AuthorBooks\Model\Book(); // should not include this ok($book->create(array('title' => 'Book I Ex'))->success); ok($book->create(array('title' => 'Book I'))->success); ok($ab->create(array('author_id' => $author->id, 'book_id' => $book->id))->success); ok($book->create(array('title' => 'Book II'))->success); $ab->create(array('author_id' => $author->id, 'book_id' => $book->id)); ok($book->create(array('title' => 'Book III'))->success); $ab->create(array('author_id' => $author->id, 'book_id' => $book->id)); // retrieve books from relationshipt $author->flushCache(); $books = $author->books; is(3, $books->size(), 'We have 3 books'); $bookTitles = array(); foreach ($books->items() as $item) { $bookTitles[$item->title] = true; $item->delete(); } count_ok(3, array_keys($bookTitles)); ok($bookTitles['Book I']); ok($bookTitles['Book II']); ok($bookTitles['Book III']); ok(!isset($bookTitles['Book I Ex'])); $author->delete(); }