Package mondrian.gui
Class JdbcMetaData
- java.lang.Object
-
- mondrian.gui.JdbcMetaData
-
public class JdbcMetaData extends java.lang.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) 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
Constructors Constructor Description 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
All Methods Static Methods Instance Methods Concrete Methods Modifier and Type Method Description 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)
-
-
-
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 nametableName
- Table namecolName
- 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)
-
-