Basic back-end unit tests to cover all API endpoints.
Notes & Concerns
In addition, as we still make changes to the db schema, we want to ensure that those changes do not impact existing API endpoints, so we somehow need to test if the queries/inserts/updates do not raise an SQL error. Possible approaches:
For select queries, we run some of them with the system account (2000000). However, what do we do for product instances, etc?
For inserts & updates, we run the queries, but do not commit the changes.
For the GitHub actions, how do we access secret variables that are typically stored in the config.ini?
Description
Basic back-end unit tests to cover all API endpoints.
Notes & Concerns