ActiveRecord是否支持where子句中的元组,假设底层数据库这样做?
结果where子句看起来像这样:where (name, address) in (('John', '123 Main St'))
我试着:
Person.where({[:name, :address] => ['John', '123 Main St']})
tupleArray = [['John', '123 Main St'],['Jane', '124 Main St']]
Person.where("(name, address) IN (#{(['(?)']*tupleArray.size).join(', ')})", *tupleArray)
Person.where("(name, address) IN ((?))", ['John', '123 Main St'])