protected function emptyTables() { $res1 = AuthorPeer::doDeleteAll(); $res2 = PublisherPeer::doDeleteAll(); $res3 = AuthorPeer::doDeleteAll(); $res4 = ReviewPeer::doDeleteAll(); $res5 = MediaPeer::doDeleteAll(); $res6 = BookClubListPeer::doDeleteAll(); $res7 = BookListRelPeer::doDeleteAll(); }
public function testCommitAfterFetch() { $con = Propel::getConnection(BookPeer::DATABASE_NAME); AuthorPeer::doDeleteAll($con); $a = new Author(); $a->setFirstName('Test'); $a->setLastName('User'); $a->save($con); $con->beginTransaction(); $stmt = $con->prepare('SELECT author.FIRST_NAME, author.LAST_NAME FROM author'); $stmt->execute(); $authorArr = array(0 => 'Test', 1 => 'User'); $i = 0; $row = $stmt->fetch(PDO::FETCH_NUM); $stmt->closeCursor(); $con->commit(); $this->assertEquals($authorArr, $row, 'PDO driver supports calling $stmt->fetch before the transaction has been closed'); }
/** * @see http://www.propelorm.org/ticket/959 */ public function testFindOneWithSameRelatedObject() { BookPeer::doDeleteAll(); AuthorPeer::doDeleteAll(); $auth = new Author(); $auth->setFirstName('John'); $auth->save(); $book1 = new Book(); $book1->setTitle('Hello'); $book1->setAuthor($auth); $book1->save(); $book2 = new Book(); $book2->setTitle('World'); $book2->setAuthor($auth); $book2->save(); BookPeer::clearInstancePool(); AuthorPeer::clearInstancePool(); $c = new ModelCriteria('bookstore', 'Book'); $c->setFormatter(ModelCriteria::FORMAT_ARRAY); $c->join('Book.Author'); $c->with('Author'); $books = $c->find(); $this->assertEquals(2, count($books)); $firstBook = $books[0]; $this->assertTrue(isset($firstBook['Author'])); $secondBook = $books[1]; $this->assertTrue(isset($secondBook['Author'])); }
/** * Test the doDeleteAll() method when onDelete="SETNULL". */ public function testDoDeleteAll_SetNull() { $c = new Criteria(); $c->add(BookPeer::AUTHOR_ID, null, Criteria::NOT_EQUAL); // 1) make sure there are some books with valid authors $this->assertTrue(count(BookPeer::doSelect($c)) > 0, "Expect some book.author_id columns that are not NULL."); // 2) delete all the authors AuthorPeer::doDeleteAll(); // 3) now verify that the book.author_id columns are all nul $this->assertEquals(0, count(BookPeer::doSelect($c)), "Expect all book.author_id columns to be NULL."); }
The tests expect a model similar to this one: propel: article: id: ~ title: varchar(255) Beware that the tables for these models will be emptied by the tests, so use a test database connection. */ include dirname(__FILE__).'/../../bootstrap.php'; $con = Propel::getConnection(); // cleanup database AuthorPeer::doDeleteAll(); CommentPeer::doDeleteAll(); CategoryPeer::doDeleteAll(); ArticlePeer::doDeleteAll(); $t = new lime_test(33, new lime_output_color()); $article1 = new Article(); $article1->setTitle('tt1'); $article1->save(); $article2 = new Article(); $article2->setTitle('tt2'); $article2->save(); $article3 = new Article(); $article3->setTitle('tt3'); $article3->save();
public static function depopulate() { AcctAccessRolePeer::doDeleteAll(); AuthorPeer::doDeleteAll(); BookstorePeer::doDeleteAll(); BookstoreContestPeer::doDeleteAll(); BookstoreContestEntryPeer::doDeleteAll(); BookstoreEmployeePeer::doDeleteAll(); BookstoreEmployeeAccountPeer::doDeleteAll(); BookstoreSalePeer::doDeleteAll(); BookClubListPeer::doDeleteAll(); BookOpinionPeer::doDeleteAll(); BookReaderPeer::doDeleteAll(); BookListRelPeer::doDeleteAll(); BookPeer::doDeleteAll(); ContestPeer::doDeleteAll(); CustomerPeer::doDeleteAll(); MediaPeer::doDeleteAll(); PublisherPeer::doDeleteAll(); ReaderFavoritePeer::doDeleteAll(); ReviewPeer::doDeleteAll(); }
public static function depopulate($con = null) { if ($con === null) { $con = Propel::getConnection(BookPeer::DATABASE_NAME); } $con->beginTransaction(); AuthorPeer::doDeleteAll($con); BookstorePeer::doDeleteAll($con); BookstoreContestPeer::doDeleteAll($con); BookstoreContestEntryPeer::doDeleteAll($con); BookstoreEmployeePeer::doDeleteAll($con); BookstoreEmployeeAccountPeer::doDeleteAll($con); BookstoreSalePeer::doDeleteAll($con); BookClubListPeer::doDeleteAll($con); BookOpinionPeer::doDeleteAll($con); BookReaderPeer::doDeleteAll($con); BookListRelPeer::doDeleteAll($con); BookPeer::doDeleteAll($con); ContestPeer::doDeleteAll($con); CustomerPeer::doDeleteAll($con); MediaPeer::doDeleteAll($con); PublisherPeer::doDeleteAll($con); ReaderFavoritePeer::doDeleteAll($con); ReviewPeer::doDeleteAll($con); $con->commit(); }