public function testPoisonedCacheWhenSavingABook() { $b1 = BookPeer::retrieveByPK($this->books[0]->getId()); // if author is loaded then doSave will do addBook($b1) and poison the authors books cache $b1->getAuthor(); // e.g. to update viewed count etc $b1->save(); // ... later down the line fetch the author $author = AuthorPeer::retrieveByPK($this->author->getId()); $this->assertEquals(2, count($author->getBooks())); $this->assertEquals(2, $author->countBooks()); }
/** * Test deleting an object using the delete() method. */ public function testDelete() { BookstoreDataPopulator::populate(); // 1) grab an arbitrary object $book = BookPeer::doSelectOne(new Criteria()); $bookId = $book->getId(); // 2) delete it $book->delete(); // 3) make sure it can't be save()d now that it's deleted try { $book->setTitle("Will Fail"); $book->save(); $this->fail("Expect an exception to be thrown when attempting to save() a deleted object."); } catch (PropelException $e) { } // 4) make sure that it doesn't exist in db $book = BookPeer::retrieveByPK($bookId); $this->assertNull($book, "Expect NULL from retrieveByPK on deleted Book."); }
public function testCountRefFk() { $book = new Book(); $book->setTitle("Test Book"); $book->setISBN("TT-EE-SS-TT"); $num = 5; for ($i = 2; $i < $num + 2; $i++) { $r = new Review(); $r->setReviewedBy('Hans ' . $num); $dt = new DateTime("now"); $dt->modify("-" . $i . " weeks"); $r->setReviewDate($dt); $r->setRecommended($i % 2 == 0); $book->addReview($r); } $this->assertEquals($num, $book->countReviews(), "Expected countReviews to return {$num}"); $this->assertEquals($num, count($book->getReviews()), "Expected getReviews to return {$num} reviews"); $book->save(); BookPeer::clearInstancePool(); ReviewPeer::clearInstancePool(); $book = BookPeer::retrieveByPK($book->getId()); $this->assertEquals($num, $book->countReviews(), "Expected countReviews() to return {$num} (after save)"); $this->assertEquals($num, count($book->getReviews()), "Expected getReviews() to return {$num} (after save)"); // Now set different criteria and expect different results $c = new Criteria(); $c->add(ReviewPeer::RECOMMENDED, false); $this->assertEquals(floor($num / 2), $book->countReviews($c), "Expected " . floor($num / 2) . " results from countReviews(recomm=false)"); // Change Criteria, run again -- expect different. $c = new Criteria(); $c->add(ReviewPeer::RECOMMENDED, true); $this->assertEquals(ceil($num / 2), count($book->getReviews($c)), "Expected " . ceil($num / 2) . " results from getReviews(recomm=true)"); $this->assertEquals($num, $book->countReviews(), "Expected countReviews to return {$num} with new empty Criteria"); }
public function testObjectInstances() { $sample = BookPeer::doSelectOne(new Criteria()); $samplePk = $sample->getPrimaryKey(); // 1) make sure consecutive calls to retrieveByPK() return the same object. $b1 = BookPeer::retrieveByPK($samplePk); $b2 = BookPeer::retrieveByPK($samplePk); $sampleval = md5(microtime()); $this->assertTrue($b1 === $b2, "Expected object instances to match for calls with same retrieveByPK() method signature."); // 2) make sure that calls to doSelect also return references to the same objects. $allbooks = BookPeer::doSelect(new Criteria()); foreach ($allbooks as $testb) { if ($testb->getPrimaryKey() == $b1->getPrimaryKey()) { $this->assertTrue($testb === $b1, "Expected same object instance from doSelect() as from retrieveByPK()"); } } // 3) test fetching related objects $book = BookPeer::retrieveByPK($samplePk); $bookauthor = $book->getAuthor(); $author = AuthorPeer::retrieveByPK($bookauthor->getId()); $this->assertTrue($bookauthor === $author, "Expected same object instance when calling fk object accessor as retrieveByPK()"); // 4) test a doSelectJoin() $morebooks = BookPeer::doSelectJoinAuthor(new Criteria()); for ($i = 0, $j = 0; $j < count($morebooks); $i++, $j++) { $testb1 = $allbooks[$i]; $testb2 = $allbooks[$j]; $this->assertTrue($testb1 === $testb2, "Expected the same objects from consecutive doSelect() calls."); // we could probably also test this by just verifying that $book & $testb are the same if ($testb1->getPrimaryKey() === $book) { $this->assertTrue($book->getAuthor() === $testb1->getAuthor(), "Expected same author object in calls to pkey-matching books."); } } // 5) test creating a new object, saving it, and then retrieving that object (should all be same instance) $b = new BookstoreEmployee(); $b->setName("Testing"); $b->setJobTitle("Testing"); $b->save(); $empId = $b->getId(); $this->assertSame($b, BookstoreEmployeePeer::retrieveByPK($empId), "Expected newly saved object to be same instance as pooled."); }
/** * @see testDoDeleteCompositePK() */ private function createBookWithId($id) { $con = Propel::getConnection(BookPeer::DATABASE_NAME); $b = BookPeer::retrieveByPK($id); if (!$b) { $b = new Book(); $b->setTitle("Book{$id}")->setISBN("BookISBN{$id}")->save(); $b1Id = $b->getId(); $sql = "UPDATE " . BookPeer::TABLE_NAME . " SET id = ? WHERE id = ?"; $stmt = $con->prepare($sql); $stmt->bindValue(1, $id); $stmt->bindValue(2, $b1Id); $stmt->execute(); } }
public function getBook($con = null) { include_once 'lib/model/om/BaseBookPeer.php'; if ($this->aBook === null && $this->book_id !== null) { $this->aBook = BookPeer::retrieveByPK($this->book_id, $con); } return $this->aBook; }
public function getBook($con = null) { if ($this->aBook === null && $this->book_id !== null) { $this->aBook = BookPeer::retrieveByPK($this->book_id, $con); } return $this->aBook; }