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."); }
public function testMultiLeafExpansion() { $objMilestone = Milestone::QuerySingle(QQ::Equal(QQN::Milestone()->Id, 1), QQ::Clause(QQ::ExpandAsArray(QQN::Milestone()->Project->ManagerPerson->ProjectAsTeamMember), QQ::ExpandAsArray(QQN::Milestone()->Project->PersonAsTeamMember))); $objProjectArray = $objMilestone->Project->ManagerPerson->_ProjectAsTeamMemberArray; $objPeopleArray = $objMilestone->Project->_PersonAsTeamMemberArray; $this->assertTrue(is_array($objProjectArray), "_ProjectAsTeamMemberArray is an array"); $this->assertEqual(count($objProjectArray), 2, "_ProjectAsTeamMemberArray has 2 Project objects"); $this->assertTrue(is_array($objPeopleArray), "_PersonAsTeamMemberArray is an array"); $this->assertEqual(count($objPeopleArray), 5, "_PersonAsTeamMemberArray has 5 People objects"); // try through a unique relationship $objLogin = Login::QuerySingle(QQ::Equal(QQN::Login()->PersonId, 7), QQ::Clause(QQ::ExpandAsArray(QQN::Login()->Person->ProjectAsTeamMember), QQ::ExpandAsArray(QQN::Login()->Person->ProjectAsManager))); $objProjectArray = $objLogin->Person->_ProjectAsTeamMemberArray; $this->assertTrue(is_array($objProjectArray), "_ProjectAsTeamMemberArray is an array"); $this->assertEqual(count($objProjectArray), 2, "_ProjectAsTeamMemberArray has 2 Project objects"); $objProjectArray = $objLogin->Person->_ProjectAsManagerArray; $this->assertTrue(is_array($objProjectArray), "_ProjectAsManagerArray is an array"); $this->assertEqual(count($objProjectArray), 2, "_ProjectAsManagerArray has 2 Project objects"); }
public function testEmptyColumns() { $objItem = Login::QuerySingle(QQ::Equal(QQN::Login()->Id, 1)); $var = $objItem->IsEnabled; $this->assertNotNull($var, "Zero column does not return null. "); $this->assertTrue($var == 0, "Zero boolean column is false or zero. "); $objItem = Project::QuerySingle(QQ::Equal(QQN::Project()->Id, 2)); $this->assertTrue($objItem->EndDate === null, "Null date column returns a null."); // Testing unique reverse reference on null $objPerson = new Person(); $objLogin = $objPerson->Login; $this->assertNull($objLogin, "New record should not be associated with null PK."); }
/** * Load a single Login object, * by Email Index(es) * @param string $strEmail * @return Login */ public static function LoadByEmail($strEmail, $objOptionalClauses = null) { return Login::QuerySingle(QQ::Equal(QQN::Login()->Email, $strEmail), $objOptionalClauses); }