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();
}
