/*

* Copyright (c) 2002-2009 Nokia Corporation and/or its subsidiary(-ies). 

* All rights reserved.

* This component and the accompanying materials are made available

* under the terms of "Eclipse Public License v1.0"

* which accompanies this distribution, and is available

* at the URL "http://www.eclipse.org/legal/epl-v10.html".

*

* Initial Contributors:

* Nokia Corporation - initial contribution.

*

* Contributors:

*

* Description:  Abstract SQL connection class*

*/

#ifndef __MDSSQLCONNECTION_H__

#define __MDSSQLCONNECTION_H__

#include <e32base.h>

#include "mdccommon.pan"

#include "mdscommoninternal.h"

// types of columns

enum TColumnDataType

    {

    EColumnNotUsed,

    EColumnBool,

    EColumnInt32,

    EColumnUint32,

    EColumnInt64,

    EColumnReal32,

    EColumnReal64,

    EColumnTime,

    EColumnDes8,

    EColumnDes16,  // could be used as Unknown, because it checks the

                   // actual type from sqlite

    EColumnHBuf8,  // local pointer responsibility

    EColumnHBuf16, // local pointer responsibility

    EColumnNullDes8,

    EColumnNullDes16, // used when db column is null 

    //EColumnUnknown

    EColumnTItemId = EColumnUint32, // should be changed according to TItemId definition

    EColumnTDefId = EColumnUint32, // should be changed according to TDefId definition

    };

/**

* A class representing a database column.

* The column contains a type and an untyped pointer, which can

* be cast to represent various types.

*/

NONSHARABLE_CLASS(TColumn)

    {

    public:

        /** Returns column type. */

        inline TColumnDataType Type() const;

        /** Constructs a column with data type only. Use for queries. */

        inline TColumn( TColumnDataType aType = EColumnNotUsed );

        /** frees allocated memory in this column */

        inline void Free();

        // constructors

        TColumn( TInt32 aVal ) { Set( aVal ); }

        TColumn( TUint32 aVal ) { Set( aVal ); }

        TColumn( TBool aVal ) { Set( aVal ); }

        TColumn( TInt64 aVal ) { Set( aVal ); }

        TColumn( TReal32 aVal ) { Set( aVal ); }

        TColumn( TReal64 aVal ) { Set( aVal ); }

        TColumn( TTime aVal ) { Set( aVal ); }

        TColumn( const TDesC8& aVal ) { Set( aVal ); }

        TColumn( const TDesC16& aVal ) { Set( aVal ); }

        TColumn( const HBufC8* aVal ) { Set( aVal ); }

        TColumn( const HBufC16* aVal ) { Set( aVal ); }

        // data setters & getters

        inline void Set( TInt32 aVal );

        inline void Set( TUint32 aVal );

        inline void Set( TBool aVal );

        inline void Set( TInt64 aVal );

        inline void Set( TReal32 aVal );

        inline void Set( TReal64 aVal );

        inline void Set( TTime aVal );

        inline void Set( const TDesC8& aVal );

        inline void Set( const TDesC16& aVal );

        inline void Set( const HBufC8* aVal );

        inline void Set( const HBufC16* aVal );

        inline void NotUsed();

        // data getters

        inline void Get( TInt32& aValue ) const;

        inline void Get( TUint32& aValue ) const;

        inline void Get( TBool& aValue ) const;

        inline void Get( TInt64& aValue ) const;

        inline void Get( TReal32& aValue ) const;

        inline void Get( TReal64& aValue ) const;

        inline void Get( TTime& aValue ) const;

        inline void Get( TPtrC8& aValue ) const;

        inline void Get( TPtrC16& aValue ) const;

        inline TBool IsNull();

        /**

        * type of data in this column

        */

        TColumnDataType iType;

        /**

        * a structure to store multi-typed data

        */

        union TMultiTypeData

            {

            /*struct

                {

                TUint32 iLow;

                TUint32 iHigh;

                } iInt64;*/

            TInt64 iInt64;

            TReal32 iReal32;

            TReal64 iReal64;

            TInt32 iInt32;

            TUint32 iUint32;

            struct

                {

                TAny* iPtr;

                TInt iLen;

                } iText;

            };

        /**

        * multi-use data in this column

        */

        TMultiTypeData iData;

    };

/**

* A class representing a database row.

* The class describes each column type and the data in the column.

* where column data is located. The class is provided during

* query and is used when each row is read. Note that the

* buffer class MAY be modified by the user during the query.

* The same class is also used when replacing wildcards with

* variable data.

*/

class RRowData

    {

    public:

        /**

        * constructor

        */

        inline RRowData();

        /** Closes all the resources used by this object */

        inline void Close();

        /** frees allocated memory in this row */

        inline void Free();

        /** number of columns or variables */

        inline TInt Size() const;

        /** returns column by index */

        inline TColumn& Column( TInt aIndex );

        /** returns column by index */

        inline const TColumn& Column( TInt aIndex ) const;

        /** Appends a new column in row */

        inline TColumn& AppendL( const TColumn& aColumn );

        /** Resets the row */

        inline void Reset();

		/** Copy all columns */

		void AppendColumnTypesL( RRowData& aColumnTypeRow );

		/** Receive space to row */

		void ReserveL( TInt aColumnCount );

    protected:

        /** The array of columns */

        RArray<TColumn> iColumns;

    };

#include "mdssqlrow.inl" // inline methods

#endif	// __MDSSQLCONNECTION_H__

// End of File