Question

Closed. This question needs details or clarity. It is not currently accepting answers.

Want to improve this question? Add details and clarify the problem by editing this post.

Closed 9 years ago.

我有两个问题:

Model.where(:a =>  1 , b =>  2 , c =>  3 , d =>  4 )
Model.where(:e =>  5 , f =>  6 )

使工会取得以下结果是否是一种良好(或有效的)做法?

models = Model.where(:a =>  1 , b =>  2 , c =>  3 , d =>  4 )
models += Model.where(:e =>  5 , f =>  6 )

铁路工程3.07。这不是事实。例如,它简化了。

EDIT: Sorry, I was not explicit. The goal is to get the union (the sum of results).

Answer 1

如果两套结果出现重叠,你可能会获得重复价值。而用管道操作者:

models = Model.where(:a =>  1 , b =>  2 , c =>  3 , d =>  4 ) | Model.where(:e =>  5 , f =>  6 )

Answer 2

Model.where("(a =  1  AND b =  2  AND c =  3  AND d =  4 ) OR (e =  5  AND f =  6 )")

它可能不是针对你的特殊情况,而是至少只提出一个问题。

In any case, don t forget to reject SQL injection.

Answer 3

在本案中,你获得我相信你想要的结果。 rel rel queries queries queries queries

:a =>  1 , b =>  2 , c =>  3 , d =>  4 , :e =>  5 , f =>  6

如果这是你想要的,这一链条就完全合理。

如果是这样的话,你想要把两个问题的结果结合起来,那么你很可能想像:

models = Model.where(:a =>  1 , b =>  2 , c =>  3 , d =>  4 ).all.to_a + Model.where(:e =>  5 , f =>  6 ).all.to_a