city.rb

class CityRlOp < ActiveRecord::Base
  @conn = use_connection_ninja(:rl_op)
  self.table_name = 'City'
  
  def self.get_all_city_names
    city_names = Rails.cache.read "geomapping_city_names"
    if city_names.nil?
      city_names = []
      select("distinct city_name").each do |name|
        city_names.push name
      end
      Rails.cache.write "geomapping_city_names", city_names
    end
    city_names
  end
  
  def self.city_name_exists?(name)
    records = where(city_name: name)
    if records.count > 0
      city_names = Rails.cache.read "geomapping_city_names"
      city_names.push name
      Rails.cache.write "geomapping_city_names", city_names
      true
    else
      false
    end
  end
end