Tutorial database testing v5

TTCN-3 User Conference 2009Sophia Antipolis, FranceTutorialStrategies in testing database application with TTCN-3by Bernard Stepien, Liam Peyton, Grant Middleton SchooI of Information Technology and Engineering11Motivation on database testing• Database testing is relatively trivial:– Send an SQL request– Check the results set• Handling the results set at the codec level is also trivial but a repetitive task.• For each different results set there has to be a different handling in the codec.• Thus, normally, database testing is codec development intensive.• We propose a solution that eliminates the intensive codec development effort.2Motivation on database applications testing• Testing of database applications mostly consist in checking the database state following an operation in some application program.• Thus, database application testing is a kind of integration testing where several individual test results need to be correlated.• It is an advantage to be able to handle all aspects of integration testing with a single language like TTCN-3.• Also, the various aspects can be correlated strictly at the abstract layer.3Service Oriented ArchitectureSeparation of concerns with concrete adaptorsBrowser InterfaceTest FrameworkHTTP HTTP-specificationsRequest Response-templatesWeb Application-data types-books-adaptors-shopping carts HTTP adaptor-ordersJDBC adaptorJDBC RMI SOAPRMI adaptorSOAP adaptorBook Shopping ...