思考Sphinx并搜索多个模型-ThinkingSphinxandsearchingmultiplemodels

I'm looking for a way to perform a search against multiple models (see this post), and got a couple of answers saying that Thinking Sphinx would be a good match for this kind of thing.

我正在寻找一种方法来对多个模型进行搜索(参见这篇文章),并得到了几个答案,说思维狮身人面像将是一个很好的匹配这种事情。

Indeed, it looks sweet, and it seems the application-wide search capability (ThinkingSphinx.search) is close to what I want. But the docs state this will return various kinds of model objects, depending on where a match was found.

事实上,它看起来很甜美,似乎应用程序范围的搜索功能(ThinkingSphinx.search)接近我想要的。但文档声明这将返回各种模型对象,具体取决于找到匹配的位置。

I have a models somewhat like this:

我的模特有点像这样:

• Employee
• Company
• Municipality
• County

Where employees are linked to County only though Company, which in turn is linked to a Municipality, which in turn is linked to the actual County.

员工只通过公司与县相关联,公司又与市政府相关联,而市政府又与实际的县相关联。

Now as a result from my search, I really only want Employee objects. For example a search for the string "joe tulsa" should return all Employees where both words can be found somewhere in the named models. I'll get some false positives, but at least I should get every employee named "Joe" in Tulsa county.

现在作为搜索的结果,我真的只想要Employee对象。例如,搜索字符串“joe tulsa”应返回所有Employees,其中两个单词都可以在命名模型中的某处找到。我会得到一些误报,但至少我应该让塔尔萨县的每个员工都叫“乔”。

Is this something that can be achieved with built in functionality of Thinking Sphinx?

这是可以通过Thinking Sphinx的内置功能实现的吗?

1 个解决方案

class Employee  :company
  has_one :county, :through => :company
  ...
end

class Company  :municipality
  ...
end

class Municipality 

define_index do
  indexes :name, :sortable => :true
  indexes company(:name),      :as => :company
  indexes municipality(:name), :as => :municipality
  indexes county(:name),       :as => :county
  ...
end