mondrian.gui
Class JdbcMetaData

java.lang.Object
  mondrian.gui.JdbcMetaData

public class JdbcMetaData
extends java.lang.Object

Version:

$Id: //open/mondrian/src/main/mondrian/gui/JdbcMetaData.java#5 $

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

jdbcDriverClassName

java.lang.String jdbcDriverClassName

jdbcUsername

java.lang.String jdbcUsername

jdbcConnectionUrl

java.lang.String jdbcConnectionUrl

jdbcPassword

java.lang.String jdbcPassword

jdbcSchema

java.lang.String jdbcSchema

requireSchema

boolean requireSchema

conn

java.sql.Connection conn

md

java.sql.DatabaseMetaData md

workbench

Workbench workbench

LEVEL_SEPARATOR

public static final java.lang.String LEVEL_SEPARATOR

See Also:

Constant Field Values

Constructor Detail

JdbcMetaData

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)

JdbcMetaData

public JdbcMetaData(java.lang.String jdbcDriverClassName,
                    java.lang.String jdbcConnectionUrl,
                    java.lang.String jdbcUsername,
                    java.lang.String jdbcPassword)

Tests database connection. Called from Preferences dialog button test connection.

Method Detail

getRequireSchema

public boolean getRequireSchema()

getResourceConverter

public I18n getResourceConverter()

Returns:

the workbench i18n converter

initConnection

public java.lang.String initConnection()

closeConnection

public void closeConnection()

listAllSchemas

public java.util.List<java.lang.String> listAllSchemas()

getAllSchemas

public java.util.List<java.lang.String> getAllSchemas()

getAllTables

public java.util.List<java.lang.String> getAllTables(java.lang.String schemaName)

Returns all tables in a given schema.

getAllTables

public 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.

getFactTables

public java.util.List<java.lang.String> getFactTables(java.lang.String schemaName)

getDimensionTables

public 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.

isTableExists

public boolean isTableExists(java.lang.String schemaName,
                             java.lang.String tableName)

isColExists

public boolean isColExists(java.lang.String schemaName,
                           java.lang.String tableName,
                           java.lang.String colName)

getFactTableFKs

public java.util.List<java.lang.String> getFactTableFKs(java.lang.String schemaName,
                                                        java.lang.String factTable)

getTablePK

public java.lang.String getTablePK(java.lang.String schemaName,
                                   java.lang.String tableName)

getAllColumns

public java.util.List<java.lang.String> getAllColumns(java.lang.String schemaName,
                                                      java.lang.String tableName)

Gets all columns of given table in schema. column string is formatted.

getAllDbColumns

public java.util.List<JdbcMetaData.DbColumn> getAllDbColumns(java.lang.String schemaName,
                                                             java.lang.String tableName)

Returns all columns of given table in schema. Column string is formatted.

getColumnDataType

public int getColumnDataType(java.lang.String schemaName,
                             java.lang.String tableName,
                             java.lang.String colName)

getColumnDefinition

public JdbcMetaData.DbColumn getColumnDefinition(java.lang.String schemaName,
                                                 java.lang.String tableName,
                                                 java.lang.String colName)

Gets column definition of given table and its col.

Parameters:

schemaName - Schema name

tableName - Table name

colName - Column name

Returns:

Column definition

getDbCatalogName

public java.lang.String getDbCatalogName()

getDatabaseProductName

public java.lang.String getDatabaseProductName()

getJdbcConnectionUrl

public java.lang.String getJdbcConnectionUrl()

getErrMsg

public java.lang.String getErrMsg()

main

public static void main(java.lang.String[] args)