/*+
−
* 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+
−