postgres icon indicating copy to clipboard operation
postgres copied to clipboard
verified publisher icon supabase

Set up testing suites

Open dragarcia opened this issue 5 years ago • 1 comments

At the moment, testing the database to ensure that all extensions and settings are working is done manually at the end of each new build. Perhaps I could make use of a combination of psql scripts and pgTAP to automate this. This is especially so since we have more features than last time.

dragarcia avatar May 08 '20 11:05 dragarcia

Whenever a new image is created, we should be able to:

  • [ ] Verify that all the extensions installed are available. Listing out extensions.
  • [ ] Make sure that these extensions are working. Naive way is to install them inside a schema and run their specific functions.
  • [ ] Make sure that roles created are there as well.

All of these will be ran before Packer ends and database and system should be cleaned up after these tests have been ran. Building of image should fail if any of these tests fail.

dragarcia avatar May 12 '20 14:05 dragarcia

First pass of testing suites done via https://github.com/supabase/postgres/pull/295.

dragarcia avatar Sep 26 '22 06:09 dragarcia