class DanarchyDeploy::Services::MySQL::Privileges
Public Class Methods
new(mysql, options)
click to toggle source
# File lib/danarchy_deploy/services/mysql/privileges.rb, line 8 def self.new(mysql, options) sql_grants = sql_template(mysql, options) run_sql_grants(mysql, sql_grants, options) end
run_sql_grants(mysql, sql_grants, options)
click to toggle source
# File lib/danarchy_deploy/services/mysql/privileges.rb, line 25 def self.run_sql_grants(mysql, sql_grants, options) # Using CLI commands for now; # mysql2 requires mysql client be installed even if we won't be using it. # client = Mysql2::Client.new(:default_file => default_file) cmd = "mysql --defaults-file=#{mysql[:default_file]} -v < #{sql_grants}" DanarchyDeploy::Helpers.run_command(cmd, options) end
sql_template(mysql, options)
click to toggle source
# File lib/danarchy_deploy/services/mysql/privileges.rb, line 13 def self.sql_template(mysql, options) sql_grants = '/root/.user_grants.sql' source = options[:deploy_dir] + '/templates/services/mysql/user_db_grants.sql.erb' templates = [{ target: sql_grants, source: source, variables: mysql[:privileges] }] DanarchyDeploy::Templater.new(templates, options) sql_grants end