feat: add --skip-ssl option for database:import command

carlalexander · carlalexander · commit 07d4c8004357 · 2024-06-28T14:46:59.000-04:00
diff --git a/src/Command/Database/ImportDatabaseCommand.php b/src/Command/Database/ImportDatabaseCommand.php
@@ -65,7 +65,8 @@ protected function configure()
             ->addOption('server', null, InputOption::VALUE_REQUIRED, 'The ID or name of the database server to import a database to')
             ->addOption('user', null, InputOption::VALUE_REQUIRED, 'The user used to connect to the database server')
             ->addOption('password', null, InputOption::VALUE_REQUIRED, 'The password of the user connecting to the database server')
-            ->addOption('force', 'f', InputOption::VALUE_NONE, 'Force the import even if there are SQL errors');
+            ->addOption('force', 'f', InputOption::VALUE_NONE, 'Force the import even if there are SQL errors')
+            ->addOption('skip-ssl', null, InputOption::VALUE_NONE, 'Disable SSL for the connection to the database server');
     }
 
     /**
@@ -100,7 +101,7 @@ protected function perform(Input $input, Output $output)
 
         $output->infoWithDelayWarning(sprintf('Importing "<comment>%s</comment>" to the "<comment>%s</comment>" database', $file, $name));
 
-        Mysql::import($file, $host, $port, $user, $password, $name, $input->getBooleanOption('force'));
+        Mysql::import($file, $host, $port, $user, $password, $name, $input->getBooleanOption('force'), $input->getBooleanOption('skip-ssl'));
 
         if ($tunnel instanceof Process) {
             $tunnel->stop();
diff --git a/src/Tool/Mysql.php b/src/Tool/Mysql.php
@@ -33,13 +33,23 @@ public static function export(string $filename, string $host, string $port, stri
     /**
      * Import a MySQL database.
      */
-    public static function import(string $filename, string $host, string $port, string $user, string $password, string $name, bool $force = false)
+    public static function import(string $filename, string $host, string $port, string $user, string $password, string $name, bool $force = false, bool $skipSsl = false)
     {
         if (!self::isMySqlInstalledGlobally()) {
             throw new CommandLineToolNotDetectedException('MySQL');
         }
 
-        self::runCommand(sprintf('%s %s | mysql %s --protocol=TCP --host=%s --port=%s --user=%s --password=%s %s', str_ends_with($filename, '.sql.gz') ? 'gunzip <' : 'cat', $filename, $force ? '--force' : '', $host, $port, $user, $password, $name));
+        $options = [];
+
+        if ($force) {
+            $options[] = '--force';
+        }
+
+        if ($skipSsl) {
+            $options[] = '--skip-ssl';
+        }
+
+        self::runCommand(sprintf('%s %s | mysql %s --protocol=TCP --host=%s --port=%s --user=%s --password=%s %s', str_ends_with($filename, '.sql.gz') ? 'gunzip <' : 'cat', $filename, implode(' ', $options), $host, $port, $user, $password, $name));
     }
 
     /**
