| Server IP : www.kowitt.ac.th / Your IP : 216.73.216.118 Web Server : Microsoft-IIS/7.5 System : Windows NT SERVER02 6.1 build 7601 (Windows Server 2008 R2 Standard Edition Service Pack 1) i586 User : IUSR ( 0) PHP Version : 5.6.31 Disable Function : NONE MySQL : ON | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : C:/inetpub/wwwroot/phpMyAdmin/test/libraries/common/ |
Upload File : |
<?php
/* vim: set expandtab sw=4 ts=4 sts=4: */
/**
* Test for quoting, slashing/backslashing
*
* @package PhpMyAdmin-test
* @group common.lib-tests
*/
/*
* Include to test.
*/
/**
* Test for quoting, slashing/backslashing
*
* @package PhpMyAdmin-test
* @group common.lib-tests
*/
class PMA_QuotingSlashing_Test extends PHPUnit_Framework_TestCase
{
/**
* sqlAddslashes test
*
* @return void
*/
public function testAddSlashes()
{
$string = "\'test''\''\'\r\t\n";
$this->assertEquals(
"\\\\\\\\\'test\'\'\\\\\\\\\'\'\\\\\\\\\'\\r\\t\\n",
PMA\libraries\Util::sqlAddSlashes($string, true, true, true)
);
$this->assertEquals(
"\\\\\\\\\\'test\\'\\'\\\\\\\\\\'\\'\\\\\\\\\\'\\r\\t\\n",
PMA\libraries\Util::sqlAddSlashes($string, true, true, false)
);
$this->assertEquals(
"\\\\\\\\\'test\'\'\\\\\\\\\'\'\\\\\\\\\'\r\t\n",
PMA\libraries\Util::sqlAddSlashes($string, true, false, true)
);
$this->assertEquals(
"\\\\\\\\\\'test\\'\\'\\\\\\\\\\'\\'\\\\\\\\\\'\r\t\n",
PMA\libraries\Util::sqlAddSlashes($string, true, false, false)
);
$this->assertEquals(
"\\\\\'test\'\'\\\\\'\'\\\\\'\\r\\t\\n",
PMA\libraries\Util::sqlAddSlashes($string, false, true, true)
);
$this->assertEquals(
"\\\\\\'test\\'\\'\\\\\\'\\'\\\\\\'\\r\\t\\n",
PMA\libraries\Util::sqlAddSlashes($string, false, true, false)
);
$this->assertEquals(
"\\\\\'test\'\'\\\\\'\'\\\\\'\r\t\n",
PMA\libraries\Util::sqlAddSlashes($string, false, false, true)
);
$this->assertEquals(
"\\\\\\'test\\'\\'\\\\\\'\\'\\\\\\'\r\t\n",
PMA\libraries\Util::sqlAddSlashes($string, false, false, false)
);
$this->assertEquals(
"\\\\\\'",
PMA\libraries\Util::sqlAddSlashes('\\\'')
);
}
/**
* data provider for PMA\libraries\Util::unQuote test
*
* @return array
*/
public function unQuoteProvider()
{
return array(
array('"test\'"', "test'"),
array("'test''", "test'"),
array("`test'`", "test'"),
array("'test'test", "'test'test")
);
}
/**
* PMA\libraries\Util::unQuote test
*
* @param string $param String
* @param string $expected Expected output
*
* @return void
*
* @dataProvider unQuoteProvider
*/
public function testUnQuote($param, $expected)
{
$this->assertEquals(
$expected, PMA\libraries\Util::unQuote($param)
);
}
/**
* data provider for PMA\libraries\Util::unQuote test with chosen quote
*
* @return array
*/
public function unQuoteSelectedProvider()
{
return array(
array('"test\'"', "test'"),
array("'test''", "'test''"),
array("`test'`", "`test'`"),
array("'test'test", "'test'test")
);
}
/**
* PMA\libraries\Util::unQuote test with chosen quote
*
* @param string $param String
* @param string $expected Expected output
*
* @return void
*
* @dataProvider unQuoteSelectedProvider
*/
public function testUnQuoteSelectedChar($param, $expected)
{
$this->assertEquals(
$expected, PMA\libraries\Util::unQuote($param, '"')
);
}
/**
* data provider for backquote test
*
* @return array
*/
public function backquoteDataProvider()
{
return array(
array('0', '`0`'),
array('test', '`test`'),
array('te`st', '`te``st`'),
array(
array('test', 'te`st', '', '*'),
array('`test`', '`te``st`', '', '*')
)
);
}
/**
* backquote test with different param $do_it (true, false)
*
* @param string $a String
* @param string $b Expected output
*
* @return void
*
* @dataProvider backquoteDataProvider
*/
public function testBackquote($a, $b)
{
// Test bypass quoting (used by dump functions)
$this->assertEquals($a, PMA\libraries\Util::backquote($a, false));
// Test backquote
$this->assertEquals($b, PMA\libraries\Util::backquote($a));
}
/**
* data provider for backquoteCompat test
*
* @return array
*/
public function backquoteCompatDataProvider()
{
return array(
array('0', '"0"'),
array('test', '"test"'),
array('te`st', '"te`st"'),
array(
array('test', 'te`st', '', '*'),
array('"test"', '"te`st"', '', '*')
)
);
}
/**
* backquoteCompat test with different param $compatibility (NONE, MSSQL)
*
* @param string $a String
* @param string $b Expected output
*
* @return void
*
* @dataProvider backquoteCompatDataProvider
*/
public function testbackquoteCompat($a, $b)
{
// Test bypass quoting (used by dump functions)
$this->assertEquals($a, PMA\libraries\Util::backquoteCompat($a, 'NONE', false));
// Run tests in MSSQL compatibility mode
// Test bypass quoting (used by dump functions)
$this->assertEquals($a, PMA\libraries\Util::backquoteCompat($a, 'MSSQL', false));
// Test backquote
$this->assertEquals($b, PMA\libraries\Util::backquoteCompat($a, 'MSSQL'));
}
/**
* backquoteCompat test with forbidden words
*
* @return void
*/
public function testBackquoteForbidenWords()
{
foreach (SqlParser\Context::$KEYWORDS as $keyword => $type) {
if ($type & SqlParser\Token::FLAG_KEYWORD_RESERVED) {
$this->assertEquals(
"`" . $keyword . "`",
PMA\libraries\Util::backquote($keyword, false)
);
} else {
$this->assertEquals(
$keyword,
PMA\libraries\Util::backquote($keyword, false)
);
}
}
}
}