2007-03-01 @ 14:32
I’ve just released “Trigger Happy”, a rails plugin that adds support for triggers in your Active Record Migrations. To install the plugin just do this:
script/plugin install svn://rubyforge.org/var/svn/artriggers/trunk/trigger_happy
To add a trigger do this:
add_trigger "ai_people", :on => 'people', :timing => 'after', :event => 'insert', :statement => 'INSERT INTO log (id, timestamp) VALUES (NEW.id, NOW())'
To drop a trigger do this:
It only supports mysql for now, but I plan on having other database supported in the future.