org.h2.jdbc.meta.DatabaseMeta Maven / Gradle / Ivy

Go to download
Show more of this group Show more artifacts with this name
Show all versions of h2-mvstore Show documentation
Fork of h2database to maintain Java 8 compatibility
The newest version!
/*
 * Copyright 2004-2023 H2 Group. Multiple-Licensed under the MPL 2.0,
 * and the EPL 1.0 (https://h2database.com/html/license.html).
 * Initial Developer: H2 Group
 */
package org.h2.jdbc.meta;

import org.h2.mode.DefaultNullOrdering;
import org.h2.result.ResultInterface;

/**
 * Database meta information.
 */
public abstract class DatabaseMeta {

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#nullsAreSortedHigh()
     * @see java.sql.DatabaseMetaData#nullsAreSortedLow()
     * @see java.sql.DatabaseMetaData#nullsAreSortedAtStart()
     * @see java.sql.DatabaseMetaData#nullsAreSortedAtEnd()
     * @return DefaultNullOrdering
     */
    public abstract DefaultNullOrdering defaultNullOrdering();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getDatabaseProductVersion()
     * @return product version as String
     */
    public abstract String getDatabaseProductVersion();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getSQLKeywords()
     * @return list of supported SQL keywords
     */
    public abstract String getSQLKeywords();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getNumericFunctions()
     * @return list of supported numeric functions
     */
    public abstract String getNumericFunctions();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getStringFunctions()
     * @return list of supported string functions
     */
    public abstract String getStringFunctions();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getSystemFunctions()
     * @return list of supported system functions
     */
    public abstract String getSystemFunctions();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getTimeDateFunctions()
     * @return list of supported time/date functions
     */
    public abstract String getTimeDateFunctions();

    /**
     * INTERNAL
     *
     * @see java.sql.DatabaseMetaData#getSearchStringEscape()
     * @return search string escape sequence
     */
    public abstract String getSearchStringEscape();

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param procedureNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getProcedures(String, String, String)
     */
    public abstract ResultInterface getProcedures(String catalog, String schemaPattern, String procedureNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param procedureNamePattern "LIKE" style pattern to filter result
     * @param columnNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getProcedureColumns(String, String,
     *      String, String)
     */
    public abstract ResultInterface getProcedureColumns(String catalog, String schemaPattern,
            String procedureNamePattern, String columnNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableNamePattern "LIKE" style pattern to filter result
     * @param types String[]
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getTables(String, String, String,
     *      String[])
     */
    public abstract ResultInterface getTables(String catalog, String schemaPattern, String tableNamePattern,
            String[] types);

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getSchemas()
     */
    public abstract ResultInterface getSchemas();

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getCatalogs()
     */
    public abstract ResultInterface getCatalogs();

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getTableTypes()
     */
    public abstract ResultInterface getTableTypes();

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableNamePattern "LIKE" style pattern to filter result
     * @param columnNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getColumns(String, String, String, String)
     */
    public abstract ResultInterface getColumns(String catalog, String schemaPattern, String tableNamePattern,
            String columnNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @param columnNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getColumnPrivileges(String, String,
     *      String, String)
     */
    public abstract ResultInterface getColumnPrivileges(String catalog, String schema, String table,
            String columnNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getTablePrivileges(String, String, String)
     */
    public abstract ResultInterface getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern);

    /**
     * INTERNAL
     * @param catalogPattern "LIKE" style pattern to filter result
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableName table of interest
     * @param scope of interest
     * @param nullable include nullable columns
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getBestRowIdentifier(String, String,
     *      String, int, boolean)
     */
    public abstract ResultInterface getBestRowIdentifier(String catalogPattern, String schemaPattern, String tableName,
            int scope, boolean nullable);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getVersionColumns(String, String, String)
     */
    public abstract ResultInterface getVersionColumns(String catalog, String schema, String table);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getPrimaryKeys(String, String, String)
     */
    public abstract ResultInterface getPrimaryKeys(String catalog, String schema, String table);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getImportedKeys(String, String, String)
     */
    public abstract ResultInterface getImportedKeys(String catalog, String schema, String table);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getExportedKeys(String, String, String)
     */
    public abstract ResultInterface getExportedKeys(String catalog, String schema, String table);

    /**
     * INTERNAL
     * @param primaryCatalog to inspect
     * @param primarySchema to inspect
     * @param primaryTable to inspect
     * @param foreignCatalog to inspect
     * @param foreignSchema to inspect
     * @param foreignTable to inspect
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getCrossReference(String, String, String,
     *      String, String, String)
     */
    public abstract ResultInterface getCrossReference(String primaryCatalog, String primarySchema, String primaryTable,
            String foreignCatalog, String foreignSchema, String foreignTable);

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getTypeInfo()
     */
    public abstract ResultInterface getTypeInfo();

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schema to inspect
     * @param table to inspect
     * @param unique only
     * @param approximate allowed
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getIndexInfo(String, String, String,
     *      boolean, boolean)
     */
    public abstract ResultInterface getIndexInfo(String catalog, String schema, String table, boolean unique,
            boolean approximate);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param typeNamePattern "LIKE" style pattern to filter result
     * @param types int[]
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getUDTs(String, String, String, int[])
     */
    public abstract ResultInterface getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param typeNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getSuperTypes(String, String, String)
     */
    public abstract ResultInterface getSuperTypes(String catalog, String schemaPattern, String typeNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getSuperTables(String, String, String)
     */
    public abstract ResultInterface getSuperTables(String catalog, String schemaPattern, String tableNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param typeNamePattern "LIKE" style pattern to filter result
     * @param attributeNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getAttributes(String, String, String,
     *      String)
     */
    public abstract ResultInterface getAttributes(String catalog, String schemaPattern, String typeNamePattern,
            String attributeNamePattern);

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getDatabaseMajorVersion()
     */
    public abstract int getDatabaseMajorVersion();

    /**
     * INTERNAL
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getDatabaseMinorVersion()
     */
    public abstract int getDatabaseMinorVersion();

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getSchemas(String, String)
     */
    public abstract ResultInterface getSchemas(String catalog, String schemaPattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param functionNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getFunctions(String, String, String)
     */
    public abstract ResultInterface getFunctions(String catalog, String schemaPattern, String functionNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param functionNamePattern "LIKE" style pattern to filter result
     * @param columnNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getFunctionColumns(String, String, String,
     *      String)
     */
    public abstract ResultInterface getFunctionColumns(String catalog, String schemaPattern, //
            String functionNamePattern, String columnNamePattern);

    /**
     * INTERNAL
     * @param catalog to inspect
     * @param schemaPattern "LIKE" style pattern to filter result
     * @param tableNamePattern "LIKE" style pattern to filter result
     * @param columnNamePattern "LIKE" style pattern to filter result
     * @return ResultInterface
     *
     * @see java.sql.DatabaseMetaData#getPseudoColumns(String, String, String,
     *      String)
     */
    public abstract ResultInterface getPseudoColumns(String catalog, String schemaPattern, String tableNamePattern,
            String columnNamePattern);

}