We run thousands of integration test queries against our 21 different
supported databases. These tests are run in an automated manner for most
databases (namely those that can be virtualized in VMWare or docker), or
manually for the others. The idea is that a jOOQ query like the following...
Should always yield the exact same result on all databases.
There are also unit tests for things like the DefaultRecordMapper, which do
not depend directly on the underlying database, but since you're currently
looking into contributing support for the GRANT and REVOKE statements ,
I'm assuming that unit tests will be less interesting to you than
A good integration test would be setting up 2 database users and an object
(e.g. a table) where the owner of the object can then grant access to the
other user. There will need to be 2 JDBC connections, one for each user, to
validate that user 2 can access the object only after the relevant GRANT
has been issued, and that user 2 can no longer access the object once the
GRANT has been REVOKED.
As our integration tests are not open source, we would not expect your
tests to be very complete. Ideally, a contribution as complex as support
for the GRANT statement would simply work on 1-2 databases by your manual
testing, and we would take it from there.
I hope this helps. If you have any additional questions, please let me know
and I'll be very happy to assist you.
You received this digest because you're subscribed to updates for this group. You can change your settings on the group membership page.
To unsubscribe from this group and stop receiving emails from it send an email to [hidden email].