233 lines
8.2 KiB
C++
233 lines
8.2 KiB
C++
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
|
|
/*
|
|
* This file is part of the LibreOffice project.
|
|
*
|
|
* This Source Code Form is subject to the terms of the Mozilla Public
|
|
* License, v. 2.0. If a copy of the MPL was not distributed with this
|
|
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
|
|
*
|
|
* This file incorporates work covered by the following license notice:
|
|
*
|
|
* Licensed to the Apache Software Foundation (ASF) under one or more
|
|
* contributor license agreements. See the NOTICE file distributed
|
|
* with this work for additional information regarding copyright
|
|
* ownership. The ASF licenses this file to you under the Apache
|
|
* License, Version 2.0 (the "License"); you may not use this file
|
|
* except in compliance with the License. You may obtain a copy of
|
|
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
|
|
*/
|
|
|
|
#include <sal/config.h>
|
|
|
|
#include <string_view>
|
|
|
|
#include <ado/AColumn.hxx>
|
|
#include <ado/AConnection.hxx>
|
|
#include <ado/Awrapado.hxx>
|
|
#include <com/sun/star/sdbc/ColumnValue.hpp>
|
|
#include <comphelper/extract.hxx>
|
|
#include <comphelper/servicehelper.hxx>
|
|
#include <comphelper/types.hxx>
|
|
#include <ado/ACatalog.hxx>
|
|
|
|
using namespace ::comphelper;
|
|
|
|
using namespace connectivity::ado;
|
|
using namespace com::sun::star::uno;
|
|
using namespace com::sun::star::lang;
|
|
using namespace com::sun::star::beans;
|
|
using namespace com::sun::star::sdbc;
|
|
|
|
void WpADOColumn::Create()
|
|
{
|
|
pInterface.CoCreateInstance(ADOS::CLSID_ADOCOLUMN_25, nullptr, CLSCTX_INPROC_SERVER);
|
|
}
|
|
|
|
OAdoColumn::OAdoColumn(bool _bCase,OConnection* _pConnection,_ADOColumn* _pColumn)
|
|
: connectivity::sdbcx::OColumn(_bCase)
|
|
,m_pConnection(_pConnection)
|
|
{
|
|
construct();
|
|
OSL_ENSURE(_pColumn,"Column can not be null!");
|
|
m_aColumn.set(_pColumn);
|
|
// m_aColumn.put_ParentCatalog(_pConnection->getAdoCatalog()->getCatalog());
|
|
fillPropertyValues();
|
|
}
|
|
|
|
OAdoColumn::OAdoColumn(bool _bCase,OConnection* _pConnection)
|
|
: connectivity::sdbcx::OColumn(_bCase)
|
|
,m_pConnection(_pConnection)
|
|
{
|
|
m_aColumn.Create();
|
|
m_aColumn.put_ParentCatalog(_pConnection->getAdoCatalog()->getCatalog());
|
|
construct();
|
|
fillPropertyValues();
|
|
m_Type = DataType::OTHER;
|
|
}
|
|
|
|
|
|
void OAdoColumn::construct()
|
|
{
|
|
sal_Int32 nAttrib = isNew() ? 0 : PropertyAttribute::READONLY;
|
|
|
|
registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISASCENDING), PROPERTY_ID_ISASCENDING, nAttrib,&m_IsAscending, cppu::UnoType<bool>::get());
|
|
registerProperty(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_RELATEDCOLUMN), PROPERTY_ID_RELATEDCOLUMN, nAttrib,&m_ReferencedColumn, ::cppu::UnoType<OUString>::get());
|
|
}
|
|
|
|
void OAdoColumn::setFastPropertyValue_NoBroadcast(sal_Int32 nHandle,const Any& rValue)
|
|
{
|
|
if(m_aColumn.IsValid())
|
|
{
|
|
std::u16string_view sAdoPropertyName;
|
|
|
|
switch(nHandle)
|
|
{
|
|
case PROPERTY_ID_ISASCENDING:
|
|
m_aColumn.put_SortOrder(::cppu::any2bool(rValue) ? adSortAscending : adSortDescending);
|
|
break;
|
|
case PROPERTY_ID_RELATEDCOLUMN:
|
|
{
|
|
OUString aVal;
|
|
rValue >>= aVal;
|
|
m_aColumn.put_RelatedColumn(aVal);
|
|
}
|
|
break;
|
|
case PROPERTY_ID_NAME:
|
|
{
|
|
OUString aVal;
|
|
rValue >>= aVal;
|
|
m_aColumn.put_Name(aVal);
|
|
}
|
|
break;
|
|
case PROPERTY_ID_TYPE:
|
|
{
|
|
sal_Int32 nVal=0;
|
|
rValue >>= nVal;
|
|
m_aColumn.put_Type(ADOS::MapJdbc2ADOType(nVal,m_pConnection->getEngineType()));
|
|
}
|
|
break;
|
|
case PROPERTY_ID_TYPENAME:
|
|
// rValue <<= m_pTable->getCatalog()->getConnection()->getTypeInfo()->find();
|
|
break;
|
|
case PROPERTY_ID_PRECISION:
|
|
{
|
|
sal_Int32 nVal=0;
|
|
rValue >>= nVal;
|
|
m_aColumn.put_Precision(nVal);
|
|
}
|
|
break;
|
|
case PROPERTY_ID_SCALE:
|
|
{
|
|
sal_Int32 nVal=0;
|
|
rValue >>= nVal;
|
|
if ( !m_IsCurrency )
|
|
m_aColumn.put_NumericScale(static_cast<sal_Int8>(nVal));
|
|
}
|
|
break;
|
|
case PROPERTY_ID_ISNULLABLE:
|
|
{
|
|
sal_Int32 nVal=0;
|
|
rValue >>= nVal;
|
|
if ( nVal == ColumnValue::NULLABLE )
|
|
m_aColumn.put_Attributes( adColNullable );
|
|
}
|
|
break;
|
|
case PROPERTY_ID_ISROWVERSION:
|
|
break;
|
|
|
|
case PROPERTY_ID_ISAUTOINCREMENT:
|
|
OTools::putValue(
|
|
m_aColumn.get_Properties(), std::u16string_view(u"Autoincrement"),
|
|
getBOOL(rValue));
|
|
break;
|
|
|
|
case PROPERTY_ID_DESCRIPTION:
|
|
sAdoPropertyName = u"Description";
|
|
break;
|
|
|
|
case PROPERTY_ID_DEFAULTVALUE:
|
|
sAdoPropertyName = u"Default";
|
|
break;
|
|
}
|
|
|
|
if (!sAdoPropertyName.empty())
|
|
OTools::putValue(m_aColumn.get_Properties(), sAdoPropertyName, getString(rValue));
|
|
}
|
|
OColumn_ADO::setFastPropertyValue_NoBroadcast(nHandle,rValue);
|
|
}
|
|
|
|
void OAdoColumn::fillPropertyValues()
|
|
{
|
|
if(m_aColumn.IsValid())
|
|
{
|
|
m_IsAscending = m_aColumn.get_SortOrder() == adSortAscending;
|
|
m_ReferencedColumn = m_aColumn.get_RelatedColumn();
|
|
m_Name = m_aColumn.get_Name();
|
|
m_Precision = m_aColumn.get_Precision();
|
|
m_Scale = m_aColumn.get_NumericScale();
|
|
m_IsNullable = ((m_aColumn.get_Attributes() & adColNullable) == adColNullable) ? ColumnValue::NULLABLE : ColumnValue::NO_NULLS;
|
|
|
|
DataTypeEnum eType = m_aColumn.get_Type();
|
|
m_IsCurrency = (eType == adCurrency);
|
|
if ( m_IsCurrency && !m_Scale)
|
|
m_Scale = 4;
|
|
m_Type = ADOS::MapADOType2Jdbc(eType);
|
|
|
|
bool bForceTo = true;
|
|
const OTypeInfoMap* pTypeInfoMap = m_pConnection->getTypeInfo();
|
|
const OExtendedTypeInfo* pTypeInfo = OConnection::getTypeInfoFromType(*m_pConnection->getTypeInfo(),eType,OUString(),m_Precision,m_Scale,bForceTo);
|
|
if ( pTypeInfo )
|
|
m_TypeName = pTypeInfo->aSimpleType.aTypeName;
|
|
else if ( eType == adVarBinary && ADOS::isJetEngine(m_pConnection->getEngineType()) )
|
|
{
|
|
::comphelper::UStringMixEqual aCase(false);
|
|
OTypeInfoMap::const_iterator aFind = std::find_if(pTypeInfoMap->begin(), pTypeInfoMap->end(),
|
|
[&aCase] (const OTypeInfoMap::value_type& typeInfo) {
|
|
return aCase(typeInfo.second->getDBName(), u"VarBinary");
|
|
});
|
|
|
|
if ( aFind != pTypeInfoMap->end() ) // change column type if necessary
|
|
{
|
|
eType = aFind->first;
|
|
pTypeInfo = aFind->second;
|
|
}
|
|
|
|
if ( !pTypeInfo )
|
|
{
|
|
pTypeInfo = OConnection::getTypeInfoFromType(*m_pConnection->getTypeInfo(),adBinary,OUString(),m_Precision,m_Scale,bForceTo);
|
|
eType = adBinary;
|
|
}
|
|
|
|
if ( pTypeInfo )
|
|
{
|
|
m_TypeName = pTypeInfo->aSimpleType.aTypeName;
|
|
m_Type = ADOS::MapADOType2Jdbc(eType);
|
|
}
|
|
}
|
|
|
|
|
|
// fill some specific props
|
|
{
|
|
WpADOProperties aProps( m_aColumn.get_Properties() );
|
|
|
|
if ( aProps.IsValid() )
|
|
{
|
|
m_IsAutoIncrement
|
|
= OTools::getValue(aProps, std::u16string_view(u"Autoincrement")).getBool();
|
|
|
|
m_Description
|
|
= OTools::getValue(aProps, std::u16string_view(u"Description")).getString();
|
|
|
|
m_DefaultValue
|
|
= OTools::getValue(aProps, std::u16string_view(u"Default")).getString();
|
|
}
|
|
}
|
|
}
|
|
}
|
|
|
|
WpADOColumn OAdoColumn::getColumnImpl() const
|
|
{
|
|
return m_aColumn;
|
|
}
|
|
|
|
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|