lib/gratan/driver.rb in gratan-0.1.0 vs lib/gratan/driver.rb in gratan-0.1.1

- old
+ new

@@ -5,17 +5,17 @@ @client = client @options = options end def each_user - read('SELECT user, host FROM mysql.user').each do |row| + query('SELECT user, host FROM mysql.user').each do |row| yield(row['user'], row['host']) end end def show_grants(user, host) - read("SHOW GRANTS FOR #{quote_user(user, host)}").each do |row| + query("SHOW GRANTS FOR #{quote_user(user, host)}").each do |row| yield(row.values.first) end end def create_user(user, host, options = {}) @@ -123,12 +123,16 @@ unless options.empty? grant(user, host, object, :privs => ['USAGE'], :with => options.join(' ')) end end + def disable_log_bin_local + query('SET SQL_LOG_BIN = 0') + end + private - def read(sql) + def query(sql) log(:debug, sql) @client.query(sql) end def update(sql)