Ensure atomic inside interceptor ?

[Ninja4Panda]

I want to log every action of a user to the database so I was using an interceptor like so.

To ensure it is atomic, I did this.

Is there any ways to start a transaction within the interceptor so there is no need to add transaction before every query ?

[simolus3]

Is there any ways to start a transaction within the interceptor so there is no need to add transaction before every query ?

I haven't tested this, but you can call beginTransaction on the executor to open a transaction executor:

class _NullUser extends QueryExecutorUser {
  @override
  Future<void> beforeOpen(QueryExecutor executor, OpeningDetails details) {
    throw UnimplementedError();
  }

  @override
  int get schemaVersion => throw UnimplementedError();
}

  @override
  Future<List<Map<String, Object?>>> runSelect(
      QueryExecutor executor, String statement, List<Object?> args) async {
    if (statements.startsWith('SELECT')) {
      return super.runSelect(executor, statement, args);
    }
    final tx = executor.beginTransaction();
    await tx.ensureOpen(_NullUser()); // database connection is already open, so we can use a fake user
    // ... prepare logs
    await tx.runInsert(log, logArgs);
    final result = super.runSelect(tx, statement, args);
    await tx.close();
  }

But if you want to keep a transcript of changes, it might be easier to setup triggers for that.

[Ninja4Panda]

I did tried doing it using a transaction executor before but it didn't work. Maybe I did something wrong tho...
As you can see, I even tried using a batch and saw the "Used internally by drift" so I just stopped there

Anyhow, thanks for the reply. I've moved on to using trigger instead.