Class: Testjour::MysqlDatabaseSetup

Inherits:
Object
  • Object
show all
Defined in:
lib/testjour/mysql.rb

Overview

Stolen from deep-test

Class Attribute Summary collapse

Class Method Summary collapse

Instance Method Summary collapse

Class Attribute Details

.admin_configuration ⇒ Object

ActiveRecord configuration to use when connecting to MySQL to create databases, drop database, and grant privileges. By default, connects to information_schema on localhost as root with no password.



15
16
17
 
# File 'lib/testjour/mysql.rb', line 15

def admin_configuration
  @admin_configuration
end

Class Method Details

.with_new_database ⇒ Object 



25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
 
# File 'lib/testjour/mysql.rb', line 25

def self.with_new_database
  ENV["RAILS_ENV"] ||= "test"
  require File.expand_path("./vendor/rails/railties/lib/initializer")
  Rails::Initializer.run(:set_load_path)
  
  require "active_record"
  require "active_record/connection_adapters/mysql_adapter"
  
  mysql = self.new
  mysql.create_database
  
  ENV["TESTJOUR_DB"] = mysql.runner_database_name
  
  at_exit do
    mysql.drop_database
  end
  
  mysql.connect
  mysql.load_schema
  
  yield
end

Instance Method Details

#admin_connection ⇒ Object 



80
81
82
83
84
85
 
# File 'lib/testjour/mysql.rb', line 80

def admin_connection
  conn = ActiveRecord::Base.mysql_connection(self.class.admin_configuration)
  yield conn
ensure
  conn.disconnect! if conn
end

#connect ⇒ Object 



70
71
72
 
# File 'lib/testjour/mysql.rb', line 70

def connect
  ActiveRecord::Base.establish_connection(self.class.admin_configuration.merge(:database => runner_database_name))
end

#create_database ⇒ Object 



57
58
59
60
61
62
 
# File 'lib/testjour/mysql.rb', line 57

def create_database
  admin_connection do |connection|
    connection.recreate_database runner_database_name
    grant_privileges(connection)
  end
end

#drop_database ⇒ Object 



64
65
66
67
68
 
# File 'lib/testjour/mysql.rb', line 64

def drop_database
  admin_connection do |connection|
    connection.drop_database runner_database_name
  end
end

#grant_privileges(connection) ⇒ Object 



48
49
50
51
52
53
54
55
 
# File 'lib/testjour/mysql.rb', line 48

def grant_privileges(connection)
  sql = %{grant all on #{runner_database_name}.* 
      to %s@'localhost' identified by %s;} % [
    connection.quote(self.class.admin_configuration[:username]),
    connection.quote(self.class.admin_configuration[:password] || "")
  ]
  connection.execute sql
end

#load_schema ⇒ Object 



74
75
76
77
78
 
# File 'lib/testjour/mysql.rb', line 74

def load_schema
  # silence_stream(STDOUT) do
    load File.join(RAILS_ROOT, "db", "schema.rb")
  # end
end

#runner_database_name ⇒ Object 



87
88
89
 
# File 'lib/testjour/mysql.rb', line 87

def runner_database_name
  @runner_database_name ||= "testjour_runner_#{rand(1_000)}"
end