PHP Project::QuerySingle Examples

Example #1

File: BasicOrmTests.php Project: tomVertuoz/framework

 public function testEmptyColumns()
 {
     $objItem = Login::QuerySingle(QQ::Equal(QQN::Login()->Id, 1));
     $this->assertTrue($objItem->IsEnabled === 0, "Zero column does not return null.");
     $objItem = Project::QuerySingle(QQ::Equal(QQN::Project()->Id, 2));
     $this->assertTrue($objItem->EndDate === null, "Null date column returns a null.");
 }

Example #2

File: BasicOrmTest.php Project: vaibhav-kaushal/qc-framework

 public function testSubSql()
 {
     $objProject = Project::QuerySingle(QQ::All(), QQ::Clause(QQ::Count(QQ::SubSql('DISTINCT {1}', QQN::Project()->ManagerPersonId), "manager_count")));
     $this->assertEquals(3, $objProject->GetVirtualAttribute("manager_count"), "Project manager count is 3");
 }