pg_search across multiple models in rails?

Question

I'm trying to use pg_search to search across two models. I have a 'Hires' model with two columns 'child_id' and 'book_id'. I want to index the child name associated with the child_id in the 'Children' model.

My model looks like this:

Hire.rb

class Hire < ActiveRecord::Base

  belongs_to :book
  belongs_to :child
  accepts_nested_attributes_for :book
  accepts_nested_attributes_for :child

  include PgSearch
  multisearchable :against => [:child_id, child_forename]

  def child_forename
    child.forename
  end

end

but when I try to build the index (rake pg_search:multisearch:rebuild[Hires]) I get the following error:

rake aborted!
NameError: undefined local variable or method `child_forename' for Hire (call 'Hire.connection' to establish a connection):Class
/Library/Ruby/Gems/2.0.0/gems/activerecord-4.2.4/lib/active_record/dynamic_matchers.rb:26:in `method_missing'
/Users/James/Documents/websites/STAlibrary/app/models/hire.rb:12:in `<class:Hire>'
/Users/James/Documents/websites/STAlibrary/app/models/hire.rb:1:in `<top (required)>'
/Library/Ruby/Gems/2.0.0/gems/activesupport-4.2.4/lib/active_support/dependencies.rb:457:in `load'

How can i build this query to index the child forename?

score 0 · Answer 1 · answered Jan 19 '16 at 00:48

0

Try defining the child_forename method before multisearchable:

class Movie < ActiveRecord::Base
  belongs_to :director

  def director_name
    director.name
  end

  multisearchable against: [:name, :director_name]
...

Let me know if it works. Seems to be working ok for a test I tried some time ago.

answered Jan 19 '16 at 00:48

Mihai Ionescu

968
1
8
13

:director_name is a symbol in your example, so the method is not immediately called in that line. Order does not matter in this case. – RobDil Jan 19 '16 at 09:07

score 0 · Answer 2 · edited May 23 '17 at 11:44

0

I had some problems with pg search. So i just made my own. Check it out.

How To Create A Search Function - Ruby On Rails

edited May 23 '17 at 11:44

Community

1
1

answered Jan 19 '16 at 06:15

joeyk16

1,357
22
49

score 0 · Accepted Answer · answered Jan 19 '16 at 09:05

You are missing a colon in front of child_forename.

You need to pass in symbols:

multisearchable :against => [:child_id, :child_forename]

The given error tells you that the method "child_forename" is not defined. That is because the ruby interpreter reads the file top down and the method is not yet defined at that point. But if it was, the line would evaluate to

multisearchable :against => [:child_id, "Mary"]

which is probably not what you want. If you correctly pass the symbol, the method with that name is called later in some on_update callback when an object is instantiated and the object contents are indexed.

pg_search across multiple models in rails?

3 Answers3