Currently, each database test file creates a new file/database (each database in SQlite is mapped to a file). It would be more efficient and faster to just create one database and use transactions to never commit changes to the test database.
Motivation
The git hooks used for testing take a non-trivial amount of time. Tests can run quicker if we make a single database and rollback and transactions for each test
Summary
Currently, each database test file creates a new file/database (each database in SQlite is mapped to a file). It would be more efficient and faster to just create one database and use transactions to never commit changes to the test database.
Motivation
The git hooks used for testing take a non-trivial amount of time. Tests can run quicker if we make a single database and rollback and transactions for each test