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