Package com.liferay.portal.kernel.dao.db

Class DBInspector

java.lang.Object

com.liferay.portal.kernel.dao.db.DBInspector

public class DBInspector
extends Object

Author:

Adolfo Pérez

Constructor Summary

Constructors

Constructor	Description
DBInspector(Connection connection)

Method Summary

Modifier and Type	Method	Description
String	getCatalog()
ResultSet	getColumnsResultSet(String tableName)
String	getSchema()
List<String>	getTableNames(String tableNamePattern)
boolean	hasColumn(String tableName, String columnName)
boolean	hasColumnType(String tableName, String columnName, String columnType)
boolean	hasIndex(String tableName, String indexName)
boolean	hasRows(String tableName)
boolean	hasTable(String tableName)
boolean	hasTable(String tableName, boolean caseSensitive)	Deprecated. As of Cavanaugh (7.4.x), replaced by hasTable(String)
boolean	hasView(String viewName)
boolean	isControlTable(String tableName)
boolean	isNullable(String tableName, String columnName)
boolean	isNumeric(String tableName, String columnName)
boolean	isObjectTable(String tableName)
boolean	isObjectTable(List<Long> companyIds, String tableName)
boolean	isPartitionedControlTable(String tableName)
String	normalizeName(String name)
String	normalizeName(String name, DatabaseMetaData databaseMetaData)

Methods inherited from class java.lang.Object

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

Constructor Details

DBInspector

public DBInspector(Connection connection)

Method Details

getCatalog

public String getCatalog()
                  throws SQLException

Throws:

SQLException

getColumnsResultSet

public ResultSet getColumnsResultSet(String tableName)
                              throws SQLException

Throws:

SQLException

getSchema

public String getSchema()

getTableNames

public List<String> getTableNames(String tableNamePattern)
                           throws SQLException

Throws:

SQLException

hasColumn

public boolean hasColumn(String tableName,
 String columnName)
                  throws Exception

Throws:

Exception

hasColumnType

public boolean hasColumnType(String tableName,
 String columnName,
 String columnType)
                      throws Exception

Throws:

Exception

hasIndex

public boolean hasIndex(String tableName,
 String indexName)
                 throws Exception

Throws:

Exception

hasRows

public boolean hasRows(String tableName)

hasTable

public boolean hasTable(String tableName)
                 throws Exception

Throws:

Exception

hasTable

@Deprecated
public boolean hasTable(String tableName,
 boolean caseSensitive)
                 throws Exception

Deprecated.

As of Cavanaugh (7.4.x), replaced by hasTable(String)

Throws:

Exception

hasView

public boolean hasView(String viewName)
                throws Exception

Throws:

Exception

isControlTable

public boolean isControlTable(String tableName)

isNullable

public boolean isNullable(String tableName,
 String columnName)
                   throws SQLException

Throws:

SQLException

isNumeric

public boolean isNumeric(String tableName,
 String columnName)
                  throws Exception

Throws:

Exception

isObjectTable

public boolean isObjectTable(List<Long> companyIds,
 String tableName)

isObjectTable

public boolean isObjectTable(String tableName)

isPartitionedControlTable

public boolean isPartitionedControlTable(String tableName)

normalizeName

public String normalizeName(String name)
                     throws SQLException

Throws:

SQLException

normalizeName

public String normalizeName(String name,
 DatabaseMetaData databaseMetaData)
                     throws SQLException

Throws:

SQLException