connectivity/source/drivers/ado/AResultSetMetaData.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: AResultSetMetaData.cxx,v $
  10  * $Revision: 1.13 $
  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 "ado/AResultSetMetaData.hxx"
  34 #include <com/sun/star/sdbc/DataType.hpp>
  35 #include <com/sun/star/sdbc/ColumnValue.hpp>
  36 #include "ado/Awrapado.hxx"
  37 #include "connectivity/dbexception.hxx"
  38
  39 using namespace connectivity;
  40 using namespace connectivity::ado;
  41 using namespace com::sun::star::uno;
  42 using namespace com::sun::star::lang;
  43 using namespace com::sun::star::beans;
  44 using namespace com::sun::star::sdbc;
  45
  46 OResultSetMetaData::OResultSetMetaData( ADORecordset* _pRecordSet)
  47                     :   m_pRecordSet(_pRecordSet),
  48                         m_nColCount(-1)
  49 {
  50     if ( m_pRecordSet )
  51         m_pRecordSet->AddRef();
  52 }
  53 // -------------------------------------------------------------------------
  54 OResultSetMetaData::~OResultSetMetaData()
  55 {
  56     if ( m_pRecordSet )
  57         m_pRecordSet->Release();
  58 }
  59 // -------------------------------------------------------------------------
  60 sal_Int32 SAL_CALL OResultSetMetaData::getColumnDisplaySize( sal_Int32 column ) throw(SQLException, RuntimeException)
  61 {
  62     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  63     if(aField.IsValid() && aField.GetActualSize() != -1)
  64         return aField.GetActualSize();
  65     return 0;
  66 }
  67 // -------------------------------------------------------------------------
  68
  69 sal_Int32 SAL_CALL OResultSetMetaData::getColumnType( sal_Int32 column ) throw(SQLException, RuntimeException)
  70 {
  71     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  72     return ADOS::MapADOType2Jdbc(aField.GetADOType());
  73 }
  74 // -------------------------------------------------------------------------
  75
  76 sal_Int32 SAL_CALL OResultSetMetaData::getColumnCount(  ) throw(SQLException, RuntimeException)
  77 {
  78     if(m_nColCount != -1 )
  79         return m_nColCount;
  80
  81     if ( !m_pRecordSet )
  82         return 0;
  83
  84     ADOFields* pFields  = NULL;
  85     m_pRecordSet->get_Fields(&pFields);
  86     WpOLEAppendCollection<ADOFields, ADOField, WpADOField>      aFields(pFields);
  87     m_nColCount = aFields.GetItemCount();
  88     return m_nColCount;
  89 }
  90 // -------------------------------------------------------------------------
  91
  92 sal_Bool SAL_CALL OResultSetMetaData::isCaseSensitive( sal_Int32 column ) throw(SQLException, RuntimeException)
  93 {
  94     sal_Bool bRet = sal_False;
  95     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  96     if ( aField.IsValid() )
  97     {
  98         WpADOProperties aProps( aField.get_Properties() );
  99         if ( aProps.IsValid() )
 100             bRet = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ISCASESENSITIVE")) );
 101     }
 102     return bRet;
 103 }
 104 // -------------------------------------------------------------------------
 105
 106 ::rtl::OUString SAL_CALL OResultSetMetaData::getSchemaName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 107 {
 108     return ::rtl::OUString();
 109 }
 110 // -------------------------------------------------------------------------
 111
 112 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnName( sal_Int32 column ) throw(SQLException, RuntimeException)
 113 {
 114     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 115     if(aField.IsValid())
 116         return aField.GetName();
 117
 118     return ::rtl::OUString();
 119 }
 120 // -------------------------------------------------------------------------
 121 ::rtl::OUString SAL_CALL OResultSetMetaData::getTableName( sal_Int32 column ) throw(SQLException, RuntimeException)
 122 {
 123     ::rtl::OUString sTableName;
 124
 125     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 126     if ( aField.IsValid() )
 127     {
 128         WpADOProperties aProps( aField.get_Properties() );
 129         if ( aProps.IsValid() )
 130             sTableName = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("BASETABLENAME")) );
 131     }
 132     return sTableName;
 133 }
 134 // -------------------------------------------------------------------------
 135 ::rtl::OUString SAL_CALL OResultSetMetaData::getCatalogName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 136 {
 137     return ::rtl::OUString();
 138 }
 139 // -------------------------------------------------------------------------
 140 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnTypeName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 141 {
 142     return ::rtl::OUString();
 143 }
 144 // -------------------------------------------------------------------------
 145 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnLabel( sal_Int32 column ) throw(SQLException, RuntimeException)
 146 {
 147     return getColumnName(column);
 148 }
 149 // -------------------------------------------------------------------------
 150 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnServiceName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 151 {
 152     return ::rtl::OUString();
 153 }
 154 // -------------------------------------------------------------------------
 155
 156 sal_Bool SAL_CALL OResultSetMetaData::isCurrency( sal_Int32 column ) throw(SQLException, RuntimeException)
 157 {
 158     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 159     if(aField.IsValid())
 160     {
 161         return ((aField.GetAttributes() & adFldFixed) == adFldFixed) && (aField.GetADOType() == adCurrency);
 162     }
 163     return sal_False;
 164 }
 165 // -------------------------------------------------------------------------
 166
 167 sal_Bool SAL_CALL OResultSetMetaData::isAutoIncrement( sal_Int32 column ) throw(SQLException, RuntimeException)
 168 {
 169     sal_Bool bRet = sal_False;
 170     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 171     if ( aField.IsValid() )
 172     {
 173         WpADOProperties aProps( aField.get_Properties() );
 174         if ( aProps.IsValid() )
 175         {
 176             bRet = OTools::getValue( aProps, ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("ISAUTOINCREMENT")) );
 177 #if OSL_DEBUG_LEVEL > 0
 178             sal_Int32 nCount = aProps.GetItemCount();
 179             for (sal_Int32 i = 0; i<nCount; ++i)
 180             {
 181                 WpADOProperty aProp = aProps.GetItem(i);
 182                 ::rtl::OUString sName = aProp.GetName();
 183                 ::rtl::OUString sVal = aProp.GetValue();
 184             }
 185 #endif
 186         }
 187     }
 188     return bRet;
 189 }
 190 // -------------------------------------------------------------------------
 191
 192
 193 sal_Bool SAL_CALL OResultSetMetaData::isSigned( sal_Int32 column ) throw(SQLException, RuntimeException)
 194 {
 195     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 196     if(aField.IsValid())
 197     {
 198         DataTypeEnum eType = aField.GetADOType();
 199         return !(eType == adUnsignedBigInt || eType == adUnsignedInt || eType == adUnsignedSmallInt || eType == adUnsignedTinyInt);
 200     }
 201     return sal_False;
 202 }
 203 // -------------------------------------------------------------------------
 204 sal_Int32 SAL_CALL OResultSetMetaData::getPrecision( sal_Int32 column ) throw(SQLException, RuntimeException)
 205 {
 206     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 207     if(aField.IsValid())
 208         return aField.GetPrecision();
 209     return 0;
 210 }
 211 // -------------------------------------------------------------------------
 212 sal_Int32 SAL_CALL OResultSetMetaData::getScale( sal_Int32 column ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
 213 {
 214     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 215     if(aField.IsValid())
 216         return aField.GetNumericScale();
 217     return 0;
 218 }
 219 // -------------------------------------------------------------------------
 220
 221 sal_Int32 SAL_CALL OResultSetMetaData::isNullable( sal_Int32 column ) throw(SQLException, RuntimeException)
 222 {
 223     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 224     if(aField.IsValid())
 225     {
 226         return (aField.GetAttributes() & adFldIsNullable) == adFldIsNullable;
 227     }
 228     return sal_False;
 229 }
 230 // -------------------------------------------------------------------------
 231
 232 sal_Bool SAL_CALL OResultSetMetaData::isSearchable( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 233 {
 234     return sal_True;
 235 }
 236 // -------------------------------------------------------------------------
 237
 238 sal_Bool SAL_CALL OResultSetMetaData::isReadOnly( sal_Int32 column ) throw(SQLException, RuntimeException)
 239 {
 240     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 241     if(aField.IsValid())
 242     {
 243         //      return (aField.GetStatus() & adFieldReadOnly) == adFieldReadOnly;
 244     }
 245     return sal_False;
 246 }
 247 // -------------------------------------------------------------------------
 248
 249 sal_Bool SAL_CALL OResultSetMetaData::isDefinitelyWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 250 {
 251     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 252     if(aField.IsValid())
 253     {
 254         return (aField.GetAttributes() & adFldUpdatable) == adFldUpdatable;
 255     }
 256     return sal_False;
 257 ;
 258 }
 259 // -------------------------------------------------------------------------
 260 sal_Bool SAL_CALL OResultSetMetaData::isWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 261 {
 262     return isDefinitelyWritable(column);
 263 }
 264 // -------------------------------------------------------------------------
 265