org.apache.derbyTesting.functionTests.tests.lang

Class PrimaryKeyTest

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

All Implemented Interfaces:

junit.framework.Test

public class PrimaryKeyTest
extends BaseJDBCTestCase

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testBug5420() Testing The Bug5420
void	testCatalog() verify the consistency of the indexes on the system catalogs
void	testConstraintwithNotNull() Tests that we can combile key constraints with not null.
void	testDeleteFromPrimaryKey() tests that we can Delete from Primary Key
void	testDuplicateConstraintNames() Constraint Names must be Unique with in a schema
void	testDuplicatePrimaryKey() Tests that A table can't contain two primary keys.
void	testExplicitNullabilityOfConstraints() Tests that primary and Unique key constraint cannot be Explicitely Nullable.
void	testInvalidConstaintDefs() Tests the Invalid constraint Definations.
void	testInvalidConstraintSchemaNames() Tests Invalid constraint schema name
void	testKeyConstraintsImpliesNotNull() Tests that If a column is a part of Primary Key then it cann't contain NULL values.

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

Methods inherited from class java.lang.Object

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

Constructor Detail

PrimaryKeyTest

public PrimaryKeyTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testDuplicatePrimaryKey

public void testDuplicatePrimaryKey()
                             throws java.sql.SQLException

Tests that A table can't contain two primary keys.

Throws:

java.sql.SQLException

testInvalidConstaintDefs

public void testInvalidConstaintDefs()
                              throws java.sql.SQLException

Tests the Invalid constraint Definations.

Throws:

java.sql.SQLException

testInvalidConstraintSchemaNames

public void testInvalidConstraintSchemaNames()
                                      throws java.sql.SQLException

Tests Invalid constraint schema name

Throws:

java.sql.SQLException

testDuplicateConstraintNames

public void testDuplicateConstraintNames()
                                  throws java.sql.SQLException

Constraint Names must be Unique with in a schema

Throws:

java.sql.SQLException

testExplicitNullabilityOfConstraints

public void testExplicitNullabilityOfConstraints()
                                          throws java.sql.SQLException

Tests that primary and Unique key constraint cannot be Explicitely Nullable.

Throws:

java.sql.SQLException

testKeyConstraintsImpliesNotNull

public void testKeyConstraintsImpliesNotNull()
                                      throws java.sql.SQLException

Tests that If a column is a part of Primary Key then it cann't contain NULL values. And also Unique key cann't contain nulls.

Throws:

java.sql.SQLException

testConstraintwithNotNull

public void testConstraintwithNotNull()
                               throws java.sql.SQLException

Tests that we can combile key constraints with not null.

Throws:

java.sql.SQLException

testDeleteFromPrimaryKey

public void testDeleteFromPrimaryKey()
                              throws java.sql.SQLException

tests that we can Delete from Primary Key

Throws:

java.sql.SQLException

testCatalog

public void testCatalog()
                 throws java.sql.SQLException

verify the consistency of the indexes on the system catalogs

Throws:

java.sql.SQLException

testBug5420

public void testBug5420()
                 throws java.sql.SQLException

Testing The Bug5420

Throws:

java.sql.SQLException