mondrian.gui
Class JdbcMetaData

java.lang.Object
  extended by 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)

Get Mondrian at SourceForge.net. Fast, secure and free Open Source software downloads