We have few database views to simplify or (in most cases) improve performance of an application. Each view contains some business logic that we don't know how to test by unit tests. Is there some way to write unit tests for database views? We use dbunit with hsqldb to test sql queries. With these tools we can create view directly from code using Hibernate but it's not that easy. HSQLDB has different syntax than Oracle so we can't use native oracle sql to write it. We can use HQL but we can make some mistakes during rewriting native oracle sql to HQL and unit tests won't be valuable.
Aucun commentaire:
Enregistrer un commentaire