[Testing] Improve schema handling for integration tests on Spanner Emulator. #61
Description
Currently the schema/players.sql and schema/trading.sql files are copied into the backend service's folder to run integration tests.
It would be nice to use wrench as part of integration tests to validate schema migrations are working.
There are some issues with this though:
- applying migrations against the emulator will eventually take a while. This can be solved by loading the 'current' schema into a file. Question would be where to get that 'current' schema?
- The emulator can lag on feature parity with Cloud Spanner. This means that integration tests can fail if the emulator doesn't support a particular SQL feature we're taking advantage of in this sample gaming app.
So will need to figure out how to handle those two points when improving integration tests.