/************************************************************************* * * $RCSfile: BViews.cxx,v $ * * $Revision: 1.12 $ * * last change: $Author: oj $ $Date: 2001-10-30 11:03:21 $ * * The Contents of this file are made available subject to the terms of * either of the following licenses * * - GNU Lesser General Public License Version 2.1 * - Sun Industry Standards Source License Version 1.1 * * Sun Microsystems Inc., October, 2000 * * GNU Lesser General Public License Version 2.1 * ============================================= * Copyright 2000 by Sun Microsystems, Inc. * 901 San Antonio Road, Palo Alto, CA 94303, USA * * This library is free software; you can redistribute it and/or * modify it under the terms of the GNU Lesser General Public * License version 2.1, as published by the Free Software Foundation. * * This library is distributed in the hope that it will be useful, * but WITHOUT ANY WARRANTY; without even the implied warranty of * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU * Lesser General Public License for more details. * * You should have received a copy of the GNU Lesser General Public * License along with this library; if not, write to the Free Software * Foundation, Inc., 59 Temple Place, Suite 330, Boston, * MA 02111-1307 USA * * * Sun Industry Standards Source License Version 1.1 * ================================================= * The contents of this file are subject to the Sun Industry Standards * Source License Version 1.1 (the "License"); You may not use this file * except in compliance with the License. You may obtain a copy of the * License at http://www.openoffice.org/license.html. * * Software provided under this License is provided on an "AS IS" basis, * WITHOUT WARRANTY OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, * WITHOUT LIMITATION, WARRANTIES THAT THE SOFTWARE IS FREE OF DEFECTS, * MERCHANTABLE, FIT FOR A PARTICULAR PURPOSE, OR NON-INFRINGING. * See the License for the specific provisions governing your rights and * obligations concerning the Software. * * The Initial Developer of the Original Code is: Sun Microsystems, Inc. * * Copyright: 2000 by Sun Microsystems, Inc. * * All Rights Reserved. * * Contributor(s): _______________________________________ * * ************************************************************************/ #ifndef _CONNECTIVITY_ADABAS_VIEWS_HXX_ #include "adabas/BViews.hxx" #endif #ifndef _CONNECTIVITY_ADABAS_TABLES_HXX_ #include "adabas/BTables.hxx" #endif #ifndef _COM_SUN_STAR_SDBC_XROW_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBC_XRESULTSET_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBC_COLUMNVALUE_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBC_KEYRULE_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBCX_KEYTYPE_HPP_ #include #endif #ifndef _COM_SUN_STAR_SDBCX_CHECKOPTION_HPP_ #include #endif #ifndef _CONNECTIVITY_ADABAS_CATALOG_HXX_ #include "adabas/BCatalog.hxx" #endif #ifndef _CONNECTIVITY_ADABAS_BCONNECTION_HXX_ #include "adabas/BConnection.hxx" #endif #ifndef _COMPHELPER_EXTRACT_HXX_ #include #endif #ifndef _CONNECTIVITY_DBTOOLS_HXX_ #include "connectivity/dbtools.hxx" #endif #ifndef _DBHELPER_DBEXCEPTION_HXX_ #include "connectivity/dbexception.hxx" #endif #ifndef _CPPUHELPER_INTERFACECONTAINER_H_ #include #endif #ifndef _CONNECTIVITY_SDBCX_VIEW_HXX_ #include "connectivity/sdbcx/VView.hxx" #endif #ifndef _COMPHELPER_TYPES_HXX_ #include #endif using namespace ::comphelper; using namespace ::cppu; using namespace connectivity::adabas; using namespace ::com::sun::star::uno; using namespace ::com::sun::star::beans; using namespace ::com::sun::star::sdbcx; using namespace ::com::sun::star::sdbc; using namespace ::com::sun::star::container; using namespace ::com::sun::star::lang; using namespace dbtools; typedef connectivity::sdbcx::OCollection OCollection_TYPE; Reference< XNamed > OViews::createObject(const ::rtl::OUString& _rName) { ::rtl::OUString aName,aSchema; sal_Int32 nLen = _rName.indexOf('.'); aSchema = _rName.copy(0,nLen); aName = _rName.copy(nLen+1); ::rtl::OUString sStmt = ::rtl::OUString::createFromAscii("SELECT DISTINCT * FROM DOMAIN.SHOW_VIEW WHERE "); if(aSchema.getLength()) { sStmt += ::rtl::OUString::createFromAscii("OWNER = '"); sStmt += aSchema; sStmt += ::rtl::OUString::createFromAscii("' AND "); } sStmt += ::rtl::OUString::createFromAscii("VIEWNAME = '"); sStmt += aName; sStmt += ::rtl::OUString::createFromAscii("'"); Reference xConnection = static_cast(m_rParent).getConnection(); Reference< XStatement > xStmt = xConnection->createStatement( ); Reference< XResultSet > xResult = xStmt->executeQuery(sStmt); Reference< XNamed > xRet = NULL; if(xResult.is()) { Reference< XRow > xRow(xResult,UNO_QUERY); if(xResult->next()) // there can be only one table with this name { connectivity::sdbcx::OView* pRet = new connectivity::sdbcx::OView(sal_True, aName, xConnection->getMetaData(), CheckOption::NONE, xRow->getString(3), aSchema); xRet = pRet; } ::comphelper::disposeComponent(xResult); } ::comphelper::disposeComponent(xStmt); return xRet; } // ------------------------------------------------------------------------- void OViews::impl_refresh( ) throw(RuntimeException) { static_cast(m_rParent).refreshTables(); } // ------------------------------------------------------------------------- void OViews::disposing(void) { m_xMetaData = NULL; OCollection::disposing(); } // ------------------------------------------------------------------------- Reference< XPropertySet > OViews::createEmptyObject() { Reference xConnection = static_cast(m_rParent).getConnection(); connectivity::sdbcx::OView* pNew = new connectivity::sdbcx::OView(sal_True,xConnection->getMetaData()); return pNew; } // ------------------------------------------------------------------------- // XAppend void OViews::appendObject( const Reference< XPropertySet >& descriptor ) { ::rtl::OUString aName = getString(descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))); if(!aName.getLength()) ::dbtools::throwFunctionSequenceException(*this); createView(descriptor); } // ------------------------------------------------------------------------- // XDrop void OViews::dropObject(sal_Int32 _nPos,const ::rtl::OUString _sElementName) { if(m_bInDrop) return; ObjectIter aIter = m_aElements[_nPos]; if(!aIter->second.is()) // we want to drop a object which isn't loaded yet so we must load it aIter->second = createObject(_sElementName); Reference< ::com::sun::star::lang::XUnoTunnel> xTunnel(aIter->second.get(),UNO_QUERY); sal_Bool bIsNew = sal_False; if(xTunnel.is()) { connectivity::sdbcx::ODescriptor* pTable = (connectivity::sdbcx::ODescriptor*)xTunnel->getSomething(connectivity::sdbcx::ODescriptor::getUnoTunnelImplementationId()); if(pTable) bIsNew = pTable->isNew(); } if (!bIsNew) { OAdabasConnection* pConnection = static_cast(m_rParent).getConnection(); Reference< XStatement > xStmt = pConnection->createStatement( ); ::rtl::OUString aName,aSchema; sal_Int32 nLen = _sElementName.indexOf('.'); aSchema = _sElementName.copy(0,nLen); aName = _sElementName.copy(nLen+1); ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aSchema + m_xMetaData->getIdentifierQuoteString( ); aSql = aSql + sDot; aSql = aSql + m_xMetaData->getIdentifierQuoteString( ) + aName + m_xMetaData->getIdentifierQuoteString( ); xStmt->execute(aSql); ::comphelper::disposeComponent(xStmt); } } // ----------------------------------------------------------------------------- void OViews::dropByNameImpl(const ::rtl::OUString& elementName) { m_bInDrop = sal_True; OCollection_TYPE::dropByName(elementName); m_bInDrop = sal_False; } // ----------------------------------------------------------------------------- void OViews::createView( const Reference< XPropertySet >& descriptor ) { ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); ::rtl::OUString aQuote = static_cast(m_rParent).getConnection()->getMetaData()->getIdentifierQuoteString( ); const ::rtl::OUString& sDot = OAdabasCatalog::getDot(); ::rtl::OUString sSchema,sCommand; descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCHEMANAME)) >>= sSchema; if(sSchema.getLength()) aSql += ::dbtools::quoteName(aQuote, sSchema) + sDot; else descriptor->setPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_SCHEMANAME),makeAny(sSchema = static_cast(m_rParent).getConnection()->getMetaData()->getUserName())); aSql += ::dbtools::quoteName(aQuote, getString(descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME)))) + ::rtl::OUString::createFromAscii(" AS "); descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_COMMAND)) >>= sCommand; aSql += sCommand; OAdabasConnection* pConnection = static_cast(m_rParent).getConnection(); Reference< XStatement > xStmt = pConnection->createStatement( ); xStmt->execute(aSql); ::comphelper::disposeComponent(xStmt); // insert the new view also in the tables collection OTables* pTables = static_cast(static_cast(m_rParent).getPrivateTables()); if(pTables) { ::rtl::OUString sName = sSchema; sName += sDot; sName += getString(descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_NAME))); pTables->appendNew(sName); } } // ----------------------------------------------------------------------------- void OViews::appendNew(const ::rtl::OUString& _rsNewTable) { insertElement(_rsNewTable,NULL); // notify our container listeners ContainerEvent aEvent(static_cast(this), makeAny(_rsNewTable), Any(), Any()); OInterfaceIteratorHelper aListenerLoop(m_aContainerListeners); while (aListenerLoop.hasMoreElements()) static_cast(aListenerLoop.next())->elementInserted(aEvent); } // ----------------------------------------------------------------------------- Reference< XNamed > OViews::cloneObject(const Reference< XPropertySet >& _xDescriptor) { Reference< XNamed > xName(_xDescriptor,UNO_QUERY); OSL_ENSURE(xName.is(),"Must be a XName interface here !"); return xName.is() ? createObject(xName->getName()) : Reference< XNamed >(); } // -----------------------------------------------------------------------------