3

I want to write a generic function that accepts two objects of same entity class and compares the fields that are different and returns List of all the changes made to particular fields along with time.

One among the many entity classes would be say Member as follows

public class Member {
    String firstName;
    String lastName;
    String driverLicenseNumber;
    Integer age;
    LocalDateTime timestamp;
}

In the DB, I have a table called member_audit that gets populated with old data whenever there is a change in member table using triggers (Similarly for other entities).

The List of resource for each of the entity I would be returning is something like

public class MemberAuditsResource {
    private String field;
    private LocalDateTime on;
    private String changeType;
    private String oldValue;
    private String newValue;
}

I can only think of writing a function for each entity separately like this

private List<MembeAuditsResource> memberCompare(Member obj1, Member obj2) {

    //Compare every field in both the objects using if else and populate the resource.

}

And then calling the above function to compare every pair of record in the entity_audit table. The code would be very large to compare every field and multiplied by different entities. Is there a better and efficient way?

Mohammed Shirhaan
  • 555
  • 1
  • 11
  • 27
  • 1
    uhm you could have a look at Envers, it is an "hibernate module that provides auditing for entity classes", see https://hibernate.org/orm/envers/ and maybe https://stackoverflow.com/questions/42340179/hibernare-envers-audit-with-spring-data-jpa-and-spring-boot – Daniele Feb 23 '19 at 20:37
  • *The code would be very large to compare every field and multiplied by different entities* ... Compare objects in that case, isn't that possible as well? – Naman Feb 23 '19 at 21:58

2 Answers2

5

If you extend the ideas to compare the object graph , it is not a trivial problem. So, the efficient way is not to re-inventing the wheel but use an existing library such as JaVers :

Member oldMember = new Member("foo" ,"chan" ,"AB12" , 21 ,LocalDateTime.now());
Member newMember = new Member("bar" ,"chan" ,"AB12" , 22 ,LocalDateTime.now());

Diff diff = javers.compare(oldMember, newMember);
for(Change change:  diff.getChanges()) {
    System.out.println(change);
}

Then , you can get something like:

ValueChange{ 'firstName' changed from 'foo' to 'bar' }
ValueChange{ 'age' changed from '21' to '22' }
Ken Chan
  • 84,777
  • 26
  • 143
  • 172
1

Convert both object to a Map using JSON objectMapper.convertValue method. Then you can easily compare the keys/values of the two maps and create a list of differences.

Selindek
  • 3,269
  • 1
  • 18
  • 25