/**
* Tests the use of default expressions and the reloadOnInsert and reloadOnUpdate attributes.
*
* @link http://trac.propelorm.org/ticket/378
* @link http://trac.propelorm.org/ticket/555
*/
public function testDefaultExpressions()
{
if (Propel::getDb(BookstoreEmployeePeer::DATABASE_NAME) instanceof DBSqlite) {
$this->markTestSkipped("Cannot test default expressions with SQLite");
}
BookstoreEmployeeAccountPeer::doDeleteAll();
$b = new Bookstore();
$b->setStoreName("Foo!");
$b->save();
$employee = new BookstoreEmployee();
$employee->setName("Johnny Walker");
$acct = new BookstoreEmployeeAccount();
$acct->setBookstoreEmployee($employee);
$acct->setLogin("test-login");
$this->assertNull($acct->getCreated(), "Expected created column to be NULL.");
$this->assertNull($acct->getAuthenticator(), "Expected authenticator column to be NULL.");
$acct->save();
$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.");
$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"));
// 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.)
}
/**
* 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'));
$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'));
}
