Best way to integrate it with CI process ?

[cAstraea]

How would you approach this? I was thinking of

1. adding the .snipe and snipe_snapshot.sql to the version control
2. a pre commit hook that would run the test locally and commit the .snipe and snipe_snapshot.sql together so that the first run on the github CI server wouldn't be necessary ?

[tuimz]

We use Gitlab CI and cache the .snipe and .snipe_snapshot.sql in a remote cache.

Just my 2cts ;)