Hello everyone,
I’m currently working on a project with multiple databases. I have a master database containing User and Client tables that provide centralized authentication. Each client has its own separate database containing all other tables.
My problem is that I need `request.user` information to handle database routing for non-master tables. Currently, I have a solution using a TenantMiddleware that stores database information in a thread-local variable, but this approach isn’t ideal for production.
I’m looking for an alternative (perhaps using a custom Manager?) that would allow me to pass arguments in the “hints” parameter for the database router. I’ve been working on this for hours and haven’t found a solution to customize router hints.
Additionally, I don’t understand why the `.using()` method seems to have no effect on routing in my app - if it worked, I could simply handle routing at the view level.
Any ideas on how to properly link the request to the router ? Has anyone solved similar multi-tenant database routing challenges?
Thanks in advance for your help!