rspec for multiple database

[zgid123]

Hi,

I am using shard_resolver of Rails to handle switching database for Rails.

When I create a data test, I need to switch database connection and then create data.

let!(:tenant_1_user) do
  ActiveRecord::Tasks::DatabaseTasks.with_temporary_connection(tenant_1_db_config) do
    create(:user)
  end
end

I can get the record with the variable tenant_1_user, but in the controller (I am using request test), I run

def show
  p User.all
end

there is no user.

Is there anyway to do test for shard_resolver at the moment? If not, I guess I need to create test data to the database instead of memory

[pirj]

If you set a breakpoint in your controller, can you confirm that the User connection goes to the same shard where you created test data?

[zgid123]

yes, I run the byebug when running the test to make sure if the data is created in different shard or not. It seems the config is correct. I still not write the unit test with the wrapper ActiveRecord::Base.transaction.

Lemme create a test repository and debug again. I will put the test repo here asap.

Thanks for the reply

[zgid123]

here is the test repo

https://github.com/zgid123/test-rspec-multiple-database

the code is ugly because it is for testing. Sorry about that.

Honestly, I am trying to write a helper for my gem tenant_realm to do unit test with rspec. My production is just stable with multi-tenant. Now I just wanna add unit test. Maybe I config it wrong for rspec. Please let me know if my config is wrong somewhere.

Thank you.

[pirj]

There shouldn’t be any special configuration fo RSpec. It’s the code that juggles connections shold turn on the right one in each context.

Are you sure that the same db connection is used in both the setup code and the controller? Can you check by running the spec and setting breakpoints in two those points?

[zgid123]

yup, the connection is correct. If you check my test repo, it will put those info

"create user from test_rspec_multiple_database_1_test"
"create user from test_rspec_multiple_database_2_test"
"test controller from test_rspec_multiple_database_1_test"
#<ActiveRecord::Relation []>
"data tenant_1_user"
#<User id: 19, email: "gary@thiel-howell.example_1", first_name: nil, last_name: nil, created_at: "2024-03-21 16:14:00.309870000 +0000", updated_at: "2024-03-21 16:14:00.309870000 +0000">
F"create user from test_rspec_multiple_database_1_test"
"create user from test_rspec_multiple_database_2_test"
"test controller from test_rspec_multiple_database_2_test"
#<ActiveRecord::Relation []>
"data tenant_2_user"
#<User id: 24, email: "faustina@becker.test_4", first_name: nil, last_name: nil, created_at: "2024-03-21 16:14:00.467444000 +0000", updated_at: "2024-03-21 16:14:00.467444000 +0000">
F

# frozen_string_literal: true

require 'rails_helper'

root_db_config = TenantRealm::DbContext.root_db_config
tenant_1_db_config = root_db_config.merge(database: 'test_rspec_multiple_database_1_test')
tenant_2_db_config = root_db_config.merge(database: 'test_rspec_multiple_database_2_test')

RSpec.describe UsersController, type: :request do
  let!(:tenant_1_user) do
    ActiveRecord::Tasks::DatabaseTasks.with_temporary_connection(tenant_1_db_config) do
      p "create user from #{ActiveRecord::Base.connection_db_config.configuration_hash[:database]}"

      create(:user)
    end
  end

  let!(:tenant_2_user) do
    ActiveRecord::Tasks::DatabaseTasks.with_temporary_connection(tenant_2_db_config) do
      p "create user from #{ActiveRecord::Base.connection_db_config.configuration_hash[:database]}"

      create(:user)
    end
  end

  describe 'GET /users' do
    %i[tenant_1 tenant_2].each do |tenant|
      context "get user for #{tenant}" do
        before do
          get '/users', headers: { tenant: tenant.to_s }
        end

        it 'returns user list' do
          p "data #{tenant}_user"
          p send(:"#{tenant}_user")
          expect(response.parsed_body['email']).to eq(send(:"#{tenant}_user").email)
        end
      end
    end
  end
end

# frozen_string_literal: true

class UsersController < ApplicationController
  def index
    users = User.all

    p "test controller from #{ActiveRecord::Base.connection_db_config.configuration_hash[:database]}"
    p users

    render json: {
      data: users
    }
  end
end

[zgid123]

here is the log for full configuration_hash

"create user from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_1_test\"}"
"create user from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_2_test\"}"
"test controller from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_1_test\"}"
#<ActiveRecord::Relation []>
"data tenant_1_user"
#<User id: 21, email: "annamae.hansen@harris-rosenbaum.test_1", first_name: nil, last_name: nil, created_at: "2024-03-21 16:30:14.225226000 +0000", updated_at: "2024-03-21 16:30:14.225226000 +0000">
F"create user from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_1_test\"}"
"create user from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_2_test\"}"
"test controller from {\"adapter\":\"postgresql\",\"pool\":5,\"timeout\":5000,\"host\":\"localhost\",\"database\":\"test_rspec_multiple_database_2_test\"}"
#<ActiveRecord::Relation []>
"data tenant_2_user"
#<User id: 26, email: "malia.willms@pagac.example_4", first_name: nil, last_name: nil, created_at: "2024-03-21 16:30:14.328777000 +0000", updated_at: "2024-03-21 16:30:14.328777000 +0000">
F