Most of the time we use
dropCreate mode which means that the database will
be dropped and then re-created before we run all the tests.
We use migrationDropCreate to test database migrations.
|dropCreate||Drop and then create all the tables etc. Most commonly used mode.|
|none||Do not run any DDL. Useful if we want to run 1 particular test without any DDL change.|
|migrationDropCreate||Run the DB migration but first delete the database first ensuring the migration runs against a new database.|
|migration||Run the DB migration. Good for testing migrations run as expected.|
|create||Run the create-all.sql DDL script but delete and recreate the database first.|
|createOnly||Run the create-all.sql DDL script but without recreating the database first.|