Migration to change all MySQL table engines to InnoDB

bjhess (Barry Hess) — Mon, 01 Oct 2007 18:52:50 GMT

I have a database with an eclectic mix of table types/engines - almost random between MyISAM and InnoDB. I wanted to get transactional, so I wrote this migration to bring everything in line.



class ChangeTableTypes < ActiveRecord::Migration

  

  def self.up

    ActiveRecord::Migration::say 'Setting all tables to InnoDB engine (excluding schema_info table)...'

    result = ActiveRecord::Migration::execute 'show tables'

    while table = result.fetch_row

      execute("ALTER TABLE #{table.to_s} TYPE = InnoDB") unless table.to_s == 'schema_info'

    end

  end



  def self.down

    raise ActiveRecord::IrreversibleMigration

  end

end

Barry Hess

Rails auto select text field

bjhess (Barry Hess) — Thu, 20 Sep 2007 20:10:00 GMT

A simple helper to create those snazzy on-click-auto-select text fields you see on all the video-sharing sites.



def auto_select_text_field_tag(name, value = nil, options = {})

  text_field_tag(name,

                 value,

                 { :onclick => "$(’#{name}’).select()",

                   :readonly => "true" }.merge(options))

end

A _little_ more info on my blog.

~Barry Hess

DZone Snippets: ruby code

Migration to change all MySQL table engines to InnoDB

Rails auto select text field