Changed layout to support tagging and branching

1 files changed, 322 insertions, 0 deletions

diff --git a/test/driver/dl/tc_driver.rb b/test/driver/dl/tc_driver.rb
new file mode 100644
index 0000000..3dc59e3
--- /dev/null
+++ b/test/driver/dl/tc_driver.rb
@@ -0,0 +1,322 @@
+#--
+# =============================================================================
+# Copyright (c) 2004, Jamis Buck (jgb3@email.byu.edu)
+# All rights reserved.
+# 
+# Redistribution and use in source and binary forms, with or without
+# modification, are permitted provided that the following conditions are met:
+# 
+#     * Redistributions of source code must retain the above copyright notice,
+#       this list of conditions and the following disclaimer.
+# 
+#     * Redistributions in binary form must reproduce the above copyright
+#       notice, this list of conditions and the following disclaimer in the
+#       documentation and/or other materials provided with the distribution.
+# 
+#     * The names of its contributors may not be used to endorse or promote
+#       products derived from this software without specific prior written
+#       permission.
+# 
+# THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS"
+# AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE
+# IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE
+# DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE
+# FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL
+# DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
+# SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER
+# CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY,
+# OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE
+# OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
+# =============================================================================
+#++
+
+$:.unshift "../../../lib"
+
+require 'sqlite3/constants'
+require 'sqlite3/driver/dl/driver'
+require 'test/unit'
+
+class TC_DL_Driver < Test::Unit::TestCase
+
+  def utf16ify( str )
+    chars = str.split(//)
+    chars.zip(["\0"] * chars.length).flatten.join
+  end
+
+  def setup
+    @driver = SQLite3::Driver::DL::Driver.new
+    @dbname = "test.db"
+    @db = nil
+  end
+
+  def teardown
+    @driver.close( @db ) rescue nil
+    File.delete @dbname rescue nil
+  end
+
+  def test_open
+    result, @db = @driver.open( @dbname )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert File.exist?( @dbname )
+  end
+
+  def test_open_utf16
+    name = utf16ify( @dbname )
+    result, @db = @driver.open( name, true )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert File.exist?( @dbname )
+  end
+
+  def test_errmsg
+    result, @db = @driver.open( @dbname )
+    msg = @driver.errmsg( @db )
+    assert_equal msg, "not an error"
+  end
+
+  def test_errmsg16
+    result, @db = @driver.open( @dbname )
+    msg = @driver.errmsg( @db, true )
+    assert_equal msg, utf16ify( "not an error" )
+  end
+
+  def test_prepare
+    result, @db = @driver.open( @dbname )
+    sql = "create table foo ( a, b )"
+    result, handle, remainder = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert_equal "", remainder
+    @driver.finalize( handle )
+  end
+
+  def test_prepare_error
+    result, @db = @driver.open( @dbname )
+    sql = "create tble foo ( a, b )"
+    result, handle, remainder = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::ERROR, result
+  end
+
+  def test_prepare_remainder
+    result, @db = @driver.open( @dbname )
+    sql = "create table foo ( a, b ); select * from foo"
+    result, handle, remainder = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert_equal " select * from foo", remainder
+    @driver.finalize( handle )
+  end
+
+  def test_prepare16
+    result, @db = @driver.open( @dbname )
+    sql = utf16ify( "create table foo ( a, b )" )
+    result, handle, remainder = @driver.prepare( @db, sql, true )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert_equal "", remainder
+    @driver.finalize( handle )
+  end
+
+  def test_prepare16_remainder
+    result, @db = @driver.open( @dbname )
+    sql = utf16ify( "create table foo ( a, b ); select * from foo" )
+    result, handle, remainder = @driver.prepare( @db, sql, true )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert_equal utf16ify( " select * from foo" ), remainder
+    @driver.finalize( handle )
+  end
+
+  def test_complete
+    assert @driver.complete?( "select * from foo;" )
+  end
+
+  def test_complete_fail
+    assert !@driver.complete?( "select * from foo" )
+  end
+
+  def test_complete16
+    assert @driver.complete?( utf16ify("select * from foo;"), true )
+  end
+
+  def create_foo
+    result, @db = @driver.open( @dbname )
+    sql = "create table foo ( a, b )"
+    result, handle, = @driver.prepare( @db, sql )
+    @driver.step( handle )
+    @driver.finalize( handle )
+  end
+
+  def populate_foo
+    create_foo
+    sql = "insert into foo values ( 100, 200 )"
+    result, handle, = @driver.prepare( @db, sql )
+    @driver.step( handle )
+    @driver.finalize( handle )
+  end
+
+  def test_step
+    populate_foo
+    sql = "select * from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    @driver.finalize( handle )
+  end
+
+  def test_step_fail
+    populate_foo
+    sql = "select * from"
+    result, handle, = @driver.prepare( @db, sql )
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::MISUSE, result
+    @driver.finalize( handle )
+  end
+
+  def test_bind_blob
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_blob( handle, 1, "a\0b\1c\2d\0e" )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal "a\0b\1c\2d\0e", @driver.column_blob( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_double
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_double( handle, 1, 3.14 )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal 3.14, @driver.column_double( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_int
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_int( handle, 1, 14 )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal 14, @driver.column_int( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_null
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_null( handle, 1 )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal SQLite3::Constants::ColumnType::NULL,
+      @driver.column_type( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_text
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_text( handle, 1, "hello, world" )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal "hello, world", @driver.column_text( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_text16
+    create_foo
+    sql = "insert into foo (b) values (?)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_text( handle, 1, utf16ify("hello, world"), true )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::DONE, result
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    sql = "select b from foo"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.step( handle )
+    assert_equal SQLite3::Constants::ErrorCode::ROW, result
+    assert_equal "hello, world", @driver.column_text( handle, 0 )
+    result = @driver.finalize( handle )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+  end
+
+  def test_bind_parameter_index
+    create_foo
+    sql = "insert into foo (b) values (:hello)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    result = @driver.bind_parameter_index( handle, ":hello" )
+    assert_equal 1, result
+    result = @driver.bind_parameter_index( handle, ":foo" )
+    assert_equal 0, result
+    @driver.finalize( handle )
+  end
+
+  def test_bind_parameter_name
+    create_foo
+    sql = "insert into foo (a,b) values (?,:foo)"
+    result, handle, = @driver.prepare( @db, sql )
+    assert_equal SQLite3::Constants::ErrorCode::OK, result
+    assert_nil nil, @driver.bind_parameter_name(handle,1)
+    assert_equal ":foo", @driver.bind_parameter_name(handle,2)
+    @driver.finalize( handle )
+  end
+
+end