LCOV - code coverage report
Current view: top level - libreoffice/connectivity/source/drivers/calc - CDatabaseMetaData.cxx (source / functions) Hit Total Coverage
Test: libreoffice_filtered.info Lines: 0 225 0.0 %
Date: 2012-12-27 Functions: 0 14 0.0 %
Legend: Lines: hit not hit

          Line data    Source code
       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 "calc/CDatabaseMetaData.hxx"
      21             : #include "calc/CConnection.hxx"
      22             : #include <com/sun/star/sdbc/DataType.hpp>
      23             : #include <com/sun/star/sdbc/ResultSetType.hpp>
      24             : #include <com/sun/star/sdbc/ColumnValue.hpp>
      25             : #include <com/sun/star/beans/XPropertySet.hpp>
      26             : #include <com/sun/star/sdbc/ResultSetConcurrency.hpp>
      27             : #include <com/sun/star/sdbcx/XColumnsSupplier.hpp>
      28             : #include <com/sun/star/sdbcx/XIndexesSupplier.hpp>
      29             : #include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
      30             : #include <com/sun/star/sheet/XSpreadsheet.hpp>
      31             : #include <com/sun/star/sheet/XCellRangesQuery.hpp>
      32             : #include <com/sun/star/sheet/XCellRangeAddressable.hpp>
      33             : #include <com/sun/star/sheet/XDatabaseRanges.hpp>
      34             : #include <com/sun/star/sheet/XDatabaseRange.hpp>
      35             : #include "FDatabaseMetaDataResultSet.hxx"
      36             : #include <com/sun/star/lang/XUnoTunnel.hpp>
      37             : #include <comphelper/types.hxx>
      38             : #include <rtl/logfile.hxx>
      39             : 
      40             : using namespace connectivity::calc;
      41             : using namespace connectivity::file;
      42             : using namespace ::com::sun::star::uno;
      43             : using namespace ::com::sun::star::beans;
      44             : using namespace ::com::sun::star::sdbcx;
      45             : using namespace ::com::sun::star::sdbc;
      46             : using namespace ::com::sun::star::container;
      47             : using namespace ::com::sun::star::table;
      48             : using namespace ::com::sun::star::sheet;
      49             : 
      50             : // -------------------------------------------------------------------------
      51             : 
      52           0 : OCalcDatabaseMetaData::OCalcDatabaseMetaData(OConnection* _pCon)    :ODatabaseMetaData(_pCon)
      53             : {
      54             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::OCalcDatabaseMetaData" );
      55           0 : }
      56             : 
      57             : // -------------------------------------------------------------------------
      58             : 
      59           0 : OCalcDatabaseMetaData::~OCalcDatabaseMetaData()
      60             : {
      61           0 : }
      62             : 
      63             : // -------------------------------------------------------------------------
      64           0 : Reference< XResultSet > OCalcDatabaseMetaData::impl_getTypeInfo_throw(  )
      65             : {
      66             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::impl_getTypeInfo_throw" );
      67           0 :     ::osl::MutexGuard aGuard( m_aMutex );
      68             : 
      69           0 :     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eTypeInfo);
      70           0 :     Reference< XResultSet > xRef = pResult;
      71             : 
      72           0 :     static ODatabaseMetaDataResultSet::ORows aRows;
      73           0 :     if(aRows.empty())
      74             :     {
      75           0 :         ODatabaseMetaDataResultSet::ORow aRow;
      76             : 
      77           0 :         aRows.reserve(6);
      78           0 :         aRow.reserve(18);
      79             : 
      80           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
      81           0 :         aRow.push_back(new ORowSetValueDecorator(::rtl::OUString("VARCHAR")));
      82           0 :         aRow.push_back(new ORowSetValueDecorator(DataType::VARCHAR));
      83           0 :         aRow.push_back(new ORowSetValueDecorator((sal_Int32)65535));
      84           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
      85           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getQuoteValue());
      86           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
      87           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get1Value()); // ORowSetValue((sal_Int32)ColumnValue::NULLABLE)
      88           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
      89           0 :         aRow.push_back(new ORowSetValueDecorator((sal_Int32)ColumnSearch::CHAR));
      90           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get1Value());
      91           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
      92           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
      93           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
      94           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
      95           0 :         aRow.push_back(ODatabaseMetaDataResultSet::get0Value());
      96           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
      97           0 :         aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
      98           0 :         aRow.push_back(new ORowSetValueDecorator((sal_Int32)10));
      99             : 
     100             : 
     101           0 :         aRows.push_back(aRow);
     102             : 
     103           0 :         aRow[1] = new ORowSetValueDecorator(::rtl::OUString("DECIMAL"));
     104           0 :         aRow[2] = new ORowSetValueDecorator(DataType::DECIMAL);
     105           0 :         aRow[3] = ODatabaseMetaDataResultSet::get0Value();
     106           0 :         aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
     107           0 :         aRow[15] = ODatabaseMetaDataResultSet::get0Value();
     108           0 :         aRows.push_back(aRow);
     109             : 
     110           0 :         aRow[1] = new ORowSetValueDecorator(::rtl::OUString("BOOL"));
     111           0 :         aRow[2] = new ORowSetValueDecorator(DataType::BIT);
     112           0 :         aRow[3] = new ORowSetValueDecorator((sal_Int32)20);
     113           0 :         aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
     114           0 :         aRow[15] = new ORowSetValueDecorator((sal_Int32)15);
     115           0 :         aRows.push_back(aRow);
     116             : 
     117           0 :         aRow[1] = new ORowSetValueDecorator(::rtl::OUString("DATE"));
     118           0 :         aRow[2] = new ORowSetValueDecorator(DataType::DATE);
     119           0 :         aRow[3] = ODatabaseMetaDataResultSet::get0Value();
     120           0 :         aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
     121           0 :         aRow[15] = ODatabaseMetaDataResultSet::get0Value();
     122           0 :         aRows.push_back(aRow);
     123             : 
     124           0 :         aRow[1] = new ORowSetValueDecorator(::rtl::OUString("TIME"));
     125           0 :         aRow[2] = new ORowSetValueDecorator(DataType::TIME);
     126           0 :         aRow[3] = ODatabaseMetaDataResultSet::get0Value();
     127           0 :         aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
     128           0 :         aRow[15] = ODatabaseMetaDataResultSet::get0Value();
     129           0 :         aRows.push_back(aRow);
     130             : 
     131           0 :         aRow[1] = new ORowSetValueDecorator(::rtl::OUString("TIMESTAMP"));
     132           0 :         aRow[2] = new ORowSetValueDecorator(DataType::TIMESTAMP);
     133           0 :         aRow[3] = ODatabaseMetaDataResultSet::get0Value();
     134           0 :         aRow[9] = ODatabaseMetaDataResultSet::getBasicValue();
     135           0 :         aRow[15] = ODatabaseMetaDataResultSet::get0Value();
     136           0 :         aRows.push_back(aRow);
     137             :     }
     138             : 
     139           0 :     pResult->setRows(aRows);
     140           0 :     return xRef;
     141             : }
     142             : 
     143             : // -------------------------------------------------------------------------
     144             : 
     145           0 : Reference< XResultSet > SAL_CALL OCalcDatabaseMetaData::getColumns(
     146             :     const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/, const ::rtl::OUString& tableNamePattern,
     147             :         const ::rtl::OUString& columnNamePattern ) throw(SQLException, RuntimeException)
     148             : {
     149             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getColumns" );
     150           0 :     ::osl::MutexGuard aGuard( m_aMutex );
     151             : 
     152             : 
     153           0 :     Reference< XTablesSupplier > xTables = m_pConnection->createCatalog();
     154           0 :     if(!xTables.is())
     155           0 :         throw SQLException();
     156             : 
     157           0 :     Reference< XNameAccess> xNames = xTables->getTables();
     158           0 :     if(!xNames.is())
     159           0 :         throw SQLException();
     160             : 
     161           0 :     ODatabaseMetaDataResultSet::ORows aRows;
     162           0 :     ODatabaseMetaDataResultSet::ORow  aRow(19);
     163             : 
     164           0 :     aRow[10] = new ORowSetValueDecorator((sal_Int32)10);
     165             : 
     166           0 :     Sequence< ::rtl::OUString> aTabNames(xNames->getElementNames());
     167           0 :     const ::rtl::OUString* pTabIter = aTabNames.getConstArray();
     168           0 :     const ::rtl::OUString* pTabEnd      = pTabIter + aTabNames.getLength();
     169           0 :     for(;pTabIter != pTabEnd;++pTabIter)
     170             :     {
     171           0 :         if(match(tableNamePattern,*pTabIter,'\0'))
     172             :         {
     173           0 :             const Reference< XColumnsSupplier> xTable(xNames->getByName(*pTabIter),UNO_QUERY_THROW);
     174             :             OSL_ENSURE(xTable.is(),"Table not found! Normallya exception had to be thrown here!");
     175           0 :             aRow[3] = new ORowSetValueDecorator(*pTabIter);
     176             : 
     177           0 :             const Reference< XNameAccess> xColumns = xTable->getColumns();
     178           0 :             if(!xColumns.is())
     179           0 :                 throw SQLException();
     180             : 
     181           0 :             const Sequence< ::rtl::OUString> aColNames(xColumns->getElementNames());
     182             : 
     183           0 :             const ::rtl::OUString* pColumnIter = aColNames.getConstArray();
     184           0 :             const ::rtl::OUString* pEnd = pColumnIter + aColNames.getLength();
     185           0 :             Reference< XPropertySet> xColumn;
     186           0 :             for(sal_Int32 i=1;pColumnIter != pEnd;++pColumnIter,++i)
     187             :             {
     188           0 :                 if(match(columnNamePattern,*pColumnIter,'\0'))
     189             :                 {
     190           0 :                     aRow[4]  = new ORowSetValueDecorator( *pColumnIter);
     191             : 
     192           0 :                     xColumns->getByName(*pColumnIter) >>= xColumn;
     193             :                     OSL_ENSURE(xColumn.is(),"Columns contains a column who isn't a fastpropertyset!");
     194           0 :                     aRow[5] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPE))));
     195           0 :                     aRow[6] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME))));
     196           0 :                     aRow[7] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PRECISION))));
     197             :                     //  aRow[8] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
     198           0 :                     aRow[9] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCALE))));
     199           0 :                     aRow[11] = new ORowSetValueDecorator(::comphelper::getINT32(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_ISNULLABLE))));
     200             :                     //  aRow[12] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
     201           0 :                     aRow[13] = new ORowSetValueDecorator(::comphelper::getString(xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_DEFAULTVALUE))));
     202             :                     //  aRow[14] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
     203             :                     //  aRow[15] = xColumn->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_TYPENAME));
     204           0 :                     switch(sal_Int32(aRow[5]->getValue()))
     205             :                     {
     206             :                     case DataType::CHAR:
     207             :                     case DataType::VARCHAR:
     208           0 :                         aRow[16] = new ORowSetValueDecorator((sal_Int32)254);
     209           0 :                         break;
     210             :                     case DataType::LONGVARCHAR:
     211           0 :                         aRow[16] = new ORowSetValueDecorator((sal_Int32)65535);
     212           0 :                         break;
     213             :                     default:
     214           0 :                         aRow[16] = new ORowSetValueDecorator((sal_Int32)0);
     215             :                     }
     216           0 :                     aRow[17] = new ORowSetValueDecorator(i);
     217           0 :                     switch(sal_Int32(aRow[11]->getValue()))
     218             :                     {
     219             :                     case ColumnValue::NO_NULLS:
     220           0 :                         aRow[18]  = new ORowSetValueDecorator(::rtl::OUString("NO"));
     221           0 :                         break;
     222             :                     case ColumnValue::NULLABLE:
     223           0 :                         aRow[18]  = new ORowSetValueDecorator(::rtl::OUString("YES"));
     224           0 :                         break;
     225             :                     default:
     226           0 :                         aRow[18]  = new ORowSetValueDecorator(::rtl::OUString());
     227             :                     }
     228           0 :                     aRows.push_back(aRow);
     229             :                 }
     230           0 :             }
     231             :         }
     232             :     }
     233             : 
     234           0 :     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(::connectivity::ODatabaseMetaDataResultSet::eColumns);
     235           0 :     Reference< XResultSet > xRef = pResult;
     236           0 :     pResult->setRows(aRows);
     237             : 
     238           0 :     return xRef;
     239             : }
     240             : 
     241             : // -------------------------------------------------------------------------
     242             : 
     243           0 : ::rtl::OUString SAL_CALL OCalcDatabaseMetaData::getURL(  ) throw(SQLException, RuntimeException)
     244             : {
     245             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getURL" );
     246           0 :     ::osl::MutexGuard aGuard( m_aMutex );
     247             : 
     248           0 :     return ::rtl::OUString("sdbc:calc:") + m_pConnection->getURL();
     249             : }
     250             : 
     251             : // -------------------------------------------------------------------------
     252             : 
     253           0 : sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxBinaryLiteralLength(  ) throw(SQLException, RuntimeException)
     254             : {
     255             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxBinaryLiteralLength" );
     256           0 :     return STRING_MAXLEN;
     257             : }
     258             : 
     259             : // -------------------------------------------------------------------------
     260             : 
     261           0 : sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxCharLiteralLength(  ) throw(SQLException, RuntimeException)
     262             : {
     263             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxCharLiteralLength" );
     264           0 :     return STRING_MAXLEN;
     265             : }
     266             : // -------------------------------------------------------------------------
     267           0 : sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnNameLength(  ) throw(SQLException, RuntimeException)
     268             : {
     269             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnNameLength" );
     270           0 :     return STRING_MAXLEN;
     271             : }
     272             : // -------------------------------------------------------------------------
     273           0 : sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnsInIndex(  ) throw(SQLException, RuntimeException)
     274             : {
     275             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnsInIndex" );
     276           0 :     return 1;
     277             : }
     278             : // -------------------------------------------------------------------------
     279           0 : sal_Int32 SAL_CALL OCalcDatabaseMetaData::getMaxColumnsInTable(  ) throw(SQLException, RuntimeException)
     280             : {
     281             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getMaxColumnsInTable" );
     282           0 :     return 256;
     283             : }
     284             : 
     285             : // -------------------------------------------------------------------------
     286             : 
     287           0 : static sal_Bool lcl_IsEmptyOrHidden( const Reference<XSpreadsheets>& xSheets, const ::rtl::OUString& rName )
     288             : {
     289           0 :     Any aAny = xSheets->getByName( rName );
     290           0 :     Reference<XSpreadsheet> xSheet;
     291           0 :     if ( aAny >>= xSheet )
     292             :     {
     293             :         //  test if sheet is hidden
     294             : 
     295           0 :         Reference<XPropertySet> xProp( xSheet, UNO_QUERY );
     296           0 :         if (xProp.is())
     297             :         {
     298           0 :             sal_Bool bVisible = sal_Bool();
     299           0 :             Any aVisAny = xProp->getPropertyValue( ::rtl::OUString("IsVisible") );
     300           0 :             if ( aVisAny >>= bVisible )
     301           0 :                 if (!bVisible)
     302           0 :                     return sal_True;                // hidden
     303             :         }
     304             : 
     305             :         //  use the same data area as in OCalcTable to test for empty table
     306             : 
     307           0 :         Reference<XSheetCellCursor> xCursor = xSheet->createCursor();
     308           0 :         Reference<XCellRangeAddressable> xRange( xCursor, UNO_QUERY );
     309           0 :         if ( xRange.is() )
     310             :         {
     311           0 :             xCursor->collapseToSize( 1, 1 );        // single (first) cell
     312           0 :             xCursor->collapseToCurrentRegion();     // contiguous data area
     313             : 
     314           0 :             CellRangeAddress aRangeAddr = xRange->getRangeAddress();
     315           0 :             if ( aRangeAddr.StartColumn == aRangeAddr.EndColumn &&
     316             :                  aRangeAddr.StartRow == aRangeAddr.EndRow )
     317             :             {
     318             :                 //  single cell -> check content
     319           0 :                 Reference<XCell> xCell = xCursor->getCellByPosition( 0, 0 );
     320           0 :                 if ( xCell.is() && xCell->getType() == CellContentType_EMPTY )
     321           0 :                     return sal_True;
     322             :             }
     323           0 :         }
     324             :     }
     325             : 
     326           0 :     return sal_False;
     327             : }
     328             : 
     329           0 : static sal_Bool lcl_IsUnnamed( const Reference<XDatabaseRanges>& xRanges, const ::rtl::OUString& rName )
     330             : {
     331           0 :     sal_Bool bUnnamed = sal_False;
     332             : 
     333           0 :     Any aAny = xRanges->getByName( rName );
     334           0 :     Reference<XDatabaseRange> xRange;
     335           0 :     if ( aAny >>= xRange )
     336             :     {
     337           0 :         Reference<XPropertySet> xRangeProp( xRange, UNO_QUERY );
     338           0 :         if ( xRangeProp.is() )
     339             :         {
     340             :             try
     341             :             {
     342           0 :                 Any aUserAny = xRangeProp->getPropertyValue( ::rtl::OUString("IsUserDefined") );
     343           0 :                 sal_Bool bUserDefined = sal_Bool();
     344           0 :                 if ( aUserAny >>= bUserDefined )
     345           0 :                     bUnnamed = !bUserDefined;
     346             :             }
     347           0 :             catch ( UnknownPropertyException& )
     348             :             {
     349             :                 // optional property
     350             :             }
     351           0 :         }
     352             :     }
     353             : 
     354           0 :     return bUnnamed;
     355             : }
     356             : 
     357             : // -------------------------------------------------------------------------
     358             : 
     359           0 : Reference< XResultSet > SAL_CALL OCalcDatabaseMetaData::getTables(
     360             :         const Any& /*catalog*/, const ::rtl::OUString& /*schemaPattern*/,
     361             :         const ::rtl::OUString& tableNamePattern, const Sequence< ::rtl::OUString >& types )
     362             :         throw(SQLException, RuntimeException)
     363             : {
     364             :     RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcDatabaseMetaData::getTables" );
     365           0 :     ::osl::MutexGuard aGuard( m_aMutex );
     366             : 
     367           0 :     ODatabaseMetaDataResultSet* pResult = new ODatabaseMetaDataResultSet(ODatabaseMetaDataResultSet::eTables);
     368           0 :     Reference< XResultSet > xRef = pResult;
     369             : 
     370             :     // check if ORowSetValue type is given
     371             :     // when no types are given then we have to return all tables e.g. TABLE
     372             : 
     373           0 :     ::rtl::OUString aTable("TABLE");
     374             : 
     375           0 :     sal_Bool bTableFound = sal_True;
     376           0 :     sal_Int32 nLength = types.getLength();
     377           0 :     if(nLength)
     378             :     {
     379           0 :         bTableFound = sal_False;
     380             : 
     381           0 :         const ::rtl::OUString* pIter = types.getConstArray();
     382           0 :         const ::rtl::OUString* pEnd = pIter + nLength;
     383           0 :         for(;pIter != pEnd;++pIter)
     384             :         {
     385           0 :             if(*pIter == aTable)
     386             :             {
     387           0 :                 bTableFound = sal_True;
     388           0 :                 break;
     389             :             }
     390             :         }
     391             :     }
     392           0 :     if(!bTableFound)
     393             :         return xRef;
     394             : 
     395             :     // get the sheet names from the document
     396             : 
     397           0 :     OCalcConnection::ODocHolder aDocHodler(((OCalcConnection*)m_pConnection));
     398           0 :     Reference<XSpreadsheetDocument> xDoc = aDocHodler.getDoc();
     399           0 :     if ( !xDoc.is() )
     400           0 :         throw SQLException();
     401           0 :     Reference<XSpreadsheets> xSheets = xDoc->getSheets();
     402           0 :     if ( !xSheets.is() )
     403           0 :         throw SQLException();
     404           0 :     Sequence< ::rtl::OUString > aSheetNames = xSheets->getElementNames();
     405             : 
     406           0 :     ODatabaseMetaDataResultSet::ORows aRows;
     407           0 :     sal_Int32 nSheetCount = aSheetNames.getLength();
     408           0 :     for (sal_Int32 nSheet=0; nSheet<nSheetCount; nSheet++)
     409             :     {
     410           0 :         ::rtl::OUString aName = aSheetNames[nSheet];
     411           0 :         if ( !lcl_IsEmptyOrHidden( xSheets, aName ) && match(tableNamePattern,aName,'\0') )
     412             :         {
     413           0 :             ODatabaseMetaDataResultSet::ORow aRow(3);
     414           0 :             aRow.reserve(6);
     415           0 :             aRow.push_back(new ORowSetValueDecorator(aName));
     416           0 :             aRow.push_back(new ORowSetValueDecorator(aTable));
     417           0 :             aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
     418           0 :             aRows.push_back(aRow);
     419             :         }
     420           0 :     }
     421             : 
     422             :     // also use database ranges
     423             : 
     424           0 :     Reference<XPropertySet> xDocProp( xDoc, UNO_QUERY );
     425           0 :     if ( xDocProp.is() )
     426             :     {
     427           0 :         Any aRangesAny = xDocProp->getPropertyValue( ::rtl::OUString("DatabaseRanges") );
     428           0 :         Reference<XDatabaseRanges> xRanges;
     429           0 :         if ( aRangesAny >>= xRanges )
     430             :         {
     431           0 :             Sequence< ::rtl::OUString > aDBNames = xRanges->getElementNames();
     432           0 :             sal_Int32 nDBCount = aDBNames.getLength();
     433           0 :             for (sal_Int32 nRange=0; nRange<nDBCount; nRange++)
     434             :             {
     435           0 :                 ::rtl::OUString aName = aDBNames[nRange];
     436           0 :                 if ( !lcl_IsUnnamed( xRanges, aName ) && match(tableNamePattern,aName,'\0') )
     437             :                 {
     438           0 :                     ODatabaseMetaDataResultSet::ORow aRow(3);
     439           0 :                     aRow.reserve(6);
     440           0 :                     aRow.push_back(new ORowSetValueDecorator(aName));
     441           0 :                     aRow.push_back(new ORowSetValueDecorator(aTable));
     442           0 :                     aRow.push_back(ODatabaseMetaDataResultSet::getEmptyValue());
     443           0 :                     aRows.push_back(aRow);
     444             :                 }
     445           0 :             }
     446           0 :         }
     447             :     }
     448             : 
     449           0 :     pResult->setRows(aRows);
     450             : 
     451           0 :     return xRef;
     452             : }
     453             : // -----------------------------------------------------------------------------
     454             : 
     455             : 
     456             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */

Generated by: LCOV version 1.10