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