public class JdbcMetaData extends Object
Modifier and Type | Class and 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 |
Modifier and Type | Field and 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 and 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) |
Modifier and Type | Method and 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) |
String jdbcDriverClassName
String jdbcUsername
String jdbcConnectionUrl
String jdbcPassword
String jdbcSchema
boolean requireSchema
Connection conn
public static final String LEVEL_SEPARATOR
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)
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 namepublic String getDbCatalogName()
public String getDatabaseProductName()
public String getJdbcConnectionUrl()