class Mkxms::Mssql::StoredProcedure

Constants

SQL_OBJECT_TYPE

Attributes

definition[R]
name[RW]
param_properties[R]
schema[RW]

Public Class Methods

new(attrs) click to toggle source
# File lib/mkxms/mssql/stored_procedure_handler.rb, line 12
def initialize(attrs)
  @schema = attrs['schema']
  @name = attrs['name']
  @definition = ''
  @param_properties = Hash.new {|h, k| h[k] = ''}
end

Public Instance Methods

param_properties_sql() click to toggle source
# File lib/mkxms/mssql/stored_procedure_handler.rb, line 27
def param_properties_sql
  @param_properties.each_pair.map do |k, v|
    Property.addition_sql(k[1], v, property_subject_identifiers + ['PARAMETER', Utils.unquoted_name(k[0])])
  end
end
to_sql() click to toggle source
# File lib/mkxms/mssql/stored_procedure_handler.rb, line 22
def to_sql
  mvdef = AccessObjectDefinition.replace_object_name(definition, "[{filename}]")
  ([mvdef] + extended_properties_sql + param_properties_sql).join("\n")
end