/**
* This method actually checks if the functionality that needs to be changed
* for the above test to work will still work after the change ...
*
* check if stuff like MAX(id), LOWER(question), etc. will be converted to
* MAX(TABLE_QUESTION.id), LOWER(TABLE_QUESTION.question)
* this is done for preventing ambiguous column names, that's why it only applies
* in joined queries ...
*/
function test_testSqlFunction()
{
$theQuestion = 'Why does this not work?';
$theAnswer = 'I dont know!';
$question = new MDB_QT(TABLE_QUESTION);
$newQuest = array(TABLE_QUESTION => $theQuestion);
$qid = $question->add($newQuest);
$answer = new MDB_QT(TABLE_ANSWER);
$newAnswer = array(TABLE_QUESTION . '_id' => $qid, TABLE_ANSWER => $theAnswer);
$aid = $answer->add($newAnswer);
$question->autoJoin(TABLE_ANSWER);
// $question->setSelect('id, '.TABLE_QUESTION.' as question, '.TABLE_ANSWER.' as answer');
$question->setSelect('MAX(id),' . TABLE_ANSWER . '.id');
$this->assertTrue(strpos($question->_buildSelectQuery(), 'MAX(' . TABLE_QUESTION . '.id)'));
// check '(question)'
$question->setSelect('LOWER(question),' . TABLE_ANSWER . '.*');
$this->assertTrue(strpos($question->_buildSelectQuery(), 'LOWER(' . TABLE_QUESTION . '.question)'));
// check 'id,'
$question->setSelect('id, ' . TABLE_ANSWER . '.*');
$this->assertTrue(strpos($question->_buildSelectQuery(), TABLE_QUESTION . '.id'));
// check 'id as qid'
$question->setSelect('id as qid, ' . TABLE_ANSWER . '.*');
$this->assertTrue(strpos($question->_buildSelectQuery(), TABLE_QUESTION . '.id as qid'));
// check 'id as qid'
$question->setSelect('LOWER( question ), ' . TABLE_ANSWER . '.*');
$this->assertTrue(strpos($question->_buildSelectQuery(), 'LOWER( ' . TABLE_QUESTION . '.question )'));
}
/**
* This method checks if the setJoin() method is working correctly
*
* check if stuff like MAX(id), LOWER(question), etc. will be converted to
* MAX(TABLE_QUESTION.id), LOWER(TABLE_QUESTION.question)
* this is done for preventing ambiguous column names, that's why it only applies
* in joined queries ...
*/
function test_setJoin()
{
$theQuestion = 'Why does this not work?';
$theAnswer = 'I dont know!';
$question = new MDB_QT(TABLE_QUESTION);
$newQuest = array(TABLE_QUESTION => $theQuestion);
$qid = $question->add($newQuest);
$this->assertTrue($qid != false);
$answer = new MDB_QT(TABLE_ANSWER);
$newAnswer = array(TABLE_QUESTION . '_id' => $qid, TABLE_ANSWER => $theAnswer);
$aid = $answer->add($newAnswer);
$this->assertTrue($aid != false);
$joinOn = TABLE_QUESTION . '.id=' . TABLE_ANSWER . '.question_id';
$question->setJoin(TABLE_ANSWER, $joinOn);
if (DB_TYPE == 'ibase') {
$expected = array('t_answer_id' => $aid, 't_answer_answer' => $theAnswer, 't_answer_question_id' => $qid, 'id' => $qid, 'question' => $theQuestion);
} else {
$expected = array('_answer_id' => $aid, '_answer_answer' => $theAnswer, '_answer_question_id' => $qid, 'id' => $qid, 'question' => $theQuestion);
}
$this->assertEqual($expected, $question->get($qid));
}
