Function that takes transaction or connection as argument

[kulak]

It is nice to be able to write code that's independent of current status of connection or transaction and thus function could take executor that is either transaction or connection.

Can it be done with this library?

It seems that I might be able to ask for connection and then pass transaction that gets converted to underlying connection, but I am not sure.

[blackbeam]

Hi. Please look at the following code snippet:

pub async fn archive(conn: &mut impl Queryable, id: i32) -> crate::Result<bool> {
                  // ^^^^^^^^^^^^^^^^^^^^^^^^^ this works for both &mut Conn and &mut Transaction
    const QUERY: &str = "UPDATE `ReadingRooms` \
        SET `is_archived` = NOT `is_archived` WHERE `id` = ?";
    let affected_rows = conn.exec_iter(QUERY, (id,)).await?.affected_rows();
    Ok(affected_rows > 0)
}

[kulak]

Thank you, I think it is exactly what I was looking for. I saw Queryable, but I was not sure if it was the intent.

[kulak]

The problem with the above example, is that it does not seem to work with last_insert_id, as that one is defined on DB connection.

[blackbeam]

The problem with the above example, is that it does not seem to work with last_insert_id, as that one is defined on DB connection.

Looks like you are looking for QueryResult::last_insert_id