org.apache.derbyTesting.functionTests.tests.tools

Class ImportExportTest

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

All Implemented Interfaces:

junit.framework.Test

public class ImportExportTest
extends BaseJDBCTestCase

Test import and export procedures

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	baseSuite(java.lang.String name)
private void	doExport(java.lang.String fromSchema, java.lang.String fromTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset)
private void	doExportToFile(java.lang.String fileName, java.lang.String fromSchema, java.lang.String fromTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset)
private void	doImport(java.lang.String fromTable, java.lang.String toSchema, java.lang.String toTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace)
private void	doImportAndExport(java.lang.String fromSchema, java.lang.String fromTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset)
private void	doImportAndVerify(java.lang.String fromSchema, java.lang.String fromTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace) doImportAndVerify checks that data which has been imported and then exported is identical.
private void	doImportFromFile(java.lang.String fileName, java.lang.String toSchema, java.lang.String toTable, java.lang.String colDel, java.lang.String charDel, java.lang.String codeset, int replace)
private void	resetTables() Called from setUp().
protected void	setUp() Set up the test environment.
static junit.framework.Test	suite()
void	testCastingProblem() Test that you can't import the wrong type of object into a UDT column.
void	testDelimiterAndCodeset()
void	testEarlyEndOfFile()
void	testEmptyTable()
void	testEmptyTableWithDelimitedFormat()
void	testEmptyTableWithFieldCharDelimiters()
void	testImportFromNonExistantFile()
void	testImportWithSameNameInDifferentSchema() Test that import to a table in the default schema works if a table with the same name exists in a different schema (DERBY-3296).
void	testInvalidEncoding()
void	testNullDataFile()
void	testQuotesInArguments() Test that quotes in the arguments to the export and import procedures are handled properly (DERBY-4042).
void	testQuotesInColumnNames() Test that we can successfully export from and import to tables that have columns with special characters in their names (single and double quotes, spaces, mixed case).
void	testSpecialDelimitersAndCodeset()
void	testSpecialDelimitersAndUTF16()
void	testWithCodeset()
void	testWithDefaultOptions()

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, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

ImportExportTest

public ImportExportTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

baseSuite

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

setUp

protected void setUp()
              throws java.lang.Exception

Set up the test environment.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

testImportFromNonExistantFile

public void testImportFromNonExistantFile()

testNullDataFile

public void testNullDataFile()

testEmptyTable

public void testEmptyTable()
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testEmptyTableWithDelimitedFormat

public void testEmptyTableWithDelimitedFormat()
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

testEmptyTableWithFieldCharDelimiters

public void testEmptyTableWithFieldCharDelimiters()
                                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testWithDefaultOptions

public void testWithDefaultOptions()
                            throws java.lang.Exception

Throws:

java.lang.Exception

testWithCodeset

public void testWithCodeset()
                     throws java.lang.Exception

Throws:

java.lang.Exception

testDelimiterAndCodeset

public void testDelimiterAndCodeset()
                             throws java.lang.Exception

Throws:

java.lang.Exception

testSpecialDelimitersAndCodeset

public void testSpecialDelimitersAndCodeset()
                                     throws java.lang.Exception

Throws:

java.lang.Exception

testSpecialDelimitersAndUTF16

public void testSpecialDelimitersAndUTF16()
                                   throws java.lang.Exception

Throws:

java.lang.Exception

testInvalidEncoding

public void testInvalidEncoding()
                         throws java.lang.Exception

Throws:

java.lang.Exception

testEarlyEndOfFile

public void testEarlyEndOfFile()
                        throws java.lang.Exception

Throws:

java.lang.Exception

testImportWithSameNameInDifferentSchema

public void testImportWithSameNameInDifferentSchema()
                                             throws java.lang.Exception

Test that import to a table in the default schema works if a table with the same name exists in a different schema (DERBY-3296).

Throws:

java.lang.Exception

testQuotesInArguments

public void testQuotesInArguments()
                           throws java.lang.Exception

Test that quotes in the arguments to the export and import procedures are handled properly (DERBY-4042).

Throws:

java.lang.Exception

testQuotesInColumnNames

public void testQuotesInColumnNames()
                             throws java.lang.Exception

Test that we can successfully export from and import to tables that have columns with special characters in their names (single and double quotes, spaces, mixed case). Regression test case for DERBY-4828.

Throws:

java.lang.Exception

testCastingProblem

public void testCastingProblem()
                        throws java.lang.Exception

Test that you can't import the wrong type of object into a UDT column.

Throws:

java.lang.Exception

doImport

private void doImport(java.lang.String fromTable,
                      java.lang.String toSchema,
                      java.lang.String toTable,
                      java.lang.String colDel,
                      java.lang.String charDel,
                      java.lang.String codeset,
                      int replace)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doImportFromFile

private void doImportFromFile(java.lang.String fileName,
                              java.lang.String toSchema,
                              java.lang.String toTable,
                              java.lang.String colDel,
                              java.lang.String charDel,
                              java.lang.String codeset,
                              int replace)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

doImportAndExport

private void doImportAndExport(java.lang.String fromSchema,
                               java.lang.String fromTable,
                               java.lang.String colDel,
                               java.lang.String charDel,
                               java.lang.String codeset)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

doExport

private void doExport(java.lang.String fromSchema,
                      java.lang.String fromTable,
                      java.lang.String colDel,
                      java.lang.String charDel,
                      java.lang.String codeset)
               throws java.sql.SQLException

Throws:

java.sql.SQLException

doExportToFile

private void doExportToFile(java.lang.String fileName,
                            java.lang.String fromSchema,
                            java.lang.String fromTable,
                            java.lang.String colDel,
                            java.lang.String charDel,
                            java.lang.String codeset)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

doImportAndVerify

private void doImportAndVerify(java.lang.String fromSchema,
                               java.lang.String fromTable,
                               java.lang.String colDel,
                               java.lang.String charDel,
                               java.lang.String codeset,
                               int replace)
                        throws java.sql.SQLException

doImportAndVerify checks that data which has been imported and then exported is identical. It imports the requested data, which has been exported from T1. Row counts are compared, and then the data in T2 is again exported. A bytewise comparison of the two files is then made to verify that the data has been gone through the import/export process intact.

Throws:

java.sql.SQLException

resetTables

private void resetTables()
                  throws java.lang.Exception

Called from setUp(). Ensures that the import and export operate on a consistent set of data.

Throws:

java.lang.Exception