Enform.GetID.rb

require 'soap/wsdlDriver'
require 'rubygems'
require 'mysql'

con = Mysql::connect("HOST", "USER", "PASSWORD", "DATABASE")
wsdl = 'http://enform.ca/externalCompletion/Service.svc?wsdl'
driver = SOAP::WSDLDriverFactory.new(wsdl).create_rpc_driver
key = "XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX"
sql = "select firstname,
              lastname,
              data,
              u.id
         from mdl_user_info_field uif
         join mdl_user_info_data uid
                on uid.fieldid = uif.id
         join mdl_user u
                on u.id=uid.userid
         where uif.shortname = 'postalzip'
           and idnumber is null
"
res = con.query(sql)
res.each do |row|
 firstName = row[0]
 lastName = row[1]
 postalCode = row[2]
 id = row[3]

 response = driver.GetEnformID(:key=>key,
                               :firstName=>firstName,
                               :lastName=>lastName,
                               :postalCode=>postalCode)
 driver.reset_stream
 enformID = response.getEnformIDResult
 sql = "update mdl_user set idnumber=#{enformID} where id=#{id}"
 con.query(sql)
end