pq_databasemetadata.hxx

Go to the documentation of this file.

/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*************************************************************************
 *
 *  Effective License of whole file:
 *
 *    This library is free software; you can redistribute it and/or
 *    modify it under the terms of the GNU Lesser General Public
 *    License version 2.1, as published by the Free Software Foundation.
 *
 *    This library is distributed in the hope that it will be useful,
 *    but WITHOUT ANY WARRANTY; without even the implied warranty of
 *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 *    Lesser General Public License for more details.
 *
 *    You should have received a copy of the GNU Lesser General Public
 *    License along with this library; if not, write to the Free Software
 *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
 *    MA  02111-1307  USA
 *
 *  Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
 *
 *    The Contents of this file are made available subject to the terms of
 *    the GNU Lesser General Public License Version 2.1
 *
 *    Copyright: 2000 by Sun Microsystems, Inc.
 *
 *    Contributor(s): Joerg Budischewski
 *
 *  All parts contributed on or after August 2011:
 *
 *    This Source Code Form is subject to the terms of the Mozilla Public
 *    License, v. 2.0. If a copy of the MPL was not distributed with this
 *    file, You can obtain one at http://mozilla.org/MPL/2.0/.
 *
 ************************************************************************/
 
#pragma once
 
#include "pq_connection.hxx"
#include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
 
#include <cppuhelper/implbase.hxx>
 
