Checks (Apache Derby V10.10 Test Javadoc)

java.lang.Object
- junit.framework.Assert
- - junit.framework.TestCase
  - - org.apache.derbyTesting.junit.BaseTestCase
    - - org.apache.derbyTesting.junit.BaseJDBCTestCase
      - org.apache.derbyTesting.junit.JDBCPerfTestCase
        
        org.apache.derbyTesting.system.oe.run.Checks

All Implemented Interfaces:

junit.framework.Test
```
public class Checks
extends JDBCPerfTestCase
```
Do some checks on the Order Entry database.

Field Summary

Fields
Modifier and Type Field and Description

private OEChecks check
Run checks on OE database

private short scale
Warehouse scaling factor
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Fields
Modifier and Type	Field and Description
`private OEChecks`	`check` Run checks on OE database
`private short`	`scale` Warehouse scaling factor

Constructor Summary

Constructors
Constructor and Description

Checks(java.lang.String name)

Checks(java.lang.String name, short scale)

Constructors
Constructor and Description
`Checks(java.lang.String name)`
`Checks(java.lang.String name, short scale)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`static junit.framework.Test`	`checkAllRowCounts(short scale)` Return suite of tests that checks the row counts for all the tables in the Order Entry bechmark.
`static junit.framework.Test`	`consistencyChecks()` Consistency checks per Section 3.3.2 of TPC-C spec
`void`	`setUp()`
`static junit.framework.Test`	`suite()`
`void`	`testCondition1()` Section 3.3.2.1 of TPC-C specification.
`void`	`testCondition2()` Section 3.3.2.2 Consistency Condition 2 (TPC-C spec) Entries in the DISTRICT, ORDER, and NEW-ORDER tables must satisfy the relationship: D_NEXT_O_ID - 1 = max(O_ID) = max(NO_O_ID) for each district defined by (D_W_ID = O_W_ID = NO_W_ID) and (D_ID = O_D_ID = NO_D_ID).
`void`	`testCondition3()` 3.3.2.3 Consistency Condition 3 Entries in the NEW-ORDER table must satisfy the relationship: max(NO_O_ID) - min(NO_O_ID) + 1 = [number of rows in the NEW-ORDER table for this district] for each district defined by NO_W_ID and NO_D_ID.
`void`	`testCondition4()` 3.3.2.4 Consistency Condition 4 Entries in the ORDER and ORDER-LINE tables must satisfy the relationship: sum(O_OL_CNT) = [number of rows in the ORDER-LINE table for this district] for each district defined by (O_W_ID = OL_W_ID) and (O_D_ID = OL_D_ID).
`void`	`testCustomerRows()` Test cardinality of CUSTOMER table
`void`	`testDistrictRows()` Test cardinality of DISTRICT table
`void`	`testHistoryRows()` Test cardinality of HISTORY table
`void`	`testItemRows()` Test cardinality of ITEM table
`void`	`testNewOrdersRows()` Test cardinality of NEWORDERS table
`void`	`testOrderLineRows()` Test cardinality of ORDERLINE table
`void`	`testOrdersRows()` Test cardinality of ORDERS table
`void`	`testStockRows()` Test cardinality of STOCK table
`void`	`testWarehouseRows()` Test cardinality of WAREHOUSE table

Methods inherited from class org.apache.derbyTesting.junit.JDBCPerfTestCase
runBareOverridable, runTest

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase
assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase
assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, setName, toString

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Field Detail
  - scale
```
private short scale
```
    Warehouse scaling factor
  - check
```
private OEChecks check
```
    Run checks on OE database
- Constructor Detail
  - Checks
```
public Checks(java.lang.String name)
```
  - Checks
```
public Checks(java.lang.String name,
              short scale)
```
    Parameters:
    
    name - - test name
    
    scale - -warehouse scale factor
- Method Detail
  - setUp
```
public void setUp()
           throws java.lang.Exception
```
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.lang.Exception
  - checkAllRowCounts
```
public static junit.framework.Test checkAllRowCounts(short scale)
```
    Return suite of tests that checks the row counts for all the tables in the Order Entry bechmark.
    
    Parameters:
    
    scale -
  - consistencyChecks
```
public static junit.framework.Test consistencyChecks()
```
    Consistency checks per Section 3.3.2 of TPC-C spec
  - suite
```
public static junit.framework.Test suite()
```
    Returns:
    
    suite of tests that perform certain consistency checks on the OE database
  - testCondition1
```
public void testCondition1()
                    throws java.sql.SQLException
