test/classes/Database/SearchTest.php

   1 <?php
   2
   3 declare(strict_types=1);
   4
   5 namespace PhpMyAdmin\Tests\Database;
   6
   7 use PhpMyAdmin\Database\Search;
   8 use PhpMyAdmin\DatabaseInterface;
   9 use PhpMyAdmin\Template;
  10 use PhpMyAdmin\Tests\AbstractTestCase;
  11
  12 /**
  13  * Tests for database search.
  14  */
  15 class SearchTest extends AbstractTestCase
  16 {
  17     /** @var Search */
  18     protected $object;
  19
  20     /**
  21      * Sets up the fixture, for example, opens a network connection.
  22      * This method is called before a test is executed.
  23      *
  24      * @access protected
  25      */
  26     protected function setUp(): void
  27     {
  28         parent::setUp();
  29         parent::loadDefaultConfig();
  30
  31         $GLOBALS['server'] = 0;
  32         $GLOBALS['db'] = 'pma';
  33         $GLOBALS['_POST'] = [];
  34
  35         //mock DBI
  36         $dbi = $this->getMockBuilder(DatabaseInterface::class)
  37             ->disableOriginalConstructor()
  38             ->getMock();
  39
  40         $dbi->expects($this->any())
  41             ->method('getColumns')
  42             ->with('pma', 'table1')
  43             ->will($this->returnValue([
  44                 ['Field' => 'column1'],
  45                 ['Field' => 'column2'],
  46             ]));
  47
  48         $dbi->expects($this->any())
  49             ->method('escapeString')
  50             ->will($this->returnArgument(0));
  51
  52         $GLOBALS['dbi'] = $dbi;
  53         $this->object = new Search($dbi, 'pma_test', new Template());
  54     }
  55
  56     /**
  57      * Tears down the fixture, for example, closes a network connection.
  58      * This method is called after a test is executed.
  59      *
  60      * @access protected
  61      */
  62     protected function tearDown(): void
  63     {
  64         parent::tearDown();
  65         unset($this->object);
  66     }
  67
  68     /**
  69      * Test for generating where clause for different search types
  70      *
  71      * @param string $type     type
  72      * @param string $expected expected result
  73      *
  74      * @dataProvider searchTypes
  75      */
  76     public function testGetWhereClause(string $type, string $expected): void
  77     {
  78         $_POST['criteriaSearchType'] = $type;
  79         $_POST['criteriaSearchString'] = 'search string';
  80
  81         $this->object = new Search($GLOBALS['dbi'], 'pma_test', new Template());
  82         $this->assertEquals(
  83             $expected,
  84             $this->callFunction(
  85                 $this->object,
  86                 Search::class,
  87                 'getWhereClause',
  88                 ['table1']
  89             )
  90         );
  91     }
  92
  93     /**
  94      * Data provider for testGetWhereClause
  95      *
  96      * @return array
  97      */
  98     public function searchTypes(): array
  99     {
 100         return [
 101             [
 102                 '1',
 103                 " WHERE (CONVERT(`column1` USING utf8) LIKE '%search%'"
 104                 . " OR CONVERT(`column2` USING utf8) LIKE '%search%') "
 105                 . " OR  (CONVERT(`column1` USING utf8) LIKE '%string%'"
 106                 . " OR CONVERT(`column2` USING utf8) LIKE '%string%')",
 107             ],
 108             [
 109                 '2',
 110                 " WHERE (CONVERT(`column1` USING utf8) LIKE '%search%'"
 111                 . " OR CONVERT(`column2` USING utf8) LIKE '%search%') "
 112                 . " AND  (CONVERT(`column1` USING utf8) LIKE '%string%'"
 113                 . " OR CONVERT(`column2` USING utf8) LIKE '%string%')",
 114             ],
 115             [
 116                 '3',
 117                 " WHERE (CONVERT(`column1` USING utf8) LIKE '%search string%'"
 118                 . " OR CONVERT(`column2` USING utf8) LIKE '%search string%')",
 119             ],
 120             [
 121                 '4',
 122                 " WHERE (CONVERT(`column1` USING utf8) LIKE 'search string'"
 123                 . " OR CONVERT(`column2` USING utf8) LIKE 'search string')",
 124             ],
 125             [
 126                 '5',
 127                 " WHERE (CONVERT(`column1` USING utf8) REGEXP 'search string'"
 128                 . " OR CONVERT(`column2` USING utf8) REGEXP 'search string')",
 129             ],
 130         ];
 131     }
 132
 133     /**
 134      * Test for getSearchSqls
 135      */
 136     public function testGetSearchSqls(): void
 137     {
 138         $this->assertEquals(
 139             [
 140                 'select_columns' => 'SELECT *  FROM `pma`.`table1` WHERE FALSE',
 141                 'select_count' => 'SELECT COUNT(*) AS `count` FROM `pma`.`table1` ' .
 142                     'WHERE FALSE',
 143                 'delete' => 'DELETE FROM `pma`.`table1` WHERE FALSE',
 144             ],
 145             $this->callFunction(
 146                 $this->object,
 147                 Search::class,
 148                 'getSearchSqls',
 149                 ['table1']
 150             )
 151         );
 152     }
 153
 154     /**
 155      * Test for getSearchResults
 156      */
 157     public function testGetSearchResults(): void
 158     {
 159         $this->assertStringContainsString(
 160             'Search results for "<em></em>" :',
 161             $this->object->getSearchResults()
 162         );
 163     }
 164
 165     /**
 166      * Test for getSelectionForm
 167      */
 168     public function testGetMainHtml(): void
 169     {
 170         $main = $this->object->getMainHtml();
 171
 172         // test selection form
 173         $this->assertStringContainsString('<form', $main);
 174         $this->assertStringContainsString('<a id="togglesearchformlink">', $main);
 175         $this->assertStringContainsString('criteriaSearchType', $main);
 176
 177         // test result divs
 178         $this->assertStringContainsString(
 179             '<div id="table-info"',
 180             $main
 181         );
 182         $this->assertStringContainsString(
 183             '<a id="table-link"',
 184             $main
 185         );
 186         $this->assertStringContainsString(
 187             '<div id="browse-results"',
 188             $main
 189         );
 190         $this->assertStringContainsString(
 191             '<div id="sqlqueryform"',
 192             $main
 193         );
 194         $this->assertStringContainsString(
 195             '<button class="btn btn-secondary" id="togglequerybox"',
 196             $main
 197         );
 198     }
 199 }