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