Re: Best Way to Test Against a Database

jehugaleahsa@xxxxxxxxx wrote:

How well does this verify the parameters that I set?

As I wrote, this approch will verify the correctness of the SQL statement. To verify the correctness of the results, the query has to be executed.


As Andy wrote, resetting the database is critical. A clean test environment has to be in place for every test, to make them repeatable.

The test steps should also be independent, so that it is not neccessary to run all tests always together in a specific order. This setup makes database tests very slow.

Every developer will also need his/her own test database, to avoid 'test run wars'. (If there is a way to test the business logic without accessing the database, this would be much better. However this does not mean that database tests are not neccessary in this case.)


Michael



.

Relevant Pages

  • Re: How should I generate a primary key?
    ... the external reality and verify them. ... be verified for syntax or check digits inside itself. ... A surrogate key is system generated to replace the actual key behind ... with a quote from Dr. Codd: "..Database users ...
    (comp.databases)
  • Re: Questionable Results
    ... your query is very simple. ... - PAYEE_ID is a Text type field? ... Then compact the database again to get rid of this junk: ... If you are still stuck after that, and you can verify that the 3 assumptions ...
    (microsoft.public.access.queries)
  • Re: Keeping A Tool Library
    ... Easy enough to verify, just go to the MasterCam forum and ask. ... Last weeks e-mails ... questioned your use of the word database. ... video training is all about. ...
    (alt.machines.cnc)
  • Re: Rules wont apply to received messages
    ... Start the Database Utility to verify your database." ... the verify engine doesn't catch that the rebuild routines won't catch it ... good messages until you identify the areas of corruption. ...
    (microsoft.public.mac.office.entourage)
  • Programmatically suppress "Verify Database" alerts
    ... eventual changes to the database won't break the reports. ... We are planning to upgrade to CR 11. ... using the report viewer control and CRAXDDRT. ... some "Verify Database" alert messages, ...
    (microsoft.public.vb.crystal)