1*9b5730f6SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*9b5730f6SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*9b5730f6SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*9b5730f6SAndrew Rist  * distributed with this work for additional information
6*9b5730f6SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*9b5730f6SAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*9b5730f6SAndrew Rist  * "License"); you may not use this file except in compliance
9*9b5730f6SAndrew Rist  * with the License.  You may obtain a copy of the License at
10*9b5730f6SAndrew Rist  *
11*9b5730f6SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*9b5730f6SAndrew Rist  *
13*9b5730f6SAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*9b5730f6SAndrew Rist  * software distributed under the License is distributed on an
15*9b5730f6SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*9b5730f6SAndrew Rist  * KIND, either express or implied.  See the License for the
17*9b5730f6SAndrew Rist  * specific language governing permissions and limitations
18*9b5730f6SAndrew Rist  * under the License.
19*9b5730f6SAndrew Rist  *
20*9b5730f6SAndrew Rist  *************************************************************/
21*9b5730f6SAndrew Rist 
22*9b5730f6SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_connectivity.hxx"
26cdf0e10cSrcweir #include "mysql/YUsers.hxx"
27cdf0e10cSrcweir #include "mysql/YUser.hxx"
28cdf0e10cSrcweir #include "mysql/YTable.hxx"
29cdf0e10cSrcweir #include <com/sun/star/sdbc/XRow.hpp>
30cdf0e10cSrcweir #include <com/sun/star/sdbc/XResultSet.hpp>
31cdf0e10cSrcweir #include "connectivity/sdbcx/IRefreshable.hxx"
32cdf0e10cSrcweir #include <comphelper/types.hxx>
33cdf0e10cSrcweir #include "connectivity/dbexception.hxx"
34cdf0e10cSrcweir #include "connectivity/dbtools.hxx"
35cdf0e10cSrcweir #include "TConnection.hxx"
36cdf0e10cSrcweir 
37cdf0e10cSrcweir using namespace ::comphelper;
38cdf0e10cSrcweir using namespace connectivity;
39cdf0e10cSrcweir using namespace connectivity::mysql;
40cdf0e10cSrcweir using namespace ::com::sun::star::uno;
41cdf0e10cSrcweir using namespace ::com::sun::star::beans;
42cdf0e10cSrcweir //	using namespace ::com::sun::star::sdbcx;
43cdf0e10cSrcweir using namespace ::com::sun::star::sdbc;
44cdf0e10cSrcweir using namespace ::com::sun::star::container;
45cdf0e10cSrcweir using namespace ::com::sun::star::lang;
46cdf0e10cSrcweir typedef connectivity::sdbcx::OCollection OCollection_TYPE;
47cdf0e10cSrcweir 
OUsers(::cppu::OWeakObject & _rParent,::osl::Mutex & _rMutex,const TStringVector & _rVector,const::com::sun::star::uno::Reference<::com::sun::star::sdbc::XConnection> & _xConnection,connectivity::sdbcx::IRefreshableUsers * _pParent)48cdf0e10cSrcweir OUsers::OUsers( ::cppu::OWeakObject& _rParent,
49cdf0e10cSrcweir 				::osl::Mutex& _rMutex,
50cdf0e10cSrcweir 				const TStringVector &_rVector,
51cdf0e10cSrcweir 				const ::com::sun::star::uno::Reference< ::com::sun::star::sdbc::XConnection >& _xConnection,
52cdf0e10cSrcweir 				connectivity::sdbcx::IRefreshableUsers* _pParent)
53cdf0e10cSrcweir 	: sdbcx::OCollection(_rParent,sal_True,_rMutex,_rVector)
54cdf0e10cSrcweir 	,m_xConnection(_xConnection)
55cdf0e10cSrcweir 	,m_pParent(_pParent)
56cdf0e10cSrcweir {
57cdf0e10cSrcweir }
58cdf0e10cSrcweir // -----------------------------------------------------------------------------
59cdf0e10cSrcweir 
createObject(const::rtl::OUString & _rName)60cdf0e10cSrcweir sdbcx::ObjectType OUsers::createObject(const ::rtl::OUString& _rName)
61cdf0e10cSrcweir {
62cdf0e10cSrcweir 	return new OMySQLUser(m_xConnection,_rName);
63cdf0e10cSrcweir }
64cdf0e10cSrcweir // -------------------------------------------------------------------------
impl_refresh()65cdf0e10cSrcweir void OUsers::impl_refresh() throw(RuntimeException)
66cdf0e10cSrcweir {
67cdf0e10cSrcweir 	m_pParent->refreshUsers();
68cdf0e10cSrcweir }
69cdf0e10cSrcweir // -------------------------------------------------------------------------
createDescriptor()70cdf0e10cSrcweir Reference< XPropertySet > OUsers::createDescriptor()
71cdf0e10cSrcweir {
72cdf0e10cSrcweir 	OUserExtend* pNew = new OUserExtend(m_xConnection);
73cdf0e10cSrcweir 	return pNew;
74cdf0e10cSrcweir }
75cdf0e10cSrcweir // -------------------------------------------------------------------------
76cdf0e10cSrcweir // XAppend
appendObject(const::rtl::OUString & _rForName,const Reference<XPropertySet> & descriptor)77cdf0e10cSrcweir sdbcx::ObjectType OUsers::appendObject( const ::rtl::OUString& _rForName, const Reference< XPropertySet >& descriptor )
78cdf0e10cSrcweir {
79cdf0e10cSrcweir 	::rtl::OUString aSql	= ::rtl::OUString::createFromAscii("GRANT USAGE ON * TO ");
80cdf0e10cSrcweir 	::rtl::OUString aQuote	= m_xConnection->getMetaData()->getIdentifierQuoteString(  );
81cdf0e10cSrcweir 	::rtl::OUString sUserName( _rForName );
82cdf0e10cSrcweir 	aSql += ::dbtools::quoteName(aQuote,sUserName)
83cdf0e10cSrcweir 				+ ::rtl::OUString::createFromAscii(" @\"%\" ");
84cdf0e10cSrcweir 	::rtl::OUString sPassword;
85cdf0e10cSrcweir 	descriptor->getPropertyValue(OMetaConnection::getPropMap().getNameByIndex(PROPERTY_ID_PASSWORD)) >>= sPassword;
86cdf0e10cSrcweir 	if ( sPassword.getLength() )
87cdf0e10cSrcweir 	{
88cdf0e10cSrcweir 		aSql += ::rtl::OUString::createFromAscii(" IDENTIFIED BY '");
89cdf0e10cSrcweir 		aSql += sPassword;
90cdf0e10cSrcweir 		aSql += ::rtl::OUString::createFromAscii("'");
91cdf0e10cSrcweir 	}
92cdf0e10cSrcweir 
93cdf0e10cSrcweir 	Reference< XStatement > xStmt = m_xConnection->createStatement(  );
94cdf0e10cSrcweir 	if(xStmt.is())
95cdf0e10cSrcweir 		xStmt->execute(aSql);
96cdf0e10cSrcweir 	::comphelper::disposeComponent(xStmt);
97cdf0e10cSrcweir 
98cdf0e10cSrcweir     return createObject( _rForName );
99cdf0e10cSrcweir }
100cdf0e10cSrcweir // -------------------------------------------------------------------------
101cdf0e10cSrcweir // XDrop
dropObject(sal_Int32,const::rtl::OUString _sElementName)102cdf0e10cSrcweir void OUsers::dropObject(sal_Int32 /*_nPos*/,const ::rtl::OUString _sElementName)
103cdf0e10cSrcweir {
104cdf0e10cSrcweir 	::rtl::OUString aSql	= ::rtl::OUString::createFromAscii("REVOKE ALL ON * FROM ");
105cdf0e10cSrcweir 	::rtl::OUString aQuote	= m_xConnection->getMetaData()->getIdentifierQuoteString(  );
106cdf0e10cSrcweir 	aSql += ::dbtools::quoteName(aQuote,_sElementName);
107cdf0e10cSrcweir 
108cdf0e10cSrcweir 	Reference< XStatement > xStmt = m_xConnection->createStatement(  );
109cdf0e10cSrcweir 	if(xStmt.is())
110cdf0e10cSrcweir 		xStmt->execute(aSql);
111cdf0e10cSrcweir 	::comphelper::disposeComponent(xStmt);
112cdf0e10cSrcweir }
113cdf0e10cSrcweir 
114cdf0e10cSrcweir // -------------------------------------------------------------------------
115