org.apache.derbyTesting.functionTests.tests.tools

Class ImportExportBaseTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.tools.ImportExportBaseTest

All Implemented Interfaces:

junit.framework.Test

Direct Known Subclasses:

ImportExportBinaryDataTest, ImportExportLobTest

public abstract class ImportExportBaseTest
extends BaseJDBCTestCase

This is base class for some of the import tests, provides methods to perform import/export using different procedures.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
ImportExportBaseTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
protected void	doExportQuery(java.lang.String query, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset) Perform export using SYSCS_UTIL.SYSCS_EXPORT_QUERY procedure.
protected void	doExportQueryLobsToExtFile(java.lang.String query, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, java.lang.String lobsFileName) Perform export using SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE procedure.
protected void	doExportTable(java.lang.String schemaName, java.lang.String tableName, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset) Perform export using SYSCS_UTIL.SYSCS_EXPORT_TABLE procedure.
protected void	doExportTableLobsToExtFile(java.lang.String schemaName, java.lang.String tableName, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, java.lang.String lobsFileName) Perform export using SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE procedure.
protected void	doImportData(java.lang.String schemaName, java.lang.String tableName, java.lang.String insertCols, java.lang.String colIndexes, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace) Perform import using SYSCS_UTIL.SYSCS_IMPORT_DATA procedure.
protected void	doImportDataLobsFromExtFile(java.lang.String schemaName, java.lang.String tableName, java.lang.String insertCols, java.lang.String colIndexes, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace) Perform import using SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE procedure.
protected void	doImportTable(java.lang.String schemaName, java.lang.String tableName, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace) Perform import using SYSCS_UTIL.SYSCS_IMPORT_TABLE procedure.
protected void	doImportTableLobsFromExtFile(java.lang.String schemaName, java.lang.String tableName, java.lang.String fileName, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace) Perform import using SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE procedure.

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

Methods inherited from class java.lang.Object

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

Constructor Detail

ImportExportBaseTest

public ImportExportBaseTest(java.lang.String name)

Method Detail

doExportTable

protected void doExportTable(java.lang.String schemaName,
                             java.lang.String tableName,
                             java.lang.String fileName,
                             java.lang.String colDel,
                             java.lang.String charDel,
                             java.lang.String codeset)
                      throws java.sql.SQLException

Perform export using SYSCS_UTIL.SYSCS_EXPORT_TABLE procedure.

Throws:

java.sql.SQLException

doExportQuery

protected void doExportQuery(java.lang.String query,
                             java.lang.String fileName,
                             java.lang.String colDel,
                             java.lang.String charDel,
                             java.lang.String codeset)
                      throws java.sql.SQLException

Perform export using SYSCS_UTIL.SYSCS_EXPORT_QUERY procedure.

Throws:

java.sql.SQLException

doImportTable

protected void doImportTable(java.lang.String schemaName,
                             java.lang.String tableName,
                             java.lang.String fileName,
                             java.lang.String colDel,
                             java.lang.String charDel,
                             java.lang.String codeset,
                             int replace)
                      throws java.sql.SQLException

Perform import using SYSCS_UTIL.SYSCS_IMPORT_TABLE procedure.

Throws:

java.sql.SQLException

doImportData

protected void doImportData(java.lang.String schemaName,
                            java.lang.String tableName,
                            java.lang.String insertCols,
                            java.lang.String colIndexes,
                            java.lang.String fileName,
                            java.lang.String colDel,
                            java.lang.String charDel,
                            java.lang.String codeset,
                            int replace)
                     throws java.sql.SQLException

Perform import using SYSCS_UTIL.SYSCS_IMPORT_DATA procedure.

Throws:

java.sql.SQLException

doExportTableLobsToExtFile

protected void doExportTableLobsToExtFile(java.lang.String schemaName,
                                          java.lang.String tableName,
                                          java.lang.String fileName,
                                          java.lang.String colDel,
                                          java.lang.String charDel,
                                          java.lang.String codeset,
                                          java.lang.String lobsFileName)
                                   throws java.sql.SQLException

Perform export using SYSCS_UTIL.SYSCS_EXPORT_TABLE_LOBS_TO_EXTFILE procedure.

Throws:

java.sql.SQLException

doExportQueryLobsToExtFile

protected void doExportQueryLobsToExtFile(java.lang.String query,
                                          java.lang.String fileName,
                                          java.lang.String colDel,
                                          java.lang.String charDel,
                                          java.lang.String codeset,
                                          java.lang.String lobsFileName)
                                   throws java.sql.SQLException

Perform export using SYSCS_UTIL.SYSCS_EXPORT_QUERY_LOBS_TO_EXTFILE procedure.

Throws:

java.sql.SQLException

doImportTableLobsFromExtFile

protected void doImportTableLobsFromExtFile(java.lang.String schemaName,
                                            java.lang.String tableName,
                                            java.lang.String fileName,
                                            java.lang.String colDel,
                                            java.lang.String charDel,
                                            java.lang.String codeset,
                                            int replace)
                                     throws java.sql.SQLException

Perform import using SYSCS_UTIL.SYSCS_IMPORT_TABLE_LOBS_FROM_EXTFILE procedure.

Throws:

java.sql.SQLException

doImportDataLobsFromExtFile

protected void doImportDataLobsFromExtFile(java.lang.String schemaName,
                                           java.lang.String tableName,
                                           java.lang.String insertCols,
                                           java.lang.String colIndexes,
                                           java.lang.String fileName,
                                           java.lang.String colDel,
                                           java.lang.String charDel,
                                           java.lang.String codeset,
                                           int replace)
                                    throws java.sql.SQLException

Perform import using SYSCS_UTIL.SYSCS_IMPORT_DATA_LOBS_FROM_EXTFILE procedure.

Throws:

java.sql.SQLException