/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the Collabora Office project. * * 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/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ #pragma once #include "CacheSet.hxx" #include "PrivateRow.hxx" #include #include #include #include #include #include #include namespace dbaccess { struct SelectColumnDescription { OUString sRealName; // may be empty OUString sTableName; // may be empty OUString sDefaultValue; sal_Int32 nPosition; sal_Int32 nType; sal_Int32 nScale; bool bNullable; SelectColumnDescription() :nPosition( 0 ) ,nType( 0 ) ,nScale( 0 ) ,bNullable(false) { } SelectColumnDescription( sal_Int32 _nPosition, sal_Int32 _nType, sal_Int32 _nScale, bool _bNullable, OUString _sDefaultValue ) :sDefaultValue(std::move( _sDefaultValue )) ,nPosition( _nPosition ) ,nType( _nType ) ,nScale( _nScale ) ,bNullable(_bNullable) { } }; typedef std::map< OUString, SelectColumnDescription, ::comphelper::UStringMixLess > SelectColumnsMetaData; // the elements of _rxQueryColumns must have the properties PROPERTY_REALNAME and PROPERTY_TABLENAME void getColumnPositions(const css::uno::Reference< css::container::XNameAccess >& _rxQueryColumns, const cpo::uno::Sequence< OUString >& _rColumnNames, std::u16string_view _rsUpdateTableName, SelectColumnsMetaData& o_rColumnNames /* out */, bool i_bAppendTableName = false); struct OKeySetValue { ORowSetRow m_aRowSetRow; sal_Int32 m_nUpdateInsert; rtl::Reference m_xRow; }; typedef std::map OKeySetMatrix; typedef std::map > OUpdatedParameter; // is used when the source supports keys class OKeySet : public OCacheSet { protected: OKeySetMatrix m_aKeyMap; OKeySetMatrix::iterator m_aKeyIter; std::vector< OUString > m_aAutoColumns; // contains all columns which are autoincrement ones OUpdatedParameter m_aUpdatedParameter; // contains all parameter which have been updated and are needed for refetching rtl::Reference m_aParameterValueForCache; std::unique_ptr m_pKeyColumnNames; // contains all key column names std::unique_ptr m_pColumnNames; // contains all column names std::unique_ptr m_pParameterNames; // contains all parameter names std::unique_ptr m_pForeignColumnNames; // contains all column names of the rest connectivity::OSQLTable m_xTable; // reference to our table // we need a different SQL (statement) for each different combination // of NULLness of key & foreign columns; // each subclause is either "colName = ?" or "colName IS NULL" // (we avoid the standard "colName IS NOT DISTINCT FROM ?" because it is not widely supported) typedef std::map< std::vector, css::uno::Reference< css::sdbc::XPreparedStatement > > vStatements_t; vStatements_t m_vStatements; css::uno::Reference< css::sdbc::XPreparedStatement> m_xStatement; css::uno::Reference< css::sdbc::XResultSet> m_xSet; css::uno::Reference< css::sdbc::XRow> m_xRow; css::uno::Reference< css::sdb::XSingleSelectQueryAnalyzer > m_xComposer; const OUString m_sUpdateTableName; std::vector< OUString > m_aFilterColumns; sal_Int32& m_rRowCount; bool m_bRowCountFinal; /** copies the values from the insert row into the key row * * \param _rInsertRow the row which was inserted * \param _rKeyRow The current key row of the row set. + \param i_nBookmark The bookmark is used to update the parameter */ void copyRowValue(const ORowSetRow& _rInsertRow, ORowSetRow const & _rKeyRow, sal_Int32 i_nBookmark); // returns true if it did any work bool fillAllRows(); bool fetchRow(); void invalidateRow(); static void impl_convertValue_throw(const ORowSetRow& _rInsertRow,const SelectColumnDescription& i_aMetaData); void initColumns(); void findTableColumnsMatching_throw( const cpo::uno::Any& i_aTable, const OUString& i_rUpdateTableName, const css::uno::Reference< css::sdbc::XDatabaseMetaData>& i_xMeta, const css::uno::Reference< css::container::XNameAccess>& i_xQueryColumns, std::unique_ptr const & o_pKeyColumnNames); void ensureStatement( ); virtual void makeNewStatement( ); static void setOneKeyColumnParameter( sal_Int32 &nPos, const css::uno::Reference< css::sdbc::XParameters > &_xParameter, const connectivity::ORowSetValue &_rValue, sal_Int32 _nType, sal_Int32 _nScale ); OUStringBuffer createKeyFilter( ); /// @throws css::sdbc::SQLException /// @throws css::uno::RuntimeException bool doTryRefetch_throw(); void tryRefetch(const ORowSetRow& _rInsertRow,bool bRefetch); void executeUpdate(const ORowSetRow& _rInsertRow, const ORowSetRow& _rOriginalRow, const OUString& i_sSQL, std::u16string_view i_sTableName,const std::vector& _aIndexColumnPositions = std::vector()); void executeInsert( const ORowSetRow& _rInsertRow, const OUString& i_sSQL, std::u16string_view i_sTableName, bool bRefetch = false); void executeStatement(OUStringBuffer& io_aFilter, css::uno::Reference< css::sdb::XSingleSelectQueryComposer>& io_xAnalyzer); virtual ~OKeySet() override; public: OKeySet(connectivity::OSQLTable _aTable, OUString _sUpdateTableName, const css::uno::Reference< css::sdb::XSingleSelectQueryAnalyzer >& _xComposer, const ORowSetValueVector& _aParameterValueForCache, sal_Int32 i_nMaxRows, sal_Int32& o_nRowCount); // late ctor which can throw exceptions virtual void construct(const css::uno::Reference< css::sdbc::XResultSet>& _xDriverSet,const OUString& i_sRowSetFilter) override; virtual void reset(const css::uno::Reference< css::sdbc::XResultSet>& _xDriverSet) override; // css::sdbc::XRow virtual bool wasNull( ) override; virtual OUString getString( sal_Int32 columnIndex ) override; virtual bool getBoolean( sal_Int32 columnIndex ) override; virtual sal_Int8 getByte( sal_Int32 columnIndex ) override; virtual sal_Int16 getShort( sal_Int32 columnIndex ) override; virtual sal_Int32 getInt( sal_Int32 columnIndex ) override; virtual sal_Int64 getLong( sal_Int32 columnIndex ) override; virtual float getFloat( sal_Int32 columnIndex ) override; virtual double getDouble( sal_Int32 columnIndex ) override; virtual cpo::uno::Sequence< sal_Int8 > getBytes( sal_Int32 columnIndex ) override; virtual css::util::Date getDate( sal_Int32 columnIndex ) override; virtual css::util::Time getTime( sal_Int32 columnIndex ) override; virtual css::util::DateTime getTimestamp( sal_Int32 columnIndex ) override; virtual css::uno::Reference< css::io::XInputStream > getBinaryStream( sal_Int32 columnIndex ) override; virtual css::uno::Reference< css::io::XInputStream > getCharacterStream( sal_Int32 columnIndex ) override; virtual cpo::uno::Any getObject( sal_Int32 columnIndex, const css::uno::Reference< css::container::XNameAccess >& typeMap ) override; virtual css::uno::Reference< css::sdbc::XRef > getRef( sal_Int32 columnIndex ) override; virtual css::uno::Reference< css::sdbc::XBlob > getBlob( sal_Int32 columnIndex ) override; virtual css::uno::Reference< css::sdbc::XClob > getClob( sal_Int32 columnIndex ) override; virtual css::uno::Reference< css::sdbc::XArray > getArray( sal_Int32 columnIndex ) override; virtual bool rowUpdated( ) override; virtual bool rowInserted( ) override; virtual bool rowDeleted( ) override; bool isBeforeFirst( ); bool isAfterLast( ); // css::sdbc::XResultSet virtual bool next() override; virtual void beforeFirst( ) override; virtual void afterLast( ) override; virtual bool first() override; virtual bool last( ) override; virtual sal_Int32 getRow( ) override; virtual bool absolute( sal_Int32 row ) override; virtual bool previous( ) override; /// @throws css::sdbc::SQLException /// @throws css::uno::RuntimeException void ensureRowForData( ); virtual void refreshRow( ) override; // css::sdbcx::XRowLocate virtual cpo::uno::Any getBookmark() override; virtual bool moveToBookmark( const cpo::uno::Any& bookmark ) override; virtual sal_Int32 compareBookmarks( const cpo::uno::Any& first, const cpo::uno::Any& second ) override; virtual bool hasOrderedBookmarks( ) override; virtual sal_Int32 hashBookmark( const cpo::uno::Any& bookmark ) override; // css::sdbc::XResultSetUpdate virtual void updateRow(const ORowSetRow& _rInsertRow,const ORowSetRow& _rOriginalRow,const connectivity::OSQLTable& _xTable ) override; virtual void deleteRow(const ORowSetRow& _rInsertRow,const connectivity::OSQLTable& _xTable ) override; virtual void insertRow( const ORowSetRow& _rInsertRow,const connectivity::OSQLTable& _xTable ) override; }; } /* vim:set shiftwidth=4 softtabstop=4 expandtab: */