module PgSaurus::ConnectionAdapters::Table::TriggerMethods

Provides methods to extend ActiveRecord::ConnectionAdapters::Table to support database triggers.

Public Instance Methods

create_trigger(proc_name, event, options = {}) click to toggle source

Creates a trigger.

Example:

change_table :pets do |t|
  t.create_trigger :pets_not_empty_trigger_proc,
                   'AFTER INSERT',
                   for_each: 'ROW',
                   schema: 'public',
                   constraint: true,
                   deferrable: true,
                   initially_deferred: true
end
# File lib/pg_saurus/connection_adapters/table/trigger_methods.rb, line 18
def create_trigger(proc_name, event, options = {})
  @base.create_trigger(@name, proc_name, event, options)
end
remove_trigger(proc_name, options = {}) click to toggle source

Removes a trigger.

Example:

change_table :pets do |t|
  t.remove_trigger :pets_not_empty_trigger_proc
end
# File lib/pg_saurus/connection_adapters/table/trigger_methods.rb, line 29
def remove_trigger(proc_name, options = {})
  @base.remove_trigger(@name, proc_name, options)
end