SASUnit Examples  Version 1.5.0
database_test.sas File Reference
Test Scenarios

Tests for buidling a database. More...

Go to the source code of this file.

Detailed Description

Tests for buidling a database.

Example for a test scenario with the following features:

  • Creating three tables for bulding up a sample database.
  • These are the created tables:
    • Customer
      Table containing 5 customers.
      Variables are CustomerNumber and CustomerName.
      Primary key ist CustomerNumber.
    • Contracts
      Table containing 8 contracts.
      Variales are ContractNumer and ContractType.
      Primary key is ContractNumber. ContractType should range from 1 to 3.
    • CustomerContracts
      Table mapping contracts to customers.
      Variables are CustomerNumber and ContractNumber.
      Primary key ist ContractNumber and CustomerNumber.
  • All foreign key relations are checked
  • A combined dataset is created
    • Combined datasets should containg 8 rows.
      Primary key is ContractNumber and CustomerNumber.
    • Checking if there are customers without contracts and vice versa.
Version
$Revision: 315 $
Author
$Author: klandwich $
Date
$Date: 2014-02-28 10:25:18 +0100 (Fr, 28 Feb 2014) $
See Also
For further information please refer to SASUnit User's Guide
$HeadURL: https://svn.code.sf.net/p/sasunit/code/trunk/example/saspgm/database_test.sas $
Copyright
Copyright 2010, 2012 HMS Analytical Software GmbH. This file is part of SASUnit, the Unit testing framework for SAS(R) programs. For terms of usage under the GPL license see included file readme.txt or https://sourceforge.net/p/sasunit/wiki/readme.v1.2/.

Definition in file database_test.sas.