public function testSetterOneToManyReplacesOldObjectsByNewObjectsWithFkRequired()
{
// Ensure no data
BookSummaryQuery::create()->deleteAll();
BookQuery::create()->deleteAll();
$bookSummaries = new ObjectCollection();
foreach (array('foo', 'bar') as $summary) {
$s = new BookSummary();
$s->setSummary($summary);
$bookSummaries[] = $s;
}
$b = new Book();
$b->setTitle('Hello');
$b->setBookSummaries($bookSummaries);
$b->save();
$bookSummaries = $b->getBookSummaries();
$this->assertEquals('foo', $bookSummaries[0]->getSummary());
$this->assertEquals('bar', $bookSummaries[1]->getSummary());
$bookSummaries = new ObjectCollection();
foreach (array('bam', 'bom') as $summary) {
$s = new BookSummary();
$s->setSummary($summary);
$bookSummaries[] = $s;
}
$b->setBookSummaries($bookSummaries);
$b->save();
$bookSummaries = $b->getBookSummaries();
$this->assertEquals('bam', $bookSummaries[0]->getSummary());
$this->assertEquals('bom', $bookSummaries[1]->getSummary());
$this->assertEquals(1, BookQuery::create()->count());
$this->assertEquals(2, BookSummaryQuery::create()->count());
}
public function testRemoveObjectOneToManyWithFkRequired()
{
BookSummaryQuery::create()->deleteAll();
BookQuery::create()->deleteAll();
$bookSummary = new BookSummary();
$bookSummary->setSummary('summary Propel Book');
$bookSummary2 = new BookSummary();
$bookSummary2->setSummary('summary2 Propel Book');
$book = new Book();
$book->setTitle('Propel Book');
$book->setISBN('01234');
$book->addBookSummary($bookSummary);
$book->addBookSummary($bookSummary2);
$this->assertCount(2, $book->getBookSummaries());
$book->removeBookSummary($bookSummary);
$bookSummaries = $book->getBookSummaries();
$this->assertCount(1, $bookSummaries);
$this->assertEquals('summary2 Propel Book', $bookSummaries->getFirst()->getSummary());
$book->save();
$bookSummary2->save();
$this->assertEquals(1, BookQuery::create()->count(), 'One Book');
$this->assertEquals(1, BookSummaryQuery::create()->count(), 'One Summary');
$this->assertEquals(1, BookSummaryQuery::create()->filterBySummarizedBook($book)->count());
$book->addBookSummary($bookSummary);
$bookSummary->save();
$book->save();
$this->assertEquals(2, BookSummaryQuery::create()->filterBySummarizedBook($book)->count());
$book->removeBookSummary($bookSummary2);
$book->save();
$this->assertEquals(1, BookSummaryQuery::create()->filterBySummarizedBook($book)->count());
$this->assertEquals(1, BookSummaryQuery::create()->count(), 'One Book summary because FK is required so book summary is deleted when book is saved');
}
