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