Never been to DZone Snippets before?

Snippets is a public source code repository. Easily build up your personal collection of code snippets, categorize them with tags / keywords, and share them with the world

About this user

Barry Hess http://blog.bjhess.com

« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS 

Migration to change all MySQL table engines to InnoDB

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
to ruby rails by bjhess on Oct 01, 2007 2 Comments

Rails auto select text field

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
to ruby rails on by bjhess on Sep 20, 2007
« Newer Snippets
Older Snippets »
Showing 1-2 of 2 total  RSS