removeDefaultResults(); $dummyDbi->addSelectDb('test_db'); $dummyDbi->addResult('SHOW TABLES FROM `test_db`;', [['test_table']], ['Tables_in_test_db']); $dummyDbi->addResult( 'SHOW TABLE STATUS FROM `test_db` WHERE `Name` IN (\'test_table\')', [['test_table', 'InnoDB', '10', 'Dynamic', '3', '10922', '32768', '0', '32768', '0', '7', '2023-05-29 14:53:55', '2023-05-29 14:53:55', null, 'utf8mb4_general_ci', null, '', '', '0', 'N']], ['Name', 'Engine', 'Version', 'Row_format', 'Rows', 'Avg_row_length', 'Data_length', 'Max_data_length', 'Index_length', 'Data_free', 'Auto_increment', 'Create_time', 'Update_time', 'Check_time', 'Collation', 'Checksum', 'Create_options', 'Comment', 'Max_index_length', 'Temporary'] ); $dummyDbi->addResult( 'SHOW TRIGGERS FROM `test_db`', [['test_trigger', 'INSERT', 'test_table', 'BEGIN END', 'AFTER', 'definer@localhost']], ['Trigger', 'Event', 'Table', 'Statement', 'Timing', 'Definer'] ); $dummyDbi->addResult('SELECT CURRENT_USER();', [['definer@localhost']], ['CURRENT_USER()']); $dummyDbi->addResult( "SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''definer''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'", [['TRIGGER']], ['PRIVILEGE_TYPE'] ); // phpcs:enable $dbi = DatabaseInterface::load($dummyDbi); $GLOBALS['dbi'] = $dbi; (new TriggersController(new ResponseRenderer(), new Template(), 'test_db', $dbi))(); $actual = $this->getActualOutputForAssertion(); // phpcs:disable Generic.Files.LineLength.TooLong $expected = <<<'HTML'

Triggers

Check all

Create new trigger

	Name	Table	Time	Event

	DROP TRIGGER IF EXISTS `test_trigger` test_trigger	test_table	AFTER	INSERT	Edit	Export	Drop

HTML; // phpcs:enable self::assertSame($expected, $actual); } public function testWithoutTriggers(): void { $GLOBALS['server'] = 2; $GLOBALS['text_dir'] = 'ltr'; $GLOBALS['PMA_PHP_SELF'] = 'index.php'; $GLOBALS['db'] = 'test_db'; $GLOBALS['cfg']['Server']['DisableIS'] = true; $dummyDbi = new DbiDummy(); // phpcs:disable Generic.Files.LineLength.TooLong $dummyDbi->removeDefaultResults(); $dummyDbi->addSelectDb('test_db'); $dummyDbi->addResult('SHOW TABLES FROM `test_db`;', [['test_table']], ['Tables_in_test_db']); $dummyDbi->addResult( 'SHOW TABLE STATUS FROM `test_db` WHERE `Name` IN (\'test_table\')', [['test_table', 'InnoDB', '10', 'Dynamic', '3', '10922', '32768', '0', '32768', '0', '7', '2023-05-29 14:53:55', '2023-05-29 14:53:55', null, 'utf8mb4_general_ci', null, '', '', '0', 'N']], ['Name', 'Engine', 'Version', 'Row_format', 'Rows', 'Avg_row_length', 'Data_length', 'Max_data_length', 'Index_length', 'Data_free', 'Auto_increment', 'Create_time', 'Update_time', 'Check_time', 'Collation', 'Checksum', 'Create_options', 'Comment', 'Max_index_length', 'Temporary'] ); $dummyDbi->addResult( 'SHOW TRIGGERS FROM `test_db`', [], ['Trigger', 'Event', 'Table', 'Statement', 'Timing', 'Definer'] ); $dummyDbi->addResult('SELECT CURRENT_USER();', [['definer@localhost']], ['CURRENT_USER()']); $dummyDbi->addResult( "SELECT `PRIVILEGE_TYPE` FROM `INFORMATION_SCHEMA`.`USER_PRIVILEGES` WHERE GRANTEE='''definer''@''localhost''' AND PRIVILEGE_TYPE='TRIGGER'", [['TRIGGER']], ['PRIVILEGE_TYPE'] ); // phpcs:enable $dbi = DatabaseInterface::load($dummyDbi); $GLOBALS['dbi'] = $dbi; (new TriggersController(new ResponseRenderer(), new Template(), 'test_db', $dbi))(); $actual = $this->getActualOutputForAssertion(); // phpcs:disable Generic.Files.LineLength.TooLong $expected = <<<'HTML'

Triggers

Create new trigger

There are no triggers to display.

HTML; // phpcs:enable self::assertSame($expected, $actual); } }