migrate method
Opens the database, makes it the default connection and migrates it.
Wire into setUpAll.
Implementation
Future<void> migrate() async {
_connection = SqliteConnection.inMemory();
DB.use(_connection);
await Migrator(_connection, migrations).run();
}