sl@0: // Copyright (c) 2006-2010 Nokia Corporation and/or its subsidiary(-ies).
sl@0: // All rights reserved.
sl@0: // This component and the accompanying materials are made available
sl@0: // under the terms of "Eclipse Public License v1.0"
sl@0: // which accompanies this distribution, and is available
sl@0: // at the URL "http://www.eclipse.org/legal/epl-v10.html".
sl@0: //
sl@0: // Initial Contributors:
sl@0: // Nokia Corporation - initial contribution.
sl@0: //
sl@0: // Contributors:
sl@0: //
sl@0: // Description:
sl@0: //
sl@0: 
sl@0: #include "SqlAssert.h"			//ESqlPanicInvalidObj, ESqlPanicObjExists
sl@0: #include "SqlDatabaseImpl.h"	//CSqlDatabaseImpl
sl@0: #include "OstTraceDefinitions.h"
sl@0: #ifdef OST_TRACE_COMPILER_IN_USE
sl@0: #include "SqlScalarFullSelectTraces.h"
sl@0: #endif
sl@0: #include "SqlTraceDef.h"
sl@0: 
sl@0: /**
sl@0: Returns a reference to the implementation object of RSqlDatabase - CSqlDatabaseImpl.
sl@0: 
sl@0: @panic SqlDb 2 Create() or Open() has not previously been called on this RSqlDatabase object.
sl@0: 
sl@0: @internalComponent
sl@0: */
sl@0: inline CSqlDatabaseImpl& TSqlScalarFullSelectQuery::Impl() const
sl@0: 	{
sl@0: 	__ASSERT_ALWAYS(iDatabaseImpl != NULL, __SQLPANIC(ESqlPanicInvalidObj));
sl@0: 	return *iDatabaseImpl;	
sl@0: 	}
sl@0: 
sl@0: /**
sl@0: Initializes TSqlScalarFullSelectQuery data members with default values.
sl@0: */
sl@0: EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery() :
sl@0: 	iDatabaseImpl(NULL)
sl@0: 	{
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Initializes TSqlScalarFullSelectQuery object.
sl@0: 
sl@0: @param aDatabase	A reference to the RSqlDatabase object that represents 
sl@0:                     the database on which scalar fullselect queries will be executed.
sl@0: */
sl@0: EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery(RSqlDatabase& aDatabase) :
sl@0: 	iDatabaseImpl(&aDatabase.Impl())
sl@0: 	{
sl@0: 	SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_TSQLSCALARFULLSELECTQUERY, "0x%X;TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Initializes/reinitializes TSqlScalarFullSelectQuery object.
sl@0: 
sl@0: @param aDatabase	A reference to the RSqlDatabase object that represents 
sl@0:                     the database on which scalar fullselect queries will be executed.
sl@0: */
sl@0: EXPORT_C void TSqlScalarFullSelectQuery::SetDatabase(RSqlDatabase& aDatabase)
sl@0: 	{
sl@0: 	iDatabaseImpl = &aDatabase.Impl();
sl@0:     SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SETDATABASE, "0x%X;TSqlScalarFullSelectQuery::SetDatabase;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single 32-bit integer value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 16-bit SELECT sql query
sl@0: 
sl@0: @return 32-bit integer column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC& aSqlStmt)
sl@0: 	{
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
sl@0: 	TInt res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;res=%d", (TUint)this, res));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single 64-bit integer value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 16-bit SELECT sql query
sl@0: 
sl@0: @return 64-bit integer column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC& aSqlStmt)
sl@0: 	{
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
sl@0: 	TInt64 res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
sl@0: 	SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;res=%lld", (TUint)this, res));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single real value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 16-bit SELECT sql query
sl@0: 
sl@0: @return Real column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC& aSqlStmt)
sl@0: 	{
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
sl@0: 	TReal res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
sl@0:     SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16", (TUint)this));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single text value and copies that value to the place refered by aDest parameter.
sl@0: 
sl@0: If the destination buffer is not big enough, the function will copy as much data as 
sl@0: possible and will return positive value - the character length of the text column.
sl@0: 
sl@0: @param aSqlStmt 16-bit SELECT sql query
sl@0: @param aDest Refers to the place where the column data will be copied
sl@0: 
sl@0: @return KErrNone, if the function completes successfully,
sl@0: 		Positive value, The text column value length in characters, in case if the receiving buffer 
sl@0: 						is not big enough.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC& aSqlStmt, TDes& aDest)
sl@0: 	{
sl@0:     SQL_TRACE_BORDER(OstTraceExt5(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectTextL-16;aSqlStmt=%S;aDest.Ptr()=0x%X;aDest.Size()=%d;aDest.MaxSize()=%d", (TUint)this, __SQLPRNSTR(aSqlStmt), (TUint)aDest.Ptr(), aDest.Size(), aDest.MaxSize()));
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
sl@0: 	TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
sl@0: 	aDest.SetLength(ptr.Length() / sizeof(TUint16));
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-16;rc=%d", (TUint)this, rc));
sl@0: 	return rc;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single binary value and copies that value to the place refered by aDest parameter.
sl@0: 
sl@0: If the destination buffer is not big enough, the function will copy as much data as 
sl@0: possible and will return positive value - the byte length of the binary column.
sl@0: 
sl@0: @param aSqlStmt 16-bit SELECT sql query
sl@0: @param aDest Refers to the place where the column data will be copied
sl@0: 
sl@0: @return KErrNone, if the function completes successfully,
sl@0: 		Positive value, The binary column value length in bytes, in case if the receiving buffer 
sl@0: 						is not big enough.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC& aSqlStmt, TDes8& aDest)
sl@0: 	{
sl@0:     SQL_TRACE_BORDER(OstTraceExt5(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-16;aSqlStmt=%S;aDest.Ptr()=0x%X;aDest.Size()=%d;aDest.MaxSize()=%d", (TUint)this, __SQLPRNSTR(aSqlStmt), (TUint)aDest.Ptr(), aDest.Size(), aDest.MaxSize()));
sl@0: 	TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-16;rc=%d", (TUint)this, rc));
sl@0: 	return rc;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single 32-bit integer value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 8-bit SELECT sql query
sl@0: 
sl@0: @return 32-bit integer column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC8& aSqlStmt)
sl@0: 	{
sl@0: 	__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
sl@0: 	TInt res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;res=%d", (TUint)this, res));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single 64-bit integer value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 8-bit SELECT sql query
sl@0: 
sl@0: @return 64-bit integer column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC8& aSqlStmt)
sl@0: 	{
sl@0: 	__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
sl@0: 	SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
sl@0: 	TInt64 res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
sl@0: 	SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;res=%lld", (TUint)this, res));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single real value and returns that value.
sl@0: 
sl@0: @param aSqlStmt 8-bit SELECT sql query
sl@0: 
sl@0: @return Real column value.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC8& aSqlStmt)
sl@0: 	{
sl@0: 	__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
sl@0: 	TReal res;
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
sl@0: 	(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
sl@0:     SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8", (TUint)this));
sl@0: 	return res;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single text value and copies that value to the place refered by aDest parameter.
sl@0: 
sl@0: If the destination buffer is not big enough, the function will copy as much data as 
sl@0: possible and will return positive value - the character length of the text column.
sl@0: 
sl@0: @param aSqlStmt 8-bit SELECT sql query
sl@0: @param aDest Refers to the place where the column data will be copied
sl@0: 
sl@0: @return KErrNone, if the function completes successfully,
sl@0: 		Positive value, The text column value length in characters, in case if the receiving buffer 
sl@0: 						is not big enough.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC8& aSqlStmt, TDes& aDest)
sl@0: 	{
sl@0: 	__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
sl@0:     SQL_TRACE_BORDER(OstTraceExt5(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectTextL-8;aSqlStmt=%s;aDest.Ptr()=0x%X;aDest.Size()=%d;aDest.MaxSize()=%d", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf), (TUint)aDest.Ptr(), aDest.Size(), aDest.MaxSize()));
sl@0: 	TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
sl@0: 	TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
sl@0: 	aDest.SetLength(ptr.Length() / sizeof(TUint16));
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-8;rc=%d", (TUint)this, rc));
sl@0: 	return rc;
sl@0: 	}
sl@0: 	
sl@0: /**
sl@0: Executes a SELECT query which is expected to return a single row consisting of
sl@0: a single binary value and copies that value to the place refered by aDest parameter.
sl@0: 
sl@0: If the destination buffer is not big enough, the function will copy as much data as 
sl@0: possible and will return positive value - the character length of the text column.
sl@0: 
sl@0: @param aSqlStmt 8-bit SELECT sql query
sl@0: @param aDest Refers to the place where the column data will be copied
sl@0: 
sl@0: @return KErrNone, if the function completes successfully,
sl@0: 		Positive value, The binary column value length in bytes, in case if the receiving buffer 
sl@0: 						is not big enough.
sl@0: 
sl@0: @leave  KErrNotFound, If there is no record,
sl@0:         The function may leave with database specific errors categorised as ESqlDbError and
sl@0:   		other system-wide error codes.
sl@0: */
sl@0: EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC8& aSqlStmt, TDes8& aDest)
sl@0: 	{
sl@0: 	__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
sl@0:     SQL_TRACE_BORDER(OstTraceExt5(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-8;aSqlStmt=%s;aDest.Ptr()=0x%X;aDest.Size()=%d;aDest.MaxSize()=%d", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf), (TUint)aDest.Ptr(), aDest.Size(), aDest.MaxSize()));
sl@0: 	TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
sl@0:     SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-8;rc=%d", (TUint)this, rc));
sl@0: 	return rc;
sl@0: 	}