1 // Copyright (c) 2006-2010 Nokia Corporation and/or its subsidiary(-ies).
2 // All rights reserved.
3 // This component and the accompanying materials are made available
4 // under the terms of "Eclipse Public License v1.0"
5 // which accompanies this distribution, and is available
6 // at the URL "http://www.eclipse.org/legal/epl-v10.html".
8 // Initial Contributors:
9 // Nokia Corporation - initial contribution.
16 #include "SqlAssert.h" //ESqlPanicInvalidObj, ESqlPanicObjExists
17 #include "SqlDatabaseImpl.h" //CSqlDatabaseImpl
18 #include "OstTraceDefinitions.h"
19 #ifdef OST_TRACE_COMPILER_IN_USE
20 #include "SqlScalarFullSelectTraces.h"
22 #include "SqlTraceDef.h"
25 Returns a reference to the implementation object of RSqlDatabase - CSqlDatabaseImpl.
27 @panic SqlDb 2 Create() or Open() has not previously been called on this RSqlDatabase object.
31 inline CSqlDatabaseImpl& TSqlScalarFullSelectQuery::Impl() const
33 __ASSERT_ALWAYS(iDatabaseImpl != NULL, __SQLPANIC(ESqlPanicInvalidObj));
34 return *iDatabaseImpl;
38 Initializes TSqlScalarFullSelectQuery data members with default values.
40 EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery() :
46 Initializes TSqlScalarFullSelectQuery object.
48 @param aDatabase A reference to the RSqlDatabase object that represents
49 the database on which scalar fullselect queries will be executed.
51 EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery(RSqlDatabase& aDatabase) :
52 iDatabaseImpl(&aDatabase.Impl())
54 SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_TSQLSCALARFULLSELECTQUERY, "0x%X;TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
58 Initializes/reinitializes TSqlScalarFullSelectQuery object.
60 @param aDatabase A reference to the RSqlDatabase object that represents
61 the database on which scalar fullselect queries will be executed.
63 EXPORT_C void TSqlScalarFullSelectQuery::SetDatabase(RSqlDatabase& aDatabase)
65 iDatabaseImpl = &aDatabase.Impl();
66 SQL_TRACE_BORDER(OstTraceExt3(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SETDATABASE, "0x%X;TSqlScalarFullSelectQuery::SetDatabase;aDatabase=0x%X;iDatabaseImpl=0x%X", (TUint)this, (TUint)&aDatabase, (TUint)iDatabaseImpl));
70 Executes a SELECT query which is expected to return a single row consisting of
71 a single 32-bit integer value and returns that value.
73 @param aSqlStmt 16-bit SELECT sql query
75 @return 32-bit integer column value.
77 @leave KErrNotFound, If there is no record,
78 The function may leave with database specific errors categorised as ESqlDbError and
79 other system-wide error codes.
81 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC& aSqlStmt)
83 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
85 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
86 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
87 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;res=%d", (TUint)this, res));
92 Executes a SELECT query which is expected to return a single row consisting of
93 a single 64-bit integer value and returns that value.
95 @param aSqlStmt 16-bit SELECT sql query
97 @return 64-bit integer column value.
99 @leave KErrNotFound, If there is no record,
100 The function may leave with database specific errors categorised as ESqlDbError and
101 other system-wide error codes.
103 EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC& aSqlStmt)
105 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
107 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
108 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
109 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;res=%lld", (TUint)this, res));
114 Executes a SELECT query which is expected to return a single row consisting of
115 a single real value and returns that value.
117 @param aSqlStmt 16-bit SELECT sql query
119 @return Real column value.
121 @leave KErrNotFound, If there is no record,
122 The function may leave with database specific errors categorised as ESqlDbError and
123 other system-wide error codes.
125 EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC& aSqlStmt)
127 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
129 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
130 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
131 SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16", (TUint)this));
136 Executes a SELECT query which is expected to return a single row consisting of
137 a single text value and copies that value to the place refered by aDest parameter.
139 If the destination buffer is not big enough, the function will copy as much data as
140 possible and will return positive value - the character length of the text column.
142 @param aSqlStmt 16-bit SELECT sql query
143 @param aDest Refers to the place where the column data will be copied
145 @return KErrNone, if the function completes successfully,
146 Positive value, The text column value length in characters, in case if the receiving buffer
149 @leave KErrNotFound, If there is no record,
150 The function may leave with database specific errors categorised as ESqlDbError and
151 other system-wide error codes.
153 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC& aSqlStmt, TDes& aDest)
155 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()));
156 TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
157 TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
158 aDest.SetLength(ptr.Length() / sizeof(TUint16));
159 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-16;rc=%d", (TUint)this, rc));
164 Executes a SELECT query which is expected to return a single row consisting of
165 a single binary value and copies that value to the place refered by aDest parameter.
167 If the destination buffer is not big enough, the function will copy as much data as
168 possible and will return positive value - the byte length of the binary column.
170 @param aSqlStmt 16-bit SELECT sql query
171 @param aDest Refers to the place where the column data will be copied
173 @return KErrNone, if the function completes successfully,
174 Positive value, The binary column value length in bytes, in case if the receiving buffer
177 @leave KErrNotFound, If there is no record,
178 The function may leave with database specific errors categorised as ESqlDbError and
179 other system-wide error codes.
181 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC& aSqlStmt, TDes8& aDest)
183 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()));
184 TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
185 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-16;rc=%d", (TUint)this, rc));
190 Executes a SELECT query which is expected to return a single row consisting of
191 a single 32-bit integer value and returns that value.
193 @param aSqlStmt 8-bit SELECT sql query
195 @return 32-bit integer column value.
197 @leave KErrNotFound, If there is no record,
198 The function may leave with database specific errors categorised as ESqlDbError and
199 other system-wide error codes.
201 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC8& aSqlStmt)
203 __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
204 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
206 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
207 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
208 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;res=%d", (TUint)this, res));
213 Executes a SELECT query which is expected to return a single row consisting of
214 a single 64-bit integer value and returns that value.
216 @param aSqlStmt 8-bit SELECT sql query
218 @return 64-bit integer column value.
220 @leave KErrNotFound, If there is no record,
221 The function may leave with database specific errors categorised as ESqlDbError and
222 other system-wide error codes.
224 EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC8& aSqlStmt)
226 __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
227 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
229 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
230 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
231 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;res=%lld", (TUint)this, res));
236 Executes a SELECT query which is expected to return a single row consisting of
237 a single real value and returns that value.
239 @param aSqlStmt 8-bit SELECT sql query
241 @return Real column value.
243 @leave KErrNotFound, If there is no record,
244 The function may leave with database specific errors categorised as ESqlDbError and
245 other system-wide error codes.
247 EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC8& aSqlStmt)
249 __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
250 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
252 TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
253 (void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
254 SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8", (TUint)this));
259 Executes a SELECT query which is expected to return a single row consisting of
260 a single text value and copies that value to the place refered by aDest parameter.
262 If the destination buffer is not big enough, the function will copy as much data as
263 possible and will return positive value - the character length of the text column.
265 @param aSqlStmt 8-bit SELECT sql query
266 @param aDest Refers to the place where the column data will be copied
268 @return KErrNone, if the function completes successfully,
269 Positive value, The text column value length in characters, in case if the receiving buffer
272 @leave KErrNotFound, If there is no record,
273 The function may leave with database specific errors categorised as ESqlDbError and
274 other system-wide error codes.
276 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC8& aSqlStmt, TDes& aDest)
278 __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
279 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()));
280 TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
281 TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
282 aDest.SetLength(ptr.Length() / sizeof(TUint16));
283 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-8;rc=%d", (TUint)this, rc));
288 Executes a SELECT query which is expected to return a single row consisting of
289 a single binary value and copies that value to the place refered by aDest parameter.
291 If the destination buffer is not big enough, the function will copy as much data as
292 possible and will return positive value - the character length of the text column.
294 @param aSqlStmt 8-bit SELECT sql query
295 @param aDest Refers to the place where the column data will be copied
297 @return KErrNone, if the function completes successfully,
298 Positive value, The binary column value length in bytes, in case if the receiving buffer
301 @leave KErrNotFound, If there is no record,
302 The function may leave with database specific errors categorised as ESqlDbError and
303 other system-wide error codes.
305 EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC8& aSqlStmt, TDes8& aDest)
307 __SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
308 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()));
309 TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
310 SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-8;rc=%d", (TUint)this, rc));