Module: PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods

Included in:
PgSaurus::ConnectionAdapters::AbstractAdapter
Defined in:
lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb

Overview

Adapter definitions for db functions

Instance Method Summary collapse

Instance Method Details

#create_trigger(table_name, proc_name, event, options = {}) ⇒ Object

Creates a trigger.

Example:

create_trigger :pets,                           # Table or view name
               :pets_not_empty_trigger_proc,    # Procedure name. Parentheses are optional if you have no arguments.
               'AFTER INSERT',                  # Trigger event
               for_each: 'ROW',                 # Can be row or statement. Default is row.
               schema: 'public',                # Optional schema name
               constraint: true,                # Sets if the trigger is a constraint. Default is false.
               deferrable: true,                # Sets if the trigger is immediate or deferrable. Default is immediate.
               initially_deferred: true,        # Sets if the trigger is initially deferred. Default is immediate. Only relevant if the trigger is deferrable.
               condition: "new.name = 'fluffy'" # Optional when condition. Default is none.



28
29
30
 
# File 'lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb', line 28

def create_trigger(table_name, proc_name, event, options = {})

end

#remove_trigger(table_name, proc_name, options = {}) ⇒ Object

Removes a trigger.

Example:

remove_trigger :pets, :pets_not_empty_trigger_proc



38
39
40
 
# File 'lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb', line 38

def remove_trigger(table_name, proc_name, options = {})

end

#supports_triggers? ⇒ Boolean

:nodoc

Returns:

  • (Boolean) 


5
6
7
 
# File 'lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb', line 5

def supports_triggers?
  false
end

#triggers ⇒ Object

Returns the listing of currently defined db triggers



10
11
12
 
# File 'lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb', line 10

def triggers

end