Viewing file:  GetTest.php (5.66 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//
// $Id: GetTest.php 322098 2012-01-11 21:20:03Z danielc $
//
require_once dirname(__FILE__) . '/TestCase.php';
class tests_GetTest extends tests_TestCase
{
function test_AddGet()
{
$user = new tests_Common(TABLE_USER);
$newData = array( 'login' => 'cain',
'password' => '0',
'name' => 'Lutz Testern',
'address_id'=> 0,
'company_id'=> 0
);
$userId = $user->add( $newData );
$newData['id'] = $userId;
$this->assertEquals($newData,$user->get($userId));
$newData = array( 'login' => '',
'password' => '',
'name' => '',
'address_id'=> 0,
'company_id'=> 0
);
$userId = $user->add( $newData );
if (!$userId) {
$errors = $user->getErrors();
$this->fail($errors[0][1]);
}
$newData['id'] = $userId;
$this->assertEquals($newData,$user->get($userId));
}
// test if column==table works, using the table TABLE_QUESTION
function test_tableEqualsColumn()
{
$question = new tests_Common(TABLE_QUESTION);
$newData = array(TABLE_QUESTION => 'Why does this not work?');
$id = $question->add($newData);
$newData['id'] = $id;
$this->assertEquals($newData, $question->get($id));
}
// test if column==table works, using the table TABLE_QUESTION
function test_tableEqualsColumnGetAll()
{
$question = new tests_Common(TABLE_QUESTION);
$newData = array(TABLE_QUESTION => 'Why does this not work?');
$id = $question->add($newData);
$newData['id'] = $id;
$data = $question->getAll();
// assertEquals doesnt sort arrays recursively, so we have to extract the data :-(
// we cant do this: $this->assertEquals(array($newData),$question->getAll());
$this->assertEquals($newData, $data[0]);
}
// test if column==table works, using the table TABLE_QUESTION
// this fails in v0.9.3
// a join makes it fail!!!, the tests above are just convinience tests
// they are actually meant to work !always! :-)
function test_tableEqualsColumnJoinedGetAll()
{
$theQuestion = 'Why does this not work?';
$theAnswer = 'I dont know!';
$question = new tests_Common(TABLE_QUESTION);
$newQuest = array(TABLE_QUESTION => $theQuestion);
$qid=$question->add($newQuest);
$answer = new tests_Common(TABLE_ANSWER);
$newAnswer = array(TABLE_QUESTION.'_id' => $qid, TABLE_ANSWER => $theAnswer);
$aid = $answer->add($newAnswer);
$question->autoJoin(TABLE_ANSWER);
//$newData['id'] = $id;
$data = $question->getAll();
$expected = array( '_'.TABLE_ANSWER.'_id'=>$aid,
'_'.TABLE_ANSWER.'_'.TABLE_ANSWER=>$theAnswer,
'_'.TABLE_ANSWER.'_'.TABLE_QUESTION.'_id'=>$qid,
'id'=>$qid,
TABLE_QUESTION=>$theQuestion);
// assertEquals doesnt sort arrays recursively, so we have to extract the data :-(
// we cant do this: $this->assertEquals(array($newData),$question->getAll());
$this->assertEquals($expected, $data[0]);
}
/**
* 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 ambigious 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 tests_Common(TABLE_QUESTION);
$question->setOption('raw', true);
$newQuest = array(TABLE_QUESTION => $theQuestion);
$qid=$question->add($newQuest);
$answer = new tests_Common(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->assertStringStartsWith(
'SELECT MAX('.TABLE_QUESTION.'.id)',
$question->_buildSelectQuery());
// check '(question)'
$question->setSelect('LOWER('.TABLE_QUESTION.'),'.TABLE_ANSWER.'.*');
$this->assertStringStartsWith(
'SELECT LOWER('.TABLE_QUESTION.'.'.TABLE_QUESTION.')',
$question->_buildSelectQuery());
// check 'id,'
$question->setSelect('id, '.TABLE_ANSWER.'.*');
$this->assertStringStartsWith(
'SELECT '.TABLE_QUESTION.'.id',
$question->_buildSelectQuery());
// check 'id as qid'
$question->setSelect('id as qid, '.TABLE_ANSWER.'.*');
$this->assertStringStartsWith(
'SELECT '.TABLE_QUESTION.'.id AS qid',
$question->_buildSelectQuery());
// check 'id as qid'
$question->setSelect('LOWER( '.TABLE_QUESTION.' ), '.TABLE_ANSWER.'.*');
$this->assertStringStartsWith(
'SELECT LOWER( '.TABLE_QUESTION.'.'.TABLE_QUESTION.' )',
$question->_buildSelectQuery());
}
}
?>
|