[n]unit testing on big'ish systems

foldface_at_yahoo.co.uk
Date: 12/21/04 

Date: 21 Dec 2004 14:02:13 -0800

Terrible subject line

  I'm presently working on a system which comprises of a number of
parts.
We have a database, a large c++ program which has been about for many
years
and writes and reads to the database and a c# program which does some
writing and lots of reading from the database.
 
  What I'm after is some guidelines on how to unit test the c#
program.
Points to consider
- A lot (pardon the vague'ness) of the logic is in stored procedures
- The c# program does a lot of reading and not so much writing to the
database
- You need a fair bit of information in the database in order to do
anything
useful.
- Although these programs have been about for a while there has been
no
unit testing at all until now.

A bit of reading throws up
- mock objects, great but given the need for lots of setup data before
you
begin and given that you can always rollback db changes I possibly
should
start with an example db? Can't help but think thats limiting though
as
a dynamic input would reveal more, but the large nature of the db
prohibits
this.
- Assume using mock objects, as a lot of the code is in stored
procedures
I can't help but think that nunit is the wrong vehicle to be testing
this?
Any one have experience of something like TSqlUnit?

Q: What I want to get from this given the advanced (in years) nature
of the code.
A: I've worked on test first stuff in the past but not with n-tier
stuff of this
nature, I've been further from the database so I could test classes
meaningfully, stored procedures weren't a consideration.

I'm at the throwing hands up stage and could do with some guidance in
moving forwards, any ideas?

Relevant Pages

  • Re: Application Speed Problem - VERY weird
    ... MDE front ends not MDB ... If the DB is reading in a lot of records, ... The data is linked with the standard Access "link ... add that we have only ever used the database on Access 2K. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Help with calculations in a query
    ... Well, Richard, I'll tell you what I do know. ... I do know that I've tried various approaches to solving many database ... deletes the row containing the previous day's reading? ... Lets say that I created an extra field in my table for each meter ...
    (microsoft.public.access.queries)
  • Re: using files with java
    ... >> Basically all you need is a File object and print and read Streams, ... > Are you trying to build a database in Java? ... > reading and PrintWriter, BufferedOutputStream, and FileOutputStream for ... Serialization is okay...commonly used in clustering, ...
    (comp.lang.java.programmer)
  • Re: using files with java
    ... >> Basically all you need is a File object and print and read Streams, ... > Are you trying to build a database in Java? ... > reading and PrintWriter, BufferedOutputStream, and FileOutputStream for ... Serialization is okay...commonly used in clustering, ...
    (comp.lang.java.help)
  • Re: Setting the data type of a new filed in a make table query
    ... I have created a small database that has ... wanted to populate the form with all of the equipment that needed an hour ... reading, display the LAST reading and add ... possible with a Select query, or if I can provide you with some additional ...
    (microsoft.public.access.queries)