test/PMA_quoting_slashing_test.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Test for quoting, slashing/backslashing
   5  *
   6  * @package phpMyAdmin-test
   7  * @version $Id: PMA_quoting_slashing_test.php
   8  */
   9
  10 /**
  11  * Tests core.
  12  */
  13 require_once 'PHPUnit/Framework.php';
  14
  15 /**
  16  * Include to test.
  17  */
  18 require_once './libraries/common.lib.php';
  19
  20 /**
  21  * Test quoting, slashing, backslashing.
  22  *
  23  */
  24 class PMA_quoting_slashing_test extends PHPUnit_Framework_TestCase
  25 {
  26
  27     /**
  28      * sqlAddslashes test
  29      */
  30
  31     public function testAddSlashes() {
  32         $string = "\'test''\''\'\r\t\n";
  33
  34         $this->assertEquals("\\\\\\\\\'test\'\'\\\\\\\\\'\'\\\\\\\\\'\\r\\t\\n", PMA_sqlAddslashes($string, true, true, true));
  35         $this->assertEquals("\\\\\\\\''test''''\\\\\\\\''''\\\\\\\\''\\r\\t\\n", PMA_sqlAddslashes($string, true, true, false));
  36         $this->assertEquals("\\\\\\\\\'test\'\'\\\\\\\\\'\'\\\\\\\\\'\r\t\n", PMA_sqlAddslashes($string, true, false, true));
  37         $this->assertEquals("\\\\\\\\''test''''\\\\\\\\''''\\\\\\\\''\r\t\n", PMA_sqlAddslashes($string, true, false, false));
  38         $this->assertEquals("\\\\\'test\'\'\\\\\'\'\\\\\'\\r\\t\\n", PMA_sqlAddslashes($string, false, true, true));
  39         $this->assertEquals("\\\\''test''''\\\\''''\\\\''\\r\\t\\n", PMA_sqlAddslashes($string, false, true, false));
  40         $this->assertEquals("\\\\\'test\'\'\\\\\'\'\\\\\'\r\t\n", PMA_sqlAddslashes($string, false, false, true));
  41         $this->assertEquals("\\\\''test''''\\\\''''\\\\''\r\t\n", PMA_sqlAddslashes($string, false, false, false));
  42     }
  43
  44     /**
  45      * data provider for unQuote test
  46      */
  47
  48     public function unQuoteProvider() {
  49         return array(
  50             array('"test\'"', "test'"),
  51             array("'test''", "test'"),
  52             array("`test'`", "test'"),
  53             array("'test'test", "'test'test")
  54         );
  55     }
  56
  57     /**
  58      * unQuote test
  59      * @dataProvider unQuoteProvider
  60      */
  61
  62     public function testUnQuote($param, $expected) {
  63         $this->assertEquals($expected, PMA_unQuote($param));
  64     }
  65
  66     /**
  67      * data provider for unQuote test with chosen quote
  68      */
  69
  70     public function unQuoteSelectedProvider() {
  71         return array(
  72             array('"test\'"', "test'"),
  73             array("'test''", "'test''"),
  74             array("`test'`", "`test'`"),
  75             array("'test'test", "'test'test")
  76         );
  77     }
  78
  79     /**
  80      * unQuote test with chosen quote
  81      * @dataProvider unQuoteSelectedProvider
  82      */
  83
  84     public function testUnQuoteSelectedChar($param, $expected) {
  85         $this->assertEquals($expected, PMA_unQuote($param, '"'));
  86     }
  87
  88     /**
  89      * data provider for backquote test
  90      */
  91
  92     public function backquoteDataProvider() {
  93         return array(
  94             array('0', '`0`'),
  95             array('test', '`test`'),
  96             array('te`st', '`te``st`'),
  97             array(array('test', 'te`st', '', '*'), array('`test`', '`te``st`', '', '*'))
  98         );
  99     }
 100
 101     /**
 102      * backquote test with different param $do_it (true, false)
 103      * @dataProvider backquoteDataProvider
 104      */
 105
 106     public function testBackquote($a, $b) {
 107         $this->assertEquals($a, PMA_backquote($a, false));
 108         $this->assertEquals($b, PMA_backquote($a));
 109     }
 110 }
 111 ?>