Hi everybody,
I want to index and search over a class model (include has filter) which
could be like this.
class ForumPost < ActiveRecord::Base
> validates_presence_of :title, :content
>
> belongs_to :forum_section, :foreign_key=> :section_id
> belongs_to :forum_post, :foreign_key=> :post_id
> has_many :forum_posts,:foreign_key=> :post_id, :dependent=>:destroy
> belongs_to :user
>
> xss_terminate :html5lib_sanitize => [ :content ]
>
> # Definition de l index de recherche
> define_index do
> # General (Mots cles / Nom du forum / Sous-Forum Categorie / Auteur /
> Nombre de reponses)
> indexes title, :as => :ts_forum_post_title
> indexes content, :as => :ts_forum_post_content
>
> has forum_post(:id), :as => :ts_forum_post_ids
>
> # Propriete sur les recherches
> set_property :enable_star => 1
> set_property :min_prefix_len => 1
>
> end
> end
>
If the ForumPost is the TOPIC, they don't have forum_post value (NULL
value), and their reply forum_post value will be the TOPIC ID.
To be more clear, an example of my database
"id";"title";"content";"user_id";"section_id";"post_id";"created_at";"updated_at"
> "41";"TOPIC";"<p>cvxcvxcvcx<br/></p>";"11";"15";NULL;"2009-05-06
> 10:01:07";"2009-05-06 10:01:07"
> "44";"reply_1";"<p>cxvxv<br/></p>";"11";"15";"41";"2009-05-06
> 10:01:50";"2009-05-06 10:01:50"
> "45";"reply_2";"<p>vxvcxvxc<br/></p>";"11";"15";"41";"2009-05-06
> 10:02:10";"2009-05-06 10:02:10"
>
When i'm searching for "cx*" in Search client, the result is good
search --config
> /home/gamez/project/uneek/trunk/config/development.sphinx.conf cx*
>
> displaying matches:
> 1. document=410, weight=1, ts_forum_post_ids=41, sphinx_internal_id=41,
> class_crc=3624676887, subclass_crcs=(3624676887), sphinx_deleted=0
> id=41
> title=TOPIC
> content=<p>cvxcvxcvcx<br/></p>
> user_id=11
> section_id=15
> post_id=(NULL)
> created_at=2009-05-06 10:01:07
> updated_at=2009-05-06 10:01:07
> 2. document=440, weight=1, ts_forum_post_ids=44, sphinx_internal_id=44,
> class_crc=3624676887, subclass_crcs=(3624676887), sphinx_deleted=0
> id=44
> title=reply_1
> content=<p>cxvxv<br/></p>
> user_id=11
> section_id=15
> post_id=41
> created_at=2009-05-06 10:01:50
> updated_at=2009-05-06 10:01:50
> 3. document=440, weight=1, ts_forum_post_ids=45, sphinx_internal_id=45,
> class_crc=3624676887, subclass_crcs=(3624676887), sphinx_deleted=0
> id=45
> title=reply_2
> content=<p>vxvcxvxc<br/></p>
> user_id=11
> section_id=15
> post_id=41
> created_at=2009-05-06 10:01:50
> updated_at=2009-05-06 10:01:50
>
words:
1. 'cx*': 3 documents, 6 hits
But, With, thinkingSphinx search and has filter, the result is wrong.
@searches = ThinkingSphinx::Search.search(params[:search][:query],
> :per_page => self.per_page, :classes => [UserProfile, Community, Article,
> Event, Forum, Blog, BlogPost, BlogComment, Forum, ForumPost, ForumSection],
> :with => {
> :ts_community_ids => communities_ids_from_user(current_user.id),
> :ts_blog_comments_ids => blog_comments_ids_from_user(
> current_user.id),
> :ts_blog_post_ids => blog_posts_ids_from_user(current_user.id),
> :ts_blog_ids => blog_ids_from_user(current_user.id),
> :ts_forum_ids => forum_ids_from_user(current_user.id),
> :ts_forum_post_ids => forum_post_ids_from_user(current_user.id),
> :ts_forum_section_ids => forum_section_ids_from_user(
> current_user.id)
> }
> )
>
The :ts_forum_post_ids value is [36, 41, 44, 45, 63, 64] but, Sphinx search,
doesn't include 41 ID Document
/* Mongrel Log */
Sphinx: cx*
Sphinx Result: [44, 45]
But, if I delete the line, and search like this
@searches = ThinkingSphinx::Search.search(params[:search][:query],
> :per_page => self.per_page, :classes => [UserProfile, Community, Article,
> Event, Forum, Blog, BlogPost, BlogComment, Forum, ForumPost, ForumSection],
> :with => {
> :ts_community_ids => communities_ids_from_user(current_user.id),
> :ts_blog_comments_ids => blog_comments_ids_from_user(
> current_user.id),
> :ts_blog_post_ids => blog_posts_ids_from_user(current_user.id),
> :ts_blog_ids => blog_ids_from_user(current_user.id),
> :ts_forum_ids => forum_ids_from_user(current_user.id),
> :ts_forum_section_ids => forum_section_ids_from_user(
> current_user.id)
> }
> )
>
The result is good.
I think TS ignore docs when NULLABLE belongs_to is present and when we using
has keyword. Do you have some idea to fix them ? or i'm doing something
wrong ?
Thank's.
Best regards,
Mickaël ALLAIN.
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
