public function testSelect()
{
$objTest = new TypeTest();
$objTest->TestFloat = 2.0;
$objTest->Save();
$objTest2 = new TypeTest();
$objTest2->TestFloat = 3.0;
$objTest2->Save();
$objResArray = TypeTest::QueryArray(QQ::GreaterThan(QQ::Virtual('power2', QQ::Power(QQN::TypeTest()->TestFloat, 2.0)), 1.0), QQ::Clause(QQ::OrderBy(QQ::Virtual('power2')), QQ::Expand(QQ::Virtual('power2')), QQ::Select(QQ::Virtual('power2'))));
$this->assertEquals(2, count($objResArray));
if (2 == count($objResArray)) {
$objRes = $objResArray[0];
$this->assertNotNull($objRes);
if ($objRes) {
$this->assertNull($objRes->TestFloat);
$this->assertEquals(4.0, $objRes->GetVirtualAttribute('power2'));
}
$objRes = $objResArray[1];
$this->assertNotNull($objRes);
if ($objRes) {
$this->assertNull($objRes->TestFloat);
$this->assertEquals(9.0, $objRes->GetVirtualAttribute('power2'));
}
}
$objTest->Delete();
$objTest2->Delete();
}
public function testSelect()
{
$objTest = new TypeTest();
$objTest->TestFloat = 1.0;
$objTest->Save();
$objTest2 = new TypeTest();
$objTest2->TestFloat = 2.0;
$objTest2->Save();
$objResArray = TypeTest::QueryArray(QQ::LessThan(QQ::Virtual('mul1', QQ::Mul(QQN::TypeTest()->TestFloat, -2.0)), -1.0), QQ::Clause(QQ::OrderBy(QQ::Virtual('mul1')), QQ::Expand(QQ::Virtual('mul1')), QQ::Select(QQ::Virtual('mul1'))));
$this->assertEquals(2, count($objResArray));
if (2 == count($objResArray)) {
$objRes = $objResArray[0];
$this->assertNotNull($objRes);
if ($objRes) {
$this->assertNull($objRes->TestFloat);
$this->assertEquals(-4.0, $objRes->GetVirtualAttribute('mul1'));
}
$objRes = $objResArray[1];
$this->assertNotNull($objRes);
if ($objRes) {
$this->assertNull($objRes->TestFloat);
$this->assertEquals(-2.0, $objRes->GetVirtualAttribute('mul1'));
}
}
$objTest->Delete();
$objTest2->Delete();
}
public function testSave()
{
$objTest = new TypeTest();
// Test null saves
$objTest->Save();
$id = $objTest->Id;
$objTest2 = TypeTest::Load($id);
$this->assertNull($objTest2->Date, 'Null date is saved as a NULL in database');
$this->assertNull($objTest2->Time, 'Null time is saved as a NULL in database');
$this->assertNull($objTest2->DateTime, 'Null datetime is saved as a NULL in database');
$objTest2->Delete();
// Test empty saves
$objTest = new TypeTest();
$objTest->Date = new QDateTime();
$objTest->Time = new QDateTime();
$objTest->DateTime = new QDateTime();
$objTest->Save();
$id = $objTest->Id;
$objTest2 = TypeTest::Load($id);
$this->assertNull($objTest2->Date, 'Empty date is saved as a NULL in database');
$this->assertNull($objTest2->Time, 'Empty time is saved as a NULL in database');
$this->assertNull($objTest2->DateTime, 'Empty datetime is saved as a NULL in database');
$objTest2->Delete();
// Test value combinations
$objTest = new TypeTest();
$objTest->Date = new QDateTime('2002-3-5', null, QDateTime::DateOnlyType);
$objTest->Time = new QDateTime('13:15:02', null, QDateTime::TimeOnlyType);
$objTest->DateTime = new QDateTime('2002-3-5 13:15:02');
$objTest->Save();
$id = $objTest->Id;
$objTest2 = TypeTest::Load($id);
$dt = clone $objTest2->Date;
$dt->SetTime($objTest2->Time);
$this->assertTrue($dt->IsEqualTo($objTest2->DateTime), 'Combined dates and times after a save are correct.');
$objTest2->Delete();
}
/**
* Set the host portion of the url
*
* @param string $host
*/
public function setHost($host = null)
{
$this->host = TypeTest::nullableString($host, "host");
}
