芝麻web文件管理V1.00

编辑当前文件:/home/strato/chroot/opt/RZphp80/includes/test/MDB_QueryTool/tests/GetTest.php

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

}
?>