Pat,
I saw the entry on git hub and responded to it :). Here's the
response :
I downloaded the 9.9 Sphinx branch and tried it.
It's better.. There's a slight change on my end of implementation, but
nothing that should change the behavior of the facets method. This
branch is giving me some of the facets I want, but others are nil.
What I have now is:
House ==> has many bedrooms
Each bedroom has a door, of a certain color. (Before it was many doors
per bedroom).
It is defined as:
class House << ActiveRecord::Base
has_many :bedrooms
define_index do
indexes bedrooms.door.color, :as => :bedroom_door_color, :facet =>
true
end
end
For the facets, I get:
"Blue" => 2
"nil" => 2
"Red" => 1
I do have 6 total colors entries, and the 2 that are nil are different
colors. One facet isn't being displayed.
Thanks.
Manish
On Sep 13, 9:50 am, Pat Allan <[email protected]> wrote:
> Okay, latest TS (as a plugin, haven't bumped gem version yet) should
> fix this. Let me know if I'm wrong :)
>
> --
> Pat
>
> On 07/09/2009, at 5:57 PM, mrmanishs wrote:
>
>
>
> > Pat...
>
> > Thanks :)
>
> > Let me know whenever you get to it, and I'll try to hit it again...
>
> > Manish
>
> > On Sep 7, 11:34 am, Pat Allan <[email protected]> wrote:
> >> Yup, I'm sure it's an issue, I just need to find some time to work on
> >> it. Maybe during this week, but we'll see - work and life are both a
> >> bit flat out at the moment.
>
> >> --
> >> Pat
>
> >> On 07/09/2009, at 5:15 PM, mrmanishs wrote:
>
> >>> I found a work-around for now, just going to doone-to-one. I
> >>> think I
> >>> have a way that it may work...
>
> >>> But, this looks like it still as an issue.
>
> >>> On Sep 6, 1:12 pm, mrmanishs <[email protected]> wrote:
> >>>> Hey Pat,
>
> >>>> I reinstalled using the following command: script/plugin install
> >>>> git://github.com/freelancing-god/thinking-sphinx.git --force
>
> >>>> However, I am still getting the same error.
>
> >>>> The error comes up whenever I type: House.facets.
>
> >>>> Manish
>
> >>>> On Sep 6, 11:48 am, Pat Allan <[email protected]> wrote:
>
> >>>>> Hi Manish
>
> >>>>> On 06/09/2009, at 5:32 PM, mrmanishs wrote:
>
> >>>>>> Pat... I am always impressed by your response time.
>
> >>>>> Ah, it varies. Saying 'What version?' isn't too hard though. And
> >>>>> I'm
> >>>>> having a quiet weekend :)
>
> >>>>>> The installation date I have is August 16th, 2009.
>
> >>>>> Just checked the TS logs, the fix was made on the 23rd - try
> >>>>> updating,
> >>>>> and let me know if that doesn't fix the problem.
>
> >>>>> Cheers
>
> >>>>> --
> >>>>> Pat
>
> >>>>>> On Sep 6, 11:14 am, Pat Allan <[email protected]> wrote:
> >>>>>>> How recent is your version of Thinking Sphinx? Changes were made
> >>>>>>> to
> >>>>>>> multi-value string facets a few weeks ago. If you're running
> >>>>>>> something
> >>>>>>> really recent, I'll try to add a failing scenario, and figure
> >>>>>>> out the
> >>>>>>> fix.
>
> >>>>>>> --
> >>>>>>> Pat
>
> >>>>>>> On 06/09/2009, at 5:12 PM, mrmanishs wrote:
>
> >>>>>>>> So,
>
> >>>>>>>> That does index properly, but when I try to run facets, I get
> >>>>>>>> the
> >>>>>>>> following error:
>
> >>>>>>>> NoMethodError: undefined method 'doors' for #<Array:0x271ad5c>
> >>>>>>>> from /opt/local/lib/ruby/gems/1.8/gems/
> >>>>>>>> activerecord-2.3.2/
> >>>>>>>> lib/
> >>>>>>>> active_record/associations/association_proxy.rb:148:in `send'
> >>>>>>>> from /opt/local/lib/ruby/gems/1.8/gems/
> >>>>>>>> activerecord-2.3.2/
> >>>>>>>> lib/
> >>>>>>>> active_record/associations/association_proxy.rb:148:in `send'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:95:in
> >>>>>>>> `translate'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:94:in
> >>>>>>>> `each'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:94:in
> >>>>>>>> `translate'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet.rb:75:in
> >>>>>>>> `value'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 112:in
> >>>>>>>> `add_from_results'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:183:in
> >>>>>>>> `each_with_groupby_and_count'
> >>>>>>>> from /opt/local/lib/ruby/gems/1.8/gems/
> >>>>>>>> activerecord-2.3.2/
> >>>>>>>> lib/
> >>>>>>>> active_record/attribute_methods.rb:211:in `each_with_index'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in
> >>>>>>>> `each'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in
> >>>>>>>> `each_with_index'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search.rb:182:in
> >>>>>>>> `each_with_groupby_and_count'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 111:in
> >>>>>>>> `add_from_results'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 47:in
> >>>>>>>> `populate'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 45:in
> >>>>>>>> `each'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 45:in
> >>>>>>>> `populate'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/facet_search.rb:
> >>>>>>>> 11:in
> >>>>>>>> `initialize'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search_methods.rb:
> >>>>>>>> 404:in
> >>>>>>>> `new'
> >>>>>>>> from /Users/manish/AcceleWeb/srcror/allvineyards.com/
> >>>>>>>> vendor/
> >>>>>>>> plugins/thinking-sphinx/lib/thinking_sphinx/search_methods.rb:
> >>>>>>>> 404:in
> >>>>>>>> `facets'
> >>>>>>>> from (irb):4>>
>
> >>>>>>>> Any idea?
>
> >>>>>>>> Manish
>
> >>>>>>>> On Sep 5, 4:36 pm, Pat Allan <[email protected]> wrote:
> >>>>>>>>> If you want to index all the colours, then your example should
> >>>>>>>>> actually work (provided the association names are correct).
>
> >>>>>>>>> If you want the number of doors for all bedrooms, then try the
> >>>>>>>>> following:
> >>>>>>>>> # to force the joins
> >>>>>>>>> has bedrooms.doors(:id), :as => :door_ids
> >>>>>>>>> # actual door count
> >>>>>>>>> has 'COUNT(doors.id)', :as => :door_count, :type
> >>>>>>>>> => :integer
>
> >>>>>>>>> --
> >>>>>>>>> Pat
>
> >>>>>>>>> On 05/09/2009, at 9:03 PM, mrmanishs wrote:
>
> >>>>>>>>>> All,
>
> >>>>>>>>>> How would I index attribute of a aone-to-many-to-many
> >>>>>>>>>> association?
>
> >>>>>>>>>> Example:
>
> >>>>>>>>>> House ==> hasmanybedrooms
> >>>>>>>>>> each bedroom hasmanydoors, of a certain color. I don't have
> >>>>>>>>>> a :through relationship because it'sonetomany, so house_id
> >>>>>>>>>> is
> >>>>>>>>>> stored on the bedroom table.
>
> >>>>>>>>>> How would I tell it to index it so that House knows howmany
> >>>>>>>>>> colored
> >>>>>>>>>> doors it has for its bedrooms? I'd like to do something like
> >>>>>>>>>> this
> >>>>>>>>>> (obviously it doesn't work):
>
> >>>>>>>>>> class House << ActiveRecord::Base
> >>>>>>>>>> has_many :bedrooms
>
> >>>>>>>>>> define_index do
> >>>>>>>>>> indexes bedrooms.doors.color, :as
> >>>>>>>>>> => :bedroom_door_color, :facet
> >>>>>>>>>> => true
> >>>>>>>>>> end
>
> >>>>>>>>>> end
>
> >>>>>>>>>> Thanks.
>
> >>>>>>>>>> Manish
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Thinking Sphinx" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/thinking-sphinx?hl=en
-~----------~----~----~----~------~----~------~--~---