database testing

[malytomas]

is it possible to have some infrastructure for testing?
specifically, i would like to test behaviors in the database.

example testcase:
restore database from the repository,
run this sql to add a player, a ship, a move command, and run several ticks of simulation.
verify that the ship has reached its destination.

there are a lot of edge cases that would be nice to test regularly, such as multiple ships trading with one planet at once, or several ships transferring goods to one ship simultaneously, etc..

[tivvit]

Definitely a good idea.

We can use the dev (docker-based) infrastructure for that. To ensure atomicity (clean db for each run) we just need to remove the previous container (from the previous run - it keeps the data).

For the tests we may use the SQL cli or a Python script. When we have that we can create a CI for that.

[tivvit]

same as #117 ?

[malytomas]

i consider #117 as significantly smaller subset than what i was hoping for in #12.

in #117 i want to test that all types of commands can run and do something. this is the minimum mandatory to make it usable at the trip.

in #12 i wanted to test for several scenarios. many edge cases etc.. i acknowledge that we do not have time for all of that anymore..