org.dbunit.util

Class SQLHelper

java.lang.Object

org.dbunit.util.SQLHelper

public class SQLHelper
extends Object

Helper for SQL-related stuff.
TODO: testcases, also think about refactoring so that methods are not static anymore (for better extensibility)

Since:

Nov 5, 2005

Version:

$Revision: 900 $

Author:

Felipe Leme (dbunit@felipeal.net)

Field Summary

Fields

Modifier and Type	Field and Description
static String	DB_PRODUCT_SYBASE The database product name reported by Sybase JDBC drivers.

Method Summary

Methods

Modifier and Type	Method and Description
static void	close(ResultSet resultSet) Closes the given result set in a null-safe way
static void	close(ResultSet rs, Statement stmt) Close a result set and a prepared statement, checking for null references.
static void	close(Statement stmt) Close a SQL statement, checking for null references.
static Column	createColumn(ResultSet resultSet, IDataTypeFactory dataTypeFactory, boolean datatypeWarning) Utility method to create a Column object from a SQL ResultSet object.
static String	getDatabaseInfo(DatabaseMetaData metaData) Returns the database and JDBC driver information as pretty formatted string
static String	getPrimaryKeyColumn(Connection conn, String table) Gets the primary column for a table.
static boolean	isSybaseDb(DatabaseMetaData metaData) Detects whether or not the given metadata describes the connection to a Sybase database or not.
static boolean	matches(ResultSet resultSet, String schema, String table, boolean caseSensitive) Checks if the given resultSet matches the given schema and table name.
static boolean	matches(ResultSet resultSet, String catalog, String schema, String table, String column, boolean caseSensitive) Checks if the given resultSet matches the given schema and table name.
static void	printAllTables(DatabaseMetaData metaData, PrintStream outputStream) Utility method for debugging to print all tables of the given metadata on the given stream
static void	printDatabaseInfo(DatabaseMetaData metaData, PrintStream outputStream) Prints the database and JDBC driver information to the given output stream
static boolean	schemaExists(Connection connection, String schema) Returns true if the given schema exists for the given connection.
static boolean	tableExists(DatabaseMetaData metaData, String schema, String tableName) Checks if the given table exists.

Methods inherited from class java.lang.Object

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

Field Detail

DB_PRODUCT_SYBASE

public static final String DB_PRODUCT_SYBASE

The database product name reported by Sybase JDBC drivers.

See Also:

Constant Field Values

Method Detail

getPrimaryKeyColumn

public static String getPrimaryKeyColumn(Connection conn,
                         String table)
                                  throws SQLException

Gets the primary column for a table.

Parameters:

conn - connection with the database

table - table name

Returns:

name of primary column for a table (assuming it's just 1 column).

Throws:

SQLException - raised while getting the meta data

close

public static void close(ResultSet rs,
         Statement stmt)
                  throws SQLException

Close a result set and a prepared statement, checking for null references.

Parameters:

rs - result set to be closed

stmt - prepared statement to be closed

Throws:

SQLException - exception raised in either close() method

close

public static void close(Statement stmt)
                  throws SQLException

Close a SQL statement, checking for null references.

Parameters:

stmt - statement to be closed

Throws:

SQLException - exception raised while closing the statement

close

public static void close(ResultSet resultSet)
                  throws SQLException

Closes the given result set in a null-safe way

Parameters:

resultSet -

Throws:

SQLException

schemaExists

public static boolean schemaExists(Connection connection,
                   String schema)
                            throws SQLException

Returns true if the given schema exists for the given connection.

Parameters:

connection - The connection to a database

schema - The schema to be searched

Returns:

Returns true if the given schema exists for the given connection.

Throws:

SQLException

Since:

2.3.0

tableExists

public static boolean tableExists(DatabaseMetaData metaData,
                  String schema,
                  String tableName)
                           throws SQLException

Checks if the given table exists.

Parameters:

metaData - The database meta data

schema - The schema in which the table should be searched. If null the schema is not used to narrow the table name.

tableName - The table name to be searched

Returns:

Returns true if the given table exists in the given schema. Else returns false.

Throws:

SQLException

Since:

2.3.0

printAllTables

public static void printAllTables(DatabaseMetaData metaData,
                  PrintStream outputStream)
                           throws SQLException

Utility method for debugging to print all tables of the given metadata on the given stream

Parameters:

metaData -

outputStream -

Throws:

SQLException

getDatabaseInfo

public static String getDatabaseInfo(DatabaseMetaData metaData)
                              throws SQLException

Returns the database and JDBC driver information as pretty formatted string

Parameters:

metaData - The JDBC database metadata needed to retrieve database information

Returns:

The database information as formatted string

Throws:

SQLException

printDatabaseInfo

public static void printDatabaseInfo(DatabaseMetaData metaData,
                     PrintStream outputStream)
                              throws SQLException

Prints the database and JDBC driver information to the given output stream

Parameters:

metaData - The JDBC database metadata needed to retrieve database information

outputStream - The stream to which the information is printed

Throws:

SQLException

isSybaseDb

public static boolean isSybaseDb(DatabaseMetaData metaData)
                          throws SQLException

Detects whether or not the given metadata describes the connection to a Sybase database or not.

Parameters:

metaData - The metadata to be checked whether it is a Sybase connection

Returns:

true if and only if the given metadata belongs to a Sybase database.

Throws:

SQLException

createColumn

public static final Column createColumn(ResultSet resultSet,
                  IDataTypeFactory dataTypeFactory,
                  boolean datatypeWarning)
                                 throws SQLException,
                                        DataTypeException

Utility method to create a Column object from a SQL ResultSet object.

Parameters:

resultSet - A result set produced via DatabaseMetaData.getColumns(String, String, String, String)

dataTypeFactory - The factory used to lookup the DataType for this column

datatypeWarning - Whether or not a warning should be printed if the column could not be created because of an unknown datatype.

Returns:

The Column or null if the column could not be initialized because of an unknown datatype.

Throws:

SQLException

DataTypeException

Since:

2.4.0

matches

public static boolean matches(ResultSet resultSet,
              String schema,
              String table,
              boolean caseSensitive)
                       throws SQLException

Checks if the given resultSet matches the given schema and table name. The comparison is case sensitive.

Parameters:

resultSet - A result set produced via DatabaseMetaData.getColumns(String, String, String, String)

schema - The name of the schema to check. If null it is ignored in the comparison

table - The name of the table to check. If null it is ignored in the comparison

caseSensitive - Whether or not the comparison should be case sensitive or not

Returns:

true if the column metadata of the given resultSet matches the given schema and table parameters.

Throws:

SQLException

Since:

2.4.0

matches

public static boolean matches(ResultSet resultSet,
              String catalog,
              String schema,
              String table,
              String column,
              boolean caseSensitive)
                       throws SQLException

Checks if the given resultSet matches the given schema and table name. The comparison is case sensitive.

Parameters:

resultSet - A result set produced via DatabaseMetaData.getColumns(String, String, String, String)

catalog - The name of the catalog to check. If null it is ignored in the comparison

schema - The name of the schema to check. If null it is ignored in the comparison

table - The name of the table to check. If null it is ignored in the comparison

column - The name of the column to check. If null it is ignored in the comparison

caseSensitive - Whether or not the comparison should be case sensitive or not

Returns:

true if the column metadata of the given resultSet matches the given schema and table parameters.

Throws:

SQLException

Since:

2.4.0