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

Timestamp:

11/30/07 11:46:41 (1 year ago)

Author:

hans

Message:

Merging in changes from 1.3 branch. svn merge -r 534:832

Files:

• trunk/generator/test/classes/propel/GeneratedObjectTest.php (modified) (6 diffs)

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

@@ -42 +42 @@
-         * Test saving an object after setting default values for it.
-         */
- {
-
+
+
-                // From the schema.xml, I am relying on the following:
-                //  - that 'Penguin' is the default Name for a Publisher
-01/01/20
+2001-01-
-
-                // 1) check regular values (VARCHAR)
@@ -63 +63 @@
-
-        /**
+         * Test default return values.
+         */
+        public function testDefaultValues()
+        {
+                $r = new Review();
+                $this->assertEquals('2001-01-01', $r->getReviewDate('Y-m-d'));
+
+                $this->assertFalse($r->isModified(), "expected isModified() to be falseb");
+
+                $acct = new BookstoreEmployeeAccount();
+                $this->assertEquals(true, $acct->getEnabled());
+                $this->assertFalse($acct->isModified());
+
+                $acct->setLogin("testuser");
+                $acct->setPassword("testpass");
+                $this->assertTrue($acct->isModified());
+        }
+
+        /**
+         * Tests the use of default expressions.
+         * (Also indirectly tests the reload() method.)
+         */
+        public function testDefaultExpresions()
+        {
+                if (Propel::getDb(BookstoreEmployeePeer::DATABASE_NAME) instanceof DBSqlite) {
+                        $this->markTestSkipped("Cannot test default expressions with SQLite");
+                }
+
+                $employee = new BookstoreEmployee();
+                $employee->setName("Johnny Walker");
+
+                $acct = new BookstoreEmployeeAccount();
+                $acct->setBookstoreEmployee($employee);
+                $acct->setLogin("test-login");
+
+                $this->assertNull($acct->getCreated());
+
+                $acct->save();
+
+                // BookstoreEmployeeAccountPeer::removeInstanceFromPool($acct);
+
+                $acct = BookstoreEmployeeAccountPeer::retrieveByPK($acct->getEmployeeId());
+                $this->assertNotNull($acct->getCreated(), "Expected a valid date after retrieving saved object.");
+
+                $now = new DateTime("now");
+                $this->assertEquals($now->format("Y-m-d"), $acct->getCreated("Y-m-d"));
+
+                $acct->setCreated($now);
+                $this->assertEquals($now->format("Y-m-d"), $acct->getCreated("Y-m-d"));
+
+        }
+
+        /**
+         * Test the behavior of date/time/values.
+         * This requires that the model was built with propel.useDateTimeClass=true.
+         */
+        public function testTemporalValues_PreEpoch()
+        {
+                $r = new Review();
+
+                $preEpochDate = new DateTime('1602-02-02');
+
+                $r->setReviewDate($preEpochDate);
+
+                $this->assertEquals('1602-02-02', $r->getReviewDate(null)->format("Y-m-d"));
+
+                $r->setReviewDate('1702-02-02');
+
+                $this->assertTrue($r->isModified());
+
+                $this->assertEquals('1702-02-02', $r->getReviewDate(null)->format("Y-m-d"));
+
+                // Now test for setting null
+                $r->setReviewDate(null);
+                $this->assertNull($r->getReviewDate());
+
+        }
+
+        /**
+         * Test setting invalid date/time.
+         */
+        public function _disabled_testSetTemporalValue_Invalid()
+        {
+                // FIXME - Figure out why this doesn't work (doesn't throw Exception) in the Phing+PHPUnit context
+                $r = new Review();
+                try {
+                        $r->setReviewDate("Invalid Date");
+                        $this->fail("Expected PropelException when setting date column w/ invalid date");
+                } catch (PropelException $x) {
+                        print "Caught expected PropelException: " . $x->__toString();
+                }
+        }
+
+        /**
+         * Test setting TIMESTAMP columns w/ unix int timestamp.
+         */
+        public function testTemporalValues_Unix()
+        {
+                $store = new Bookstore();
+                $store->setStoreName("test");
+                $store->setStoreOpenTime(strtotime('12:55'));
+                $store->save();
+                $this->assertEquals('12:55', $store->getStoreOpenTime(null)->format('H:i'));
+        }
+
+        /**
+         * Test setting TIME columns.
+         */
+        public function testTemporalValues_TimeSetting()
+        {
+                $store = new Bookstore();
+                $store->setStoreName("test");
+                $store->setStoreOpenTime("12:55");
+                $store->save();
+
+                $store = new Bookstore();
+                $store->setStoreName("test2");
+                $store->setStoreOpenTime(new DateTime("12:55"));
+                $store->save();
+        }
+
+        /**
+         * Test setting TIME columns.
+         */
+        public function testTemporalValues_DateSetting()
+        {
+                $r = new Review();
+                $r->setBook(BookPeer::doSelectOne(new Criteria()));
+                $r->setReviewDate(new DateTime('1999-12-20'));
+                $r->setReviewedBy("Hans");
+                $r->setRecommended(false);
+                $r->save();
+        }
+
+        /**
+         * Testing creating & saving new object & instance pool.
+         */
+        public function testObjectInstances_New()
+        {
+                $emp = new BookstoreEmployee();
+                $emp->setName(md5(microtime()));
+                $emp->save();
+                $id = $emp->getId();
+
+                $retrieved = BookstoreEmployeePeer::retrieveByPK($id);
+                $this->assertSame($emp, $retrieved, "Expected same object (from instance pool)");
+        }
+
+        /**
+         *
+         */
+        public function testObjectInstances_Fkeys()
+        {
+                // Establish a relationship between one employee and account
+                // and then change the employee_id and ensure that the account
+                // is not pulling the old employee.
+
+                $pub1 = new Publisher();
+                $pub1->setName('Publisher 1');
+                $pub1->save();
+
+                $pub2 = new Publisher();
+                $pub2->setName('Publisher 2');
+                $pub2->save();
+
+                $book = new Book();
+                $book->setTitle("Book Title");
+                $book->setISBN("1234");
+                $book->setPublisher($pub1);
+                $book->save();
+
+                $this->assertSame($pub1, $book->getPublisher());
+
+                // now change values behind the scenes
+                $con = Propel::getConnection(BookstoreEmployeeAccountPeer::DATABASE_NAME);
+                $con->exec("UPDATE " . BookPeer::TABLE_NAME . " SET "
+                . " publisher_id = " . $pub2->getId()
+                . " WHERE id = " . $book->getId());
+
+
+                $book2 = BookPeer::retrieveByPK($book->getId());
+                $this->assertSame($book, $book2, "Expected same book object instance");
+
+                $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.");
+
+                // Now let's set it back and also verify that reload() works ...
+
+                $con->exec("UPDATE " . BookPeer::TABLE_NAME . " SET "
+                . " publisher_id = " . $pub1->getId()
+                . " WHERE id = " . $book->getId());
+
+                $book->reload();
+
+                $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 reload() method.
+         */
+        public function testReload()
+        {
+                $a = AuthorPeer::doSelectOne(new Criteria());
+
+                $origName = $a->getFirstName();
+
+                $a->setFirstName(md5(time()));
+
+                $this->assertNotEquals($origName, $a->getFirstName());
+                $this->assertTrue($a->isModified());
+
+                $a->reload();
+
+                $this->assertEquals($origName, $a->getFirstName());
+                $this->assertFalse($a->isModified());
+
+        }
+
+        /**
+         * Test reload(deep=true) method.
+         */
+        public function testReloadDeep()
+        {
+                // arbitrary book
+                $b = BookPeer::doSelectOne(new Criteria());
+
+                // arbitrary, different author
+                $c = new Criteria();
+                $c->add(AuthorPeer::ID, $b->getAuthorId(), Criteria::NOT_EQUAL);
+                $a = AuthorPeer::doSelectOne($c);
+
+                $origAuthor = $b->getAuthor();
+
+                $b->setAuthor($a);
+
+                $this->assertNotEquals($origAuthor, $b->getAuthor(), "Expected just-set object to be different from obj from DB");
+                $this->assertTrue($b->isModified());
+
+                $b->reload($deep=true);
+
+                $this->assertEquals($origAuthor, $b->getAuthor(), "Expected object in DB to be restored");
+                $this->assertFalse($a->isModified());
+        }
+
+        /**
-         * Test saving an object and getting correct number of affected rows from save().
-         * This includes tests of cascading saves to fk-related objects.
@@ -98 +345 @@
-                // modify the related author
-                $author->setLastName("Kurlanski");
-  
+
-                $this->assertEquals(1, $affected, "Expected 1 affected row when saving book with updated author.");
-
@@ -104 +351 @@
-                $author->setLastName("Kurlansky");
-                $book->setTitle("Salt: A World History");
-  
+
-                $this->assertEquals(2, $affected, "Expected 2 affected rows when saving updated book with updated author.");
-
@@ -184 +431 @@
-                $r->setBook($book);
-                $r->setRecommended(true);
-
-
+
+
+
-                unset($r);
-
@@ -199 +447 @@
-                $this->assertType('boolean', $r2->getRecommended(), "Expected getRecommended() to return a boolean.");
-                $this->assertType('Book', $r2->getBook(), "Expected getBook() to return a Book.");
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-}