|
|||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectmondrian.gui.JdbcMetaData
public class JdbcMetaData
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 |
---|
String jdbcDriverClassName
String jdbcUsername
String jdbcConnectionUrl
String jdbcPassword
String jdbcSchema
boolean requireSchema
Connection conn
DatabaseMetaData md
Workbench workbench
public static final String LEVEL_SEPARATOR
Constructor Detail |
---|
public JdbcMetaData(Workbench wb, String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword, String jdbcSchema, boolean requireSchema)
public JdbcMetaData(String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword)
Method Detail |
---|
public boolean getRequireSchema()
public I18n getResourceConverter()
public String initConnection()
public void closeConnection()
public List<String> listAllSchemas()
public List<String> getAllSchemas()
public List<String> getAllTables(String schemaName)
public List<String> getAllTables(String schemaName, String minusTable)
public List<String> getFactTables(String schemaName)
public List<String> getDimensionTables(String schemaName, String factTable)
public boolean isTableExists(String schemaName, String tableName)
public boolean isColExists(String schemaName, String tableName, String colName)
public List<String> getFactTableFKs(String schemaName, String factTable)
public String getTablePK(String schemaName, String tableName)
public List<String> getAllColumns(String schemaName, String tableName)
public List<JdbcMetaData.DbColumn> getAllDbColumns(String schemaName, String tableName)
public int getColumnDataType(String schemaName, String tableName, String colName)
public JdbcMetaData.DbColumn getColumnDefinition(String schemaName, String tableName, String colName)
schemaName
- Schema nametableName
- Table namecolName
- Column name
public String getDbCatalogName()
public String getDatabaseProductName()
public String getJdbcConnectionUrl()
public String getErrMsg()
public static void main(String[] args)
|
|
||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | ||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |