org.apache.derbyTesting.functionTests.tests.demo

Class CheckToursDBTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.demo.CheckToursDBTest

All Implemented Interfaces:

junit.framework.Test

public class CheckToursDBTest
extends BaseJDBCTestCase

This test is for testing the ToursDB database and functions

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
CheckToursDBTest(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	basesuite(java.lang.String name)
private void	doDelete() Method to delete rows from the ToursDB tables
private void	doSelect() Method to select rows from ToursDB tables
private void	doUpdate() Method to update the rows in the ToursDB tables.
private void	insertMaps() Inserts 3 rows in the Maps table.
void	insertMapsPrivileged() Inserts rows in the Maps table.
static junit.framework.Test	suite()
protected void	tearDown() Tear-down the fixture by removing the tables
void	testToursDB() Test insert, update and delete on ToursDB tables

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, runBareOverridable, 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, runTest, setName, setUp, toString

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

CheckToursDBTest

public CheckToursDBTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Parameters:

name -

Method Detail

basesuite

public static junit.framework.Test basesuite(java.lang.String name)

suite

public static junit.framework.Test suite()

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear-down the fixture by removing the tables

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testToursDB

public void testToursDB()
                 throws java.lang.Exception

Test insert, update and delete on ToursDB tables

Throws:

java.lang.Exception

doDelete

private void doDelete()
               throws java.lang.Exception

Method to delete rows from the ToursDB tables

Throws:

java.lang.Exception

doUpdate

private void doUpdate()
               throws java.sql.SQLException

Method to update the rows in the ToursDB tables.

Throws:

java.sql.SQLException

insertMapsPrivileged

public void insertMapsPrivileged()
                          throws java.lang.Exception

Inserts rows in the Maps table. Calls insertMaps().

Throws:

java.lang.Exception

doSelect

private void doSelect()
               throws java.sql.SQLException

Method to select rows from ToursDB tables

Throws:

java.sql.SQLException

insertMaps

private void insertMaps()
                 throws java.sql.SQLException,
                        java.io.FileNotFoundException,
                        java.io.IOException

Inserts 3 rows in the Maps table.

Throws:

java.sql.SQLException

java.io.FileNotFoundException

java.io.IOException