1*cdf0e10cSrcweir /************************************************************************* 2*cdf0e10cSrcweir * 3*cdf0e10cSrcweir * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. 4*cdf0e10cSrcweir * 5*cdf0e10cSrcweir * Copyright 2000, 2010 Oracle and/or its affiliates. 6*cdf0e10cSrcweir * 7*cdf0e10cSrcweir * OpenOffice.org - a multi-platform office productivity suite 8*cdf0e10cSrcweir * 9*cdf0e10cSrcweir * This file is part of OpenOffice.org. 10*cdf0e10cSrcweir * 11*cdf0e10cSrcweir * OpenOffice.org is free software: you can redistribute it and/or modify 12*cdf0e10cSrcweir * it under the terms of the GNU Lesser General Public License version 3 13*cdf0e10cSrcweir * only, as published by the Free Software Foundation. 14*cdf0e10cSrcweir * 15*cdf0e10cSrcweir * OpenOffice.org is distributed in the hope that it will be useful, 16*cdf0e10cSrcweir * but WITHOUT ANY WARRANTY; without even the implied warranty of 17*cdf0e10cSrcweir * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the 18*cdf0e10cSrcweir * GNU Lesser General Public License version 3 for more details 19*cdf0e10cSrcweir * (a copy is included in the LICENSE file that accompanied this code). 20*cdf0e10cSrcweir * 21*cdf0e10cSrcweir * You should have received a copy of the GNU Lesser General Public License 22*cdf0e10cSrcweir * version 3 along with OpenOffice.org. If not, see 23*cdf0e10cSrcweir * <http://www.openoffice.org/license.html> 24*cdf0e10cSrcweir * for a copy of the LGPLv3 License. 25*cdf0e10cSrcweir * 26*cdf0e10cSrcweir ************************************************************************/ 27*cdf0e10cSrcweir 28*cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove 29*cdf0e10cSrcweir #include "precompiled_connectivity.hxx" 30*cdf0e10cSrcweir #include "dbase/DTables.hxx" 31*cdf0e10cSrcweir #include "dbase/DTable.hxx" 32*cdf0e10cSrcweir #include <com/sun/star/sdbc/XRow.hpp> 33*cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSet.hpp> 34*cdf0e10cSrcweir #include <com/sun/star/sdbc/ColumnValue.hpp> 35*cdf0e10cSrcweir #include <com/sun/star/sdbc/KeyRule.hpp> 36*cdf0e10cSrcweir #include <com/sun/star/sdbcx/KeyType.hpp> 37*cdf0e10cSrcweir #include "file/FCatalog.hxx" 38*cdf0e10cSrcweir #include "file/FConnection.hxx" 39*cdf0e10cSrcweir #include <com/sun/star/lang/XUnoTunnel.hpp> 40*cdf0e10cSrcweir #include "dbase/DCatalog.hxx" 41*cdf0e10cSrcweir #include <comphelper/types.hxx> 42*cdf0e10cSrcweir #include "resource/dbase_res.hrc" 43*cdf0e10cSrcweir #include "connectivity/dbexception.hxx" 44*cdf0e10cSrcweir 45*cdf0e10cSrcweir using namespace ::comphelper; 46*cdf0e10cSrcweir using namespace connectivity; 47*cdf0e10cSrcweir using namespace connectivity::dbase; 48*cdf0e10cSrcweir using namespace connectivity::file; 49*cdf0e10cSrcweir using namespace ::com::sun::star::uno; 50*cdf0e10cSrcweir using namespace ::com::sun::star::beans; 51*cdf0e10cSrcweir using namespace ::com::sun::star::sdbcx; 52*cdf0e10cSrcweir using namespace ::com::sun::star::sdbc; 53*cdf0e10cSrcweir using namespace ::com::sun::star::lang; 54*cdf0e10cSrcweir using namespace ::com::sun::star::container; 55*cdf0e10cSrcweir namespace starutil = ::com::sun::star::util; 56*cdf0e10cSrcweir 57*cdf0e10cSrcweir sdbcx::ObjectType ODbaseTables::createObject(const ::rtl::OUString& _rName) 58*cdf0e10cSrcweir { 59*cdf0e10cSrcweir ::rtl::OUString aName,aSchema; 60*cdf0e10cSrcweir ODbaseTable* pRet = new ODbaseTable(this,(ODbaseConnection*)static_cast<OFileCatalog&>(m_rParent).getConnection(), 61*cdf0e10cSrcweir _rName,::rtl::OUString::createFromAscii("TABLE")); 62*cdf0e10cSrcweir 63*cdf0e10cSrcweir sdbcx::ObjectType xRet = pRet; 64*cdf0e10cSrcweir pRet->construct(); 65*cdf0e10cSrcweir return xRet; 66*cdf0e10cSrcweir } 67*cdf0e10cSrcweir // ------------------------------------------------------------------------- 68*cdf0e10cSrcweir void ODbaseTables::impl_refresh( ) throw(RuntimeException) 69*cdf0e10cSrcweir { 70*cdf0e10cSrcweir static_cast<ODbaseCatalog*>(&m_rParent)->refreshTables(); 71*cdf0e10cSrcweir } 72*cdf0e10cSrcweir // ------------------------------------------------------------------------- 73*cdf0e10cSrcweir Reference< XPropertySet > ODbaseTables::createDescriptor() 74*cdf0e10cSrcweir { 75*cdf0e10cSrcweir return new ODbaseTable(this,(ODbaseConnection*)static_cast<OFileCatalog&>(m_rParent).getConnection()); 76*cdf0e10cSrcweir } 77*cdf0e10cSrcweir typedef connectivity::sdbcx::OCollection ODbaseTables_BASE_BASE; 78*cdf0e10cSrcweir // ------------------------------------------------------------------------- 79*cdf0e10cSrcweir // XAppend 80*cdf0e10cSrcweir sdbcx::ObjectType ODbaseTables::appendObject( const ::rtl::OUString& _rForName, const Reference< XPropertySet >& descriptor ) 81*cdf0e10cSrcweir { 82*cdf0e10cSrcweir Reference<XUnoTunnel> xTunnel(descriptor,UNO_QUERY); 83*cdf0e10cSrcweir if(xTunnel.is()) 84*cdf0e10cSrcweir { 85*cdf0e10cSrcweir ODbaseTable* pTable = reinterpret_cast< ODbaseTable* >( xTunnel->getSomething(ODbaseTable::getUnoTunnelImplementationId()) ); 86*cdf0e10cSrcweir if(pTable) 87*cdf0e10cSrcweir { 88*cdf0e10cSrcweir pTable->setPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME),makeAny(_rForName)); 89*cdf0e10cSrcweir try 90*cdf0e10cSrcweir { 91*cdf0e10cSrcweir if(!pTable->CreateImpl()) 92*cdf0e10cSrcweir throw SQLException(); 93*cdf0e10cSrcweir } 94*cdf0e10cSrcweir catch(SQLException&) 95*cdf0e10cSrcweir { 96*cdf0e10cSrcweir throw; 97*cdf0e10cSrcweir } 98*cdf0e10cSrcweir catch(Exception&) 99*cdf0e10cSrcweir { 100*cdf0e10cSrcweir throw SQLException(); 101*cdf0e10cSrcweir } 102*cdf0e10cSrcweir } 103*cdf0e10cSrcweir } 104*cdf0e10cSrcweir return createObject( _rForName ); 105*cdf0e10cSrcweir } 106*cdf0e10cSrcweir // ------------------------------------------------------------------------- 107*cdf0e10cSrcweir // XDrop 108*cdf0e10cSrcweir void ODbaseTables::dropObject(sal_Int32 _nPos,const ::rtl::OUString _sElementName) 109*cdf0e10cSrcweir { 110*cdf0e10cSrcweir Reference< XUnoTunnel> xTunnel; 111*cdf0e10cSrcweir try 112*cdf0e10cSrcweir { 113*cdf0e10cSrcweir xTunnel.set(getObject(_nPos),UNO_QUERY); 114*cdf0e10cSrcweir } 115*cdf0e10cSrcweir catch(const Exception&) 116*cdf0e10cSrcweir { 117*cdf0e10cSrcweir if(ODbaseTable::Drop_Static(ODbaseTable::getEntry(static_cast<OFileCatalog&>(m_rParent).getConnection(),_sElementName),sal_False,NULL)) 118*cdf0e10cSrcweir return; 119*cdf0e10cSrcweir } 120*cdf0e10cSrcweir 121*cdf0e10cSrcweir if ( xTunnel.is() ) 122*cdf0e10cSrcweir { 123*cdf0e10cSrcweir ODbaseTable* pTable = reinterpret_cast< ODbaseTable* >( xTunnel->getSomething(ODbaseTable::getUnoTunnelImplementationId()) ); 124*cdf0e10cSrcweir if(pTable) 125*cdf0e10cSrcweir pTable->DropImpl(); 126*cdf0e10cSrcweir } 127*cdf0e10cSrcweir else 128*cdf0e10cSrcweir { 129*cdf0e10cSrcweir const ::rtl::OUString sError( static_cast<OFileCatalog&>(m_rParent).getConnection()->getResources().getResourceStringWithSubstitution( 130*cdf0e10cSrcweir STR_TABLE_NOT_DROP, 131*cdf0e10cSrcweir "$tablename$", _sElementName 132*cdf0e10cSrcweir ) ); 133*cdf0e10cSrcweir ::dbtools::throwGenericSQLException( sError, NULL ); 134*cdf0e10cSrcweir } 135*cdf0e10cSrcweir } 136*cdf0e10cSrcweir // ------------------------------------------------------------------------- 137*cdf0e10cSrcweir Any SAL_CALL ODbaseTables::queryInterface( const Type & rType ) throw(RuntimeException) 138*cdf0e10cSrcweir { 139*cdf0e10cSrcweir typedef sdbcx::OCollection OTables_BASE; 140*cdf0e10cSrcweir return OTables_BASE::queryInterface(rType); 141*cdf0e10cSrcweir } 142*cdf0e10cSrcweir // ----------------------------------------------------------------------------- 143*cdf0e10cSrcweir 144*cdf0e10cSrcweir 145