mysql - Ruby 续集多个运算符

Question

我如何添加多个运算符来应用它：

where deleted is not null and (status in ('PENDING', 'REMOVING') 
or (status='FAILED' and published_at is null))

与红宝石和续集

标签： mysqlsqlsequel

Answer 1

解决方案是：

.exclude(deleted: nil)
.where(
  Sequel.|(
    { status: %w[PENDING REMOVING] },
    { status: 'FAILED', published_at: nil }
  )
)