connectivity/source/drivers/mozab/MResultSetMetaData.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: MResultSetMetaData.cxx,v $
  10  * $Revision: 1.8 $
  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 "connectivity/dbexception.hxx"
  34 #include "connectivity/dbtools.hxx"
  35 #include <comphelper/types.hxx>
  36 #include <comphelper/extract.hxx>
  37 #include <cppuhelper/typeprovider.hxx>
  38 #include <tools/diagnose_ex.h>
  39 #include "MResultSetMetaData.hxx"
  40 #include <com/sun/star/sdbc/DataType.hpp>
  41
  42 using namespace connectivity::mozab;
  43 using namespace com::sun::star::uno;
  44 using namespace com::sun::star::lang;
  45 using namespace com::sun::star::sdbc;
  46 using namespace com::sun::star::beans;
  47 using namespace ::dbtools;
  48 using namespace ::comphelper;
  49
  50 // -------------------------------------------------------------------------
  51 OResultSetMetaData::~OResultSetMetaData()
  52 {
  53    m_xColumns = NULL;
  54 }
  55
  56 // -----------------------------------------------------------------------------
  57 void OResultSetMetaData::checkColumnIndex(sal_Int32 column)  throw(SQLException, RuntimeException)
  58 {
  59     if(column <= 0 || column > (sal_Int32)(sal_Int32)m_xColumns->get().size())
  60         throwInvalidIndexException(*this);
  61 }
  62 // -------------------------------------------------------------------------
  63 sal_Int32 SAL_CALL OResultSetMetaData::getColumnDisplaySize( sal_Int32 column ) throw(SQLException, RuntimeException)
  64 {
  65     return getPrecision(column);
  66 }
  67 // -------------------------------------------------------------------------
  68
  69 sal_Int32 SAL_CALL OResultSetMetaData::getColumnType( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
  70 {
  71     return DataType::VARCHAR; // at the moment there exists only this type
  72 }
  73 // -------------------------------------------------------------------------
  74
  75 sal_Int32 SAL_CALL OResultSetMetaData::getColumnCount(  ) throw(SQLException, RuntimeException)
  76 {
  77     return (m_xColumns->get()).size();
  78 }
  79 // -------------------------------------------------------------------------
  80
  81 sal_Bool SAL_CALL OResultSetMetaData::isCaseSensitive( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
  82 {
  83     return sal_False;
  84 }
  85 // -------------------------------------------------------------------------
  86
  87 ::rtl::OUString SAL_CALL OResultSetMetaData::getSchemaName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
  88 {
  89     return ::rtl::OUString();
  90 }
  91 // -------------------------------------------------------------------------
  92
  93 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnName( sal_Int32 column ) throw(SQLException, RuntimeException)
  94 {
  95     checkColumnIndex(column);
  96
  97     ::rtl::OUString sColumnName;
  98     try
  99     {
 100         Reference< XPropertySet > xColumnProps( (m_xColumns->get())[column-1], UNO_QUERY_THROW );
 101         OSL_VERIFY( xColumnProps->getPropertyValue( OMetaConnection::getPropMap().getNameByIndex( PROPERTY_ID_NAME ) ) >>= sColumnName );
 102     }
 103     catch( const Exception& )
 104     {
 105         DBG_UNHANDLED_EXCEPTION();
 106     }
 107     return sColumnName;
 108 }
 109 // -------------------------------------------------------------------------
 110 ::rtl::OUString SAL_CALL OResultSetMetaData::getTableName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 111 {
 112     return m_aTableName;
 113 }
 114 // -------------------------------------------------------------------------
 115 ::rtl::OUString SAL_CALL OResultSetMetaData::getCatalogName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 116 {
 117     return ::rtl::OUString();
 118 }
 119 // -------------------------------------------------------------------------
 120 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnTypeName( sal_Int32 column ) throw(SQLException, RuntimeException)
 121 {
 122     checkColumnIndex(column);
 123     return getString((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME)));
 124 }
 125 // -------------------------------------------------------------------------
 126 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnLabel( sal_Int32 column ) throw(SQLException, RuntimeException)
 127 {
 128     return getColumnName(column);
 129 }
 130 // -------------------------------------------------------------------------
 131 ::rtl::OUString SAL_CALL OResultSetMetaData::getColumnServiceName( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 132 {
 133     return ::rtl::OUString();
 134 }
 135 // -------------------------------------------------------------------------
 136
 137 sal_Bool SAL_CALL OResultSetMetaData::isCurrency( sal_Int32 column ) throw(SQLException, RuntimeException)
 138 {
 139     checkColumnIndex(column);
 140     return getBOOL((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISCURRENCY)));
 141 }
 142 // -------------------------------------------------------------------------
 143
 144 sal_Bool SAL_CALL OResultSetMetaData::isAutoIncrement( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 145 {
 146     return sal_False;
 147 }
 148 // -------------------------------------------------------------------------
 149 sal_Bool SAL_CALL OResultSetMetaData::isSigned( sal_Int32 /*column*/ ) throw(SQLException, RuntimeException)
 150 {
 151     return sal_False;
 152 }
 153 // -------------------------------------------------------------------------
 154 sal_Int32 SAL_CALL OResultSetMetaData::getPrecision( sal_Int32 column ) throw(SQLException, RuntimeException)
 155 {
 156     checkColumnIndex(column);
 157     return getINT32((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION)));
 158 }
 159 // -------------------------------------------------------------------------
 160 sal_Int32 SAL_CALL OResultSetMetaData::getScale( sal_Int32 column ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::uno::RuntimeException)
 161 {
 162     checkColumnIndex(column);
 163     return getINT32((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE)));
 164 }
 165 // -------------------------------------------------------------------------
 166
 167 sal_Int32 SAL_CALL OResultSetMetaData::isNullable( sal_Int32 column ) throw(SQLException, RuntimeException)
 168 {
 169     checkColumnIndex(column);
 170     return getINT32((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE)));
 171 }
 172 // -------------------------------------------------------------------------
 173
 174 sal_Bool SAL_CALL OResultSetMetaData::isSearchable( sal_Int32 column ) throw(SQLException, RuntimeException)
 175 {
 176     ::rtl::OUString sColumnName( getColumnName( column ) );
 177
 178     if ( !m_pTable || !m_pTable->getConnection() )
 179     {
 180         OSL_ENSURE( false, "OResultSetMetaData::isSearchable: suspicious: called without table or connection!" );
 181         return sal_False;
 182     }
 183
 184     if ( m_pTable->getConnection()->isLDAP() )
 185     {
 186         const OColumnAlias& aAliases( m_pTable->getConnection()->getColumnAlias() );
 187         if ( !aAliases.isColumnSearchable( sColumnName ) )
 188             return sal_False;
 189     }
 190
 191     return sal_True;
 192 }
 193 // -------------------------------------------------------------------------
 194
 195 sal_Bool SAL_CALL OResultSetMetaData::isReadOnly( sal_Int32 column ) throw(SQLException, RuntimeException)
 196 {
 197     checkColumnIndex(column);
 198     sal_Bool bReadOnly = (m_xColumns->get())[column-1]->getPropertySetInfo()->hasPropertyByName(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FUNCTION)) &&
 199         ::cppu::any2bool((m_xColumns->get())[column-1]->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_FUNCTION)));
 200
 201     return m_bReadOnly || bReadOnly || m_pTable->isReadOnly();
 202 }
 203 // -------------------------------------------------------------------------
 204
 205 sal_Bool SAL_CALL OResultSetMetaData::isDefinitelyWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 206 {
 207     return !isReadOnly(column);
 208 }
 209 // -------------------------------------------------------------------------
 210 sal_Bool SAL_CALL OResultSetMetaData::isWritable( sal_Int32 column ) throw(SQLException, RuntimeException)
 211 {
 212     return !isReadOnly(column);
 213 }
 214 // -------------------------------------------------------------------------
 215