Feature Request: Connection switching for multiple databases

[hareku]

I request to implement connection switching for multiple databases.
It's like Rails 6 ActiveRecord feature.
rails/rails#34052

In the case of gorm, I think it maybe above this code.

type User struct {}

func (User) WritingDBName() string {
  return "user_writing_db"
}
func (User) ReadingDBName() string {
  return "user_reading_db"
}

If I can implement this feature, is it possible to merge?

[stevenkitter]

Very good idea, I prefer to this too.

[github-actions]

This issue will be automatically closed because it is marked as GORM V1 issue, we have released the public testing GORM V2 release and its documents https://v2.gorm.io/docs/ already, the testing release has been used in some production services for a while, and going to release the final version in following weeks, we are still actively collecting feedback before it, please open a new issue for any suggestion or problem, thank you

Also check out https://github.com/go-gorm/gorm/wiki/GORM-V2-Release-Note-Draft for how to use the public testing version and its changelog