This article will look at how we can automate database interaction in End 2 End automation using the JOOQ library in Java.
When we do End 2 End automation of an application, we generally consider 2 parts.
Database Automation with JOOQ
Converting Objects to Map and Back
In large enterprise applications, sometimes, we need to convert data objects to and from Map. Usually, it is an intermediate step to a special serialization. If it is possible to use something standard, then it is better to use that, but many times, the architecture envisioned by some lead architect, the rigid environment, or some similar reason does not make it possible to use JOOQ, Hibernate, Jackson, JAX, or something similar. In such a situation, as it happened to me a few years ago, we have to convert the objects to some proprietary format being string or binary, and the first step towards that direction is to convert the object to a Map.
Eventually, the conversion is more complex than just: