connectivity/source/drivers/postgresql/pq_xusers.cxx

   1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
   2 /*************************************************************************
   3  *
   4  *  Effective License of whole file:
   5  *
   6  *    This library is free software; you can redistribute it and/or
   7  *    modify it under the terms of the GNU Lesser General Public
   8  *    License version 2.1, as published by the Free Software Foundation.
   9  *
  10  *    This library is distributed in the hope that it will be useful,
  11  *    but WITHOUT ANY WARRANTY; without even the implied warranty of
  12  *    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
  13  *    Lesser General Public License for more details.
  14  *
  15  *    You should have received a copy of the GNU Lesser General Public
  16  *    License along with this library; if not, write to the Free Software
  17  *    Foundation, Inc., 59 Temple Place, Suite 330, Boston,
  18  *    MA  02111-1307  USA
  19  *
  20  *  Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
  21  *
  22  *    The Contents of this file are made available subject to the terms of
  23  *    the GNU Lesser General Public License Version 2.1
  24  *
  25  *    Copyright: 2000 by Sun Microsystems, Inc.
  26  *
  27  *    Contributor(s): Joerg Budischewski
  28  *
  29  *  All parts contributed on or after August 2011:
  30  *
  31  *    This Source Code Form is subject to the terms of the Mozilla Public
  32  *    License, v. 2.0. If a copy of the MPL was not distributed with this
  33  *    file, You can obtain one at http://mozilla.org/MPL/2.0/.
  34  *
  35  ************************************************************************/
  36
  37 #include <rtl/ref.hxx>
  38 #include <rtl/ustrbuf.hxx>
  39 #include <com/sun/star/lang/IndexOutOfBoundsException.hpp>
  40 #include <com/sun/star/lang/WrappedTargetRuntimeException.hpp>
  41 #include <com/sun/star/sdbc/SQLException.hpp>
  42 #include <com/sun/star/sdbc/XRow.hpp>
  43 #include <cppuhelper/exc_hlp.hxx>
  44 #include <o3tl/safeint.hxx>
  45
  46 #include "pq_xusers.hxx"
  47 #include "pq_xuser.hxx"
  48 #include "pq_statics.hxx"
  49 #include "pq_tools.hxx"
  50
  51 using osl::MutexGuard;
  52
  53 using com::sun::star::beans::XPropertySet;
  54
  55 using com::sun::star::uno::Any;
  56 using com::sun::star::uno::UNO_QUERY;
  57 using com::sun::star::uno::Reference;
  58
  59 using com::sun::star::container::NoSuchElementException;
  60
  61 using com::sun::star::sdbc::XRow;
  62 using com::sun::star::sdbc::XStatement;
  63 using com::sun::star::sdbc::XResultSet;
  64
  65 namespace pq_sdbc_driver
  66 {
  67 Users::Users(
  68         const ::rtl::Reference< comphelper::RefCountedMutex > & refMutex,
  69         const css::uno::Reference< css::sdbc::XConnection >  & origin,
  70         ConnectionSettings *pSettings )
  71     : Container( refMutex, origin, pSettings,  getStatics().USER )
  72 {}
  73
  74 Users::~Users()
  75 {}
  76
  77 void Users::refresh()
  78 {
  79     try
  80     {
  81         osl::MutexGuard guard( m_xMutex->GetMutex() );
  82         Statics & st = getStatics();
  83
  84         Reference< XStatement > stmt = m_origin->createStatement();
  85
  86         Reference< XResultSet > rs = stmt->executeQuery( u"SELECT usename FROM pg_shadow"_ustr );
  87
  88         Reference< XRow > xRow( rs , UNO_QUERY );
  89
  90         String2IntMap map;
  91
  92         m_values.clear();
  93         sal_Int32 tableIndex = 0;
  94         while( rs->next() )
  95         {
  96             rtl::Reference<User> pUser =
  97                 new User( m_xMutex, m_origin, m_pSettings );
  98             Reference< css::beans::XPropertySet > prop = pUser;
  99
 100             OUString name = xRow->getString( 1);
 101             pUser->setPropertyValue_NoBroadcast_public(
 102                 st.NAME , Any(xRow->getString( TABLE_INDEX_CATALOG+1) ) );
 103
 104             {
 105                 m_values.push_back( Any( prop ) );
 106                 map[ name ] = tableIndex;
 107                 ++tableIndex;
 108             }
 109         }
 110         m_name2index.swap( map );
 111     }
 112     catch ( css::sdbc::SQLException & e )
 113     {
 114         css::uno::Any anyEx = cppu::getCaughtException();
 115         throw css::lang::WrappedTargetRuntimeException( e.Message,
 116                         e.Context, anyEx );
 117     }
 118
 119     fire( RefreshedBroadcaster( *this ) );
 120 }
 121
 122
 123 void Users::appendByDescriptor(
 124     const css::uno::Reference< css::beans::XPropertySet >& descriptor )
 125 {
 126     osl::MutexGuard guard( m_xMutex->GetMutex() );
 127
 128     OUStringBuffer update( 128 );
 129     update.append( "CREATE USER " );
 130     bufferQuoteIdentifier( update, extractStringProperty( descriptor, getStatics().NAME ), m_pSettings );
 131     update.append( " PASSWORD " );
 132     bufferQuoteConstant( update, extractStringProperty( descriptor, getStatics().PASSWORD ), m_pSettings );
 133
 134     Reference< XStatement > stmt = m_origin->createStatement( );
 135     DisposeGuard disposeGuard( stmt );
 136     stmt->executeUpdate( update.makeStringAndClear() );
 137 }
 138
 139 void Users::dropByName( const OUString& elementName )
 140 {
 141     String2IntMap::const_iterator ii = m_name2index.find( elementName );
 142     if( ii == m_name2index.end() )
 143     {
 144         throw css::container::NoSuchElementException(
 145             "User " + elementName + " is unknown, so it can't be dropped",
 146             *this );
 147     }
 148     dropByIndex( ii->second );
 149 }
 150
 151 void Users::dropByIndex( sal_Int32 index )
 152 {
 153
 154     osl::MutexGuard guard( m_xMutex->GetMutex() );
 155     if( index < 0 ||  o3tl::make_unsigned(index) >= m_values.size() )
 156     {
 157         throw css::lang::IndexOutOfBoundsException(
 158             "USERS: Index out of range (allowed 0 to "
 159             + OUString::number( m_values.size() -1 )
 160             +  ", got " + OUString::number( index )
 161             + ")",
 162             *this );
 163     }
 164
 165     Reference< XPropertySet > set;
 166     m_values[index] >>= set;
 167     OUString name;
 168     set->getPropertyValue( getStatics().NAME ) >>= name;
 169
 170     OUStringBuffer update( 128 );
 171     update.append( "DROP USER " );
 172     bufferQuoteIdentifier( update, name, m_pSettings );
 173
 174     Reference< XStatement > stmt = m_origin->createStatement( );
 175     DisposeGuard disposeGuard( stmt );
 176     stmt->executeUpdate( update.makeStringAndClear() );
 177 }
 178
 179
 180 css::uno::Reference< css::beans::XPropertySet > Users::createDataDescriptor()
 181 {
 182     return new UserDescriptor( m_xMutex, m_origin, m_pSettings  );
 183 }
 184
 185 Reference< css::container::XNameAccess > Users::create(
 186     const ::rtl::Reference< comphelper::RefCountedMutex > & refMutex,
 187     const css::uno::Reference< css::sdbc::XConnection >  & origin,
 188     ConnectionSettings *pSettings )
 189 {
 190     rtl::Reference<Users> pUsers = new Users( refMutex, origin, pSettings );
 191     pUsers->refresh();
 192
 193     return pUsers;
 194 }
 195
 196 void Users::disposing()
 197 {
 198 }
 199
 200 };
 201
 202 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */