Module: ActiveRecord::ConnectionAdapters::SchemaStatements

Defined in:
lib/trackless_triggers.rb

Instance Method Summary collapse

Instance Method Details

#add_trigger(name, opts = {}) ⇒ Object 



42
43
44
45
 
# File 'lib/trackless_triggers.rb', line 42

def add_trigger(name, opts = {})
  sql = "CREATE TRIGGER #{name} #{opts[:timing]} #{opts[:event]} ON #{opts[:on]} FOR EACH ROW #{opts[:statement]}"
  execute sql
end

#drop_trigger(name) ⇒ Object 



47
48
49
 
# File 'lib/trackless_triggers.rb', line 47

def drop_trigger(name)
  execute("DROP TRIGGER #{name}")
end