public class JdbcMetadata extends BaseMetadata
Modifier and Type | Class and Description |
---|---|
class |
JdbcMetadata.DbMetadata
The Class DbMetadata.
|
Modifier and Type | Field and Description |
---|---|
protected static Set<String> |
ALLOWED_FOR_SCHEMA_CATALOG
The allowed objects for schemas and catalogs.
|
protected static Set<String> |
ALLOWED_FOR_TABLE
The allowed objects for tables.
|
protected static Set<String> |
ALLOWED_TOP_LEVEL
The allowed top level.
|
protected static Map<String,String> |
METADATA_METHODS
The metadata methods.
|
protected static Map<String,String> |
TYPE_METHODS
The type methods.
|
protected static Map<String,String> |
TYPE_SUPPORT_AS_TEXT
The types which support asText method.
|
protected static Map<String,String> |
TYPE_SUPPORT_DROP_AS_TEXT
The types which support dropAsText method.
|
protected static Map<String,String> |
TYPES_BY_PARENT
The types by parent.
|
TYPES_SUPPORT_REFRESH
ALL_REFS, ALL_TYPES, BASE_CLASS_PATH, DB_DELIMITER, DEFAULT_METHOD, DEFAULT_TYPE, ID_FIELD, METADATA_DELIMITER, SYNONYMS_DATASET_TYPE, TABLE_PRIV, TABLE_PRIVS, TABLES_DATASET_TYPE, TYPE_ALIAS, TYPE_ALIASES, TYPE_ASSEMBLIES, TYPE_ASSEMBLY, TYPE_CATALOG, TYPE_CLASS, TYPE_COLUMN, TYPE_COLUMNS, TYPE_CONSTRAINTS, TYPE_DATA_SET, TYPE_DB_LINK, TYPE_DB_LINKS, TYPE_DBFUNCT, TYPE_DBFUNCTIONS, TYPE_DBINFO, TYPE_DBPROP, TYPE_DBPROPS, TYPE_DIRECTORIES, TYPE_DIRECTORY, TYPE_EK, TYPE_EK_COLUMN, TYPE_EK_COLUMNS, TYPE_EKS, TYPE_EXEC_METHOD, TYPE_EXEC_METHODS, TYPE_FILE, TYPE_FK, TYPE_FK_COLUMN, TYPE_FK_COLUMNS, TYPE_FKS, TYPE_FUNCT, TYPE_FUNCT_PARAMETERS, TYPE_FUNCTS, TYPE_GLOBAL_TEMPORARIES, TYPE_INDEX, TYPE_INDEX_COLUMN, TYPE_INDEX_COLUMNS, TYPE_INDEXES, TYPE_JAVA_CLASSES, TYPE_LOCAL_TEMPORARIES, TYPE_NICKNAME, TYPE_PACKAGE, TYPE_PACKAGE_BODY, TYPE_PACKAGES, TYPE_PARAMETER, TYPE_PARAMETERS, TYPE_PK, TYPE_PK_COLUMN, TYPE_PK_COLUMNS, TYPE_PKS, TYPE_PROC, TYPE_PROC_PARAMETERS, TYPE_PROCS, TYPE_PROCS_FUNCS, TYPE_QUEUE, TYPE_QUEUE_TABLE, TYPE_QUEUE_TABLES, TYPE_QUEUES, TYPE_RECYCLE_BIN, TYPE_RECYCLE_BIN_ITEM, TYPE_SCHEMA, TYPE_SEQUENCE, TYPE_SEQUENCES, TYPE_SYNONYM, TYPE_SYNONYMS, TYPE_SYSTEM_TABLES, TYPE_SYSTEM_VIEWS, TYPE_TABLE, TYPE_TABLES, TYPE_TEMPORARY_TABLES, TYPE_TEMPORARY_VIEWS, TYPE_TRIGGER, TYPE_TRIGGERS, TYPE_TYPE, TYPE_TYPES, TYPE_USER_TYPE, TYPE_USER_TYPES, TYPE_VIEW, TYPE_VIEWS, TYPE_WORKSHEET, TYPE_WORKSHEETS, TYPE_XML_SCHEMA, TYPE_XML_SCHEMAS, VIEWS_DATASET_TYPE
APP, COMMAND, ETL_DRIVER, FORMATTER, IDE_NODE, NO_RANK, WIDGET
Constructor and Description |
---|
JdbcMetadata() |
Modifier and Type | Method and Description |
---|---|
boolean |
allowNotDefault()
Checks if not default objects are allowed in the restricted mode.
|
String |
asText(String catalog,
String schema,
String pattern,
String type,
String metadataId)
Shows object DDL.
|
String |
asTextMethod(String type)
asText method name for the type.
|
static List<String> |
chooseBestIndex(LinkedHashMap<String,List<String>> indexes,
DataSetFields fields)
Choose the best index and return list of fields in the index.
|
String |
createAsText(String sql,
String catalog,
String schema,
String pattern,
String type)
Shows object create DDL.
|
Map<Integer,List<FieldDef>> |
discoverDatabaseTypes()
Discovers database types.
|
String |
dropAsText(String catalog,
String schema,
String pattern,
String type)
Shows object drop DDL.
|
String |
dropAsTextMethod(String type)
dropAsText method name for the type.
|
String |
executeAsText(String catalog,
String schema,
String pattern,
String type,
String metadataId)
Shows object execute SQL.
|
void |
free()
Free the resources.
|
String |
getAllowedSchema()
Gets the allowed schema when in restricted mode.
|
DataSet |
getAllRefs(String catalog,
String schema,
String pattern,
String type)
Get the all references including inner tables.
|
List<Object> |
getCatalogs(boolean hasSchemas)
Gets the catalogs.
|
String[] |
getCatalogSchemaAndPattern(String value)
Gets the catalog schema and pattern from the value.
|
Set<String> |
getCatalogSchemaMetadataAllowed()
Gets the set of allowed database objects for catalogs and schemas when in restricted mode.
|
DataSet |
getDbFunctions(String catalog,
String schema,
String pattern,
String type)
Gets the database functions.
|
List<String> |
getDbInfoObjects()
Gets the database info objects.
|
JdbcMetadata.DbMetadata |
getDbMetadata()
Gets the database metadata.
|
static List<String> |
getDbObjectsByWildcard(String wildcard,
Alias alias,
Driver driver,
Set<String> excludedObjects,
Set<String> includedObjects,
boolean includeViews,
boolean includeTables)
Gets the database objects by a wildcard.
|
List<String> |
getDbObjectTypes()
Gets the database object types.
|
DataSet |
getDbProps(String catalog,
String schema,
String pattern,
String type)
Gets the database properties.
|
static String |
getDeleteRule(Object rule)
Gets the delete rule.
|
String |
getDropAliasAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop alias SQL.
|
String |
getDropAssemblyAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop assembly SQL.
|
String |
getDropDbLinkAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop alias SQL.
|
String |
getDropFunctionAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop function SQL.
|
String |
getDropIndexAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop index SQL.
|
String |
getDropPackageAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop package SQL.
|
String |
getDropProcAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop procedure SQL.
|
String |
getDropSequenceAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop sequence SQL.
|
String |
getDropSynonymAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop db link SQL.
|
String |
getDropTableAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop table SQL.
|
String |
getDropTriggerAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop trigger SQL.
|
String |
getDropTypeAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop type SQL.
|
String |
getDropViewAsText(String catalog,
String schema,
String pattern,
String type)
Gets the drop view SQL.
|
DataSet |
getEKColumns(String catalog,
String schema,
String pattern,
String type)
Gets the external key columns.
|
List<String> |
getEKMetadataTypes()
Gets the external key metadata types.
|
DataSet |
getFKColumns(String catalog,
String schema,
String pattern,
String type)
Gets the foreign key columns.
|
String |
getFkDefinitionAsText(String catalog,
String schema,
String pattern,
String type,
String name)
Gets the foreign key definition as text.
|
List<String> |
getFKMetadataTypes()
Gets the foreign key metadata types.
|
String |
getFksAsText(String catalog,
String schema,
String pattern,
String type)
Gets the foreign key as text.
|
static String |
getFuncParamNameForNull(Object name)
Gets the function parameter name when it is null.
|
static String |
getFuncParamType(Object type)
Gets the function parameter type.
|
static String |
getFuncRetType(Object type)
Gets the function return type.
|
List<String> |
getFunctMetadataTypes()
Gets the function metadata types.
|
DataSet |
getFunctParameters(String catalog,
String schema,
String pattern,
String type)
Gets the function parameters.
|
DataSet |
getFuncts(String catalog,
String schema,
String pattern,
String type)
Gets the functions.
|
DataSet |
getIndexColumns(String catalog,
String schema,
String pattern,
String type)
Gets the index columns.
|
String |
getIndexDefinitionAsText(String catalog,
String schema,
String pattern,
String type,
String tableName,
String name,
boolean unique,
String suffix,
boolean toUpper,
boolean leadingNumberNotAllowed)
Gets the index definition as text.
|
String |
getIndexesAsText(String catalog,
String schema,
String pattern,
String type,
String tName,
String suffix,
boolean toUpper,
boolean leadingNumberNotAllowed)
Gets the indexes as text.
|
List<String> |
getIndexMetadataTypes()
Gets the index metadata types.
|
String |
getLicensePropertyName()
Gets the name of the license property.
|
Map<String,String> |
getMetadataMethods()
Gets the metadata methods.
|
String |
getName()
Gets the name.
|
List<Object> |
getOwners()
Gets the owners.
|
DataSet |
getParameters(String catalog,
String schema,
String pattern,
String type)
Gets the parameters.
|
String |
getPkAsText(String catalog,
String schema,
String pattern,
String type)
Gets the primary key as text.
|
DataSet |
getPKColumns(String catalog,
String schema,
String pattern,
String type)
Gets the primary key columns.
|
List<String> |
getPKMetadataTypes()
Gets the primary key metadata types.
|
List<String> |
getProcMetadataTypes()
Gets the procedure metadata types.
|
DataSet |
getProcParameters(String catalog,
String schema,
String pattern,
String type)
Gets the procedure parameters.
|
DataSet |
getProcs(String catalog,
String schema,
String pattern,
String type)
Gets the procedures.
|
static String |
getProcsRetType(Object type)
Gets the procedure return type.
|
List<Object> |
getSchemas(String catalog)
Gets the schemas.
|
static List<String> |
getSuggestedKeyFields(Connection connection,
Driver driver,
String theTableName,
DataSetFields dataSetFields)
Gets the suggested key fields.
|
String |
getTableAsText(String catalog,
String schema,
String pattern,
String type)
Gets the table as text.
|
DataSet |
getTableColumns(String catalog,
String schema,
String pattern,
String type)
Gets the table columns.
|
DataSet |
getTableEKs(String catalog,
String schema,
String pattern,
String type)
Gets the table external keys.
|
DataSet |
getTableEKs(String catalog,
String schema,
String pattern,
String type,
DataSet dataSet)
Gets the table external keys.
|
DataSet |
getTableFKs(String catalog,
String schema,
String pattern,
String type)
Gets the table foreign keys.
|
DataSet |
getTableIndexes(String catalog,
String schema,
String pattern,
String type)
Gets the table indexes.
|
Set<String> |
getTableMetadataAllowed()
Gets the set of allowed database objects for tables when in restricted mode.
|
List<String> |
getTableMetadataTypes()
Gets the table metadata types.
|
String |
getTableNameAsText(String catalog,
String schema,
String pattern,
String type,
String name)
Gets the table name as text.
|
DataSet |
getTablePKs(String catalog,
String schema,
String pattern,
String type)
Gets the table primary key.
|
DataSet |
getTablePrivs(String catalog,
String schema,
String pattern,
String type)
Gets the table privileges.
|
DataSet |
getTablesByType(String catalog,
String schema,
String pattern,
String type)
Gets the tables by type.
|
List<String> |
getTableTypes()
Gets the table types.
|
Set<String> |
getTopLevelAllowed()
Gets the set of allowed top level database objects when in restricted mode.
|
List<Object> |
getTopLevelDbObjects()
Gets the top level database objects.
|
String |
getTransIsolation(Object value)
Gets the transaction isolation level.
|
String |
getTypeByTypeFieldValue(String value)
Gets the type by type field value.
|
String |
getTypeField()
Gets the type field.
|
Map<String,String> |
getTypeMethods()
Gets the type methods.
|
DataSet |
getTypes(String catalog,
String schema,
String pattern,
String type)
Gets the types.
|
Map<String,String> |
getTypesByParent()
Gets the types by parent.
|
static String |
getUpdateRule(Object rule)
Gets the update rule.
|
String |
getVendor()
Gets the vendor.
|
String |
getVersion()
Gets the version of the extension module.
|
List<String> |
getViewMetadataTypes()
Gets the view metadata types.
|
boolean |
isOutParam(String parType)
Checks if this is output parameter.
|
boolean |
isUnique(DataSet dataSet,
int row)
Checks if index is unique using given data set with indexes and row which
is a number of the index.
|
boolean |
needToPopulate(String type)
Checks if metadata node needs to be populatet.
|
static void |
populateTables(List<String> objects,
DataSet tables,
Metadata metadata,
String wildcard,
Set<String> excludedObjects,
Set<String> includedObjects)
Populate tables.
|
boolean |
supportsAsText(String type)
Checks if metadata driver supports asText method for the type.
|
boolean |
supportsDrop(String type)
Checks if metadata driver supports dropAsText method for the type.
|
boolean |
supportsExecute(String type)
Checks if metadata driver supports executeAsText method for the type.
|
compareTo, getColumns, getConfigFileName, getConnectionFactory, getConnectionParamsProvider, getCurrentDatabase, getDefaultColumns, getDisplayName, getDriver, getExtensionRank, getFullObjectName, getIconPath, getLocalUnitClassPath, getMetadataByType, getMetadataByTypePreserveException, getMetadataTypeByParentType, getMetadataTypes, getObjectName, getObjectOwnerName, getObjectTypes, getType, getXmlConfigFileName, hasCatalogs, hasMetadataTypes, hasSchemas, init, isDatabaseCurrent, searchDatabase, setCurrentDatabase, setHasCatalogs, setHasSchemas, supportsRefresh, supportsSearchDatabase
protected static Map<String,String> TYPE_METHODS
protected static Map<String,String> METADATA_METHODS
protected static Map<String,String> TYPES_BY_PARENT
protected static Map<String,String> TYPE_SUPPORT_AS_TEXT
protected static Map<String,String> TYPE_SUPPORT_DROP_AS_TEXT
protected static Set<String> ALLOWED_TOP_LEVEL
protected static Set<String> ALLOWED_FOR_SCHEMA_CATALOG
protected static Set<String> ALLOWED_FOR_TABLE
public static String getDeleteRule(Object rule)
rule
- the rulepublic static String getFuncParamNameForNull(Object name)
name
- the namepublic static String getFuncParamType(Object type)
type
- the typepublic static String getFuncRetType(Object type)
type
- the typepublic static String getProcsRetType(Object type)
type
- the typepublic static String getUpdateRule(Object rule)
rule
- the rulepublic boolean allowNotDefault()
Metadata
public String asText(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
Metadata
asText
in interface Metadata
asText
in class BaseMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typemetadataId
- the metadata idException
- in case of any errorpublic String asTextMethod(String type)
type
- the typepublic String createAsText(String sql, String catalog, String schema, String pattern, String type)
Metadata
sql
- the sqlcatalog
- the catalogschema
- the schemapattern
- the patterntype
- the typepublic Map<Integer,List<FieldDef>> discoverDatabaseTypes() throws Exception
Metadata
Exception
- in case of any errorpublic String dropAsText(String catalog, String schema, String pattern, String type) throws Exception
Metadata
dropAsText
in interface Metadata
dropAsText
in class BaseMetadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String dropAsTextMethod(String type)
type
- the typepublic String executeAsText(String catalog, String schema, String pattern, String type, String metadataId) throws Exception
Metadata
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typemetadataId
- the metadata idException
- in case of any errorpublic void free()
Metadata
public String getAllowedSchema()
Metadata
public DataSet getAllRefs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<Object> getCatalogs(boolean hasSchemas) throws Exception
hasSchemas
- the "has schemas" flagException
- in case of any errorpublic String[] getCatalogSchemaAndPattern(String value)
value
- an array where catalog is a first element, schema is a second
and pattern is a thirdpublic Set<String> getCatalogSchemaMetadataAllowed()
Metadata
public DataSet getDbFunctions(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getDbInfoObjects() throws Exception
Exception
- in case of any errorpublic JdbcMetadata.DbMetadata getDbMetadata() throws Exception
Exception
- in case of any errorpublic List<String> getDbObjectTypes() throws Exception
Exception
- in case of any errorpublic DataSet getDbProps(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getDropAliasAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropAssemblyAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropDbLinkAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropFunctionAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropIndexAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropPackageAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropProcAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropSequenceAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropSynonymAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropTableAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropTriggerAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropTypeAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic String getDropViewAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- the exceptionpublic DataSet getEKColumns(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getEKMetadataTypes()
public DataSet getFKColumns(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getFkDefinitionAsText(String catalog, String schema, String pattern, String type, String name) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typename
- the nameException
- in case of any errorpublic List<String> getFKMetadataTypes()
public String getFksAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getFunctMetadataTypes()
public DataSet getFunctParameters(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getFuncts(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getIndexColumns(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getIndexDefinitionAsText(String catalog, String schema, String pattern, String type, String tableName, String name, boolean unique, String suffix, boolean toUpper, boolean leadingNumberNotAllowed) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typetableName
- the table namename
- the nameunique
- if true the "unique" is added before index namesuffix
- the suffix will be added to the index nametoUpper
- if true converts fields names to upper caseleadingNumberNotAllowed
- the leading number not allowedException
- in case of any errorpublic String getIndexesAsText(String catalog, String schema, String pattern, String type, String tName, String suffix, boolean toUpper, boolean leadingNumberNotAllowed) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typetName
- the table name to replace original table namesuffix
- will be added to the end of the index nametoUpper
- if true converts fields names to upper caseleadingNumberNotAllowed
- the leading number not allowedException
- in case of any errorpublic List<String> getIndexMetadataTypes()
public String getLicensePropertyName()
ExtensionModule
public Map<String,String> getMetadataMethods()
BaseMetadata
getMetadataMethods
in class BaseMetadata
public String getName()
Metadata
public List<Object> getOwners() throws Exception
Exception
- in case of any errorpublic DataSet getParameters(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic String getPkAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getPKColumns(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getPKMetadataTypes()
public List<String> getProcMetadataTypes()
public DataSet getProcParameters(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getProcs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<Object> getSchemas(String catalog) throws Exception
catalog
- the catalogException
- in case of any errorpublic String getTableAsText(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableColumns(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableEKs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableEKs(String catalog, String schema, String pattern, String type, DataSet dataSet) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typedataSet
- the existing data setException
- in case of any errorpublic DataSet getTableFKs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTableIndexes(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic Set<String> getTableMetadataAllowed()
Metadata
public List<String> getTableMetadataTypes()
public String getTableNameAsText(String catalog, String schema, String pattern, String type, String name) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typename
- the nameException
- in case of any errorpublic DataSet getTablePKs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTablePrivs(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic DataSet getTablesByType(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic List<String> getTableTypes() throws Exception
Exception
- in case of any errorpublic Set<String> getTopLevelAllowed()
Metadata
public List<Object> getTopLevelDbObjects() throws Exception
Metadata
Exception
- in case of any errorpublic String getTransIsolation(Object value)
value
- the valuepublic String getTypeByTypeFieldValue(String value)
Metadata
value
- the valuepublic String getTypeField()
Metadata
public Map<String,String> getTypeMethods()
Metadata
public DataSet getTypes(String catalog, String schema, String pattern, String type) throws Exception
catalog
- the catalogschema
- the schemapattern
- the patterntype
- the typeException
- in case of any errorpublic Map<String,String> getTypesByParent()
BaseMetadata
getTypesByParent
in class BaseMetadata
public String getVendor()
ExtensionModule
public String getVersion()
ExtensionModule
public List<String> getViewMetadataTypes()
public boolean isOutParam(String parType)
parType
- the parameter typepublic boolean isUnique(DataSet dataSet, int row)
dataSet
- the data set with indexesrow
- the a number of the indexpublic boolean needToPopulate(String type)
Metadata
type
- the typepublic boolean supportsAsText(String type)
Metadata
supportsAsText
in interface Metadata
supportsAsText
in class BaseMetadata
type
- the typepublic boolean supportsDrop(String type)
Metadata
supportsDrop
in interface Metadata
supportsDrop
in class BaseMetadata
type
- the typepublic boolean supportsExecute(String type)
Metadata
type
- the typepublic static void populateTables(List<String> objects, DataSet tables, Metadata metadata, String wildcard, Set<String> excludedObjects, Set<String> includedObjects)
objects
- the objectstables
- the tablesmetadata
- the metadatawildcard
- the wildcardexcludedObjects
- the excluded objectsincludedObjects
- the included objectspublic static List<String> getDbObjectsByWildcard(String wildcard, Alias alias, Driver driver, Set<String> excludedObjects, Set<String> includedObjects, boolean includeViews, boolean includeTables) throws Exception
wildcard
- the wildcardalias
- the aliasdriver
- the driverexcludedObjects
- the excluded objectsincludedObjects
- the included objectsincludeViews
- the include views flagincludeTables
- the include tables flagException
- the exceptionpublic static List<String> chooseBestIndex(LinkedHashMap<String,List<String>> indexes, DataSetFields fields)
indexes
- the indexes and fieldsfields
- the fieldspublic static List<String> getSuggestedKeyFields(Connection connection, Driver driver, String theTableName, DataSetFields dataSetFields) throws Exception
connection
- the connectiondriver
- the drivertheTableName
- the the table namefields
- the fieldsException
- in case of any errorCopyright © 2010-2020 Toolsverse. All Rights Reserved.