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

问题描述

在Sequel中，我可以这样做：

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获取错误的布尔值？ （类似地，我可能正在调用一个返回时间戳，数组等的函数-我希望返回的值具有正确的类型）

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.

推荐答案

我陷入困境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屋！