从 ActiveRecord 原始 SQL 获取类型化结果 [英] Getting typed results from ActiveRecord raw SQL

问题描述

在续集中，我可以做到:

In Sequel, I can do:

irb(main):003:0> DB["select false"].get
=> false

返回一个错误的布尔值.我希望能够在 ActiveRecord 中做类似的事情:

Which returns a false boolean. I'd like to be able to do something similar in ActiveRecord:

irb(main):007:0> ActiveRecord::Base.connection.select_value "select false"
=> "f"

如您所见，它返回字符串 "f".有没有办法用 ActiveRecord 得到一个 false 布尔值?(同样，我可能正在调用一个返回时间戳、数组等的函数——我希望返回的值具有正确的类型)

As you can see, it returns the string "f". Is there a way to get a false boolean with ActiveRecord? (Similarly, I might be calling a function that returns a timestamptz, an array, etc -- I'd want the returned value to have the correct type)

我的用例:我正在调用一个数据库函数，想要返回一个输入的结果而不是一个字符串.

My use case: I'm calling a database function, want to get back a typed result instead of a string.

推荐答案

这对我在 rails 5 中有效

This works for me in rails 5

results = ActiveRecord::Base.connection.select_all(sql)
results.rows.map{ |row| Hash[results.columns.zip(row)] }

效果不错

[{"person1"=>563, "person2"=>564, "count"=>1},
 {"person1"=>563, "person2"=>566, "count"=>5},
 {"person1"=>565, "person2"=>566, "count"=>1}]

这篇关于从 ActiveRecord 原始 SQL 获取类型化结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！