Reduce test time

[LuukBlom]

Kind of request

Changing existing functionality

Enhancement Description

Testing everything on teamcity takes over an hour now.
We are testing a lot of things in duplicate

I think the main areas of improvement are:

• We should use more in-memory fixtures and less file based ones. To do this, I think we need to add in-memory storage of the objects in the database. and a read and write fn on the db.
• test_db/test_fa fixtures: these revert the database on disk after every test. Which adds time to every test. the in-memory db will make these faster / redundant.
• We are running many scenarios in different places, and many of these scenario runs are the similar if not exactly the same. We should use fixtures to run some scenarios for output testing.

Task list

• add in-memory storage of the objects in the database
• add read and write to the db
• remove tests where we are testing things twice

Use case

No response

Additional Context

No response