1.1 --- /dev/null Thu Jan 01 00:00:00 1970 +0000
1.2 +++ b/os/persistentdata/persistentstorage/sql/SRC/Client/SqlScalarFullSelect.cpp Fri Jun 15 03:10:57 2012 +0200
1.3 @@ -0,0 +1,312 @@
1.4 +// Copyright (c) 2006-2010 Nokia Corporation and/or its subsidiary(-ies).
1.5 +// All rights reserved.
1.6 +// This component and the accompanying materials are made available
1.7 +// under the terms of "Eclipse Public License v1.0"
1.8 +// which accompanies this distribution, and is available
1.9 +// at the URL "http://www.eclipse.org/legal/epl-v10.html".
1.10 +//
1.11 +// Initial Contributors:
1.12 +// Nokia Corporation - initial contribution.
1.13 +//
1.14 +// Contributors:
1.15 +//
1.16 +// Description:
1.17 +//
1.18 +
1.19 +#include "SqlAssert.h" //ESqlPanicInvalidObj, ESqlPanicObjExists
1.20 +#include "SqlDatabaseImpl.h" //CSqlDatabaseImpl
1.21 +#include "OstTraceDefinitions.h"
1.22 +#ifdef OST_TRACE_COMPILER_IN_USE
1.23 +#include "SqlScalarFullSelectTraces.h"
1.24 +#endif
1.25 +#include "SqlTraceDef.h"
1.26 +
1.27 +/**
1.28 +Returns a reference to the implementation object of RSqlDatabase - CSqlDatabaseImpl.
1.29 +
1.30 +@panic SqlDb 2 Create() or Open() has not previously been called on this RSqlDatabase object.
1.31 +
1.32 +@internalComponent
1.33 +*/
1.34 +inline CSqlDatabaseImpl& TSqlScalarFullSelectQuery::Impl() const
1.35 + {
1.36 + __ASSERT_ALWAYS(iDatabaseImpl != NULL, __SQLPANIC(ESqlPanicInvalidObj));
1.37 + return *iDatabaseImpl;
1.38 + }
1.39 +
1.40 +/**
1.41 +Initializes TSqlScalarFullSelectQuery data members with default values.
1.42 +*/
1.43 +EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery() :
1.44 + iDatabaseImpl(NULL)
1.45 + {
1.46 + }
1.47 +
1.48 +/**
1.49 +Initializes TSqlScalarFullSelectQuery object.
1.50 +
1.51 +@param aDatabase A reference to the RSqlDatabase object that represents
1.52 + the database on which scalar fullselect queries will be executed.
1.53 +*/
1.54 +EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery(RSqlDatabase& aDatabase) :
1.55 + iDatabaseImpl(&aDatabase.Impl())
1.56 + {
1.57 + SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_TSQLSCALARFULLSELECTQUERY, "0x%X;TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
1.58 + }
1.59 +
1.60 +/**
1.61 +Initializes/reinitializes TSqlScalarFullSelectQuery object.
1.62 +
1.63 +@param aDatabase A reference to the RSqlDatabase object that represents
1.64 + the database on which scalar fullselect queries will be executed.
1.65 +*/
1.66 +EXPORT_C void TSqlScalarFullSelectQuery::SetDatabase(RSqlDatabase& aDatabase)
1.67 + {
1.68 + iDatabaseImpl = &aDatabase.Impl();
1.69 + SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SETDATABASE, "0x%X;TSqlScalarFullSelectQuery::SetDatabase;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
1.70 + }
1.71 +
1.72 +/**
1.73 +Executes a SELECT query which is expected to return a single row consisting of
1.74 +a single 32-bit integer value and returns that value.
1.75 +
1.76 +@param aSqlStmt 16-bit SELECT sql query
1.77 +
1.78 +@return 32-bit integer column value.
1.79 +
1.80 +@leave KErrNotFound, If there is no record,
1.81 + The function may leave with database specific errors categorised as ESqlDbError and
1.82 + other system-wide error codes.
1.83 +*/
1.84 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC& aSqlStmt)
1.85 + {
1.86 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
1.87 + TInt res;
1.88 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.89 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
1.90 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;res=%d", (TUint)this, res));
1.91 + return res;
1.92 + }
1.93 +
1.94 +/**
1.95 +Executes a SELECT query which is expected to return a single row consisting of
1.96 +a single 64-bit integer value and returns that value.
1.97 +
1.98 +@param aSqlStmt 16-bit SELECT sql query
1.99 +
1.100 +@return 64-bit integer column value.
1.101 +
1.102 +@leave KErrNotFound, If there is no record,
1.103 + The function may leave with database specific errors categorised as ESqlDbError and
1.104 + other system-wide error codes.
1.105 +*/
1.106 +EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC& aSqlStmt)
1.107 + {
1.108 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
1.109 + TInt64 res;
1.110 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.111 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
1.112 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;res=%lld", (TUint)this, res));
1.113 + return res;
1.114 + }
1.115 +
1.116 +/**
1.117 +Executes a SELECT query which is expected to return a single row consisting of
1.118 +a single real value and returns that value.
1.119 +
1.120 +@param aSqlStmt 16-bit SELECT sql query
1.121 +
1.122 +@return Real column value.
1.123 +
1.124 +@leave KErrNotFound, If there is no record,
1.125 + The function may leave with database specific errors categorised as ESqlDbError and
1.126 + other system-wide error codes.
1.127 +*/
1.128 +EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC& aSqlStmt)
1.129 + {
1.130 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
1.131 + TReal res;
1.132 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.133 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
1.134 + SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16", (TUint)this));
1.135 + return res;
1.136 + }
1.137 +
1.138 +/**
1.139 +Executes a SELECT query which is expected to return a single row consisting of
1.140 +a single text value and copies that value to the place refered by aDest parameter.
1.141 +
1.142 +If the destination buffer is not big enough, the function will copy as much data as
1.143 +possible and will return positive value - the character length of the text column.
1.144 +
1.145 +@param aSqlStmt 16-bit SELECT sql query
1.146 +@param aDest Refers to the place where the column data will be copied
1.147 +
1.148 +@return KErrNone, if the function completes successfully,
1.149 + Positive value, The text column value length in characters, in case if the receiving buffer
1.150 + is not big enough.
1.151 +
1.152 +@leave KErrNotFound, If there is no record,
1.153 + The function may leave with database specific errors categorised as ESqlDbError and
1.154 + other system-wide error codes.
1.155 +*/
1.156 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC& aSqlStmt, TDes& aDest)
1.157 + {
1.158 + 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()));
1.159 + TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
1.160 + TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
1.161 + aDest.SetLength(ptr.Length() / sizeof(TUint16));
1.162 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-16;rc=%d", (TUint)this, rc));
1.163 + return rc;
1.164 + }
1.165 +
1.166 +/**
1.167 +Executes a SELECT query which is expected to return a single row consisting of
1.168 +a single binary value and copies that value to the place refered by aDest parameter.
1.169 +
1.170 +If the destination buffer is not big enough, the function will copy as much data as
1.171 +possible and will return positive value - the byte length of the binary column.
1.172 +
1.173 +@param aSqlStmt 16-bit SELECT sql query
1.174 +@param aDest Refers to the place where the column data will be copied
1.175 +
1.176 +@return KErrNone, if the function completes successfully,
1.177 + Positive value, The binary column value length in bytes, in case if the receiving buffer
1.178 + is not big enough.
1.179 +
1.180 +@leave KErrNotFound, If there is no record,
1.181 + The function may leave with database specific errors categorised as ESqlDbError and
1.182 + other system-wide error codes.
1.183 +*/
1.184 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC& aSqlStmt, TDes8& aDest)
1.185 + {
1.186 + 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()));
1.187 + TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
1.188 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-16;rc=%d", (TUint)this, rc));
1.189 + return rc;
1.190 + }
1.191 +
1.192 +/**
1.193 +Executes a SELECT query which is expected to return a single row consisting of
1.194 +a single 32-bit integer value and returns that value.
1.195 +
1.196 +@param aSqlStmt 8-bit SELECT sql query
1.197 +
1.198 +@return 32-bit integer column value.
1.199 +
1.200 +@leave KErrNotFound, If there is no record,
1.201 + The function may leave with database specific errors categorised as ESqlDbError and
1.202 + other system-wide error codes.
1.203 +*/
1.204 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC8& aSqlStmt)
1.205 + {
1.206 + __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
1.207 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
1.208 + TInt res;
1.209 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.210 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
1.211 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;res=%d", (TUint)this, res));
1.212 + return res;
1.213 + }
1.214 +
1.215 +/**
1.216 +Executes a SELECT query which is expected to return a single row consisting of
1.217 +a single 64-bit integer value and returns that value.
1.218 +
1.219 +@param aSqlStmt 8-bit SELECT sql query
1.220 +
1.221 +@return 64-bit integer column value.
1.222 +
1.223 +@leave KErrNotFound, If there is no record,
1.224 + The function may leave with database specific errors categorised as ESqlDbError and
1.225 + other system-wide error codes.
1.226 +*/
1.227 +EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC8& aSqlStmt)
1.228 + {
1.229 + __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
1.230 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
1.231 + TInt64 res;
1.232 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.233 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
1.234 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;res=%lld", (TUint)this, res));
1.235 + return res;
1.236 + }
1.237 +
1.238 +/**
1.239 +Executes a SELECT query which is expected to return a single row consisting of
1.240 +a single real value and returns that value.
1.241 +
1.242 +@param aSqlStmt 8-bit SELECT sql query
1.243 +
1.244 +@return Real column value.
1.245 +
1.246 +@leave KErrNotFound, If there is no record,
1.247 + The function may leave with database specific errors categorised as ESqlDbError and
1.248 + other system-wide error codes.
1.249 +*/
1.250 +EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC8& aSqlStmt)
1.251 + {
1.252 + __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
1.253 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
1.254 + TReal res;
1.255 + TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
1.256 + (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
1.257 + SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8", (TUint)this));
1.258 + return res;
1.259 + }
1.260 +
1.261 +/**
1.262 +Executes a SELECT query which is expected to return a single row consisting of
1.263 +a single text value and copies that value to the place refered by aDest parameter.
1.264 +
1.265 +If the destination buffer is not big enough, the function will copy as much data as
1.266 +possible and will return positive value - the character length of the text column.
1.267 +
1.268 +@param aSqlStmt 8-bit SELECT sql query
1.269 +@param aDest Refers to the place where the column data will be copied
1.270 +
1.271 +@return KErrNone, if the function completes successfully,
1.272 + Positive value, The text column value length in characters, in case if the receiving buffer
1.273 + is not big enough.
1.274 +
1.275 +@leave KErrNotFound, If there is no record,
1.276 + The function may leave with database specific errors categorised as ESqlDbError and
1.277 + other system-wide error codes.
1.278 +*/
1.279 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC8& aSqlStmt, TDes& aDest)
1.280 + {
1.281 + __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
1.282 + 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()));
1.283 + TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
1.284 + TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
1.285 + aDest.SetLength(ptr.Length() / sizeof(TUint16));
1.286 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-8;rc=%d", (TUint)this, rc));
1.287 + return rc;
1.288 + }
1.289 +
1.290 +/**
1.291 +Executes a SELECT query which is expected to return a single row consisting of
1.292 +a single binary value and copies that value to the place refered by aDest parameter.
1.293 +
1.294 +If the destination buffer is not big enough, the function will copy as much data as
1.295 +possible and will return positive value - the character length of the text column.
1.296 +
1.297 +@param aSqlStmt 8-bit SELECT sql query
1.298 +@param aDest Refers to the place where the column data will be copied
1.299 +
1.300 +@return KErrNone, if the function completes successfully,
1.301 + Positive value, The binary column value length in bytes, in case if the receiving buffer
1.302 + is not big enough.
1.303 +
1.304 +@leave KErrNotFound, If there is no record,
1.305 + The function may leave with database specific errors categorised as ESqlDbError and
1.306 + other system-wide error codes.
1.307 +*/
1.308 +EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC8& aSqlStmt, TDes8& aDest)
1.309 + {
1.310 + __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
1.311 + 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()));
1.312 + TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
1.313 + SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-8;rc=%d", (TUint)this, rc));
1.314 + return rc;
1.315 + }