How I write it in rails format? Articles.find( ????)
SELECT *, MATCH(title, body) AGAINST(''$keyword'') AS score FROM
articles
WHERE MATCH(title, body) AGAINST(''$keyword'') ORDER BY score
DESC
--
Posted via http://www.ruby-forum.com/.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Ruby on Rails: Talk" group.
To post to this group, send email to
rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
On Feb 27, 2009, at 11:29 AM, Ga Ga wrote:> How I write it in rails format? Articles.find( ????) > > SELECT *, MATCH(title, body) AGAINST(''$keyword'') AS score FROM > articles > WHERE MATCH(title, body) AGAINST(''$keyword'') ORDER BY score DESCObviously, you''d have to try it yourself, but: match_part = sanitize_sql([''MATCH(title, body) AGAINST(?)'', keyword]) Article.find(:all, :select => "*, #{match_part} AS score", :conditions => match_part, :order => ''score DESC'') I''m guessing that the $keyword is from Perl, but I''ve assumed that you have a local variable called keyword. Look closely at whether the conditions end up correct or if things get double-escaped in the final SQL. -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
I get: undefined method `sanitize_sql'' -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Ga Ga wrote:> I get: > > undefined method `sanitize_sql''Help ? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Feb 27, 2009, at 11:42 AM, Rob Biedenharn wrote:> On Feb 27, 2009, at 11:29 AM, Ga Ga wrote: >> How I write it in rails format? Articles.find( ????) >> >> SELECT *, MATCH(title, body) AGAINST(''$keyword'') AS score FROM >> articles >> WHERE MATCH(title, body) AGAINST(''$keyword'') ORDER BY score DESC > > > Obviously, you''d have to try it yourself, but: > > match_part self.class. > sanitize_sql([''MATCH(title, body) AGAINST(?)'', keyword]) > Article.find(:all, :select => "*, #{match_part} AS score", > :conditions => match_part, :order => ''score DESC'') > > I''m guessing that the $keyword is from Perl, but I''ve assumed that you > have a local variable called keyword. Look closely at whether the > conditions end up correct or if things get double-escaped in the final > SQL. > > -Rob > > Rob Biedenharn http://agileconsultingllc.com > Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.orgSorry, if you look at the docs, sanitize_sql is a protected class method of ActiveRecord::Base -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Rob Biedenharn wrote:> On Feb 27, 2009, at 11:42 AM, Rob Biedenharn wrote: >> match_part > self.class. >> >> Rob Biedenharn http://agileconsultingllc.com >> Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org > > > Sorry, if you look at the docs, sanitize_sql is a protected class > method of ActiveRecord::Base >Is there some alternative way to it, and not to use protected classes? -- Posted via http://www.ruby-forum.com/. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
On Feb 27, 2009, at 2:56 PM, Ga Ga wrote:> Rob Biedenharn wrote: >> On Feb 27, 2009, at 11:42 AM, Rob Biedenharn wrote: >>> match_part >> self.class. >>> >>> Rob Biedenharn http://agileconsultingllc.com >>> Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org >> >> Sorry, if you look at the docs, sanitize_sql is a protected class >> method of ActiveRecord::Base > > Is there some alternative way to it, and not to use protected classes? > --It''s not a protected "class", it''s a protected method in the class ActiveRecord::Base which your Article class is a sub-class. If you don''t like the form of the call, make your own class method like this: class Article def self.keyword_find(keyword) match_part = sanitize_sql([''MATCH(title, body) AGAINST(?)'', keyword]) find(:all, :select => "*, #{match_part} AS score", :conditions => match_part, :order => ''score DESC'') end end Then just call "normally": good_articles = Article.keyword_find(''chocolate'') Does that make you happier? There''s nothing wrong with using sanitize_sql, you just need to call it from the Article class rather than ''directly''. -Rob Rob Biedenharn http://agileconsultingllc.com Rob-xa9cJyRlE0mWcWVYNo9pwxS2lgjeYSpx@public.gmane.org --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk+unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---