Hide image

Writing Unit Tests for SQL Databases using Delphi

Writing unit tests for client/server applications accessing a database on a SQL server is more complex than writing tests for stand-alone applications due to the fact that the resulting state of the system is not a value returned by every function, but it is stored in the database and must be retrieved in a more complex way. Even if Delphi does not ship with a tool specifically designed to test SQL databases, with some coding work it is possible to use DUnit framework to write, not only tests for classes working on the DB, but also for stored procedures on the server. It is also possible to extend DUnit so that DB developers and testers can effectively write tests without the need for deepening their knowledge of Delphi syntax and class libraries, focusing on their main task of writing SQL code.

DOWNLOAD VIDEO NOW                                      WATCH VIDEO NOW
 

NOTE: To access this session replay, you must be logged into EDN.  Login or sign up here now – it’s free!

Presented by: Giacomo Degli Esposti - Optima s.r.l