1 /************************************************************************* 2 * 3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4 * 5 * Copyright 2000, 2010 Oracle and/or its affiliates. 6 * 7 * OpenOffice.org - a multi-platform office productivity suite 8 * 9 * This file is part of OpenOffice.org. 10 * 11 * OpenOffice.org is free software: you can redistribute it and/or modify 12 * it under the terms of the GNU Lesser General Public License version 3 13 * only, as published by the Free Software Foundation. 14 * 15 * OpenOffice.org is distributed in the hope that it will be useful, 16 * but WITHOUT ANY WARRANTY; without even the implied warranty of 17 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18 * GNU Lesser General Public License version 3 for more details 19 * (a copy is included in the LICENSE file that accompanied this code). 20 * 21 * You should have received a copy of the GNU Lesser General Public License 22 * version 3 along with OpenOffice.org. If not, see 23 * <http://www.openoffice.org/license.html> 24 * for a copy of the LGPLv3 License. 25 * 26 ************************************************************************/ 27 28 // MARKER(update_precomp.py): autogen include statement, do not remove 29 #include "precompiled_connectivity.hxx" 30 31 32 #include "calc/CCatalog.hxx" 33 #include "calc/CConnection.hxx" 34 #include "calc/CTables.hxx" 35 #include <com/sun/star/sdbc/XRow.hpp> 36 #include <com/sun/star/sdbc/XResultSet.hpp> 37 #include <rtl/logfile.hxx> 38 39 using namespace ::com::sun::star::uno; 40 using namespace ::com::sun::star::beans; 41 using namespace ::com::sun::star::sdbcx; 42 using namespace ::com::sun::star::sdbc; 43 using namespace ::com::sun::star::container; 44 45 // ------------------------------------------------------------------------- 46 using namespace connectivity::calc; 47 // ------------------------------------------------------------------------- 48 OCalcCatalog::OCalcCatalog(OCalcConnection* _pCon) : file::OFileCatalog(_pCon) 49 { 50 RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcCatalog::OCalcCatalog" ); 51 } 52 // ------------------------------------------------------------------------- 53 void OCalcCatalog::refreshTables() 54 { 55 RTL_LOGFILE_CONTEXT_AUTHOR( aLogger, "calc", "Ocke.Janssen@sun.com", "OCalcCatalog::refreshTables" ); 56 TStringVector aVector; 57 Sequence< ::rtl::OUString > aTypes; 58 OCalcConnection::ODocHolder aDocHodler(((OCalcConnection*)m_pConnection)); 59 Reference< XResultSet > xResult = m_xMetaData->getTables(Any(), 60 ::rtl::OUString::createFromAscii("%"),::rtl::OUString::createFromAscii("%"),aTypes); 61 62 if(xResult.is()) 63 { 64 Reference< XRow > xRow(xResult,UNO_QUERY); 65 while(xResult->next()) 66 aVector.push_back(xRow->getString(3)); 67 } 68 if(m_pTables) 69 m_pTables->reFill(aVector); 70 else 71 m_pTables = new OCalcTables(m_xMetaData,*this,m_aMutex,aVector); 72 73 // this avoids that the document will be loaded a 2nd time when one table will be accessed. 74 //if ( m_pTables && m_pTables->hasElements() ) 75 // m_pTables->getByIndex(0); 76 } 77 // ----------------------------------------------------------------------------- 78 79 80 81