Sha256: 52341650356be30a28fe8b856342447c8ae1c7910b61de6341fa3290db1d5f2a

Contents?: true

Size: 1.12 KB

Versions: 33

Compression:

Stored size: 1.12 KB

Contents

require 'jdbc_common'
require 'db/mssql'

ActiveRecord::Schema.verbose = false

class CreateArticles < ActiveRecord::Migration

  def self.up
    execute <<-SQL
      CREATE TABLE articles (
        [id] int NOT NULL IDENTITY(1, 1) PRIMARY KEY, 
        [title] VARCHAR(100), 
        [author] VARCHAR(60) DEFAULT 'anonymous', 
        [body] TEXT
      )
    SQL
  end

  def self.down
    drop_table "articles"
  end

end

class Article < ActiveRecord::Base
end

class MsSQLLegacyTypesTest < Test::Unit::TestCase

  def setup
    CreateArticles.up
    @connection = ActiveRecord::Base.connection
  end

  def teardown
    CreateArticles.down
    ActiveRecord::Base.clear_active_connections!
  end

  def test_varchar_column
    Article.create!(:title => "Blah blah")
    article = Article.first
    assert_equal("Blah blah", article.title)
  end
  
  SAMPLE_TEXT = "Lorem ipsum dolor sit amet ..."
  
  def test_text_column
    Article.create!(:body => SAMPLE_TEXT)
    article = Article.first
    assert_equal(SAMPLE_TEXT, article.body)
  end
  
  def test_varchar_default_value
    assert_equal("anonymous", Article.new.author)
  end
  
end

Version data entries

33 entries across 33 versions & 8 rubygems

Version Path
cmoran92-activerecord-jdbc-adapter-1.2.1.2 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.2.5 test/mssql_legacy_types_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.5 test/mssql_legacy_types_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.4 test/mssql_legacy_types_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.3 test/mssql_legacy_types_test.rb
tgbyte-activerecord-jdbc-adapter-1.2.2.2 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.2.2.1 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-onsite-1.2.2 test/mssql_legacy_types_test.rb
cmoran92-activerecord-jdbc-adapter-1.2.1.1 test/mssql_legacy_types_test.rb
intentmedia-activerecord-jdbc-adapter-1.1.1.1 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.2.2 test/mssql_legacy_types_test.rb
cmoran92-activerecord-jdbc-adapter-1.2.1 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.2.1 test/mssql_legacy_types_test.rb
c3-activerecord-jdbc-adapter-1.1.3.1 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.2.0 test/mssql_legacy_types_test.rb
c3-activerecord-jdbc-adapter-1.1.3 test/mssql_legacy_types_test.rb
jashmenn-activerecord-jdbc-adapter-1.2.0.0 test/mssql_legacy_types_test.rb
jashmenn-activerecord-jdbc-adapter-1.2.0 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.1.3 test/mssql_legacy_types_test.rb
activerecord-jdbc-adapter-1.1.2 test/mssql_legacy_types_test.rb