class Lookup

Public Class Methods

new(db) click to toggle source
# File lib/jungle_path/app/ztools/zport_data.rb, line 206
def initialize(db)
  @target_db = db
  @current_user = nil
  @current_key = nil
  @lookups = {}
end

Public Instance Methods

value(table, value, search_column, target_column) click to toggle source
# File lib/jungle_path/app/ztools/zport_data.rb, line 213
def value table, value, search_column, target_column
  key = "#{table}.#{search_column}"
  @lookups[key] = load_lookup(table, search_column, target_column) unless @lookups[key]
  @lookups[key][value]
end

Private Instance Methods

load_lookup(table, search_column, target_column) click to toggle source
# File lib/jungle_path/app/ztools/zport_data.rb, line 220
def load_lookup table, search_column, target_column
  lookup = {}
  lookup[nil] = nil
  lookup['No Match Row Id'] = nil
  sql = SQLHelpers.sql("select #{search_column}, #{target_column} from #{table}")
  ds = @target_db.base[sql]
  results = ds.all
  results.each do |item|
    lookup[item[search_column]] = item[target_column]
  end
  lookup
end