Construct SQL in Ruby

Question

Let's say I wanna do

SomeModel.where(blahblah)

and if certain param has been set, then I also want to order the selection

SomeModel.where(blahblah).order(blahblah)

I don't want to have to do

if something
   SomeModel.where(blahblah)
else
   SomeModel.where(blahblah).order(blahblah)
end

because it's repetitive.

Is there some way that allows me to construct a SQL statement with conditionals, and then execute it later? Something similar to constructing a SQL string through concatenation and then executing the string?

Satya · Accepted Answer · 2013-10-04 04:18:47Z

1

Yes, that's the point of ARel:

x = SomeModel.where(blahblah)
x = x.order(blah) if something

answered Oct 4, 2013 at 4:18

Satya

4,49824 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Satya Over a year ago

You're using Rails. You're already doing .where and .order. That's all ARel. ActiveRecord::Relation. In other words, you don't need to add another gem, you already have the gem you need for this.

Collectives™ on Stack Overflow

Construct SQL in Ruby

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related