Sha256: 5b7f240b2f25c5a0aea473fb80472daafe335d227a71da047af2fcfedaa4386c
Contents?: true
Size: 1.04 KB
Versions: 109
Compression:
Stored size: 1.04 KB
Contents
require 'helper'
module SQLite3
class TestResultSet < SQLite3::TestCase
def setup
@db = SQLite3::Database.new ':memory:'
super
end
def teardown
super
@db.close
end
def test_each_hash
@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
rs.close
end
def test_next_hash
@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
rs.close
end
end
end
Version data entries
109 entries across 109 versions & 2 rubygems