connectivity/source/commontools/TIndex.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: TIndex.cxx,v $
  10  * $Revision: 1.4 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_connectivity.hxx"
  33 #include "connectivity/TIndex.hxx"
  34 #include "connectivity/TIndexColumns.hxx"
  35 #include <com/sun/star/sdbc/XRow.hpp>
  36 #include <com/sun/star/sdbc/XResultSet.hpp>
  37 #include "connectivity/TTableHelper.hxx"
  38 #include "TConnection.hxx"
  39
  40 using namespace connectivity;
  41 using namespace connectivity::sdbcx;
  42 using namespace ::com::sun::star::uno;
  43 using namespace ::com::sun::star::beans;
  44 //      using namespace ::com::sun::star::sdbcx;
  45 using namespace ::com::sun::star::sdbc;
  46 using namespace ::com::sun::star::container;
  47 using namespace ::com::sun::star::lang;
  48 // -------------------------------------------------------------------------
  49 OIndexHelper::OIndexHelper(     OTableHelper* _pTable) : connectivity::sdbcx::OIndex(sal_True)
  50                  , m_pTable(_pTable)
  51 {
  52     construct();
  53     ::std::vector< ::rtl::OUString> aVector;
  54     m_pColumns  = new OIndexColumns(this,m_aMutex,aVector);
  55 }
  56 // -------------------------------------------------------------------------
  57 OIndexHelper::OIndexHelper(     OTableHelper* _pTable,
  58                 const ::rtl::OUString& _Name,
  59                 const ::rtl::OUString& _Catalog,
  60                 sal_Bool _isUnique,
  61                 sal_Bool _isPrimaryKeyIndex,
  62                 sal_Bool _isClustered
  63                 ) : connectivity::sdbcx::OIndex(_Name,
  64                                   _Catalog,
  65                                   _isUnique,
  66                                   _isPrimaryKeyIndex,
  67                                   _isClustered,sal_True)
  68                 ,m_pTable(_pTable)
  69 {
  70     construct();
  71     refreshColumns();
  72 }
  73 // -------------------------------------------------------------------------
  74
  75 void OIndexHelper::refreshColumns()
  76 {
  77     if ( !m_pTable )
  78         return;
  79
  80     ::std::vector< ::rtl::OUString> aVector;
  81     if ( !isNew() )
  82     {
  83         ::dbtools::OPropertyMap& rPropMap = OMetaConnection::getPropMap();
  84         ::rtl::OUString aSchema,aTable;
  85         m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_SCHEMANAME))     >>= aSchema;
  86         m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_NAME))           >>= aTable;
  87
  88         Reference< XResultSet > xResult = m_pTable->getMetaData()->getIndexInfo(
  89             m_pTable->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_CATALOGNAME)),
  90             aSchema,aTable,sal_False,sal_False);
  91
  92         if ( xResult.is() )
  93         {
  94             Reference< XRow > xRow(xResult,UNO_QUERY);
  95             ::rtl::OUString aColName;
  96             while( xResult->next() )
  97             {
  98                 if ( xRow->getString(6) == m_Name )
  99                 {
 100                     aColName = xRow->getString(9);
 101                     if ( !xRow->wasNull() )
 102                         aVector.push_back(aColName);
 103                 }
 104             }
 105         }
 106     }
 107     if(m_pColumns)
 108         m_pColumns->reFill(aVector);
 109     else
 110         m_pColumns      = new OIndexColumns(this,m_aMutex,aVector);
 111 }
 112 // -----------------------------------------------------------------------------
 113