1#@!#!123s

: / opt / lampp / lib / php / test / MDB_QueryTool / tests /
Filename : GetQueryStringTest.php
back
<?php
//
// $Id: GetQueryStringTest.php 322098 2012-01-11 21:20:03Z danielc $
//

require_once dirname(__FILE__) . '/TestCase.php';

/**
* This class just checks if the query is returned, not if
* the query was properly rendered. This should be subject to
* some other tests!
*
* @package tests
*/
class tests_GetQueryStringTest extends tests_TestCase
{
    function _setup()
    {
        $this->question = new tests_Common(TABLE_QUESTION);
        $this->question->setOption('raw', true);
    }

    function test_selectAll()
    {
        $this->_setup();
        $this->assertStringEquals(
                            'SELECT '.TABLE_QUESTION.'.id AS id,'.TABLE_QUESTION.'.'.TABLE_QUESTION.' AS '.TABLE_QUESTION.' FROM '.TABLE_QUESTION
                            ,$this->question->getQueryString());
    }

    function test_selectWithWhere()
    {
        $this->_setup();
        $this->question->setWhere('id=1');
        $this->assertStringEquals(
                            'SELECT '.TABLE_QUESTION.'.id AS id,'.TABLE_QUESTION.'.'.TABLE_QUESTION.' AS '.TABLE_QUESTION.' FROM '.TABLE_QUESTION.
                            ' WHERE id=1'
                            ,$this->question->getQueryString());
    }
}

?>