Ruby on Rails

You can always use the underlying arel_table:

Plan.where(arel_table[:user_id].not_eq([3,4,7]))

Saving off what the user_ids of [3,4,7] mean might make it a bit clearer too:

declarative_name = arel_table[:user_id].not_eq(ids)
Plane.where(declarative_name)

Or succinctly in a scope:

scope :declarative_name, ->(ids) { where(arel_table[:user_id].not_eq(ids)) }
# => Plan.declarative_name [3,4,7]

There is a railscast for promoting the Arel predicates to class level methods on active_record objects: http://railscasts.com/episodes/355-hacking-with-arel

So you could end up with:

Plan.match(user_id: { not_in: [3,4,7] })

The draw back is that your interface for all active_record objects is more expansive, but it depends on the style of the app and your preferences on this matter, I like to keep a minimal public interface personally.

And finally the squeel gem sprung to mind which automagically adds these predicates to active_record objects too:

Plan.where{ user_id.not_in [3,4,7] }

I've tried all of these approaches except the railscast version, and like access the arel_table directly to build queries the best, as you learn more that way :-)

On Tuesday, 26 February 2013 03:23:48 UTC, Bruno Santos wrote:

Try something like this:

Plan.where("user_id not in (#{[3,4,7].join(', ')})")

2013/2/25 tamouse mailing lists <tamous...@gmail.com>

On Sun, Feb 24, 2013 at 8:43 PM, Javier Quarite <jqua...@gmail.com> wrote:
>
> Have you considered doing a sql query?
>
> my approach would be this
>
> query_array = []
> [3,4,7].each do |value|
>   query_array << "user_id != #{value}"
> end
>
> Plan.where("#{query_array}.join(" and ")")
>
> Also, the past week I found this gist from ryan
> https://gist.github.com/ryanb/4974414
>
> I'm still analyzing it but it taught me a lot
>
> Javier

If going the SQL route, easier might be:

Plan.where("user_id not in (3,4,7)")

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-ta...@googlegroups.com.
To post to this group, send email to rubyonra...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.

--
You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email to rubyonrails-talk+unsubscribe@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msg/rubyonrails-talk/-/0fsT1g5jZSoJ.
For more options, visit https://groups.google.com/groups/opt_out.