Um, not sure what you mean about the symbol and AR...?
but I just remembered - the manual 'has' call doesn't set up the
relationships in the query Sphinx runs, so you'll need another field
or attribute that uses the friendship relationship, ie:
has friendships.friend_id, :as => :friend_ids
Cheers
--
Pat
On 15/02/2009, at 12:30 PM, Alex Caudill wrote:
>
> Nice trick Pat. I had no idea that ActiveRecord just takes the symbol
> and converts it into a string when you specify a relationship, I
> thought
> there was all kinds of kung-fu involved. That's awesome, I'll
> definitely
> find a few places to put that technique to use.
>
> On Feb 14, 2009, at 7:23 PM, Pat Allan wrote:
>
>>
>> But, if you want pagination to work straight out of the box, let's
>> put
>> named_scope aside for a moment...
>>
>> what you need is a custom attribute for your filter... (I'm guessing
>> table and column names, and using mysql functions)
>>
>> has "IF(private = 1, '0', GROUP_CONCAT(friendships.friend_id
>> SEPARATOR
>> ','))", :as => :user_limit, :type => :multi
>>
>> And then:
>>
>> # This will match 0 for public users, and the user id for private
>> users
>> User.search "whatever", :with => {:user_limit => [0, user.id]}
>>
>> Give that a shot.
>>
>> Cheers
>>
>> --
>> Pat
>>
>> On 15/02/2009, at 11:51 AM, Alex Caudill wrote:
>>
>>>
>>> Hey Pascal,
>>>
>>> You could use a named_scope, e.g.,
>>> User.publicly_visible.search(conditions), but then you'd have to
>>> manually do pagination on the results, like
>>> User.publicly_visible.search(conditions).paginate(:per_page =>
>>> 10, :page => 1) - there may be performance problems with this, I
>>> don't
>>> know if
>>> ActiveRecord lazily loads the rest of the User table columns or
>>> what,
>>> but I'm using a similar approach with chained named scopes and it
>>> seems to perform admirably so far.
>>>
>>> Hope this helps!
>>>
>>> On Feb 14, 2009, at 2:37 PM, pascal wrote:
>>>
>>>>
>>>> Hi
>>>>
>>>>
>>>> I want to convert a search system (just SQL queries) to sphinx/TS
>>>> and
>>>> have some troubles, and i hope someone can help me.
>>>>
>>>> The aim is to search users by first/lastname and a description text
>>>> field. A user has many friends. Depending on the users privacy
>>>> settings his visibility in the search by first/lastname is
>>>> restricted
>>>> to his friends or to everyone. Search by description is never
>>>> restricted.
>>>>
>>>> Maybe an example can clear things up:
>>>> User "Santa Claus" has "search privacy" turned on. If you are a
>>>> friend
>>>> you can still find him by the search "Santa". If you aren't a
>>>> friend,
>>>> then you can't find him with "Santa" but with "Christmas" because
>>>> "Christmas" appears on a his description text.
>>>>
>>>> So it something like "find users where search terms matches AND
>>>> (privacy off OR privacy on AND his ID is in in the list of my
>>>> friends
>>>> ids)".
>>>>
>>>> I got simple search up and running real quick but is Sphinx/TS the
>>>> right tool for this? How would i go about this?
>>>>
>>>>
>>>> Thanks for your help!
>>>>
>>>> Pascal
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>
>>>
>>>
>>>>
>>
>>
>>>
>
>
> >
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
