Module org.jooq

Package org.jooq

Interface Meta

All Superinterfaces:

Scope

public interface Meta
extends Scope

A wrapping object for DatabaseMetaData or for other sources of database meta information (e.g. InformationSchema)

This object can be obtained through DSLContext.meta() in order to provide convenient access to your database meta data. This abstraction has two purposes:

1. To increase API convenience, as no checked SQLException is thrown, only the unchecked DataAccessException
2. To increase API convenience, as the returned objects are always jOOQ objects, not JDBC ResultSet objects with hard-to-remember API constraints

This type is a Scope with independent lifecycle and its own Scope.data() map. Its implementations are not required to be thread safe and are likely not. Clients should access separate instances per thread and use-case. Implementations are allowed to cache meta data for faster subsequent access, e.g. by means of snapshot(). Clients should assume that meta data is not up to date if other processes alter the database at the same time as clients access this API.

Author:

Lukas Eder

Method Summary

Modifier and Type	Method	Description
@NotNull Meta	apply(String migration)	Apply a migration to this meta to produce a new Meta.
@NotNull Meta	apply(Collection<? extends Query> migration)	Apply a migration to this meta to produce a new Meta.
@NotNull Meta	apply(Queries migration)	Apply a migration to this meta to produce a new Meta.
@NotNull Meta	apply(Query... migration)	Apply a migration to this meta to produce a new Meta.
@NotNull Queries	ddl()	Generate a creation script for the entire meta data.
@NotNull Queries	ddl(DDLExportConfiguration configuration)	Generate a creation script for the entire meta data.
@NotNull Dependencies	dependencies()	Collect the object dependencies between the various objects in this Meta.
@NotNull Meta	filterCatalogs(Predicate<? super Catalog> filter)	Create a wrapper Meta instance filtering out some catalogs.
@NotNull Meta	filterDomains(Predicate<? super Domain<?>> filter)	Create a wrapper Meta instance filtering out some domains.
@NotNull Meta	filterForeignKeys(Predicate<? super ForeignKey<?,?>> filter)	Create a wrapper Meta instance filtering out some foreign keys.
@NotNull Meta	filterIndexes(Predicate<? super Index> filter)	Create a wrapper Meta instance filtering out some indexes.
@NotNull Meta	filterPrimaryKeys(Predicate<? super UniqueKey<?>> filter)	Create a wrapper Meta instance filtering out some primary keys.
@NotNull Meta	filterSchemas(Predicate<? super Schema> filter)	Create a wrapper Meta instance filtering out some schemas.
@NotNull Meta	filterSequences(Predicate<? super Sequence<?>> filter)	Create a wrapper Meta instance filtering out some sequences.
@NotNull Meta	filterSynonyms(Predicate<? super Synonym> filter)	Create a wrapper Meta instance filtering out some synonym.
@NotNull Meta	filterTables(Predicate<? super Table<?>> filter)	Create a wrapper Meta instance filtering out some tables.
@NotNull Meta	filterTriggers(Predicate<? super Trigger> filter)	Create a wrapper Meta instance filtering out some triggers.
@NotNull Meta	filterUDTs(Predicate<? super UDT<?>> filter)	Create a wrapper Meta instance filtering out some UDTs.
@NotNull Meta	filterUniqueKeys(Predicate<? super UniqueKey<?>> filter)	Create a wrapper Meta instance filtering out some unique keys.
@NotNull Catalog	getCatalog(String name)	Get a catalog object by name from the underlying meta data source, or null if no such object exists.
@NotNull Catalog	getCatalog(Name name)	Get a catalog object by name from the underlying meta data source, or null if no such object exists.
@NotNull List<Catalog>	getCatalogs()	Get all catalog objects from the underlying meta data source.
@NotNull List<Domain<?>>	getDomains()	Get all domain objects from the underlying meta data source.
@NotNull List<Domain<?>>	getDomains(String name)	Get all domain objects by name from the underlying meta data source.
@NotNull List<Domain<?>>	getDomains(Name name)	Get all domain objects by name from the underlying meta data source.
@NotNull List<ForeignKey<?,?>>	getForeignKeys()	Get all foreign keys from the underlying meta data source.
@NotNull List<ForeignKey<?,?>>	getForeignKeys(String name)	Get all foreign keys from the underlying meta data source.
@NotNull List<ForeignKey<?,?>>	getForeignKeys(Name name)	Get all foreign keys from the underlying meta data source.
@NotNull List<Index>	getIndexes()	Get all indexes from the underlying meta data sources.
@NotNull List<Index>	getIndexes(String name)	Get all indexes from the underlying meta data sources.
@NotNull List<Index>	getIndexes(Name name)	Get all indexes from the underlying meta data sources.
@NotNull List<UniqueKey<?>>	getPrimaryKeys()	Get all primary keys from the underlying meta data source.
@NotNull List<UniqueKey<?>>	getPrimaryKeys(String name)	Get all primary keys from the underlying meta data source.
@NotNull List<UniqueKey<?>>	getPrimaryKeys(Name name)	Get all primary keys from the underlying meta data source.
@NotNull List<Synonym>	getPublicSynonyms()	Get all public synonym objects from the underlying meta data source.
@NotNull List<Synonym>	getPublicSynonyms(String name)	Get all public synonym objects by name from the underlying meta data source.
@NotNull List<Synonym>	getPublicSynonyms(Name name)	Get all public synonym objects by name from the underlying meta data source.
@NotNull List<Schema>	getSchemas()	Get all schema objects from the underlying meta data source.
@NotNull List<Schema>	getSchemas(String name)	Get all schema objects by name from the underlying meta data source.
@NotNull List<Schema>	getSchemas(Name name)	Get all schema objects by name from the underlying meta data source.
@NotNull List<Sequence<?>>	getSequences()	Get all sequence objects from the underlying meta data source.
@NotNull List<Sequence<?>>	getSequences(String name)	Get all sequence objects by name from the underlying meta data source.
@NotNull List<Sequence<?>>	getSequences(Name name)	Get all sequence objects by name from the underlying meta data source.
@NotNull List<Synonym>	getSynonyms()	Get all synonym objects from the underlying meta data source.
@NotNull List<Synonym>	getSynonyms(String name)	Get all synonym objects by name from the underlying meta data source.
@NotNull List<Synonym>	getSynonyms(Name name)	Get all synonym objects by name from the underlying meta data source.
@NotNull List<Table<?>>	getTables()	Get all table objects from the underlying meta data source.
@NotNull List<Table<?>>	getTables(String name)	Get all table objects by name from the underlying meta data source.
@NotNull List<Table<?>>	getTables(Name name)	Get all table objects by name from the underlying meta data source.
@NotNull List<Trigger>	getTriggers()	Get all trigger objects from the underlying meta data source.
@NotNull List<Trigger>	getTriggers(String name)	Get all trigger objects by name from the underlying meta data source.
@NotNull List<Trigger>	getTriggers(Name name)	Get all trigger objects by name from the underlying meta data source.
@NotNull List<UDT<?>>	getUDTs()	Get all UDT objects from the underlying meta data source.
@NotNull List<UDT<?>>	getUDTs(String name)	Get all UDT objects by name from the underlying meta data source.
@NotNull List<UDT<?>>	getUDTs(Name name)	Get all UDT objects by name from the underlying meta data source.
@NotNull List<UniqueKey<?>>	getUniqueKeys()	Get all unique keys from the underlying meta data source.
@NotNull List<UniqueKey<?>>	getUniqueKeys(String name)	Get all unique keys from the underlying meta data source.
@NotNull List<UniqueKey<?>>	getUniqueKeys(Name name)	Get all unique keys from the underlying meta data source.
@NotNull InformationSchema	informationSchema()	Export to the InformationSchema format.
@NotNull Queries	migrateTo(Meta other)	Generate a migration script to get from this meta data to another one.
@NotNull Queries	migrateTo(Meta other, MigrationConfiguration configuration)	Generate a migration script to get from this meta data to another one.
@Nullable Domain<?>	resolveDomain(String name)	Resolve a Domain by its name according to interpreter Settings.
@Nullable Domain<?>	resolveDomain(Name name)	Resolve a Domain by its name according to interpreter Settings.
@Nullable Sequence<?>	resolveSequence(String name)	Resolve a Sequence by its name according to interpreter Settings.
@Nullable Sequence<?>	resolveSequence(Name name)	Resolve a Sequence by its name according to interpreter Settings.
@Nullable Synonym	resolveSynonym(String name)	Resolve a Synonym by its name according to interpreter Settings.
@Nullable Synonym	resolveSynonym(Name name)	Resolve a Synonym by its name according to interpreter Settings.
@Nullable Table<?>	resolveTable(String name)	Resolve a Table by its name according to interpreter Settings.
@Nullable Table<?>	resolveTable(Name name)	Resolve a Table by its name according to interpreter Settings.
@Nullable Trigger	resolveTrigger(String name)	Resolve a Trigger by its name according to interpreter Settings.
@Nullable Trigger	resolveTrigger(Name name)	Resolve a Trigger by its name according to interpreter Settings.
@Nullable UDT<?>	resolveUDT(String name)	Resolve a UDT by its name according to interpreter Settings.
@Nullable UDT<?>	resolveUDT(Name name)	Resolve a UDT by its name according to interpreter Settings.
@NotNull Meta	snapshot()	Eager-create an in-memory copy of this Meta instance without any connection to the original data source.

