How to use SyncConnectionWrapper from an existing sync connection (PooledConnection)

[vincent-herlemont]

I have an insert function that takes &mut PooledConnection<ConnectionManager<diesel::SqliteConnection>> as arguments, as shown below. And I would like to use the connection in this context. Here is some pseudo code:

    async fn insert(
        connection: &mut PooledConnection<ConnectionManager<diesel::SqliteConnection>>,
    ) -> Result<Vec<Self>, Error> {
        use diesel_async::AsyncConnection;
        use diesel_async::sync_connection_wrapper::SyncConnectionWrapper;
        let connection = SyncConnectionWrapper::<Connection>::new(connection.into());
        ...
   }

It does not work because the trait 'From<&mut PooledConnection<ConnectionManager<diesel::SqliteConnection>>>' is not implemented for 'diesel::SqliteConnection'. Do you have any suggestions on this?

[weiznich]

This is expected as SyncConnectionWrapper expects to take ownership of the connection. If you provide only a mutable reference that's not possible.

Additionally this only supports the plain SqliteConnection type for now. For any other connection type additional trait implementations in diesel are required.

[momentary-lapse]

I stumbled upon a similar problem, and wondering if it's possible to get a connection string (db url) of an existing AsyncConnection (in my case AsyncPgConnection)?

[weiznich]

No that's currently not possible as we don't have easily access to that information at that point either.