Contents

module Addresses
  class City < ActiveRecord::Base
    belongs_to :state

    has_many :neighborhoods

    def self.filter(params = {})
      query_word = 'like'

      query_word = 'ilike' if adapter == 'postgresql'

      cities = City.order('name asc')
      
      cities = cities.where("name #{query_word} ?", "%#{params[:name]}%") if params[:name]

      cities
    end

    private

    def self.adapter
      ActiveRecord::Base.connection.instance_values["config"][:adapter]
    rescue
      nil
    end
  end
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
addresses-1.0.9	app/models/addresses/city.rb
addresses-1.0.8	app/models/addresses/city.rb