Methods inherited from interface org.jooq.Scope

configuration, creationTime, data, data, data, dialect, dsl, family, settings

Method Details

getCatalogs

@NotNull
@Support
@NotNull List<Catalog> getCatalogs()
                            throws DataAccessException

Get all catalog objects from the underlying meta data source.

For those databases that don't really support JDBC meta data catalogs, a single empty catalog (named "") will be returned. In other words, there is always at least one catalog in a database.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getCatalog

@NotNull
@Support
@NotNull Catalog getCatalog(String name)
                     throws DataAccessException

Get a catalog object by name from the underlying meta data source, or null if no such object exists.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getCatalog

@NotNull
@Support
@NotNull Catalog getCatalog(Name name)
                     throws DataAccessException

Get a catalog object by name from the underlying meta data source, or null if no such object exists.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSchemas

@NotNull
@Support
@NotNull List<Schema> getSchemas()
                          throws DataAccessException

Get all schema objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSchemas

@NotNull
@Support
@NotNull List<Schema> getSchemas(String name)
                          throws DataAccessException

Get all schema objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSchemas

@NotNull
@Support
@NotNull List<Schema> getSchemas(Name name)
                          throws DataAccessException

Get all schema objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getTables

@NotNull
@Support
@NotNull List<Table<?>> getTables()
                           throws DataAccessException

