Multiple Databases

[LimpidCrypto]

I have a SaaS1 with a Database hosted locally using Docker. I also have another SaaS2 which is pretty similar to the SaaS1. It also has a Database.
I would need SaaS1 to be able to connect to the database of SaaS2. What would be a good way to integrate the second database connection into SaaS1, using the loco project structure?

[kaplanelad]

Hey @LimpidCrypto
In your APP hooks, navigate to the after_routes function and implementing the following example:

   async fn after_routes(router: axum::Router, _ctx: &AppContext) -> Result<axum::Router> {
        let saas2_db_config = config::Database {
           // ... (fill in your configuration details)
        };

        let saas2_db = db::connect(&saas_db_config).await?;
        Ok(router.layer(Extension(saas2_db)))
    }

In this illustration, we use a local DB configuration and integrate the database connection as an Axum extension.

Now, in your controller, retrieve this instance using the following example:

async fn example(
    _auth: auth::JWT,
    State(_ctx): State<AppContext>,
    Extension(saas2_db): Extension<DatabaseConnection>,
) -> Result<()> {
   ...
}

Define the extension in the controller's schema function, and you'll be able to seamlessly utilize the secondary database.

[LimpidCrypto]

list is part of the notes starter controller

[kaplanelad]

It looks like the given error that the connection succeeded, but the record is not found.
So maybe you don't have the user in the second DB?

[LimpidCrypto]

Yes I thought so too but the pid printed by the dbg!(auth.claims.pid.clone()); exists:

[LimpidCrypto]

I inserted the user of SaaS2 into the database of SaaS1 and now it I get the notes list. But of course I want to get the user of the SaaS2 database. So it I get the wrong database connection in the controller method

[LimpidCrypto]

Oh forget about it. During testing I changed the env!("USER_DATABASE_URL") which points to SaaS2 database to env!("DATABASE_URL") which points to SaaS1 database. Your solustion works just fine. Thanks for your help :)