org.dbunit.dataset
Class DataSetUtils

java.lang.Object
  extended by org.dbunit.dataset.DataSetUtils

public class DataSetUtils
extends Object

This class contains various methods for manipulating datasets.

Since:
Feb 19, 2002
Version:
$Revision: 554 $
Author:
Manuel Laflamme

Method Summary
static void assertEquals(IDataSet expectedDataSet, IDataSet actualDataSet)
          Deprecated. Use Assertion.assertEquals
static void assertEquals(ITable expectedTable, ITable actualTable)
          Deprecated. Use Assertion.assertEquals
static Column getColumn(String columnName, Column[] columns)
          Search and returns the specified column from the specified column array.
static String getEscapedName(String name, String escapePattern)
           
static String getQualifiedName(String prefix, String name)
          Returns the specified name qualified with the specified prefix.
static String getQualifiedName(String prefix, String name, String escapePattern)
           
static String[] getReverseTableNames(IDataSet dataSet)
          Returns the table names from the specified dataset in reverse order.
static String getSqlValueString(Object value, DataType dataType)
          Returns the specified value as a string to be use in an SQL Statement.
static ITable[] getTables(IDataSet dataSet)
          Returns the tables from the specified dataset.
static ITable[] getTables(ITableIterator iterator)
          Returns the tables from the specified iterator.
static ITable[] getTables(String[] names, IDataSet dataSet)
          Search and returns the specified tables from the specified dataSet.
static String[] reverseStringArray(String[] array)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Method Detail

assertEquals

public static void assertEquals(IDataSet expectedDataSet,
                                IDataSet actualDataSet)
                         throws Exception
Deprecated. Use Assertion.assertEquals

Asserts that the two specified dataset are equals. This method ignore the tables order.

Throws:
Exception

assertEquals

public static void assertEquals(ITable expectedTable,
                                ITable actualTable)
                         throws Exception
Deprecated. Use Assertion.assertEquals

Asserts that the two specified tables are equals. This method ignore the table names, the columns order, the columns data type and the primary keys.

Throws:
Exception

getQualifiedName

public static String getQualifiedName(String prefix,
                                      String name)
Returns the specified name qualified with the specified prefix. The name is not modified if the prefix is null or if the name is already qualified.

Example:
getQualifiedName(null, "NAME") returns "NAME". getQualifiedName("PREFIX", "NAME") returns "PREFIX.NAME" and getQualifiedName("PREFIX2", "PREFIX1.NAME") returns "PREFIX1.NAME".

Parameters:
prefix - the prefix
name - the name
Returns:
the qualified name

getQualifiedName

public static String getQualifiedName(String prefix,
                                      String name,
                                      String escapePattern)

getEscapedName

public static String getEscapedName(String name,
                                    String escapePattern)

getSqlValueString

public static String getSqlValueString(Object value,
                                       DataType dataType)
                                throws TypeCastException
Returns the specified value as a string to be use in an SQL Statement. For example the string myValue is returned as 'myValue'.

Parameters:
value - the value
dataType - the value data type
Returns:
the SQL string value
Throws:
TypeCastException

getColumn

public static Column getColumn(String columnName,
                               Column[] columns)
Search and returns the specified column from the specified column array.

Parameters:
columnName - the name of the column to search.
columns - the array of columns from which the column must be searched.
Returns:
the column or null if the column is not found

getTables

public static ITable[] getTables(String[] names,
                                 IDataSet dataSet)
                          throws DataSetException
Search and returns the specified tables from the specified dataSet.

Parameters:
names - the names of the tables to search.
dataSet - the dataset from which the tables must be searched.
Returns:
the tables or an empty array if no tables are found.
Throws:
DataSetException

getTables

public static ITable[] getTables(IDataSet dataSet)
                          throws DataSetException
Returns the tables from the specified dataset.

Throws:
DataSetException

getTables

public static ITable[] getTables(ITableIterator iterator)
                          throws DataSetException
Returns the tables from the specified iterator.

Throws:
DataSetException

getReverseTableNames

public static String[] getReverseTableNames(IDataSet dataSet)
                                     throws DataSetException
Returns the table names from the specified dataset in reverse order.

Throws:
DataSetException

reverseStringArray

public static String[] reverseStringArray(String[] array)


Copyright © 2002-2011. All Rights Reserved.