Ruby on Rails

Fail to see the use case Faisal - plz elaborate - and keep in mind that

Article.where id: [1,2,3,4,5,6,7,8,9,10,11, . . . , 2100]

would generate one heck of a parameterized array ;)


> Den 02/10/2015 kl. 04.39 skrev Faisal Mansoor <faisal.mansoor@gmail.com>:
>
> Activerecord generates parameterized queries for basic types, but, it does parameterize array types.
>
> E.g.
>
> Article.where(id: 1)
> # generates
> # SELECT "articles".* FROM "articles" WHERE "articles"."id" = $1 [["id", 1]]
>
> But,
>
> Article.where(id: [1,2])
> # generates
> # SELECT "articles".* FROM "articles" WHERE "articles"."id" IN (1, 2)
> # rather than
> # SELECT "articles".* FROM "articles" WHERE "articles"."id" IN ($1, $2)
> [["id", 1], ["id", 2],]
>
> Is it possible to restructure the query or use Arel to generate parameterized query for IN clauses?
>
>
> --
> 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/msgid/rubyonrails-talk/3edc1ebe-8d1b-4b42-9229-75934110b26b%40googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
> --
> Denne besked er blevet skannet af
> ALCO Stopspam, og menes at være fri for vira og spam.
> Klik her for at rapportere denne besked som spam.

--
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/msgid/rubyonrails-talk/62900F4E-4875-4808-8C0C-E0F9F513B08C%40diechmann.net.
For more options, visit https://groups.google.com/d/optout.