/**
* This method checks if the getJoin() method is working correctly
*/
function test_getJoin()
{
$question = new MDB_QT(TABLE_QUESTION);
$joinOn1 = TABLE_QUESTION . '.id=' . TABLE_ANSWER . '.question_id';
$question->setJoin(TABLE_ANSWER, $joinOn1);
$all = array('default' => array(TABLE_ANSWER => $joinOn1));
$tables = array(TABLE_ANSWER);
$right = array();
$left = array();
$this->assertEqual($all, $question->getJoin());
$this->assertEqual($tables, $question->getJoin('tables'));
$this->assertEqual($right, $question->getJoin('right'));
$this->assertEqual($left, $question->getJoin('left'));
//--------------------------------------------------------
$joinOn2 = TABLE_USER . '.id=' . TABLE_ANSWER . '.question_id';
$question->setRightJoin(TABLE_USER, $joinOn2);
$all = array('default' => array(TABLE_ANSWER => $joinOn1), 'right' => array(TABLE_USER => $joinOn2));
$tables = array(TABLE_ANSWER, TABLE_USER);
$right = array(TABLE_USER => $joinOn2);
$left = array();
$this->assertEqual($all, $question->getJoin());
$this->assertEqual($tables, $question->getJoin('tables'));
$this->assertEqual($right, $question->getJoin('right'));
$this->assertEqual($left, $question->getJoin('left'));
}
