org.apache.derbyTesting.perf.basic.jdbc

Class CountTest

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.perf.basic.jdbc.CountTest

All Implemented Interfaces:

junit.framework.Test

public class CountTest
extends JDBCPerfTestCase

Add tests to measure performance of count.

Field Summary

Fields

Modifier and Type	Field and Description
protected static int	rowcount
(package private) java.sql.PreparedStatement	select
(package private) static java.lang.String	tableName

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
CountTest(java.lang.String name, int iterations, int repeats) Constructor -create a CountTest

Method Summary

Modifier and Type	Method and Description
void	Count100() Execute the count query for the BaseLoad100TestSetup schema.
void	initializeConnection(java.sql.Connection conn) Override initializeConnection to set the autocommit to false
void	setUp() setup for the test.
static junit.framework.Test	suite() Suite of tests to return.
void	tearDown() Cleanup - close resources opened in this test.

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, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runScript, runScript, runSQLCommands, setAutoCommit, 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

select

java.sql.PreparedStatement select

tableName

static java.lang.String tableName

rowcount

protected static int rowcount

Constructor Detail

CountTest

public CountTest(java.lang.String name,
                 int iterations,
                 int repeats)

Constructor -create a CountTest

Parameters:

name - testname

iterations - iterations for the test to measure

repeats - number of times to repeat the test

Method Detail

suite

public static junit.framework.Test suite()

Suite of tests to return.

setUp

public void setUp()
           throws java.lang.Exception

setup for the test.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

initializeConnection

public void initializeConnection(java.sql.Connection conn)
                          throws java.sql.SQLException

Override initializeConnection to set the autocommit to false

Overrides:

initializeConnection in class BaseJDBCTestCase

Parameters:

conn - Connection to be intialized

Throws:

java.sql.SQLException - Error setting the initial state.

Count100

public void Count100()
              throws java.lang.Exception

Execute the count query for the BaseLoad100TestSetup schema.

Throws:

java.lang.Exception

tearDown

public void tearDown()
              throws java.lang.Exception

Cleanup - close resources opened in this test.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception