How do you talk SQL directly to MySQL from Ruby?

Question

I want to write a script in Ruby to clean up some messed up keys in several copies of the same MySQL schema. I'd like to do something like SHOW CREATE TABLE, then look at what comes back and delete keys if they exist.

I know in the Rails environment you can do this...

ActiveRecord::Base.connection.execute( some sql )

But what you get back is a "Result" object. For this task I need a String so I can analyze it and act accordingly.

Answer 1

This should help you:

>> result = ActiveRecord::Base.connection.execute("SHOW TABLES")
=> #<Mysql::Result:0x37ecb30>

>> result.class.instance_methods - Object.instance_methods
=> ["all_hashes", "field_seek", "row_tell", "fetch_field_direct", "free", "field_tell", "fetch_lengths", "num_fields", "data_seek", "fetch_row", "num_rows", "fetch_field", "each", "each_hash", "fetch_hash", "row_seek", "fetch_fields"]

Look at #all_hashes on the MySql::Result instance