Contents

require 'jdbc_common'
require 'db/mssql'

class MSSQLIgnoreSystemViewsTest < Test::Unit::TestCase
  include MigrationSetup

  def test_system_views_ignored
    assert_not_include tables, 'views'
    if ActiveRecord::Base.connection.sqlserver_version == "2000"
      assert_false table_exists?("sys.views"), %{table_exists?("sys.views")}
      assert_false table_exists?("information_schema.views"), %{table_exists?("information_schema.views")}
    else
      assert_true table_exists?("sys.views"), %{table_exists?("sys.views")}
      assert_true table_exists?("information_schema.views"), %{table_exists?("information_schema.views")}
      
      assert_true table_exists?(:views), %{table_exists?(:views)}
    end
    assert_false table_exists?("dbo.views"), %{table_exists?("dbo.views")}
    #assert_false table_exists?(:views), %{table_exists?(:views)}
    ActiveRecord::Schema.define { suppress_messages { create_table :views } }
    assert_include tables, 'views'
    assert_true table_exists?(:views), %{table_exists?(:views)}
    ActiveRecord::Schema.define { suppress_messages { drop_table :views } }
    #assert_false table_exists?(:views), %{table_exists?(:views)}
  ensure
    ActiveRecord::Base.connection.drop_table(:views) rescue nil
  end

  private

  def tables
    ActiveRecord::Base.connection.tables
  end
  
  def table_exists?(*args)
    ActiveRecord::Base.connection.table_exists?(*args)
  end
    
end

Version data entries

2 entries across 2 versions & 1 rubygems

Version	Path
activerecord-jdbc-adapter-1.3.0.beta2	test/db/mssql/ignore_system_views_test.rb
activerecord-jdbc-adapter-1.3.0.beta1	test/db/mssql/ignore_system_views_test.rb