test/classes/Rte/TriggersTest.php

   1 <?php
   2 /* vim: set expandtab sw=4 ts=4 sts=4: */
   3 /**
   4  * Tests for PhpMyAdmin\Rte\Triggers
   5  *
   6  * @package PhpMyAdmin-test
   7  */
   8 declare(strict_types=1);
   9
  10 namespace PhpMyAdmin\Tests\Rte;
  11
  12 use PhpMyAdmin\Config;
  13 use PhpMyAdmin\Response;
  14 use PhpMyAdmin\Rte\Triggers;
  15 use PHPUnit\Framework\TestCase;
  16
  17 /**
  18  * This class is for testing PhpMyAdmin\Rte\Triggers methods
  19  *
  20  * @package PhpMyAdmin-test
  21  */
  22 class TriggersTest extends TestCase
  23 {
  24     /**
  25      * @var Triggers
  26      */
  27     private $triggers;
  28
  29     /**
  30      * Set up
  31      *
  32      * @return void
  33      */
  34     protected function setUp(): void
  35     {
  36         $GLOBALS['PMA_Config'] = new Config();
  37         $GLOBALS['PMA_Config']->enableBc();
  38         $GLOBALS['cfg']['Server']['DisableIS'] = false;
  39         $GLOBALS['db'] = 'pma_test';
  40         $GLOBALS['table'] = 'table';
  41         $GLOBALS['PMA_PHP_SELF'] = 'index.php';
  42
  43         $this->triggers = new Triggers($GLOBALS['dbi']);
  44     }
  45
  46     /**
  47      * Test for getDataFromRequest
  48      *
  49      * @param array $in  Input
  50      * @param array $out Expected output
  51      *
  52      * @return void
  53      *
  54      * @dataProvider providerGetDataFromRequestEmpty
  55      */
  56     public function testGetDataFromRequestEmpty($in, $out): void
  57     {
  58         unset($_POST);
  59         foreach ($in as $key => $value) {
  60             if ($value !== '') {
  61                 $_POST[$key] = $value;
  62             }
  63         }
  64         $this->assertEquals($out, $this->triggers->getDataFromRequest());
  65     }
  66
  67     /**
  68      * Data provider for testGetDataFromRequestEmpty
  69      *
  70      * @return array
  71      */
  72     public function providerGetDataFromRequestEmpty()
  73     {
  74         return [
  75             [
  76                 [
  77                     'item_name'               => '',
  78                     'item_table'              => '',
  79                     'item_original_name'      => '',
  80                     'item_action_timing'      => '',
  81                     'item_event_manipulation' => '',
  82                     'item_definition'         => '',
  83                     'item_definer'            => '',
  84                 ],
  85                 [
  86                     'item_name'               => '',
  87                     'item_table'              => '',
  88                     'item_original_name'      => '',
  89                     'item_action_timing'      => '',
  90                     'item_event_manipulation' => '',
  91                     'item_definition'         => '',
  92                     'item_definer'            => '',
  93                 ],
  94             ],
  95             [
  96                 [
  97                     'item_name'               => 'foo',
  98                     'item_table'              => 'foo',
  99                     'item_original_name'      => 'foo',
 100                     'item_action_timing'      => 'foo',
 101                     'item_event_manipulation' => 'foo',
 102                     'item_definition'         => 'foo',
 103                     'item_definer'            => 'foo',
 104                 ],
 105                 [
 106                     'item_name'               => 'foo',
 107                     'item_table'              => 'foo',
 108                     'item_original_name'      => 'foo',
 109                     'item_action_timing'      => 'foo',
 110                     'item_event_manipulation' => 'foo',
 111                     'item_definition'         => 'foo',
 112                     'item_definer'            => 'foo',
 113                 ],
 114             ],
 115         ];
 116     }
 117
 118     /**
 119      * Test for getEditorForm
 120      *
 121      * @param array $data    Data for trigger
 122      * @param array $matcher Matcher
 123      *
 124      * @return void
 125      *
 126      * @dataProvider providerGetEditorFormAdd
 127      * @group medium
 128      */
 129     public function testGetEditorFormAdd($data, $matcher): void
 130     {
 131         $GLOBALS['server'] = 1;
 132         $this->triggers->setGlobals();
 133         $this->assertStringContainsString(
 134             $matcher,
 135             $this->triggers->getEditorForm('add', $data)
 136         );
 137     }
 138
 139     /**
 140      * Provider for testGetEditorFormAdd
 141      *
 142      * @return array
 143      */
 144     public function providerGetEditorFormAdd()
 145     {
 146         $data = [
 147             'item_name'               => '',
 148             'item_table'              => 'table1',
 149             'item_original_name'      => '',
 150             'item_action_timing'      => '',
 151             'item_event_manipulation' => '',
 152             'item_definition'         => '',
 153             'item_definer'            => '',
 154         ];
 155
 156         return [
 157             [
 158                 $data,
 159                 "name='add_item'",
 160             ],
 161             [
 162                 $data,
 163                 "name='item_name'",
 164             ],
 165             [
 166                 $data,
 167                 "name='item_table'",
 168             ],
 169             [
 170                 $data,
 171                 "name='item_timing'",
 172             ],
 173             [
 174                 $data,
 175                 "name='item_event'",
 176             ],
 177             [
 178                 $data,
 179                 "name='item_definition'",
 180             ],
 181             [
 182                 $data,
 183                 "name='item_definer'",
 184             ],
 185             [
 186                 $data,
 187                 "name='editor_process_add'",
 188             ],
 189         ];
 190     }
 191
 192     /**
 193      * Test for getEditorForm
 194      *
 195      * @param array $data    Data for trigger
 196      * @param array $matcher Matcher
 197      *
 198      * @return void
 199      *
 200      * @dataProvider providerGetEditorFormEdit
 201      * @group medium
 202      */
 203     public function testGetEditorFormEdit($data, $matcher): void
 204     {
 205         $GLOBALS['server'] = 1;
 206         $this->triggers->setGlobals();
 207         $this->assertStringContainsString(
 208             $matcher,
 209             $this->triggers->getEditorForm('edit', $data)
 210         );
 211     }
 212
 213     /**
 214      * Provider for testGetEditorFormEdit
 215      *
 216      * @return array
 217      */
 218     public function providerGetEditorFormEdit()
 219     {
 220         $data = [
 221             'item_name'               => 'foo',
 222             'item_table'              => 'table1',
 223             'item_original_name'      => 'bar',
 224             'item_action_timing'      => 'BEFORE',
 225             'item_event_manipulation' => 'INSERT',
 226             'item_definition'         => 'SET @A=1;',
 227             'item_definer'            => '',
 228         ];
 229
 230         return [
 231             [
 232                 $data,
 233                 "name='edit_item'",
 234             ],
 235             [
 236                 $data,
 237                 "name='item_name'",
 238             ],
 239             [
 240                 $data,
 241                 "name='item_table'",
 242             ],
 243             [
 244                 $data,
 245                 "name='item_timing'",
 246             ],
 247             [
 248                 $data,
 249                 "name='item_event'",
 250             ],
 251             [
 252                 $data,
 253                 "name='item_definition'",
 254             ],
 255             [
 256                 $data,
 257                 "name='item_definer'",
 258             ],
 259             [
 260                 $data,
 261                 "name='editor_process_edit'",
 262             ],
 263         ];
 264     }
 265
 266     /**
 267      * Test for getEditorForm
 268      *
 269      * @param array $data    Data for trigger
 270      * @param array $matcher Matcher
 271      *
 272      * @return void
 273      *
 274      * @dataProvider providerGetEditorFormAjax
 275      */
 276     public function testGetEditorFormAjax($data, $matcher): void
 277     {
 278         $GLOBALS['server'] = 1;
 279         Response::getInstance()->setAjax(true);
 280         $this->triggers->setGlobals();
 281         $this->assertStringContainsString(
 282             $matcher,
 283             $this->triggers->getEditorForm('edit', $data)
 284         );
 285         Response::getInstance()->setAjax(false);
 286     }
 287
 288     /**
 289      * Provider for testGetEditorFormAjax
 290      *
 291      * @return array
 292      */
 293     public function providerGetEditorFormAjax()
 294     {
 295         $data = [
 296             'item_name'               => 'foo',
 297             'item_table'              => 'table1',
 298             'item_original_name'      => 'bar',
 299             'item_action_timing'      => 'BEFORE',
 300             'item_event_manipulation' => 'INSERT',
 301             'item_definition'         => 'SET @A=1;',
 302             'item_definer'            => '',
 303         ];
 304
 305         return [
 306             [
 307                 $data,
 308                 "name='editor_process_edit'",
 309             ],
 310             [
 311                 $data,
 312                 "name='ajax_request'",
 313             ],
 314         ];
 315     }
 316
 317     /**
 318      * Test for getQueryFromRequest
 319      *
 320      * @param string $definer    Definer
 321      * @param string $name       Name
 322      * @param string $timing     Timing
 323      * @param string $event      Event
 324      * @param string $table      Table
 325      * @param string $definition Definition
 326      * @param string $query      Query
 327      * @param string $num_err    Error number
 328      *
 329      * @return void
 330      *
 331      * @dataProvider providerGetQueryFromRequest
 332      */
 333     public function testGetQueryFromRequest(
 334         $definer,
 335         $name,
 336         $timing,
 337         $event,
 338         $table,
 339         $definition,
 340         $query,
 341         $num_err
 342     ) {
 343         global $errors;
 344
 345         $errors = [];
 346         $this->triggers->setGlobals();
 347
 348         $_POST['item_definer']    = $definer;
 349         $_POST['item_name']       = $name;
 350         $_POST['item_timing']     = $timing;
 351         $_POST['item_event']      = $event;
 352         $_POST['item_table']      = $table;
 353         $_POST['item_definition'] = $definition;
 354         $GLOBALS['server'] = 1;
 355
 356         $this->assertEquals($query, $this->triggers->getQueryFromRequest());
 357         $this->assertCount($num_err, $errors);
 358     }
 359
 360     /**
 361      * Data provider for testGetQueryFromRequest
 362      *
 363      * @return array
 364      */
 365     public function providerGetQueryFromRequest()
 366     {
 367         return [
 368             [
 369                 '',
 370                 '',
 371                 '',
 372                 '',
 373                 '',
 374                 '',
 375                 'CREATE TRIGGER ON  FOR EACH ROW ',
 376                 5,
 377             ],
 378             [
 379                 'root',
 380                 'trigger',
 381                 'BEFORE',
 382                 'INSERT',
 383                 'table`2',
 384                 'SET @A=NULL',
 385                 'CREATE TRIGGER `trigger` BEFORE INSERT ON  FOR EACH ROW SET @A=NULL',
 386                 2,
 387             ],
 388             [
 389                 'foo`s@host',
 390                 'trigger`s test',
 391                 'AFTER',
 392                 'foo',
 393                 'table3',
 394                 'BEGIN SET @A=1; SET @B=2; END',
 395                 'CREATE DEFINER=`foo``s`@`host` TRIGGER `trigger``s test` AFTER ON  FOR EACH ROW BEGIN SET @A=1; SET @B=2; END',
 396                 2,
 397             ],
 398             [
 399                 'root@localhost',
 400                 'trigger',
 401                 'BEFORE',
 402                 'INSERT',
 403                 'table1',
 404                 'SET @A=NULL',
 405                 'CREATE DEFINER=`root`@`localhost` TRIGGER `trigger` BEFORE INSERT ON `table1` FOR EACH ROW SET @A=NULL',
 406                 0,
 407             ],
 408         ];
 409     }
 410 }