Changeset 1068 for trunk/generator/test/classes/propel/GeneratedObjectTest.php

Timestamp:

08/06/08 07:55:11 (4 months ago)

Author:

ron

Message:

Merge in changes from 1.3 branch: merge -r 832:1067

Files:

• trunk/generator (modified) (1 prop)
• trunk/generator/test/classes/propel/GeneratedObjectTest.php (modified) (12 diffs)

trunk/generator/test/classes/propel/GeneratedObjectTest.php

@@ -70 +70 @@
-                $this->assertEquals('2001-01-01', $r->getReviewDate('Y-m-d'));
-
-b
+
-
-                $acct = new BookstoreEmployeeAccount();
@@ -82 +82 @@
-
-        /**
-
-
+
+
+
+
-         */
-        public function testDefaultExpresions()
@@ -91 +93 @@
-                }
-
+                $b = new Bookstore();
+                $b->setStoreName("Foo!");
+                $b->save();
+
-                $employee = new BookstoreEmployee();
-                $employee->setName("Johnny Walker");
@@ -98 +104 @@
-                $acct->setLogin("test-login");
-
-
+
+
-
-                $acct->save();
-
-                // BookstoreEmployeeAccountPeer::removeInstanceFromPool($acct);
-
-                $acct = BookstoreEmployeeAccountPeer::retrieveByPK($acct->getEmployeeId());
+
+                $this->assertNotNull($acct->getAuthenticator(), "Expected a valid (non-NULL) authenticator column after save.");
+                $this->assertEquals('Password', $acct->getAuthenticator(), "Expected authenticator='Password' after save.");
-                $this->assertNotNull($acct->getCreated(), "Expected a valid date after retrieving saved object.");
-
@@ -113 +121 @@
-                $this->assertEquals($now->format("Y-m-d"), $acct->getCreated("Y-m-d"));
-
+                // Unfortunately we can't really test the conjunction of reloadOnInsert and reloadOnUpdate when using just
+                // default values. (At least not in a cross-db way.)
+        }
+
+        /**
+         * Tests the use of default expressions and the reloadOnInsert attribute.
+         *
+         * @link       http://propel.phpdb.org/trac/ticket/378
+         * @link       http://propel.phpdb.org/trac/ticket/555
+         */
+        public function testDefaultExpresions_ReloadOnInsert()
+        {
+                if (Propel::getDb(BookstoreEmployeePeer::DATABASE_NAME) instanceof DBSqlite) {
+                        $this->markTestSkipped("Cannot test default date expressions with SQLite");
+                }
+
+                // Create a new bookstore, contest, bookstore_contest, and bookstore_contest_entry
+
+                $b = new Bookstore();
+                $b->setStoreName("Barnes & Noble");
+                $b->save();
+
+                $c = new Contest();
+                $c->setName("Bookathon Contest");
+                $c->save();
+
+                $bc = new BookstoreContest();
+                $bc->setBookstore($b);
+                $bc->setContest($c);
+                $bc->save();
+
+                $c = new Customer();
+                $c->setName("Happy Customer");
+                $c->save();
+
+                $bce = new BookstoreContestEntry();
+                $bce->setBookstore($b);
+                $bce->setBookstoreContest($bc);
+                $bce->setCustomer($c);
+                $bce->save();
+
+                $this->assertNotNull($bce->getEntryDate(), "Expected a non-null entry_date after save.");
+        }
+
+        /**
+         * Tests the overriding reloadOnInsert at runtime.
+         *
+         * @link       http://propel.phpdb.org/trac/ticket/378
+         * @link       http://propel.phpdb.org/trac/ticket/555
+         */
+        public function testDefaultExpresions_ReloadOnInsert_Override()
+        {
+                if (Propel::getDb(BookstoreEmployeePeer::DATABASE_NAME) instanceof DBSqlite) {
+                        $this->markTestSkipped("Cannot test default date expressions with SQLite");
+                }
+
+                // Create a new bookstore, contest, bookstore_contest, and bookstore_contest_entry
+                $b = new Bookstore();
+                $b->setStoreName("Barnes & Noble");
+                $b->save();
+
+                $c = new Contest();
+                $c->setName("Bookathon Contest");
+                $c->save();
+
+                $bc = new BookstoreContest();
+                $bc->setBookstore($b);
+                $bc->setContest($c);
+                $bc->save();
+
+                $c = new Customer();
+                $c->setName("Happy Customer");
+                $c->save();
+
+                $bce = new BookstoreContestEntry();
+                $bce->setBookstore($b);
+                $bce->setBookstoreContest($bc);
+                $bce->setCustomer($c);
+                $bce->save(null, $skipReload=true);
+
+                $this->assertNull($bce->getEntryDate(), "Expected a NULL entry_date after save.");
+        }
+
+        /**
+         * Tests the use of default expressions and the reloadOnUpdate attribute.
+         *
+         * @link       http://propel.phpdb.org/trac/ticket/555
+         */
+        public function testDefaultExpresions_ReloadOnUpdate()
+        {
+                $b = new Bookstore();
+                $b->setStoreName("Foo!");
+                $b->save();
+
+                $sale = new BookstoreSale();
+                $sale->setBookstore(BookstorePeer::doSelectOne(new Criteria()));
+                $sale->setSaleName("Spring Sale");
+                $sale->save();
+
+                // Expect that default values are set, but not default expressions
+                $this->assertNull($sale->getDiscount(), "Expected discount to be NULL.");
+
+                $sale->setSaleName("Winter Clearance");
+                $sale->save();
+                // Since reloadOnUpdate = true, we expect the discount to be set now.
+
+                $this->assertNotNull($sale->getDiscount(), "Expected discount to be non-NULL after save.");
+        }
+
+        /**
+         * Tests the overriding reloadOnUpdate at runtime.
+         *
+         * @link       http://propel.phpdb.org/trac/ticket/378
+         * @link       http://propel.phpdb.org/trac/ticket/555
+         */
+        public function testDefaultExpresions_ReloadOnUpdate_Override()
+        {
+                $b = new Bookstore();
+                $b->setStoreName("Foo!");
+                $b->save();
+
+                $sale = new BookstoreSale();
+                $sale->setBookstore(BookstorePeer::doSelectOne(new Criteria()));
+                $sale->setSaleName("Spring Sale");
+                $sale->save();
+
+                // Expect that default values are set, but not default expressions
+                $this->assertNull($sale->getDiscount(), "Expected discount to be NULL.");
+
+                $sale->setSaleName("Winter Clearance");
+                $sale->save(null, $skipReload=true);
+
+                // Since reloadOnUpdate = true, we expect the discount to be set now.
+
+                $this->assertNull($sale->getDiscount(), "Expected NULL value for discount after save.");
-        }
-
@@ -144 +287 @@
-         * Test setting invalid date/time.
-         */
-
-
-
+
+
+
+
+
-                $r = new Review();
-                try {
@@ -166 +311 @@
-                $store->save();
-                $this->assertEquals('12:55', $store->getStoreOpenTime(null)->format('H:i'));
+
+                $acct = new BookstoreEmployeeAccount();
+                $acct->setCreated(time());
+                $this->assertEquals(date('Y-m-d H:i'), $acct->getCreated('Y-m-d H:i'));
+
+                $review = new Review();
+                $review->setReviewDate(time());
+                $this->assertEquals(date('Y-m-d'), $review->getReviewDate('Y-m-d'));
+        }
+
+        /**
+         * Test setting empty temporal values.
+         * @link       http://propel.phpdb.org/trac/ticket/586
+         */
+        public function testTemporalValues_Empty()
+        {
+                $review = new Review();
+                $review->setReviewDate('');
+                $this->assertNull($review->getReviewDate());
-        }
-
@@ -246 +410 @@
-                $this->assertSame($book, $book2, "Expected same book object instance");
-
+                $this->assertEquals($pub1->getId(), $book->getPublisherId(), "Expected book to have OLD publisher id before reload()");
+
+                $book->reload();
+
-                $this->assertEquals($pub2->getId(), $book->getPublisherId(), "Expected book to have new publisher id");
-                $this->assertSame($pub2, $book->getPublisher(), "Expected book to have new publisher object associated.");
-
- and also verify that reload() works
+, just to be double sure
-
-                $con->exec("UPDATE " . BookPeer::TABLE_NAME . " SET "
@@ -259 +427 @@
-                $this->assertEquals($pub1->getId(), $book->getPublisherId(), "Expected book to have old publisher id (again).");
-                $this->assertSame($pub1, $book->getPublisher(), "Expected book to have old publisher object associated (again).");
+
+        }
+
+        /**
+         * Test the effect of typecast on primary key values and instance pool retrieval.
+         */
+        public function testObjectInstancePoolTypecasting()
+        {
+                $reader = new BookReader();
+                $reader->setName("Tester");
+                $reader->save();
+                $readerId = $reader->getId();
+
+                $book = new Book();
+                $book->setTitle("BookTest");
+                $book->setISBN("TEST");
+                $book->save();
+                $bookId = $book->getId();
+
+                $opinion = new BookOpinion();
+                $opinion->setBookId((string)$bookId);
+                $opinion->setReaderId((string)$readerId);
+                $opinion->setRating("BAD!");
+                $opinion->setRecommendToFriend(false);
+                $opinion->save();
+
+
+                $opinion2 = BookOpinionPeer::retrieveByPK($bookId, $readerId);
+
+                $this->assertSame($opinion, $opinion2, "Expected same object to be retrieved from differently type-casted primary key values.");
-
-        }
@@ -403 +601 @@
-        /**
-         * Tests new one-to-one functionality.
-         *
-         * @todo       -cGeneratedObjectTest Add a test for one-to-one when implemented.
-         */
-        public function testOneToOne()
@@ -599 +795 @@
-        }
-
-        /**
-         * Test the LOB results returned in a resultset.
-         */
-        public function testLobResults()
-        {
-
-                $blob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.gif';
-                $clob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.txt';
-
-                $book = BookPeer::doSelectOne(new Criteria());
-
-                $m1 = new Media();
-                $m1->setBook($book);
-                $m1->setCoverImage(file_get_contents($blob_path));
-                $m1->setExcerpt(file_get_contents($clob_path));
-                $m1->save();
-                $m1_id = $m1->getId();
-
-                $m1->reload();
-
-                $img = $m1->getCoverImage();
-                $txt = $m1->getExcerpt();
-
-                $this->assertType('resource', $img, "Expected results of BLOB method to be a resource.");
-                $this->assertType('string', $txt, "Expected results of CLOB method to be a string.");
-
-                $stat = fstat($img);
-                $size = $stat['size'];
-
-                $this->assertEquals(filesize($blob_path), $size, "Expected filesize to match stat(blobrsc)");
-                $this->assertEquals(filesize($clob_path), strlen($txt), "Expected filesize to match clob strlen");
-        }
-
-        /**
-         * Tests the setting of LOB (BLOB and CLOB) values.
-         */
-        public function testLobSetting()
-        {
-                $blob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.gif';
-                $blob2_path = TESTS_BASE_DIR . '/etc/lob/propel.gif';
-
-                $clob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.txt';
-                $book = BookPeer::doSelectOne(new Criteria());
-
-                $m1 = new Media();
-                $m1->setBook($book);
-                $m1->setCoverImage(file_get_contents($blob_path));
-                $m1->setExcerpt(file_get_contents($clob_path));
-                $m1->save();
-                $m1_id = $m1->getId();
-
-                // 1) Assert that we've got a valid stream to start with
-                $img = $m1->getCoverImage();
-                $this->assertType('resource', $img, "Expected results of BLOB method to be a resource.");
-
-                // 2) Test setting a BLOB column with file contents
-                $m1->setCoverImage(file_get_contents($blob2_path));
-                $this->assertType('resource', $m1->getCoverImage(), "Expected to get a resource back after setting BLOB with file contents.");
-
-                // commit those changes & reload
-                $m1->save();
-
-                // 3) Verify that we've got a valid resource after reload
-                $m1->reload();
-                $this->assertType('resource', $m1->getCoverImage(), "Expected to get a resource back after setting reloading object.");
-
-                // 4) Test isModified() behavior
-                $fp = fopen("php://temp", "r+");
-                fwrite($fp, file_get_contents($blob2_path));
-
-                $m1->setCoverImage($fp);
-                $this->assertTrue($m1->isModified(), "Expected Media object to be modified, despite fact that stream is to same data");
-
-                // 5) Test external modification of the stream (and re-setting it into the object)
-                $stream = $m1->getCoverImage();
-                fwrite($stream, file_get_contents($blob_path)); // change the contents of the stream
-
-                $m1->setCoverImage($stream);
-
-                $this->assertTrue($m1->isModified(), "Expected Media object to be modified when stream contents changed.");
-                $this->assertNotEquals(file_get_contents($blob2_path), stream_get_contents($m1->getCoverImage()));
-
-                $m1->save();
-
-                // 6) Assert that when we call the setter with a stream, that the file in db gets updated.
-
-                $m1->reload(); // start with a fresh copy from db
-
-                // Ensure that object is set up correctly
-                $this->assertNotEquals(file_get_contents($blob_path), stream_get_contents($m1->getCoverImage()), "The object is not correctly set up to verify the stream-setting test.");
-
-                $fp = fopen($blob_path, "r");
-                $m1->setCoverImage($fp);
-                $m1->save();
-                $m1->reload(); // refresh from db
-
-                // Assert that we've updated the db
-                $this->assertEquals(file_get_contents($blob_path), stream_get_contents($m1->getCoverImage()), "Expected the updated BLOB value after setting with a stream.");
-
-                // 7) Assert that 'w' mode works
-
-        }
-
-        public function testLobSetting_WriteMode()
-        {
-                $blob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.gif';
-                $blob2_path = TESTS_BASE_DIR . '/etc/lob/propel.gif';
-
-                $clob_path = TESTS_BASE_DIR . '/etc/lob/tin_drum.txt';
-                $book = BookPeer::doSelectOne(new Criteria());
-
-                $m1 = new Media();
-                $m1->setBook($book);
-                $m1->setCoverImage(file_get_contents($blob_path));
-                $m1->setExcerpt(file_get_contents($clob_path));
-                $m1->save();
-
-                MediaPeer::clearInstancePool();
-
-                // make sure we have the latest from the db:
-                $m2 = MediaPeer::retrieveByPK($m1->getId());
-
-                // now attempt to assign a temporary stream, opened in 'w' mode, to the db
-
-                $stream = fopen("php://memory", 'w');
-                fwrite($stream, file_get_contents($blob2_path));
-                $m2->setCoverImage($stream);
-                $m2->save();
-                fclose($stream);
-
-                $m2->reload();
-                $this->assertEquals(file_get_contents($blob2_path), stream_get_contents($m2->getCoverImage()), "Expected contents to match when setting stream w/ 'w' mode");
-
-                $stream2 = fopen("php://memory", 'w+');
-                fwrite($stream2, file_get_contents($blob_path));
-                rewind($stream2);
-                $this->assertEquals(file_get_contents($blob_path), stream_get_contents($stream2), "Expecting setup to be correct");
-
-                $m2->setCoverImage($stream2);
-                $m2->save();
-                $m2->reload();
-
-                $this->assertEquals(file_get_contents($blob_path), stream_get_contents($m2->getCoverImage()), "Expected contents to match when setting stream w/ 'w+' mode");
-
-        }
-
-
-        public function testDefaultFkColVal()
-        {
-                $sale = new BookstoreSale();
-ID
+bookstore_id of 1
-
-                $bookstore = BookstorePeer::doSelectOne(new Criteria());
@@ -835 +884 @@
-                $this->assertEquals($emp->getBookstoreEmployeeAccount()->getLogin(), $e2->getBookstoreEmployeeAccount()->getLogin());
-        }
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-}