michelp / pgsodium

Modern cryptography for PostgreSQL using libsodium.
Other
555 stars 32 forks source link

Add tap tests on pgsodium objects schema #67

Closed ioguix closed 1 year ago

ioguix commented 1 year ago

This adds tap tests on the pgsodium extension itself. This should help enforce some sanity rules about ownership, privileges, existing objects, etc.

This is currently a draft as:

The generation script itself is included in this PR for information only. The objective is to edit the pgsodium_schema.sql test script bu hand.

ioguix commented 1 year ago

Note that the tests are currently failing because of #68

ioguix commented 1 year ago

Hi,

There's currently 1729 tests including the ones from commit f64f2cf.

We could add some more tests around indexes & constraints on table keys and about the event trigger (not supported by pgtap yet).

From here, I'll need some serious review, the next steps would be to:

Regards,

ioguix commented 1 year ago

Thank you!