--- /dev/null	Thu Jan 01 00:00:00 1970 +0000
+++ b/inc/mdssqlrow.h	Mon Jan 18 20:34:07 2010 +0200
@@ -0,0 +1,220 @@
+/*
+* 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