test/PMA_escapeMySqlWildcards_test.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Test for MySQL Wildcards escaping/unescaping
   5  *
   6  * @author Michal Biniek <michal@bystrzyca.pl>
   7  * @package phpMyAdmin-test
   8  * @version $Id$
   9  */
  10
  11 /**
  12  * Tests core.
  13  */
  14 require_once 'PHPUnit/Framework.php';
  15
  16 /**
  17  * Include to test.
  18  */
  19 require_once './libraries/common.lib.php';
  20
  21 /**
  22  * Test MySQL escaping.
  23  *
  24  */
  25 class PMA_escapeMySqlWildcards_test extends PHPUnit_Framework_TestCase
  26 {
  27
  28     /**
  29      * PMA_escape_mysql_wildcards tests
  30      */
  31
  32     public function testEscape_1()
  33     {
  34         $this->assertEquals('\_test', PMA_escape_mysql_wildcards('_test'));
  35     }
  36
  37         public function testEscape_2()
  38     {
  39         $this->assertEquals('\_\\', PMA_escape_mysql_wildcards('_\\'));
  40     }
  41
  42         public function testEscape_3()
  43     {
  44         $this->assertEquals('\\_\%', PMA_escape_mysql_wildcards('_%'));
  45     }
  46
  47         public function testEscape_4()
  48     {
  49         $this->assertEquals('\\\_', PMA_escape_mysql_wildcards('\_'));
  50     }
  51
  52         public function testEscape_5()
  53     {
  54         $this->assertEquals('\\\_\\\%', PMA_escape_mysql_wildcards('\_\%'));
  55     }
  56
  57         /**
  58          * PMA_unescape_mysql_wildcards tests
  59          */
  60
  61         public function testUnEscape_1()
  62     {
  63         $this->assertEquals('_test', PMA_unescape_mysql_wildcards('\_test'));
  64     }
  65
  66         public function testUnEscape_2()
  67     {
  68         $this->assertEquals('_%__%', PMA_unescape_mysql_wildcards('\_\\%\_\_\%'));
  69     }
  70
  71         public function testUnEscape_3()
  72     {
  73         $this->assertEquals('\_', PMA_unescape_mysql_wildcards('\\\_'));
  74     }
  75
  76         public function testUnEscape_4()
  77     {
  78         $this->assertEquals('%_', PMA_unescape_mysql_wildcards('%\_'));
  79     }
  80
  81         public function testUnEscape_5()
  82     {
  83         $this->assertEquals('\%\_', PMA_unescape_mysql_wildcards('\\\%\\\_'));
  84     }
  85 }
  86 ?>