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 10cdf0e10cSrcweir * 11*9b5730f6SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0 12cdf0e10cSrcweir * 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. 19cdf0e10cSrcweir * 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 "TPrivilegesResultSet.hxx" 27cdf0e10cSrcweir 28cdf0e10cSrcweir using namespace connectivity; 29cdf0e10cSrcweir //------------------------------------------------------------------------------ 30cdf0e10cSrcweir using namespace ::com::sun::star::beans; 31cdf0e10cSrcweir using namespace ::com::sun::star::uno; 32cdf0e10cSrcweir using namespace ::com::sun::star::sdbcx; 33cdf0e10cSrcweir using namespace ::com::sun::star::sdbc; 34cdf0e10cSrcweir using namespace ::com::sun::star::container; 35cdf0e10cSrcweir using namespace ::com::sun::star::lang; 36cdf0e10cSrcweir //------------------------------------------------------------------------------ 37cdf0e10cSrcweir OResultSetPrivileges::OResultSetPrivileges( const Reference< XDatabaseMetaData>& _rxMeta 38cdf0e10cSrcweir , const Any& catalog 39cdf0e10cSrcweir , const ::rtl::OUString& schemaPattern 40cdf0e10cSrcweir , const ::rtl::OUString& tableNamePattern) 41cdf0e10cSrcweir : ODatabaseMetaDataResultSet(eTablePrivileges) 42cdf0e10cSrcweir , m_bResetValues(sal_True) 43cdf0e10cSrcweir { 44cdf0e10cSrcweir osl_incrementInterlockedCount( &m_refCount ); 45cdf0e10cSrcweir { 46cdf0e10cSrcweir ::rtl::OUString sUserWorkingFor; 47cdf0e10cSrcweir static Sequence< ::rtl::OUString > sTableTypes; 48cdf0e10cSrcweir if ( sTableTypes.getLength() == 0 ) 49cdf0e10cSrcweir { 50cdf0e10cSrcweir // we want all catalogues, all schemas, all tables 51cdf0e10cSrcweir sTableTypes.realloc(3); 52cdf0e10cSrcweir sTableTypes[0] = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("VIEW")); 53cdf0e10cSrcweir sTableTypes[1] = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("TABLE")); 54cdf0e10cSrcweir sTableTypes[2] = ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("%")); // just to be sure to include anything else .... 55cdf0e10cSrcweir } 56cdf0e10cSrcweir try 57cdf0e10cSrcweir { 58cdf0e10cSrcweir m_xTables = _rxMeta->getTables(catalog,schemaPattern,tableNamePattern,sTableTypes); 59cdf0e10cSrcweir m_xRow = Reference< XRow>(m_xTables,UNO_QUERY); 60cdf0e10cSrcweir 61cdf0e10cSrcweir sUserWorkingFor = _rxMeta->getUserName(); 62cdf0e10cSrcweir } 63cdf0e10cSrcweir catch(Exception&) 64cdf0e10cSrcweir { 65cdf0e10cSrcweir } 66cdf0e10cSrcweir 67cdf0e10cSrcweir ODatabaseMetaDataResultSet::ORows aRows; 68cdf0e10cSrcweir static ODatabaseMetaDataResultSet::ORow aRow(8); 69cdf0e10cSrcweir aRow[5] = new ORowSetValueDecorator(sUserWorkingFor); 70cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getSelectValue(); 71cdf0e10cSrcweir aRow[7] = new ORowSetValueDecorator(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("YES"))); 72cdf0e10cSrcweir aRows.push_back(aRow); 73cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getInsertValue(); 74cdf0e10cSrcweir aRows.push_back(aRow); 75cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getDeleteValue(); 76cdf0e10cSrcweir aRows.push_back(aRow); 77cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getUpdateValue(); 78cdf0e10cSrcweir aRows.push_back(aRow); 79cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getCreateValue(); 80cdf0e10cSrcweir aRows.push_back(aRow); 81cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getReadValue(); 82cdf0e10cSrcweir aRows.push_back(aRow); 83cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getAlterValue(); 84cdf0e10cSrcweir aRows.push_back(aRow); 85cdf0e10cSrcweir aRow[6] = ODatabaseMetaDataResultSet::getDropValue(); 86cdf0e10cSrcweir aRows.push_back(aRow); 87cdf0e10cSrcweir aRow[6] = new ORowSetValueDecorator(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("REFERENCE"))); 88cdf0e10cSrcweir aRows.push_back(aRow); 89cdf0e10cSrcweir 90cdf0e10cSrcweir setRows(aRows); 91cdf0e10cSrcweir } 92cdf0e10cSrcweir osl_decrementInterlockedCount( &m_refCount ); 93cdf0e10cSrcweir } 94cdf0e10cSrcweir //------------------------------------------------------------------------------ 95cdf0e10cSrcweir const ORowSetValue& OResultSetPrivileges::getValue(sal_Int32 columnIndex) 96cdf0e10cSrcweir { 97cdf0e10cSrcweir switch(columnIndex) 98cdf0e10cSrcweir { 99cdf0e10cSrcweir case 1: 100cdf0e10cSrcweir case 2: 101cdf0e10cSrcweir case 3: 102cdf0e10cSrcweir if ( m_xRow.is() && m_bResetValues ) 103cdf0e10cSrcweir { 104cdf0e10cSrcweir (*m_aRowsIter)[1] = new ORowSetValueDecorator(m_xRow->getString(1)); 105cdf0e10cSrcweir if ( m_xRow->wasNull() ) 106cdf0e10cSrcweir (*m_aRowsIter)[1]->setNull(); 107cdf0e10cSrcweir (*m_aRowsIter)[2] = new ORowSetValueDecorator(m_xRow->getString(2)); 108cdf0e10cSrcweir if ( m_xRow->wasNull() ) 109cdf0e10cSrcweir (*m_aRowsIter)[2]->setNull(); 110cdf0e10cSrcweir (*m_aRowsIter)[3] = new ORowSetValueDecorator(m_xRow->getString(3)); 111cdf0e10cSrcweir if ( m_xRow->wasNull() ) 112cdf0e10cSrcweir (*m_aRowsIter)[3]->setNull(); 113cdf0e10cSrcweir 114cdf0e10cSrcweir m_bResetValues = sal_False; 115cdf0e10cSrcweir } 116cdf0e10cSrcweir } 117cdf0e10cSrcweir return ODatabaseMetaDataResultSet::getValue(columnIndex); 118cdf0e10cSrcweir } 119cdf0e10cSrcweir // ----------------------------------------------------------------------------- 120cdf0e10cSrcweir void SAL_CALL OResultSetPrivileges::disposing(void) 121cdf0e10cSrcweir { 122cdf0e10cSrcweir ODatabaseMetaDataResultSet::disposing(); 123cdf0e10cSrcweir m_xTables.clear(); 124cdf0e10cSrcweir m_xRow.clear(); 125cdf0e10cSrcweir } 126cdf0e10cSrcweir // ----------------------------------------------------------------------------- 127cdf0e10cSrcweir sal_Bool SAL_CALL OResultSetPrivileges::next( ) throw(SQLException, RuntimeException) 128cdf0e10cSrcweir { 129cdf0e10cSrcweir ::osl::MutexGuard aGuard( m_aMutex ); 130cdf0e10cSrcweir checkDisposed(ODatabaseMetaDataResultSet_BASE::rBHelper.bDisposed ); 131cdf0e10cSrcweir 132cdf0e10cSrcweir sal_Bool bReturn = sal_False; 133cdf0e10cSrcweir if ( m_xTables.is() ) 134cdf0e10cSrcweir { 135cdf0e10cSrcweir if ( m_bBOF ) 136cdf0e10cSrcweir { 137cdf0e10cSrcweir m_bResetValues = sal_True; 138cdf0e10cSrcweir if ( !m_xTables->next() ) 139cdf0e10cSrcweir return sal_False; 140cdf0e10cSrcweir } 141cdf0e10cSrcweir 142cdf0e10cSrcweir bReturn = ODatabaseMetaDataResultSet::next(); 143cdf0e10cSrcweir if ( !bReturn ) 144cdf0e10cSrcweir { 145cdf0e10cSrcweir m_bBOF = sal_False; 146cdf0e10cSrcweir m_bResetValues = bReturn = m_xTables->next(); 147cdf0e10cSrcweir } 148cdf0e10cSrcweir } 149cdf0e10cSrcweir return bReturn; 150cdf0e10cSrcweir } 151cdf0e10cSrcweir // ----------------------------------------------------------------------------- 152