1*9b5730f6SAndrew Rist /************************************************************** 2cdf0e10cSrcweir * 3*9b5730f6SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one 4*9b5730f6SAndrew Rist * or more contributor license agreements. See the NOTICE file 5*9b5730f6SAndrew Rist * distributed with this work for additional information 6*9b5730f6SAndrew Rist * regarding copyright ownership. The ASF licenses this file 7*9b5730f6SAndrew Rist * to you under the Apache License, Version 2.0 (the 8*9b5730f6SAndrew Rist * "License"); you may not use this file except in compliance 9*9b5730f6SAndrew Rist * with the License. You may obtain a copy of the License at 10*9b5730f6SAndrew Rist * 11*9b5730f6SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12*9b5730f6SAndrew Rist * 13*9b5730f6SAndrew Rist * Unless required by applicable law or agreed to in writing, 14*9b5730f6SAndrew Rist * software distributed under the License is distributed on an 15*9b5730f6SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16*9b5730f6SAndrew Rist * KIND, either express or implied. See the License for the 17*9b5730f6SAndrew Rist * specific language governing permissions and limitations 18*9b5730f6SAndrew Rist * under the License. 19*9b5730f6SAndrew Rist * 20*9b5730f6SAndrew Rist *************************************************************/ 21*9b5730f6SAndrew Rist 22*9b5730f6SAndrew Rist 23cdf0e10cSrcweir 24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 25cdf0e10cSrcweir #include "precompiled_connectivity.hxx" 26cdf0e10cSrcweir #include "ado/AColumns.hxx" 27cdf0e10cSrcweir #include "ado/AColumn.hxx" 28cdf0e10cSrcweir #include "ado/AConnection.hxx" 29cdf0e10cSrcweir #include "ado/Awrapado.hxx" 30cdf0e10cSrcweir #include <com/sun/star/sdbc/XRow.hpp> 31cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSet.hpp> 32cdf0e10cSrcweir #include <com/sun/star/sdbc/DataType.hpp> 33cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnValue.hpp> 34cdf0e10cSrcweir #include <comphelper/property.hxx> 35cdf0e10cSrcweir #include <comphelper/types.hxx> 36cdf0e10cSrcweir #include <connectivity/dbexception.hxx> 37cdf0e10cSrcweir #ifdef __MINGW32__ 38cdf0e10cSrcweir #include <algorithm> 39cdf0e10cSrcweir #endif 40cdf0e10cSrcweir #include "resource/ado_res.hrc" 41cdf0e10cSrcweir 42cdf0e10cSrcweir using namespace connectivity::ado; 43cdf0e10cSrcweir using namespace connectivity; 44cdf0e10cSrcweir using namespace comphelper; 45cdf0e10cSrcweir using namespace com::sun::star::uno; 46cdf0e10cSrcweir using namespace com::sun::star::lang; 47cdf0e10cSrcweir using namespace com::sun::star::beans; 48cdf0e10cSrcweir using namespace com::sun::star::sdbc; 49cdf0e10cSrcweir using namespace com::sun::star::container; 50cdf0e10cSrcweir 51cdf0e10cSrcweir sdbcx::ObjectType OColumns::createObject(const ::rtl::OUString& _rName) 52cdf0e10cSrcweir { 53cdf0e10cSrcweir return new OAdoColumn(isCaseSensitive(),m_pConnection,m_aCollection.GetItem(_rName)); 54cdf0e10cSrcweir } 55cdf0e10cSrcweir 56cdf0e10cSrcweir // ------------------------------------------------------------------------- 57cdf0e10cSrcweir void OColumns::impl_refresh() throw(RuntimeException) 58cdf0e10cSrcweir { 59cdf0e10cSrcweir m_aCollection.Refresh(); 60cdf0e10cSrcweir } 61cdf0e10cSrcweir // ------------------------------------------------------------------------- 62cdf0e10cSrcweir Reference< XPropertySet > OColumns::createDescriptor() 63cdf0e10cSrcweir { 64cdf0e10cSrcweir return new OAdoColumn(isCaseSensitive(),m_pConnection); 65cdf0e10cSrcweir } 66cdf0e10cSrcweir // ------------------------------------------------------------------------- 67cdf0e10cSrcweir // XAppend 68cdf0e10cSrcweir sdbcx::ObjectType OColumns::appendObject( const ::rtl::OUString&, const Reference< XPropertySet >& descriptor ) 69cdf0e10cSrcweir { 70cdf0e10cSrcweir OAdoColumn* pColumn = NULL; 71cdf0e10cSrcweir Reference< XPropertySet > xColumn; 72cdf0e10cSrcweir if ( !getImplementation( pColumn, descriptor ) || pColumn == NULL ) 73cdf0e10cSrcweir { 74cdf0e10cSrcweir // m_pConnection->throwGenericSQLException( STR_INVALID_COLUMN_DESCRIPTOR_ERROR,static_cast<XTypeProvider*>(this) ); 75cdf0e10cSrcweir pColumn = new OAdoColumn(isCaseSensitive(),m_pConnection); 76cdf0e10cSrcweir xColumn = pColumn; 77cdf0e10cSrcweir ::comphelper::copyProperties(descriptor,xColumn); 78cdf0e10cSrcweir } 79cdf0e10cSrcweir 80cdf0e10cSrcweir WpADOColumn aColumn = pColumn->getColumnImpl(); 81cdf0e10cSrcweir 82cdf0e10cSrcweir #if OSL_DEBUG_LEVEL > 0 83cdf0e10cSrcweir sal_Int32 nPrecision; 84cdf0e10cSrcweir sal_Int32 nScale; 85cdf0e10cSrcweir sal_Int32 nType; 86cdf0e10cSrcweir nPrecision = aColumn.get_Precision(); 87cdf0e10cSrcweir nScale = aColumn.get_NumericScale(); 88cdf0e10cSrcweir nType = ADOS::MapADOType2Jdbc(aColumn.get_Type()); 89cdf0e10cSrcweir #endif 90cdf0e10cSrcweir 91cdf0e10cSrcweir ::rtl::OUString sTypeName; 92cdf0e10cSrcweir pColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)) >>= sTypeName; 93cdf0e10cSrcweir 94cdf0e10cSrcweir const OTypeInfoMap* pTypeInfoMap = m_pConnection->getTypeInfo(); 95cdf0e10cSrcweir ::comphelper::TStringMixEqualFunctor aCase(sal_False); 96cdf0e10cSrcweir // search for typeinfo where the typename is equal sTypeName 97cdf0e10cSrcweir OTypeInfoMap::const_iterator aFind = ::std::find_if(pTypeInfoMap->begin(), 98cdf0e10cSrcweir pTypeInfoMap->end(), 99cdf0e10cSrcweir ::std::compose1( 100cdf0e10cSrcweir ::std::bind2nd(aCase, sTypeName), 101cdf0e10cSrcweir ::std::compose1( 102cdf0e10cSrcweir ::std::mem_fun(&OExtendedTypeInfo::getDBName), 103cdf0e10cSrcweir ::std::select2nd<OTypeInfoMap::value_type>()) 104cdf0e10cSrcweir ) 105cdf0e10cSrcweir 106cdf0e10cSrcweir ); 107cdf0e10cSrcweir 108cdf0e10cSrcweir if ( aFind != pTypeInfoMap->end() ) // change column type if necessary 109cdf0e10cSrcweir aColumn.put_Type(aFind->first); 110cdf0e10cSrcweir 111cdf0e10cSrcweir if ( SUCCEEDED(((ADOColumns*)m_aCollection)->Append(OLEVariant(aColumn.get_Name()),aColumn.get_Type(),aColumn.get_DefinedSize())) ) 112cdf0e10cSrcweir { 113cdf0e10cSrcweir WpADOColumn aAddedColumn = m_aCollection.GetItem(OLEVariant(aColumn.get_Name())); 114cdf0e10cSrcweir if ( aAddedColumn.IsValid() ) 115cdf0e10cSrcweir { 116cdf0e10cSrcweir sal_Bool bAutoIncrement = sal_False; 117cdf0e10cSrcweir pColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISAUTOINCREMENT)) >>= bAutoIncrement; 118cdf0e10cSrcweir if ( bAutoIncrement ) 119cdf0e10cSrcweir OTools::putValue( aAddedColumn.get_Properties(), ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("Autoincrement")), bAutoIncrement ); 120cdf0e10cSrcweir 121cdf0e10cSrcweir if ( aFind != pTypeInfoMap->end() && aColumn.get_Type() != aAddedColumn.get_Type() ) // change column type if necessary 122cdf0e10cSrcweir aColumn.put_Type(aFind->first); 123cdf0e10cSrcweir aAddedColumn.put_Precision(aColumn.get_Precision()); 124cdf0e10cSrcweir aAddedColumn.put_NumericScale(aColumn.get_NumericScale()); 125cdf0e10cSrcweir aAddedColumn.put_Attributes(aColumn.get_Attributes()); 126cdf0e10cSrcweir aAddedColumn.put_SortOrder(aColumn.get_SortOrder()); 127cdf0e10cSrcweir aAddedColumn.put_RelatedColumn(aColumn.get_RelatedColumn()); 128cdf0e10cSrcweir } 129cdf0e10cSrcweir } 130cdf0e10cSrcweir ADOS::ThrowException(*m_pConnection->getConnection(),static_cast<XTypeProvider*>(this)); 131cdf0e10cSrcweir 132cdf0e10cSrcweir return new OAdoColumn(isCaseSensitive(),m_pConnection,pColumn->getColumnImpl()); 133cdf0e10cSrcweir } 134cdf0e10cSrcweir // ------------------------------------------------------------------------- 135cdf0e10cSrcweir // XDrop 136cdf0e10cSrcweir void OColumns::dropObject(sal_Int32 /*_nPos*/,const ::rtl::OUString _sElementName) 137cdf0e10cSrcweir { 138cdf0e10cSrcweir if(!m_aCollection.Delete(_sElementName)) 139cdf0e10cSrcweir ADOS::ThrowException(*m_pConnection->getConnection(),static_cast<XTypeProvider*>(this)); 140cdf0e10cSrcweir } 141cdf0e10cSrcweir // ----------------------------------------------------------------------------- 142cdf0e10cSrcweir 143cdf0e10cSrcweir 144cdf0e10cSrcweir 145