Get all table objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getTables

@NotNull
@Support
@NotNull List<Table<?>> getTables(String name)
                           throws DataAccessException

Get all table objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getTables

@NotNull
@Support
@NotNull List<Table<?>> getTables(Name name)
                           throws DataAccessException

Get all table objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveTable

@Nullable
@Support
@Nullable Table<?> resolveTable(String name)
                         throws DataAccessException

Resolve a Table by its name according to interpreter Settings.

Unlike getTables(String), which may list multiple tables by their case sensitive name, this method finds the best matching table according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such table was found.

Throws:

DataAccessException

resolveTable

@Nullable
@Support
@Nullable Table<?> resolveTable(Name name)
                         throws DataAccessException

Resolve a Table by its name according to interpreter Settings.

Unlike getTables(Name), which may list multiple tables by their case sensitive name, this method finds the best matching table according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such table was found.

Throws:

DataAccessException

getUDTs

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@NotNull List<UDT<?>> getUDTs()
                       throws DataAccessException

Get all UDT objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getUDTs

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@NotNull List<UDT<?>> getUDTs(String name)
                       throws DataAccessException

Get all UDT objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getUDTs

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@NotNull List<UDT<?>> getUDTs(Name name)
                       throws DataAccessException

Get all UDT objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveUDT

@Nullable
@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@Nullable UDT<?> resolveUDT(String name)
                     throws DataAccessException

Resolve a UDT by its name according to interpreter Settings.

Unlike getUDTs(String), which may list multiple UDTs by their case sensitive name, this method finds the best matching UDTs according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such UDTs was found.

Throws:

DataAccessException

resolveUDT

@Nullable
@Support({AURORA_POSTGRES,COCKROACHDB,DUCKDB,INFORMIX,ORACLE,POSTGRES,YUGABYTEDB})
@Nullable UDT<?> resolveUDT(Name name)
                     throws DataAccessException

Resolve a UDT by its name according to interpreter Settings.

Unlike getUDTs(Name), which may list multiple UDTs by their case sensitive name, this method finds the best matching UDTs according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such UDTs was found.

Throws:

DataAccessException

getDomains

@NotNull
@Support({AURORA_POSTGRES,FIREBIRD,H2,HSQLDB,ORACLE23C,POSTGRES,SQLSERVER,YUGABYTEDB})
@NotNull List<Domain<?>> getDomains()
                             throws DataAccessException

Get all domain objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getDomains

