com.liferay.portal.kernel.dao.db

Class DBInspector

java.lang.Object

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

public class DBInspector
extends java.lang.Object

Author:

Adolfo Pérez

Constructor Summary

Constructors

Constructor and Description
DBInspector(java.sql.Connection connection)

Method Summary

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

Methods inherited from class java.lang.Object

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

Constructor Detail

DBInspector

public DBInspector(java.sql.Connection connection)

Method Detail

getCatalog

public java.lang.String getCatalog()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

getColumnsResultSet

public java.sql.ResultSet getColumnsResultSet(java.lang.String tableName)
                                       throws java.sql.SQLException

Throws:

java.sql.SQLException

getSchema

public java.lang.String getSchema()

getTableNames

public java.util.List<java.lang.String> getTableNames(java.lang.String tableNamePattern)
                                               throws java.sql.SQLException

Throws:

java.sql.SQLException

hasColumn

public boolean hasColumn(java.lang.String tableName,
                         java.lang.String columnName)
                  throws java.lang.Exception

Throws:

java.lang.Exception

hasColumnType

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

Throws:

java.lang.Exception

hasIndex

public boolean hasIndex(java.lang.String tableName,
                        java.lang.String indexName)
                 throws java.lang.Exception

Throws:

java.lang.Exception

hasRows

public boolean hasRows(java.lang.String tableName)

hasTable

public boolean hasTable(java.lang.String tableName)
                 throws java.lang.Exception

Throws:

java.lang.Exception

hasTable

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

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

Throws:

java.lang.Exception

hasView

public boolean hasView(java.lang.String viewName)
                throws java.lang.Exception

Throws:

java.lang.Exception

isControlTable

public boolean isControlTable(java.lang.String tableName)

isNullable

public boolean isNullable(java.lang.String tableName,
                          java.lang.String columnName)
                   throws java.sql.SQLException

Throws:

java.sql.SQLException

isObjectTable

public boolean isObjectTable(java.util.List<java.lang.Long> companyIds,
                             java.lang.String tableName)

isPartitionedControlTable

public boolean isPartitionedControlTable(java.lang.String tableName)

normalizeName

public java.lang.String normalizeName(java.lang.String name)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

normalizeName

public java.lang.String normalizeName(java.lang.String name,
                                      java.sql.DatabaseMetaData databaseMetaData)
                               throws java.sql.SQLException

Throws:

java.sql.SQLException