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  * @package phpMyAdmin-test
   7  */
   8
   9 /**
  10  * Tests core.
  11  */
  12 require_once 'PHPUnit/Framework.php';
  13
  14 /**
  15  * Include to test.
  16  */
  17 require_once './libraries/common.lib.php';
  18
  19 /**
  20  * Test MySQL escaping.
  21  *
  22  */
  23 class PMA_escapeMySqlWildcards_test extends PHPUnit_Framework_TestCase
  24 {
  25
  26     public function escapeDataProvider() {
  27         return array(
  28             array('\_test', '_test'),
  29             array('\_\\', '_\\'),
  30             array('\\_\%', '_%'),
  31             array('\\\_', '\_'),
  32             array('\\\_\\\%', '\_\%'),
  33             array('\_\\%\_\_\%', '_%__%'),
  34             array('\%\_', '%_'),
  35             array('\\\%\\\_', '\%\_')
  36         );
  37     }
  38
  39     /**
  40      * PMA_escape_mysql_wildcards tests
  41      * @dataProvider escapeDataProvider
  42      */
  43
  44     public function testEscape($a, $b)
  45     {
  46         $this->assertEquals($a, PMA_escape_mysql_wildcards($b));
  47     }
  48
  49     /**
  50      * PMA_unescape_mysql_wildcards tests
  51      * @dataProvider escapeDataProvider
  52      */
  53
  54     public function testUnEscape($a, $b)
  55     {
  56         $this->assertEquals($b, PMA_unescape_mysql_wildcards($a));
  57     }
  58 }
  59 ?>