Add basic test for Export::exportServer

Signed-off-by: Maurício Meneghini Fauth <mauricio@fauth.dev>

1 files changed, 79 insertions, 0 deletions

diff --git a/test/classes/ExportTest.php b/test/classes/ExportTest.php
index cb2d0bbad6..3e48c040ba 100644
--- a/test/classes/ExportTest.php
+++ b/test/classes/ExportTest.php
@@ -9,6 +9,7 @@ use PhpMyAdmin\Export;
 use PhpMyAdmin\Plugins\Export\ExportPhparray;
 use PhpMyAdmin\Plugins\Export\ExportSql;
 use PhpMyAdmin\Transformations;
+use stdClass;
 
 /**
  * @covers \PhpMyAdmin\Export
@@ -114,6 +115,7 @@ class ExportTest extends AbstractTestCase
 
     public function testExportDatabase(): void
     {
+        $GLOBALS['plugin_param'] = ['export_type' => 'database', 'single_table' => false];
         $GLOBALS['sql_create_view'] = 'something';
         $GLOBALS['output_kanji_conversion'] = false;
         $GLOBALS['buffer_needed'] = false;
@@ -179,4 +181,81 @@ SQL;
 
         $this->assertSame($expected, $this->getActualOutputForAssertion());
     }
+
+    public function testExportServer(): void
+    {
+        $GLOBALS['plugin_param'] = ['export_type' => 'server', 'single_table' => false];
+        $GLOBALS['dblist'] = new stdClass();
+        $GLOBALS['dblist']->databases = ['test_db'];
+        $GLOBALS['output_kanji_conversion'] = false;
+        $GLOBALS['buffer_needed'] = false;
+        $GLOBALS['asfile'] = false;
+        $GLOBALS['cfg']['Server']['DisableIS'] = false;
+        $GLOBALS['sql_structure_or_data'] = 'structure_and_data';
+        $GLOBALS['sql_insert_syntax'] = 'both';
+        $GLOBALS['sql_max_query_size'] = '50000';
+
+        // phpcs:disable Generic.Files.LineLength.TooLong
+        $dbiDummy = $this->createDbiDummy();
+        $dbiDummy->addResult(
+            'SHOW TABLES FROM `test_db`;',
+            [['test_table']],
+            ['Tables_in_test_db']
+        );
+        $dbiDummy->addResult(
+            'SELECT DEFAULT_COLLATION_NAME FROM information_schema.SCHEMATA WHERE SCHEMA_NAME = \'test_db\' LIMIT 1',
+            [['utf8mb4_general_ci']],
+            ['DEFAULT_COLLATION_NAME']
+        );
+        $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->exportServer(
+            ['test_db'],
+            'structure_and_data',
+            new ExportSql(new Relation($dbi), $export, new Transformations()),
+            "\n",
+            'index.php?route=/server/export',
+            'server',
+            false,
+            true,
+            false,
+            false,
+            [],
+            ''
+        );
+
+        $expected = <<<SQL
+CREATE DATABASE IF NOT EXISTS test_db DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;USE test_db;
+INSERT INTO test_table (id, name, datetimefield) VALUES
+('1', 'abcd', '2011-01-20 02:00:02'),
+('2', 'foo', '2010-01-20 02:00:02'),
+('3', 'Abcd', '2012-01-20 02:00:02');
+
+SQL;
+
+        $this->assertSame($expected, $this->getActualOutputForAssertion());
+    }
 }