UsageExamplesRubyGetObject

#!/usr/bin/env ruby
# This ruby example requires the ruby odbc library which can be found
# at http://www.ch-werner.de/rubyodbc/  Unfortunately, this isn't available
# as a gem as of yet.
#
# Call like: GetObject.rb -e -d debug.txt Property Photo LN000001

$VERBOSE = 1

require 'odbc'
require 'optparse'

DRIVER = "ezRETS ODBC Driver"
drv = ODBC::Driver.new
drv.name = DRIVER
drv.attrs["LoginUrl"] = 'http://demo.crt.realtors.org:6103/rets/login'
drv.attrs["UID"] = 'Joe'
drv.attrs["PWD"] = 'Schmoe'
drv.attrs["StandardNames"] = 'false'
if PLATFORM =~ /darwin/
  # iodbc actually takes the path to the driver, not the name as
  # registered in odbcinst.ini.  Right now, of our platforms, OS X
  # is the only one that uses iODBC by default.
  drv.attrs["DRIVER"] = '/usr/local/lib/ezrets.dylib'
else
  drv.attrs["DRIVER"] = DRIVER
end
puts drv.attrs["DRIVER"]

show_extra = false

usage = OptionParser.new do |opts|
  opts.banner = "Usage: GenericSearch.rb [options] <resource> <type> " +
                "<object_key>"
  opts.on('-b', '--bulk_metadata', 'Grab the metadata all at once') do |a|
    drv.attrs["UseBulkMetadata"] = "true"
  end
  opts.on('-dARG', '--debug_log ARG', 'Debug log to given file') do |a|
    drv.attrs["DebugLogFile"] = a
  end
  opts.on('-e', '--extra_info') { show_extra = true }
  opts.on('-HARG', '--http_log ARG', 'HTTP log to given file') do |a|
    drv.attrs["HttpLogFile"] = a
  end
  opts.on('-lARG', '--loginUrl ARG', 'Login URL') do |a|
    drv.attrs["LoginUrl"] = a
  end
  opts.on('-pARG', '--password ARG') { |a| drv.attrs["PWD"] = a }
  opts.on('-rARG', '--rets_version ARG') { |a| drv.attrs["RetsVersion"] = a }
  opts.on('-uARG', '--user ARG') { |a| drv.attrs["UID"] = a }
  opts.on('-UARG', '--user_agent ARG') { |a| drv.attrs["UserAgent"] = a }
  opts.on('-vARG', '--version ARG') { |a| drv.attrs["RetsVersion"] = a }
  opts.on('-h', '--help', 'Show this message') { puts opts ; exit }
  opts.parse!(ARGV)
end

if (ARGV.length < 3)
  puts usage
  exit 1
end

resource = ARGV[0]
type = ARGV[1]
object_key = ARGV[2]

if drv.attrs.has_key?('DebugLogFile')
  drv.attrs['UseDebugLogging'] = "true"
end

if drv.attrs.has_key?('HttpLogFile')
  drv.attrs['UseHttpLogging'] = "true"
end

extentions = {
  'image/jpeg' => 'jpg',
  'image/gif' => 'gif'
}

sql = "select * from object:binary:#{resource} where type='#{type}' and " +
      "object_key='#{object_key}'"

dbc = ODBC::Database.new
dbc.drvconnect(drv)
dbc.run(sql) do |stmt|
  print "Search result has #{stmt.nrows} rows\n\n"
  if show_extra
    stmt.columns(true).each do |col|
      puts "#{col.name}: #{col.type} #{col.length}"
    end
    puts
  end
  stmt.each_hash do |row|
    filename = row["object_key"] + '.' + row["object_id"].to_s + '.' +
               extentions[row["mime_type"]]
    File.open(filename, 'w') { |f| f << row["raw_data"] }
  end
end
dbc.disconnect