public class GeneratedColumnsHelper extends BaseJDBCTestCase
Helper routines for testing generated columns. See DERBY-481.
Modifier and Type | Field and Description |
---|---|
protected static java.lang.String |
BAD_BEFORE_TRIGGER |
protected static java.lang.String |
BAD_CAST |
protected static java.lang.String |
BAD_FOREIGN_KEY_ACTION |
protected static java.lang.String |
CANT_CONTAIN_NULLS |
protected static java.lang.String |
CANT_MODIFY_IDENTITY |
protected static java.lang.String |
CANT_OVERRIDE_GENERATION_CLAUSE |
protected static java.lang.String |
CANT_REFERENCE_GENERATED_COLUMN |
protected static java.lang.String |
CASCADED_COLUMN_DROP_WARNING |
protected static java.lang.String |
COLUMN_OUT_OF_SCOPE |
protected static java.lang.String |
CONSTRAINT_DROPPED_WARNING |
protected static java.lang.String |
CONSTRAINT_VIOLATION |
protected static java.lang.String |
DUPLICATE_CLAUSE |
protected static java.lang.String |
FORBIDDEN_DROP_TRIGGER |
protected static java.lang.String |
FORBIDDEN_ORDERING_OPERATION |
protected static java.lang.String |
FOREIGN_KEY_VIOLATION |
protected static java.lang.String |
GRANT_REVOKE_NOT_ALLOWED |
protected static java.lang.String |
ILLEGAL_ADD_DEFAULT |
protected static java.lang.String |
ILLEGAL_AGG |
protected static java.lang.String |
ILLEGAL_AGGREGATE |
protected static java.lang.String |
ILLEGAL_COMPARISON |
protected static java.lang.String |
ILLEGAL_DUPLICATE |
protected static java.lang.String |
ILLEGAL_RENAME |
protected static java.lang.String |
ILLEGAL_STORAGE |
protected static java.lang.String |
ILLEGAL_UDT_CLASS |
protected static java.lang.String |
JAVA_EXCEPTION |
protected static java.lang.String |
LACK_COLUMN_PRIV |
protected static java.lang.String |
LACK_EXECUTE_PRIV |
protected static java.lang.String |
LACK_TABLE_PRIV |
protected static java.lang.String |
LACK_USAGE_PRIV |
protected static java.lang.String |
LANG_INVALID_USE_OF_DEFAULT |
protected static java.lang.String |
LEXICAL_ERROR |
protected static java.lang.String |
LOCK_TIMEOUT |
protected static java.lang.String |
MISSING_OBJECT |
protected static java.lang.String |
NEED_EXPLICIT_DATATYPE |
protected static java.lang.String |
NO_GENERIC_PERMISSION |
protected static java.lang.String |
NO_SELECT_OR_UPDATE_PERMISSION |
protected static java.lang.String |
NO_TABLE_PERMISSION |
protected static java.lang.String |
NON_EMPTY_SCHEMA |
protected static java.lang.String |
NONEXISTENT_OBJECT |
protected static java.lang.String |
NOT_IMPLEMENTED |
protected static java.lang.String |
NOT_NULL_NEEDS_DATATYPE |
protected static java.lang.String |
NOT_NULL_VIOLATION |
protected static java.lang.String |
OBJECT_DOES_NOT_EXIST |
protected static java.lang.String |
OPERATION_FORBIDDEN |
protected static java.lang.String |
REDUNDANT_CLAUSE |
protected static java.lang.String |
ROUTINE_CANT_ISSUE_SQL |
protected static java.lang.String |
ROUTINE_DEPENDS_ON_TYPE |
protected static java.lang.String |
STRING_TRUNCATION |
protected static java.lang.String |
SYNTAX_ERROR |
protected static java.lang.String |
TABLE_DEPENDS_ON_TYPE |
protected static java.lang.String |
TOO_MUCH_CONTENTION |
protected static java.lang.String |
TRIGGER_DROPPED_WARNING |
protected static java.lang.String |
UNSTABLE_RESULTS |
protected static java.lang.String |
VIEW_DEPENDENCY |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
GeneratedColumnsHelper(java.lang.String name)
Create a new instance.
|
Modifier and Type | Method and Description |
---|---|
protected void |
assertColumnTypes(java.sql.Connection conn,
java.lang.String tableName,
java.lang.String[][] columnTypes)
Assert that a table has the correct column types.
|
void |
assertDeterministic(java.sql.Connection conn,
java.lang.String routineName,
boolean isDeterministic)
Assert whether a routine is expected to be DETERMINISTIC.
|
protected void |
expectExecutionWarning(java.sql.Connection conn,
java.lang.String sqlState,
java.lang.String query)
Assert that the statement text, when executed, raises a warning.
|
protected void |
expectExecutionWarnings(java.sql.Connection conn,
java.lang.String[] sqlStates,
java.lang.String query)
Assert that the statement text, when executed, raises a warning.
|
protected void |
expectInsertRowError(java.sql.ResultSet rs,
java.lang.String sqlState)
Assert that the in-place insert raises the expected error.
|
protected void |
expectNoWarning(java.sql.Connection conn,
java.lang.String query)
Assert that the statement text, when executed, raises no warnings.
|
protected void |
expectUpdateRowError(java.sql.ResultSet rs,
java.lang.String sqlState)
Assert that the in-place update raises the expected error.
|
protected <T> java.util.ArrayList<T> |
fill(T[] raw)
Fill an ArrayList from an array.
|
protected void |
verifyRestrictedDrop(java.sql.Connection conn,
java.lang.String createDependentObject,
java.lang.String dropDependentObject,
java.lang.String createStatement,
java.lang.String dropStatement,
java.lang.String badDropState)
Test that a restricted drop is blocked by an object.
|
protected void |
verifyRevokePrivilege(java.sql.Connection grantorConnection,
java.sql.Connection granteeConnection,
java.lang.String grantStatement,
java.lang.String revokeStatement,
java.lang.String createStatement,
java.lang.String dropStatement,
java.lang.String badRevokeSQLState)
Test that a privilege can't be revoked if an object depends on it.
|
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
protected static final java.lang.String NOT_IMPLEMENTED
protected static final java.lang.String OBJECT_DOES_NOT_EXIST
protected static final java.lang.String NONEXISTENT_OBJECT
protected static final java.lang.String REDUNDANT_CLAUSE
protected static final java.lang.String CANT_CONTAIN_NULLS
protected static final java.lang.String ILLEGAL_AGGREGATE
protected static final java.lang.String UNSTABLE_RESULTS
protected static final java.lang.String CANT_OVERRIDE_GENERATION_CLAUSE
protected static final java.lang.String CANT_REFERENCE_GENERATED_COLUMN
protected static final java.lang.String ROUTINE_CANT_ISSUE_SQL
protected static final java.lang.String BAD_FOREIGN_KEY_ACTION
protected static final java.lang.String ILLEGAL_ADD_DEFAULT
protected static final java.lang.String ILLEGAL_RENAME
protected static final java.lang.String NEED_EXPLICIT_DATATYPE
protected static final java.lang.String BAD_BEFORE_TRIGGER
protected static final java.lang.String NOT_NULL_NEEDS_DATATYPE
protected static final java.lang.String NOT_NULL_VIOLATION
protected static final java.lang.String CONSTRAINT_VIOLATION
protected static final java.lang.String FOREIGN_KEY_VIOLATION
protected static final java.lang.String ILLEGAL_DUPLICATE
protected static final java.lang.String SYNTAX_ERROR
protected static final java.lang.String LEXICAL_ERROR
protected static final java.lang.String COLUMN_OUT_OF_SCOPE
protected static final java.lang.String OPERATION_FORBIDDEN
protected static final java.lang.String LACK_TABLE_PRIV
protected static final java.lang.String LACK_COLUMN_PRIV
protected static final java.lang.String LACK_EXECUTE_PRIV
protected static final java.lang.String LACK_USAGE_PRIV
protected static final java.lang.String CANT_MODIFY_IDENTITY
protected static final java.lang.String CASCADED_COLUMN_DROP_WARNING
protected static final java.lang.String CONSTRAINT_DROPPED_WARNING
protected static final java.lang.String TRIGGER_DROPPED_WARNING
protected static final java.lang.String LANG_INVALID_USE_OF_DEFAULT
protected static final java.lang.String GRANT_REVOKE_NOT_ALLOWED
protected static final java.lang.String MISSING_OBJECT
protected static final java.lang.String ROUTINE_DEPENDS_ON_TYPE
protected static final java.lang.String TABLE_DEPENDS_ON_TYPE
protected static final java.lang.String VIEW_DEPENDENCY
protected static final java.lang.String NON_EMPTY_SCHEMA
protected static final java.lang.String JAVA_EXCEPTION
protected static final java.lang.String ILLEGAL_UDT_CLASS
protected static final java.lang.String FORBIDDEN_ORDERING_OPERATION
protected static final java.lang.String ILLEGAL_AGG
protected static final java.lang.String ILLEGAL_COMPARISON
protected static final java.lang.String ILLEGAL_STORAGE
protected static final java.lang.String BAD_CAST
protected static final java.lang.String DUPLICATE_CLAUSE
protected static final java.lang.String FORBIDDEN_DROP_TRIGGER
protected static final java.lang.String LOCK_TIMEOUT
protected static final java.lang.String TOO_MUCH_CONTENTION
protected static final java.lang.String STRING_TRUNCATION
protected static final java.lang.String NO_GENERIC_PERMISSION
protected static final java.lang.String NO_SELECT_OR_UPDATE_PERMISSION
protected static final java.lang.String NO_TABLE_PERMISSION
public GeneratedColumnsHelper(java.lang.String name)
protected void expectUpdateRowError(java.sql.ResultSet rs, java.lang.String sqlState) throws java.lang.Exception
java.lang.Exception
protected void expectInsertRowError(java.sql.ResultSet rs, java.lang.String sqlState) throws java.lang.Exception
java.lang.Exception
protected void expectExecutionWarning(java.sql.Connection conn, java.lang.String sqlState, java.lang.String query) throws java.lang.Exception
java.lang.Exception
protected void expectNoWarning(java.sql.Connection conn, java.lang.String query) throws java.lang.Exception
java.lang.Exception
protected void expectExecutionWarnings(java.sql.Connection conn, java.lang.String[] sqlStates, java.lang.String query) throws java.lang.Exception
java.lang.Exception
public void assertDeterministic(java.sql.Connection conn, java.lang.String routineName, boolean isDeterministic) throws java.lang.Exception
Assert whether a routine is expected to be DETERMINISTIC.
java.lang.Exception
protected void assertColumnTypes(java.sql.Connection conn, java.lang.String tableName, java.lang.String[][] columnTypes) throws java.lang.Exception
java.lang.Exception
protected void verifyRevokePrivilege(java.sql.Connection grantorConnection, java.sql.Connection granteeConnection, java.lang.String grantStatement, java.lang.String revokeStatement, java.lang.String createStatement, java.lang.String dropStatement, java.lang.String badRevokeSQLState) throws java.lang.Exception
java.lang.Exception
protected void verifyRestrictedDrop(java.sql.Connection conn, java.lang.String createDependentObject, java.lang.String dropDependentObject, java.lang.String createStatement, java.lang.String dropStatement, java.lang.String badDropState) throws java.lang.Exception
java.lang.Exception
protected <T> java.util.ArrayList<T> fill(T[] raw)
Fill an ArrayList from an array.
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.