Sha256: dc844c69b91b8bee7b272dd58c94b0ccec69df4ba6c059a8fe9aeb7012389a07
Contents?: true
Size: 978 Bytes
Versions: 294
Compression:
Stored size: 978 Bytes
Contents
require 'helper'
module SQLite3
class TestResultSet < SQLite3::TestCase
def test_each_hash
db = SQLite3::Database.new ':memory:'
db.execute "create table foo ( a integer primary key, b text )"
list = ('a'..'z').to_a
list.each do |t|
db.execute "insert into foo (b) values (\"#{t}\")"
end
rs = db.prepare('select * from foo').execute
rs.each_hash do |hash|
assert_equal list[hash['a'] - 1], hash['b']
end
end
def test_next_hash
db = SQLite3::Database.new ':memory:'
db.execute "create table foo ( a integer primary key, b text )"
list = ('a'..'z').to_a
list.each do |t|
db.execute "insert into foo (b) values (\"#{t}\")"
end
rs = db.prepare('select * from foo').execute
rows = []
while row = rs.next_hash
rows << row
end
rows.each do |hash|
assert_equal list[hash['a'] - 1], hash['b']
end
end
end
end
Version data entries
294 entries across 257 versions & 25 rubygems