test/test_database.rb in extralite-1.27 vs test/test_database.rb in extralite-2.0
- old
+ new
@@ -174,11 +174,11 @@
when /linux/
@db.load_extension(File.join(__dir__, 'extensions/text.so'))
when /darwin/
@db.load_extension(File.join(__dir__, 'extensions/text.dylib'))
end
-
+
r = @db.query_single_value("select reverse('abcd')")
assert_equal 'dcba', r
end
def test_tables
@@ -283,11 +283,11 @@
def test_database_busy_timeout
fn = "/tmp/extralite-#{rand(10000)}.db"
db1 = Extralite::Database.new(fn)
db2 = Extralite::Database.new(fn)
-
+
db1.query('begin exclusive')
assert_raises(Extralite::BusyError) { db2.query('begin exclusive') }
db2.busy_timeout = 3
t0 = Time.now
@@ -347,20 +347,20 @@
if Extralite.sqlite3_version >= '3.38.5'
assert_equal 7, @db.error_offset
end
@db.query('create table t2 (v not null)')
-
+
assert_raises(Extralite::Error) { @db.query('insert into t2 values (null)') }
assert_equal Extralite::SQLITE_CONSTRAINT_NOTNULL, @db.errcode
assert_equal 'NOT NULL constraint failed: t2.v', @db.errmsg
end
def test_close_with_open_prepared_statement
- stmt = @db.prepare('select * from t')
- stmt.query
+ query = @db.prepare('select * from t')
+ query.next
@db.close
end
end
class ScenarioTest < MiniTest::Test
@@ -437,18 +437,18 @@
assert_equal ['select 1'], sqls
@db.query('select 2')
assert_equal ['select 1', 'select 2'], sqls
- stmt = @db.prepare('select 3')
-
- stmt.query
+ query = @db.prepare('select 3')
+
+ query.to_a
assert_equal ['select 1', 'select 2', 'select 3'], sqls
# turn off
@db.trace
- stmt.query
+ query.to_a
@db.query('select 4')
assert_equal ['select 1', 'select 2', 'select 3'], sqls
end
end