| /************************************************************** |
| * |
| * 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 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| // MARKER(update_precomp.py): autogen include statement, do not remove |
| #include "precompiled_connectivity.hxx" |
| #include "hsqldb/HCatalog.hxx" |
| #include "hsqldb/HUsers.hxx" |
| #include "hsqldb/HTables.hxx" |
| #include "hsqldb/HViews.hxx" |
| #include <com/sun/star/sdbc/XRow.hpp> |
| #include <com/sun/star/sdbc/XResultSet.hpp> |
| #include <comphelper/types.hxx> |
| |
| |
| // ------------------------------------------------------------------------- |
| using namespace connectivity; |
| using namespace connectivity::hsqldb; |
| //using namespace connectivity::sdbcx; |
| using namespace ::com::sun::star::uno; |
| using namespace ::com::sun::star::beans; |
| using namespace ::com::sun::star::sdbcx; |
| using namespace ::com::sun::star::sdbc; |
| using namespace ::com::sun::star::container; |
| using namespace ::com::sun::star::lang; |
| // ------------------------------------------------------------------------- |
| OHCatalog::OHCatalog(const Reference< XConnection >& _xConnection) : sdbcx::OCatalog(_xConnection) |
| ,m_xConnection(_xConnection) |
| { |
| } |
| // ----------------------------------------------------------------------------- |
| void OHCatalog::refreshObjects(const Sequence< ::rtl::OUString >& _sKindOfObject,TStringVector& _rNames) |
| { |
| Reference< XResultSet > xResult = m_xMetaData->getTables(Any(), |
| ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("%")), |
| ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("%")), |
| _sKindOfObject); |
| fillNames(xResult,_rNames); |
| } |
| // ------------------------------------------------------------------------- |
| void OHCatalog::refreshTables() |
| { |
| TStringVector aVector; |
| static const ::rtl::OUString s_sTableTypeView(RTL_CONSTASCII_USTRINGPARAM("VIEW")); |
| static const ::rtl::OUString s_sTableTypeTable(RTL_CONSTASCII_USTRINGPARAM("TABLE")); |
| |
| Sequence< ::rtl::OUString > sTableTypes(2); |
| sTableTypes[0] = s_sTableTypeView; |
| sTableTypes[1] = s_sTableTypeTable; |
| |
| refreshObjects(sTableTypes,aVector); |
| |
| if ( m_pTables ) |
| m_pTables->reFill(aVector); |
| else |
| m_pTables = new OTables(m_xMetaData,*this,m_aMutex,aVector); |
| } |
| // ------------------------------------------------------------------------- |
| void OHCatalog::refreshViews() |
| { |
| Sequence< ::rtl::OUString > aTypes(1); |
| aTypes[0] = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("VIEW")); |
| |
| sal_Bool bSupportsViews = sal_False; |
| try |
| { |
| Reference<XResultSet> xRes = m_xMetaData->getTableTypes(); |
| Reference<XRow> xRow(xRes,UNO_QUERY); |
| while ( xRow.is() && xRes->next() ) |
| { |
| if ( (bSupportsViews = xRow->getString(1).equalsIgnoreAsciiCase(aTypes[0])) ) |
| { |
| break; |
| } |
| } |
| } |
| catch(const SQLException&) |
| { |
| } |
| |
| TStringVector aVector; |
| if ( bSupportsViews ) |
| refreshObjects(aTypes,aVector); |
| |
| if ( m_pViews ) |
| m_pViews->reFill(aVector); |
| else |
| m_pViews = new HViews( m_xConnection, *this, m_aMutex, aVector ); |
| } |
| // ------------------------------------------------------------------------- |
| void OHCatalog::refreshGroups() |
| { |
| } |
| // ------------------------------------------------------------------------- |
| void OHCatalog::refreshUsers() |
| { |
| TStringVector aVector; |
| Reference< XStatement > xStmt = m_xConnection->createStatement( ); |
| Reference< XResultSet > xResult = xStmt->executeQuery(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("select User from hsqldb.user group by User"))); |
| if ( xResult.is() ) |
| { |
| Reference< XRow > xRow(xResult,UNO_QUERY); |
| TString2IntMap aMap; |
| while( xResult->next() ) |
| aVector.push_back(xRow->getString(1)); |
| ::comphelper::disposeComponent(xResult); |
| } |
| ::comphelper::disposeComponent(xStmt); |
| |
| if(m_pUsers) |
| m_pUsers->reFill(aVector); |
| else |
| m_pUsers = new OUsers(*this,m_aMutex,aVector,m_xConnection,this); |
| } |
| // ----------------------------------------------------------------------------- |
| Any SAL_CALL OHCatalog::queryInterface( const Type & rType ) throw(RuntimeException) |
| { |
| if ( rType == ::getCppuType((const Reference<XGroupsSupplier>*)0) ) |
| return Any(); |
| |
| return OCatalog::queryInterface(rType); |
| } |
| // ----------------------------------------------------------------------------- |
| Sequence< Type > SAL_CALL OHCatalog::getTypes( ) throw(RuntimeException) |
| { |
| Sequence< Type > aTypes = OCatalog::getTypes(); |
| ::std::vector<Type> aOwnTypes; |
| aOwnTypes.reserve(aTypes.getLength()); |
| const Type* pBegin = aTypes.getConstArray(); |
| const Type* pEnd = pBegin + aTypes.getLength(); |
| for(;pBegin != pEnd;++pBegin) |
| { |
| if ( !(*pBegin == ::getCppuType((const Reference<XGroupsSupplier>*)0))) |
| { |
| aOwnTypes.push_back(*pBegin); |
| } |
| } |
| const Type* pTypes = aOwnTypes.empty() ? 0 : &aOwnTypes[0]; |
| return Sequence< Type >(pTypes, aOwnTypes.size()); |
| } |
| // ----------------------------------------------------------------------------- |
| |
| |