org.apache.derbyTesting.perf.basic.jdbc

Class SortTest

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.SortTest

All Implemented Interfaces:

junit.framework.Test

public class SortTest
extends JDBCPerfTestCase

Sort test

Field Summary

Fields

Modifier and Type	Field and Description
protected static int	rowcount
(package private) java.sql.PreparedStatement	select
protected 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
SortTest(java.lang.String name, int iterations, int repeats) Sort tests.

Method Summary

Modifier and Type	Method and Description
void	initializeConnection(java.sql.Connection conn) Override initializeConnection to set the autocommit to false
void	setUp() Do the necessary setup for the test ,prepare the statement
void	SortDesc100() Sort test with the schema loaded as part of BaseLoad100TestSetup The rows are presented to the sorter in reverse order of the sort.
void	SortDesc100GetData() Sort test with the schema loaded as part of BaseLoad100TestSetup The rows are presented to the sorter in reverse order of the sort.
static junit.framework.Test	suite()
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

protected static java.lang.String tableName

rowcount

protected static int rowcount

Constructor Detail

SortTest

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

Sort tests.

Parameters:

name - test name

iterations - iterations of the test to measure

repeats - number of times to repeat the test

Method Detail

suite

public static junit.framework.Test suite()

Returns:

suite of tests

setUp

public void setUp()
           throws java.lang.Exception

Do the necessary setup for the test ,prepare the statement

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.

SortDesc100

public void SortDesc100()
                 throws java.lang.Exception

Sort test with the schema loaded as part of BaseLoad100TestSetup The rows are presented to the sorter in reverse order of the sort. The test loads a table with rowcount keys in order, and then sorts them in descending order. The column data are not retrieved using the appropriate getXXX() methods

Throws:

java.lang.Exception

SortDesc100GetData

public void SortDesc100GetData()
                        throws java.lang.Exception

Sort test with the schema loaded as part of BaseLoad100TestSetup The rows are presented to the sorter in reverse order of the sort. The test loads a table with rowcount keys in order, and then sorts them in descending order. The column data are retrieved using the appropriate getXXX() methods

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