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 
24*b1cdbd2cSJim Jagielski #ifndef CONNECTIVITY_HSQLDB_TABLE_HXX
25*b1cdbd2cSJim Jagielski #define CONNECTIVITY_HSQLDB_TABLE_HXX
26*b1cdbd2cSJim Jagielski 
27*b1cdbd2cSJim Jagielski #include "connectivity/TTableHelper.hxx"
28*b1cdbd2cSJim Jagielski #include <com/sun/star/sdbc/XDatabaseMetaData.hpp>
29*b1cdbd2cSJim Jagielski #include <comphelper/IdPropArrayHelper.hxx>
30*b1cdbd2cSJim Jagielski 
31*b1cdbd2cSJim Jagielski namespace connectivity
32*b1cdbd2cSJim Jagielski {
33*b1cdbd2cSJim Jagielski 	namespace hsqldb
34*b1cdbd2cSJim Jagielski 	{
35*b1cdbd2cSJim Jagielski 
36*b1cdbd2cSJim Jagielski         ::rtl::OUString getTypeString(const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& xColProp);
37*b1cdbd2cSJim Jagielski 
38*b1cdbd2cSJim Jagielski 		class OHSQLTable;
39*b1cdbd2cSJim Jagielski 		typedef ::comphelper::OIdPropertyArrayUsageHelper< OHSQLTable >	OHSQLTable_PROP;
40*b1cdbd2cSJim Jagielski 		class OHSQLTable :	public OTableHelper
41*b1cdbd2cSJim Jagielski 							,public OHSQLTable_PROP
42*b1cdbd2cSJim Jagielski 		{
43*b1cdbd2cSJim Jagielski 			sal_Int32 m_nPrivileges; // we have to set our privileges by our own
44*b1cdbd2cSJim Jagielski 
45*b1cdbd2cSJim Jagielski 			/** executes the statmenmt.
46*b1cdbd2cSJim Jagielski 				@param	_rStatement
47*b1cdbd2cSJim Jagielski 					The statement to execute.
48*b1cdbd2cSJim Jagielski 				*/
49*b1cdbd2cSJim Jagielski 			void executeStatement(const ::rtl::OUString& _rStatement );
50*b1cdbd2cSJim Jagielski 		protected:
51*b1cdbd2cSJim Jagielski 
52*b1cdbd2cSJim Jagielski 			/** creates the column collection for the table
53*b1cdbd2cSJim Jagielski 				@param	_rNames
54*b1cdbd2cSJim Jagielski 					The column names.
55*b1cdbd2cSJim Jagielski 			*/
56*b1cdbd2cSJim Jagielski 			virtual sdbcx::OCollection* createColumns(const TStringVector& _rNames);
57*b1cdbd2cSJim Jagielski 
58*b1cdbd2cSJim Jagielski 			/** creates the key collection for the table
59*b1cdbd2cSJim Jagielski 				@param	_rNames
60*b1cdbd2cSJim Jagielski 					The key names.
61*b1cdbd2cSJim Jagielski 			*/
62*b1cdbd2cSJim Jagielski 			virtual sdbcx::OCollection* createKeys(const TStringVector& _rNames);
63*b1cdbd2cSJim Jagielski 
64*b1cdbd2cSJim Jagielski 			/** creates the index collection for the table
65*b1cdbd2cSJim Jagielski 				@param	_rNames
66*b1cdbd2cSJim Jagielski 					The index names.
67*b1cdbd2cSJim Jagielski 			*/
68*b1cdbd2cSJim Jagielski 			virtual sdbcx::OCollection* createIndexes(const TStringVector& _rNames);
69*b1cdbd2cSJim Jagielski 
70*b1cdbd2cSJim Jagielski 			/** used to implement the creation of the array helper which is shared amongst all instances of the class.
71*b1cdbd2cSJim Jagielski 				This method needs to be implemented in derived classes.
72*b1cdbd2cSJim Jagielski 				<BR>
73*b1cdbd2cSJim Jagielski 				The method gets called with s_aMutex acquired.
74*b1cdbd2cSJim Jagielski 				<BR>
75*b1cdbd2cSJim Jagielski 				as long as IPropertyArrayHelper has no virtual destructor, the implementation of ~OPropertyArrayUsageHelper
76*b1cdbd2cSJim Jagielski 				assumes that you created an ::cppu::OPropertyArrayHelper when deleting s_pProps.
77*b1cdbd2cSJim Jagielski 				@return							an pointer to the newly created array helper. Must not be NULL.
78*b1cdbd2cSJim Jagielski 			*/
79*b1cdbd2cSJim Jagielski 			virtual ::cppu::IPropertyArrayHelper* createArrayHelper(sal_Int32 nId) const;
80*b1cdbd2cSJim Jagielski 			virtual ::cppu::IPropertyArrayHelper & SAL_CALL getInfoHelper();
81*b1cdbd2cSJim Jagielski 
82*b1cdbd2cSJim Jagielski 		public:
83*b1cdbd2cSJim Jagielski 			OHSQLTable(	sdbcx::OCollection* _pTables,
84*b1cdbd2cSJim Jagielski 							const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection);
85*b1cdbd2cSJim Jagielski 			OHSQLTable(	sdbcx::OCollection* _pTables,
86*b1cdbd2cSJim Jagielski 							const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection,
87*b1cdbd2cSJim Jagielski 							const ::rtl::OUString& _Name,
88*b1cdbd2cSJim Jagielski 							const ::rtl::OUString& _Type,
89*b1cdbd2cSJim Jagielski 							const ::rtl::OUString& _Description = ::rtl::OUString(),
90*b1cdbd2cSJim Jagielski 							const ::rtl::OUString& _SchemaName = ::rtl::OUString(),
91*b1cdbd2cSJim Jagielski 							const ::rtl::OUString& _CatalogName = ::rtl::OUString(),
92*b1cdbd2cSJim Jagielski 							sal_Int32 _nPrivileges = 0
93*b1cdbd2cSJim Jagielski 				);
94*b1cdbd2cSJim Jagielski 
95*b1cdbd2cSJim Jagielski 			// ODescriptor
96*b1cdbd2cSJim Jagielski 			virtual void construct();
97*b1cdbd2cSJim Jagielski 			// com::sun::star::lang::XUnoTunnel
98*b1cdbd2cSJim Jagielski             virtual sal_Int64 SAL_CALL getSomething( const ::com::sun::star::uno::Sequence< sal_Int8 >& aIdentifier ) throw(::com::sun::star::uno::RuntimeException);
99*b1cdbd2cSJim Jagielski             static ::com::sun::star::uno::Sequence< sal_Int8 > getUnoTunnelImplementationId();
100*b1cdbd2cSJim Jagielski 
101*b1cdbd2cSJim Jagielski 			virtual ::com::sun::star::uno::Any SAL_CALL queryInterface( const ::com::sun::star::uno::Type & rType ) throw(::com::sun::star::uno::RuntimeException);
102*b1cdbd2cSJim Jagielski 			//XTypeProvider
103*b1cdbd2cSJim Jagielski 			virtual ::com::sun::star::uno::Sequence< ::com::sun::star::uno::Type > SAL_CALL getTypes(  ) throw(::com::sun::star::uno::RuntimeException);
104*b1cdbd2cSJim Jagielski 			// XAlterTable
105*b1cdbd2cSJim Jagielski             virtual void SAL_CALL alterColumnByName( const ::rtl::OUString& colName, const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& descriptor ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::NoSuchElementException, ::com::sun::star::uno::RuntimeException);
106*b1cdbd2cSJim Jagielski 
107*b1cdbd2cSJim Jagielski             // XRename
108*b1cdbd2cSJim Jagielski             virtual void SAL_CALL rename( const ::rtl::OUString& newName ) throw(::com::sun::star::sdbc::SQLException, ::com::sun::star::container::ElementExistException, ::com::sun::star::uno::RuntimeException);
109*b1cdbd2cSJim Jagielski 
110*b1cdbd2cSJim Jagielski 			/**
111*b1cdbd2cSJim Jagielski 				returns the ALTER TABLE XXX COLUMN statement
112*b1cdbd2cSJim Jagielski 			*/
113*b1cdbd2cSJim Jagielski 			::rtl::OUString getAlterTableColumnPart();
114*b1cdbd2cSJim Jagielski 
115*b1cdbd2cSJim Jagielski 			// some methods to alter table structures
116*b1cdbd2cSJim Jagielski 			void alterColumnType(sal_Int32 nNewType,const ::rtl::OUString& _rColName,const ::com::sun::star::uno::Reference< ::com::sun::star::beans::XPropertySet >& _xDescriptor);
117*b1cdbd2cSJim Jagielski 			void alterDefaultValue(const ::rtl::OUString& _sNewDefault,const ::rtl::OUString& _rColName);
118*b1cdbd2cSJim Jagielski 			void dropDefaultValue(const ::rtl::OUString& _sNewDefault);
119*b1cdbd2cSJim Jagielski 
120*b1cdbd2cSJim Jagielski 		};
121*b1cdbd2cSJim Jagielski 	}
122*b1cdbd2cSJim Jagielski }
123*b1cdbd2cSJim Jagielski #endif // CONNECTIVITY_HSQLDB_TABLE_HXX
124*b1cdbd2cSJim Jagielski 
125