require "cases/helper"
module ActiveRecord
class ResultTest < ActiveRecord::TestCase
def result
Result.new(["col_1", "col_2"], [
["row 1 col 1", "row 1 col 2"],
["row 2 col 1", "row 2 col 2"],
["row 3 col 1", "row 3 col 2"],
])
end
test "length" do
assert_equal 3, result.length
end
test "to_hash returns row_hashes" do
assert_equal [
{"col_1" => "row 1 col 1", "col_2" => "row 1 col 2"},
{"col_1" => "row 2 col 1", "col_2" => "row 2 col 2"},
{"col_1" => "row 3 col 1", "col_2" => "row 3 col 2"},
], result.to_hash
end
test "first returns first row as a hash" do
assert_equal(
{"col_1" => "row 1 col 1", "col_2" => "row 1 col 2"}, result.first)
end
test "last returns last row as a hash" do
assert_equal(
{"col_1" => "row 3 col 1", "col_2" => "row 3 col 2"}, result.last)
end
test "each with block returns row hashes" do
result.each do |row|
assert_equal ["col_1", "col_2"], row.keys
end
end
test "each without block returns an enumerator" do
result.each.with_index do |row, index|
assert_equal ["col_1", "col_2"], row.keys
assert_kind_of Integer, index
end
end
if Enumerator.method_defined? :size
test "each without block returns a sized enumerator" do
assert_equal 3, result.each.size
end
end
test "cast_values returns rows after type casting" do
values = [["1.1", "2.2"], ["3.3", "4.4"]]
columns = ["col1", "col2"]
types = { "col1" => Type::Integer.new, "col2" => Type::Float.new }
result = Result.new(columns, values, types)
assert_equal [[1, 2.2], [3, 4.4]], result.cast_values
end
test "cast_values uses identity type for unknown types" do
values = [["1.1", "2.2"], ["3.3", "4.4"]]
columns = ["col1", "col2"]
types = { "col1" => Type::Integer.new }
result = Result.new(columns, values, types)
assert_equal [[1, "2.2"], [3, "4.4"]], result.cast_values
end
test "cast_values returns single dimensional array if single column" do
values = [["1.1"], ["3.3"]]
columns = ["col1"]
types = { "col1" => Type::Integer.new }
result = Result.new(columns, values, types)
assert_equal [1, 3], result.cast_values
end
test "cast_values can receive types to use instead" do
values = [["1.1", "2.2"], ["3.3", "4.4"]]
columns = ["col1", "col2"]
types = { "col1" => Type::Integer.new, "col2" => Type::Float.new }
result = Result.new(columns, values, types)
assert_equal [[1.1, 2.2], [3.3, 4.4]], result.cast_values("col1" => Type::Float.new)
end
end
end
