Querying and returning an array rather than an object?

rubyonrails-talk
1

I'm trying to write an application where people can vote on things, and I want to make sure a person can't vote twice. Pretend 'user' is voting on various objects. I was thinking about something like this:

v = user.votes.find(:all, :select => 'object_id').

if v.contains?(object_a.id) then already_voted_a if v.contains?(object_b.id) then already_voted_b if v.contains?(object_c.id) then already_voted_c

etc...

But v won't be an array of object ids, it will be an array of votes, right? How do you think I should go about doing this?

They're going to be many objects on a single page, so I only want to do one database query.

Thanks!

Stedwick

2

Well if you do just want an array of values, you might be interested in the select_all or select_values methods provided by the connection (ie User.connection.select_values 'SELECT object_id from votes where user_id = 123')

Fred

3

Thanks!

I also realized I could probably use things like:

v.map!{|x| x.object_id}

or

v.flatten!.compact!

Those would probably work too, right?