Models using different database about search_cop HOT 7 CLOSED

I don't fully understand. You use multiple db's? If yes, how do you want search cop to work in this scenario?

from search_cop.

Well hopefully join using the database/table that the associated model uses. Is this doable with this or have I surpassed the scope of this gem.

from search_cop.

I still don't fully understand what you try to achive. Can you provide more details? Schema, Model, what lives in which db? Thanks

from search_cop.

class SharedModels < ActiveRecord::Base
  self.abstract_class = true
  establish_connection "master_#{Rails.env}"
end         

class Site < SharedModels
  has_many :nodes
end

class Node < ActiveRecord::Base
  belongs_to :site

  search_scope :search do 
    attributes :name, :description, site: ["site.site_code", "site.name"]
  end
end

Node is in application database, Site is in master database. Im performing the search on node.

from search_cop.

Ah, ok, thanks. However, cross db join's are not possible SQL wise. As SearchCop operates on the SQL level, this won't work, sorry.

from search_cop.

great thanks for your help, any tips on implementing this?

from search_cop.

Search both models individually

@nodes = Node.search(params[:q_nodes])
@sites = Site.search(params[:q_sites])...

and "merge" the results application wise or add a single data source and index/denormalize your data there to search for both at the same time (ElasticSearch, Solr, Sphinx).

from search_cop.