Hello,
I've noticed a difference in results between doing
ThinkingSphinx.search "test" and ThinkingSphinx.search, :without =>
'....'
So here's what I did
(1) Created a translation (id=1) and set the status to published. Ran
delta index and the translation was indexed as published.
(2) Created a new translation (id= 2) off of the published translation
and set the status to draft. Ran delta index on both the published and
the draft translations. When I did the following query:
ThinkingSphinx.search "test"
(1) id=1, published
(2) id=2, unpublished
ThinkingSphinx.search "test", :without => {'published' => 0}
(1) id=1, published
ThinkingSphinx.search "test", :without => {'published' => 1}
(1) id=1, unpublished (CORRUPTED, not sure where
this came from. The AR object this index entry refers to has published
set to true)
(2) id=2, unpublished
class ContentTranslation < ActiveRecord::Base
define_index
has published
set_property :delta => true
end
def run_index_delta
#update all translations in the same locale
ids_of_translations_in_same_locale =
ContentTranslation.find(:all, :select => "id", :conditions=>
"content_id='#{self.content_id}' AND locale_id =
'#{self.locale_id}'").collect{|t| t.id}
ContentTranslation.connection.update("UPDATE content_translations
SET delta = true where id IN
(#{ids_of_translations_in_same_locale.join(",")})")
ContentTranslation.search ""
ContentTranslation.index_delta
ContentTranslation.connection.update("UPDATE content_translations
SET delta = false where id IN
(#{ids_of_translations_in_same_locale.join(",")})")
end
end
Thoughts?
Thank you
Jesus Tugade
--
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.
