Hi Greg At this point, TS doesn't support :touch (probably because I didn't really know about it). If you want to supply a patch, that'd be great! :)
-- Pat On 22/11/2011, at 4:42 AM, Greg DeVore wrote: > Pat - > > Thanks so much! That worked great. I also noticed that in Rails 3 > calling :touch on an object does not trigger a delta index. Is that by > design or should :touch trigger delta indexing? > > Greg > > On Nov 18, 9:29 am, Pat Allan <[email protected]> wrote: >> Hi Greg >> >> I think the best approach is what you're hinting at in your final screenshot >> - a complex piece of SQL code that grabs the ids you need. You could look at >> your space_ids attribute for an example, and you can use the join method in >> your define_index block to force joins on associations that you're not using >> in any fields or attributes - although given you've got space_ids, I guess >> all the tables are referenced already. >> >> If you're using MySQL, then an IF(manuals.draft = 0 AND sections.hidden = 0, >> spaces.id, 0) statement might do the trick (wrapped up in the standard >> concat statements)… PostgreSQL doesn't have an IF method, but you can get >> the same thing happening with a CASE statement instead. >> >> Is that enough help? If you get stuck, let me know. >> >> Cheers >> >> -- >> Pat >> >> On 16/11/2011, at 10:45 PM, Greg DeVore wrote: >> >> >> >> >> >> >> >>> We are in the process of upgrading from Rails 2.3 to 3.x. We have been >>> using TS for awhile but had to hack it a bit to make it do delta >>> indexing on some complex joins we were doing. As we upgrade to Rails 3 >>> we want to make this "out of the box" with the current version of TS >>> without having to hack up our own version. I am just not sure about >>> the best way to setup the "has" index for the MVA value we want to >>> index. >> >>> Here are some screenshots that show what we are trying to do: >> >>> http://gdevore.clarify-it.com/d/qz6ale >> >>> Basically I have a Lesson model that I need to add >>> a :published_space_ids MVA to. The scope to get the >>> published_spaces_ids for a lesson looks like this: >> >>> Space.joins(:manuals => {:sections >>> => :readings}).where('readings.lesson_id = ?', >>> self.id).where('manuals.draft = ? AND sections.hidden = ?', false, >>> false) >> >>> I am not sure how to add this to the sphinx index for the Lesson >>> model. >> >>> Thanks, >> >>> Greg >> >>> -- >>> 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 >>> athttp://groups.google.com/group/thinking-sphinx?hl=en. > > -- > 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. > -- 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.
