forked from thiagopradi/octopus
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Rakefile
146 lines (117 loc) · 4.36 KB
/
Rakefile
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
require 'bundler/gem_tasks'
require 'rspec/core/rake_task'
require 'appraisal'
task :default => :spec
RSpec::Core::RakeTask.new(:spec) do |spec|
end
namespace :db do
desc 'Build the databases for tests'
task :build_databases do
pg_spec = {
:adapter => 'postgresql',
:host => 'localhost',
:username => (ENV['POSTGRES_USER'] || "postgres"),
:encoding => 'utf8'
}
mysql_spec = {
:adapter => 'mysql',
:host => 'localhost',
:username => (ENV['MYSQL_USER'] || "root"),
:encoding => 'utf8'
}
%x( rm -f /tmp/database.sqlite3 )
require "active_record"
# Connects to PostgreSQL
ActiveRecord::Base.establish_connection(pg_spec.merge('database' => 'postgres', 'schema_search_path' => 'public'))
(1..2).map do |i|
# drop the old database (if it exists)
ActiveRecord::Base.connection.drop_database("octopus_shard_#{i}")
# create new database
ActiveRecord::Base.connection.create_database("octopus_shard_#{i}")
end
# Connect to MYSQL
ActiveRecord::Base.establish_connection(mysql_spec)
(1..5).map do |i|
# drop the old database (if it exists)
ActiveRecord::Base.connection.drop_database("octopus_shard_#{i}")
# create new database
ActiveRecord::Base.connection.create_database("octopus_shard_#{i}")
end
end
desc 'Create tables on tests databases'
task :create_tables do
require "octopus"
# Set the octopus variable directory to spec dir, in order to load the config/shards.yml file.
Octopus.instance_variable_set(:@directory, "#{File.dirname(__FILE__)}/spec/" )
# Require the database connection
require "#{File.dirname(__FILE__)}/spec/support/database_connection"
[:master, :brazil, :canada, :russia, :alone_shard, :postgresql_shard, :sqlite_shard, :protocol_shard].each do |shard_symbol|
# Rails 3.1 needs to do some introspection around the base class, which requires
# the model be a descendent of ActiveRecord::Base.
class BlankModel < ActiveRecord::Base; end;
BlankModel.using(shard_symbol).connection.initialize_schema_migrations_table()
BlankModel.using(shard_symbol).connection.create_table(:users) do |u|
u.string :name
u.integer :number
u.boolean :admin
u.datetime :created_at
u.datetime :updated_at
end
BlankModel.using(shard_symbol).connection.create_table(:clients) do |u|
u.string :country
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:cats) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:items) do |u|
u.string :name
u.integer :client_id
end
BlankModel.using(shard_symbol).connection.create_table(:computers) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:keyboards) do |u|
u.string :name
u.integer :computer_id
end
BlankModel.using(shard_symbol).connection.create_table(:roles) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:permissions) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:permissions_roles, :id => false) do |u|
u.integer :role_id
u.integer :permission_id
end
BlankModel.using(shard_symbol).connection.create_table(:assignments) do |u|
u.integer :programmer_id
u.integer :project_id
end
BlankModel.using(shard_symbol).connection.create_table(:programmers) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:projects) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:comments) do |u|
u.string :name
u.string :commentable_type
u.integer :commentable_id
end
BlankModel.using(shard_symbol).connection.create_table(:parts) do |u|
u.string :name
u.integer :item_id
end
BlankModel.using(shard_symbol).connection.create_table(:yummy) do |u|
u.string :name
end
BlankModel.using(shard_symbol).connection.create_table(:adverts) do |u|
u.string :name
end
end
end
desc 'Prepare the test databases'
task :prepare => [:build_databases, :create_tables]
end