Module: Squirm::Rails::ActiveRecordSupport

Defined in:
lib/squirm/rails/active_record_support.rb

Overview

Support for working with procedures inside Active Record models. This exists primarily to ensure that stored procedure calls are done inside the same connection used by the AR model, to avoid transaction opacity issues that could arise if AR and Squirm are used different connections.

Instance Method Summary collapse

Instance Method Details

#procedure(name, options = {}, &block) ⇒ Object 



11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 
# File 'lib/squirm/rails/active_record_support.rb', line 11

def procedure(name, options = {}, &block)
  name = options[:as] || name

  self.class_eval(<<-EOM, __FILE__, __LINE__ + 1)
    @@__squirm ||= {}
    @@__squirm[:#{name}] = Squirm.procedure("#{name}")

    def self.#{name}(options = {})
      Squirm.use(connection.raw_connection) do
        @@__squirm[:#{name}].call(options)
      end
    end

    def #{name}(options = {})
      self.class.#{name}(@@__squirm[:#{name}].arguments.inject({}) do |hash, key|
        hash[key] ||= send(key) if respond_to?(key); hash
      end.merge(options))
    end
  EOM
end