mondrian.gui
Class JdbcMetaData

java.lang.Object
  extended by mondrian.gui.JdbcMetaData

public class JdbcMetaData
extends 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)  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
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
 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)

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