@NotNull
@Support({AURORA_POSTGRES,FIREBIRD,H2,HSQLDB,ORACLE23C,POSTGRES,SQLSERVER,YUGABYTEDB})
@NotNull List<Domain<?>> getDomains(String name)
                             throws DataAccessException

Get all domain objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getDomains

@NotNull
@Support({AURORA_POSTGRES,FIREBIRD,H2,HSQLDB,ORACLE23C,POSTGRES,SQLSERVER,YUGABYTEDB})
@NotNull List<Domain<?>> getDomains(Name name)
                             throws DataAccessException

Get all domain objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveDomain

@Nullable
@Support({AURORA_POSTGRES,H2,POSTGRES,SQLSERVER})
@Nullable Domain<?> resolveDomain(String name)
                           throws DataAccessException

Resolve a Domain by its name according to interpreter Settings.

Unlike getDomains(String), which may list multiple domains by their case sensitive name, this method finds the best matching domain according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such domain was found.

Throws:

DataAccessException

resolveDomain

@Nullable
@Support({AURORA_POSTGRES,H2,POSTGRES,SQLSERVER})
@Nullable Domain<?> resolveDomain(Name name)
                           throws DataAccessException

Resolve a Domain by its name according to interpreter Settings.

Unlike getDomains(Name), which may list multiple domains by their case sensitive name, this method finds the best matching domain according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such domain was found.

Throws:

DataAccessException

getTriggers

@NotNull
@Support({AURORA_POSTGRES,DB2,DERBY,FIREBIRD_3_0,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,YUGABYTEDB})
@Pro
@NotNull List<Trigger> getTriggers()
                            throws DataAccessException

Get all trigger objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getTriggers

@NotNull
@Support({AURORA_POSTGRES,DB2,DERBY,FIREBIRD_3_0,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,YUGABYTEDB})
@Pro
@NotNull List<Trigger> getTriggers(String name)
                            throws DataAccessException

Get all trigger objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getTriggers

@NotNull
@Support({AURORA_POSTGRES,DB2,DERBY,FIREBIRD_3_0,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,YUGABYTEDB})
@Pro
@NotNull List<Trigger> getTriggers(Name name)
                            throws DataAccessException

Get all trigger objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveTrigger

@Nullable
@Support({AURORA_POSTGRES,DB2,DERBY,FIREBIRD_3_0,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,YUGABYTEDB})
@Pro
@Nullable Trigger resolveTrigger(String name)
                          throws DataAccessException

Resolve a Trigger by its name according to interpreter Settings.

Unlike getTriggers(String), which may list multiple triggers by their case sensitive name, this method finds the best matching trigger according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such trigger was found.

Throws:

DataAccessException

resolveTrigger

@Nullable
@Support({AURORA_POSTGRES,DB2,DERBY,FIREBIRD_3_0,HSQLDB,INFORMIX,MARIADB,MYSQL,ORACLE,POSTGRES,SQLITE,SQLSERVER,YUGABYTEDB})
@Pro
@Nullable Trigger resolveTrigger(Name name)
                          throws DataAccessException

Resolve a Trigger by its name according to interpreter Settings.

Unlike getTriggers(Name), which may list multiple triggers by their case sensitive name, this method finds the best matching trigger according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such trigger was found.

Throws:

DataAccessException

getSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getSynonyms()
                            throws DataAccessException

Get all synonym objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getSynonyms(String name)
                            throws DataAccessException

Get all synonym objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getSynonyms(Name name)
                            throws DataAccessException

Get all synonym objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveSynonym

@Nullable
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@Nullable Synonym resolveSynonym(String name)
                          throws DataAccessException

Resolve a Synonym by its name according to interpreter Settings.

Unlike getSynonyms(String), which may list multiple synonyms by their case sensitive name, this method finds the best matching synonym according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such synonym was found.

Throws:

DataAccessException

resolveSynonym

@Nullable
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@Nullable Synonym resolveSynonym(Name name)
                          throws DataAccessException

Resolve a Synonym by its name according to interpreter Settings.

Unlike getSynonyms(Name), which may list multiple synonyms by their case sensitive name, this method finds the best matching synonym according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such synonym was found.

Throws:

DataAccessException

getPublicSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getPublicSynonyms()
                                  throws DataAccessException

Get all public synonym objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getPublicSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getPublicSynonyms(String name)
                                  throws DataAccessException

Get all public synonym objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getPublicSynonyms

