Contents

class TestODBCStatement < DBDConfig.testbase(:odbc)
    def test_column_info
        sth = nil
        
        assert_nothing_raised do 
            sth = @dbh.prepare("select * from names")
            sth.execute
        end

        assert_kind_of Array, sth.column_info 
        assert_kind_of DBI::ColumnInfo, sth.column_info[0]
        assert_kind_of DBI::ColumnInfo, sth.column_info[1]
        assert_equal [
            {
                :table=>"names", 
                :precision=>255, 
                :searchable=>true, 
                :name=>"name", 
                :unsigned=>true, 
                :length=>255, 
                :sql_type=>12, 
                :scale=>0, 
                :nullable=>true, 
                :type_name=>"VARCHAR"
            },
            {
                :table=>"names", 
                :precision=>10, 
                :searchable=>true, 
                :name=>"age", 
                :unsigned=>false, 
                :length=>4, 
                :sql_type=>4, 
                :scale=>0, 
                :nullable=>true, 
                :type_name=>"INTEGER"
            }
        ], sth.column_info

        sth.finish
    end
end

Version data entries

3 entries across 3 versions & 1 rubygems

Version	Path
dbd-odbc-0.2.2	test/dbd/odbc/test_statement.rb
dbd-odbc-0.2.3	test/dbd/odbc/test_statement.rb
dbd-odbc-0.2.4	test/dbd/odbc/test_statement.rb