Class: Mimas::Plugins::PostgreSQL::Commands::CreateRole

Inherits:

CLI::Commands::BaseCommand

• Object
• CLI::Commands::BaseCommand
• Mimas::Plugins::PostgreSQL::Commands::CreateRole

Defined in:

lib/mimas/plugins/postgresql/commands/create_role.rb

Instance Method Summary

• #call(server_name:, role_name:, **options) ⇒ Object

Instance Method Details

#call(server_name:, role_name:, **options) ⇒ Object

# File 'lib/mimas/plugins/postgresql/commands/create_role.rb', line 14

def call(server_name:, role_name:, **options)
  server = Config.current.servers[server_name.to_sym]
  sudo_user = options[:user]

  password = options[:password] || SecureRandom.alphanumeric(64)
  ssh(server, user: sudo_user) do |session|
    session.run "sudo -u postgres psql -c \"CREATE ROLE #{role_name} WITH LOGIN PASSWORD \'#{password}\';\"", capture: true
  end

  say ""
  say "Created a new role #{role_name.dup.bold.magenta} with password: #{password.bold.white}"
  say "Ensure you save this password as it cannot be displayed again."
end