Use schema.rb for all databases

Move adapter specific schema into their own files

Signed-off-by: Michael Koziarski <michael@koziarski.com>

1 files changed, 7 insertions, 51 deletions

diff --git a/activerecord/test/cases/aaa_create_tables_test.rb b/activerecord/test/cases/aaa_create_tables_test.rb
index 32e0d2936e..3911afac49 100644
--- a/activerecord/test/cases/aaa_create_tables_test.rb
+++ b/activerecord/test/cases/aaa_create_tables_test.rb
@@ -4,65 +4,21 @@ require "cases/helper"
 class AAACreateTablesTest < ActiveRecord::TestCase
   self.use_transactional_fixtures = false
 
-  def test_drop_and_create_main_tables
-    recreate ActiveRecord::Base unless use_migrations?
-    assert true
-  end
-
   def test_load_schema
-    if ActiveRecord::Base.connection.supports_migrations?
-      eval(File.read(SCHEMA_ROOT + "/schema.rb"))
-    else
-      recreate ActiveRecord::Base, '3'
+    eval(File.read(SCHEMA_ROOT + "/schema.rb"))
+    if File.exists?(adapter_specific_schema_file)
+      eval(File.read(adapter_specific_schema_file))
     end
     assert true
   end
 
   def test_drop_and_create_courses_table
-    if Course.connection.supports_migrations?
-      eval(File.read(SCHEMA_ROOT + "/schema2.rb"))
-    end
-    recreate Course, '2' unless use_migrations_for_courses?
+    eval(File.read(SCHEMA_ROOT + "/schema2.rb"))
     assert true
   end
 
   private
-    def use_migrations?
-      unittest_sql_filename = ActiveRecord::Base.connection.adapter_name.downcase + ".sql"
-      not File.exist? SCHEMA_ROOT + "/#{unittest_sql_filename}"
-    end
-
-    def use_migrations_for_courses?
-      unittest2_sql_filename = ActiveRecord::Base.connection.adapter_name.downcase + "2.sql"
-      not File.exist? SCHEMA_ROOT + "/#{unittest2_sql_filename}"
-    end
-
-    def recreate(base, suffix = nil)
-      connection = base.connection
-      adapter_name = connection.adapter_name.downcase + suffix.to_s
-      execute_sql_file SCHEMA_ROOT + "/#{adapter_name}.drop.sql", connection
-      execute_sql_file SCHEMA_ROOT + "/#{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
+  def adapter_specific_schema_file
+    SCHEMA_ROOT + '/' + ActiveRecord::Base.connection.adapter_name.downcase + '_specific_schema.rb'
+  end
 end