connectivity/source/commontools/TIndex.cxx

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