GitHub - jovoto-team/trackless_triggers: A fork of Trigger Happy that packages it as a gem

This repository has been archived by the owner on Dec 16, 2020. It is now read-only.

Name		Name	Last commit message	Last commit date
Latest commit History 36 Commits
lib		lib
.gitignore		.gitignore
CHANGELOG		CHANGELOG
MIT-LICENSE		MIT-LICENSE
README		README
Rakefile		Rakefile
VERSION		VERSION
init.rb		init.rb
trackless_triggers.gemspec		trackless_triggers.gemspec

Repository files navigation

= Trackless Triggers

Add triggers and functions to your active record migrations. Based on Trigger Happy (http://tenderlovemaking.com/2007/03/01/trigger-happy.html)

== INSTALL

Add this to your Gemfile:

gem 'trackless_triggers'

== EXAMPLE

Add a trigger:

  add_trigger "ai_people",
    :on         => 'people',
    :timing     => 'after',
    :event      => 'insert',
    :statement  => 'INSERT INTO log (id, timestamp) VALUES (NEW.id, NOW())'

Update an existing trigger (drops then adds):

  update_trigger "ai_people",
    :on         => 'people',
    :timing     => 'after',
    :event      => 'insert',
    :statement  => 'INSERT INTO log (id, timestamp) VALUES (NEW.id, NOW())'

Remove a trigger:

  drop_trigger 'ai_people'

== LIMITATIONS

Only works with mysql for now.