DDL Mode

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.

Mode Description
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.

Edit Page