By: Tim DelChiaro
Abstract: Use DUnit framework to write tests for not only classes working on the DB, but also for stored procedures on the server
Hide imageClick to see full-sized 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
Try Delphi XE4 free for 30 days
New Instant Trial!
Webinars on demand!
More social media choices:
Delphi on Google+
@RADTools on Twitter
Server Response from: ETNASC04