org.sourceforge.jxutil.dbtest.universal
Class DBMetaDataTest

java.lang.Object
  |
  +--junit.framework.Assert
        |
        +--junit.framework.TestCase
              |
              +--org.sourceforge.jxutil.dbtest.DatabaseTest
                    |
                    +--org.sourceforge.jxutil.dbtest.universal.DBMetaDataTest

All Implemented Interfaces:

Test

public class DBMetaDataTest

extends DatabaseTest

Check functionality of DatabaseMetaData.

Version:

$Revision: 1.9 $, $Date: 2002/04/13 21:07:59 $

Author:

Keve Müller

Nested Class Summary

Nested classes inherited from class org.sourceforge.jxutil.dbtest.DatabaseTest

DatabaseTest.ColumnDef, DatabaseTest.TableDef

Field Summary

private static Category	cat
private static String[]	keyColumns
private static String[]	keyProcedures
private static String[]	keyTables
private static DatabaseTest.TableDef	PK_ONE A table with one primary key.
private static DatabaseTest.TableDef	PK_TWO A table with compound primary key.

Fields inherited from class org.sourceforge.jxutil.dbtest.DatabaseTest

conn, dbMeta

Fields inherited from class junit.framework.TestCase

Constructor Summary

DBMetaDataTest(String name)
Create the test instance.

Method Summary

private void	assertAscending(String[] keys, Comparable[] last, Object[] current)
void	setUpDB() Set up the test's DB environment.
void	tearDownDB() Tear down the test's DB environment.
void	testCatalogs() Test DatabaseMetaData.getCatalogs.
void	testGetColumns() Check DatabaseMetadata.getColumns.
void	testGetCrossReference() Check DatabaseMetadata.getCrossReference
void	testGetProcedureColumns() Check DatabaseMetadata.getProcedureColumns.
void	testGetProcedures() Check DatabaseMetadata.getProcedures.
void	testGetTablePrivileges() Check DatabaseMetadata.getTablePrivileges.
void	testGetTables() Test DatabaseMetaData.getTableTypes, getTables.
void	testGetVersionColumns() Check DatabaseMetadata.getVersionColumns.
void	testKeysIndex() Check DatabaseMetadata.get{Primary, Exported, Imported}Keys, getColumnPrivileges, getIndexInfo, getBestRowIdentifier.
void	testPrimaryKey() Test DatabaseMetaData.getPrimaryKey.
void	testSchemas() Test DatabaseMetaData.getSchemas
void	testTableTypes() Test DatabaseMetaData.getTableTypes.
void	testTypeInfo() Test DatabaseMetaData.getTypeInfo.
void	testUDTs() Test DatabaseMetaData.getUDTs

Methods inherited from class org.sourceforge.jxutil.dbtest.DatabaseTest

checkDataCols, checkDataRows, createTable, dropTable, dropTable, getColumnString, getType, isDBMS, isDriver, loadData, setConnection, setUp, tearDown

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, name, run, run, runBare, runTest, setName, toString

Methods inherited from class junit.framework.Assert

assert, assert, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertNotNull, assertNotNull, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, fail, fail

Methods inherited from class java.lang.Object

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

Field Detail

cat

private static final Category cat

keyColumns

private static final String[] keyColumns

keyProcedures

private static final String[] keyProcedures

keyTables

private static final String[] keyTables

PK_ONE

private static final DatabaseTest.TableDef PK_ONE

A table with one primary key.

PK_TWO

private static final DatabaseTest.TableDef PK_TWO

A table with compound primary key.

Constructor Detail

DBMetaDataTest

public DBMetaDataTest(String name)

Create the test instance.

Parameters:

name - the test name

Method Detail

assertAscending

private void assertAscending(String[] keys,
                             Comparable[] last,
                             Object[] current)

setUpDB

public void setUpDB()
             throws SQLException

Set up the test's DB environment. Create the tables.

Overrides:

setUpDB in class DatabaseTest

Throws:

SQLException - if a database error occurs

tearDownDB

public void tearDownDB()
                throws SQLException

Tear down the test's DB environment. Drop the tables.

Overrides:

tearDownDB in class DatabaseTest

Throws:

SQLException - if a database error occurs

testCatalogs

public void testCatalogs()
                  throws SQLException

Test DatabaseMetaData.getCatalogs.

Throws:

SQLException - if a database error occurs

testGetColumns

public void testGetColumns()
                    throws SQLException

Check DatabaseMetadata.getColumns.

Throws:

SQLException - if a database error occurs

testGetCrossReference

public void testGetCrossReference()
                           throws SQLException

Check DatabaseMetadata.getCrossReference

Throws:

SQLException - if a database error occurs

testGetProcedureColumns

public void testGetProcedureColumns()
                             throws SQLException

Check DatabaseMetadata.getProcedureColumns.

Throws:

SQLException - if a database error occurs

testGetProcedures

public void testGetProcedures()
                       throws SQLException

Check DatabaseMetadata.getProcedures.

Throws:

SQLException - if a database error occurs

testGetTablePrivileges

public void testGetTablePrivileges()
                            throws SQLException

Check DatabaseMetadata.getTablePrivileges.

Throws:

SQLException - if a database error occurs

testGetTables

public void testGetTables()
                   throws SQLException

Test DatabaseMetaData.getTableTypes, getTables. Check for Table Types. Retrieve all tables and tables of a given table type. Check the data for consistency.

Throws:

SQLException - if a database error occurs

testGetVersionColumns

public void testGetVersionColumns()
                           throws SQLException

Check DatabaseMetadata.getVersionColumns.

Throws:

SQLException - if a database error occurs

testKeysIndex

public void testKeysIndex()
                   throws SQLException

Check DatabaseMetadata.get{Primary, Exported, Imported}Keys, getColumnPrivileges, getIndexInfo, getBestRowIdentifier.

Throws:

SQLException - if a database error occurs

testPrimaryKey

public void testPrimaryKey()
                    throws SQLException

Test DatabaseMetaData.getPrimaryKey. Return the information on the table, check the validity of the data. NB: The rows have to be ordered by COLUMN_NAME, while KEY_SEQ should reflect the order within the key.

Throws:

SQLException - if a database error occurs

testSchemas

public void testSchemas()
                 throws SQLException

Test DatabaseMetaData.getSchemas

Throws:

SQLException - if a database error occurs

testTableTypes

public void testTableTypes()
                    throws SQLException

Test DatabaseMetaData.getTableTypes.

Throws:

SQLException - if a database error occurs

testTypeInfo

public void testTypeInfo()
                  throws SQLException

Test DatabaseMetaData.getTypeInfo.

Throws:

SQLException - if a database error occurs

testUDTs

public void testUDTs()
              throws SQLException

Test DatabaseMetaData.getUDTs

Throws:

SQLException - if a database error occurs