connectivity/source/drivers/ado/AResultSetMetaData.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*
   3  * This file is part of the LibreOffice project.
   4  *
   5  * This Source Code Form is subject to the terms of the Mozilla Public
   6  * License, v. 2.0. If a copy of the MPL was not distributed with this
   7  * file, You can obtain one at http://mozilla.org/MPL/2.0/.
   8  *
   9  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include "ado/AResultSetMetaData.hxx"
  21 #include <com/sun/star/sdbc/DataType.hpp>
  22 #include <com/sun/star/sdbc/ColumnValue.hpp>
  23 #include "ado/Awrapado.hxx"
  24 #include "connectivity/dbexception.hxx"
  25
  26 using namespace connectivity;
  27 using namespace connectivity::ado;
  28 using namespace com::sun::star::uno;
  29 using namespace com::sun::star::lang;
  30 using namespace com::sun::star::beans;
  31 using namespace com::sun::star::sdbc;
  32
  33 OResultSetMetaData::OResultSetMetaData( ADORecordset* _pRecordSet)
  34                     :   m_pRecordSet(_pRecordSet),
  35                         m_nColCount(-1)
  36 {
  37     if ( m_pRecordSet )
  38         m_pRecordSet->AddRef();
  39 }
  40
  41 OResultSetMetaData::~OResultSetMetaData()
  42 {
  43     if ( m_pRecordSet )
  44         m_pRecordSet->Release();
  45 }
  46
  47 sal_Int32 SAL_CALL OResultSetMetaData::getColumnDisplaySize( sal_Int32 column ) throw(SQLException, RuntimeException)
  48 {
  49     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  50     if(aField.IsValid() && aField.GetActualSize() != -1)
  51         return aField.GetActualSize();
  52     return 0;
  53 }
  54
  55
  56 sal_Int32 SAL_CALL OResultSetMetaData::getColumnType( sal_Int32 column ) throw(SQLException, RuntimeException)
  57 {
  58     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  59     return ADOS::MapADOType2Jdbc(aField.GetADOType());
  60 }
  61
  62
  63 sal_Int32 SAL_CALL OResultSetMetaData::getColumnCount(  ) throw(SQLException, RuntimeException)
  64 {
  65     if(m_nColCount != -1 )
  66         return m_nColCount;
  67
  68     if ( !m_pRecordSet )
  69         return 0;
  70
  71     ADOFields* pFields  = NULL;
  72     m_pRecordSet->get_Fields(&pFields);
  73     WpOLEAppendCollection<ADOFields, ADOField, WpADOField>  aFields(pFields);
  74     m_nColCount = aFields.GetItemCount();
  75     return m_nColCount;
  76 }
  77
  78
  79 sal_Bool SAL_CALL OResultSetMetaData::isCaseSensitive( sal_Int32 column ) throw(SQLException, RuntimeException)
  80 {
  81     sal_Bool bRet = sal_False;
  82     WpADOField aField = ADOS::getField(m_pRecordSet,column);
  83     if ( aField.IsValid() )
  84     {
  85         WpADOProperties aProps( aField.get_Properties() );
  86         if ( aProps.IsValid() )
  87             bRet = OTools::getValue( aProps, OUString("ISCASESENSITIVE") );
  88     }
  89     return bRet;
  90 }
  91
  92
  93 OUString SAL_CALL OResultSetMetaData::getSchemaName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
  94 {
  95     return OUString();
  96 }
  97
  98
  99 OUString SAL_CALL OResultSetMetaData::getColumnName( sal_Int32 column ) throw(SQLException, RuntimeException)
 100 {
 101     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 102     if(aField.IsValid())
 103         return aField.GetName();
 104
 105     return OUString();
 106 }
 107
 108 OUString SAL_CALL OResultSetMetaData::getTableName( sal_Int32 column ) throw(SQLException, RuntimeException)
 109 {
 110     OUString sTableName;
 111
 112     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 113     if ( aField.IsValid() )
 114     {
 115         WpADOProperties aProps( aField.get_Properties() );
 116         if ( aProps.IsValid() )
 117             sTableName = OTools::getValue( aProps, OUString("BASETABLENAME") );
 118     }
 119     return sTableName;
 120 }
 121
 122 OUString SAL_CALL OResultSetMetaData::getCatalogName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 123 {
 124     return OUString();
 125 }
 126
 127 OUString SAL_CALL OResultSetMetaData::getColumnTypeName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 128 {
 129     return OUString();
 130 }
 131
 132 OUString SAL_CALL OResultSetMetaData::getColumnLabel( sal_Int32 column ) throw(SQLException, RuntimeException)
 133 {
 134     return getColumnName(column);
 135 }
 136
 137 OUString SAL_CALL OResultSetMetaData::getColumnServiceName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 138 {
 139     return OUString();
 140 }
 141
 142
 143 sal_Bool SAL_CALL OResultSetMetaData::isCurrency( sal_Int32 column ) throw(SQLException, RuntimeException)
 144 {
 145     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 146     if(aField.IsValid())
 147     {
 148         return ((aField.GetAttributes() & adFldFixed) == adFldFixed) && (aField.GetADOType() == adCurrency);
 149     }
 150     return sal_False;
 151 }
 152
 153
 154 sal_Bool SAL_CALL OResultSetMetaData::isAutoIncrement( sal_Int32 column ) throw(SQLException, RuntimeException)
 155 {
 156     sal_Bool bRet = sal_False;
 157     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 158     if ( aField.IsValid() )
 159     {
 160         WpADOProperties aProps( aField.get_Properties() );
 161         if ( aProps.IsValid() )
 162         {
 163             bRet = OTools::getValue( aProps, OUString("ISAUTOINCREMENT") );
 164 #if OSL_DEBUG_LEVEL > 0
 165             sal_Int32 nCount = aProps.GetItemCount();
 166             for (sal_Int32 i = 0; i<nCount; ++i)
 167             {
 168                 WpADOProperty aProp = aProps.GetItem(i);
 169                 OUString sName = aProp.GetName();
 170                 OUString sVal = aProp.GetValue();
 171             }
 172 #endif
 173         }
 174     }
 175     return bRet;
 176 }
 177
 178
 179
 180 sal_Bool SAL_CALL OResultSetMetaData::isSigned( sal_Int32 column ) throw(SQLException, RuntimeException)
 181 {
 182     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 183     if(aField.IsValid())
 184     {
 185         DataTypeEnum eType = aField.GetADOType();
 186         return !(eType == adUnsignedBigInt || eType == adUnsignedInt || eType == adUnsignedSmallInt || eType == adUnsignedTinyInt);
 187     }
 188     return sal_False;
 189 }
 190
 191 sal_Int32 SAL_CALL OResultSetMetaData::getPrecision( sal_Int32 column ) throw(SQLException, RuntimeException)
 192 {
 193     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 194     if(aField.IsValid())
 195         return aField.GetPrecision();
 196     return 0;
 197 }
 198
 199 sal_Int32 SAL_CALL OResultSetMetaData::getScale( sal_Int32 column ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
 200 {
 201     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 202     if(aField.IsValid())
 203         return aField.GetNumericScale();
 204     return 0;
 205 }
 206
 207
 208 sal_Int32 SAL_CALL OResultSetMetaData::isNullable( sal_Int32 column ) throw(SQLException, RuntimeException)
 209 {
 210     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 211     if(aField.IsValid())
 212     {
 213         return (aField.GetAttributes() & adFldIsNullable) == adFldIsNullable;
 214     }
 215     return sal_False;
 216 }
 217
 218
 219 sal_Bool SAL_CALL OResultSetMetaData::isSearchable( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 220 {
 221     return sal_True;
 222 }
 223
 224
 225 sal_Bool SAL_CALL OResultSetMetaData::isReadOnly( sal_Int32 column ) throw(SQLException, RuntimeException)
 226 {
 227     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 228     if(aField.IsValid())
 229     {
 230         //  return (aField.GetStatus() & adFieldReadOnly) == adFieldReadOnly;
 231     }
 232     return sal_False;
 233 }
 234
 235
 236 sal_Bool SAL_CALL OResultSetMetaData::isDefinitelyWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 237 {
 238     WpADOField aField = ADOS::getField(m_pRecordSet,column);
 239     if(aField.IsValid())
 240     {
 241         return (aField.GetAttributes() & adFldUpdatable) == adFldUpdatable;
 242     }
 243     return sal_False;
 244 ;
 245 }
 246
 247 sal_Bool SAL_CALL OResultSetMetaData::isWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 248 {
 249     return isDefinitelyWritable(column);
 250 }
 251
 252
 253 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */