Need mechanism to load data before integration tests.

[jamoore]

Currently the query tests in ome.server.itests.query (LoadContainersHierarchyQueryTest and friends) rely on the create_pojos.sql file in that same directory. Otherwise they fail.

There needs to be a system for automatically loading all SQL (or other data format like HibernateQL) based on some name pattern matching (create_*.sql) or similar before integration tests are run.

One other option would be to have this data be stored as groovy (with HQL calls) rather than pure SQL for better portability.

[jmoore]

This could be done with a @Configuration(beforeSuite = true) (see ​http://blog.hibernate.org/cgi-bin/blosxom.cgi/2005/11/24). One possibility is to have the beforeSuite method call a groovy script to make the data format as simple as possible.

[jmoore]

This is now a problem with the *.sql files under server/test/ome/server/itests/query. Needs to be fixed by using TestNg? facilities.

[jmoore]

r770 removes the hand-coded sql files and in turn uses testng facilities (as mentioned) to create data only once using CreatePojosFixture. The caveat is that this is done for each subclass using the fixture. It would be nice if this could be static (once per JVM not once per subclass).