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
All Methods Static Methods Instance Methods Concrete Methods 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)
-
-
-
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
-
-
Method Detail
-
getRequireSchema
public boolean getRequireSchema()
-
getResourceConverter
public I18n getResourceConverter()
- Returns:
- the workbench i18n converter
-
initConnection
public String initConnection()
-
closeConnection
public void closeConnection()
-
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.
-
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.
-
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 nametableName
- Table namecolName
- 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)
-
-