org.dbunit.database.search

Class TablesDependencyHelper

java.lang.Object

org.dbunit.database.search.TablesDependencyHelper

public class TablesDependencyHelper
extends java.lang.Object

Helper for the graph-search based classes used to calculate dependency among tables.

Since:

Aug 26, 2005

Version:

$Revision$ $Date$

Author:

Felipe Leme (dbunit@felipeal.net), Last changed by: $Author$

Method Summary

Modifier and Type	Method and Description
static IDataSet	getAllDataset(IDatabaseConnection connection, PrimaryKeyFilter.PkTableMap rootTables)
static IDataSet	getAllDataset(IDatabaseConnection connection, java.lang.String rootTable, java.util.Set allowedPKs)
static java.lang.String[]	getAllDependentTables(IDatabaseConnection connection, java.lang.String rootTable) Get the name of all tables that depend on a root table ( i.e, all tables whose PK is a FK for the root table) and also the tables the root table depends on (i.e., all tables which have a FK for the root table's PK).
static java.lang.String[]	getAllDependentTables(IDatabaseConnection connection, java.lang.String[] rootTables) Get the name of all tables that depend on the root tables ( i.e, all tables whose PK is a FK for any of the root tables) and also the tables the root tables depends on (i.e., all tables which have a FK for any of the root table's PK).
static IDataSet	getDataset(IDatabaseConnection connection, PrimaryKeyFilter.PkTableMap rootTables)
static IDataSet	getDataset(IDatabaseConnection connection, java.lang.String rootTable, java.util.Set allowedIds)
static java.lang.String[]	getDependentTables(IDatabaseConnection connection, java.lang.String rootTable) Get the name of all tables that depend on the root tables (i.e, all tables that have FKs pointing to the PK of the root table).
static java.lang.String[]	getDependentTables(IDatabaseConnection connection, java.lang.String[] rootTables) Get the name of all tables that depend on the root tables (i.e, all tables that have FKs pointing to the PK of one of the root tables).
static java.lang.String[]	getDependsOnTables(IDatabaseConnection connection, java.lang.String rootTable) Get the name of all tables that the given rootTable depends on (i.e, all tables whose PK is a FK for the root table).
static java.util.Set	getDirectDependentTables(IDatabaseConnection connection, java.lang.String tableName) Returns a set of tables which directly depend on the given table.
static java.util.Set	getDirectDependsOnTables(IDatabaseConnection connection, java.lang.String tableName) Returns a set of tables on which the given table directly depends on.

Methods inherited from class java.lang.Object

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

Method Detail

getDependentTables

public static java.lang.String[] getDependentTables(IDatabaseConnection connection,
                                                    java.lang.String rootTable)
                                             throws SearchException

Get the name of all tables that depend on the root tables (i.e, all tables that have FKs pointing to the PK of the root table).

Parameters:

connection - database connection

rootTable - root table described above

Returns:

name of all tables that depend on the root table (including the root table), in the right order for insertions

Throws:

SearchException - if an exception occurred while calculating the order

getDependentTables

public static java.lang.String[] getDependentTables(IDatabaseConnection connection,
                                                    java.lang.String[] rootTables)
                                             throws SearchException

Get the name of all tables that depend on the root tables (i.e, all tables that have FKs pointing to the PK of one of the root tables).

Parameters:

connection - database connection

rootTables - array of root tables described above

Returns:

name of all tables that depend on the root tables (including the root tables), in the right order for insertions

Throws:

SearchException - if an exception occurred while calculating the order

getDependsOnTables

public static java.lang.String[] getDependsOnTables(IDatabaseConnection connection,
                                                    java.lang.String rootTable)
                                             throws SearchException

Get the name of all tables that the given rootTable depends on (i.e, all tables whose PK is a FK for the root table).

Parameters:

connection - database connection

rootTable - root table described above

Returns:

name of all tables that the rootTable depends on (including the rootTable itself), in the right order for insertions

Throws:

SearchException - if an exception occurred while calculating the order

Since:

2.4

getAllDependentTables

public static java.lang.String[] getAllDependentTables(IDatabaseConnection connection,
                                                       java.lang.String rootTable)
                                                throws SearchException

Get the name of all tables that depend on a root table ( i.e, all tables whose PK is a FK for the root table) and also the tables the root table depends on (i.e., all tables which have a FK for the root table's PK).

Parameters:

connection - database connection

rootTable - root table described above

Returns:

name of all tables that depend on the root table (including the root table), in the right order for insertions

Throws:

SearchException - if an exception occurred while calculating the order

getAllDependentTables

public static java.lang.String[] getAllDependentTables(IDatabaseConnection connection,
                                                       java.lang.String[] rootTables)
                                                throws SearchException

Get the name of all tables that depend on the root tables ( i.e, all tables whose PK is a FK for any of the root tables) and also the tables the root tables depends on (i.e., all tables which have a FK for any of the root table's PK).

Parameters:

connection - database connection

rootTables - root tables described above

Returns:

name of all tables that depend on the root tables (including the root tables), in the right order for insertions

Throws:

SearchException - if an exception occurred while calculating the order

getDataset

public static IDataSet getDataset(IDatabaseConnection connection,
                                  java.lang.String rootTable,
                                  java.util.Set allowedIds)
                           throws SearchException,
                                  java.sql.SQLException,
                                  DataSetException

Throws:

SearchException

java.sql.SQLException

DataSetException

getDataset

public static IDataSet getDataset(IDatabaseConnection connection,
                                  PrimaryKeyFilter.PkTableMap rootTables)
                           throws SearchException,
                                  java.sql.SQLException,
                                  DataSetException

Throws:

SearchException

java.sql.SQLException

DataSetException

getAllDataset

public static IDataSet getAllDataset(IDatabaseConnection connection,
                                     java.lang.String rootTable,
                                     java.util.Set allowedPKs)
                              throws SearchException,
                                     java.sql.SQLException,
                                     DataSetException

Throws:

SearchException

java.sql.SQLException

DataSetException

getAllDataset

public static IDataSet getAllDataset(IDatabaseConnection connection,
                                     PrimaryKeyFilter.PkTableMap rootTables)
                              throws SearchException,
                                     java.sql.SQLException,
                                     DataSetException

Throws:

SearchException

java.sql.SQLException

DataSetException

getDirectDependsOnTables

public static java.util.Set getDirectDependsOnTables(IDatabaseConnection connection,
                                                     java.lang.String tableName)
                                              throws SearchException

Returns a set of tables on which the given table directly depends on.

Parameters:

connection - The connection to be used for the database lookup.

tableName -

Returns:

a set of tables on which the given table directly depends on.

Throws:

SearchException

Since:

2.4

getDirectDependentTables

public static java.util.Set getDirectDependentTables(IDatabaseConnection connection,
                                                     java.lang.String tableName)
                                              throws SearchException

Returns a set of tables which directly depend on the given table.

Parameters:

connection - The connection to be used for the database lookup.

tableName -

Returns:

a set of tables on which the given table directly depends on.

Throws:

SearchException

Since:

2.4