1 /************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance 9 * with the License. You may obtain a copy of the License at 10 * 11 * http://www.apache.org/licenses/LICENSE-2.0 12 * 13 * Unless required by applicable law or agreed to in writing, 14 * software distributed under the License is distributed on an 15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 16 * KIND, either express or implied. See the License for the 17 * specific language governing permissions and limitations 18 * under the License. 19 * 20 *************************************************************/ 21 22 23 #ifndef CONNECTIVITY_MYSQL_TABLES_HXX 24 #define CONNECTIVITY_MYSQL_TABLES_HXX 25 26 #include "connectivity/sdbcx/VCollection.hxx" 27 #include "connectivity/SQLStatementHelper.hxx" 28 #include <com/sun/star/sdbc/XDatabaseMetaData.hpp> 29 namespace connectivity 30 { 31 namespace mysql 32 { 33 class OTables : public sdbcx::OCollection, 34 public ::dbtools::ISQLStatementHelper 35 { 36 ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData > m_xMetaData; 37 38 protected: 39 virtual sdbcx::ObjectType createObject(const ::rtl::OUString& _rName); 40 virtual void impl_refresh() throw(::com::sun::star::uno::RuntimeException); 41 virtual ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet > createDescriptor(); 42 virtual sdbcx::ObjectType appendObject( const ::rtl::OUString& _rForName, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ); 43 virtual void dropObject(sal_Int32 _nPos,const ::rtl::OUString _sElementName); 44 45 void createTable( const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ); 46 virtual ::rtl::OUString getNameForObject(const sdbcx::ObjectType& _xObject); 47 public: OTables(const::com::sun::star::uno::Reference<::com::sun::star::sdbc::XDatabaseMetaData> & _rMetaData,::cppu::OWeakObject & _rParent,::osl::Mutex & _rMutex,const TStringVector & _rVector)48 OTables(const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XDatabaseMetaData >& _rMetaData,::cppu::OWeakObject& _rParent, ::osl::Mutex& _rMutex, 49 const TStringVector &_rVector) : sdbcx::OCollection(_rParent,sal_True,_rMutex,_rVector) 50 ,m_xMetaData(_rMetaData) 51 {} 52 53 // only the name is identical to ::cppu::OComponentHelper 54 virtual void SAL_CALL disposing(void); 55 56 // XDrop 57 void appendNew(const ::rtl::OUString& _rsNewTable); 58 // some helper functions 59 /** 60 returns a sql string which contains the column definition part for create or alter statements 61 */ 62 static ::rtl::OUString getColumnSqlType(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxColProp); 63 /** 64 returns the "not null" part or the default part of the table statement 65 */ 66 static ::rtl::OUString getColumnSqlNotNullDefault(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxColProp); 67 /** 68 returns the corresponding typename 69 can contain () which have to filled with values 70 */ 71 static ::rtl::OUString getTypeString(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _rxColProp); 72 73 /** convert the sql statement to fit MySQL notation 74 @param _sSql in/out 75 */ 76 static ::rtl::OUString adjustSQL(const ::rtl::OUString& _sSql); 77 78 // ISQLStatementHelper 79 virtual void addComment(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor,::rtl::OUStringBuffer& _rOut); 80 }; 81 } 82 } 83 #endif // CONNECTIVITY_MYSQL_TABLES_HXX 84 85