module PgSaurus::ConnectionAdapters::AbstractAdapter::TriggerMethods
Adapter definitions for db functions
Public Instance Methods
create_trigger(table_name, proc_name, event, options = {})
click to toggle source
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.
# 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 = {})
click to toggle source
Removes a trigger.
Example:
remove_trigger :pets, :pets_not_empty_trigger_proc
# File lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb, line 38 def remove_trigger(table_name, proc_name, options = {}) end
supports_triggers?()
click to toggle source
:nodoc
# File lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb, line 5 def supports_triggers? false end
triggers()
click to toggle source
Returns the listing of currently defined db triggers
# File lib/pg_saurus/connection_adapters/abstract_adapter/trigger_methods.rb, line 10 def triggers end