Package mondrian.gui

Class JdbcMetaData

java.lang.Object

mondrian.gui.JdbcMetaData

public class JdbcMetaData
extends Object

Nested Class Summary

Nested Classes

Modifier and Type	Class	Description
(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

Fields

Modifier and Type	Field	Description
(package private) Connection	conn
(package private) String	jdbcConnectionUrl
(package private) String	jdbcDriverClassName
(package private) String	jdbcPassword
(package private) String	jdbcSchema
(package private) String	jdbcUsername
static String	LEVEL_SEPARATOR
(package private) DatabaseMetaData	md
(package private) boolean	requireSchema
(package private) Workbench	workbench

Constructor Summary

Constructors

Constructor	Description
JdbcMetaData(String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword)	Tests database connection.
JdbcMetaData(Workbench wb, String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword, String jdbcSchema, boolean requireSchema)

Method Summary

Modifier and Type	Method	Description
void	closeConnection()
List<String>	getAllColumns(String schemaName, String tableName)	Gets all columns of given table in schema.
List<JdbcMetaData.DbColumn>	getAllDbColumns(String schemaName, String tableName)	Returns all columns of given table in schema.
List<String>	getAllSchemas()
List<String>	getAllTables(String schemaName)	Returns all tables in a given schema.
List<String>	getAllTables(String schemaName, String minusTable)	Returns all tables in given schema minus the given table name.
int	getColumnDataType(String schemaName, String tableName, String colName)
JdbcMetaData.DbColumn	getColumnDefinition(String schemaName, String tableName, String colName)	Gets column definition of given table and its col.
String	getDatabaseProductName()
String	getDbCatalogName()
List<String>	getDimensionTables(String schemaName, String factTable)	Gets all possible cases of dimension tables which are linked to given fact table by foreign keys.
String	getErrMsg()
List<String>	getFactTableFKs(String schemaName, String factTable)
List<String>	getFactTables(String schemaName)
String	getJdbcConnectionUrl()
boolean	getRequireSchema()
I18n	getResourceConverter()
String	getTablePK(String schemaName, String tableName)
String	initConnection()
boolean	isColExists(String schemaName, String tableName, String colName)
boolean	isTableExists(String schemaName, String tableName)
List<String>	listAllSchemas()
static void	main(String[] args)

Methods inherited from class java.lang.Object

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

Field Detail

jdbcDriverClassName

String jdbcDriverClassName

jdbcUsername

String jdbcUsername

jdbcConnectionUrl

String jdbcConnectionUrl

jdbcPassword

String jdbcPassword

jdbcSchema

String jdbcSchema

requireSchema

boolean requireSchema

conn

Connection conn

md

DatabaseMetaData md

workbench

Workbench workbench

LEVEL_SEPARATOR

public static final String LEVEL_SEPARATOR

See Also:

Constant Field Values

Constructor Detail

JdbcMetaData

public JdbcMetaData(Workbench wb,
                    String jdbcDriverClassName,
                    String jdbcConnectionUrl,
                    String jdbcUsername,
                    String jdbcPassword,
                    String jdbcSchema,
                    boolean requireSchema)

JdbcMetaData

public JdbcMetaData(String jdbcDriverClassName,
                    String jdbcConnectionUrl,
                    String jdbcUsername,
                    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 String initConnection()

closeConnection

public void closeConnection()

listAllSchemas

public List<String> listAllSchemas()

getAllSchemas

public List<String> getAllSchemas()

getAllTables

public List<String> getAllTables(String schemaName)

Returns all tables in a given schema.

getAllTables

public List<String> getAllTables(String schemaName,
                                 String minusTable)

Returns all tables in given schema minus the given table name.

getFactTables

public List<String> getFactTables(String schemaName)

getDimensionTables

public List<String> getDimensionTables(String schemaName,
                                       String factTable)

Gets all possible cases of dimension tables which are linked to given fact table by foreign keys.

isTableExists

public boolean isTableExists(String schemaName,
                             String tableName)

isColExists

public boolean isColExists(String schemaName,
                           String tableName,
                           String colName)

getFactTableFKs

public List<String> getFactTableFKs(String schemaName,
                                    String factTable)

getTablePK

public String getTablePK(String schemaName,
                         String tableName)

getAllColumns

public List<String> getAllColumns(String schemaName,
                                  String tableName)

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

getAllDbColumns

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

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

getColumnDataType

public int getColumnDataType(String schemaName,
                             String tableName,
                             String colName)

getColumnDefinition

public JdbcMetaData.DbColumn getColumnDefinition(String schemaName,
                                                 String tableName,
                                                 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 String getDbCatalogName()

getDatabaseProductName

public String getDatabaseProductName()

getJdbcConnectionUrl

public String getJdbcConnectionUrl()

getErrMsg

public String getErrMsg()

main

public static void main(String[] args)