find_by_sql with array format in Rails 3

ruby-on-rails-3 activerecord model find-by-sql
Shree S picture Shree S · Jun 11, 2012 · Viewed 8.4k times · Source

good day guys!

I'm using find_by_sql() in rails 3 to fetch records as follows.

@list=Email.find_by_sql(["SELECT * FROM Emails WHERE sent_id=?",params[:id]])

How to modify the same statement if multiple parameter applies for same attribute, say for example :

@list=Email.find_by_sql(["SELECT * FROM Emails WHERE (sent_id=? OR from_id=?)",params[:id],params[:id]])

Here, both sent_id and from_id attributes receives same parameter params[:id]

So, instead of passing same params[:id] twice, is there any mechanism available to pass parameter based on order?

Answer

MrTheWalrus picture MrTheWalrus · Jun 11, 2012

You can use a hash to name the interpolated values, like this:

@list = Email.find_by_sql(["SELECT * FROM Emails WHERE (sent_id = :id OR from_id = :id)", {:id => params[:id]}])

Related questions

Rails: How do self-referential has_many models work?

So, I'm working on an app where I want to users to be able to group objects in "folders". Basically: User has_many :foos Foos don't have to be in a folder, but they can be. In that case: Folder …

Read More
How to create ActiveRecord tableless Model in Rails 3

I am trying to create a Active Record tableless Model. My user.rb looks like this class User < ActiveRecord::Base class_inheritable_accessor :columns def self.columns @columns ||= []; end def self.column(name, sql_type = nil, default = nil, null = …

Read More
rails g scaffold for existing model and DB table

I would like to create a structure with rails g scaffold Article, but I have already created the table Articles and model Articles. Is there any way to do that?

Read More