Module: ActiveRecord::ConnectionAdapters::SchemaStatements

Defined in:
lib/trackless_triggers.rb

Instance Method Summary collapse

Instance Method Details

#add_function(sql) ⇒ Object 



103
104
105
 
# File 'lib/trackless_triggers.rb', line 103

def add_function(sql)
  execute sql
end

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



94
95
96
97
 
# File 'lib/trackless_triggers.rb', line 94

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_function(name) ⇒ Object 



107
108
109
 
# File 'lib/trackless_triggers.rb', line 107

def drop_function(name)
  execute("DROP FUNCTION #{name}")
end

#drop_trigger(name) ⇒ Object 



99
100
101
 
# File 'lib/trackless_triggers.rb', line 99

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