niko / em_mysql2_connection_pool Goto Github PK

As per the Readme you can call query with a proc block

MySQL.query proc{ |conn|
escaped_name = conn.escape some_string
"SELECT * FROM my_table WHERE name is '#{escaped_name}'"
}

However with the gem it complains that sql is not a string. In the gist you based the gem from you have

sql = query[:sql].is_a?(Proc) ? query[:sql].call(connection) : query[:sql]

Is there a way to call the gem to emulate the query with a proc or can this be added?

Thanks

What would be the license for this Gem?
Thank you!

the code passes blocks as parameters everywhere, instead please consider yielding because it is faster (please refer to e.g. http://mudge.name/2011/01/26/passing-blocks-in-ruby-without-block.html). If it is necessary to pass the block down to another method then you can use this approach (from the comments in the above link):

class Monkey
  def self.tell_ape
    tell("ape") {yield}
  end

  def self.tell(name)
    puts "#{name}: #{yield}"
  end
end

Monkey.tell_ape { "ook!" }

It would be great if we could directly use MYSQL.escape string