/************************************************************************* * * $RCSfile: YViews.cxx,v $ * * $Revision: 1.5 $ * * last change: $Author: vg $ $Date: 2005-03-10 15:32:08 $ * * 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_MYSQL_VIEWS_HXX_ #include "mysql/YViews.hxx" #endif #ifndef CONNECTIVITY_MYSQL_TABLES_HXX #include "mysql/YTables.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_MYSQL_CATALOG_HXX #include "mysql/YCatalog.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 #ifndef CONNECTIVITY_CONNECTION_HXX #include "TConnection.hxx" #endif using namespace ::comphelper; using namespace ::cppu; using namespace connectivity; using namespace connectivity::mysql; 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; sdbcx::ObjectType OViews::createObject(const ::rtl::OUString& _rName) { ::rtl::OUString sCatalog,sSchema,sTable; ::dbtools::qualifiedNameComponents(m_xMetaData, _rName, sCatalog, sSchema, sTable, ::dbtools::eInDataManipulation); return new ::connectivity::sdbcx::OView(isCaseSensitive(), sTable, m_xMetaData, 0, ::rtl::OUString(), sSchema, sCatalog ); } // ------------------------------------------------------------------------- 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(static_cast(this)); createView(descriptor); } // ------------------------------------------------------------------------- // XDrop void OViews::dropObject(sal_Int32 _nPos,const ::rtl::OUString _sElementName) { if ( m_bInDrop ) return; Reference< ::com::sun::star::lang::XUnoTunnel> xTunnel(getObject(_nPos),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) { ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("DROP VIEW"); Reference xProp(xTunnel,UNO_QUERY); aSql += ::dbtools::composeTableName(m_xMetaData,xProp,sal_True,::dbtools::eInTableDefinitions); Reference xConnection = static_cast(m_rParent).getConnection(); Reference< XStatement > xStmt = xConnection->createStatement( ); 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 ) { Reference xConnection = static_cast(m_rParent).getConnection(); ::rtl::OUString aSql = ::rtl::OUString::createFromAscii("CREATE VIEW "); ::rtl::OUString aQuote = xConnection->getMetaData()->getIdentifierQuoteString( ); ::rtl::OUString sSchema,sCommand; aSql += ::dbtools::composeTableName(m_xMetaData,descriptor,sal_True,::dbtools::eInTableDefinitions); aSql += ::rtl::OUString::createFromAscii(" AS "); descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_COMMAND)) >>= sCommand; aSql += sCommand; Reference< XStatement > xStmt = xConnection->createStatement( ); if ( xStmt.is() ) { 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 = ::dbtools::composeTableName(m_xMetaData,descriptor,sal_False,::dbtools::eInDataManipulation); 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); } // -----------------------------------------------------------------------------