@NotNull
@Support({DB2,DERBY,H2,HANA,HSQLDB,INFORMIX,ORACLE,SPANNER,SQLSERVER})
@Pro
@NotNull List<Synonym> getPublicSynonyms(Name name)
                                  throws DataAccessException

Get all public synonym objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSequences

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER2012,SYBASE})
@NotNull List<Sequence<?>> getSequences()
                                 throws DataAccessException

Get all sequence objects from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSequences

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER2012,SYBASE})
@NotNull List<Sequence<?>> getSequences(String name)
                                 throws DataAccessException

Get all sequence objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getSequences

@NotNull
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER2012,SYBASE})
@NotNull List<Sequence<?>> getSequences(Name name)
                                 throws DataAccessException

Get all sequence objects by name from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

resolveSequence

@Nullable
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER2012,SYBASE})
@Nullable Sequence<?> resolveSequence(String name)
                               throws DataAccessException

Resolve a Sequence by its name according to interpreter Settings.

Unlike getSequences(String), which may list multiple sequences by their case sensitive name, this method finds the best matching sequence according to the argument as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such sequence was found.

Throws:

DataAccessException

resolveSequence

@Nullable
@Support({AURORA_POSTGRES,COCKROACHDB,CUBRID,DB2,DERBY,FIREBIRD,H2,HANA,HSQLDB,INFORMIX,INGRES,ORACLE,POSTGRES,SNOWFLAKE,SQLSERVER2012,SYBASE})
@Nullable Sequence<?> resolveSequence(Name name)
                               throws DataAccessException

Resolve a Sequence by its name according to interpreter Settings.

Unlike getSequences(Name), which may list multiple sequences by their case sensitive name, this method finds the best matching sequence according to the argument Name.qualifier() as well as the underlying Settings.getInterpreterNameLookupCaseSensitivity() and Settings.getInterpreterSearchPath(), or returns null if no such sequence was found.

Throws:

DataAccessException

getPrimaryKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getPrimaryKeys()
                                    throws DataAccessException

Get all primary keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getPrimaryKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getPrimaryKeys(String name)
                                    throws DataAccessException

Get all primary keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getPrimaryKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getPrimaryKeys(Name name)
                                    throws DataAccessException

Get all primary keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getUniqueKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getUniqueKeys()
                                   throws DataAccessException

Get all unique keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getUniqueKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getUniqueKeys(String name)
                                   throws DataAccessException

Get all unique keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getUniqueKeys

@NotNull
@Support
@NotNull List<UniqueKey<?>> getUniqueKeys(Name name)
                                   throws DataAccessException

Get all unique keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getForeignKeys

@NotNull
@Support
@NotNull List<ForeignKey<?,?>> getForeignKeys()
                                       throws DataAccessException

Get all foreign keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getForeignKeys

@NotNull
@Support
@NotNull List<ForeignKey<?,?>> getForeignKeys(String name)
                                       throws DataAccessException

Get all foreign keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getForeignKeys

@NotNull
@Support
@NotNull List<ForeignKey<?,?>> getForeignKeys(Name name)
                                       throws DataAccessException

Get all foreign keys from the underlying meta data source.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getIndexes

@NotNull
@Support
@NotNull List<Index> getIndexes()
                         throws DataAccessException

Get all indexes from the underlying meta data sources.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getIndexes

@NotNull
@Support
@NotNull List<Index> getIndexes(String name)
                         throws DataAccessException

Get all indexes from the underlying meta data sources.

Throws:

DataAccessException - If something went wrong fetching the meta objects

getIndexes

@NotNull
@Support
@NotNull List<Index> getIndexes(Name name)
                         throws DataAccessException

Get all indexes from the underlying meta data sources.

Throws:

DataAccessException - If something went wrong fetching the meta objects

filterCatalogs

@NotNull
@NotNull Meta filterCatalogs(Predicate<? super Catalog> filter)

Create a wrapper Meta instance filtering out some catalogs.

filterSchemas

@NotNull
@NotNull Meta filterSchemas(Predicate<? super Schema> filter)

Create a wrapper Meta instance filtering out some schemas.

filterTables

@NotNull
@NotNull Meta filterTables(Predicate<? super Table<?>> filter)

Create a wrapper Meta instance filtering out some tables.

filterUDTs

@NotNull
@NotNull Meta filterUDTs(Predicate<? super UDT<?>> filter)

Create a wrapper Meta instance filtering out some UDTs.

filterDomains

