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

jovoto-team/trackless_triggers

 
 

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

36 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

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.

Packages

No packages published

Languages

  • Ruby 100.0%