ruby on rails - Not quite multiple model search - PG -

ruby on rails - Not quite multiple model search - PG -

:user has_many :books etc.

i want implement search matches against books or users, books , users closely related, does't quite sense multiple class search.

essentially want perform total text search against -

book.title book.description book.user.username book.user.aboutuser

... , homecoming ranked book objects. i'm playing around textacular. right in thinking not multiple class search? can point resource woking out how create query?

i utilize sunspot here - uses sorl, quite search engine.

in gemfile:

gem 'sunspot_rails' gem 'sunspot_solr' # optional pre-packaged solr distribution utilize in development

after required bundle, can create config , launch solr deamon:

rails generate sunspot_rails:install bundle exec rake sunspot:solr:start

in model:

searchable integer :rank text :title, :descritpion text :aboutuser users.map { |user| user.aboutuser } end text :username users.map { |user| user.username } end end

usage:

books = book.search fulltext 'my text' order_by :rank, :desc end

only minus need launch on production server - shouldn't done using rake sunspot:solr:start. instead should deploy on (probably) tomcat or other java app server.

ruby-on-rails postgresql search