/**
  * Test removing object when FK is part of the composite PK
  */
 public function testRemove_CompositePK()
 {
     BookReaderQuery::create()->deleteAll();
     BookQuery::create()->deleteAll();
     BookOpinionQuery::create()->deleteAll();
     $br = new BookReader();
     $br->setName("TestReader");
     $br->save();
     $b = new Book();
     $b->setTitle("TestBook");
     $b->setISBN("XX-XX-XX-XX");
     $b->save();
     $op = new BookOpinion();
     $op->setBookReader($br);
     $op->setBook($b);
     $op->setRating(10);
     $op->setRecommendToFriend(true);
     $op->save();
     $this->assertEquals(1, BookReaderQuery::create()->count(), '1 BookReader');
     $this->assertEquals(1, BookQuery::create()->count(), '1 Book');
     $this->assertEquals(1, BookOpinionQuery::create()->count(), '1 BookOpinion');
     // make sure everything is loaded correctly (and their relation too)
     $br->reload(true);
     $b->reload(true);
     $op->reload(true);
     $br->getBookOpinions();
     // load the relation
     $b->removeBookOpinion($op);
     $b->save();
     // the Book knows that there is no longer an opinion
     $this->assertEquals(0, count($b->getBookOpinions()), 'Book knows there is no opinion');
     // but not the BookReader
     $this->assertEquals(1, count($br->getBookOpinions()), 'BookReader still thinks it has 1 opinion');
     $br->reload(true);
     // with relations
     $this->assertEquals(0, count($br->getBookOpinions()), 'BookReader now knows the opinion is gone');
     $this->assertEquals(1, BookReaderQuery::create()->count(), '1 BookReader');
     $this->assertEquals(1, BookQuery::create()->count(), '1 Book');
     $this->assertEquals(0, BookOpinionQuery::create()->count(), '0 BookOpinion');
 }
Ejemplo n.º 2
0
 /**
  * Test copying when an object has composite primary key.
  * @link http://propel.phpdb.org/trac/ticket/618
  */
 public function testCopy_CompositePK()
 {
     $br = new BookReader();
     $br->setName("TestReader");
     $br->save();
     $br->copy();
     $b = new Book();
     $b->setTitle("TestBook");
     $b->setISBN("XX-XX-XX-XX");
     $b->save();
     $op = new BookOpinion();
     $op->setBookReader($br);
     $op->setBook($b);
     $op->setRating(10);
     $op->setRecommendToFriend(true);
     $op->save();
     $br2 = $br->copy(true);
     $this->assertNull($br2->getId());
     $opinions = $br2->getBookOpinions();
     $this->assertEquals(1, count($opinions), "Expected to have a related BookOpinion after copy()");
     // We DO expect the reader_id to be null
     $this->assertNull($opinions[0]->getReaderId());
     // but we DO NOT expect the book_id to be null
     $this->assertEquals($op->getBookId(), $opinions[0]->getBookId());
 }
Ejemplo n.º 3
0
 /**
  * @link       http://propel.phpdb.org/trac/ticket/519
  */
 public function testDoDeleteCompositePK()
 {
     $con = Propel::getConnection(BookPeer::DATABASE_NAME);
     ReaderFavoritePeer::doDeleteAll();
     // Create books with IDs 1 to 3
     // Create readers with IDs 1 and 2
     $this->createBookWithId(1);
     $this->createBookWithId(2);
     $this->createBookWithId(3);
     $this->createReaderWithId(1);
     $this->createReaderWithId(2);
     for ($i = 1; $i <= 3; $i++) {
         for ($j = 1; $j <= 2; $j++) {
             $bo = new BookOpinion();
             $bo->setBookId($i);
             $bo->setReaderId($j);
             $bo->save();
             $rf = new ReaderFavorite();
             $rf->setBookId($i);
             $rf->setReaderId($j);
             $rf->save();
         }
     }
     $this->assertEquals(6, ReaderFavoritePeer::doCount(new Criteria()));
     // Now delete 2 of those rows (2 is special in that it is the number of rows
     // being deleted, as well as the number of things in the primary key)
     ReaderFavoritePeer::doDelete(array(array(1, 1), array(2, 2)));
     $this->assertEquals(4, ReaderFavoritePeer::doCount(new Criteria()));
     //Note: these composite PK's are pairs of (BookId, ReaderId)
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPK(2, 1));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPK(1, 2));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPk(3, 1));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPk(3, 2));
     $this->assertNull(ReaderFavoritePeer::retrieveByPK(1, 1));
     $this->assertNull(ReaderFavoritePeer::retrieveByPK(2, 2));
     //test deletion of a single composite PK
     ReaderFavoritePeer::doDelete(array(3, 1));
     $this->assertEquals(3, ReaderFavoritePeer::doCount(new Criteria()));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPK(2, 1));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPK(1, 2));
     $this->assertNotNull(ReaderFavoritePeer::retrieveByPk(3, 2));
     $this->assertNull(ReaderFavoritePeer::retrieveByPK(1, 1));
     $this->assertNull(ReaderFavoritePeer::retrieveByPK(2, 2));
     $this->assertNull(ReaderFavoritePeer::retrieveByPk(3, 1));
     //test deleting the last three
     ReaderFavoritePeer::doDelete(array(array(2, 1), array(1, 2), array(3, 2)));
     $this->assertEquals(0, ReaderFavoritePeer::doCount(new Criteria()));
 }
 /**
  * Testing foreign keys with multiple referrer columns.
  * @link       http://propel.phpdb.org/trac/ticket/606
  */
 public function testMultiColFk()
 {
     $con = Propel::getConnection(BookPeer::DATABASE_NAME);
     ReaderFavoritePeer::doDeleteAll();
     $b1 = new Book();
     $b1->setTitle("Book1");
     $b1->setISBN("ISBN-1");
     $b1->save();
     $r1 = new BookReader();
     $r1->setName("Me");
     $r1->save();
     $bo1 = new BookOpinion();
     $bo1->setBookId($b1->getId());
     $bo1->setReaderId($r1->getId());
     $bo1->setRating(9);
     $bo1->setRecommendToFriend(true);
     $bo1->save();
     $rf1 = new ReaderFavorite();
     $rf1->setReaderId($r1->getId());
     $rf1->setBookId($b1->getId());
     $rf1->save();
     $c = new Criteria(ReaderFavoritePeer::DATABASE_NAME);
     $c->add(ReaderFavoritePeer::BOOK_ID, $b1->getId());
     $c->add(ReaderFavoritePeer::READER_ID, $r1->getId());
     $results = ReaderFavoritePeer::doSelectJoinBookOpinion($c);
     $this->assertEquals(1, count($results), "Expected 1 result");
 }
 public static function populateOpinionFavorite($con = null)
 {
     if ($con === null) {
         $con = Propel::getConnection(BookPeer::DATABASE_NAME);
     }
     $con->beginTransaction();
     $book1 = BookPeer::doSelectOne(new Criteria(), $con);
     $reader1 = new BookReader();
     $reader1->save($con);
     $bo = new BookOpinion();
     $bo->setBook($book1);
     $bo->setBookReader($reader1);
     $bo->save($con);
     $rf = new ReaderFavorite();
     $rf->setBookOpinion($bo);
     $rf->save($con);
     $con->commit();
 }