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)