|
sl@0
|
1 |
// Copyright (c) 2006-2010 Nokia Corporation and/or its subsidiary(-ies).
|
|
sl@0
|
2 |
// All rights reserved.
|
|
sl@0
|
3 |
// This component and the accompanying materials are made available
|
|
sl@0
|
4 |
// under the terms of "Eclipse Public License v1.0"
|
|
sl@0
|
5 |
// which accompanies this distribution, and is available
|
|
sl@0
|
6 |
// at the URL "http://www.eclipse.org/legal/epl-v10.html".
|
|
sl@0
|
7 |
//
|
|
sl@0
|
8 |
// Initial Contributors:
|
|
sl@0
|
9 |
// Nokia Corporation - initial contribution.
|
|
sl@0
|
10 |
//
|
|
sl@0
|
11 |
// Contributors:
|
|
sl@0
|
12 |
//
|
|
sl@0
|
13 |
// Description:
|
|
sl@0
|
14 |
//
|
|
sl@0
|
15 |
|
|
sl@0
|
16 |
#include "SqlAssert.h" //ESqlPanicInvalidObj, ESqlPanicObjExists
|
|
sl@0
|
17 |
#include "SqlDatabaseImpl.h" //CSqlDatabaseImpl
|
|
sl@0
|
18 |
#include "OstTraceDefinitions.h"
|
|
sl@0
|
19 |
#ifdef OST_TRACE_COMPILER_IN_USE
|
|
sl@0
|
20 |
#include "SqlScalarFullSelectTraces.h"
|
|
sl@0
|
21 |
#endif
|
|
sl@0
|
22 |
#include "SqlTraceDef.h"
|
|
sl@0
|
23 |
|
|
sl@0
|
24 |
/**
|
|
sl@0
|
25 |
Returns a reference to the implementation object of RSqlDatabase - CSqlDatabaseImpl.
|
|
sl@0
|
26 |
|
|
sl@0
|
27 |
@panic SqlDb 2 Create() or Open() has not previously been called on this RSqlDatabase object.
|
|
sl@0
|
28 |
|
|
sl@0
|
29 |
@internalComponent
|
|
sl@0
|
30 |
*/
|
|
sl@0
|
31 |
inline CSqlDatabaseImpl& TSqlScalarFullSelectQuery::Impl() const
|
|
sl@0
|
32 |
{
|
|
sl@0
|
33 |
__ASSERT_ALWAYS(iDatabaseImpl != NULL, __SQLPANIC(ESqlPanicInvalidObj));
|
|
sl@0
|
34 |
return *iDatabaseImpl;
|
|
sl@0
|
35 |
}
|
|
sl@0
|
36 |
|
|
sl@0
|
37 |
/**
|
|
sl@0
|
38 |
Initializes TSqlScalarFullSelectQuery data members with default values.
|
|
sl@0
|
39 |
*/
|
|
sl@0
|
40 |
EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery() :
|
|
sl@0
|
41 |
iDatabaseImpl(NULL)
|
|
sl@0
|
42 |
{
|
|
sl@0
|
43 |
}
|
|
sl@0
|
44 |
|
|
sl@0
|
45 |
/**
|
|
sl@0
|
46 |
Initializes TSqlScalarFullSelectQuery object.
|
|
sl@0
|
47 |
|
|
sl@0
|
48 |
@param aDatabase A reference to the RSqlDatabase object that represents
|
|
sl@0
|
49 |
the database on which scalar fullselect queries will be executed.
|
|
sl@0
|
50 |
*/
|
|
sl@0
|
51 |
EXPORT_C TSqlScalarFullSelectQuery::TSqlScalarFullSelectQuery(RSqlDatabase& aDatabase) :
|
|
sl@0
|
52 |
iDatabaseImpl(&aDatabase.Impl())
|
|
sl@0
|
53 |
{
|
|
sl@0
|
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));
|
|
sl@0
|
55 |
}
|
|
sl@0
|
56 |
|
|
sl@0
|
57 |
/**
|
|
sl@0
|
58 |
Initializes/reinitializes TSqlScalarFullSelectQuery object.
|
|
sl@0
|
59 |
|
|
sl@0
|
60 |
@param aDatabase A reference to the RSqlDatabase object that represents
|
|
sl@0
|
61 |
the database on which scalar fullselect queries will be executed.
|
|
sl@0
|
62 |
*/
|
|
sl@0
|
63 |
EXPORT_C void TSqlScalarFullSelectQuery::SetDatabase(RSqlDatabase& aDatabase)
|
|
sl@0
|
64 |
{
|
|
sl@0
|
65 |
iDatabaseImpl = &aDatabase.Impl();
|
|
sl@0
|
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));
|
|
sl@0
|
67 |
}
|
|
sl@0
|
68 |
|
|
sl@0
|
69 |
/**
|
|
sl@0
|
70 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
71 |
a single 32-bit integer value and returns that value.
|
|
sl@0
|
72 |
|
|
sl@0
|
73 |
@param aSqlStmt 16-bit SELECT sql query
|
|
sl@0
|
74 |
|
|
sl@0
|
75 |
@return 32-bit integer column value.
|
|
sl@0
|
76 |
|
|
sl@0
|
77 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
78 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
79 |
other system-wide error codes.
|
|
sl@0
|
80 |
*/
|
|
sl@0
|
81 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC& aSqlStmt)
|
|
sl@0
|
82 |
{
|
|
sl@0
|
83 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
|
|
sl@0
|
84 |
TInt res;
|
|
sl@0
|
85 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
86 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
|
|
sl@0
|
87 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-16;res=%d", (TUint)this, res));
|
|
sl@0
|
88 |
return res;
|
|
sl@0
|
89 |
}
|
|
sl@0
|
90 |
|
|
sl@0
|
91 |
/**
|
|
sl@0
|
92 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
93 |
a single 64-bit integer value and returns that value.
|
|
sl@0
|
94 |
|
|
sl@0
|
95 |
@param aSqlStmt 16-bit SELECT sql query
|
|
sl@0
|
96 |
|
|
sl@0
|
97 |
@return 64-bit integer column value.
|
|
sl@0
|
98 |
|
|
sl@0
|
99 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
100 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
101 |
other system-wide error codes.
|
|
sl@0
|
102 |
*/
|
|
sl@0
|
103 |
EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC& aSqlStmt)
|
|
sl@0
|
104 |
{
|
|
sl@0
|
105 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
|
|
sl@0
|
106 |
TInt64 res;
|
|
sl@0
|
107 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
108 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
|
|
sl@0
|
109 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-16;res=%lld", (TUint)this, res));
|
|
sl@0
|
110 |
return res;
|
|
sl@0
|
111 |
}
|
|
sl@0
|
112 |
|
|
sl@0
|
113 |
/**
|
|
sl@0
|
114 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
115 |
a single real value and returns that value.
|
|
sl@0
|
116 |
|
|
sl@0
|
117 |
@param aSqlStmt 16-bit SELECT sql query
|
|
sl@0
|
118 |
|
|
sl@0
|
119 |
@return Real column value.
|
|
sl@0
|
120 |
|
|
sl@0
|
121 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
122 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
123 |
other system-wide error codes.
|
|
sl@0
|
124 |
*/
|
|
sl@0
|
125 |
EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC& aSqlStmt)
|
|
sl@0
|
126 |
{
|
|
sl@0
|
127 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY16, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16;aSqlStmt=%S", (TUint)this, __SQLPRNSTR(aSqlStmt)));
|
|
sl@0
|
128 |
TReal res;
|
|
sl@0
|
129 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
130 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
|
|
sl@0
|
131 |
SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-16", (TUint)this));
|
|
sl@0
|
132 |
return res;
|
|
sl@0
|
133 |
}
|
|
sl@0
|
134 |
|
|
sl@0
|
135 |
/**
|
|
sl@0
|
136 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
137 |
a single text value and copies that value to the place refered by aDest parameter.
|
|
sl@0
|
138 |
|
|
sl@0
|
139 |
If the destination buffer is not big enough, the function will copy as much data as
|
|
sl@0
|
140 |
possible and will return positive value - the character length of the text column.
|
|
sl@0
|
141 |
|
|
sl@0
|
142 |
@param aSqlStmt 16-bit SELECT sql query
|
|
sl@0
|
143 |
@param aDest Refers to the place where the column data will be copied
|
|
sl@0
|
144 |
|
|
sl@0
|
145 |
@return KErrNone, if the function completes successfully,
|
|
sl@0
|
146 |
Positive value, The text column value length in characters, in case if the receiving buffer
|
|
sl@0
|
147 |
is not big enough.
|
|
sl@0
|
148 |
|
|
sl@0
|
149 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
150 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
151 |
other system-wide error codes.
|
|
sl@0
|
152 |
*/
|
|
sl@0
|
153 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC& aSqlStmt, TDes& aDest)
|
|
sl@0
|
154 |
{
|
|
sl@0
|
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()));
|
|
sl@0
|
156 |
TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
|
|
sl@0
|
157 |
TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
|
|
sl@0
|
158 |
aDest.SetLength(ptr.Length() / sizeof(TUint16));
|
|
sl@0
|
159 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-16;rc=%d", (TUint)this, rc));
|
|
sl@0
|
160 |
return rc;
|
|
sl@0
|
161 |
}
|
|
sl@0
|
162 |
|
|
sl@0
|
163 |
/**
|
|
sl@0
|
164 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
165 |
a single binary value and copies that value to the place refered by aDest parameter.
|
|
sl@0
|
166 |
|
|
sl@0
|
167 |
If the destination buffer is not big enough, the function will copy as much data as
|
|
sl@0
|
168 |
possible and will return positive value - the byte length of the binary column.
|
|
sl@0
|
169 |
|
|
sl@0
|
170 |
@param aSqlStmt 16-bit SELECT sql query
|
|
sl@0
|
171 |
@param aDest Refers to the place where the column data will be copied
|
|
sl@0
|
172 |
|
|
sl@0
|
173 |
@return KErrNone, if the function completes successfully,
|
|
sl@0
|
174 |
Positive value, The binary column value length in bytes, in case if the receiving buffer
|
|
sl@0
|
175 |
is not big enough.
|
|
sl@0
|
176 |
|
|
sl@0
|
177 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
178 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
179 |
other system-wide error codes.
|
|
sl@0
|
180 |
*/
|
|
sl@0
|
181 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC& aSqlStmt, TDes8& aDest)
|
|
sl@0
|
182 |
{
|
|
sl@0
|
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()));
|
|
sl@0
|
184 |
TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
|
|
sl@0
|
185 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT16, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-16;rc=%d", (TUint)this, rc));
|
|
sl@0
|
186 |
return rc;
|
|
sl@0
|
187 |
}
|
|
sl@0
|
188 |
|
|
sl@0
|
189 |
/**
|
|
sl@0
|
190 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
191 |
a single 32-bit integer value and returns that value.
|
|
sl@0
|
192 |
|
|
sl@0
|
193 |
@param aSqlStmt 8-bit SELECT sql query
|
|
sl@0
|
194 |
|
|
sl@0
|
195 |
@return 32-bit integer column value.
|
|
sl@0
|
196 |
|
|
sl@0
|
197 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
198 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
199 |
other system-wide error codes.
|
|
sl@0
|
200 |
*/
|
|
sl@0
|
201 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectIntL(const TDesC8& aSqlStmt)
|
|
sl@0
|
202 |
{
|
|
sl@0
|
203 |
__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
|
|
sl@0
|
204 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
|
|
sl@0
|
205 |
TInt res;
|
|
sl@0
|
206 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
207 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt, ptr);
|
|
sl@0
|
208 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectIntL-8;res=%d", (TUint)this, res));
|
|
sl@0
|
209 |
return res;
|
|
sl@0
|
210 |
}
|
|
sl@0
|
211 |
|
|
sl@0
|
212 |
/**
|
|
sl@0
|
213 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
214 |
a single 64-bit integer value and returns that value.
|
|
sl@0
|
215 |
|
|
sl@0
|
216 |
@param aSqlStmt 8-bit SELECT sql query
|
|
sl@0
|
217 |
|
|
sl@0
|
218 |
@return 64-bit integer column value.
|
|
sl@0
|
219 |
|
|
sl@0
|
220 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
221 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
222 |
other system-wide error codes.
|
|
sl@0
|
223 |
*/
|
|
sl@0
|
224 |
EXPORT_C TInt64 TSqlScalarFullSelectQuery::SelectInt64L(const TDesC8& aSqlStmt)
|
|
sl@0
|
225 |
{
|
|
sl@0
|
226 |
__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
|
|
sl@0
|
227 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
|
|
sl@0
|
228 |
TInt64 res;
|
|
sl@0
|
229 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
230 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlInt64, ptr);
|
|
sl@0
|
231 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTINT64L_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectInt64L-8;res=%lld", (TUint)this, res));
|
|
sl@0
|
232 |
return res;
|
|
sl@0
|
233 |
}
|
|
sl@0
|
234 |
|
|
sl@0
|
235 |
/**
|
|
sl@0
|
236 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
237 |
a single real value and returns that value.
|
|
sl@0
|
238 |
|
|
sl@0
|
239 |
@param aSqlStmt 8-bit SELECT sql query
|
|
sl@0
|
240 |
|
|
sl@0
|
241 |
@return Real column value.
|
|
sl@0
|
242 |
|
|
sl@0
|
243 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
244 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
245 |
other system-wide error codes.
|
|
sl@0
|
246 |
*/
|
|
sl@0
|
247 |
EXPORT_C TReal TSqlScalarFullSelectQuery::SelectRealL(const TDesC8& aSqlStmt)
|
|
sl@0
|
248 |
{
|
|
sl@0
|
249 |
__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
|
|
sl@0
|
250 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_ENTRY8, "Entry;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8;aSqlStmt=%s", (TUint)this, __SQLPRNSTR8(aSqlStmt, des16prnbuf)));
|
|
sl@0
|
251 |
TReal res;
|
|
sl@0
|
252 |
TPtr8 ptr(reinterpret_cast <TUint8*> (&res), sizeof(res));
|
|
sl@0
|
253 |
(void)Impl().ExecScalarFullSelectL(aSqlStmt, ESqlReal, ptr);
|
|
sl@0
|
254 |
SQL_TRACE_BORDER(OstTrace1(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTREALL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectRealL-8", (TUint)this));
|
|
sl@0
|
255 |
return res;
|
|
sl@0
|
256 |
}
|
|
sl@0
|
257 |
|
|
sl@0
|
258 |
/**
|
|
sl@0
|
259 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
260 |
a single text value and copies that value to the place refered by aDest parameter.
|
|
sl@0
|
261 |
|
|
sl@0
|
262 |
If the destination buffer is not big enough, the function will copy as much data as
|
|
sl@0
|
263 |
possible and will return positive value - the character length of the text column.
|
|
sl@0
|
264 |
|
|
sl@0
|
265 |
@param aSqlStmt 8-bit SELECT sql query
|
|
sl@0
|
266 |
@param aDest Refers to the place where the column data will be copied
|
|
sl@0
|
267 |
|
|
sl@0
|
268 |
@return KErrNone, if the function completes successfully,
|
|
sl@0
|
269 |
Positive value, The text column value length in characters, in case if the receiving buffer
|
|
sl@0
|
270 |
is not big enough.
|
|
sl@0
|
271 |
|
|
sl@0
|
272 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
273 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
274 |
other system-wide error codes.
|
|
sl@0
|
275 |
*/
|
|
sl@0
|
276 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectTextL(const TDesC8& aSqlStmt, TDes& aDest)
|
|
sl@0
|
277 |
{
|
|
sl@0
|
278 |
__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
|
|
sl@0
|
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()));
|
|
sl@0
|
280 |
TPtr8 ptr(reinterpret_cast <TUint8*> (const_cast <TUint16*> (aDest.Ptr())), aDest.MaxLength() * sizeof(TUint16));
|
|
sl@0
|
281 |
TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlText, ptr);
|
|
sl@0
|
282 |
aDest.SetLength(ptr.Length() / sizeof(TUint16));
|
|
sl@0
|
283 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTTEXTL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectTextL-8;rc=%d", (TUint)this, rc));
|
|
sl@0
|
284 |
return rc;
|
|
sl@0
|
285 |
}
|
|
sl@0
|
286 |
|
|
sl@0
|
287 |
/**
|
|
sl@0
|
288 |
Executes a SELECT query which is expected to return a single row consisting of
|
|
sl@0
|
289 |
a single binary value and copies that value to the place refered by aDest parameter.
|
|
sl@0
|
290 |
|
|
sl@0
|
291 |
If the destination buffer is not big enough, the function will copy as much data as
|
|
sl@0
|
292 |
possible and will return positive value - the character length of the text column.
|
|
sl@0
|
293 |
|
|
sl@0
|
294 |
@param aSqlStmt 8-bit SELECT sql query
|
|
sl@0
|
295 |
@param aDest Refers to the place where the column data will be copied
|
|
sl@0
|
296 |
|
|
sl@0
|
297 |
@return KErrNone, if the function completes successfully,
|
|
sl@0
|
298 |
Positive value, The binary column value length in bytes, in case if the receiving buffer
|
|
sl@0
|
299 |
is not big enough.
|
|
sl@0
|
300 |
|
|
sl@0
|
301 |
@leave KErrNotFound, If there is no record,
|
|
sl@0
|
302 |
The function may leave with database specific errors categorised as ESqlDbError and
|
|
sl@0
|
303 |
other system-wide error codes.
|
|
sl@0
|
304 |
*/
|
|
sl@0
|
305 |
EXPORT_C TInt TSqlScalarFullSelectQuery::SelectBinaryL(const TDesC8& aSqlStmt, TDes8& aDest)
|
|
sl@0
|
306 |
{
|
|
sl@0
|
307 |
__SQLTRACE_BORDERVAR(TBuf<100> des16prnbuf);
|
|
sl@0
|
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()));
|
|
sl@0
|
309 |
TInt rc = Impl().ExecScalarFullSelectL(aSqlStmt, ESqlBinary, aDest);
|
|
sl@0
|
310 |
SQL_TRACE_BORDER(OstTraceExt2(TRACE_BORDER, TSQLSCALARFULLSELECTQUERY_SELECTBINARYL_EXIT8, "Exit;0x%X;TSqlScalarFullSelectQuery::SelectBinaryL-8;rc=%d", (TUint)this, rc));
|
|
sl@0
|
311 |
return rc;
|
|
sl@0
|
312 |
}
|