From 9baf9235f24db0d71652da917fa26291ee36e139 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Maur=C3=ADcio=20Meneghini=20Fauth?= Date: Tue, 9 Aug 2022 23:22:18 -0300 Subject: Add basic test for Export::exportDatabase MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit Signed-off-by: Maurício Meneghini Fauth --- test/classes/ExportTest.php | 100 ++++++++++++++++++++++++++++++++++---------- 1 file changed, 77 insertions(+), 23 deletions(-) (limited to 'test') diff --git a/test/classes/ExportTest.php b/test/classes/ExportTest.php index 45ad69ef5b..cb2d0bbad6 100644 --- a/test/classes/ExportTest.php +++ b/test/classes/ExportTest.php @@ -7,6 +7,7 @@ namespace PhpMyAdmin\Tests; use PhpMyAdmin\ConfigStorage\Relation; use PhpMyAdmin\Export; use PhpMyAdmin\Plugins\Export\ExportPhparray; +use PhpMyAdmin\Plugins\Export\ExportSql; use PhpMyAdmin\Transformations; /** @@ -15,24 +16,10 @@ use PhpMyAdmin\Transformations; */ class ExportTest extends AbstractTestCase { - /** @var Export */ - private $export; - - /** - * Sets up the fixture - */ - protected function setUp(): void - { - parent::setUp(); - $GLOBALS['dbi'] = $this->createDatabaseInterface(); - $this->export = new Export($GLOBALS['dbi']); - } - - /** - * Test for mergeAliases - */ public function testMergeAliases(): void { + $GLOBALS['dbi'] = $this->createDatabaseInterface(); + $export = new Export($GLOBALS['dbi']); $aliases1 = [ 'test_db' => [ 'alias' => 'aliastest', @@ -91,31 +78,30 @@ class ExportTest extends AbstractTestCase ], ], ]; - $actual = $this->export->mergeAliases($aliases1, $aliases2); + $actual = $export->mergeAliases($aliases1, $aliases2); $this->assertEquals($expected, $actual); } - /** - * Test for getFinalFilenameAndMimetypeForFilename - */ public function testGetFinalFilenameAndMimetypeForFilename(): void { + $GLOBALS['dbi'] = $this->createDatabaseInterface(); + $export = new Export($GLOBALS['dbi']); $exportPlugin = new ExportPhparray( new Relation($GLOBALS['dbi']), new Export($GLOBALS['dbi']), new Transformations() ); - $finalFileName = $this->export->getFinalFilenameAndMimetypeForFilename($exportPlugin, 'zip', 'myfilename'); + $finalFileName = $export->getFinalFilenameAndMimetypeForFilename($exportPlugin, 'zip', 'myfilename'); $this->assertSame([ 'myfilename.php.zip', 'application/zip', ], $finalFileName); - $finalFileName = $this->export->getFinalFilenameAndMimetypeForFilename($exportPlugin, 'gzip', 'myfilename'); + $finalFileName = $export->getFinalFilenameAndMimetypeForFilename($exportPlugin, 'gzip', 'myfilename'); $this->assertSame([ 'myfilename.php.gz', 'application/x-gzip', ], $finalFileName); - $finalFileName = $this->export->getFinalFilenameAndMimetypeForFilename( + $finalFileName = $export->getFinalFilenameAndMimetypeForFilename( $exportPlugin, 'gzip', 'export.db1.table1.file' @@ -125,4 +111,72 @@ class ExportTest extends AbstractTestCase 'application/x-gzip', ], $finalFileName); } + + public function testExportDatabase(): void + { + $GLOBALS['sql_create_view'] = 'something'; + $GLOBALS['output_kanji_conversion'] = false; + $GLOBALS['buffer_needed'] = false; + $GLOBALS['asfile'] = false; + $GLOBALS['sql_structure_or_data'] = 'structure_and_data'; + $GLOBALS['cfg']['Server']['DisableIS'] = false; + $GLOBALS['sql_insert_syntax'] = 'both'; + $GLOBALS['sql_max_query_size'] = '50000'; + + // phpcs:disable Generic.Files.LineLength.TooLong + $dbiDummy = $this->createDbiDummy(); + $dbiDummy->addResult( + 'SELECT TABLE_NAME FROM information_schema.VIEWS WHERE TABLE_SCHEMA = \'test_db\' AND TABLE_NAME = \'test_table\'', + [], + ['TABLE_NAME'] + ); + $dbiDummy->addResult( + 'SELECT *, `TABLE_SCHEMA` AS `Db`, `TABLE_NAME` AS `Name`, `TABLE_TYPE` AS `TABLE_TYPE`, `ENGINE` AS `Engine`, `ENGINE` AS `Type`, `VERSION` AS `Version`, `ROW_FORMAT` AS `Row_format`, `TABLE_ROWS` AS `Rows`, `AVG_ROW_LENGTH` AS `Avg_row_length`, `DATA_LENGTH` AS `Data_length`, `MAX_DATA_LENGTH` AS `Max_data_length`, `INDEX_LENGTH` AS `Index_length`, `DATA_FREE` AS `Data_free`, `AUTO_INCREMENT` AS `Auto_increment`, `CREATE_TIME` AS `Create_time`, `UPDATE_TIME` AS `Update_time`, `CHECK_TIME` AS `Check_time`, `TABLE_COLLATION` AS `Collation`, `CHECKSUM` AS `Checksum`, `CREATE_OPTIONS` AS `Create_options`, `TABLE_COMMENT` AS `Comment` FROM `information_schema`.`TABLES` t WHERE `TABLE_SCHEMA` IN (\'test_db\') AND t.`TABLE_NAME` = \'test_table\' ORDER BY Name ASC', + [['def', 'test_db', 'test_table', 'BASE TABLE', 'InnoDB', '10', 'Dynamic', '3', '5461', '16384', '0', '0', '0', '4', '2011-12-13 14:15:16', null, null, 'utf8mb4_general_ci', null, '', '', '0', 'N', 'test_db', 'test_table', 'BASE TABLE', 'InnoDB', 'InnoDB', '10', 'Dynamic', '3', '5461', '16384', '0', '0', '0', '4', '2011-12-13 14:15:16', null, null, 'utf8mb4_general_ci', null, '', '']], + ['TABLE_CATALOG', 'TABLE_SCHEMA', 'TABLE_NAME', 'TABLE_TYPE', 'ENGINE', 'VERSION', 'ROW_FORMAT', 'TABLE_ROWS', 'AVG_ROW_LENGTH', 'DATA_LENGTH', 'MAX_DATA_LENGTH', 'INDEX_LENGTH', 'DATA_FREE', 'AUTO_INCREMENT', 'CREATE_TIME', 'UPDATE_TIME', 'CHECK_TIME', 'TABLE_COLLATION', 'CHECKSUM', 'CREATE_OPTIONS', 'TABLE_COMMENT', 'MAX_INDEX_LENGTH', 'TEMPORARY', 'Db', 'Name', 'TABLE_TYPE', 'Engine', 'Type', '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'] + ); + $dbiDummy->addResult( + 'SELECT `id`, `name`, `datetimefield` FROM `test_db`.`test_table`', + [ + ['1', 'abcd', '2011-01-20 02:00:02'], + ['2', 'foo', '2010-01-20 02:00:02'], + ['3', 'Abcd', '2012-01-20 02:00:02'], + ], + ['id', 'name', 'datetimefield'] + ); + // phpcs:enable + + $dbi = $this->createDatabaseInterface($dbiDummy); + $GLOBALS['dbi'] = $dbi; + $export = new Export($dbi); + + $export->exportDatabase( + 'test_db', + ['test_table'], + 'structure_and_data', + ['test_table'], + ['test_table'], + new ExportSql(new Relation($dbi), $export, new Transformations()), + "\n", + 'index.php?route=/database/export&db=test_db', + 'database', + false, + true, + false, + false, + [], + '' + ); + + $expected = <<assertSame($expected, $this->getActualOutputForAssertion()); + } } -- cgit v1.2.3