Contents

require File.expand_path('helper', File.dirname(__FILE__))

module SQLite3
  class TestBackup < Test::Unit::TestCase
    def setup
      @sdb = SQLite3::Database.new(':memory:')
      @ddb = SQLite3::Database.new(':memory:')
      @sdb.execute('CREATE TABLE foo (idx, val);');
      @data = ('A'..'Z').map{|x|x * 40}
      @data.each_with_index do |v, i|
        @sdb.execute('INSERT INTO foo (idx, val) VALUES (?, ?);', [i, v])
      end
    end

    def test_backup_step
      b = SQLite3::Backup.new(@ddb, 'main', @sdb, 'main')
      while b.step(1) == SQLite3::Constants::ErrorCode::OK
        assert_not_equal(0, b.remaining)
      end
      assert_equal(0, b.remaining)
      b.finish
      assert_equal(@data.length, @ddb.execute('SELECT * FROM foo;').length)
    end

    def test_backup_all
      b = SQLite3::Backup.new(@ddb, 'main', @sdb, 'main')
      assert_equal(SQLite3::Constants::ErrorCode::DONE, b.step(-1))
      assert_equal(0, b.remaining)
      b.finish
      assert_equal(@data.length, @ddb.execute('SELECT * FROM foo;').length)
    end
  end
end

Version data entries

7 entries across 7 versions & 2 rubygems

Version	Path
sqlite3-1.3.3-x86-mswin32-60	test/test_backup.rb
sqlite3-1.3.3-x86-mingw32	test/test_backup.rb
sqlite3-1.3.3	test/test_backup.rb
sqlite3-1.3.3.beta.1	test/test_backup.rb
sqlite3-ruby-1.3.2	test/test_backup.rb
sqlite3-ruby-1.3.2-x86-mswin32-60	test/test_backup.rb
sqlite3-ruby-1.3.2-x86-mingw32	test/test_backup.rb