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
DatabaseMetaData md
Workbench workbench
public static final String LEVEL_SEPARATOR
public JdbcMetaData(Workbench wb, String jdbcDriverClassName, String jdbcConnectionUrl, String jdbcUsername, String jdbcPassword, String jdbcSchema, boolean requireSchema)
public boolean getRequireSchema()
public I18n getResourceConverter()
public String initConnection()
public void closeConnection()
public List<String> getAllTables(String schemaName)
public List<String> getAllTables(String schemaName, String minusTable)
public List<String> getDimensionTables(String schemaName, String factTable)
public List<String> getAllColumns(String schemaName, String tableName)
public List<JdbcMetaData.DbColumn> getAllDbColumns(String schemaName, String tableName)
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()
public String getErrMsg()
public static void main(String[] args)