Multitenancy using schema

[trevster344]

I'm attempting to implement multitenancy using the schema. Is there any way from middleware to override the base postgres connection for all modules forward? I see I can fork the EntityManager but I need this to apply in a way that all modules will be using the schema I choose. This is my preferred method of multitenancy with Postgres usually.

Update: I have found that modifying the schema property on the EntityManager from a loader appears to be working. Continuing experimentation. Seems to only affect the main entity manager which means every request is sharing it. Not a viable solution unfortunately.

[SalahAdDin]

Do you check the existing template?

[trevster344]

Yes, I've been through every resource I can find. Nothing seems to answer this. Unfortunately with module isolation the request scope using Inject decorator isn't viable either as no other module gets its changes from its forked entitymanager. Open ears here otherwise I'll go back to writing middleware to override every single api i need.

[lumicjs]

hey... were you successful at this?? i had been looking for the same but havent been able find something even close to it/