Class: SQLResolver

Inherits:

Object

• Object
• SQLResolver

Defined in:

lib/etl/transform/foreign_key_lookup_transform.rb

Instance Method Summary

• #initialize(table, field, connection = nil) ⇒ SQLResolver constructor

  A new instance of SQLResolver.

• #resolve(value) ⇒ Object

Constructor Details

#initialize(table, field, connection = nil) ⇒ SQLResolver

Returns a new instance of SQLResolver.

# File 'lib/etl/transform/foreign_key_lookup_transform.rb', line 67

def initialize(table, field, connection=nil)
  @table = table
  @field = field
  @connection = connection
end

Instance Method Details

#resolve(value) ⇒ Object

# File 'lib/etl/transform/foreign_key_lookup_transform.rb', line 72

def resolve(value)
  conn = @connection ||= ActiveRecord::Base.connection
  conn.select_value("SELECT id FROM #{table} WHERE #{field} = #{conn.quote(value)}")
end