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.



13
14
15
 
# File 'lib/testjour/mysql.rb', line 13

def admin_configuration
  @admin_configuration
end

Class Method Details

.with_new_database ⇒ Object 



23
24
25
26
27
28
29
30
31
32
33
34
35
 
# File 'lib/testjour/mysql.rb', line 23

def self.with_new_database
  mysql = self.new
  mysql.create_database
  
  at_exit do
    mysql.drop_database
  end
  
  mysql.connect
  mysql.load_schema
  
  yield
end

Instance Method Details

#admin_connection ⇒ Object 



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

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

#connect ⇒ Object 



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

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

#create_database ⇒ Object 



46
47
48
49
50
51
 
# File 'lib/testjour/mysql.rb', line 46

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

#drop_database ⇒ Object 



53
54
55
56
57
 
# File 'lib/testjour/mysql.rb', line 53

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

#grant_privileges(connection) ⇒ Object 



37
38
39
40
41
42
43
44
 
# File 'lib/testjour/mysql.rb', line 37

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 



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

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

#runner_database_name ⇒ Object 



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

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