```
    Section 3.3.2.1 of TPC-C specification. Entries in the WAREHOUSE and DISTRICT tables must satisfy the relationship: W_YTD = sum(D_YTD) for each warehouse defined by (W_ID = D_W_ID).
    
    Throws:
    
    java.sql.SQLException
  - testCondition2
```
public void testCondition2()
                    throws java.sql.SQLException
```
    Section 3.3.2.2 Consistency Condition 2 (TPC-C spec) Entries in the DISTRICT, ORDER, and NEW-ORDER tables must satisfy the relationship: D_NEXT_O_ID - 1 = max(O_ID) = max(NO_O_ID) for each district defined by (D_W_ID = O_W_ID = NO_W_ID) and (D_ID = O_D_ID = NO_D_ID). This condition does not apply to the NEW-ORDER table for any districts which have no outstanding new orders (i.e., the number of rows is zero).
    
    Throws:
    
    java.sql.SQLException
  - testCondition3
```
public void testCondition3()
                    throws java.sql.SQLException
```
    3.3.2.3 Consistency Condition 3 Entries in the NEW-ORDER table must satisfy the relationship: max(NO_O_ID) - min(NO_O_ID) + 1 = [number of rows in the NEW-ORDER table for this district] for each district defined by NO_W_ID and NO_D_ID. This condition does not apply to any districts which have no outstanding new orders (i.e., the number of rows is zero).
    
    Throws:
    
    java.sql.SQLException
  - testCondition4
```
public void testCondition4()
                    throws java.sql.SQLException
```
    3.3.2.4 Consistency Condition 4 Entries in the ORDER and ORDER-LINE tables must satisfy the relationship: sum(O_OL_CNT) = [number of rows in the ORDER-LINE table for this district] for each district defined by (O_W_ID = OL_W_ID) and (O_D_ID = OL_D_ID).
    
    Throws:
    
    java.sql.SQLException
  - testWarehouseRows
```
public void testWarehouseRows()
                       throws java.lang.Exception
```
    Test cardinality of WAREHOUSE table
    
    Throws:
    
    java.lang.Exception
  - testStockRows
```
public void testStockRows()
                   throws java.lang.Exception
```
    Test cardinality of STOCK table
    
    Throws:
    
    java.lang.Exception
  - testOrdersRows
```
public void testOrdersRows()
                    throws java.lang.Exception
```
    Test cardinality of ORDERS table
    
    Throws:
    
    java.lang.Exception
  - testDistrictRows
```
public void testDistrictRows()
                      throws java.lang.Exception
```
    Test cardinality of DISTRICT table
    
    Throws:
    
    java.lang.Exception
  - testCustomerRows
```
public void testCustomerRows()
                      throws java.lang.Exception
```
    Test cardinality of CUSTOMER table
    
    Throws:
    
    java.lang.Exception
  - testItemRows
```
public void testItemRows()
                  throws java.lang.Exception
```
    Test cardinality of ITEM table
    
    Throws:
    
    java.lang.Exception
  - testNewOrdersRows
```
public void testNewOrdersRows()
                       throws java.lang.Exception
```
    Test cardinality of NEWORDERS table
    
    Throws:
    
    java.lang.Exception
  - testHistoryRows
```
public void testHistoryRows()
                     throws java.lang.Exception
```
    Test cardinality of HISTORY table
    
    Throws:
    
    java.lang.Exception
  - testOrderLineRows
```
public void testOrderLineRows()
                       throws java.lang.Exception
```
    Test cardinality of ORDERLINE table
    
    Throws:
    
    java.lang.Exception

Class Checks

Field Summary

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

Constructor Summary

Method Summary

Methods inherited from class org.apache.derbyTesting.junit.JDBCPerfTestCase

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

scale

check

Constructor Detail

Checks

Checks

Method Detail

setUp

checkAllRowCounts

consistencyChecks

suite

testCondition1

testCondition2

testCondition3

testCondition4

testWarehouseRows

testStockRows

testOrdersRows

testDistrictRows

testCustomerRows

testItemRows

testNewOrdersRows

testHistoryRows

testOrderLineRows