Menu
What are the advantages / disadvantages of the various Unit Testing frameworks for Oracle PL/SQL? For example:
utPLSQL
PL/Unit
Pluto
SqlDeveloper Unit Testing
any other options?
This type of question hasn't been asked in a long time so I'm looking for info that is up-to-date as of 2013.
928
The SQL Developer unit testing feature provides a framework for testing PL/SQL objects, such as functions and procedures, and monitoring the results of such objects over time. You create tests, and for each you provide information about what is to be tested and what result is expected.
Unit Testing of the software product is carried out during the development of an application. An individual component may be either an individual function or a procedure. Unit Testing is typically performed by the developer. In SDLC or V Model, Unit testing is the first level of testing done before integration testing.
You can write unit tests that evaluate changes to any database object. However SQL Server Data Tools includes additional support for creating tests for database functions, triggers, and stored procedures from a database project node in SQL Server Object Explorer.
The issue with first three is that they are not being supported by the community anymore.
If I would have to choose I would go with Steven's Feuerstein utPLSQL. His approach is always good.
Pluto - object oriented PL/SQL makes it hard to use. Guy that has written it is pretty smart but somehow the community was not interested and the project died.
Bottom line is: using files to create test cases makes it hard to maintain and share.
Oracle SQL Developer is the best what you can get for free. Easy to use interface plus the most important thing: repository. You can share your work with others and with other projects. Easy in configuration. Test cases can be create on the fly.
There is one more thing. Guys from the Oak table described Oracle SQL Developer unit testing in "Expert PL/SQL Practices". Even if it is sponsored they wouldn't describe it if it was absolute disaster.
My personal opinion.
100
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
