|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectmondrian.gui.JdbcMetaData
public class JdbcMetaData
Nested Class Summary | |
---|---|
(package private) class |
JdbcMetaData.Database
Database metadata. |
class |
JdbcMetaData.DbColumn
|
(package private) class |
JdbcMetaData.DbSchema
|
(package private) class |
JdbcMetaData.DbTable
|
(package private) class |
JdbcMetaData.FactTable
|
Field Summary | |
---|---|
(package private) java.sql.Connection |
conn
|
(package private) java.lang.String |
jdbcConnectionUrl
|
(package private) java.lang.String |
jdbcDriverClassName
|
(package private) java.lang.String |
jdbcPassword
|
(package private) java.lang.String |
jdbcSchema
|
(package private) java.lang.String |
jdbcUsername
|
static java.lang.String |
LEVEL_SEPARATOR
|
(package private) java.sql.DatabaseMetaData |
md
|
(package private) boolean |
requireSchema
|
(package private) Workbench |
workbench
|
Constructor Summary | |
---|---|
JdbcMetaData(java.lang.String jdbcDriverClassName,
java.lang.String jdbcConnectionUrl,
java.lang.String jdbcUsername,
java.lang.String jdbcPassword)
Tests database connection. |
|
JdbcMetaData(Workbench wb,
java.lang.String jdbcDriverClassName,
java.lang.String jdbcConnectionUrl,
java.lang.String jdbcUsername,
java.lang.String jdbcPassword,
java.lang.String jdbcSchema,
boolean requireSchema)
|
Method Summary | |
---|---|
void |
closeConnection()
|
java.util.List<java.lang.String> |
getAllColumns(java.lang.String schemaName,
java.lang.String tableName)
Gets all columns of given table in schema. |
java.util.List<JdbcMetaData.DbColumn> |
getAllDbColumns(java.lang.String schemaName,
java.lang.String tableName)
Returns all columns of given table in schema. |
java.util.List<java.lang.String> |
getAllSchemas()
|
java.util.List<java.lang.String> |
getAllTables(java.lang.String schemaName)
Returns all tables in a given schema. |
java.util.List<java.lang.String> |
getAllTables(java.lang.String schemaName,
java.lang.String minusTable)
Returns all tables in given schema minus the given table name. |
int |
getColumnDataType(java.lang.String schemaName,
java.lang.String tableName,
java.lang.String colName)
|
JdbcMetaData.DbColumn |
getColumnDefinition(java.lang.String schemaName,
java.lang.String tableName,
java.lang.String colName)
Gets column definition of given table and its col. |
java.lang.String |
getDatabaseProductName()
|
java.lang.String |
getDbCatalogName()
|
java.util.List<java.lang.String> |
getDimensionTables(java.lang.String schemaName,
java.lang.String factTable)
Gets all possible cases of dimension tables which are linked to given fact table by foreign keys. |
java.lang.String |
getErrMsg()
|
java.util.List<java.lang.String> |
getFactTableFKs(java.lang.String schemaName,
java.lang.String factTable)
|
java.util.List<java.lang.String> |
getFactTables(java.lang.String schemaName)
|
java.lang.String |
getJdbcConnectionUrl()
|
boolean |
getRequireSchema()
|
I18n |
getResourceConverter()
|
java.lang.String |
getTablePK(java.lang.String schemaName,
java.lang.String tableName)
|
java.lang.String |
initConnection()
|
boolean |
isColExists(java.lang.String schemaName,
java.lang.String tableName,
java.lang.String colName)
|
boolean |
isTableExists(java.lang.String schemaName,
java.lang.String tableName)
|
java.util.List<java.lang.String> |
listAllSchemas()
|
static void |
main(java.lang.String[] args)
|
Methods inherited from class java.lang.Object |
---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait |
Field Detail |
---|
java.lang.String jdbcDriverClassName
java.lang.String jdbcUsername
java.lang.String jdbcConnectionUrl
java.lang.String jdbcPassword
java.lang.String jdbcSchema
boolean requireSchema
java.sql.Connection conn
java.sql.DatabaseMetaData md
Workbench workbench
public static final java.lang.String LEVEL_SEPARATOR
Constructor Detail |
---|
public JdbcMetaData(Workbench wb, java.lang.String jdbcDriverClassName, java.lang.String jdbcConnectionUrl, java.lang.String jdbcUsername, java.lang.String jdbcPassword, java.lang.String jdbcSchema, boolean requireSchema)
public JdbcMetaData(java.lang.String jdbcDriverClassName, java.lang.String jdbcConnectionUrl, java.lang.String jdbcUsername, java.lang.String jdbcPassword)
Method Detail |
---|
public boolean getRequireSchema()
public I18n getResourceConverter()
public java.lang.String initConnection()
public void closeConnection()
public java.util.List<java.lang.String> listAllSchemas()
public java.util.List<java.lang.String> getAllSchemas()
public java.util.List<java.lang.String> getAllTables(java.lang.String schemaName)
public java.util.List<java.lang.String> getAllTables(java.lang.String schemaName, java.lang.String minusTable)
public java.util.List<java.lang.String> getFactTables(java.lang.String schemaName)
public java.util.List<java.lang.String> getDimensionTables(java.lang.String schemaName, java.lang.String factTable)
public boolean isTableExists(java.lang.String schemaName, java.lang.String tableName)
public boolean isColExists(java.lang.String schemaName, java.lang.String tableName, java.lang.String colName)
public java.util.List<java.lang.String> getFactTableFKs(java.lang.String schemaName, java.lang.String factTable)
public java.lang.String getTablePK(java.lang.String schemaName, java.lang.String tableName)
public java.util.List<java.lang.String> getAllColumns(java.lang.String schemaName, java.lang.String tableName)
public java.util.List<JdbcMetaData.DbColumn> getAllDbColumns(java.lang.String schemaName, java.lang.String tableName)
public int getColumnDataType(java.lang.String schemaName, java.lang.String tableName, java.lang.String colName)
public JdbcMetaData.DbColumn getColumnDefinition(java.lang.String schemaName, java.lang.String tableName, java.lang.String colName)
schemaName
- Schema nametableName
- Table namecolName
- Column name
public java.lang.String getDbCatalogName()
public java.lang.String getDatabaseProductName()
public java.lang.String getJdbcConnectionUrl()
public java.lang.String getErrMsg()
public static void main(java.lang.String[] args)
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |