/*************************************************************************
 *
 *  OpenOffice.org - a multi-platform office productivity suite
 *
 *  $RCSfile: resultsetmetadata.hxx,v $
 *
 *  $Revision: 1.5 $
 *
 *  last change: $Author: rt $ $Date: 2005/09/09 16:31:10 $
 *
 *  The Contents of this file are made available subject to
 *  the terms of GNU Lesser General Public License Version 2.1.
 *
 *
 *    GNU Lesser General Public License Version 2.1
 *    =============================================
 *    Copyright 2005 by Sun Microsystems, Inc.
 *    901 San Antonio Road, Palo Alto, CA 94303, USA
 *
 *    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
 *
 ************************************************************************/

#ifndef _UCBHELPER_RESULTSETMETADATA_HXX
#define _UCBHELPER_RESULTSETMETADATA_HXX

#include <vector>

#ifndef _COM_SUN_STAR_UNO_REFERENCE_HXX_
#include <com/sun/star/uno/Reference.hxx>
#endif
#ifndef _COM_SUN_STAR_UNO_SEQUENCE_HXX_
#include <com/sun/star/uno/Sequence.hxx>
#endif

#ifndef _COM_SUN_STAR_LANG_XTYPEPROVIDER_HPP_
#include <com/sun/star/lang/XTypeProvider.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBC_COLUMNVALUE_HPP_
#include <com/sun/star/sdbc/ColumnValue.hpp>
#endif
#ifndef _COM_SUN_STAR_SDBC_XRESULTSETMETADATA_HPP_
#include <com/sun/star/sdbc/XResultSetMetaData.hpp>
#endif

#ifndef _CPPUHELPER_WEAK_HXX_
#include <cppuhelper/weak.hxx>
#endif

#ifndef _UCBHELPER_MACROS_HXX
#include <ucbhelper/macros.hxx>
#endif
#ifndef INCLUDED_UCBHELPERDLLAPI_H
#include "ucbhelper/ucbhelperdllapi.h"
#endif

namespace com { namespace sun { namespace star {
	namespace lang	{ class XMultiServiceFactory; }
	namespace beans { struct Property; }
} } }

namespace ucb
{

//=========================================================================

/**
 * This is a structure that holds additional meta data for one column
 * of a resultset. The default values set in the constructor should be a
 * good guess for many UCB use cases.
 */
struct ResultSetColumnData
{
	/** @see ResultSetMetaData::isAutoIncrement */
	sal_Bool        isAutoIncrement;

	/** @see ResultSetMetaData::isCaseSensitive */
	sal_Bool        isCaseSensitive;

	/** @see ResultSetMetaData::isSearchable */
	sal_Bool        isSearchable;

	/** @see ResultSetMetaData::isCurrency */
	sal_Bool        isCurrency;

	/** @see ResultSetMetaData::isNullable */
	sal_Int32       isNullable;

	/** @see ResultSetMetaData::isSigned */
	sal_Bool        isSigned;

	/** @see ResultSetMetaData::getColumnDisplaySize */
	sal_Int32       columnDisplaySize;

	/** @see ResultSetMetaData::getColumnLabel */
	::rtl::OUString columnLabel;

	/** @see ResultSetMetaData::getSchemaName */
	::rtl::OUString schemaName;

	/** @see ResultSetMetaData::getPrecision */
	sal_Int32 		precision;

	/** @see ResultSetMetaData::getScale */
	sal_Int32 		scale;

	/** @see ResultSetMetaData::getTableName */
	::rtl::OUString tableName;

	/** @see ResultSetMetaData::getCatalogName */
	::rtl::OUString catalogName;

	/** @see ResultSetMetaData::getColumnTypeName */
	::rtl::OUString columnTypeName;

	/** @see ResultSetMetaData::isReadOnly */
	sal_Bool 		isReadOnly;

	/** @see ResultSetMetaData::isWritable */
	sal_Bool 		isWritable;

	/** @see ResultSetMetaData::isDefinitelyWritable */
	sal_Bool 		isDefinitelyWritable;

	/** @see ResultSetMetaData::getColumnServiceName */
	::rtl::OUString columnServiceName;

