AnyFixture: multiple databases support

[palkan]

Discussed in #239

^{Originally posted by hvenables March 18, 2022}
Hey,

Quick question around the use of any fixture with multiple databases. I found that when i started using it for our secondary database that the fixtures weren't getting rolled back. The clean method

test-prof/lib/test_prof/any_fixture.rb

Line 166 in fd399f4

def clean

only seems to roll back ActiveRecord::Base and there is no config option to get it to rollback a different database.

Do you have any advice on using any fixture with a secondary database?

Thanks

Harry :)

We need to refactor the internals (the subscribers and table_cache):

• Keep track of not only affected tables but the corresponding database configurations.
• Clean all the affected configurations (see https://github.com/rails/rails/blob/b764fc24c88fbd7caf580d8ac3e94e3aaccd2726/activerecord/lib/active_record/test_fixtures.rb#L163-L167).