Add support for Rails 7.2 and 8.0

[joe-sharp]

Summary

I would like to request that support for newer versions of Ruby on Rails, specifically 7.2 and 8.0, be added to the gem. Happy to try opening my own PR(s) if I can get to it before anyone else.

Looking at the gem's dependencies, it appears that activerecord and activesupport are currently pinned to versions less than 7.2.
Both Rails 7.2 and 8.0 have now been officially released:

• Rails 7.2 was released on August 9th, 2024.
• Rails 8.0 was released on November 7th, 2024.

According to the Ruby on Rails maintenance policy, Rails 7.1 has already moved out of bugfix support as of the 7.2 release. As users upgrade to newer, supported versions of Rails, compatibility with multidb becomes increasingly important.

It would be highly beneficial for users of multidb if the gem could support these newer Rails versions.
Thank you for considering this request and for your work on the multidb gem!

Steps to Reproduce

Attempting to use the multidb gem in a Rails 7.2 or 8.0 application results in dependency conflicts due to the version constraints on activerecord and activesupport. It will actually try to use version 0.1.13 since that is the newest version with a version directive that can pin to 7.2+

Expected Behavior

The multidb gem should be compatible with and function correctly in applications using Rails 7.2 and 8.0.

Environment

Ruby Version: 3.2 (currently)

Rails Version: 7.2 or 8.0

Multidb Version: 0.7.0 but on Rails 7.2+ Bundler will resolve to 0.1.13 which is very undesirable.

[urkle]

@joe-sharp if you want to create a PR that adds support for 7.2+ support I'll review and get it merged in.

Start by modifying the .github/workflows/prs.yml to include 7.2 and 8.0. Then add new gemfiles for those versions of AR. Finally modify the gemspec to relax the version requirements ( < 8.1).

Then you can run tests (making a PR) OR locally by setting the BUNDLE_GEMFILE environment

BUNDLE_GEMFILE=gemfiles/activerecord-7.2.gemfile

Then you can run bundler to setup that environment and run the test

bundle install
bundle exec rspec

This should direct to where changes need to be made to get things working.

Pushing up a PR will allow github to run through the 7.2 and 8.0 in automation.

(and yes if needed we can drop older AR/rails versions once we figure out the changes needed)

[joe-sharp]

@urkle I took a crack at it. This does drop a lot of older releases but all of them are well out of support. Happy to update the changelog and the version if we want to go with it. Maybe worth a Major release due to the breaking changes for many older combinations. Also happy to try and conditionalize some support for older stuff but if you look at the CI run from some early commits they would require some fixes without any of these changes.

[urkle]

@joe-sharp if we change the supported versions of Railos/AR, then it must be a major release due to the breaking change.

I'll look over your PR and put additional comments there.