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