Mass import generate same hash for all operations

[micter59]

Q	A
auditor version	5.2.5
PHP version	8.2.11
Database	MySQL

Summary

I'm working on a project where i have to import old data from an other app.
In the use of the app, I've no problem with the audits, when adding / editing / deleting something.
The import it-self is also ok.
But after the import, I realize that all audits entries have same transaction hash.

Current behavior

I've tried to import data with a "Fixture", and also with a "Command".
Both ways have the same behaviour : all audits entries have the same hash.
As I display audits by hash (to get all linked entities), it's a problem for me.
I should add that I've put a "flush" command after each creation of data.

How to reproduce

Just do an import of a lot of data.

Expected behavior

I would expect every operation has its own transaction hash.

[TheCelavi]

Just a thought - as far as I know, doctrine fixtures bundle creates "outer" transaction, so flushing inside will just commit "inner" transaction.

Have you tried something like this:

• iterate data
  • for each iteration, create entities
  • add them to entity manager
  • flush
  • clear manager

?

Make sure that there is no "outer" transaction.

Batch import should not work, it is single transaction.

In general, when you think about import and transaction audit - it is one transaction done by one user in one particular time, regardless of amount of data and number of insert operations.

I don't think, from philosophical standpoint, that it is a bug, it is more as a feature 😂

However, that doesn't help you - so I guess you could try to simulate "one by one" transaction. Just make sure there is no outer transaction scope.