Ah, ok...:-)
But are you sure this is correct?
Because:
Track.search('beat impelling', :order => 'category_name ASC')
[:matches]
gives me:
TypeError: Symbol as array index
from (irb):1:in `[]'
from (irb):1
On Jun 4, 4:15 pm, Pat Allan <[email protected]> wrote:
> Ah, that's just the email client wrapping my code - put it all on one
> line. Here's another example without the search term (although you
> should keep that in):
> Track.search(:order => 'category_name ASC')[:matches]
>
> --
> Pat
>
> On 04/06/2009, at 7:51 AM, j0llyr0g3r wrote:
>
>
>
> > Hey Pat,
>
> > sorry, I am not sure what you mean? Is this:
>
> >> What's the output of the following?
> >> Track.search('beat impelling', :order => 'category_name ASC')
> >> [:matches]
>
> > a typo?
> > Because i read your peepcode and something like "[:matches]" is
> > nowhere mentioned.....
>
> > If not, here is the output in "script/console":
>
> >>> Track.search('beat impelling', :order => 'category_name ASC')
> > => [#<Track id: 1, artist: "foobar", title: "House", ................
> >>> [:matches]
> > => [:matches]
>
> > On Jun 4, 12:09 am, Pat Allan <[email protected]> wrote:
> >> What's the output of the following?
> >> Track.search('beat impelling', :order => 'category_name ASC')
> >> [:matches]
>
> >> --
> >> Pat
>
> >> On 03/06/2009, at 11:44 AM, j0llyr0g3r wrote:
>
> >>> Hi Pat,
>
> >>> and thanks for your insights on this issue. I had to tweak your
> >>> proposal since
>
> >>> indexes category.category_translations , :as => :category
>
> >>> won't work as category_translations is a 'real' table.
>
> >>> I defined my indexes now like that:
>
> >>> has category.category_translations.name, :as => :category_name
> >>> has theme.theme_translations.name, :as => :theme_name
>
> >>> I reindexed and restarted sphinx.
>
> >>> Unfortunately, it still isn't working:
>
> >>> Track.search 'beat', :order => 'category_name asc'
>
> >>> now yields a correct resultset, but the sorting still doesn't work.
> >>> The following example illustrates this:
>
> >>>>> Track.search('beat impelling', :order => 'category_name ASC').each
> >>>>> {|f| puts f.category.name}
> >>> Electro / House
> >>> Hip Hop
> >>> Funk
> >>> Techno / Trance
> >>> Rock
> >>> Pop
> >>> Hip Hop
> >>> Electro / House
> >>> Rock
> >>> Rock
> >>> Pop
>
> >>> "Tailing" my development.log at the same time shows this:
>
> >>> Sphinx: beat impelling
> >>> Sphinx Result: [1, 2, 13, 15, 18, 20, 22, 24, 39, 42, 49]
> >>> Track Load (4.6ms) SELECT * FROM `tracks` WHERE (`tracks`.`id` IN
> >>> (1,2,13,15,18,20,22,24,39,42,49))
> >>> Category Load (3.2ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 4)
> >>> CategoryTranslation Load (0.9ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id
> >>> = 4
> >>> AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.6ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 7)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id
> >>> = 7
> >>> AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.6ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 6)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id
> >>> = 6
> >>> AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.6ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 16)
> >>> CategoryTranslation Load (4.4ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 16 AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (2.7ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 15)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 15 AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (2.3ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 13)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 13 AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.5ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 7)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id
> >>> = 7
> >>> AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.5ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 4)
> >>> CategoryTranslation Load (0.8ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id
> >>> = 4
> >>> AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.5ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 15)
> >>> CategoryTranslation Load (6.6ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 15 AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.6ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 15)
> >>> CategoryTranslation Load (1.2ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 15 AND (`category_translations`.`locale` IN ('en','root')))
> >>> Category Load (0.6ms) SELECT * FROM `categories` WHERE
> >>> (`categories`.`id` = 13)
> >>> CategoryTranslation Load (0.9ms) SELECT * FROM
> >>> `category_translations` WHERE (`category_translations`.category_id =
> >>> 13 AND (`category_translations`.`locale` IN ('en','root')))
>
> >>> I don't get it, no errors in the logs, but obviously the order-
> >>> clause
> >>> is ignored?
>
> >>> What am i doing wrong here?
>
> >>> On May 31, 8:25 pm, Pat Allan <[email protected]> wrote:
> >>>> You'll have to do *one* of the two following things:
> >>>> - Add that column as a sortable field (if you want the contents
> >>>> indexed for searching)
> >>>> indexes category.category_translations, :as
> >>>> => :category, :sortable
> >>>> => true
> >>>> - Or, add it as an attribute, which is implicitly sortable, but not
> >>>> indexed for searching
> >>>> has category.category_translations, :as => :category
>
> >>>> And then stop Sphinx, re-index and restart Sphinx (rake
> >>>> thinking_sphinx:rebuild if you're running a new version of TS) and
> >>>> then you can search as follows:
> >>>> Track.search 'beat', :order => :category # or 'category ASC'
>
> >>>> The problem with your current approach: Sphinx doesn't use SQL for
> >>>> searches. :joins and table names in :order mean nothing to Sphinx,
> >>>> and
> >>>> so it gets confused and returns no results.
>
> >>>> Cheers
>
> >>>> --
> >>>> Pat
>
> >>>> On 31/05/2009, at 11:04 AM, j0llyr0g3r wrote:
>
> >>>>> Hey guys,
>
> >>>>> i have a model "track" with the following index structure:
>
> >>>>> define_index do
> >>>>> indexes tags, :sortable => true
> >>>>> indexes short_description, :sortable => true
> >>>>> indexes full_description, :sortable => true
> >>>>> indexes artist, :sortable => true
> >>>>> indexes title, :sortable => true
> >>>>> end
>
> >>>>> This works fine so far....
>
> >>>>> Now, my model "track" has a belongs_to-association to the model
> >>>>> "category", which in turn has a "has_many"-association to the
> >>>>> model
> >>>>> "category_translations" (globalize2)
>
> >>>>> So i thought i could do the following query and get back the
> >>>>> results
> >>>>> sorted via category-name:
>
> >>>>> Track.search 'beat', :order => 'category_translations.name
> >>>>> ASC', :joins => {:category => :category_translations}
>
> >>>>> but this gives me an empty resultset.
>
> >>>>> In my log-files i can see the error:
>
> >>>>> Sphinx: beat
> >>>>> Sphinx Result: []
> >>>>> Sphinx Error: index track_core: sort-by attribute
> >>>>> 'category_translations' not found
>
> >>>>> What do i have to do in order to be able to sort after the
> >>>>> category-
> >>>>> name?
> >>>>> Do i have to index it separately?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
