Need some assistance. I am new to Groovy (familiar with
Java) and I am trying to write a script to compare tables in two different databases, row by row. The hope is that these databases are exact matches. I am having trouble figuring out how to write this type of check syntactically in Groovy using the eachRow method in Groovy.sql.Sql. For each row in databaseA/table1, find that row in databaseB/table1. How can I write this using closures? I have already attempted multiple variations but I can't find the proper method/syntax. Thanks for any assistance.
example pseudo code: