Add `DBShell::Client::MySQL`

For now only includes a `.build_command()` method.

Inspired again by:
https://github.com/django/django/blob/66150f7cf61bc09547fa98586790df596eff6d77/django/db/backends/mysql/client.py

although in our case we haven't handled some of the more exotic options.
Eventually we'll probably have to do that.

1 files changed, 23 insertions, 0 deletions

diff --git a/lib/dbshell/client/mysql.rb b/lib/dbshell/client/mysql.rb
new file mode 100644
index 0000000..6cb8233
--- /dev/null
+++ b/lib/dbshell/client/mysql.rb
@@ -0,0 +1,23 @@
+module DBShell
+  module Client
+    class MySQL
+      EXECUTABLE_NAME = 'mysql'
+
+      def self.build_command(db_info)
+        args = [EXECUTABLE_NAME]
+
+        host = db_info['host']
+        port = db_info['port']
+        db_name = db_info['database']
+        user = db_info['username']
+        password = db_info['password']
+
+        args.push("--user=#{user}") if user
+        args.push("--password=#{password}") if password
+        args.push("--host=#{host}") if host
+        args.push("--port=#{port}") if port
+        args.push(db_name)
+      end
+    end
+  end
+end