@NotNull
@NotNull Meta filterDomains(Predicate<? super Domain<?>> filter)

Create a wrapper Meta instance filtering out some domains.

filterTriggers

@Pro
@NotNull
@NotNull Meta filterTriggers(Predicate<? super Trigger> filter)

Create a wrapper Meta instance filtering out some triggers.

filterSynonyms

@Pro
@NotNull
@NotNull Meta filterSynonyms(Predicate<? super Synonym> filter)

Create a wrapper Meta instance filtering out some synonym.

filterSequences

@NotNull
@NotNull Meta filterSequences(Predicate<? super Sequence<?>> filter)

Create a wrapper Meta instance filtering out some sequences.

filterPrimaryKeys

@NotNull
@NotNull Meta filterPrimaryKeys(Predicate<? super UniqueKey<?>> filter)

Create a wrapper Meta instance filtering out some primary keys.

filterUniqueKeys

@NotNull
@NotNull Meta filterUniqueKeys(Predicate<? super UniqueKey<?>> filter)

Create a wrapper Meta instance filtering out some unique keys.

filterForeignKeys

@NotNull
@NotNull Meta filterForeignKeys(Predicate<? super ForeignKey<?,?>> filter)

Create a wrapper Meta instance filtering out some foreign keys.

filterIndexes

@NotNull
@NotNull Meta filterIndexes(Predicate<? super Index> filter)

Create a wrapper Meta instance filtering out some indexes.

snapshot

@NotNull
@NotNull Meta snapshot()
                throws DataAccessException

Eager-create an in-memory copy of this Meta instance without any connection to the original data source.

Throws:

DataAccessException

dependencies

@NotNull
@NotNull Dependencies dependencies()
                            throws DataAccessException

Collect the object dependencies between the various objects in this Meta.

This is a commercial-only feature.

Throws:

DataAccessException

ddl

@NotNull
@NotNull Queries ddl()
              throws DataAccessException

Generate a creation script for the entire meta data.

Throws:

DataAccessException - If something went wrong fetching the meta objects

ddl

@NotNull
@NotNull Queries ddl(DDLExportConfiguration configuration)
              throws DataAccessException

Generate a creation script for the entire meta data.

Throws:

DataAccessException - If something went wrong fetching the meta objects

apply

@NotNull
@NotNull Meta apply(String migration)
             throws DataAccessException

Apply a migration to this meta to produce a new Meta.

Throws:

DataAccessException - If something went wrong fetching the meta objects

See Also:

• Parser.parse(String)

apply

@NotNull
@NotNull Meta apply(Query... migration)
             throws DataAccessException

Apply a migration to this meta to produce a new Meta.

Throws:

DataAccessException - If something went wrong fetching the meta objects

apply

@NotNull
@NotNull Meta apply(Collection<? extends Query> migration)
             throws DataAccessException

Apply a migration to this meta to produce a new Meta.

Throws:

DataAccessException - If something went wrong fetching the meta objects

apply

@NotNull
@NotNull Meta apply(Queries migration)
             throws DataAccessException

Apply a migration to this meta to produce a new Meta.

Throws:

DataAccessException - If something went wrong fetching the meta objects

migrateTo

@NotNull
@NotNull Queries migrateTo(Meta other)
                    throws DataAccessException

Generate a migration script to get from this meta data to another one.

See migrateTo(Meta, MigrationConfiguration) for more details.

Throws:

DataAccessException - If something went wrong fetching the meta objects

See Also:

• migrateTo(Meta, MigrationConfiguration)

migrateTo

@NotNull
@NotNull Queries migrateTo(Meta other,
 MigrationConfiguration configuration)
                    throws DataAccessException

Generate a migration script to get from this meta data to another one.

To some extent, some database migrations can be generated automatically by comparing two versions of a schema. This is what migrateTo() does. It supports:

• Schema additions / removals
• Table additions / removals
• Column additions / removals
• Column data type changes
• Constraint additions / removals
• Index additions / removals
• Sequence additions / removals
• Comment additions / removals

More complex, structural changes, such as moving some columns from one table to another, or turning a to-one relationship into a to-many relationship, as well as data migrations, can currently not be detected automatically.

Throws:

DataAccessException - If something went wrong fetching the meta objects

informationSchema

@NotNull
@NotNull InformationSchema informationSchema()
                                      throws DataAccessException

Export to the InformationSchema format.

This allows for serialising schema meta information as XML using JAXB. See also Constants.XSD_META for details.

Throws:

DataAccessException