org.apache.derbyTesting.functionTests.tests.lang

Class ProcedureInTriggerTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.ProcedureInTriggerTest

All Implemented Interfaces:

junit.framework.Test

public class ProcedureInTriggerTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static int	getConnectionProcCount
private static int	selectRowsCount
private static int	zeroArgCount

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static void	alterTable()
private static junit.framework.Test	basesuite()
private void	checkAndResetGetConnectionProcCount(int count)
private void	checkAndResetSelectRowsCount(int count)
private void	checkAndResetZeroArgCount(int count)
static void	createIndex()
static void	createTrigger()
static void	deleteRow(int p1)
static void	doConnCommit()
static int	doConnCommitInt()
static void	doConnectionSetIsolation()
static void	doConnRollback()
static void	dropIndex()
static void	dropTable()
static void	dropTrigger()
static void	getConnectionProc()
static void	insertRow(int p1)
static void	insertRow(int p1, java.lang.String p2)
static void	selectRows(int p1, int p2, java.sql.ResultSet[] data1, java.sql.ResultSet[] data2)
static void	selectRows(int p1, java.sql.ResultSet[] data)
static void	selectRows(java.lang.String table, java.sql.ResultSet[] rs)
static junit.framework.Test	suite()
protected void	tearDown() Tear down the test environment.
void	testModifiesSql() Test triggers that MODIFY SQL DATA
void	testTriggerContainsSql() Test CONTAINS SQL triggers (neither reads no writes data) procedure does just a getConnection and that's it.
void	testTriggerNegative() Some misc negative tests for procedures in triggers.
void	testTriggerNoSql() Test triggers that fire procedures with no sql
void	testTriggerReadsSql() Test triggers for procedures that READ SQL DATA
static void	updateRow(int p1)
static void	zeroArg()

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

Field Detail

zeroArgCount

private static int zeroArgCount

getConnectionProcCount

private static int getConnectionProcCount

selectRowsCount

private static int selectRowsCount

Constructor Detail

ProcedureInTriggerTest

public ProcedureInTriggerTest(java.lang.String name)

Method Detail

testTriggerNoSql

public void testTriggerNoSql()
                      throws java.sql.SQLException

Test triggers that fire procedures with no sql

Throws:

java.sql.SQLException

testTriggerContainsSql

public void testTriggerContainsSql()
                            throws java.sql.SQLException

Test CONTAINS SQL triggers (neither reads no writes data) procedure does just a getConnection and that's it.

Throws:

java.sql.SQLException

testTriggerReadsSql

public void testTriggerReadsSql()
                         throws java.sql.SQLException

Test triggers for procedures that READ SQL DATA

Throws:

java.sql.SQLException

testModifiesSql

public void testModifiesSql()
                     throws java.sql.SQLException

Test triggers that MODIFY SQL DATA

Throws:

java.sql.SQLException

testTriggerNegative

public void testTriggerNegative()
                         throws java.sql.SQLException

Some misc negative tests for procedures in triggers.

Throws:

java.sql.SQLException

basesuite

private static junit.framework.Test basesuite()

suite

public static junit.framework.Test suite()

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear down the test environment.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

checkAndResetZeroArgCount

private void checkAndResetZeroArgCount(int count)

zeroArg

public static void zeroArg()

checkAndResetGetConnectionProcCount

private void checkAndResetGetConnectionProcCount(int count)

getConnectionProc

public static void getConnectionProc()
                              throws java.lang.Throwable

Throws:

java.lang.Throwable

checkAndResetSelectRowsCount

private void checkAndResetSelectRowsCount(int count)

selectRows

public static void selectRows(int p1,
                              java.sql.ResultSet[] data)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

selectRows

public static void selectRows(int p1,
                              int p2,
                              java.sql.ResultSet[] data1,
                              java.sql.ResultSet[] data2)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

selectRows

public static void selectRows(java.lang.String table,
                              java.sql.ResultSet[] rs)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

insertRow

public static void insertRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

insertRow

public static void insertRow(int p1,
                             java.lang.String p2)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

updateRow

public static void updateRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

deleteRow

public static void deleteRow(int p1)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

alterTable

public static void alterTable()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

dropTable

public static void dropTable()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

doConnCommitInt

public static int doConnCommitInt()
                           throws java.lang.Throwable

Throws:

java.lang.Throwable

doConnCommit

public static void doConnCommit()
                         throws java.lang.Throwable

Throws:

java.lang.Throwable

doConnRollback

public static void doConnRollback()
                           throws java.lang.Throwable

Throws:

java.lang.Throwable

doConnectionSetIsolation

public static void doConnectionSetIsolation()
                                     throws java.lang.Throwable

Throws:

java.lang.Throwable

createIndex

public static void createIndex()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

dropIndex

public static void dropIndex()
                      throws java.sql.SQLException

Throws:

java.sql.SQLException

createTrigger

public static void createTrigger()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

dropTrigger

public static void dropTrigger()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException