zip2tax basic connection example in ruby

zip2tax_basic.rb

require "rubygems"
require "mysql"

#connection parameters
server = "db.Zip2Tax.com"
db_username = "z2t_link"
db_password = "H^2p6~r"
database = "zip2tax"

#query parameters
extended_lookup = false   # set to true for extended lookup, false for basic lookup
zipcode = "90210"
user_name = "sample"
user_password = "password"

####
extended_procedure = extended_lookup ? "_extended" : ""
query_string = "CALL zip2tax.z2t_lookup#{extended_procedure}('#{zipcode}','#{user_name}','#{user_password}')"

begin
  #open the connection and fetch results
  db_connection = Mysql.real_connect( server, db_username, db_password, database, 3306, nil, Mysql::CLIENT_MULTI_RESULTS)
  results_hash =  db_connection.query(query_string).fetch_hash
rescue Mysql::Error => e
  abort "Error code: #{e.errno}\nError message: #{e.error}"
ensure
  #close the connection
  db_connection.close if db_connection
end

#print out all values
results_hash.each_pair {|key, value| printf "%32s: %s\n", key, value }

#print out a specific value
puts "Sales Tax Rate: " + results_hash["Sales_Tax_Rate"]