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