[Rails] establish_connection(:other_database) in model is still called in tests

[belgoros]

I have to establish connection to a database different than defined for 
development environment.
Here is how I added the specific connection to *database.yml*:

default:
...


development:
...


test:
....


mystore:
  adapter: oracle_enhanced
  host: <%= ENV['mystore_db_host']%>
  port: <%= ENV['mystore_db_port']%>
  database: <%= ENV['mystore_db_name']%>
  username: <%= ENV['mystore_db_user']%>
  password: <%= ENV['mystore_db_password']%>

So I create a base model class as follows:

module MystoreMigration
  class MystoreModel < ApplicationRecord
    establish_connection(:mystore) unless Rails.env.test?
  end
end

Than I have some model defined that inherit the above class, for example:

module MystoreMigration
  class StoreInfo < MystoreModel
...
  end
end

It works fine in development environment but when running tests and mocking 
the above models, Rails is still trying to establish the connection.
To make it work, I had to add the same environment variables to *test* 
section in *Figaro* gem *application.yml* file:

development:
  mystore_db_host: "XXXX"
  mystore_db_port: "XXXX"
  mystore_db_name: "XXXX"
  mystore_db_user: "XXXX"
  mystore_db_password: "XXXX"


....
test:
  mystore_db_host: "XXXX"
  mystore_db_port: "XXXX"
  mystore_db_name: "XXXX"
  mystore_db_user: "XXXX"
  mystore_db_password: "XXXX"

If I remove the variables from test environment, the following simple test 
where I mock the model class as follows:

RSpec.describe MystoreMigration::StoreMigrator do


  let(:shop) { build(:shop) }
  let(:store) { double(MystoreMigration::StoreInfo)}
  let(:store_migrator) { MystoreMigration::StoreMigrator.new([store]) }


  describe 'initialization' do
    it 'should have stores initialized' do
      expect(store_migrator.stores).not_to be_empty
    end
  end

Class under test (just to chesk the constructor):

module MystoreMigration
  class StoreMigrator


  def initialize(stores = [])
      @stores = stores
    end
...


 fails with error:

OCIError:

       ORA-12162: TNS:net service name is incorrectly specified

     # oci8.c:561:in oci8lib_250.bundle

     # 
/Users/Serguei/.rvm/gems/ruby-2.5.0/gems/ruby-oci8-2.2.5.1/lib/oci8/oci8.rb:142:in
 
`initialize'

What's wrong with that ? Thank you.

-- 
You received this message because you are subscribed to the Google Groups "Ruby 
on Rails: Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to rubyonrails-talk+unsubscr...@googlegroups.com.
To post to this group, send email to rubyonrails-talk@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/rubyonrails-talk/abb916cf-4504-41f3-aad8-6996f2ceef0f%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.