/**
* Helper method
*
* @param string input
* @param bool lower whether this is the lower boundary
* @return util.Date
*/
protected function parseDate($input, $lower)
{
switch ($input) {
case '__NOW__':
if ($lower) {
$r = DateUtil::getMidnight(Date::now());
} else {
$r = DateUtil::getMidnight(DateUtil::addDays(Date::now(), 1));
}
break;
case '__FUTURE__':
$r = Date::now();
break;
case '__UNLIMITED__':
$r = null;
break;
default:
$r = new Date($input);
}
return $r;
}
public function testNonLeapYear()
{
$date = \util\Date::create(1999, 2, 1, 0, 0, 0, new TimeZone('Europe/Berlin'));
$this->assertEquals(\util\Date::create(1999, 3, 1, 0, 0, 0, new TimeZone('Europe/Berlin')), DateUtil::addMonths($date, 1));
$this->assertEquals(\util\Date::create(1999, 3, 3, 0, 0, 0, new TimeZone('Europe/Berlin')), DateUtil::addDays($date, 30));
}
public function multipleResultForDoSelect()
{
$this->setResults(new MOckResultSet(array(0 => array('job_id' => 1, 'title' => 'Unit tester', 'valid_from' => Date::now(), 'expire_at' => null), 1 => array('job_id' => 9, 'title' => 'PHP programmer', 'valid_from' => Date::now(), 'expire_at' => DateUtil::addDays(Date::now(), 7)))));
$peer = Job::getPeer();
$jobs = $peer->doSelect(new \rdbms\Criteria(array('job_id', 10, LESS_THAN)));
$this->assertArray($jobs);
$this->assertEquals(2, sizeof($jobs));
$this->assertClass($jobs[0], 'net.xp_framework.unittest.rdbms.dataset.Job');
$this->assertEquals(1, $jobs[0]->getJob_id());
$this->assertClass($jobs[1], 'net.xp_framework.unittest.rdbms.dataset.Job');
$this->assertEquals(9, $jobs[1]->getJob_id());
}
public function multipleResultForDoSelect()
{
$this->setResults(new MockResultSet([0 => ['job_id' => 1, 'title' => 'Unit tester', 'valid_from' => Date::now(), 'expire_at' => null], 1 => ['job_id' => 9, 'title' => 'PHP programmer', 'valid_from' => Date::now(), 'expire_at' => DateUtil::addDays(Date::now(), 7)]]));
$peer = Job::getPeer();
$jobs = $peer->doSelect(new \rdbms\Criteria(['job_id', 10, LESS_THAN]));
$this->assertInstanceOf('var[]', $jobs);
$this->assertEquals(2, sizeof($jobs));
$this->assertInstanceOf(Job::class, $jobs[0]);
$this->assertEquals(1, $jobs[0]->getJob_id());
$this->assertInstanceOf(Job::class, $jobs[1]);
$this->assertEquals(9, $jobs[1]->getJob_id());
}
