module Sequel::Dataset::StoredProcedureMethods

Attributes

sproc_args[W]

The name of the stored procedure to call

sproc_name[RW]

The name of the stored procedure to call

Public Instance Methods

call(*args, &block) click to toggle source

Call the stored procedure with the given args

# File lib/sequel/adapters/utils/stored_procedures.rb, line 11
def call(*args, &block)
  sp = clone
  sp.sproc_args = args
  sp.run(&block)
end
inspect() click to toggle source

Programmer friendly string showing this is a stored procedure, showing the name of the procedure.

# File lib/sequel/adapters/utils/stored_procedures.rb, line 19
def inspect
  "<#{self.class.name}/StoredProcedure name=#{@sproc_name}>"
end
run(&block) click to toggle source

Run the stored procedure with the current args on the database

# File lib/sequel/adapters/utils/stored_procedures.rb, line 24
def run(&block)
  case @sproc_type
  when :select, :all
    all(&block)
  when :first
    first
  when :insert
    insert
  when :update
    update
  when :delete
    delete
  end
end
sproc_type=(type) click to toggle source

Set the type of the stored procedure and override the corresponding _sql method to return the empty string (since the result will be ignored anyway).

# File lib/sequel/adapters/utils/stored_procedures.rb, line 42
def sproc_type=(type)
  @sproc_type = type
  @opts[:sql] = ''
end