On Monday, January 23, 2017 at 10:02:53 AM UTC-8, Julien Ammous wrote:
>
> Hi, I want sequel to write this:
>
> SELECT * FROM xxx ORDER BY RANDOM()
>
> This is the request I want but I would prefer if the order() helper could
> be used so that I can chains other sequel methods, I tried a few solutions
> but I can't make it write this query :(
>
> I tried:
>
> - order('RANDOM()') : without much surprise it write ORDER BY 'RANDOM()'
> - order(:'RANDOM()'): it complains that it cannot find a column by that
> name
>
> If anyone has any suggestion it would help, at this point I want/need to
> make it work, I will monkey patch the code if I need to.
> Writing the full query by hand is a solution I would like to avoid
> otherwise I would not be using sequel.
>
There are multiple ways to do this. One way would be do use a virtual row
block:
order{RANDOM{}}
Another would be to create the function object explicitly:
order(Sequel.function(:RANDOM))
Another would be to force custom SQL using Sequel.lit:
order(Sequel.lit('RANDOM()'))
Thanks,
Jeremy
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/sequel-talk.
For more options, visit https://groups.google.com/d/optout.
