/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*************************************************************************
*
* Effective License of whole file:
*
* This library is free software; you can redistribute it and/or
* modify it under the terms of the GNU Lesser General Public
* License version 2.1, as published by the Free Software Foundation.
*
* This library is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
* Lesser General Public License for more details.
*
* You should have received a copy of the GNU Lesser General Public
* License along with this library; if not, write to the Free Software
* Foundation, Inc., 59 Temple Place, Suite 330, Boston,
* MA 02111-1307 USA
*
* Parts "Copyright by Sun Microsystems, Inc" prior to August 2011:
*
* The Contents of this file are made available subject to the terms of
* the GNU Lesser General Public License Version 2.1
*
* Copyright: 2000 by Sun Microsystems, Inc.
*
* Contributor(s): Joerg Budischewski
*
* All parts contributed on or after August 2011:
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
************************************************************************/
#include <rtl/ref.hxx>
#include <rtl/ustrbuf.hxx>
#include <com/sun/star/lang/IndexOutOfBoundsException.hpp>
#include <com/sun/star/lang/WrappedTargetRuntimeException.hpp>
#include <com/sun/star/sdbc/SQLException.hpp>
#include <com/sun/star/sdbc/XRow.hpp>
#include <com/sun/star/sdbcx/Privilege.hpp>
#include <com/sun/star/sdbc/DataType.hpp>
#include <cppuhelper/exc_hlp.hxx>
#include <o3tl/safeint.hxx>
#include "pq_xtables.hxx"
#include "pq_xviews.hxx"
#include "pq_xtable.hxx"
#include "pq_statics.hxx"
#include "pq_tools.hxx"
using osl::MutexGuard;
using com::sun::star::beans::XPropertySet;
using com::sun::star::uno::Any;
using com::sun::star::uno::UNO_QUERY;
using com::sun::star::uno::Reference;
using com::sun::star::uno::Sequence;
using com::sun::star::container::XEnumerationAccess;
using com::sun::star::container::XEnumeration;
using com::sun::star::sdbc::XRow;
using com::sun::star::sdbc::XStatement;
using com::sun::star::sdbc::XResultSet;
using com::sun::star::sdbc::XDatabaseMetaData;
using com::sun::star::sdbcx::XColumnsSupplier;
using com::sun::star::sdbcx::XKeysSupplier;
namespace pq_sdbc_driver
{
Tables::Tables(
const ::rtl::Reference< comphelper::RefCountedMutex > & refMutex,
const css::uno::Reference< css::sdbc::XConnection > & origin,
ConnectionSettings *pSettings )
: Container( refMutex, origin, pSettings, getStatics().TABLE )
{}
Tables::~Tables()
{}
void Tables::refresh()
{
try
{
osl::MutexGuard guard( m_xMutex->GetMutex() );
Statics & st = getStatics();
Reference< XDatabaseMetaData > meta = m_origin->getMetaData();
Reference< XResultSet > rs =
meta->getTables( Any(), st.cPERCENT,st.cPERCENT, Sequence< OUString > () );
Reference< XRow > xRow( rs , UNO_QUERY );
String2IntMap map;
m_values.clear();
sal_Int32 tableIndex = 0;
while( rs->next() )
{
// if creating all these tables turns out to have too bad performance, we might
// instead offer a factory interface
rtl::Reference<Table> pTable =
new Table( m_xMutex, m_origin, m_pSettings );
Reference< css::beans::XPropertySet > prop = pTable;
OUString name = xRow->getString( TABLE_INDEX_NAME+1);
OUString schema = xRow->getString( TABLE_INDEX_SCHEMA+1);
pTable->setPropertyValue_NoBroadcast_public(
st.CATALOG_NAME , Any(xRow->getString( TABLE_INDEX_CATALOG+1) ) );
pTable->setPropertyValue_NoBroadcast_public( st.NAME , Any( name ) );
pTable->setPropertyValue_NoBroadcast_public( st.SCHEMA_NAME , Any( schema ));
pTable->setPropertyValue_NoBroadcast_public(
st.TYPE , Any( xRow->getString( TABLE_INDEX_TYPE+1) ) );
pTable->setPropertyValue_NoBroadcast_public(
st.DESCRIPTION , Any( xRow->getString( TABLE_INDEX_REMARKS+1) ) );
pTable->setPropertyValue_NoBroadcast_public(
st.PRIVILEGES ,
Any( sal_Int32( css::sdbcx::Privilege::SELECT |
css::sdbcx::Privilege::INSERT |
css::sdbcx::Privilege::UPDATE |
css::sdbcx::Privilege::DELETE |
css::sdbcx::Privilege::READ |
css::sdbcx::Privilege::CREATE |
css::sdbcx::Privilege::ALTER |
css::sdbcx::Privilege::REFERENCE |
css::sdbcx::Privilege::DROP ) ) );
{
m_values.push_back( Any( prop ) );
map[ schema + "." + name ] = tableIndex;
++tableIndex;
}
}
m_name2index.swap( map );
}
catch ( const css::sdbc::SQLException & e )
{
css::uno::Any anyEx = cppu::getCaughtException();
throw css::lang::WrappedTargetRuntimeException( e.Message,
e.Context, anyEx );
}
fire( RefreshedBroadcaster( *this ) );
}
static void appendColumnList(
OUStringBuffer &buf, const Reference< XColumnsSupplier > & columnSupplier, ConnectionSettings *settings )
{
if( !columnSupplier.is() )
return;
Reference< XEnumerationAccess > columns( columnSupplier->getColumns(),UNO_QUERY );
if( !columns.is() )
return;
Reference< XEnumeration > xEnum( columns->createEnumeration() );
bool first = true;
Statics & st = getStatics();
while( xEnum.is() && xEnum->hasMoreElements() )
{
if( first )
{
first = false;
}
else
{
buf.append( ", " );
}
Reference< XPropertySet > column( xEnum->nextElement(), UNO_QUERY );
OUString name = extractStringProperty( column, st.NAME );
OUString defaultValue = extractStringProperty( column, st.DEFAULT_VALUE );
bool isNullable = extractBoolProperty( column, st.IS_NULLABLE );
bool isAutoIncrement = extractBoolProperty( column, st.IS_AUTO_INCREMENT );
bufferQuoteIdentifier( buf, name, settings );
OUString type = sqltype2string( column );
if( isAutoIncrement )
{
sal_Int32 dataType = 0;
column->getPropertyValue( st.TYPE ) >>= dataType;
if( css::sdbc::DataType::INTEGER == dataType )
{
buf.append( " serial ");
isNullable = false;
}
else if( css::sdbc::DataType::BIGINT == dataType )
{
buf.append( " serial8 " );
isNullable = false;
}
else
buf.append( type );
}
else
{
buf.append( type );
}
if( !defaultValue.isEmpty() )
{
bufferQuoteConstant( buf, defaultValue, settings );
}
if( ! isNullable )
buf.append( " NOT NULL " );
}
}
static void appendKeyList(
OUStringBuffer & buf, const Reference< XKeysSupplier > &keySupplier, ConnectionSettings *settings )
{
if( !keySupplier.is() )
return;
Reference< XEnumerationAccess > keys( keySupplier->getKeys(), UNO_QUERY );
if(keys.is() )
{
Reference< XEnumeration > xEnum = keys->createEnumeration();
while( xEnum.is() && xEnum->hasMoreElements() )
{
buf.append( ", " );
Reference< XPropertySet > key( xEnum->nextElement(), UNO_QUERY );
bufferKey2TableConstraint( buf, key, settings );
}
}
}
void Tables::appendByDescriptor(
const css::uno::Reference< css::beans::XPropertySet >& descriptor )
{
osl::MutexGuard guard( m_xMutex->GetMutex() );
Reference< XStatement > stmt =
m_origin->createStatement();
Statics &st = getStatics();
OUString name,schema;
descriptor->getPropertyValue( st.SCHEMA_NAME ) >>= schema;
descriptor->getPropertyValue( st.NAME ) >>= name;
TransactionGuard transaction( stmt );
OUStringBuffer buf( 128 );
buf.append( "CREATE TABLE" );
bufferQuoteQualifiedIdentifier( buf, schema, name , m_pSettings);
buf.append( "(" );
// columns
Reference< XColumnsSupplier > supplier( descriptor, UNO_QUERY );
appendColumnList( buf, supplier, m_pSettings );
appendKeyList( buf, Reference< XKeysSupplier >( descriptor, UNO_QUERY ), m_pSettings );
buf.append( ") " );
// execute the creation !
transaction.executeUpdate( buf.makeStringAndClear() );
// description...
OUString description = extractStringProperty( descriptor, st.DESCRIPTION );
if( !description.isEmpty() )
{
buf.truncate();
buf.append( "COMMENT ON TABLE" );
bufferQuoteQualifiedIdentifier( buf, schema, name, m_pSettings );
buf.append( "IS " );
bufferQuoteConstant( buf, description, m_pSettings);
transaction.executeUpdate( buf.makeStringAndClear() );
}
// column descriptions
if( supplier.is() )
{
Reference< XEnumerationAccess > columns( supplier->getColumns(),UNO_QUERY );
if( columns.is() )
{
Reference< XEnumeration > xEnum( columns->createEnumeration() );
while( xEnum.is() && xEnum->hasMoreElements() )
{
Reference< XPropertySet > column( xEnum->nextElement(), UNO_QUERY );
description = extractStringProperty( column,st.DESCRIPTION );
if( !description.isEmpty() )
{
buf.truncate();
buf.append( "COMMENT ON COLUMN " );
bufferQuoteQualifiedIdentifier(
buf, schema, name, extractStringProperty( column, st.NAME ), m_pSettings );
buf.append( "IS " );
bufferQuoteConstant( buf, description, m_pSettings );
transaction.executeUpdate( buf.makeStringAndClear() );
}
}
}
}
transaction.commit();
disposeNoThrow( stmt );
// TODO: cheaper recalculate
// Container::append( concatQualified( schema, name ), descriptor ); // maintain the lists
refresh();
}
void Tables::dropByIndex( sal_Int32 index )
{
osl::MutexGuard guard( m_xMutex->GetMutex() );
if( index < 0 || o3tl::make_unsigned(index) >= m_values.size() )
{
throw css::lang::IndexOutOfBoundsException(
"TABLES: Index out of range (allowed 0 to " + OUString::number(m_values.size() -1)
+ ", got " + OUString::number( index ) + ")",
*this );
}
Reference< XPropertySet > set;
m_values[index] >>= set;
Statics &st = getStatics();
OUString name,schema;
set->getPropertyValue( st.SCHEMA_NAME ) >>= schema;
set->getPropertyValue( st.NAME ) >>= name;
if( extractStringProperty( set, st.TYPE ) == st.VIEW && m_pSettings->views.is() )
{
m_pSettings->pViewsImpl->dropByName( concatQualified( schema, name ) );
}
else
{
OUStringBuffer update( 128 );
update.append( "DROP " );
if( extractStringProperty( set, st.TYPE ) == st.VIEW )
update.append( "VIEW " );
else
update.append( "TABLE " );
bufferQuoteQualifiedIdentifier( update, schema, name, m_pSettings );
Reference< XStatement > stmt = m_origin->createStatement( );
DisposeGuard dispGuard( stmt );
stmt->executeUpdate( update.makeStringAndClear() );
}
Container::dropByIndex( index );
}
css::uno::Reference< css::beans::XPropertySet > Tables::createDataDescriptor()
{
return new TableDescriptor( m_xMutex, m_origin, m_pSettings );
}
Reference< css::container::XNameAccess > Tables::create(
const ::rtl::Reference< comphelper::RefCountedMutex > & refMutex,
const css::uno::Reference< css::sdbc::XConnection > & origin,
ConnectionSettings *pSettings,
rtl::Reference<Tables> *ppTables)
{
*ppTables = new Tables( refMutex, origin, pSettings );
(*ppTables)->refresh();
return *ppTables;
}
};
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
↑ V530 The return value of function 'truncate' is required to be utilized.
↑ V530 The return value of function 'truncate' is required to be utilized.