namespace pq_sdbc_driver
{
 
class DatabaseMetaData :
        public ::cppu::WeakImplHelper< css::sdbc::XDatabaseMetaData >
{
    ::rtl::Reference< comphelper::RefCountedMutex > m_xMutex;
    ConnectionSettings *m_pSettings;
    css::uno::Reference< css::sdbc::XConnection > m_origin;
    css::uno::Reference< css::sdbc::XPreparedStatement > m_getIntSetting_stmt;
    css::uno::Reference< css::sdbc::XPreparedStatement > m_getReferences_stmt[16];
    css::uno::Reference< css::sdbc::XPreparedStatement > m_getTablePrivs_stmt;
    css::uno::Reference< css::sdbc::XPreparedStatement > m_getColumnPrivs_stmt;
 
    sal_Int32 getIntSetting(const OUString& settingName);
    sal_Int32 getMaxIndexKeys();
    sal_Int32 getMaxNameLength();
    css::uno::Reference< css::sdbc::XResultSet > getImportedExportedKeys(
        const css::uno::Any& primaryCatalog, const OUString& primarySchema, const OUString& primaryTable,
        const css::uno::Any& foreignCatalog, const OUString& foreignSchema, const OUString& foreignTable );
    void init_getReferences_stmt ();
    void init_getPrivs_stmt ();
 
public:
    DatabaseMetaData(
        ::rtl::Reference< comphelper::RefCountedMutex > reMutex,
        css::uno::Reference< css::sdbc::XConnection > origin,
        ConnectionSettings *pSettings
        );
 
public:
    // Methods
    virtual sal_Bool SAL_CALL allProceduresAreCallable(  ) override;
    virtual sal_Bool SAL_CALL allTablesAreSelectable(  ) override;
    virtual OUString SAL_CALL getURL(  ) override;
    virtual OUString SAL_CALL getUserName(  ) override;
    virtual sal_Bool SAL_CALL isReadOnly(  ) override;
    virtual sal_Bool SAL_CALL nullsAreSortedHigh(  ) override;
    virtual sal_Bool SAL_CALL nullsAreSortedLow(  ) override;
    virtual sal_Bool SAL_CALL nullsAreSortedAtStart(  ) override;
    virtual sal_Bool SAL_CALL nullsAreSortedAtEnd(  ) override;
    virtual OUString SAL_CALL getDatabaseProductName(  ) override;
    virtual OUString SAL_CALL getDatabaseProductVersion(  ) override;
    virtual OUString SAL_CALL getDriverName(  ) override;
    virtual OUString SAL_CALL getDriverVersion(  ) override;
    virtual sal_Int32 SAL_CALL getDriverMajorVersion(  ) override;
    virtual sal_Int32 SAL_CALL getDriverMinorVersion(  ) override;
    virtual sal_Bool SAL_CALL usesLocalFiles(  ) override;
    virtual sal_Bool SAL_CALL usesLocalFilePerTable(  ) override;
    virtual sal_Bool SAL_CALL supportsMixedCaseIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesUpperCaseIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesLowerCaseIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesMixedCaseIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL supportsMixedCaseQuotedIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesUpperCaseQuotedIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesLowerCaseQuotedIdentifiers(  ) override;
    virtual sal_Bool SAL_CALL storesMixedCaseQuotedIdentifiers(  ) override;
    virtual OUString SAL_CALL getIdentifierQuoteString(  ) override;
    virtual OUString SAL_CALL getSQLKeywords(  ) override;
    virtual OUString SAL_CALL getNumericFunctions(  ) override;
    virtual OUString SAL_CALL getStringFunctions(  ) override;
    virtual OUString SAL_CALL getSystemFunctions(  ) override;
    virtual OUString SAL_CALL getTimeDateFunctions(  ) override;
    virtual OUString SAL_CALL getSearchStringEscape(  ) override;
    virtual OUString SAL_CALL getExtraNameCharacters(  ) override;
    virtual sal_Bool SAL_CALL supportsAlterTableWithAddColumn(  ) override;
    virtual sal_Bool SAL_CALL supportsAlterTableWithDropColumn(  ) override;
    virtual sal_Bool SAL_CALL supportsColumnAliasing(  ) override;
    virtual sal_Bool SAL_CALL nullPlusNonNullIsNull(  ) override;
    virtual sal_Bool SAL_CALL supportsTypeConversion(  ) override;
    virtual sal_Bool SAL_CALL supportsConvert( sal_Int32 fromType, sal_Int32 toType ) override;
    virtual sal_Bool SAL_CALL supportsTableCorrelationNames(  ) override;
    virtual sal_Bool SAL_CALL supportsDifferentTableCorrelationNames(  ) override;
    virtual sal_Bool SAL_CALL supportsExpressionsInOrderBy(  ) override;
    virtual sal_Bool SAL_CALL supportsOrderByUnrelated(  ) override;
    virtual sal_Bool SAL_CALL supportsGroupBy(  ) override;
    virtual sal_Bool SAL_CALL supportsGroupByUnrelated(  ) override;
    virtual sal_Bool SAL_CALL supportsGroupByBeyondSelect(  ) override;
    virtual sal_Bool SAL_CALL supportsLikeEscapeClause(  ) override;
    virtual sal_Bool SAL_CALL supportsMultipleResultSets(  ) override;
    virtual sal_Bool SAL_CALL supportsMultipleTransactions(  ) override;
    virtual sal_Bool SAL_CALL supportsNonNullableColumns(  ) override;
    virtual sal_Bool SAL_CALL supportsMinimumSQLGrammar(  ) override;
    virtual sal_Bool SAL_CALL supportsCoreSQLGrammar(  ) override;
    virtual sal_Bool SAL_CALL supportsExtendedSQLGrammar(  ) override;
    virtual sal_Bool SAL_CALL supportsANSI92EntryLevelSQL(  ) override;
    virtual sal_Bool SAL_CALL supportsANSI92IntermediateSQL(  ) override;
    virtual sal_Bool SAL_CALL supportsANSI92FullSQL(  ) override;
    virtual sal_Bool SAL_CALL supportsIntegrityEnhancementFacility(  ) override;
    virtual sal_Bool SAL_CALL supportsOuterJoins(  ) override;
    virtual sal_Bool SAL_CALL supportsFullOuterJoins(  ) override;
    virtual sal_Bool SAL_CALL supportsLimitedOuterJoins(  ) override;
    virtual OUString SAL_CALL getSchemaTerm(  ) override;
    virtual OUString SAL_CALL getProcedureTerm(  ) override;
    virtual OUString SAL_CALL getCatalogTerm(  ) override;
    virtual sal_Bool SAL_CALL isCatalogAtStart(  ) override;
    virtual OUString SAL_CALL getCatalogSeparator(  ) override;
    virtual sal_Bool SAL_CALL supportsSchemasInDataManipulation(  ) override;
    virtual sal_Bool SAL_CALL supportsSchemasInProcedureCalls(  ) override;
    virtual sal_Bool SAL_CALL supportsSchemasInTableDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsSchemasInIndexDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsSchemasInPrivilegeDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsCatalogsInDataManipulation(  ) override;
    virtual sal_Bool SAL_CALL supportsCatalogsInProcedureCalls(  ) override;
    virtual sal_Bool SAL_CALL supportsCatalogsInTableDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsCatalogsInIndexDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsCatalogsInPrivilegeDefinitions(  ) override;
    virtual sal_Bool SAL_CALL supportsPositionedDelete(  ) override;
    virtual sal_Bool SAL_CALL supportsPositionedUpdate(  ) override;
    virtual sal_Bool SAL_CALL supportsSelectForUpdate(  ) override;
    virtual sal_Bool SAL_CALL supportsStoredProcedures(  ) override;
    virtual sal_Bool SAL_CALL supportsSubqueriesInComparisons(  ) override;
    virtual sal_Bool SAL_CALL supportsSubqueriesInExists(  ) override;
    virtual sal_Bool SAL_CALL supportsSubqueriesInIns(  ) override;
    virtual sal_Bool SAL_CALL supportsSubqueriesInQuantifieds(  ) override;
    virtual sal_Bool SAL_CALL supportsCorrelatedSubqueries(  ) override;
    virtual sal_Bool SAL_CALL supportsUnion(  ) override;
    virtual sal_Bool SAL_CALL supportsUnionAll(  ) override;
    virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossCommit(  ) override;
    virtual sal_Bool SAL_CALL supportsOpenCursorsAcrossRollback(  ) override;
    virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossCommit(  ) override;
    virtual sal_Bool SAL_CALL supportsOpenStatementsAcrossRollback(  ) override;
    virtual sal_Int32 SAL_CALL getMaxBinaryLiteralLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxCharLiteralLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnsInGroupBy(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnsInIndex(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnsInOrderBy(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnsInSelect(  ) override;
    virtual sal_Int32 SAL_CALL getMaxColumnsInTable(  ) override;
    virtual sal_Int32 SAL_CALL getMaxConnections(  ) override;
    virtual sal_Int32 SAL_CALL getMaxCursorNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxIndexLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxSchemaNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxProcedureNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxCatalogNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxRowSize(  ) override;
    virtual sal_Bool SAL_CALL doesMaxRowSizeIncludeBlobs(  ) override;
    virtual sal_Int32 SAL_CALL getMaxStatementLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxStatements(  ) override;
    virtual sal_Int32 SAL_CALL getMaxTableNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getMaxTablesInSelect(  ) override;
    virtual sal_Int32 SAL_CALL getMaxUserNameLength(  ) override;
    virtual sal_Int32 SAL_CALL getDefaultTransactionIsolation(  ) override;
    virtual sal_Bool SAL_CALL supportsTransactions(  ) override;
    virtual sal_Bool SAL_CALL supportsTransactionIsolationLevel( sal_Int32 level ) override;
    virtual sal_Bool SAL_CALL supportsDataDefinitionAndDataManipulationTransactions(  ) override;
    virtual sal_Bool SAL_CALL supportsDataManipulationTransactionsOnly(  ) override;
    virtual sal_Bool SAL_CALL dataDefinitionCausesTransactionCommit(  ) override;
    virtual sal_Bool SAL_CALL dataDefinitionIgnoredInTransactions(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedures( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getProcedureColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& procedureNamePattern, const OUString& columnNamePattern ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTables( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const css::uno::Sequence< OUString >& types ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getSchemas(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCatalogs(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTableTypes(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumns( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern, const OUString& columnNamePattern ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getColumnPrivileges( const css::uno::Any& catalog, const OUString& schema, const OUString& table, const OUString& columnNamePattern ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTablePrivileges( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& tableNamePattern ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getBestRowIdentifier( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Int32 scope, sal_Bool nullable ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getVersionColumns( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getPrimaryKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getImportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getExportedKeys( const css::uno::Any& catalog, const OUString& schema, const OUString& table ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getCrossReference( const css::uno::Any& primaryCatalog, const OUString& primarySchema, const OUString& primaryTable, const css::uno::Any& foreignCatalog, const OUString& foreignSchema, const OUString& foreignTable ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getTypeInfo(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getIndexInfo( const css::uno::Any& catalog, const OUString& schema, const OUString& table, sal_Bool unique, sal_Bool approximate ) override;
    virtual sal_Bool SAL_CALL supportsResultSetType( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL supportsResultSetConcurrency( sal_Int32 setType, sal_Int32 concurrency ) override;
    virtual sal_Bool SAL_CALL ownUpdatesAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL ownDeletesAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL ownInsertsAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL othersUpdatesAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL othersDeletesAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL othersInsertsAreVisible( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL updatesAreDetected( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL deletesAreDetected( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL insertsAreDetected( sal_Int32 setType ) override;
    virtual sal_Bool SAL_CALL supportsBatchUpdates(  ) override;
    virtual css::uno::Reference< css::sdbc::XResultSet > SAL_CALL getUDTs( const css::uno::Any& catalog, const OUString& schemaPattern, const OUString& typeNamePattern, const css::uno::Sequence< sal_Int32 >& types ) override;
    virtual css::uno::Reference< css::sdbc::XConnection > SAL_CALL getConnection(  ) override;
};
 
}
 
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */