Hi!
On Wed, Nov 29, 2006 at 07:16:22PM -0500, John Bachir wrote:
> Hello. I am new to Ferret. I am using it through Acts as Ferret.
>
> Let's say I have such a table, and all columns are indexed using the
> default behavior provided by acts_as_ferret:
>
> ARTICLES
> -id
> -year
> -body
>
[..]
>
> [3] This is an acts_as_ferret-specific question: are there any
> convenient methods to do queries against the regular (mysql) database
> and the ferret database at the same time? for example, still using
> the example above, if year (and maybe several other columns) were NOT
> stored in the ferret DB, is there any level of abstraction at which i
> can query: "select id, year, author, title from articles where
> KEYWORDS % body" ?
You can give ActiveRecord conditions (and any other options such as
:include or :order) in the second parameter hash to find_by_contents:
Model.find_by_contents( query, {}, { :conditions => ['year > ?',year] } )
but be aware that these conditions will be applied *after* searching the
Ferret index, and will further reduce the result set returned by ferret.
This makes Ferret's :limit and :offset options quite useless. You can
however use these options inside the second hash so they will be applied
to the ActiveRecord find call.
cheers,
Jens
--
webit! Gesellschaft für neue Medien mbH www.webit.de
Dipl.-Wirtschaftsingenieur Jens Krämer [EMAIL PROTECTED]
Schnorrstraße 76 Tel +49 351 46766 0
D-01069 Dresden Fax +49 351 46766 66
_______________________________________________
Ferret-talk mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/ferret-talk
