On Tuesday, October 17, 2017 at 7:16:13 AM UTC-4, Beth Skurrie wrote:
>
> Imagine I have a table that has two pairs of coordinates, start_x, start_y
> and end_x, end_y. I'm trying to find all lines that connect two points 1,1
> and 2,2, without knowing which is the start and which is the end.
>
> This is almost there, but not quite.
>
> irb(main):004:0> DB[:lines].where(start_x: 1, start_y: 1).or(start_x: 2,
> start_y: 2).where(end_x: 1, end_y: 1).or(end_x: 2, end_y: 2)
> => #<Sequel::SQLite::Dataset: "SELECT * FROM `lines` WHERE (((((`start_x`
> = 1) AND (`start_y` = 1)) OR ((`start_x` = 2) AND (`start_y` = 2))) AND
> (`end_x` = 1) AND (`end_y` = 1)) OR ((`end_x` = 2) AND (`end_y` = 2)))">
>
> The red part is where it goes wrong. I want it to do:
>
> SELECT * FROM `lines` WHERE (((`start_x` = 1) AND (`start_y` = 1)) OR
> ((`start_x`
> = 2) AND (`start_y` = 2))) AND (((`end_x` = 1) AND (`end_y` = 1)) OR
> ((`end_x`
> = 2) AND (`end_y` = 2)))
>
> I've trawled through all the querying documentation I can find, but
> haven't been able to find an answer. Any help would be appreciated.
>
> Thanks.
>
How about this?
DB[:lines].where { Sequel.|({start_x: 1, start_y: 1}, {start_x: 2,
start_y: 2}) & Sequel.|({ end_x: 1, end_y: 1 }, { end_x: 2, end_y: 2 }) }
# => "SELECT * FROM lines WHERE ((((start_x = 1) AND (start_y = 1)) OR
((start_x = 2) AND (start_y = 2))) AND (((end_x = 1) AND (end_y = 1)) OR
((end_x = 2) AND (end_y = 2))))"
--
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.
