How are you querying against user_id and/or creator_id? Cheers
-- Pat On 12/02/2009, at 4:25 PM, brian wrote: > > Hi Pat, > > Thanks for looking at this. Its my first time using sphinx, but I've > found it pretty good so far. I'm using other indexes in my app > without any trouble. > > Its returning the correct records. It works with description, but > when I add the :creator_id, I get an empty array back. I want to > search within uploads for entities that I'm subscribed to. > > Thanks, > Brian > > On Feb 11, 9:01 pm, Pat Allan <[email protected]> wrote: >> Hi Brian >> >> Do you get the expected data in the user_id column if you run that >> SQL >> query (stripping out the id filtering in the WHERE clause, of >> course)? >> >> -- >> Pat >> >> On 12/02/2009, at 1:31 AM, brian wrote: >> >> >> >>> Here is the sql that I have: >> >>> SELECT `uploads`.`id` * 3 + 1 AS `id` , CAST(`uploads`.`description` >>> AS CHAR) AS `description`, UNIX_TIMESTAMP(`uploads`.`created_at`) AS >>> `created_at`, `uploads`.`creator_id` AS `creator_id`, GROUP_CONCAT >>> (`subscriptions`.`user_id` SEPARATOR ',') AS `user_id`, >>> `uploads`.`id` >>> AS `sphinx_internal_id`, 269607721 AS `class_crc`, '269607721' AS >>> `subclass_crcs`, 0 AS `sphinx_deleted` >> >>> FROM uploads >>> LEFT OUTER JOIN `entities` ON `entities`.id = `uploads`.entity_id >>> LEFT OUTER JOIN `subscriptions` ON subscriptions.entity_id = >>> entities.id >> >>> WHERE `uploads`.`id` >= $start AND `uploads`.`id` <= $end AND >>> `uploads`.`delta` = 0 GROUP BY `uploads`.`id` >> >>> ORDER BY NULL >> >>> On Feb 10, 11:45 pm, Pat Allan <[email protected]> wrote: >>>> Hi Brian >> >>>> From an initial look, it seems like you're doing the right thing - >>>> although entity.subscriptions(:user_id) could be done as >>>> entity.subscriptions.user_id. >> >>>> What's the sql_query in your development.sphinx.conf file for the >>>> Upload index? >> >>>> -- >>>> Pat >> >>>> On 11/02/2009, at 5:27 AM, brian wrote: >> >>>>> I'm trying to get associations working, but can't seem to get it >>>>> right. I have users, who can subscribe to entities. Entities >>>>> have >>>>> uploads and uploads have descriptions. I want to search >>>>> upload.description through all of a user's subscription. >> >>>>> Here are my models: >> >>>>> class User < ActiveRecord::Base >>>>> has_many :subscriptions >>>>> has_many :entity_subscriptions, :through >>>>> => :subscriptions, :source >>>>> => 'entity' >>>>> has_many :entities, :foreign_key => 'owner_id' >>>>> ... >>>>> end >> >>>>> class Entity < ActiveRecord::Base >>>>> has_many :uploads >>>>> has_many :subscriptions >>>>> has_many :subscribers, :through => :subscriptions, :source => >>>>> 'user' >>>>> ... >>>>> end >> >>>>> class Subscription < ActiveRecord::Base >>>>> belongs_to :entity >>>>> belongs_to :user >>>>> end >> >>>>> class Upload < ActiveRecord::Base >>>>> belongs_to :entity >> >>>>> define_index do >>>>> indexes description >>>>> has :created_at >>>>> has :creator_id >>>>> has entity.subscriptions(:user_id), :as => :user_id >>>>> set_property :delta => true >>>>> end >>>>> ... >>>>> end >> >>>>> If I add in user id, i don't get subscriptions for the user that I >>>>> want. I think I've just set it up wrong, any help is greatly >>>>> apprieciated. >> >>>>> Thanks, >>>>> Brian >> >> > > --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
