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