How to run a query outside of the transaction that has been started?

[plaa]

In general, we want our API to work in an all-of-nothing approach. Therefore in most cases we start a DB transaction in the router so that all calls to the feature and lower levels are bundled in the same transaction. However, there are cases where we want to ensure that data is written to the DB in the feature level regardless of whether a transaction has been started or not (e.g. logging something or results from calling an external API).

How is this possible in Gino? In other ORMs you can start a separate transaction, but in Gino async with db.transaction() automatically creates savepoints instead of starting a new transaction.

[plaa]

Was able to make it work using the Manual Control for transactions, and wrap it up in a context manager:

@asynccontextmanager
async def start_isolated_db_transaction() -> AsyncIterator[Any]:
    """Start a database transaction that is isolated from any enclosing transaction.
    That is, the queries within this transaction are committed as soon as this context
    manager exits, even if there is an enclosing transation."""
    # This acquires a new connection from the Gino engine connection pool and
    # starts a transaction using it.  Implicit queries work correctly within it.
    async with db.bind.acquire() as connection:
        tx = await connection.transaction()
        try:
            yield tx
            await tx.commit()
        except:
            await tx.rollback()
            raise

Gino evidently does some magic that allows the implicit queries to work on the innermost transaction, even if it's unrelated to the enclosing one.