We have all of our unit tests written so that they create and populate tables in HSQL. I want developers who use this to be able to write queries on this HSQL database (1), writing queries, they can better understand the data model, and those who are not familiar with SQL can reproduce the data before writing execution statements and 2 ), since they do not have access to test databases / security reasons). Is there a way to persist test results so that it can parse and parse using a SQL client?
Now I am the jury, juggling it, switching the data source to another database (for example, DB2 / mysql, then connecting to this database on my machine so that I can play with stable data), however, it would be easier for me if HSQL supports this than Explain how to do this for each new developer.
To be clear, I need an SQL client to interact with persistent data, so debugging and memory checking will not be clean. This has more to do with initial development, rather than debugging / maintenance / testing.
source
share