Storing multiple variable via a single db call

Question

update: i need the results to be associated with the variables, and obviously maintaining order.

Hi folks, i find myself doing some variant of this often.

Essentially, i am doing 3 db calls, but I would like to do it in one single database call (for obvious performance reasons)

user1=User.find(x)
user2=User.find(y)
user3=User.find(z)

I believe there should be a simple rails method to handle this

I am using mongoid, but activerecord centric answers appreciated as well

Vasiliy Ermolovich · Accepted Answer · 2011-04-28 16:22:49Z

1

users = User.find(1,2,3)

User Load (0.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" IN (1, 2, 3)

UPDATE: If you want to store the result in the variables:

user1, user2, user3 = User.find(1,2,3)

answered Apr 28, 2011 at 16:15

24.7k5 gold badges84 silver badges78 bronze badges

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

Comments

dee-see · Accepted Answer · 2011-04-28 16:14:38Z

0

users = User.find(x, y, z) will return an array with your results.

Documentation:

Person.find(1, 2, 6) # returns an array for objects with IDs in (1, 2, 6)

answered Apr 28, 2011 at 16:14

dee-see

24.1k6 gold badges63 silver badges92 bronze badges