Creation of unit tests for stored procedures (PL/SQL) for a purchasing system
Project duration: 6 months
Brief description
Creation of unit tests for existing stored procedures (PL/SQL) for a purchasing system in a food store chain. The "Dell Code Tester for Oracle" tool is used to support the implementation.
Supplement
The standard test cases that cover INSERT, UPDATE and DELETE are created as a minimum. Positive and negative test cases are created, as well as test cases for exception handling. Test resources that are used multiple times are made available in a global test package or secured in scripts. All test definitions (metadata) are managed in TFS.
Subject description
The database sources to be checked contain coding for managing item data, supplier data, purchasing conditions, transport routes, lists etc. for food and non-food at the international and national level. All transactions for INSERT, UPDATE and DELETE are covered here for the purchasing system's tables. In addition, detailed business logic for selects, calculations or reporting can also be covered.