Skip to content

test: clear schema and rerun migrations instead of just dropping tables

Ben Whitmore requested to merge reset-db-for-tests-20230706 into main

I've created routines for dropping/recreating the public schema entirely and then rerunning all migrations. This should get us to the same state as when we've just installed/started kotahi for the first time, with all tables/functions/triggers/foreign constraints etc, plus whatever data the migrations supply, such as admin and groupManager teams and group-wide chat channels.

I have not yet modified the dumps to account for the fact that we now have a lot of the schema already in place. The dumps will need to be stripped down substantially.

Merge request reports