Flatware not connecting to the right database without `flatware_helper.rb`

[dgmora]

I got some errors when using flatware_helper.rb, so I decided to not use it. I noticed then that most tests work, although not all of them. After inspecting and setting a breakpoint in the test, I saw that ActiveRecord::Base.connection_db_config.database is my_app_test and not my_app_test1. All workers run against the same test DB.

The environment variable is set correctly in the database.yml and in tests I see that variable is set correctly.

I have made sure that the are no connections in the DB in the spec helper, removed maintain_test_schema and other stuff, even shutting down the DB to see if there was some connection before any test was run. But it still connects to the usual test DB. Not sure what else do to diagnose this, my next step was going to try to fix the errors I had with flatware_helper.rb, but I was wondering if I missed something obvious, since it looked like it should have worked without it.

[tbsvttr]

@dgmora I had the same problem here:

# config/database.yml
test:
  <<: *default
  database: project_name_test<%=ENV['TEST_ENV_NUMBER']%>
# using `ENV.fetch('TEST_ENV_NUMBER')` here raises because that ENV is not filled at all in some circumstances.

# spec/some_spec.rb
  before do
    puts ActiveRecord::Base.connection_db_config.database # outputs: project_name_test
  end

It works correctly when I do:

# spec/flatware_helper.rb

# frozen_string_literal: true

Flatware.configure do |conf|
  conf.before_fork do
    require 'rails_helper'
    system('bin/rails assets:precompile')  # You might not need this or it might not work for me, but its very handy for me
    ActiveRecord::Base.connection_pool.disconnect!
  end

  conf.after_fork do |test_env_number|
    config = ActiveRecord::Base.connection_db_config.configuration_hash
    ActiveRecord::Base.establish_connection(
      config.merge(
        database: config.fetch(:database) + test_env_number.to_s
      )
    )
  end
end

I also created:

# bin/flatware

#!/usr/bin/env ruby
# frozen_string_literal: true

require 'rubygems'
require 'bundler/setup'
require 'flatware'

Flatware::CLI.start ['rspec', '-r', './spec/flatware_helper.rb', *ARGV]

To have a handy bin/flatware available.

I use Ruby 3.4.2, Rails 8.0.2, Rspec 3.13.0, flatware-rspec 2.3.4