Rails 怎么让 or 语句变得的优美

111eo · January 21, 2021 · Last by jasonZYJ replied at January 21, 2021 · 503 hits
# 例如常见的
User.where("id = 1 or name = '1'")

大家平常都是怎么使用 or 的呢?

User.where(id: 1).or(User.where(name:'1')).to_sql
# "SELECT `users`.* FROM `users` WHERE (`users`.`id` = 1 OR `users`.`name` = '1')"

User.where(User.arel_table[:id].eq(1).or(User.arel_table[:name].eq('1'))).to_sql
#"SELECT `users`.* FROM `users` WHERE (`users`.`id` = 1 OR `users`.`name` = '1')"

You need to Sign in before reply, if you don't have an account, please Sign up first.