Sha256: 761b67436fa783090f03b70df6ce4680b9163bcf6987dfaf51c6544bf71c6cfe

Contents?: true

Size: 1.78 KB

Versions: 79

Compression:

Stored size: 1.78 KB

Contents

# The filename begins with "aaa" to ensure this is the first test.
require 'abstract_unit'

class AAACreateTablesTest < Test::Unit::TestCase
  self.use_transactional_fixtures = false

  def setup
    @base_path = "#{File.dirname(__FILE__)}/fixtures/db_definitions"
  end

  def test_drop_and_create_main_tables
    recreate ActiveRecord::Base
    assert true
  end

  def test_load_schema
    if ActiveRecord::Base.connection.supports_migrations?
      eval(File.read("#{File.dirname(__FILE__)}/fixtures/db_definitions/schema.rb"))
    else
      recreate ActiveRecord::Base, '3'
    end
    assert true
  end
  
  def test_drop_and_create_courses_table
    recreate Course, '2'
    assert true
  end

  private
    def recreate(base, suffix = nil)
      connection = base.connection
      adapter_name = connection.adapter_name.downcase + suffix.to_s
      execute_sql_file "#{@base_path}/#{adapter_name}.drop.sql", connection
      execute_sql_file "#{@base_path}/#{adapter_name}.sql", connection
    end

    def execute_sql_file(path, connection)
      # OpenBase has a different format for sql files
      if current_adapter?(:OpenBaseAdapter) then
          File.read(path).split("go").each_with_index do |sql, i|
            begin
              # OpenBase does not support comments embedded in sql
              connection.execute(sql,"SQL statement ##{i}") unless sql.blank?
            rescue ActiveRecord::StatementInvalid
              #$stderr.puts "warning: #{$!}"
            end
          end
      else
        File.read(path).split(';').each_with_index do |sql, i|
          begin
            connection.execute("\n\n-- statement ##{i}\n#{sql}\n") unless sql.blank?
          rescue ActiveRecord::StatementInvalid
            #$stderr.puts "warning: #{$!}"
          end
        end
      end
    end
end

Version data entries

79 entries across 79 versions & 6 rubygems

Version Path
backlog-0.0.4 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.1.0 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.1.1 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.1.2 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.2.0 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.2.1 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.0 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.2 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.1 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.3 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.4 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.6 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.5 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.8 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.7 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.3.9 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.4.0 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.5.0 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.5.1 vendor/rails/activerecord/test/aaa_create_tables_test.rb
backlog-0.5.10 vendor/rails/activerecord/test/aaa_create_tables_test.rb