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