jeudi 8 octobre 2015

How do I regression test table schemas with SBT?

I am currently working on a large Scala project that stores large amounts of data across many different SQL tables. However, this application is undergoing a lot of development very quickly, and so the schema for any one of these tables may change between versions. Furthermore, developers may have to switch between versions (such as stable and develop). I am looking for a way to store the expected schema (or at least required tables and columns in tables) for a given version and test that the required columns are there at build time using SBT and/or bash scripts.

I can imagine this would require adding some unit tests for these columns and running the unit tests at build time, but I want all the required column data to be in one place so if someone changes the schema, they do not have to go hunting for the correct unit tests.

Thank you for any help!

Aucun commentaire:

Enregistrer un commentaire