connectivity/source/commontools/TKeyColumns.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: TKeyColumns.cxx,v $
  10  * $Revision: 1.6 $
  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/TKeyColumns.hxx"
  34 #include "connectivity/sdbcx/VKeyColumn.hxx"
  35 #include <com/sun/star/sdbc/XRow.hpp>
  36 #include <com/sun/star/sdbc/XResultSet.hpp>
  37 #include <com/sun/star/sdbc/DataType.hpp>
  38 #include <com/sun/star/sdbc/ColumnValue.hpp>
  39 #include <comphelper/extract.hxx>
  40 #include <comphelper/property.hxx>
  41 #include "TConnection.hxx"
  42 #include "connectivity/TTableHelper.hxx"
  43
  44 using namespace connectivity;
  45 using namespace connectivity::sdbcx;
  46 using namespace ::com::sun::star::uno;
  47 using namespace ::com::sun::star::beans;
  48 //      using namespace ::com::sun::star::sdbcx;
  49 using namespace ::com::sun::star::sdbc;
  50 using namespace ::com::sun::star::container;
  51 using namespace ::com::sun::star::lang;
  52
  53 // -------------------------------------------------------------------------
  54 OKeyColumnsHelper::OKeyColumnsHelper(   OTableKeyHelper* _pKey,
  55                 ::osl::Mutex& _rMutex,
  56                 const ::std::vector< ::rtl::OUString> &_rVector)
  57             : connectivity::sdbcx::OCollection(*_pKey,sal_True,_rMutex,_rVector)
  58             ,m_pKey(_pKey)
  59 {
  60 }
  61 // -------------------------------------------------------------------------
  62 sdbcx::ObjectType OKeyColumnsHelper::createObject(const ::rtl::OUString& _rName)
  63 {
  64     ::dbtools::OPropertyMap& rPropMap = OMetaConnection::getPropMap();
  65     ::rtl::OUString aSchema,aTable;
  66     m_pKey->getTable()->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_SCHEMANAME))       >>= aSchema;
  67     m_pKey->getTable()->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_NAME))                     >>= aTable;
  68
  69     // frist get the related column to _rName
  70     Reference< XResultSet > xResult = m_pKey->getTable()->getMetaData()->getImportedKeys(
  71             m_pKey->getTable()->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_CATALOGNAME)),aSchema,aTable);
  72
  73     ::rtl::OUString aRefColumnName;
  74     if ( xResult.is() )
  75     {
  76         Reference< XRow > xRow(xResult,UNO_QUERY);
  77         ::rtl::OUString aTemp;
  78         while(xResult->next())
  79         {
  80             aTemp = xRow->getString(4);
  81             if(xRow->getString(8) == _rName && m_pKey->getName() == xRow->getString(12))
  82             {
  83                 aRefColumnName = aTemp;
  84                 break;
  85             }
  86         }
  87     }
  88
  89     sdbcx::ObjectType xRet;
  90
  91     // now describe the column _rName and set his related column
  92     xResult = m_pKey->getTable()->getMetaData()->getColumns(
  93                 m_pKey->getTable()->getPropertyValue(rPropMap.getNameByIndex(PROPERTY_ID_CATALOGNAME)),aSchema,aTable,_rName);
  94
  95     if ( xResult.is() )
  96     {
  97         Reference< XRow > xRow(xResult,UNO_QUERY);
  98         if ( xResult->next() )
  99         {
 100             if ( xRow->getString(4) == _rName )
 101             {
 102                 sal_Int32 nDataType = xRow->getInt(5);
 103                 ::rtl::OUString aTypeName(xRow->getString(6));
 104                 sal_Int32 nSize = xRow->getInt(7);
 105                 sal_Int32 nDec  = xRow->getInt(9);
 106                 sal_Int32 nNull = xRow->getInt(11);
 107                 ::rtl::OUString sColumnDef;
 108                 try
 109                 {
 110                     sColumnDef = xRow->getString(13);
 111                 }
 112                 catch(const SQLException&)
 113                 {
 114                     // somethimes we get an error when asking for this param
 115                 }
 116
 117                 OKeyColumn* pRet = new OKeyColumn(aRefColumnName,
 118                                                     _rName,
 119                                                     aTypeName,
 120                                                     sColumnDef,
 121                                                     nNull,
 122                                                     nSize,
 123                                                     nDec,
 124                                                     nDataType,
 125                                                     sal_False,
 126                                                     sal_False,
 127                                                     sal_False,
 128                                                     isCaseSensitive());
 129                 xRet = pRet;
 130             }
 131         }
 132     }
 133
 134     return xRet;
 135 }
 136 // -------------------------------------------------------------------------
 137 Reference< XPropertySet > OKeyColumnsHelper::createDescriptor()
 138 {
 139     return new OKeyColumn(isCaseSensitive());
 140 }
 141 // -------------------------------------------------------------------------
 142 void OKeyColumnsHelper::impl_refresh() throw(::com::sun::star::uno::RuntimeException)
 143 {
 144     m_pKey->refreshColumns();
 145 }
 146 // -----------------------------------------------------------------------------
 147
 148