	inline ResultSetColumnData();
};

// Note: Never change the initial values! Implementations using this struct
//       may havily depend on the behaviour of the default constructor.

ResultSetColumnData::ResultSetColumnData()
: isAutoIncrement( sal_False ),
  isCaseSensitive( sal_True ),
  isSearchable( sal_False ),
  isCurrency( sal_False ),
  isNullable( ::com::sun::star::sdbc::ColumnValue::NULLABLE ),
  isSigned( sal_False ),
  columnDisplaySize( 16 ),
  precision( -1 ),
  scale( 0 ),
  isReadOnly( sal_True ),
  isWritable( sal_False ),
  isDefinitelyWritable( sal_False )
{
}

//=========================================================================

struct ResultSetMetaData_Impl;

/**
 * This is an implementation of the interface XResultSetMetaData. It can be
 * used to implement the interface
 * com::sun::star::sdbc::XResultSetMetaDataSupplier, which is required for
 * implementations of service com.sun.star.ucb.ContentResultSet.
 */
class UCBHELPER_DLLPUBLIC ResultSetMetaData :
				public ::cppu::OWeakObject,
				public ::com::sun::star::lang::XTypeProvider,
				public ::com::sun::star::sdbc::XResultSetMetaData
{
private:
	ResultSetMetaData_Impl* m_pImpl;

protected:
	::com::sun::star::uno::Reference<
		::com::sun::star::lang::XMultiServiceFactory > m_xSMgr;
	::com::sun::star::uno::Sequence<
		::com::sun::star::beans::Property > 		   m_aProps;
	sal_Bool m_bReadOnly;

public:

	/**
	  *	Constructor.
	  *
	  *	@param rxSMgr is a Servive Manager.
	  *	@param rProps is a sequence of properties (partially) describing the
	  *        columns of a resultset.
	  * @param bReadOnly is used to specify whether the whole(!) resultset
	  *        is read-only.
	  */
	ResultSetMetaData(
			const ::com::sun::star::uno::Reference<
				::com::sun::star::lang::XMultiServiceFactory >& rxSMgr,
			const ::com::sun::star::uno::Sequence<
				::com::sun::star::beans::Property >& rProps,
			sal_Bool bReadOnly = sal_True );

	/**
	  *	Constructor.
	  *
	  *	@param rxSMgr is a Servive Manager.
	  *	@param rProps is a sequence of properties (partially) describing the
	  *        columns of a resultset.
	  *	@param rColumnData contains additional meta data for the columns of
	  *	       a resultset, which override the default values returned by the
	  *		   appropriate methods of this class. The length of rColumnData
	  *		   must be the same as length of rProps.
	  *		   rColumnData[ 0 ] corresponds to data in rProps[ 0 ],
	  *		   rColumnData[ 1 ] corresponds to data in rProps[ 1 ], ...
	  */
	ResultSetMetaData(
			const ::com::sun::star::uno::Reference<
				::com::sun::star::lang::XMultiServiceFactory >& rxSMgr,
			const ::com::sun::star::uno::Sequence<
				::com::sun::star::beans::Property >& rProps,
			const std::vector< ResultSetColumnData >& rColumnData );

	/**
	  *	Destructor.
	  */
	virtual ~ResultSetMetaData();

	// XInterface
	XINTERFACE_DECL()

	// XTypeProvider
	XTYPEPROVIDER_DECL()

	// XResultSetMetaData

	/**
	  * Returns the number of columns of the resultset.
	  *
	  *	@return the length of the property sequence.
	  */
    virtual sal_Int32 SAL_CALL
	getColumnCount()
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Checks whether column is automatically numbered, which makes it
	  *	read-only.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if column is automatically numbered.
	  */
    virtual sal_Bool SAL_CALL
	isAutoIncrement( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Checks whether column is case sensitive.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if column is case sensitive.
	  */
    virtual sal_Bool SAL_CALL
	isCaseSensitive( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  * Checks whether the value stored in column can be used in a
	  *	WHERE clause.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if the column is searchable.
	  */
    virtual sal_Bool SAL_CALL
	isSearchable( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Checks whether column is a cash value.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if the column is a cash value.
	  */
    virtual sal_Bool SAL_CALL
	isCurrency( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Checks whether a NULL can be stored in column.
	  *
	  *	@see com::sun::star::sdbc::ColumnValue
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return ::com::sun::star::sdbc::ColumnValue::NULLABLE, if a NULL
	  *         can be stored in the column.
	  */
    virtual sal_Int32 SAL_CALL
	isNullable( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Checks whether the value stored in column is a signed number.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if the value stored in column is a signed number.
	  */
    virtual sal_Bool SAL_CALL
	isSigned( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the normal maximum width in characters for column.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the normal maximum width in characters for column.
	  */
    virtual sal_Int32 SAL_CALL
	getColumnDisplaySize( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the suggested column title for column, to be used in print-
	  *	outs and displays.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the column label.
	  */
    virtual ::rtl::OUString SAL_CALL
	getColumnLabel( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the name of column.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the name of the property that corresponds to column.
	  */
    virtual ::rtl::OUString SAL_CALL
	getColumnName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the schema name for the table from which column of this
	  *	result set was derived.
	  *	Because this feature is not widely supported, the return value
	  *	for many DBMSs will be an empty string.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the schema name of column or an empty string.
	  */
    virtual ::rtl::OUString SAL_CALL
	getSchemaName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	For number types, getprecision gets the number of decimal digits
	  *	in column.
	  *	For character types, it gets the maximum length in characters for
	  *	column.
	  *	For binary types, it gets the maximum length in bytes for column.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the precision for the column.
	  */
    virtual sal_Int32 SAL_CALL
	getPrecision( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the number of digits to the right of the decimal point for
	  *	values in column.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the scale of the column.
	  */
    virtual sal_Int32 SAL_CALL
	getScale( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the name of the table from which column of this result set
	  *	was derived or "" if there is none (for example, for a join).
	  *	Because this feature is not widely supported, the return value
	  *	for many DBMSs will be an empty string.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the table name for column or an empty string.
	  */
    virtual ::rtl::OUString SAL_CALL
	getTableName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
    virtual ::rtl::OUString SAL_CALL
	/**
	  *	Gets the catalog name for the table from which column of this
	  *	result set was derived.
	  *	Because this feature is not widely supported, the return value
	  *	for many DBMSs will be an empty string.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the catalog name for column or an empty string.
	  */
	getCatalogName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the JDBC type for the value stored in column. ... The STRUCT
	  *	and DISTINCT type codes are always returned for structured and
	  *	distinct types, regardless of whether the value will be mapped
	  *	according to the standard mapping or be a custom mapping.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the type of the property that corresponds to column - mapped
	  *         from UNO-Type to SQL-Type.
	  */
    virtual sal_Int32 SAL_CALL
	getColumnType( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  *	Gets the type name used by this particular data source for the
	  *	values stored in column. If the type code for the type of value
	  *	stored in column is STRUCT, DISTINCT or JAVA_OBJECT, this method
	  *	returns a fully-qualified SQL type name.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the column type name.
	  */
    virtual ::rtl::OUString SAL_CALL
	getColumnTypeName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  * Indicates whether a column is definitely not writable.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if the column is definetely not writable.
	  */
    virtual sal_Bool SAL_CALL
	isReadOnly( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  * Indicates whether it is possible for a write on the column to succeed.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if it is possible for a write to succeed.
	  */
    virtual sal_Bool SAL_CALL
	isWritable( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  * Indicates whether a write on the column will definitely succeed.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return true, if a write on the column will definetely succeed.
	  */
    virtual sal_Bool SAL_CALL
	isDefinitelyWritable( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
	/**
	  * Returns the fully-qualified name of the service whose instances
	  *	are manufactured if the method
	  * com::sun::star::sdbc::ResultSet::getObject is called to retrieve a
	  * value from the column.
	  *
	  * @param  column is the number of the column for that a value shall
	  *         be returned. The first column is 1, the second is 2, ...
	  *	@return the service name for column or an empty string, if no service
	  *         is applicable.
	  */
    virtual ::rtl::OUString SAL_CALL
	getColumnServiceName( sal_Int32 column )
		throw( ::com::sun::star::sdbc::SQLException,
			   ::com::sun::star::uno::RuntimeException );
};

} // namespace ucb

#endif /* !_UCBHELPER_RESULTSETMETADATA_HXX */
