Method: XMLService::I_DB2#to_xml

Defined in:

lib/xmlservice.rb

#to_xml ⇒ Object

# File 'lib/xmlservice.rb', line 2430

def to_xml
  rows = ""
  error = " error='fast'"
  if @xml_options
    if @xml_options.has_key?(:error)
      error = " error='#{@xml_options[:error]}'"
    end
  end
  xml = "<sql>\n"
  xml << "<prepare #{error}>"
  xml << @xml_query.to_s
  xml << "</prepare>\n"
  if @xml_parms
    xml << "<execute #{error}>\n"
    if @xml_parms.is_a?(XMLService::I_Base)
      parms = @xml_parms.value
    else
      parms = @xml_parms
    end
    if parms.is_a?(Array)
      i = 0
      parms.each do |v|
        n = " var='parm#{i.to_s}'"
        xml << "<parm io='both' #{n}>#{v}</parm>\n"
        i += 1
      end
    elsif parms.is_a?(Hash)
      parms.each do |a,v|
        n = " var='#{a}'"
        xml << "<parm io='both' #{n}>#{v}</parm>\n"
      end
    else
      n = " var='parm0'"
      v = parms
      xml << "<parm io='both' #{n}>#{v}</parm>\n"
    end
    xml << "</execute>\n"
  else
    xml << "<execute #{error}/>\n"
  end
  xml << "<fetch block='all' desc='on' #{error}/>\n"
  xml << "</sql>\n"
  xml
end