spec_helper.rb in shinq-1.0.0.rc1

- old
+ new

@@ -1,9 +1,15 @@
+ENV['RAILS_ENV'] ||= 'test'
+$LOAD_PATH << File.expand_path('../helpers', __FILE__)
+
 require 'rspec/mocks/standalone'
 require 'simplecov'
+require 'erb'
 require 'yaml'
 require 'active_support/core_ext/hash'
+require 'mysql2'
+require 'timecop'
 
 def load_database_config
   db_config = YAML.load_file(File.expand_path('./config/database.yml', __dir__)).symbolize_keys
 end
 
@@ -23,11 +29,22 @@
     config.full_backtrace = true
     config.default_formatter = 'doc'
   end
 
   config.before(:suite) do
+    # MySQL on Travis does not have Q4M plugins.
+    # We use QUEUE engine and run Q4M specific spec (integration_spec) only when ENV['TRAVIS'] is nil.
+    engine = ENV['TRAVIS'] ? 'InnoDB' : 'QUEUE' # Travis MySQL does not have Q4M plugins.
+    sql = ERB.new(File.read(File.expand_path('./db/structure.sql.erb', __dir__))).result(binding)
+
     connection = Mysql2::Client.new(load_database_config[:test].merge(flags: Mysql2::Client::MULTI_STATEMENTS))
-    connection.query(File.read(File.expand_path('./db/structure.sql', __dir__)))
+    result = connection.query(sql)
+
+    while connection.next_result
+      connection.store_result
+    end
+
+    connection.close
   end
 
   config.order = :random
   Kernel.srand config.seed
 end