diff options
Diffstat (limited to 'activerecord/test/connections')
4 files changed, 97 insertions, 0 deletions
diff --git a/activerecord/test/connections/native_mysql/connection.rb b/activerecord/test/connections/native_mysql/connection.rb new file mode 100644 index 0000000000..b663106d1f --- /dev/null +++ b/activerecord/test/connections/native_mysql/connection.rb @@ -0,0 +1,24 @@ +print "Using native MySQL\n" +require 'fixtures/course' +require 'logger' + +ActiveRecord::Base.logger = Logger.new("debug.log") + +db1 = 'activerecord_unittest' +db2 = 'activerecord_unittest2' + +ActiveRecord::Base.establish_connection( + :adapter => "mysql", + :host => "localhost", + :username => "root", + :password => "", + :database => db1 +) + +Course.establish_connection( + :adapter => "mysql", + :host => "localhost", + :username => "root", + :password => "", + :database => db2 +) diff --git a/activerecord/test/connections/native_postgresql/connection.rb b/activerecord/test/connections/native_postgresql/connection.rb new file mode 100644 index 0000000000..c9b00447f9 --- /dev/null +++ b/activerecord/test/connections/native_postgresql/connection.rb @@ -0,0 +1,24 @@ +print "Using native PostgreSQL\n" +require 'fixtures/course' +require 'logger' + +ActiveRecord::Base.logger = Logger.new("debug.log") + +db1 = 'activerecord_unittest' +db2 = 'activerecord_unittest2' + +ActiveRecord::Base.establish_connection( + :adapter => "postgresql", + :host => nil, + :username => "postgres", + :password => "postgres", + :database => db1 +) + +Course.establish_connection( + :adapter => "postgresql", + :host => nil, + :username => "postgres", + :password => "postgres", + :database => db2 +)
\ No newline at end of file diff --git a/activerecord/test/connections/native_sqlite/connection.rb b/activerecord/test/connections/native_sqlite/connection.rb new file mode 100644 index 0000000000..db688bdb70 --- /dev/null +++ b/activerecord/test/connections/native_sqlite/connection.rb @@ -0,0 +1,34 @@ +print "Using native SQlite\n" +require 'fixtures/course' +require 'logger' +ActiveRecord::Base.logger = Logger.new("debug.log") + +BASE_DIR = File.expand_path(File.dirname(__FILE__) + '/../../fixtures') +sqlite_test_db = "#{BASE_DIR}/fixture_database.sqlite" +sqlite_test_db2 = "#{BASE_DIR}/fixture_database_2.sqlite" + +def make_connection(clazz, db_file, db_definitions_file) + unless File.exist?(db_file) + puts "SQLite database not found at #{db_file}. Rebuilding it." + sqlite_command = "sqlite #{db_file} 'create table a (a integer); drop table a;'" + puts "Executing '#{sqlite_command}'" + `#{sqlite_command}` + clazz.establish_connection( + :adapter => "sqlite", + :dbfile => db_file) + script = File.read("#{BASE_DIR}/db_definitions/#{db_definitions_file}") + # SQLite-Ruby has problems with semi-colon separated commands, so split and execute one at a time + script.split(';').each do + |command| + clazz.connection.execute(command) unless command.strip.empty? + end + else + clazz.establish_connection( + :adapter => "sqlite", + :dbfile => db_file) + end +end + +make_connection(ActiveRecord::Base, sqlite_test_db, 'sqlite.sql') +make_connection(Course, sqlite_test_db2, 'sqlite2.sql') + diff --git a/activerecord/test/connections/native_sqlserver/connection.rb b/activerecord/test/connections/native_sqlserver/connection.rb new file mode 100644 index 0000000000..b198f21c4b --- /dev/null +++ b/activerecord/test/connections/native_sqlserver/connection.rb @@ -0,0 +1,15 @@ +print "Using native SQLServer\n" +require 'fixtures/course' +require 'logger' + +ActiveRecord::Base.logger = Logger.new("debug.log") + +ActiveRecord::Base.establish_connection( + :adapter => "sqlserver", + :dsn => "DBI:ADO:Provider=SQLOLEDB;Data Source=(local);Initial Catalog=test;User Id=sa;Password=password;" +) + +Course.establish_connection( + :adapter => "sqlserver", + :dsn => "DBI:ADO:Provider=SQLOLEDB;Data Source=(local);Initial Catalog=test2;User Id=sa;Password=password;" +) |